Description of Issue

The month counts on the Multiple Worksite Report are almost all zero (0)
Month count is 0

Context

Payroll
State Reporting
Multiple Worksite Report

Cause

The monthly employment reported for each location (worksite) on the Multiple Worksite Report should be a count of all full- and part-time workers who worked during or received pay (subject to Unemployment Insurance wages) for the pay period which includes the 12th day of the month.

The EERP program is evaluating the pay period begin and end dates on the Generate screen(s) to determine which Warrant(s) include the 12th of the month.

If Month counts are 0, that indicates that there are no Warrants with a Generate screen including dates that cross the 12th.

Resolution

Manually adjust the counts as needed.

A Payroll Detail History Report can help you determine accurate counts. Search for the Warrant you believe should have crossed the 12th and export to Excel. In Excel, Filter the Pay/Deduction Code to include just unemployment insurance eligible pays. Sort by Employee Number and then use Excel's UNIQUE function to get the count.

Additional Information

Reference Chapter 5 - MWR Reporting Procedures for additional detail on Multiple Worksite Reporting requirements.
Microsoft Support for the UNIQUE function: https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60664&ui=en-us&rs=en-us&ad=us

Browser not supported