How to use the Employee Totals Verification Report
Description

NOTE:  File names have changed in Version 2018

PR_EmployeeTaxFilingStatus replaces PR3_EmployeeTaxSummary

PR_PayrollHistoryTaxReporting replaces PR_40FederalStateEFiling

Cause
Resolution

Employee Totals Verification report is used to confirm the calculated values of check totals for employees equal the employee totals in Tax Summary. This report lists employees with discrepancies, and employee totals that differ from check totals.

Information from PR3 (Employee Tax Summary) and PR_40 (Federal/State eFiling and Reporting) are compared in the Employee Totals Verification report:

Both files are located in the ..\MAS90\MAS_xxx\PRxxx folder (xxx=company code)

  • Check Total column is from PR3xxx.soa file
  • Employee Total column is from PR_40xxx.soa file

Any employees with discrepancies between these two files are listed on this report.

 

Review this report before printing W-2 & Quarterly tax forms (i.e. Form 941) forms to verify the correct information is reported to the IRS (Internal Revenue Service) & State Tax Reporting agencies.

To generate the 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 look up 
  4. Click the Print or Preview button.

Note: This report can only be printed for the current quarter or current year defined in Payroll Options.

 

DocLink: How to Perform Quarter End & Year End Processing in Payroll 2.x and Higher
DocLink: What files contain Payroll Employee Totals Verification Report information in Sage 100 ERP.
DocLink: How to edit the eFiling and Reporting file (PR_40)
Defect ID
Steps to duplicate
Related Articles