How to use the Employee Totals Verification Report

There's a file name change in Version 2018.

• PR3_EmployeeTaxSummary has changed to PR_EmployeeTaxFilingStatus
• PR_40FederalStateEFiling has changed to PR_PayrollHistoryTaxReporting

What the Employee Totals Verification Report does

The Employee Totals Verification Report confirms that calculated employee check totals match employee totals in the Tax Summary.

The report lists employees with discrepancies where employee totals differ from check totals.

Data sources used by the report

The report compares information from PR3, Employee Tax Summary, and PR_40, Federal/State eFiling and Reporting.

File locations

The system stores both files in the ..\MAS90\MAS_xxx\PRxxx folder, where xxx equals the company code.

Column sources

• The Check Total column uses data from the PR3xxx.soa file.
• The Employee Total column uses data from the PR_40xxx.soa file.

The report displays every employee with mismatched values between these files.

When to review the report

Review this report before printing W‑2 and quarterly tax forms, such as Form 941.

This review confirms the system reports correct information to the IRS and state tax reporting agencies.

Generate the Employee Totals Verification Report

1. Open Payroll, Period End, Employee Totals Verification.
2. Select one of the following:
   • Year to Date
   • Quarter to Date
3. Select All or applicable employee(s) from the lookup.
4. Click Print or Preview. Note: The system prints this report only for the current quarter or current year defined in Payroll Options.

How to Perform Quarter-End and Year-End Processing in Payroll 2.x and Higher
Files containing the Payroll Employee Totals Verification Report information in Sage 100.
How to edit the eFiling and Reporting file (PR_40)