Colorado Unemployment Insurance Tax Report in QuickBooks: What Each Line Means
QuickBooks prefills most of the Colorado UITR form, but users still need to verify FEIN, wage breakdowns, and tax calculations before filing quarterly.
QuickBooks Desktop’s built-in Colorado Unemployment Insurance Tax Report (Form UITR-1) is designed to prefill most fields automatically from existing company, payroll, and employee data — but employers are still responsible for reviewing every line before the quarterly filing deadline.
The report is due on the last day of the month following the end of each calendar quarter. When that date lands on a weekend or legal holiday, the filing is considered timely if postmarked on the next business day. Colorado offers alternative filing methods through its state labor department website, though QuickBooks itself generates the form and populates the majority of the fields based on the payroll data already entered.
What QuickBooks Fills In Automatically
In most cases, if all company setup, payroll items, and employee records are current and complete, QuickBooks will calculate and populate the core wage and tax figures without requiring manual entry. The software walks users through the form window and provides hyperlinks on individual lines so filers can trace where each number originated in their company file.
Despite that automation, several fields demand close attention — particularly those tied to employer identification and wage classification.
Key Lines to Verify
Line 3 — Due Date: This reflects the final postmark date accepted without interest or penalty charges.
Line 4 — FEIN: QuickBooks pulls the nine-digit federal employer identification number the company has registered for unemployment insurance purposes.
Line 5 — Corrected FEIN: If the federal ID number currently in use differs from what appears on the preprinted Form UITR-1 from the state, the correct number must be entered here.
Line 8 — Worker Count: This figure captures all workers who either performed services or received pay subject to unemployment insurance wages during the payroll period that includes the 12th of the month. Employees must be counted here even if their earnings have already exceeded the annual taxable wage ceiling.
Line 9 — Total Wages Paid: QuickBooks reports gross wages that have actually been paid out during the quarter. Wages that are earned or accrued but not yet paid are excluded from this line.
Line 10 — Excess Wages: This represents the portion of each employee’s wages — already included in Line 9 — that surpasses the taxable wage limit for the year.
Line 11 — Taxable Wages: The total taxable wage base for the quarter, derived by subtracting excess wages from total wages paid.
Line 12 — Tax Due: QuickBooks displays the employer’s assigned tax rate alongside the calculated tax amount owed for the quarter.
Interest and Penalty Calculations
Line 13 — Interest: Late payments accrue interest at 1.5 percent per month, or any portion of a month, on taxes paid after the due date. The same rate applies to penalties assessed for late filing.
Line 14 — Penalties: Additional penalties are assessed on each report filed past the deadline, separate from the interest charges on Line 13.
Exporting and Saving the Form
For employers who need to share their payroll data externally or retain a copy of the completed form, QuickBooks offers two built-in options. The form can be saved as a PDF for recordkeeping or electronic submission. Additionally, users can export their payroll data into a Microsoft Excel spreadsheet, which is useful for internal review, reconciliation, or providing summaries to an accountant or bookkeeper before filing.
When Numbers Look Wrong
If a line item appears incorrect or a field was left blank unexpectedly, the most common cause is missing or outdated data in the company file itself. Employee records with incomplete wage details, an incorrect FEIN in company settings, or payroll items mapped to the wrong tax-tracking type can all produce inaccurate figures on the form. Reviewing the hyperlinked breakdowns directly from the form window is the fastest way to identify which underlying transactions feed each line.
For broader payroll reporting guidance and help reconciling wage totals across state forms, the QuickBooks help menu accessible from the form window provides line-by-line context for troubleshooting.