Summary
How to reconcile an employee's check file totals to the employee master file totals for taxes in Sage 300 CRE.
Resolution
Compare Employee Master file tax totals to Employee Check tax totals
- From the Payroll Reports menu, select Tax Preparation.
- Print the Subject-to Employee report for employee tax totals.
- Print the Subject-to Employer report for employer tax totals.
- Compare the totals to confirm they are in balance.
- From the Payroll Reports menu, select Pay Period Processing and print the Deposit Summary.
- Select the Current.prt.
- Use the Check date prompts, entering January 1 through December 31 of the reconciliation year.
- Compare the summarized totals on the Deposit Summary to the Subject-to Employee and Subject to Employer.
- If there are variances, compare the Subject-to Employee/Employer to the Subject-to Date Range.
- From the Payroll Reports menu, select Tax Preparation.
- Print the following report for employee tax totals:
- Subject-to Date Range: Select Employee and Check Dates and enter January 1 through December 31 of the reconciliation year
- Print the following report for employer tax totals:
- Subject-to Date Range: Selecting Employer and Check Dates and enter January 1 through December 31 of the reconciliation year
- Compare the totals.