Submit a ticket

Standard Report - Payroll Journal

Updated on Follow
0 out of 0 found this helpful

Report Description

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

PayrollJournal.png

 

 

 

 

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

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 


 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.