Understanding the Quarterly Weeks Worked Report

To satisfy government reporting requirements regarding state unemployment insurance (SUI), you might need to report weeks worked information along with the regular SUI reports. The Quarterly Weeks Worked Report (R07810) calculates the number of weeks that an employee works, using the timecard history information that is stored in the Employee Transaction History table (F0618). The system then updates the Tax History table (F06136) for each employee's tax type Z record. You can run the report in proof mode to review the information before you run the report in update mode. When you run the report in update mode, the system updates the records in the F06136 table.

You can generate this report quarterly to satisfy government SUI reporting requirements, or you can generate the report more frequently to update tax history information. You must process this report before processing quarterly state unemployment insurance reports.

Note:

Some states require companies to report this information based on amount rather than hours worked. To ensure accurate
reporting for these states, you must enter timecards either daily or weekly. For example, if the employees are paid on a biweekly basis, you must enter at least two timecards for each employee so that the system can identify the amount that is associated with a week of work. If you enter one timecard for all of the time included in a biweekly payroll, the weeks-worked information that you report might not be accurate.

You can set the processing options for this report to generate information in a format that meets these reporting requirements.