QuickBooks Form 941: Summarizing Payroll Data, Exporting to Excel, and E-Filing

QuickBooks Desktop users preparing Form 941 — the Employer’s Quarterly Federal Tax Return — routinely ask how to summarize their payroll data in Microsoft Excel, save a copy of the completed form, and submit it electronically. QuickBooks prefills the majority of Form 941 fields from existing company, payroll, and employee records, but several manual steps remain.

What QuickBooks Fills In Automatically

When you open Form 941 inside QuickBooks, the software populates most fields using payroll data already tracked throughout the quarter. In most cases, if all compensation, withholding, and employee information has been entered consistently into QuickBooks, minimal manual input is required. However, users should carefully review every field the software did not populate and complete those entries before filing.

How to Summarize Payroll Data in Microsoft Excel

To export your payroll data into a spreadsheet for review or record-keeping, follow these steps:

1. Open QuickBooks Desktop and navigate to the Employees menu.
2. Select Payroll Tax Forms & W-2s, then choose Process Payroll Forms.
3. Select Form 941 and the applicable quarter.
4. Once the form opens, click the Export button (or look for an export option in the form toolbar).
5. Choose Export to Excel or New Excel Workbook depending on your version.
6. QuickBooks will generate a spreadsheet containing the wage, tax, and withholding figures mapped to the corresponding Form 941 lines.

This export gives you a line-by-line payroll summary you can review, share with an accountant, or archive outside of QuickBooks. For broader QuickBooks Desktop troubleshooting related to payroll forms, our general QuickBooks help resources cover common issues.

Key Line-Item Mappings on Form 941

Understanding where QuickBooks draws its numbers helps verify accuracy:

Line 1 — Number of Employees: This is the count of employees who received wages, tips, or other compensation during the pay period that includes the 12th day of the final month of each quarter — March 12 for Q1, June 12 for Q2, September 12 for Q3, and December 12 for Q4.

Line 2 — Wages, Tips, and Other Compensation: QuickBooks sums all payroll items assigned the following tax tracking types: Compensation, Reported Tips, SEC 457 Distribution, Non-qual. Plan Distr, Fringe Benefits, Other Moving Expenses, Taxable Grp Trm Life, SCorp Pd Med Premium, and HSA Co. (Taxable). The total is then reduced by specific deductions tied to qualifying payroll items.

How to Save a Copy of Your Payroll Form

Saving a copy of Form 941 for your records is straightforward:

1. With the completed form open in QuickBooks, click File in the top menu.
2. Select Save As PDF (or Print, then choose a PDF printer if your version lacks a direct save option).
3. Choose a destination folder on your computer or network.
4. Name the file descriptively — including the form type and quarter — and save it.

Retaining a PDF copy ensures you have an accessible record of each quarterly filing without needing to reopen the form inside QuickBooks.

How to E-File and E-Pay Through QuickBooks

QuickBooks supports electronic filing and payment of Form 941 through its built-in E-File & E-Pay feature, provided your payroll service subscription and enrollment status are active.

To e-file Form 941:

1. Complete and review the form in the QuickBooks payroll form window.
2. Click Submit or E-File (the button label varies by version and payroll service level).
3. Follow the on-screen prompts to confirm your filing details.
4. Enter your IRS e-file PIN when prompted.
5. QuickBooks transmits the return electronically and displays a confirmation when the IRS accepts it.

To e-pay the associated liability:

1. Open the Pay Scheduled Liabilities section in the Payroll Center.
2. Select the federal tax liability tied to Form 941.
3. Click E-Pay and verify the payment amount, date, and bank account.
4. Submit the payment electronically.

Enrollment in the IRS Electronic Federal Tax Payment System (EFTPS) is required for e-pay. If you have not enrolled, you will need to complete that process before QuickBooks can submit payments on your behalf. For step-by-step guidance on QuickBooks payroll features, our practical QuickBooks tips and troubleshooting guides walk through common payroll tasks.

Reviewing Unfilled Fields

If QuickBooks left certain fields blank, click the Help button within the form window itself. QuickBooks provides context-specific guidance explaining where each number originates and what to enter in fields that require manual input. This in-product help is the fastest way to trace a figure back to its source transaction or payroll item.

Current Tax Rates to Verify

While QuickBooks applies current rates automatically, users should verify that the correct percentages appear on the form. The employee and employer Social Security tax rate stands at 6.2% each, and the Medicare tax rate is 1.45% for both. There is no wage base limit on Medicare tax. Employers must also withhold an Additional Medicare Tax of 0.9% on wages exceeding $200,000 in a calendar year — this portion is employee-only, with no matching employer contribution.