Payroll Verification Report Samples

Tip:  To see instructions for running the reports shown below, see the Payroll Verification Reports Instructions.

Fields and Descriptions for Payroll Verification Reports

1. Compare Employee Totals to Employee Quarterly Totals:

1. • To see field descriptions, click More.

      

     Tip:  This report compares the Employee Totals file (EMPTOTAL) to the Employee Quarterly Totals file (EMPQTR) and prints any differences in Gross Pay, withholding, retirement, and earnings.

     Payroll Verification Report Fields Compare Employee Totals to Employee Quarterly Totals Tip:  To see more information about a field, click the hyperlink for the field name.
     Emp#	Employee Number
     Calculation	Lists any of the following field names that show a discrepancy between the Employee Totals and Employee Quarterly Totals file for an employee: Gross Pay Earnings Total FICA Earnings = FICA Earnings Total - Regular + FICA Earnings Total - Medicare Federally Taxable Earnings Total State Taxable Earnings Total FICA Withholding = FICA Withholding Amount Total - Regular + FICA Withholding Amount Total - Medicare Federal Tax Withholding Amount Total State Tax Withholding Amount Total Retirement Withholding Amount Total
     Emp Totals	Above field values from the Employee Totals file (EMPTOTAL)
     Emp Qtrly	Above field values from the Employee Quarterly Totals file (EMPQTR)

      

   • To see the report sample, click More.

      

     Selection Parameters for this Report Sample:
     Start at Selection Number = 1	Continue through Selection Number = 1
     Check Date Range = all	Page Width = 132 Columns

      

     

      

     ---

      

2. Compare Employee Totals to Check History:

1. • To see field descriptions, click More.

      

     Tip:  This report compares the Employee Totals file to the Pay Check History file (PAYHIST) and prints any differences in Gross Pay, withholding, and earnings.

     Payroll Verification Report Fields Compare Employee Totals to Check History Tip:  To see more information about a field, click the hyperlink for the field name.
     Emp #	Employee Number
     Calculation	Lists any of the following field names that show a discrepancy between the Employee Totals and Pay Check History file for an employee: Gross Pay Earnings Total FICA Earnings = FICA Earnings Total - Regular + FICA Earnings Total - Medicare Federally Taxable Earnings Total State Taxable Earnings Total FICA Withholding = FICA Withholding Amount Total - Regular + FICA Withholding Amount Total - Medicare Federal Tax Withholding Amount Total State Tax Withholding Amount Total Retirement Withholding Amount Total
     Emp Totals	Above field values from the Employee Totals file (EMPTOTAL)
     Chk History	Above field values from the Pay Check History file (PAYHIST)

      

   • To see the report sample, click More.

      

     Selection Parameters for this Report Sample:
     Start at Selection Number = 2	Continue through Selection Number = 2
     Check Date Range = all	Page Width = 132 Columns

      

     

      

     ---

      

3. Compare Calc'd FICA W/H with FICA W/H on Employee Totals:

1. • To see field descriptions, click More.

      

     Tip:  This report recalculates the FICA withholding for each employee and prints any discrepancies with the actual FICA withheld in the Employee Totals file.

     Payroll Verification Report Fields Compare Calc'd FICA W/H with FICA W/H on Employee Totals Tip:  To see more information about a field, click the hyperlink for the field name.
     Emp #	Employee Number
     Total Earnings YTD	Gross Pay Earnings Total
     FICA Earnings YTD	FICA Earnings YTD = FICA Earnings Total - Regular & FICA Earnings Total - Medicare
     FICA W/H YTD	FICA W/H YTD = FICA Withholding Amount Total - Regular & FICA Withholding Amount Total - Medicare
     Calc'd FICA W/H	Calc'd FICA W/H = Calculated FICA Withholding Amount Total - Regular & FICA Withholding Amount Total - Medicare
     Variance	Difference between Employee Totals FICA and Calculated FICA.

      

   • To see the report sample, click More.

      

     Selection Parameters for this Report Sample:
     Start at Selection Number = 3	Continue through Selection Number = 3
     Check Date Range = all	Page Width = 132 Columns

      

     

      

     ---

      

