Montana UI Quarterly Contribution Report in QuickBooks: Field Guide
QuickBooks prefills most of Montana's quarterly unemployment insurance form, but certain fields and reconciliation steps require user review and manual entry.
Montana employers filing their quarterly unemployment insurance contribution reports through QuickBooks have encountered questions about how the software populates Form UI-5 and its companion wage listing, Form UI-5A. While QuickBooks prefills most fields automatically using existing payroll data, several lines and reconciliation steps require user attention — and the built-in help text contains a numbering inconsistency that has caused confusion.
What the Form Covers
Montana’s Quarterly Contribution Report (Form UI-5) reports state unemployment insurance tax calculated on wages paid during the calendar quarter. The filing deadline is the last day of the month following the close of the quarter. When that date lands on a weekend or legal holiday, the deadline shifts to the next banking day.
QuickBooks pulls from existing company, payroll, and employee records to populate the form. In most cases where all payroll data has been entered correctly throughout the quarter, no additional manual input is needed beyond reviewing what the software has generated.
The Employee Wage Listing (Form UI-5A)
The companion form lists each employee and their wage details. QuickBooks excludes any employee who earned no wages during the quarter — they simply do not appear on the listing. For employees lacking a Social Security Number on file, the software inserts an “I” marker in the SSN field rather than leaving it blank.
Page totals on UI-5A aggregate both the individual employee amounts shown on that specific page and the carryover totals from all prior pages of the form. This cascading-total structure means the final page reflects cumulative quarter figures.
Reconciling the Key Lines
The form’s structure requires that figures reconcile across both UI-5 and all pages of UI-5A. Here is how the critical lines work:
Total Wages Paid This Quarter (Line 1): QuickBooks calculates this automatically. The sum of all page totals for total wages across Form UI-5 and every page of Form UI-5A must match Line 1 exactly. If these figures diverge, a data-entry error or missing paycheck is the likely culprit.
UI Excess Wages (Line 2): The software derives this by subtracting taxable wages from total wages. Again, the sum of all excess-wage page totals on UI-5 and UI-5A must equal Line 2.
UI Taxable Wages (Line 3): QuickBooks computes this figure automatically based on Montana’s wage base and each employee’s year-to-date earnings.
Tax Rate and Contribution Calculation (Line 4): The total tax rate displayed on the form feeds into the contribution computation. The software multiplies taxable wages by the contribution tax rate to arrive at the amount due. A separate administrative fund tax line also appears in this section.
The Numbering Problem
QuickBooks’ built-in help text for this form labels two distinct items as “Line 4” — one for the tax rate and contribution amount, and another for the administrative fund tax. This duplicated numbering has led users to wonder whether they are looking at a display bug or a calculation error. In practice, both items belong to the same line group; the administrative fund tax is an additional component of the total amount due rather than a separate line item.
What to Check When Something Looks Wrong
Because QuickBooks relies entirely on the payroll data already in the company file, the most common source of discrepancies is missing or incorrect paycheck data. Employers should verify that all wages for the quarter have been recorded, that each active employee has a valid Social Security Number, and that the unemployment tax rate entered in the company setup matches the rate Montana assigned.
For those who need to work with the data outside of QuickBooks, the software offers options to summarize payroll information in a spreadsheet format and to save a copy of the completed form as a PDF for recordkeeping.
When Prefill Falls Short
If QuickBooks leaves fields blank that should have populated automatically, the issue typically traces back to incomplete employee setup or paychecks recorded with items not mapped to the unemployment tax tracking. Reviewing each employee’s profile and confirming that earnings items are configured correctly usually resolves the gap before filing.
For broader payroll form troubleshooting, the form window’s built-in help button provides field-level guidance, and exporting the data to a spreadsheet can help isolate which paycheck or employee record is throwing off the totals.