Michigan UIA 1028 Quarterly Wage Report in QuickBooks: Filing and Field Guide

QuickBooks Desktop handles the heavy lifting for Michigan’s Form UIA 1028 — the Employer’s Quarterly Wage/Tax Report — but the software’s prefilled data still requires a careful review before you file. The form, submitted to the state’s Department of Licensing and Regulatory Affairs, reports wage information for every employee who worked during the quarter, and QuickBooks users regularly run into questions about which fields need manual entry, when electronic filing becomes mandatory, and how to export the underlying numbers for their own records.

The 25-Employee Electronic Filing Threshold

The single most important rule for QuickBooks users preparing this form: if you are reporting more than 25 employees, you cannot mail the return. You must file electronically through the state’s online portal. That requires advance registration, so if your headcount is approaching that number, set up your portal access before the quarterly deadline arrives. For employers at or below 25 employees, mailing remains an option. Paper returns go to the Unemployment Insurance Agency, Tax Office, P.O. Box 33598, Detroit, MI 48232-5598.

What QuickBooks Fills Automatically — and What It Does Not

When you open the UIA 1028 form window inside QuickBooks, the software populates most fields using the company, payroll, and employee data already in your file. In a well-maintained QuickBooks company file where all payroll setup is complete and current, you may not need to manually enter anything at all. That said, you should not assume the form is ready to submit without a line-by-line review.

Several fields will likely require your attention regardless of how clean your QuickBooks data is:

Employer Type

Michigan recognizes two methods of funding unemployment insurance, and you must identify which applies to your organization on the form. The first covers private, for-profit employers — the category most businesses fall into. These are classified as “contributing employers.” Each quarter, a contributing employer files the UIA 1028 to compute and pay unemployment insurance tax. The tax rate is driven by a formula that weighs the employer’s history with former workers filing unemployment claims alongside the overall size of the payroll as an indicator of potential risk.

The second method applies only to units of government and to qualifying nonprofit organizations. To fall under this category, a nonprofit’s purpose must be educational, religious, cultural, or scientific — generally aligning with Section 501(c)(3) of the Internal Revenue Code and the federal income tax exemption under Section 501(a). These employers use what Michigan calls the “reimbursing method” and are designated on the form as reimbursing employers rather than contributing ones.

Amended Return

If you are filing to correct a previously submitted UIA 1028, select the “Amended” option on the form. QuickBooks will prompt you to enter the reason for the amendment. This is a manual field — the software has no way of knowing what changed or why you are refiling, so you must provide that explanation yourself.

Family Owned

This field should be left blank in most cases. You only complete it if your business qualifies as a family-owned enterprise where the majority interest is held by the employee alone, the employee’s spouse, the employee’s son or daughter, any combination of those individuals, or the employee’s mother and/or father. The distinction matters for unemployment insurance purposes, so if you are uncertain whether your ownership structure qualifies, review the form’s built-in help before checking this box.

Exporting Payroll Data to Excel

A common question among QuickBooks users preparing the UIA 1028 is how to pull the underlying payroll numbers into a spreadsheet for verification or record-keeping. QuickBooks provides a direct option within the form window to summarize your payroll data in Microsoft Excel. When you select that option, the software exports the wage and tax figures feeding into the form so you can review them row by row, share them with an accountant, or keep them on file for your own quarterly documentation.

Saving a Copy of the Form

QuickBooks also includes a built-in option to save the completed payroll form as a PDF. This lets you retain a copy of exactly what was filed — useful for your own archives, for sharing with outside preparers, or for producing documentation if the state later questions a filing. The save-as-PDF function is accessible directly from the form window alongside the other form-level tools.

Tracing Numbers Back to QuickBooks

If a figure on the UIA 1028 does not match your expectations, the form window includes a Help button that connects to detailed guidance on where each number originated within your QuickBooks data. That includes troubleshooting tips for discrepancies and general instructions for navigating the form interface. Rather than guessing at which paycheck or setup detail drove a particular total, use that in-product help to trace the number back to its source transactions.

For broader payroll form troubleshooting in QuickBooks Desktop, the same review principles apply — verify your employee setup, confirm your tax table is current, and reconcile the form totals against your payroll registers before filing.