Filing Form 941 by Hand After QuickBooks Desktop Payroll Ends

After the payroll service ends, QuickBooks Desktop will no longer prepare or file Form 941; we show how to keep filing your quarterly return on time.

When a QuickBooks Desktop payroll subscription lapses, the company file keeps every paycheck, every withholding, and every wage base it ever recorded. The filing machinery is a different story. The built-in forms feature stops working, and Form 941 becomes a manual task. The data is still there. You only need to know which reports hold which line.

The forms module dies with the payroll subscription

Two separate things stop when the payroll service ends, and it helps to keep them apart. Tax table updates stop, so any paycheck dated after the tables expire is withheld under stale rules. The forms module also shuts off: the quarterly forms, the e-file hand-off, and the deposit reminders all sit behind an active subscription.

Reporting is not affected. QuickBooks calculates each paycheck's withholding and taxable wage bases at the moment the check is saved, and the reports simply add those stored results up. A frozen file will still produce an accurate Payroll Summary for any quarter that was processed while the subscription was live. That is the foundation for everything below.

Where do the numbers live once the file is frozen?

Open the Reports menu and look under Employees & Payroll. Four reports cover almost the whole form:

• Payroll Summary gives gross wages and taxes withheld per employee for any date range.
• Payroll Liability Balances totals what was withheld, by agency and payroll item.
• Payroll Transaction Detail breaks every paycheck into its individual wage and tax lines.
• Payroll Tax Payments lists what you already sent to the IRS, so deposits can be reconciled.

The Liability Balances report carries both the employee and employer sides of each tax, which gives you a cross-check later.

Set the report dates to the quarter, then export each one to Excel or PDF as your working papers. If you want a refresher on filtering or memorizing these reports, our QuickBooks help articles walk through the report screens.

Mapping the report totals to the form's lines

Work down the form from the top.

• Line 1 asks for the number of employees paid in the pay period that includes the 12th of the middle month. Run the Payroll Summary across those few days and count the names.
• Line 2 is total gross wages; the wage columns of the same report add up to it.
• Line 3 is federal income tax withheld, the Federal Withholding item on that report.
• Lines 5a through 5d need taxable wage bases, not gross pay. Social security wages stop at the annual wage base, Medicare wages do not, and the 0.9 percent additional Medicare withholding applies only above $200,000 of annual wages. Expand each tax line on the Payroll Summary, or open the Payroll Item Detail report, to read the wage base QuickBooks stored for each employee.

Multiply each base by the rate the form itself prints, and round every line to whole dollars.

Two jobs QuickBooks used to absorb are now yours. The fractions-of-cents adjustment is the gap between your computed total and what was actually withheld; it is typically small, but it belongs on the return. Tips, group-term life, or third-party sick pay handled outside the file must be added by hand.

Splitting the year into quarters

The 941 follows the calendar quarter, and payroll follows the check date. A weekly run worked in June but dated July 2 lands in the third quarter. Run the reports on check dates rather than work dates, and the quarter split takes care of itself.

Watch the social security wage base late in the year. Stale tax tables can keep withholding past the annual cap, or stop before reaching it, and the year-to-date bases in the Payroll Summary will show it. Check the December pay stubs before you prepare the fourth-quarter return.

The math the forms module used to do for you

With the forms module gone, none of this happens on its own:

• line arithmetic and the quarterly totals carried forward
• deposit reminders keyed to your monthly or semiweekly schedule
• the e-file hand-off
• updated rates, wage caps, and thresholds

So build the quarter as a small close. Total the lines from the reports, then schedule the payment through EFTPS. If your deposit schedule is semiweekly, keep a per-paycheck record of withheld tax, because Schedule B reports each day's liability. If you are not yet enrolled in EFTPS, start early; enrollment is not instant.

The return itself can be filed on paper with the payment voucher, or through an IRS-authorized e-file provider. Before you send it, tie the deposits line to your payment history; a mismatch surfaces later as a penalty notice.

Is the frozen file healthy enough to trust?

Run Verify, under the File menu's Utilities option, before you rely on a frozen file. If the Payroll Summary will not open, totals drift away from last year's filed return, or Verify reports errors, the data may be damaged rather than stale. Our engineers repair exactly this kind of thing; see our QuickBooks company file repair service for what the work involves.

Keep each quarter's exported reports with the filed copy of the return. The next form then takes an hour, not an afternoon.