Massachusetts Quarterly Wage Report in QuickBooks: Filing and Verification
QuickBooks prefills the MA Employer's Quarterly Report of Employment and Wages, but Massachusetts requires electronic filing through the DUA Quest portal.
QuickBooks Desktop users responsible for Massachusetts payroll compliance have access to a built-in report designed specifically for the state’s quarterly wage filing. The report — formally labeled the MA EWD, or Employer’s Quarterly Report of Employment and Wages Paid — generates a detailed employee-by-employee breakdown that mirrors what the state requires. But the report itself is not a filing mechanism, and misunderstanding that distinction can lead to missed deadlines or rejected submissions.
What the Report Covers
The MA EWD report assembles each employee’s Social Security number, gross wages paid, Massachusetts taxable wages, withholding, 12th-of-the-month headcount, and hours worked during the quarter. QuickBooks populates these fields automatically from existing payroll data, meaning that if all company, payroll, and employee records are current and accurate inside QuickBooks, no manual data entry should be necessary on the form itself.
The report is due on or before the last day of the month following the close of each calendar quarter.
Massachusetts Requires Electronic Filing
The critical detail for employers is that Massachusetts does not accept paper filings of this report. All employers — whether subject to unemployment insurance, not subject to UI, or classified as reimbursable — must file electronically through the state’s portal at mass.gov/dua/quest.
QuickBooks generates the data. The state’s website is where the actual filing happens. Users who attempt to paper-file will find the submission rejected.
Using the Report for Verification
The real value of the QuickBooks-generated report lies in verification. After entering employee wage details on the DUA Quest website but before submitting the return, the report’s totals allow you to confirm that every figure was transcribed correctly. These totals exist strictly as a cross-check — they are not submitted to the state themselves.
Common Data Issues
Several fields require particular attention because QuickBooks may not handle every nuance of Massachusetts definitions automatically.
Social Security Numbers
The report requires each employee’s Social Security number to appear exactly as printed on their Social Security card. Blank or invalid numbers will cause the filing to be rejected. These numbers are managed in the employee setup section of QuickBooks, so any discrepancies must be corrected there before generating the report.
Wage Definitions
Massachusetts defines reportable wages differently than standard payroll categories might suggest. Gross wages must be reported for each employee who resides in Massachusetts, regardless of where the work was performed. For employees living outside Massachusetts, only wages earned in-state are reportable. Wages are reportable even when they are not subject to Massachusetts withholding or income tax. Because of these specific definitions, the gross wage figure on the report may require minor adjustments before it accurately reflects what Massachusetts expects.
Where to Look for Help
For fields that QuickBooks does not fill in automatically, the report window’s built-in help provides field-level guidance. The same help resources cover general form-window usage and troubleshooting — including tracing specific numbers back to their source within QuickBooks payroll data.
Users can also summarize payroll data in Microsoft Excel for additional analysis or save a copy of the completed form for internal records before moving the figures to the state’s electronic filing portal.