Michigan Form 5080 in QuickBooks: What Fills Automatically and What You Must Enter

QuickBooks Desktop includes built-in support for Michigan Form 5080 — the combined Sales, Use and Withholding Taxes Monthly/Quarterly Return — but the form does not populate completely on its own. Users filing this return through QuickBooks have found that the software handles payroll withholding figures while leaving several tax lines empty, requiring manual entry before the return can be filed.

What Form 5080 Covers

Form 5080 is the State of Michigan’s combined tax return, replacing the older Form 160. It serves as a single filing for reporting sales tax, use tax, and Michigan income tax withholding. Employers remit the total tax due either monthly or quarterly, depending on the filing frequency assigned by the state, and that frequency can shift over time. The return is due on the 20th of the month following the close of the reporting period — whether that period is a single month or a full quarter.

Accessing the Form in QuickBooks

To open and work on Form 5080 from within QuickBooks Desktop, navigate through the payroll workflow. From the top menu bar, select Employees, then choose Payroll Forms or Payroll Center (the exact label depends on your QuickBooks edition). In the Payroll Center, select the File Forms tab. You should see Michigan Form 5080 listed among the available forms. If it does not appear, verify that your payroll tax table is current, as outdated tables can prevent newer or revised state forms from displaying. Select the form and click Create Form to open it in the QuickBooks form viewer.

Where QuickBooks Leaves Gaps

This is where users run into friction. QuickBooks does not automatically fill in sales tax, use tax, or certain payment-related information on Form 5080. The payroll withholding portion — the Michigan income tax withheld from employee wages — populates from your payroll data. But for the remaining fields, you must enter the appropriate amounts manually on the form itself. Once those figures are typed in, QuickBooks calculates the total payment based on the amounts entered.

This means that if your business collects sales tax or owes use tax, you will need to gather those numbers from your own records or from elsewhere in QuickBooks and enter them directly on the form lines. The software does not pull those figures automatically from your sales transactions or purchase data into this particular return.

Allowable Discounts

Michigan offers a filing discount, but it applies only to two-thirds (0.6667) of the sales and/or use tax collected at the 6% rate. The discount calculation depends on your filing frequency, so monthly and quarterly filers will arrive at different numbers. The state provides the current rules for discount calculations on its tax website, and users should verify the formula before entering a discount amount on the form.

Use Tax on Business or Personal Items

If your business owes use tax on inventory purchases or withdrawals, the calculation is straightforward: multiply the total inventory value by 6% (0.06) and enter the result on the appropriate line. QuickBooks will not compute this figure for you on Form 5080, so the multiplication and entry are manual steps.

Penalties and Interest for Late Filing

Michigan assesses a late filing penalty of 5% of the tax due, with an additional 5% added per month or fraction of a month after the second month, up to a maximum of 25%. Interest is charged daily based on the average prime rate plus one percentage point. Because both the interest rate and penalty details can change, the state’s tax website is the authoritative source for current figures when calculating what you owe on a late return.

Exporting Payroll Data and Saving the Form

Two tasks that frequently accompany Form 5080 preparation are summarizing payroll data in a spreadsheet and saving a copy of the completed form. QuickBooks allows you to export your payroll summary to Microsoft Excel, which gives you a working spreadsheet of the wage and withholding figures behind the return. Within the Payroll Center or the form itself, look for the option to export or summarize payroll data — this produces an Excel file you can use for reference or record-keeping.

To save a completed Form 5080 as a PDF, use the Save as PDF or Print option available in the QuickBooks form viewer window. This creates a standalone copy of the return that you can archive electronically or share with an accountant without requiring access to QuickBooks.

The Bottom Line

Form 5080 is one of those returns where QuickBooks does part of the work but not all of it. The payroll withholding side flows through automatically, but sales tax, use tax, discounts, and penalty calculations are manual entries. Knowing that before you sit down to file saves time and reduces the chance of submitting an incomplete return. For additional guidance on QuickBooks payroll forms and troubleshooting, the broader QuickBooks knowledge base covers common form-preparation questions.