Tennessee Quarterly Premium and Wage Report in QuickBooks: What Users Need to Know
QuickBooks payroll users preparing Tennessee's quarterly UI Premium and Wage report face confusion over prefilled fields, state account validation, and wage breakdowns.
Tennessee employers using QuickBooks to manage payroll must file a quarterly Premium and Wage Report covering unemployment insurance obligations, and community discussions indicate recurring confusion over how the form is populated, validated, and submitted through the software.
The state requires all employers covered under Tennessee’s Unemployment Insurance law to submit the report each calendar quarter, accompanied by any payment due. The filing deadline falls on the last day of the month following the close of the quarter — meaning Q1 closes March 31 and the report is due by April 30, and so on through the year. Filing is required even in quarters where no wages were paid. Submission itself happens through the Tennessee Department of Labor & Workforce Development’s online portal, known as TNPAWS, rather than through QuickBooks directly.
What QuickBooks Fills In
QuickBooks is designed to prefill the majority of fields on the report by pulling from existing company, payroll, and employee records. In a well-maintained file where all payroll data has been entered correctly throughout the quarter, users typically find that little or no manual entry is needed beyond reviewing what the software has produced.
That said, users regularly report difficulty locating specific information or understanding why certain fields remain blank. QuickBooks offers in-product guidance through the Help button on the form window itself, which covers general form usage and troubleshooting for specific issues. Additional resources address how to trace where the numbers originated, how to summarize payroll data in Microsoft Excel, and how to save a completed form as a PDF for recordkeeping.
State Account Number Validation
One commonly reported stumbling block involves the State Account Number field. The number must pass a check-digit validation routine, and if it fails, QuickBooks will flag an error. The recommended resolution is straightforward: compare the entry in QuickBooks against the account number originally issued by the state and correct any discrepancy. This is typically a data-entry issue rather than a software malfunction.
Understanding the Wage Breakdown
The report divides wages into several categories, and confusion over how these figures are calculated appears frequently among users.
Total Wages captures gross wages paid to all employees during the calendar quarter. This figure includes employee contributions to 401(k) plans and cafeteria plans — it is not reduced by those deferrals. The number flows from the employee wage detail on the second page of the form.
Excess Wages represents the portion of each employee’s total quarterly wages that exceeds Tennessee’s taxable wage limit. QuickBooks computes this automatically by subtracting taxable wages from total wages for the quarter.
Taxable Wages is the net taxable amount for the quarter. This figure cannot be negative — if it appears as such, the underlying payroll data likely contains an error that needs to be corrected before filing.
Calculating Contributions, Interest, and Adjustments
UI Contributions Due is derived by multiplying taxable wages by the employer’s assigned UI tax rate, which QuickBooks pulls from payroll setup.
Interest Due applies only to late filings. Interest is computed at 1.5% of the premium amount owed for the quarter, assessed for each month or fraction of a month that the payment is delinquent. Users filing on time should see this field at zero.
Outstanding Debit or Credit is intended to capture any overpayment or underpayment carried over from a previously processed form — typically one originally printed by the state tax agency. Unless the amount appears incorrect, users should enter it as shown.
When Fields Don’t Populate Correctly
For users finding that expected fields are not populating or that figures appear off, the root cause almost always traces back to payroll setup or data entry earlier in the quarter. Verifying that the state account number, UI tax rate, and employee wage records are all accurate in QuickBooks is the first step. Reviewing the employee wage detail on page 2 of the report can help isolate discrepancies in total or taxable wages.
Users who need to work with the data outside of QuickBooks — whether for reconciliation or for manual entry into the TNPAWS portal — can export a payroll summary to Excel or save the completed form as a PDF directly from the form window.