Michigan Form 5080 in QuickBooks: What Fills and What Doesn't
QuickBooks leaves several Michigan Form 5080 lines blank. Here is what users must enter manually and how the form's key fields work.
QuickBooks users filing Michigan’s combined Sales, Use and Withholding Taxes Monthly/Quarterly Return — Form 5080 — regularly run into the same stumbling block: the software does not populate every line the state requires. The form, which replaced the older Form 160, is used to remit sales tax, use tax, and Michigan income tax withholding in a single filing. QuickBooks handles the payroll withholding side, but leaves sales, use, and certain payment fields untouched.
What QuickBooks fills in versus what you enter yourself
The core issue is that QuickBooks only carries over the withholding-tax data it tracks through payroll. Sales tax, use tax, and related payment information must be entered manually on the form. Once you type those amounts into the appropriate lines, QuickBooks calculates the total payment based on what you entered.
This split catches filers off guard because the form looks complete at a glance — the withholding figures are present, the totals appear to compute — but the sales and use tax lines sit at zero unless you fill them in yourself.
Understanding the form’s key manual entries
Allowable discounts
Michigan permits a discount on a portion of the sales and use tax collected at the 6% rate. Specifically, the discount applies to two-thirds of the tax collected at that rate. The calculation depends on whether you file monthly or quarterly. The state’s tax website provides the current rules for determining the discount amount.
Use tax on business or personal items
If your business made purchases or withdrawals subject to use tax, you calculate the amount by multiplying the total inventory value by 6%. That figure goes on the use-tax line.
Prior or overpayments
You can apply a prior overpayment to the current return, but only up to the total tax liability for this period. If the overpayment exceeds what you owe, the remainder carries forward to the next return where a tax liability exists.
Penalty and interest
Late filing or late payment triggers a penalty of 5% of the tax due. That penalty increases by an additional 5% per month — or fraction of a month — after the second month, capped at 25%. Interest accrues daily based on the average prime rate plus one percentage point. The state’s website posts the current rate.
Filing frequency and deadlines
Michigan assigns filers to either a monthly or quarterly schedule, and that frequency can change over time. Regardless of frequency, 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.
Exporting payroll data and saving the form
For the withholding side of Form 5080, QuickBooks users can summarize their payroll data by exporting it to a spreadsheet. This gives you a worksheet of the payroll figures you need without retyping individual paychecks or withholding details. The export covers payroll liabilities — the Michigan income tax withheld from employee wages — which is the portion QuickBooks tracks for this form.
To keep a record of the completed return before filing, you can save the form as a PDF. This preserves a snapshot of exactly what was submitted, including any manually entered sales and use tax figures.
The bottom line for filers
Form 5080 is a combined return, and QuickBooks treats it as such — but only for the data it actually tracks. Withholding flows through from payroll. Sales tax, use tax, discounts, prior payments, penalties, and interest all require manual entry. The form calculates the total once those fields are populated, but the responsibility for getting the numbers right rests with the filer, not the software.