Massachusetts Employers: QuickBooks MA EWD Quarterly Report Explained

QuickBooks Desktop includes a built-in report designed to help Massachusetts employers complete their quarterly unemployment and wage filings. The tool assembles employee wage data, withholding totals, and headcount details into a format that mirrors what the state requires — but the report itself is not a substitute for filing through the state’s online system.

What the Report Covers

The MA EWD — short for Employer’s Quarterly Report of Employment and Wages Paid — gathers data that Massachusetts expects from virtually every employer each quarter. That includes companies subject to unemployment insurance, employers not subject to UI, and reimbursable employers. None are exempt from the filing requirement.

QuickBooks populates the report using the payroll data already entered into the company file. When employee setup, wage details, and company information are complete and current, the report fills itself without additional manual entry. The output includes each employee’s name, Social Security number, gross wages, Massachusetts taxable wages, state withholding, whether the employee worked the 12th of each month, and total hours worked during the quarter.

Filing Rules and Deadlines

Massachusetts does not accept paper submissions of this report. Employers must file electronically through the state’s online unemployment portal. The filing deadline falls on or before the last day of the month following the close of each calendar quarter — meaning April 30 for Q1, July 31 for Q2, October 31 for Q3, and January 31 for Q4.

The QuickBooks report serves as a preparation and verification tool. Employers use it to transcribe data into the state’s system accurately, confirming totals before final submission.

Social Security Numbers Must Be Exact

The report lists each employee’s Social Security number in its first column, and the number must match the employee’s Social Security card exactly. If a number is missing or entered incorrectly, the state will reject the filing.

Employers should verify that every active employee’s Social Security number is correctly entered in the employee setup screen before generating the report. Correcting a number after the fact is straightforward within QuickBooks, but catching errors early prevents filing delays.

Understanding Wage Reporting

Massachusetts defines reportable wages broadly. The state expects employers to include nearly every form of compensation — salaries, commissions, bonuses, and other remuneration — whether paid in cash or in kind. This applies to each employee who worked and was paid during any part of the quarter.

For employees living in Massachusetts, all wages are reportable regardless of where the work was performed. For employees residing outside the state, only wages earned in Massachusetts need to be reported. Wages are reportable even when they are not subject to Massachusetts income tax withholding.

Certain exclusions apply. Non-elective employer contributions to qualified pension plans, employer or employee premiums for accident and health insurance, and group-term life insurance coverage are not counted as reportable wages. Simplified employee pension contributions are also excluded when the employee can claim a federal deduction.

Because Massachusetts uses this specific wage definition, the gross wage figure on the report may differ slightly from other wage totals in QuickBooks. Employers should review the numbers and make minor adjustments if the state’s definition excludes compensation that QuickBooks includes in standard payroll totals.

Using the Verification Totals

QuickBooks provides summary totals alongside the employee wage detail listing. These totals exist strictly for verification — they let employers confirm that each employee’s wage data was entered correctly on the state’s website before the return is submitted.

The recommended workflow is to enter employee data into the state portal, then compare the portal’s running totals against the QuickBooks report. If the numbers match, the data entry was accurate. If they differ, the employer can identify which employee’s figures need correction before finalizing the filing.

Common Sticking Points

The most frequent issues employers encounter stem from incomplete employee records rather than problems with QuickBooks itself. Blank or invalid Social Security numbers will cause rejection. Missing hours-worked data or incorrect state withholding figures can also create discrepancies between the report and what the state expects.

Employers who maintain accurate payroll records throughout the quarter will find that the report generates cleanly and requires minimal adjustment. Those with gaps in employee setup — particularly around new hires or terminated employees mid-quarter — should review the employee list carefully before relying on the report for filing.