Minnesota DEED 1D-AR Quarterly Wage Detail Report in QuickBooks
QuickBooks prefills most fields on Minnesota Form DEED 1D-AR, but employers must verify employee counts, wage totals, and name-length limits before filing electronically.
QuickBooks Desktop includes built-in support for Minnesota Form DEED 1D-AR, the Employer’s Quarterly Wage Detail Report required of employers subject to Minnesota’s Unemployment Compensation law. The form appears inside the payroll module alongside the Quarterly Tax Report (Form MN DEED-1), and QuickBooks attempts to prefill most of the fields automatically. Employers who have never filed the wage detail through QuickBooks — or who are seeing unexpected blanks — generally need to understand which fields the software fills on its own and which ones require manual entry before the report can be submitted.
What QuickBooks Fills Automatically
The program populates the upper portion of the form using the company information and payroll data already on file. That includes the ten-digit Minnesota Unemployment Number, the business legal name and address, the calendar quarter and year, the due date carried over from Form MN DEED-1, and the employer telephone number. Each employee’s Social Security number, name, and quarterly wages are also drawn from the employee records and paychecks already recorded in the company file.
For Item 7 — the count of covered employees in the pay period that includes the 12th of each month — QuickBooks tallies all full-time and part-time workers who received wages during that specific period for each of the three months in the quarter. If no employees were paid in a given month, the software enters a zero rather than leaving the field blank.
Name-Length Limits to Watch For
One detail that catches employers off guard: QuickBooks truncates employee last names to twenty characters and first names to fifteen characters on the wage detail report. If an employee has a longer legal name on file, the printed form will show only the portion that fits within those limits. Employers should review the report before filing to confirm that truncated names will still satisfy Minnesota’s requirements.
Fields That May Need Manual Entry
Although QuickBooks prefills the wage figures for each employee, the software flags any field it could not populate automatically. Employers are expected to review the form line by line and enter values where QuickBooks left a gap — most commonly when an employee record is missing a Social Security number, when wages were recorded outside the normal payroll workflow, or when a new hire was added mid-quarter and the setup was incomplete. If an employee performed services but earned zero wages for the quarter, the employer should enter a zero in the wage field rather than deleting the line.
Electronic Filing Is Mandatory
Minnesota requires all Wage Detail Reports to be submitted electronically — either through the state’s online interface or its automated telephone system. Employers who report fifty or more employees in any calendar quarter must also remit payments electronically. QuickBooks generates the report and the numbers, but the actual filing happens through the state’s system, not inside the QuickBooks application itself.
Where the Numbers Come From
Employers who see a figure on the wage detail that does not match their expectations can trace it back through the form window’s built-in help. QuickBooks documents the source of each calculated field, which is useful when reconciling discrepancies between the wage detail report and internal payroll summaries. The most common sources of confusion are bonuses or corrections recorded after the original paycheck was cut, year-end adjustments that hit the wrong quarter, and employee-level wage limits that affect how taxable wages appear on the form.
Practical Steps Before Filing
Before generating the final report, employers should verify that every active employee has a complete record — legal name, Social Security number, and correct wage totals for all three months of the quarter. Running a payroll summary for the same period and comparing the totals to the wage detail report is a reliable way to catch data-entry errors. If the company file has damaged or inconsistent payroll data, the wage detail may pull incorrect figures, so verifying data integrity before filing season is worthwhile.
The wage detail report is designed to reduce manual data entry, but it is not a substitute for reviewing the numbers before they reach the state. QuickBooks handles the calculation; the employer remains responsible for accuracy.