Summarizing Form 944 Payroll Data in QuickBooks Desktop
QuickBooks Desktop users filing Form 944 can summarize annual payroll data for Excel export using built-in payroll reports and form workflows.
QuickBooks Desktop users who file IRS Form 944 — the Employer’s Annual Federal Tax Return — frequently need to export their summarized payroll data into Microsoft Excel for recordkeeping, accountant review, or reconciliation. The question of how to pull that data together, save a copy of the filed form, and handle electronic filing and payment comes up regularly among small employers assigned to the annual 944 schedule rather than the quarterly 941.
Who Files Form 944 in QuickBooks
Form 944 is filed annually by employers whose total annual liability for social security, Medicare, and withheld federal income tax is $1,000 or less. The IRS notifies eligible employers in writing that they qualify for the annual filing schedule. QuickBooks Desktop supports Form 944 preparation and e-filing within its payroll module, though the form only appears for companies set up on the annual filing preference.
The filing deadline is January 31 following the close of the calendar year. When that date falls on a weekend or federal holiday, the deadline shifts to the next business day.
Summarizing Payroll Data for Excel Export
To pull a summary of payroll data tied to Form 944 in QuickBooks Desktop, navigate to the payroll form workflow. Open the Employees menu, select Payroll Forms, then Process Payroll Forms. Select Form 944 from the list of available forms and choose the applicable tax year.
Once the form opens and populates, the summarized wage and tax figures — including total wages, federal income tax withheld, social security wages, and Medicare wages — are displayed line by line. To export this data to Excel, click the Export button within the form window. QuickBooks generates a formatted spreadsheet containing the form’s line items and calculated totals. This file can then be saved, printed, or shared with an accountant for verification before the return is submitted.
For broader payroll summaries beyond the form itself — such as wage breakdowns by employee or earnings by payroll item — the Payroll Summary report (accessible via Reports > Employees & Payroll > Payroll Summary) provides additional detail and can also be exported to Excel using the Export button at the top of the report window.
Saving a Copy of the Filed Form
After reviewing the populated Form 944 and confirming the figures, users can save a copy for their records. Within the form window, click Save as PDF or use the Print option and select a PDF writer as the destination. The saved copy captures the form exactly as it was submitted, including all calculated totals and any payment voucher information if a balance due exists.
QuickBooks also retains a record of filed forms within the company file. To review previously filed forms, return to Employees > Payroll Forms > Process Payroll Forms and select Previously Filed Forms from the filter options.
E-Filing and E-Paying Through QuickBooks
QuickBooks Desktop supports electronic filing of Form 944 through the E-File button available within the form window. Selecting this option walks the user through submitting the return directly to the IRS from within QuickBooks, provided the payroll service tier includes e-filing capabilities and the user has an active EIN and payroll PIN registered with the IRS.
For electronic payment of any balance due, QuickBooks offers E-Pay functionality. When enabled, users can authorize an electronic funds withdrawal from a designated bank account at the time of e-filing. The payment is scheduled to coincide with the filing date or a user-selected payment date. To set up E-Pay for the first time, navigate to Employees > Payroll Setup, locate the Federal payment method under the tax agency list, and configure the bank account and payment instructions.
If a balance due cannot be paid in full, the IRS offers an Online Payment Agreement application through IRS.gov for taxpayers owing $25,000 or less who can satisfy the liability within 24 months. Fees and interest apply to installment agreements.
Common Sticking Points
Users occasionally report that Form 944 does not appear in their available forms list. This typically indicates that the company file is still set to the quarterly 941 schedule. The filing frequency is assigned by the IRS, and QuickBooks must be configured to match the agency’s notification. Adjusting the filing frequency requires updating the federal tax setup under Employees > Payroll Setup > Federal Taxes > Filing Frequency.
Another recurring issue involves mismatched totals between the Payroll Summary report and the Form 944 itself. Discrepancies usually stem from wage adjustments, manual check entries, or year-end adjustments that post after the form was generated. Re-running the form after all adjustments are entered typically resolves the variance.
For users managing payroll on unsupported or discontinued QuickBooks versions, perpetual options exist for keeping Desktop payroll functions operational without forced upgrades.