QuickBooks Payroll: Understanding Form UITR-1 Quarterly Unemployment Reporting

QuickBooks users responsible for filing Colorado’s Form UITR-1 — the Quarterly Report of Wages Paid and Premiums Owed — routinely encounter confusion about which fields the software populates automatically and which ones require manual entry before the form can be submitted to the state.

Filing Deadline and Electronic Submission

Form UITR-1 is due on the last day of the month following the close of each calendar quarter. When that deadline lands on a weekend or legal holiday, the filing is considered timely if postmarked on the next business day. Colorado requires electronic filing and payment through the state’s employer portal unless a specific waiver has been granted.

What QuickBooks Prefills

For most users, QuickBooks automatically populates the majority of the form using existing company setup, payroll, and employee data. When all records are current and complete, little to no manual data entry is typically needed. However, users should carefully review every field the software did not fill in automatically, as incomplete or outdated company information can leave gaps.

Key Fields Users Must Verify

Report and Payment Due Date

This reflects the final postmark date the state will accept without applying interest or penalties.

Federal Employer Identification Number (FEIN)

QuickBooks pulls the nine-digit federal ID number the employer registered for unemployment insurance purposes. If the FEIN currently on file differs from what appears on the preprinted UITR-1, the corrected number must be entered manually.

Payroll Includes 12th of the Month

This figure counts all workers who either worked during or received pay subject to unemployment insurance wages for the payroll period covering the 12th day of the month. Employees must be counted here even if their earnings have already exceeded the annual taxable wage base for the year.

Total Wages Paid

This line captures gross wages actually paid during the quarter. It excludes amounts the employer is still liable for — wages earned or accrued but not yet distributed.

Excess Wages

This represents the portion of each employee’s wages that surpasses the taxable wage limit for the year. The state sets this annual threshold, so users should confirm the current figure against their payroll records.

Taxable Wages

This is the quarter’s total wages that fall within the taxable limit — essentially total wages paid minus excess wages.

Tax Due

QuickBooks displays the employer’s assigned tax rate alongside the calculated tax amount owed for the quarter.

Late Filing Consequences

Interest accrues at 1.5 percent per month, or any portion of a month, on taxes paid after the due date. Penalties also apply for late filing, so verifying the form’s accuracy before submission is critical.

Additional Resources

Users who need to audit where the numbers originate can use QuickBooks’ built-in hyperlink features on the form to trace calculations. The software also supports exporting summarized payroll data to Excel for reconciliation and saving completed forms as PDF copies for internal records. For broader guidance on QuickBooks payroll troubleshooting, community resources cover common reporting and filing issues.

Bottom Line

The UITR-1 workflow in QuickBooks is designed to minimize manual input, but the form still demands a careful review pass. Verifying FEIN accuracy, confirming the 12th-of-month headcount, and double-checking excess wage calculations against the current taxable wage base are the steps most likely to prevent filing errors and the penalties that follow.