QuickBooks and Michigan Form UIA 1017: What Prefills and What You Fix

QuickBooks Desktop handles the heavy lifting for Michigan’s quarterly unemployment filing, but the Form UIA 1017 — the Wage Detail Report submitted to the state’s Department of Licensing and Regulatory Affairs — still requires a careful manual review before you send it off.

The form exists to report wage information for every employee who worked during a given calendar quarter. QuickBooks pulls from your existing company, payroll, and employee records to populate the majority of the fields automatically. In an ideal scenario where all your data is current and complete inside QuickBooks, you may not need to enter anything at all. In practice, though, a handful of fields routinely come back blank or require a second look.

Navigating to the Form

To reach the UIA 1017 inside QuickBooks, you will work through the payroll forms workflow. From the Employees menu, select Payroll Forms and W-2s, then choose Process Payroll Forms. Select the quarterly form for Michigan unemployment. Once the form opens in the review window, QuickBooks displays the prefilled data alongside any fields it could not complete automatically.

Fields QuickBooks Typically Prefills

Gross wages are the core of this filing. QuickBooks pulls the total amount of wages actually paid to each employee during the calendar quarter and maps those figures to the appropriate lines. Note the emphasis on paid — the state requires wages that were disbursed during the quarter, not merely earned or accrued. QuickBooks also populates each employee’s Social Security number, which Michigan requires in order to process wage amounts for every covered worker.

Fields That May Need Your Attention

The Family Owned field is the one most likely to trip up filers who have never encountered it. QuickBooks leaves this blank unless your situation matches a specific definition. You should enter an “F” in this column only if your business is family-owned and the majority interest is held by the claimant alone, by the claimant’s son, daughter, or spouse, by any combination of those individuals, or by the claimant’s mother and/or father if the claimant is under 18. If none of those ownership structures apply, leave the field blank.

The signer’s title and telephone number also require manual entry. QuickBooks knows who you are, but the state wants the title of the person actually signing the report — owner, officer, authorized agent, or similar — along with a direct phone number where that person can be reached.

Reviewing What QuickBooks Could Not Fill

For any field the software left empty, QuickBooks provides inline guidance. Clicking the Help button on the form window brings up explanations for individual fields and can clarify where the numbers on the form originated inside your QuickBooks data. If a figure looks wrong, the Help tool can trace it back to the underlying paycheck or employee record, which is often faster than hunting through registers manually.

Exporting and Saving the Form

Two tasks that frequently follow the review step are exporting the payroll data to Excel and saving a copy of the completed form. QuickBooks includes options for both directly within the form window.

To summarize your payroll data in Microsoft Excel, use the export function available on the form screen. This pulls the wage detail into a spreadsheet where you can sort, filter, or subtotal the figures as needed for internal records or for reconciliation against your general ledger.

To save a finished copy of the form, use the PDF option. This produces a static, non-editable file that mirrors exactly what you are submitting to the state — useful for your own archives or for sharing with an outside accountant without giving them access to the live company file.

A Note on Coverage Exclusions

One detail worth watching: the form should not include wages for workers whose services are excluded from coverage under Section 43 of the Michigan Employment Security Act. QuickBooks will report wages for all active employees on your payroll unless you have configured exclusions. If you have workers who fall under a statutory exclusion, verify that their wages are not flowing onto the UIA 1017 before you file.

For broader help with QuickBooks payroll forms and troubleshooting, the form window’s built-in Help tool is the most direct route to field-level explanations and number-tracing for the specific return you are working on.