Filing Colorado Form UITR-1 in QuickBooks: What Each Field Means
QuickBooks prefills most of Colorado's quarterly unemployment wage report, but users still need to verify FEIN, wage totals, and excess calculations before filing.
Colorado employers who process payroll through QuickBooks Desktop are responsible for filing Form UITR-1 — the Quarterly Report of Wages Paid and Premiums Owed — with the state’s department of labor. The form 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. While QuickBooks automatically populates most of the form using the payroll data already entered throughout the quarter, employers frequently run into confusion about which fields require manual review and how the underlying dollar amounts are derived.
Accessing the Form
To open the UITR-1 inside QuickBooks Desktop, navigate to the Employees menu, select Payroll Forms, and choose Process Payroll Forms. From the list of available forms, select the Colorado UITR-1. QuickBooks will pull data from your active company file and attempt to prefill the relevant wage and tax fields. Before printing or saving the form, review every field manually. In most cases, if all company setup, employee profile, and paycheck data has been entered correctly throughout the quarter, no additional manual input is required. However, gaps in payroll setup — such as missing state withholding IDs or incorrect unemployment tax rates — will result in blank or incorrect fields.
Understanding the Prefilled Fields
QuickBooks maps your payroll data to specific lines on the UITR-1. Knowing where those numbers originate helps you verify accuracy before submitting the report to the state.
Report and Payment Due Date
This reflects the final acceptable postmark date. Filing or paying after this date triggers interest and penalty charges.
FEIN and Corrected FEIN
The nine-digit Federal Employer Identification Number registered with Colorado for unemployment insurance purposes appears here. If the number currently on file in QuickBooks differs from the one the state has assigned, enter the correct FEIN on the designated line rather than overwriting the original field.
Payroll Includes 12th of the Month
This count represents all workers who performed labor or received pay subject to unemployment insurance during the payroll period that includes the 12th day of the month. Employers must include these workers even if their earnings have already surpassed the annual taxable wage ceiling. This is one of the most commonly misreported fields, because users often assume employees over the wage base should be excluded.
Total Wages Paid
QuickBooks reports gross wages that have actually been paid during the quarter. Wages that are earned or accrued but not yet paid are excluded from this total, which can cause discrepancies if a business runs accrual-basis reporting alongside cash-basis payroll.
Excess Wages
This figure captures the portion of each employee’s earnings that exceeds Colorado’s annual taxable wage limit. QuickBooks calculates this automatically based on the wage base configured in your state unemployment insurance setup. If the wage base in your company file is outdated or was never updated for the current tax year, this number will be wrong.
Taxable Wages
This is the total wage amount subject to unemployment tax for the quarter — essentially total wages minus excess wages.
Tax Due, Interest, and Penalties
QuickBooks applies your assigned tax rate to the taxable wage total to show the amount owed. Interest accrues at 1.5 percent per month, or any portion of a month, on taxes paid after the deadline. Additional penalties apply for late filing.
Troubleshooting and Exporting Data
If the numbers on the form do not match your expectations, use the in-product help available directly from the form window. QuickBooks provides hyperlinks within the UITR-1 view that trace each figure back to its source data in your company file, making it easier to identify whether a discrepancy stems from a misclassified paycheck or an incorrect rate. For employers who prefer to work outside QuickBooks, the software can summarize payroll data into a Microsoft Excel spreadsheet, and the completed form can be saved as a PDF for your records or for alternative filing methods such as electronic file transfer through Colorado’s online portal.
For broader help with QuickBooks payroll forms and reporting workflows, including resolving prefilled data errors and verifying state tax setups, additional troubleshooting resources are available across our network.