Quickbooky

Accounting News

Payroll

Tennessee Unemployment Insurance Quarterly Premium Report in QuickBooks

QuickBooks prefills most of Tennessee's quarterly unemployment insurance wage and premium report, but certain fields require manual review and entry.

COMMUNITY ISSUESQUICKBOOKY

QuickBooks Desktop includes built-in support for Tennessee’s quarterly unemployment insurance filing, prefilled from the payroll data already in your company file. The state requires covered employers to submit a quarterly Premium and Wage Report along with any payment due, filed by the last day of the month following the close of each calendar quarter — even in quarters where no wages were paid.

What QuickBooks Fills In Automatically

Most fields on the Tennessee quarterly report are populated automatically from your existing payroll records. When you open the form, QuickBooks pulls gross wages, taxable wage bases, and calculated premium amounts from the employee and paycheck data already in your file. In the typical case — where all payroll has been processed consistently throughout the quarter — you may not need to enter anything beyond what QuickBooks has already completed.

The form flags any fields that still need your attention with an alert. Those are the only lines requiring manual input.

State Account Number Validation

Tennessee’s account number must pass a check-digit validation. If QuickBooks rejects the number you have entered, compare what is stored in your company file against the account number the state issued. A mismatch — even a single transposed digit — will trigger the error.

Line-by-Line Breakdown

The report follows a standard wage-and-premium structure:

Total Wages (Line 1). This is the sum of all gross wages paid to every employee during the calendar quarter. The figure includes employee contributions to 401(k) plans and cafeteria or Section 125 plans, since those amounts are still part of gross compensation for unemployment purposes.

Excess Wages (Line 2). QuickBooks calculates this automatically by identifying the portion of each employee’s wages that exceeds Tennessee’s taxable wage limit for the year. The calculation subtracts net taxable wages (Line 3) from total wages for the quarter (Line 1).

Taxable Wages (Line 3). This is the net taxable wage base for the quarter — the amount actually subject to the unemployment premium. The figure cannot be negative; if you see a negative number, something in the underlying payroll data needs correction.

Premium Due (Line 4). QuickBooks multiplies taxable wages on Line 3 by the premium rate displayed on the form to arrive at the amount due.

Interest Due (Line 5). If the filing is late, enter interest computed at 1.5% of premiums due for this quarter, assessed for each month or fraction of a month the payment is delinquent. This line applies only to the current quarter’s premium.

Job Skills Due (Line 6). Select the appropriate tax rate by checking the designated box on the form.

When Numbers Need Verification

If a figure on the form does not match what you expect, the underlying payroll data in your company file is the first place to look. QuickBooks derives every prefilled amount from paychecks, employee records, and company-level payroll settings, so discrepancies usually trace back to an unprocessed paycheck, an incorrect wage item, or a missing employee setup detail.

For employers who want to cross-reference the data independently, QuickBooks can export a payroll summary to a spreadsheet for side-by-side comparison with the form.

Saving and Filing

The completed report can be saved as a PDF for your records or for submission outside of QuickBooks. If you need general help with the form window itself — navigation, troubleshooting, or understanding where a specific number originated — the Help button on the form screen provides context-sensitive guidance.

Common Sticking Points

Most issues users encounter fall into a few categories: the state account number failing validation, a negative figure appearing on the taxable wages line, or confusion over whether retirement and cafeteria-plan contributions belong in total wages. They do. The check-digit error is the most frequent, and it is almost always a data-entry mismatch between what the state assigned and what is stored in QuickBooks.

For broader payroll-form issues — whether a specific line will not calculate, a form will not open, or wage totals seem off across multiple quarters — the underlying company file may need a closer look, since the form’s accuracy depends entirely on the integrity of the payroll data beneath it.

← Back to Community Issues