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

QuickBooks Desktop automatically populates the majority of fields on Worksheet 1 — the worksheet used to determine credits for qualified sick leave, family leave, and employee retention wages on Form 944. In most cases where company, payroll, and employee data are fully maintained inside QuickBooks, no additional manual entry is needed. However, several fields do not auto-populate, and filers have needed guidance on where those numbers originate and how to verify them.

Fields That Flow From the Interview Worksheet

Several credit-related amounts on Worksheet 1 pull indirectly from the 944 Interview Worksheet rather than being calculated in isolation on the form itself. Qualified health plan expenses allocated to sick leave wages and those allocated to family leave wages both flow from that worksheet. The same is true for the credit amount from Form 5884-C, line 11. Filers who see these fields blank or want to confirm the figures should review the Interview Worksheet entries for the corresponding filing period.

Calculated Excess Wage Fields

Two fields on Worksheet 1 represent excess wages rather than direct inputs. Excess qualified sick leave wages are determined by subtracting the amount on line 2a from total qualified sick leave wages paid. Excess qualified family leave wages follow the same logic — line 2e is subtracted from total qualified family leave wages paid. These are computed figures, so if the result looks unexpected, the underlying total wage amounts and the line 2a or 2e figures are the places to check.

Employee Retention Credit Wages

Qualified wages for the employee retention credit are defined within QuickBooks as the sum of all payroll items assigned a specific CARES Retention Credit tax tracking type. Because the calculation depends entirely on how payroll items are tagged, verifying the amount on line 5a(i) requires confirming that the correct tracking types are assigned.

The recommended approach uses two built-in reports. First, run a Payroll Item Listing report by navigating to the Reports menu, selecting Employees & Payroll, and choosing Payroll Item Listing. This report shows every defined payroll item along with its assigned tax tracking type, making it possible to identify which items feed into the retention credit calculation.

Second, run a Payroll Summary report for the Form 944 filing period — again through Reports, then Employees & Payroll, then Payroll Summary. Adjust the date range as needed and note the amounts for any payroll items using the Reported Tips tax tracking type. The Payroll Summary report can also be filtered to display only the relevant payroll items and their amounts, which simplifies the review.

Health Plan Expenses for Retention Credit Wages

Qualified health plan expenses allocable to qualified wages for the employee retention credit follow the same logic as the wage total itself — they represent the sum of all QuickBooks payroll items carrying the CARES Retention Credit tracking type. Filers who need to confirm this figure can use the same Payroll Item Listing report to verify which items are included and whether the allocation is correct.

Context for Filers

These credits originated under pandemic-era legislation, and while the filing periods they apply to have largely passed, users working on amended returns, prior-period corrections, or late filings may still encounter Worksheet 1. QuickBooks prefill handles most of the heavy lifting, but the fields tied to health plan allocations, excess wage calculations, and retention credit wage verification are the ones most likely to require a second look.

For broader help navigating the form window itself — including understanding where specific numbers on the form originated within QuickBooks — the Help button available directly on the form window provides field-level guidance. That in-product help is the most direct resource for tracing a specific figure back to its source data.