Standard Report - Payroll Journal

Overview

Updated 07/14/2021

Report Description

This report shows all payroll details by employees 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
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 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 + 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 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

Back to Top