Quickbooky

Accounting News

Payroll

Form 941 Line 13 Discrepancies in QuickBooks Payroll

QuickBooks users reviewing Form 941 Page 2 may find Line 13 deposit totals incomplete when prior overpayments or CARES Act deferrals are involved.

Form 941 Line 13 Discrepancies in QuickBooks Payroll

QuickBooks Desktop automates most of Form 941, the Employer’s Quarterly Federal Tax Return, but Page 2 has become a recurring source of confusion for payroll administrators — particularly around Line 13, where total quarterly deposits are reported. The issue centers on what QuickBooks includes automatically, what it leaves out, and how to verify the numbers when they do not match expectations.

What QuickBooks Fills In Automatically

When generating Form 941, QuickBooks prefills the majority of fields using existing company, payroll, and employee data. In most cases where all records are current and complete, no manual entry is needed. The problem arises when users assume that prefilling means complete — and Line 13 is where that assumption breaks down.

Line 13a: Total Deposits for the Quarter

Line 13a pulls the sum of all payroll liability payments processed for the quarter across several specific payroll categories. These include federal withholding, Medicare company and employee taxes, Social Security company and employee taxes, and Medicare employee additional tax. It also accounts for certain credit-related adjustments that reduce deposit amounts, including COBRA subsidy credits, national paid leave credits, CARES retention credits, and CARES FICA-employer deferrals.

The critical gap: QuickBooks does not automatically carry over overpayments from a previous period. If an employer overpaid in a prior quarter and expects that surplus to apply to the current quarter’s deposit total, that amount will not appear on Line 13a without manual intervention. Users must add the overpayment amount to the figure QuickBooks displays.

Verifying Liability Payments

To audit the numbers feeding into Line 13a, QuickBooks offers a dedicated reporting tool. The Payroll Item Detail report shows all payroll transactions across every defined payroll item. Users can access it through the Reports menu by selecting Employees & Payroll, then Payroll Item Detail. Adjusting the date range to match the relevant quarter allows administrators to identify every payroll liability check tied to the applicable tax categories.

One important note from the community guidance: amounts deferred under the employer share of Social Security tax should not be included in Line 13a totals. The same applies to deposit reductions made in anticipation of qualified sick and family leave wage credits or employee retention credits. Including those amounts would inflate the reported deposits and create a filing mismatch.

Line 13b: Deferred Employer Social Security Tax

Line 13b addresses a more specialized scenario — the deferred portion of the employer’s Social Security tax under CARES Act provisions. QuickBooks calculates this figure using liability adjustment payroll items categorized under Other Tax, specifically the CARES Company Social Security Deferral item.

Verification here requires a different report. The Payroll Item Listing report displays all defined payroll items along with their assigned tax tracking types. Users can run it from the Reports menu under Employees & Payroll. This report helps confirm that the correct tracking type is assigned to each item, which directly affects whether the deferred amount flows properly to Line 13b.

When Numbers Do Not Match

The most common symptom users report is a mismatch between what they believe was deposited and what QuickBooks shows on Line 13. In nearly every documented case, the discrepancy traces back to one of three causes: an unapplied overpayment from a prior period, a deferred tax amount that was either included or excluded incorrectly, or a payroll item assigned the wrong tax tracking type.

For broader payroll troubleshooting, the recommended first step is always running the relevant detail or listing report before adjusting any figures on the form itself. QuickBooks also provides in-context help through the Help button on the form window, which can trace specific numbers back to their source transactions.

The Bottom Line for Payroll Administrators

Form 941 Page 2 functions correctly in QuickBooks when all payroll items are properly categorized and when users understand which amounts the software includes versus excludes by default. The prefill feature handles standard scenarios well, but prior-period overpayments and CARES Act deferrals require manual review. Running the Payroll Item Detail and Payroll Item Listing reports before filing remains the most reliable way to catch discrepancies before they reach the IRS.

← Back to Community Issues