QuickBooks and New Mexico Form RPD-41072: Filling the Gaps QuickBooks Leaves Blank
QuickBooks prefills most of New Mexico's Annual Summary of Withholding Tax, but W-2G and 1099-R data requires manual entry. Here is what users need to know.
New Mexico employers who withhold state income tax face an annual reconciliation task that QuickBooks partially automates but does not fully complete. Form RPD-41072, the Annual Summary of Withholding Tax, is used to reconcile the total withholding shown on federal statements — W-2s, W-2Gs, and 1099-Rs — against the tax actually remitted to the state throughout the year on CRS-1 returns or related payment forms. QuickBooks Desktop handles a significant portion of this form automatically, but users have consistently run into confusion around the fields the software leaves blank and the manual steps required to produce an accurate filing.
What QuickBooks Fills In Automatically
When a user opens Form RPD-41072 within QuickBooks, most fields arrive prefilled with data drawn from the company file. The software pulls from existing payroll setup, employee records, and prior-period withholding remittances to populate the core reconciliation figures. In an ideal scenario — one where all company, payroll, and employee data has been entered and maintained correctly throughout the year — the form may require little to no additional input beyond reviewing what QuickBooks has generated.
The software flags fields that still need attention with on-screen alerts. Users should scan for those flags and focus their effort there rather than re-checking every line.
The W-2G and 1099-R Gap
The most common stumbling block involves gambling establishments, pension payers, and others who issue W-2G or 1099-R statements alongside standard W-2s. QuickBooks only tracks and calculates W-2 data natively. It does not automatically count W-2G or 1099-R forms, nor does it pull withholding amounts associated with those statement types into the form.
This affects two specific areas on the return:
Number of statements filed. The line asking for the total count of W-2s, W-2Gs, and 1099-Rs will reflect only W-2s unless the user intervenes. To correct this, users must navigate to the smart worksheet located above Part II on the form and manually enter the count of W-2G and 1099-R statements. QuickBooks then adds those manual entries to its W-2 count and carries the combined total to Line 1.
Tax withheld amounts. Similarly, withholding totals tied to W-2G and 1099-R distributions are not pulled in automatically. Users must review the amounts QuickBooks did not fill in and enter the correct figures — or enter zero where applicable — on the flagged lines.
Failing to account for these manual entries produces a reconciliation mismatch between what was reported to recipients and what was paid to the state, which is precisely the error Form RPD-41072 exists to catch.
Filing Frequency and Other Manual Fields
The filing frequency box on the form must be checked manually. QuickBooks does not determine this automatically; it depends on the employer’s assigned reporting schedule with the state.
When the Form Is Not Required
Not every employer who withholds New Mexico income tax needs to submit RPD-41072 to the Taxation and Revenue Department. If a business already files the ES903 wage and contribution report with New Mexico Workforce Solutions, or files Form TRD-31109 with TRD, the annual summary does not need to be transmitted. In those cases the form should still be completed and retained in the employer’s own records.
The standard filing deadline for RPD-41072 is the last day of January following the close of the tax year.
Practical Steps for a Clean Filing
Users preparing this form in QuickBooks should take a methodical approach. Start by confirming that all W-2 data has been finalized for the year. Then gather any W-2G and 1099-R statements issued during the same period. Open the form and let QuickBooks prefill what it can. Work through each field flagged with an alert, paying particular attention to the smart worksheet above Part II where supplemental statement counts and withholding amounts belong.
For users who want to cross-reference the figures before filing, QuickBooks offers options to summarize payroll data for review in a spreadsheet and to save a copy of the completed form as a PDF for recordkeeping. Both functions are accessible from within the form window.
The core takeaway: QuickBooks handles the W-2 reconciliation competently, but anyone issuing W-2Gs or 1099-Rs in New Mexico should expect to complete portions of this form by hand. Knowing where those gaps exist — and entering the correct figures on the flagged lines — is what separates a clean filing from a rejected one.