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

Compare Employee Totals to Employee Quarterly Totals:

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

Compare Employee Totals to Check History:

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

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

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

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

Accumulate Totals for Employee Totals & Quarterly Files:

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

Accumulate Totals for a Range of Dates in Check History:

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

Check the Permanent Pay Check Files:

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