QuickBooks Michigan Form UIA 1020 Report: What Each Line Means
QuickBooks prefills most of Michigan's quarterly unemployment tax form, but users often need help understanding where the numbers come from and what to enter manually.
QuickBooks Desktop’s payroll module generates a dedicated report to help Michigan employers complete Form UIA 1020 — the state’s Employer’s Quarterly Tax Report — and while the software prefills most fields automatically, users routinely ask how the underlying unemployment insurance amounts are calculated and what to do about the fields QuickBooks leaves blank.
What the Report Covers
The UIA 1020 is due on the 25th of the month following the end of each calendar quarter, and timeliness is determined by the date the state receives the form — not the postmark date. QuickBooks populates the majority of the form using company, payroll, and employee data already stored in the file. In most cases, if all of that data has been entered correctly throughout the quarter, there is little additional manual input required. However, users should review every field the software did not fill in before submitting.
Line-by-Line Breakdown
The confusion for most users centers on where specific dollar amounts originate. QuickBooks maps each line on the form to a specific data point in the payroll setup:
- Line 1 displays the employer’s UIA account number.
- Line 2 shows each employee’s yearly wages that are taxable for unemployment purposes — this is tied to Michigan’s taxable wage base.
- Line 3 reflects the quarter ending date, which falls on 03/31, 06/30, 09/30, or 12/31, along with the appropriate year.
- Line 4 is the employer’s Federal Employer Identification Number.
- Line 5 represents total wages paid during the quarter.
- Line 6 captures the portion of each employee’s wages from Line 5 that exceeds the taxable wage limit shown on Line 2.
- Line 7 is the total taxable wages for the quarter — essentially Line 5 minus Line 6.
- Line 8 shows the employer’s tax rate. A “T” preceding the rate signals a temporary assignment, which the state uses until enough history exists to calculate a permanent rate.
- Line 9 is the actual tax due for the quarter.
- Line 10 reflects any pre-existing account balance or credit. If there is a balance due, the employer enters that amount next to “Add.” If there is a credit, the amount goes next to “Subtract.”
- Line 11 is the payment amount being submitted. If no tax is due or no remittance is being made, the employer enters zero. Payments should be made by check payable to the State of Michigan, Unemployment Insurance Agency, with the UIA account number written on the check.
- Line 12 is the total count of workers who worked during — or received pay subject to unemployment insurance for — the pay period that includes the 12th of the month. Employees must be counted here even if their wages exceeded the taxable limit.
Fields QuickBooks Does Not Fill
When the software leaves a field blank, the built-in help within the form window offers guidance on what to enter and how to troubleshoot specific issues. Hyperlinks within the report itself trace numbers back to their source in QuickBooks, which helps users verify accuracy before filing.
Why It Matters
For employers managing payroll through QuickBooks, the UIA 1020 report is designed to reduce manual data entry — but only when the underlying payroll setup is complete and accurate throughout the quarter. Gaps in employee wage data, an outdated tax rate, or a missing account number can all result in blank fields or incorrect totals. Reviewing the form against the line-by-line breakdown before submission is the most reliable way to catch problems early, since the state holds employers to the receipt-date deadline regardless of when the report was mailed.