Standard Report - Payroll Journal

Report Description

This report shows all payroll details by employees and can be useful for checking accuracy while closing out payroll.

Payroll_Journal.png

 

 

Parameters

Parameter Name

Options

Explanation

Branch

All available branches

Check’s Branch

Date Type

Accounting Period Date, Check Date

Filters results by payment batch's accounting period date or check date

Start Date

 

 

End Date

 

 

SSN

 

Filters results by Social Security Number.

Bank

All available Bank name present in the Payment Bank

Filters results for the banks selected

Group By

Branch, None

When grouped by Branch, the report groups by Branch; when grouped by None, the report is not grouped by anything.

Show Summary

True/False

IF parameter Show summary = ‘False’ is selected, it shows data per Check.

IF parameter Show summary = ‘True’ is selected, it shows data per Employee.

 

 

Report Fields

Field Name

Explanation

Affiliate

Supplier Name.

Branch

Check Branch.

Payee Name

Employee name associated with the check

Ck.#

Check Number.

Will be visible only when parameter Show summary = ‘False’ is selected.

If CalcNet is not equal to the Net Amount from payment check, then * is displayed in front of the check number .(E.g. *24223 where 24223 is the check number)

Formula: CalcNet = Gross Amount – (Federal Taxes + FICA + MED EE + State Taxes + Other Taxes + Garnishments + Health Insurances + Other Adjustments + CPPEE + EIEE)

Ck.Date

Check Date.

Will be visible only when parameter Show summary = ‘False’ is selected.

Gross Amn't

Gross Amount from Payment Check.

IF parameter Show summary = ‘False’ is selected, it shows Gross amount per Check.

IF parameter Show summary = ‘True’ is selected, it shows sum of Gross amount per Employee.

Fed'l Taxes

Federal Taxes from Payment Check.

IF parameter Show summary = ‘False’ is selected, it shows Federal Taxes per Check.

IF parameter Show summary = ‘True’ is selected, it shows sum of Federal Taxes per Employee.

*For USA, it is known as Federal Income Tax, and For Canada it is Federal Withholding Tax.

FICA

FICA EE from Payment Check.

IF parameter Show summary = ‘False’ is selected, it shows FICA EE per Check.

IF parameter Show summary = ‘True’ is selected, it shows sum of FICA EE per Employee.

*EE stands for Employee

MED

MED EE from Payment Check.

IF parameter Show summary = ‘False’ is selected, it shows total MED EE per Check.

IF parameter Show summary = ‘True’ is selected, it shows total MED EE per Employee.

State Taxes

State Taxes from Payment Check.

IF parameter Show summary = ‘False’ is selected, it shows total State Taxes per Check.

IF parameter Show summary = ‘True’ is selected, it shows total State Taxes per Employee.

Other Taxes

In Case of USA, Total Other Taxes (Excluding Federal Taxes, FICA EE, MED EE, State Taxes) from Payment Check.

In Case of Canada, Total Other Taxes (Excluding Federal Withholding Tax, CPP EE, EI EE) from Payment Check.

IF parameter Show summary = ‘False’ is selected, it shows total Other Taxes per Check.

IF parameter Show summary = ‘True’ is selected, it shows total Other Taxes per Employee.

Garn.

Total Deduction Amount of the check for the Deduction Category having word “Garn” in it.

IF parameter Show summary = ‘False’ is selected, it shows total Garnishments per Check.

IF parameter Show summary = ‘True’ is selected, it shows total Garnishments per Employee.

Health Insur.

Total Deduction Amount of the check for the Deduction Category having word “HealthIns” in it or having Is Healthcare checked in the setup.

IF parameter Show summary = ‘False’ is selected, it shows total Health Insurances per Check.

IF parameter Show summary = ‘True’ is selected, it shows total Health Insurances per Employee.

Other

Total Deduction Amount (Excluding Garnishments and Health Insurances) from the check.

IF parameter Show summary = ‘False’ is selected, it shows total Other Deductions per Check.

IF parameter Show summary = ‘True’ is selected, it shows total Other Deductions per Employee.

Net Check

Net amount from Payment check.

IF parameter Show summary = ‘False’ is selected, it shows total Net amount per Check.

IF parameter Show summary = ‘True’ is selected, it shows total Net amount per Employee.

DD

Displays Y if the check is a Direct deposit, else displays N.

Ck.Status

Check Status of the check 

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share