Standard Report - Payroll Journal_CA

Report Description

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

Parameters

Parameter Name	Options	Explanation
Branch	All available branches	Check’s Branch
Date Type	Accounting Period Date, Check Date	Check’s Accounting Period or Check Date.
Start Date
End Date
SIN		Filters results by Social Insurance 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 present in 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 + Other Taxes + Garnishments + Health Insurances + Other Adjustments + CPPEE + EIEE + PPIPEE + ProvTaxes)
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.
Prov. Taxes	Provincial Taxes from Payment Check. IF parameter Show summary = ‘False’ is selected, it shows provincial taxes per Check. IF parameter Show summary = ‘True’ is selected, it shows sum of total provincial taxes per Employee.
EI	EI EE from Payment Check. IF parameter Show summary = ‘False’ is selected, it shows total EI EE per Check. IF parameter Show summary = ‘True’ is selected, it shows total EI EE per Employee.
CPP	CPP EE and QUEBEC PENSION PLAN EE from Payment Check. IF parameter Show summary = ‘False’ is selected, it shows total CPP EE and QUEBEC PENSION PLAN EE per Check. IF parameter Show summary = ‘True’ is selected, it shows total CPP EE and QUEBEC PENSION PLAN EE per Employee.
PPIP	CANADIAN PPIP EMPLOYEE from Payment Check IF parameter Show summary = ‘False’ is selected, it shows total CANADIAN PPIP EMPLOYEE per Check. IF parameter Show summary = ‘True’ is selected, it shows total CANADIAN PPIP EMPLOYEE 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, Prov.Taxes, CPP EE, EI EE, PPIP ) 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 Deductions present for the Deduction Type “Garnishment” from Payment Check. 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 Deductions present for the Health related Deduction Types having property IsHelathCare= 1. 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 Deductions (Excluding Garnishments and Health Insurances) from Payment 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