Minnesota Quarterly UI Wage Detail Report in QuickBooks

QuickBooks Desktop’s payroll module includes a built-in report designed specifically for Minnesota employers who need to file the state’s Quarterly Wage Detail Report. The tool auto-populates most of the form using company, employee, and payroll data already stored in the company file, but several fields require manual review before submission.

What the Report Covers

The Minnesota UI QTD report mirrors the state’s Quarterly Wage Detail Report. QuickBooks pulls employer identification details — including the Minnesota Employment Tax Account Number, company name and address, and federal EIN — directly from the data already on file. The quarter-end date is also filled in automatically based on existing payroll entries.

On the wage side, the report calculates total gross wages paid or due for services performed during the covered period. That total flows from the sum of individual employee detail amounts on the report’s second page. QuickBooks also enters the current calendar year’s taxable wage base, which determines the threshold at which an individual worker’s wages stop being subject to unemployment insurance tax.

Covered Worker Counts

One area that may need attention is the monthly headcount section. For each month in the reported quarter, employers must count all full-time and part-time workers who performed work or received pay subject to unemployment insurance wages during the payroll period that includes the 12th of that month.

The rules for that count are specific. Workers on paid sick leave, paid holiday, or paid vacation are included. Workers on unpaid leave are excluded. Employees who have already exceeded the taxable wage limit for the year still count toward the monthly worker total. If no employees were reportable during a given month, QuickBooks enters a zero in that field.

Filing Requirements

Minnesota requires all Wage Detail Reports to be submitted electronically through the state’s UI Employer Self-Service portal. Employers reporting 50 or more employees on the wage detail report in any calendar quarter must also remit payments electronically. The filing deadline falls at the end of the month following the close of the reporting quarter.

QuickBooks does not transmit the form directly to the state. Instead, it prepares the data so the employer can review it, save a copy, and then enter the figures into Minnesota’s online system.

Reviewing and Saving the Form

After QuickBooks fills in the fields it can derive from existing data, employers should scan the form for any blank or incomplete sections. In most cases, if all company, payroll, and employee information is current in QuickBooks, little or no manual entry is needed. When a field does not populate, the form window’s built-in help provides guidance on what to enter.

QuickBooks also offers options for tracing where the numbers originated. Employers who want to verify the underlying calculations can follow in-product links to see how unemployment insurance amounts were derived. For those who prefer to work with the data outside of QuickBooks, the software supports summarizing payroll data in Microsoft Excel. The completed form can also be saved as a PDF for recordkeeping or for reference when filing through the state portal.

Common Sticking Points

The report itself is straightforward when payroll data is clean and current, but gaps in employee setup — such as a missing state tax account number or incomplete wage records — can leave fields blank. Employers running QuickBooks payroll should verify that each employee’s profile includes the correct state withholding and unemployment insurance details before generating the report at quarter-end.

For employers managing payroll across multiple states or dealing with more complex wage situations, reviewing the taxable wage base and confirming that monthly worker counts follow Minnesota’s specific inclusion rules is the step most likely to catch errors before filing.