Multiple Worksite Report

Multiple Worksite Report

At this time there is not a single report that can generate the data needed for the MWR. The data must be pulled in two separate reports due to the nature of the data needed for the report; one for the wage data and one for the employee count. The Wage data by worksite is for the full quarter while the employee count by worksite is based upon the payrolls each month whose pay periods included the 12th of the month. 


Instructions for Wage Data Report:

1.     Navigate to Team > Payroll > Reports > Taxes > Tax Wage Details > Tax Wage Details

2.     On this report you will need the following columns: Tax Code, Subject Gross Wages (ER), and your cost center and cost center level for your worksite.

3.     Filter for your Tax Code equals SUTA: XX  (State Abbreviation) and Pay Date Range for the quarter you need the data for


Instructions for Employee Count Report:

1.     Navigate to Team > Payroll > Reports > Taxes > Tax Wage Detail > Tax Wage Details.

2.   On this report you will need the following columns: Employee ID (can also add Employee Name if you want), Payroll: Pay Month, Tax Code, Subject Gross Wages (ER), and your cost center and cost center level for your worksite.

3.     For your Pay Date Filter you will use Payroll Filter and you will select the payroll for the quarter you are running the report for whose pay periods include the 12th of the month 


4.     Export the report to Excel

5.     Within Excel there are two options for obtaining the employee count:

a.      Filter on the worksite location and by each pay month to determine how many employees were in the location each month

b.     Create a Pivot Table with the Row as Pay Month, Column for your worksite, and the Value as Count of Employee ID. This will give you a table that has  an employee count for each.



    • Related Articles

    • Report Hub

      Report Hub is a unique feature that allows you to view, search, and create custom reports. From you full navigation menu, navigate to My Info > Reports > Report Hub to access the page. Here you will find that the Report Hub is divided into a series ...

    • Saving a Report

      First, you must access the report. For example, the Employee Information report, you would access through the Main Menu. Navigate to Team > My Team > Employee Information. The different save functions are located in a drop menu accessed by clicking ...

    • How to Add/Remove Columns from a Report

      In order to build a specialized report using an existing report for your basis, you must first be able to add and/or remove columns. This article also addresses positioning existing columns or ones you've added. First you must access the report you ...

    • Sharing a Report

      Navigate to My Info > My Reports > My Saved Reports Find the report that you want to share from the Report Hub and click on the play button next to the report you want to share. Once you click on the play button, you will be brought into the report. ...

    • How To Download Certified Report

      In order to download a Certified Report that has already been produced, navigate to Settings > System Data Export > Data Exports. Under data exports, choose the export type Certified Payroll (WH347) by clicking the download option. It will default to ...