Worksheet 1 Credit for Sick, Family Leave & Employee Retention Wages in QuickBooks

QuickBooks Desktop users responsible for filing Form 941 have at times needed clarity on how Worksheet 1 — the worksheet covering credits for qualified sick and family leave wages as well as the employee retention credit — arrives at its figures. While QuickBooks prefillls most of the worksheet automatically, certain fields draw from specific payroll data, and understanding those connections matters when reviewing a return before filing.

What QuickBooks Fills Automatically

In most situations, QuickBooks populates Worksheet 1 using the company, payroll, and employee data already stored in the company file. When all relevant payroll items are set up correctly and employee records are current, the worksheet requires little to no manual entry. The challenge arises when a user needs to verify where a specific number originated or when a field appears blank unexpectedly.

Fields That Pull From the Interview Worksheet

Several Worksheet 1 lines connect directly to the 941/Schedule B Interview Worksheet rather than pulling from standalone payroll items. Specifically, the credit from Form 5884-C (line 11) and the qualified health plan expenses allocated to both sick leave wages and family leave wages all flow from that interview worksheet. Users reviewing those amounts should check the interview worksheet entries rather than expecting to trace them through individual paycheck details.

Calculated Fields for Excess Wages

Two fields on Worksheet 1 represent calculated subtractions rather than direct data pullls. Excess qualified sick leave wages are determined by subtracting line 2a from the total qualified sick leave wages paid. Similarly, excess qualified family leave wages are calculated by subtracting line 2e from total qualified family leave wages paid. These are internal worksheet calculations — QuickBooks performs the math based on amounts entered or pulled elsewhere on the form.

Verifying Employee Retention Credit Wages

The qualified wages figure for the employee retention credit represents the sum of all QuickBooks payroll items assigned the CARES Retention Credit tax-tracking type. If that number looks off, the fastest way to confirm it is through the Payroll Item Listing report.

To run that report, open the Reports menu, select Employees & Payroll, and choose Payroll Item Listing. The report shows every defined payroll item along with its assigned tax-tracking type, making it possible to identify exactly which items feed into the retention credit calculation on line 5a(i).

Cross-Checking With the Payroll Summary Report

For a second layer of verification, the Payroll Summary report lets users review actual wage amounts for the filing period in question. Access it through the same Reports menu under Employees & Payroll, then select Payroll Summary. Adjust the date range to match the Form 941 quarter, and if needed, filter the report to display only the relevant payroll items. This is also the report to use when checking amounts tied to the Reported Tips tax-tracking type.

A Note on Tax-Year Context

The sick leave, family leave, and employee retention credit provisions originated under pandemic-era legislation, and the IRS reporting requirements around them have shifted across tax years. QuickBooks continues to include Worksheet 1 as part of the Form 941 workflow, but users should confirm which credits still apply to their current filing period. A figure that prefillls correctly in one quarter may not be relevant in another if the underlying credit has expired or changed. When a worksheet line populates unexpectedly, verifying the applicable tax-year rules — alongside the payroll item setup described above — is the practical first step.

For broader help with QuickBooks Desktop payroll forms and reporting, the built-in Help button on the form window itself offers field-level guidance and can trace specific numbers back to their source transactions within the company file.