Consider the information below to determine why your quarterly reports do not have the expected figures on them:

• State requirements determine where the gross wage information is retrieved from. Typically, the gross wage information is retrieved from the SUI_E, the state withholding (SWH) or both the SUI_E and the SWH taxable fields.

• If the quarterly report being run contains year-to-date totals, do not compare these totals to other reports showing the year-to-date totals. Quarterly reports show only the totals for employees who work in that quarter.
• The quarter-to-date totals and prior quarter totals (Setup, Employee, Taxes) update when you post checks. To get accurate totals when you compare quarter-to-date totals to the amounts on the 941 report, use check date for the date range rather than period end dates.
• Verify that the 941 report has only one condition, the Date Range Condition EQ X.
• Do not compare the quarter-to-date totals against federal withholding subject-to amounts. Pays or deductions that are exempt from federal withholding tax may not be exempt from state taxes.
• Once you verify that the totals being compared to your quarter-to-date report are correct, compare the subject-to reports to the quarterly report to narrow down the difference to the employee level. For information on a subject-to by date range report, select the link below.
• Use the PR Subject-to Date Range report to verify data integrity. This report is available in the Report folder. You can add this report to your Reports menu as of the Sage Timberline Office Accounting and Management Products 9x and later year-end CD versions. For instructions to add a report to your Reports menu, select the link below.
  Compare the results to the subject-to reports (Reports, Tax Preparation) to determine if totals from the check records (transaction files) match the totals from the employee records (master files).
• If the quarterly employee count report has less employees than expected, it may be due to employees who did not work the full quarter. The employee count report includes only employees who worked for the period including the 12th of the month, per government specifications. Print the Check Register report (Reports > Pay Period Processing) and specify the period end date that includes the 12th in the date range. Although this report does not give you a count of the employees, it does provide you with an easy way to determine who worked in that period.
• Verify that the quarterly report was correct last quarter. If so, determine what changes have been implemented.
• Recalculate subject-to can cause incorrect taxable and subject-to amounts on both the master file and in the transaction files if run incorrectly. Determine if this process has been run since the last time the quarterly reports were correct.