QuickBooks Payroll Report for New Mexico Form ES903A: What Users Need
QuickBooks prefills most fields on the New Mexico ES903A payroll report, but account number format changes and e-filing rules trip up users preparing quarterly wage submissions.
QuickBooks Desktop includes a built-in payroll report designed to help New Mexico employers complete Form ES903A, the quarterly wage and contribution report required by the state’s Department of Workforce Solutions. The report gathers unemployment insurance wage data, state withholding tax detail, and workers’ compensation fee information so employers can file electronically — but several specifics around account number formatting, payment submission, and field-level data have generated recurring questions among users preparing their quarterly returns.
What the Report Covers
The ES903A report in QuickBooks assembles each employee’s quarterly gross wages, excess wages, state withholding amounts, and workers’ compensation fee data into a format that mirrors what New Mexico requires for electronic filing. QuickBooks populates most fields automatically by pulling from existing company, payroll, and employee records. In a properly maintained file, users typically find that little or no manual entry is needed beyond reviewing the generated figures.
However, the report is informational for filing purposes. Starting with fourth-quarter 2012 returns, New Mexico mandates electronic submission of quarterly wage and contribution reports. The data QuickBooks sends electronically includes the employer state account number, the filing period, and employee wage detail. Payment of any amounts owed must be handled separately through the state’s online filing portal — the report itself does not transmit or remit payment.
Account Number Format Change
One detail that has caught employers off guard involves the state account number format. For third-quarter 2012 reporting and later, New Mexico changed its unemployment insurance account number to an eight-digit format. Existing employers were instructed to keep their current account number but modify it by dropping the final digit and adding two leading zeros. QuickBooks applies this conversion automatically on the form, so the number displayed should reflect the updated format the state’s system expects.
Users who notice a discrepancy between the number on the form and the number on older correspondence with the state should verify that the correct original account number is stored in their QuickBooks company file. The program handles the reformatting from there.
Key Fields and Where the Data Originates
Several fields on the ES903A deserve particular attention when reviewing the report:
Total wages (Line 1): This figure represents the sum of all gross reportable wages paid to employees during the quarter. QuickBooks calculates this from payroll transaction data, so accuracy depends on all payroll being recorded within the company file rather than processed outside the system.
Field code: Assigned by the New Mexico Department of Labor, this code appears on official correspondence from the agency. Users who cannot locate it should check prior filing confirmations or letters from the department.
CRS ID Number: The Combined Reporting System identification number is issued by the New Mexico Taxation and Revenue Department and covers gross receipts, compensation, and state withholding taxes. This is separate from the unemployment insurance account number.
Filing and Payment Are Separate Steps
A point of confusion for some users is that New Mexico requires employers to file separate forms for each tax program — ES903A, WC-1, and CRS-1 — and remit payment for each independently. A single payment covering multiple tax obligations is not accepted. The QuickBooks report helps assemble the ES903A data, but employers remain responsible for ensuring the other forms are completed and submitted through the appropriate channels.
Quarterly wage and contribution reports are due on or before the last day of the month following the end of each calendar quarter. Missing that deadline can trigger penalties from the state, so users should plan to review their QuickBooks data well before the due date to allow time for any corrections.
Reviewing and Correcting the Report
After generating the ES903A report, users should scan every field that QuickBooks did not auto-populate. The most common gaps involve account numbers, field codes, or employee-level wage detail that was not fully entered into payroll during the quarter. If a number on the form looks incorrect, the underlying payroll data in QuickBooks is the first place to check — the report reflects what is recorded in the company file, so discrepancies usually trace back to a missing or misclassified paycheck rather than a calculation error in the report itself.
For users who want to cross-reference the figures or work with the data outside of QuickBooks, the report can be exported to a spreadsheet for further analysis. Saving a copy of the completed form as a PDF is also supported, which provides a record of what was filed and can be useful for the company’s internal archives.
When Numbers Don’t Match
If the unemployment insurance amounts on the ES903A do not align with expectations, the calculation is based on the wage base and rate stored in QuickBooks for the company’s unemployment insurance setup. Employers whose rates change from year to year — which is common based on experience rating — should confirm that the current rate is entered in the payroll setup. An outdated rate will produce incorrect liability figures on the report, even if all individual wage entries are accurate.