Filing DC Form FR-900B in QuickBooks: What Prefills and What You Must Enter
QuickBooks prefills most of the District of Columbia FR-900B annual withholding reconciliation, but 1099 data and certain lines need manual entry.
QuickBooks Desktop’s built-in payroll forms handle the District of Columbia’s annual Employer Withholding Tax Annual Reconciliation — Form FR-900B — but users working through the form for the first time routinely run into confusion over which fields the software fills automatically and which ones require manual input. The accepted guidance from the community walks through the mechanics, and the short version is this: QuickBooks covers most of the form, but it does not cover everything.
Who Needs to File Electronically
The DC FR-900B is the year-end reconciliation of employer withholding taxes. Employers who file 25 or more W-2 statements are required to submit the form electronically. Additionally, withholding tax payments must be made electronically when the amount due for a period exceeds $5,000. The filing deadline is January 31 of the following year, or within 30 days of the final payroll run if the business has closed or stopped running payroll.
What QuickBooks Fills In
When you open the FR-900B form window inside QuickBooks, most fields are already populated using the payroll data the software has tracked throughout the year. The reconciliation table — which breaks down monthly taxes withheld — is filled in automatically based on W-2 data. Monthly, quarterly, and annual totals are calculated without any user intervention.
Rows in the reconciliation section correspond to the periods in which taxes were actually paid, and only the appropriate rows for the employer’s payment frequency are populated. The totals on the form only account for those correct rows, so accuracy depends on the underlying payroll data being complete and properly mapped.
What You Must Enter Manually
Fields that QuickBooks does not populate are flagged with an alert inside the form window. In most cases, if all company, payroll, and employee data has been entered into QuickBooks throughout the year, the number of manual entries is minimal — sometimes limited to zeros on lines that do not apply.
The biggest gap is 1099 contractor withholding. QuickBooks does not track 1099 information, so any withholding tax associated with 1099 recipients must be entered by hand. This affects two areas of the form:
- The reconciliation table: A separate column exists for 1099 withholding amounts. These figures need to be typed in for each applicable month or quarter.
- Lines 1 through 4 of the summary section: These lines capture total withholding from both W-2s and 1099s — taxes withheld, taxes paid, additional tax due, and any overpayment. Because the 1099 data is manual, the totals on these lines will only be correct if the 1099 amounts were entered on the proper rows in the reconciliation section. Amounts placed on the wrong row will not roll into the totals.
Beyond the dollar figures, the form requires a preparer’s title and telephone number before submission.
Verifying the Numbers
For users who want to confirm that the prefilled amounts match their expectations, QuickBooks provides hyperlinks within the form window that trace each number back to its source in the company file. Clicking these links opens a detail view showing exactly where the calculation originated.
The form window also includes a Help button for general navigation questions and troubleshooting. For employers who prefer to cross-check the data in a spreadsheet, QuickBooks offers a payroll summary export to Microsoft Excel, accessible through a hyperlink on the form screen. And once the form is complete, it can be saved as a PDF for recordkeeping.
A Note on Accuracy
The most common pitfall reported is entering 1099 withholding amounts on the wrong line in the reconciliation table. Because the form’s totals only pull from specific rows, misplaced entries silently produce incorrect totals — the form will not flag the discrepancy. Reviewing each row against actual payment records before filing is the safest approach.
For broader payroll form troubleshooting, including issues with prefilled data not matching year-end totals, the underlying payroll setup is usually the first place to check.