QuickBooks Prefill Gaps on Colorado Form DR 1093 Leave Users Searching

QuickBooks Desktop’s built-in payroll forms are designed to prefill most state filing documents automatically, but users preparing Colorado Form DR 1093 — the Annual Transmittal of State W-2 Forms — have found that several fields require manual attention before the return is ready to submit.

What the Form Covers

Form DR 1093 is the transmittal sheet that accompanies the state copy of W-2s submitted to the Colorado Department of Revenue. For active withholding accounts, it is due on the last day of January following the calendar year in which withholdings occurred. When that deadline lands on a weekend or holiday, the filing date shifts to the next business day. Businesses that have closed their accounts face a tighter window: the form must be submitted within 30 days of closure.

One detail that has caused confusion among filers: if W-2s are filed electronically, the transmittal form itself is only required when there is a balance due or an overpayment. In cases where those conditions do not apply, submitting the paper form is unnecessary.

Where QuickBooks Fills In the Blanks — and Where It Doesn’t

QuickBooks populates the majority of fields on DR 1093 using existing company, payroll, and employee data. In an ideal scenario — one where all records are current and complete — no additional entry should be needed. In practice, however, users have reported needing to review and manually complete fields the software left blank.

The account number field illustrates the kind of formatting quirk that can trip up filers. QuickBooks generates this field automatically, and it must be exactly eight digits. If a business’s account number uses the hyphenated format — two digits, a dash, followed by five digits — QuickBooks strips the dash and prepends a zero, producing an unbroken eight-digit string. Users who manually override this field or expect the dash to carry through will run into formatting mismatches.

Fields That Always Require User Attention

Several entries on DR 1093 fall outside what QuickBooks can derive from payroll data:

Amended returns. QuickBooks does not support filing amended versions of this form. Colorado requires a separate amended return for each period, and it must reflect all corrected tax figures in full — not just the differences. The amended filing replaces the original entirely. Users needing to correct a previously submitted form must handle that process outside of QuickBooks.

Social security numbers. If a federal employer identification number is unavailable, the company officer’s SSN should be entered instead. QuickBooks cannot make this determination automatically.

Penalty calculations. Late filers must compute and enter penalties manually. The structure is straightforward but unforgiving: 5% of the tax due or $5.00, whichever is greater, applies to any payment made after the deadline. An additional half-percent accrues for each month the filing remains outstanding, capped at 12% of the total tax due.

Interest. Filers submitting after the due date must calculate interest on the outstanding balance at the current statutory rate and enter that figure on the form.

Verifying the Numbers

For users who want to confirm that QuickBooks pulled the correct withholding figures, the form window includes hyperlinks that trace each amount back to its source within the company file. Clicking those links opens the underlying payroll data so filers can cross-check the totals before submitting.

QuickBooks also offers options to export summarized payroll data to Excel for independent review and to save a completed copy of the form as a PDF for recordkeeping. Both steps are worth taking before filing, particularly when manual entries are involved.

A Note on Related Filings

Form DR 1106 — not DR 1093 — is the correct transmittal for state copies of 1099 forms. Users who handle both W-2 and 1099 reporting should confirm they are working with the right document before submitting, since QuickBooks lists both in its payroll forms inventory.

The broader takeaway for anyone preparing Colorado state filings in QuickBooks is that the software handles the heavy lifting on data entry but leaves penalty, interest, amendment, and edge-case identifier fields entirely to the user. Reviewing every field — not just the ones QuickBooks flagged — is the safest path to an accurate filing.