Missouri MODES-4 Quarterly Wage Report in QuickBooks: Field-by-Field Guide
QuickBooks prefills most of Missouri's quarterly unemployment form, but penalty, interest, and probationary entries require manual review and adjustment.
QuickBooks Desktop handles Missouri’s quarterly unemployment reporting through Form MODES-4, the Quarterly Contribution and Wage Report. The software prefills most fields automatically from existing payroll data, but several lines require manual attention — and misunderstanding those manual entries is where users tend to run into trouble.
What QuickBooks Fills Automatically
When you open the MODES-4 form, QuickBooks populates the bulk of the report using the company, payroll, and employee data already in your file. That includes each employee’s name, Social Security number, and total state wages paid, along with taxable wages and total contributions due to Missouri. In most cases, if all payroll data has been entered consistently throughout the quarter, no additional manual input is needed for the core wage and tax calculations.
The form window includes a Help button for general guidance on navigating the form and troubleshooting specific payroll issues. QuickBooks also provides traceable links so you can see exactly where the calculated unemployment insurance amounts originate within your company file.
Manual Fields That Need Attention
Several lines on the MODES-4 fall outside what QuickBooks can calculate automatically, either because they depend on external notices from the state or on filing deadlines the software cannot predict.
Interest and Penalty Lines
Line 8 — Interest Assessment Due to Federal Advances: The Missouri Division of Employment Security notifies employers directly if a federal interest assessment applies. QuickBooks has no way to anticipate this, so you must enter the amount only if you receive notice.
Line 9 — Interest Charges Per Month: If the payment accompanying the return is late, interest accrues on the contribution for every month or partial month from the due date to the actual payment date. The interest rate is set by the Division and must be obtained from them directly.
Lines 10A and 10B — Late Report Penalties: These lines carry tiered penalties based on how late the filing is. If the report is filed after the 10% penalty date printed on the form, you enter the greater of 10% of contributions due or $100. If it crosses the 20% penalty date threshold, the entry becomes the greater of 20% of contributions due or $200.
Adjustments and Totals
Line 11 — Outstanding Amounts: Any prior-period amounts due or credits get entered here. Credits should be entered as negative numbers.
Line 12 — Total Payment: QuickBooks calculates the tax withheld and due with the return, but this figure can be manually adjusted to match the actual payment you are sending.
Employee Designations
Line 20 — Probationary Employees: If any worker was employed on a test or trial basis for fewer than 29 consecutive days, you must enter the first and last days worked in the appropriate columns and place the letter “P” in the probationary column. QuickBooks does not flag probationary status automatically.
Exporting and Saving the Form
For recordkeeping, the form can be saved as a PDF directly from the form window. QuickBooks also supports exporting payroll data to a spreadsheet if you need to summarize or analyze quarterly figures outside the software.
Common Pitfalls
The recurring issue users report is not an error in QuickBooks itself but rather confusion over which lines are automatic and which require manual entry. The penalty and interest lines in particular catch employers off guard, since those amounts depend entirely on filing timeliness and state-determined rates that QuickBooks cannot predict. Reviewing every field the software did not populate — rather than assuming a blank line means zero — is the critical step before submitting the report to Missouri.