4. Compare Calc'd FICA W/H with FICA W/H on Check History:

   • To see field descriptions, click More.

      

     Tip:  This report recalculates the FICA withholding for each employee check in history and prints any discrepancies with the actual FICA withheld in the Pay Check History file (PAYHIST).

     Payroll Verification Report Fields Compare Calc'd FICA W/H with FICA W/H on Check History Tip:  To see more information about a field, click the hyperlink for the field name.
     Emp #	Employee Number
     Check #	Check Number
     FC	Employee FICA Code
     Gross Pay	Gross Pay Earnings Total
     FICA Earnings	FICA Earnings = FICA Earnings Total - Regular & FICA Earnings Total - Medicare
     FICA W/H	FICA W/H = FICA Withholding Amount Total - Regular & FICA Withholding Amount Total - Medicare
     Calc'd FICA W/H	Calc'd FICA W/H = Calculated FICA Withholding Amount Total - Regular & FICA Withholding Amount Total - Medicare
     Variance	Difference between Check History FICA and Calculated FICA

      

   • To see the report sample, click More.

      

     Selection Parameters for this Report Sample:
     Start at Selection Number = 4	Continue through Selection Number = 4
     Check Date Range = all	Page Width = 132 Columns

      

      

     ---

      

5. Accumulate Totals for Employee Totals & Quarterly Files:

1. • To see field descriptions, click More.

      

     Tip:  This report accumulates and prints totals from the Employee Totals file and the Employee Quarterly file for regular earnings and time, overtime earnings and time, and other earnings amounts.

     Payroll Verification Report Fields Accumulate Totals for Employee Totals & Quarterly Files Tip:  To see more information about a field, click the hyperlink for the field name.
     Regular Hours/Days YTD	Regular Time Total Year-to-Date
     Overtime Hours/Days YTD	Overtime Time Total Year-to-Date
     Regular Earnings YTD	Regular Earnings Total Year-to-Date
     Overtime Earnings YTD	Overtime Earnings Total Year-to-Date
     Contract Earnings MTD	Contract Earnings Total Month-to-Date
     Contract Earnings QTD	Contract Earnings Total Quarter-to-Date
     Contract Earnings YTD	Contract Earnings Total Year-to-Date
     Total Earnings MTD	Gross Pay Earnings Total Month-to-Date
     Total Earnings QTD	Gross Pay Earnings Total Quarter-to-Date
     Total Earnings YTD	Gross Pay Earnings Total Year-to-Date
     Federal W/H YTD	Federal Tax Withholding Amount Total Year-to-Date
     Regular FICA W/H YTD	FICA Withholding Amount Total - Regular, Year-to-Date
     Medicare FICA W/H YTD	FICA Withholding Amount Total - Medicare, Year-to-Date
     State W/H YTD	State Tax Withholding Amount Total Year-to-Date
     Retirement W/H MTD	Retirement Deduction Withholding Amount Total Month-to-Date
     Retirement W/H YTD	Retirement Deduction Withholding Amount Total Year-to-Date
     Hours MTD	Hours Month-to-Date = Regular Time Total + Overtime Time Total
     Fiscal Earnings MTD	Gross Pay Earnings Total Month-to-Date (from Employee Totals file)
     Fiscal Earnings QTD	Gross Pay Earnings Total Quarter-to-Date (from Employee Totals file)
     Fiscal Earnings YTD	Gross Pay Earnings Total Year-to-Date (from Employee Totals file)

      

   • To see the report sample, click More.

      

     Selection Parameters for this Report Sample:
     Start at Selection Number = 5	Continue through Selection Number = 5
     Check Date Range = all	Page Width = 132 Columns

      

     

      

     ---

      

6. Accumulate Totals for a Range of Dates in Check History:

1. • To see field descriptions, click More.

      

     Tip:  This report accumulates and prints totals from the Pay Check History file for Gross Pay and withholding amounts.

     Payroll Verification Report Fields Accumulate Totals for a Range of Dates in Check History Tip:  To see more information about a field, click the hyperlink for the field name.
     Emp #	Employee Number
     Gross Pay	Gross Pay Earnings Total
     Fed W/H	Federal Tax Withholding Amount Total
     FICA W/H	FICA W/H = FICA Withholding Amount Total - Regular & FICA Withholding Amount Total - Medicare
     State W/H	State Tax Withholding Amount Total

      

   • To see the report sample, click More.

      

     Selection Parameters for this Report Sample:
     Start at Selection Number = 6	Continue through Selection Number = 6
     Check Date Range = all	Page Width = 132 Columns

      

     

      

     ---

      

7. Check the Permanent Pay Check Files:

1. • To see field descriptions, click More.

      

     Tip:  This report checks the Permanent Pay Files for extraneous detail and terminated employees.

     Payroll Verification Report Fields Check the Permanent Pay Check Files Tip:  To see more information about a field, click the hyperlink for the field name.
     Emp#	Employee Number
     Gross Pay From Master	Gross Pay Earnings Total from Employee Master file
     Total From Detail	Gross Pay Earnings Total from Permanent Pay files

      

   • To see the report sample, click More.

      

     Selection Parameters for this Report Sample:
     Start at Selection Number = 7	Continue through Selection Number = 7
     Check Date Range = all	Page Width = 132 Columns

      

     

      

     ---