QuickBooks State Unemployment Credit Adjustment Worksheet on Form 940 Explained

When employers file their annual federal unemployment (FUTA) return, QuickBooks generates a State Unemployment Credit Adjustment Worksheet behind the scenes. The software handles most of the math automatically, but users who owe state unemployment tax late — or who operate across multiple states — frequently need to understand what the worksheet is doing and where the numbers originate.

What Triggers the Worksheet

The adjustment comes into play whenever some FUTA-taxed wages were excluded from state unemployment tax, or when state unemployment tax was paid after the Form 940 deadline. Employers who paid all of their state unemployment tax on time and whose wages were fully subject to state unemployment tax generally will not see a complex adjustment.

QuickBooks populates the majority of the worksheet fields on its own, pulling from the company’s payroll and employee data already entered throughout the year. In most situations where all payroll activity was tracked in QuickBooks, no manual entry is needed. The worksheet itself is not attached to Form 940 — it stays with the employer’s internal records.

Late State Tax Payments

The most common point of confusion involves the credit for timely state unemployment tax payments. QuickBooks operates on the assumption that all state unemployment tax was paid by the Form 940 due date. If any portion was paid late, line 2 of the worksheet must be reduced by the amount that came in after the deadline.

If the figure on line 2 ends up equal to or greater than line 1, there is no credit adjustment to compute and the rest of the worksheet does not apply.

Multi-State Employers and Rates Below 5.4%

The worksheet also accounts for employers whose assigned state unemployment experience rate falls below 5.4%. When every state rate is at or above 5.4%, QuickBooks automatically marks the worksheet accordingly and enters a zero on line 3, allowing the employer to skip ahead to line 4.

When rates dip below 5.4% in one or more states, QuickBooks calculates an additional credit. For employers with workers in multiple states, the worksheet lists up to five states with rates under that threshold. A few scenarios can cause a particular state to drop off the worksheet for a given quarter: if there was no payroll activity in that state during that quarter, or if all wages for that state in that quarter were exempt from state unemployment tax.

How the Additional Credit Is Calculated

For each state listed, QuickBooks displays several data points:

• State — the state where the taxable wages were paid, entered automatically when the experience rate is below 5.4%.
• Assigned experience rate — the employer’s specific state rate, shown on screen for reference but not printed on the worksheet. This column is not part of the official IRS worksheet; it exists solely to help verify the calculation.
• Computation rate — the difference between 5.4% and the assigned experience rate.
• Taxable state unemployment wages — the wage base subject to the assigned rate, filled in automatically.
• Additional credit — the taxable wages multiplied by the computation rate.

Those individual state credits are then subtotaled and carried through the remaining worksheet lines to produce the final FUTA credit adjustment.

When Numbers Look Wrong

Employers who spot unexpected figures on the worksheet should first confirm that all state unemployment wage items and tax payments were properly recorded in QuickBooks during the year. The Help button on the form window offers guidance on tracing specific numbers back to their source within the payroll data, and the Form 940 instructions from the IRS include a sample worksheet for comparison.

For broader payroll and tax form troubleshooting, reviewing how state unemployment rates and wage items are set up in the company file can often resolve discrepancies before the return is filed.