QuickBooks Hawaii UC-B6 Payroll Report: What It Fills In and What You Check
How QuickBooks populates the Hawaii Quarterly Wage and Unemployment Insurance report, which fields need manual review, and where the calculated numbers come from.
Hawaii employers handling quarterly unemployment insurance obligations may already have most of the legwork done inside QuickBooks. The desktop payroll module generates a dedicated report to assist with completing Form UC-B6 — the Quarterly Wage, Contribution and Employment and Training Assessment Report — though the form itself remains a controlled document that Hawaii issues directly to each employer and cannot be downloaded or reprinted from the software.
What the Report Covers
The UC-B6 report inside QuickBooks is designed to prefill wage and tax data so employers can transfer those figures onto the official state-issued form. In most cases, when company setup, payroll items, and employee records are complete and current, the report requires little or no manual entry. The software calculates unemployment insurance tax based on wages paid during the quarter and distributes the relevant totals across the corresponding lines on the state form.
Employers should understand that the QuickBooks report is a preparation aid, not a replacement for the physical form. Hawaii’s Department of Labor and Industrial Relations only accepts the original controlled forms it provides.
Electronic Filing Threshold
A separate consideration affects larger employers. Businesses with nine or more employees must submit both the quarterly contribution report and wage report electronically rather than by mail. Employers below that threshold may continue filing the paper form by mailing it to the State Tax Collector in Honolulu.
The filing deadline falls on the last day of the month following the close of each calendar quarter. When that date lands on a weekend or legal holiday, the deadline moves to the next banking day.
How QuickBooks Populates the Lines
The report walks through each section of the UC-B6 and explains where the numbers originate. Employee wages are drawn directly from payroll records for the quarter. Any employee who earned no wages during the period is simply omitted from the listing, and employees missing a Social Security number appear with that field left blank.
The wage lines build on each other in sequence. Line 4 totals only the wages shown on the current page. When an employer has more than eight workers, the main page shows no individual employee listings — instead, the continuation form carries the detail. Line 5 captures the combined totals from all continuation sheets, and Line 6 represents the grand total of all wages paid for the entire quarter.
One detail worth noting: if total quarterly wages are zero, QuickBooks enters “No Payroll” on Line 6. Active employers are still required to submit the form even when no wages were paid, so that notation serves as the official declaration.
Line 7 handles excess wages. The software calculates this figure by subtracting net taxable wages from total wages, applying the state’s wage base threshold to determine how much compensation exceeds the taxable limit.
Fields That May Need Attention
While QuickBooks prefills the majority of the form, the software flags any fields it could not populate automatically. Employers should review these gaps and enter the missing information before finalizing the report. The built-in help accessible from the form window provides guidance on individual fields and offers troubleshooting for specific issues that arise during preparation.
For employers who want to verify the underlying numbers or work with the data outside of QuickBooks, the payroll module includes an option to summarize payroll data in a spreadsheet. This can be useful for cross-referencing totals or maintaining separate records. The form can also be saved as a PDF for archival purposes.
When Data Does Not Transfer Cleanly
Occasionally the report may not reflect expected totals — typically because a payroll item was mapped incorrectly, an employee record is incomplete, or a wage item was set up with the wrong tax tracking type. These situations usually require reviewing the employee setup and verifying that each wage item is assigned to the correct unemployment insurance tax category before regenerating the report.
For employers managing Hawaii payroll compliance alongside other state filings, the UC-B6 report is one of several state-specific payroll forms QuickBooks supports. The same data-integrity principles apply across all of them: accurate employee records and properly configured payroll items are what make the prefilled numbers reliable.