Minnesota DEED 1D-AR Wage Detail Report in QuickBooks: What Fills Automatically
QuickBooks prefills most fields on Minnesota Form DEED 1D-AR, but employers must review and complete what remains before submitting electronically.
QuickBooks Desktop includes built-in support for Minnesota Form DEED 1D-AR, the Employer’s Quarterly Wage Detail Report, but users navigating the form for the first time routinely ask which fields the software completes on its own and which ones require manual entry. The short answer is that QuickBooks populates the majority of the form using the company and employee data already on file, but it does not finish the job entirely.
What the Form Covers
The DEED 1D-AR accompanies the Quarterly Tax Report (Form MN DEED-1) and covers all employees working under Minnesota’s Unemployment Compensation law. Minnesota requires that all wage detail reports be filed electronically — either through the state’s online interface or its automated telephone system. Employers reporting 50 or more employees in any calendar quarter must also remit payments electronically.
Fields QuickBooks Fills Automatically
QuickBooks draws on existing company-level setup and payroll data to populate the bulk of the form. Here is what users can expect to see pre-populated:
- Employer Number — QuickBooks pulls the Minnesota Unemployment Number entered in company settings. This should be a 10-digit account number.
- Business Name and Address — The legal name and address on file in QuickBooks carry over to the form.
- Quarter Number — The calendar quarter (1, 2, 3, or 4) is determined by the reporting period selected.
- Year — The calendar year populates based on the same selection.
- Due Date — QuickBooks enters the filing deadline for Form MN DEED-1.
- Employer Telephone Number — The phone number stored in company information appears here.
For the employee-level detail, QuickBooks populates each worker’s Social Security Number, name (last name first, then first name with initial if applicable), and total wages paid during the quarter.
Character Limits and Manual Review
One detail that catches users off guard involves name truncation. The form limits last names to 20 characters and first names to 15 characters. QuickBooks applies these limits when it fills the fields, so employers with long employee names should verify that the truncated entries remain acceptable for filing purposes.
The covered-employee count — the number of full-time and part-time workers who worked or received pay during the payroll period that includes the 12th of each month in the quarter — also populates automatically. If no employees were on the payroll during a given month, QuickBooks enters a zero for that period.
What Employers Still Need to Do
QuickBooks does not guarantee that every field is complete or accurate. After the software fills the form, employers should review each field that was not auto-populated and enter any missing information before filing. The form window includes a Help button that provides additional context on where specific numbers originate within QuickBooks, which can be useful when reconciling figures that look incorrect.
For broader payroll form troubleshooting, the same Help button offers guidance on tracing values back to their source transactions inside QuickBooks.
Filing Reminders
The key takeaway for employers is that QuickBooks is a preparation tool, not a filing tool, for this report. After reviewing and completing the form, employers must submit the wage detail electronically through Minnesota’s systems. The data QuickBooks produces is meant to assist in filling out the state form — it does not transmit directly to the state.
Users who find that account numbers, employee data, or wage totals are missing or incorrect on the pre-filled form should check the underlying company settings and employee records in QuickBooks before filing, since the form only reflects what has already been entered into the software.