QuickBooks and New Mexico Form RPD-41072: What Gets Prefilled
QuickBooks prefills most fields on New Mexico's Annual Summary of Withholding Tax but leaves W-2G and 1099-R totals for manual entry.
QuickBooks Desktop handles New Mexico’s Annual Summary of Withholding Tax — Form RPD-41072 — by prefilling most fields from existing company and payroll data, but employers filing this annual reconciliation need to understand where the software’s calculations stop and manual entry begins.
What Form RPD-41072 Does
New Mexico requires employers, payers, and gambling establishment operators that withhold state income tax from wages, pension or annuity income, or gambling winnings to file Form RPD-41072. The form reconciles the total withholding amounts reported on annual statements furnished to recipients — federal Forms W-2, W-2G, and 1099-R — against the total tax actually withheld and remitted to New Mexico on CRS-1 returns throughout the year. The filing deadline falls on the last day of January following the tax year being reconciled.
An exception exists: if an employer already files Form ES903 with the New Mexico Workforce Solutions Department or Form TRD-31109 with the New Mexico Taxation and Revenue Department, Form RPD-41072 does not need to be submitted. In that situation, employers should retain the completed form in their own records rather than filing it with the state.
How QuickBooks Populates the Form
When you open the form within QuickBooks, most fields carry over automatically from the payroll data already in the company file. The software flags any fields it could not populate with an alert, drawing attention to the specific lines where manual entry is required. In many cases, if all company, payroll, and employee information was current and complete in QuickBooks throughout the year, minimal manual input is needed beyond reviewing the prefilled amounts and entering figures — or zeroes — on the flagged lines.
The W-2G and 1099-R Gap
The most significant limitation involves the count of withholding statements. QuickBooks tracks and calculates only W-2 data natively. The form includes a smart worksheet above Part II where employers can manually add the total number of W-2G and 1099-R statements issued. That manually entered figure gets added to the W-2 count QuickBooks already calculated, producing the combined total reported on Line 1.
The same principle applies to the tax withheld amounts. QuickBooks pulls W-2 withholding totals from payroll data, but amounts withheld on gambling winnings or pension and annuity distributions reported on W-2G and 1099-R forms must be added manually to arrive at the correct reconciliation total.
Filing Frequency
The form requires employers to indicate their filing frequency by checking the appropriate box. QuickBooks does not determine this for you. Employers uncertain about their filing frequency need to contact their local New Mexico district office to confirm before completing the form.
Reviewing and Saving the Completed Form
After reviewing the prefilled data and entering any outstanding amounts, employers can save a copy of the completed payroll form. QuickBooks provides options for saving the form as a PDF for recordkeeping or submission purposes.
For general guidance on navigating the form window or troubleshooting specific display issues, the in-product Help button on the form screen offers context-sensitive assistance. Employers who want to trace specific numbers back to their source transactions within QuickBooks can use the hyperlinks provided within the form interface to see how each figure was derived.
Key Takeaway
The form largely works as intended for W-2-only filers — nearly everything populates automatically. Employers who also issue W-2G or 1099-R statements, though, should plan to gather those figures separately before starting the form, since QuickBooks will not include them in its automatic calculations.