Reconcile Payroll taxes, taxable and subject-to amounts

Print reports that compare the transaction file to the master file to reconcile taxes in Payroll. You can use this process as part of your year-end, quarter-end, and month-end procedures.

Don’t move or archive employees or move checks before closing the year, and issuing necessary government reports.  (941, W2's, Quarterly reports).

To verify that tax amounts are correct on both the transaction file and the master file, use the steps below.

Print the Deposit Summary report

1. From the Payroll Reports menu, select Pay Period Processing, Deposit Summary.
2. Select the current transaction file.
3. Enter a Check Date range you’re reconciling.
   Note: If reconciling for tax reporting, enter the date range for full month, quarter, or year. Payroll will post checks to the master file by using the Check Date. It's important that when running transaction reports you also use Check Date.
4. Click Start.

Print the Subject-to Employee report

1. From the Payroll Reports menu, select Tax Preparation, Subject-to Employee.
2. Click Start.

Compare the Federal, State, and Local taxes to the employer totals on the Deposit Summary report. The totals should match.

Print the Subject-to Employer report

1. From the Payroll Reports menu, select Reports, Tax Preparation, Subject-to Employer.
2. Click Start.

Compare the Federal, State, and Local taxes to the employer totals on the Deposit Summary report. The totals should match.

Locate discrepancies

If the totals don’t match, determine where the discrepancy is. To do this, you can print the Tax Reconciliation Report. Use this report to compare the master file totals to the transaction file on an individual employee basis. See steps to reconcile employee tax totals.

Where can I find Year-End Procedures Guides (YEPG)?
How do I reconcile Payroll to Payroll?