QuickBooks and New Mexico Form 41072: What Gets Prefilled and What You Must Enter
QuickBooks prefills most of New Mexico's Annual Summary of Withholding Tax Report, but W-2G and 1099-R amounts require manual entry. Here is how the form works.
QuickBooks Desktop handles most of the heavy lifting for New Mexico employers filing Form RPD-41072, the Annual Summary of Withholding Tax for CRS-1 Filers — but the software’s automation has clear boundaries that filers need to understand before submitting.
Form 41072 is the reconciliation return that New Mexico requires from any employer, payer, or gambling establishment operator who withholds state income tax from wages, pension or annuity income, or gambling winnings. The form reconciles the total withholding amounts shown on annual statements — federal Forms W-2, W-2G, and 1099-R — against the total tax actually withheld and paid to New Mexico on CRS-1 returns throughout the year. The filing deadline falls on the last day of February each year.
What QuickBooks Fills In Automatically
For most users, the experience of opening Form 41072 in QuickBooks is straightforward. The software prefills the majority of fields using the payroll and company data already stored in the file. Users are instructed to review the fields that QuickBooks did not populate automatically and enter any missing information. In the typical scenario — where all company, payroll, and employee data lives inside QuickBooks — little or no manual data entry is needed beyond that review.
Fields flagged by an on-screen alert are the ones that require attention. Users should enter the appropriate amounts, or zeroes where applicable, on those flagged lines.
The W-2G and 1099-R Gap
The most important limitation to be aware of involves gambling winnings and retirement income. QuickBooks only tracks and calculates W-2 data natively. The software does not automatically account for state income tax withheld on Form W-2G (gambling winnings) or Form 1099-R (pensions and annuities) if those were handled outside of QuickBooks.
This affects two specific areas of the form:
Number of forms filed. The line for the total count of W-2s, W-2Gs, and 1099s does not capture the latter two form types automatically. Users must manually add the number of W-2G and 1099-R statements to the smart worksheet located above Part II. The figure entered there carries forward and is added to Line 1.
Tax withheld amounts. If state income tax was withheld on W-2G or 1099-R statements outside of QuickBooks, those amounts will not appear in the monthly columns in Part II. Users must enter the amount withheld for each month manually in that section.
Fields You Can Override
The tax withheld and reported on Form CRS-1 is another field QuickBooks prefills automatically. However, the software treats this as editable — users can modify the figure if the prefilled number does not match their records. This flexibility matters for filers who need to correct or adjust the reconciled total before submission.
Filing Frequency and Other Details
The form includes a filing frequency selection. Users should check the appropriate box; those unsure of their filing frequency are directed to contact their local district office for clarification.
For filers who need to dig deeper into where specific numbers originated, QuickBooks provides a hyperlink within the form window that traces amounts back to their source data in the company file. The built-in Help button on the form window offers general guidance on navigating the form and troubleshooting specific issues.
Adjacent Tasks
The form’s help resources also point to two related capabilities that filers may need at year-end. Users can summarize their payroll data in Microsoft Excel for additional analysis or record-keeping. QuickBooks also supports saving a completed copy of the payroll form as a PDF, which is useful for archival or for sharing with an accountant.
The Bottom Line
Form 41072 is one of the more automated state payroll forms available in QuickBooks, but the W-2G and 1099-R gap is a real stumbling block. Filers who withhold New Mexico tax on gambling winnings or retirement distributions should not assume the prefilled totals are complete — those amounts need manual entry in both the form count and the monthly withholding columns before the return is ready to file.