QuickBooks Payroll Summary for Form 944: Exporting Data to Excel
QuickBooks desktop users preparing IRS Form 944 can export annual payroll summaries to Excel using built-in reporting tools for reconciliation.
QuickBooks users tasked with filing IRS Form 944 — the Employer’s Annual Federal Tax Return — frequently need to extract and summarize their annual payroll data into Microsoft Excel for reconciliation before filing. The challenge centers on locating the right built-in report and formatting it to mirror the lines on the federal form.
Who Needs Form 944
Form 944 is not universal. The IRS designates this annual return only for employers whose annual liability for social security, Medicare, and federal income tax withholding totals $1,000 or less for the year. If the IRS has not sent written notification directing an employer to file Form 944, that employer must file the quarterly Form 941 instead. Once notified, the employer must file Form 944 every year — even in years with no taxes to report — until the IRS changes the filing requirement or a final return is filed.
The annual deadline is January 31 following the close of the calendar year. If that date falls on a weekend or legal holiday, the deadline shifts to the next business day.
Generating the Payroll Summary in QuickBooks
To pull the data needed for Form 944 from QuickBooks Desktop, navigate to the Employees menu, select Payroll Center, then click the Reports tab. From there, choose Payroll Summary. Set the date range to cover the full calendar year (January 1 through December 31). The summary breaks down gross wages, federal withholding, social security wages and tax, Medicare wages and tax, and employer-matched liabilities — the figures that map directly onto Form 944 lines.
For QuickBooks Online Payroll users, the path differs: go to Reports, search for Payroll Summary, set the date range to the full year, and customize the columns to display both employee and employer tax portions. Once the report displays the needed columns, click Export to Excel to generate a working spreadsheet.
Reconciling Against Form 944 Lines
The exported Excel file lets you cross-check each QuickBooks payroll item against the corresponding line on Form 944. Key reconciliations include total employee compensation (which maps to wages and tips), federal income tax withheld, the employee and employer shares of social security tax, and the employee and employer shares of Medicare tax. Social security tax applies up to an annual wage base limit that the IRS adjusts periodically; Medicare tax has no wage cap. Users should verify the current year’s tax rates and wage base on the IRS Form 944 instructions rather than relying on figures from prior years, as these numbers change.
E-Filing and E-Paying Through QuickBooks
QuickBooks Enhanced Payroll and Full Service Payroll subscribers can e-file Form 944 directly from the software. In QuickBooks Desktop, go to the Employees menu, select Payroll Tax Forms & W-2s, then Process Payroll Forms. Select Annual Form 944 from the list of available federal forms. The guided interview walks through each line, pulling data from the payroll summary already in the file. Before submitting, review every line for accuracy — especially if manual payroll adjustments or third-party payments were made during the year.
For e-payment of any balance due, QuickBooks supports electronic funds withdrawal as part of the e-file process. Users enrolled in the IRS Electronic Federal Tax Payment System (EFTPS) can also schedule payments independently through the EFTPS website.
Saving a Copy of the Filed Form
After e-filing or printing Form 944, QuickBooks saves a PDF copy in the Saved PDFs folder within the QuickBooks installation directory by default. Users can also save a copy to any location by selecting Save as PDF during the print or file workflow. Keeping this archived copy is essential for audit trails and for reference when filing amended returns.
Filing an Amended Return
If an error is discovered after filing, use Form 944-X — Adjusted Employer’s Annual Federal Tax Return or Claim for Refund. The IRS instructs employers to file the original Form 944 first, then file Form 944-X separately. Filing both at the same time can trigger processing delays.
Installment Agreements for Balances Due
Employers who owe when filing may qualify for an online installment agreement through the IRS, provided the total owed is $25,000 or less and the liability can be paid within 24 months. Applications are submitted through the IRS website under the Online Payment Agreement tool. Fees and interest apply to unpaid balances.