QuickBooks and Form NCUI 101: What Employers Need to Know
A practical breakdown of how QuickBooks handles North Carolina's quarterly unemployment insurance report, key filing deadlines, and what each line means.
QuickBooks Desktop’s built-in payroll forms include support for North Carolina’s Form NCUI 101, the Employer’s Quarterly Tax and Wage Report. The form is used to report state unemployment insurance tax on wages paid during a given quarter, and QuickBooks will prefill most of the relevant fields using existing company, payroll, and employee data. Even so, employers are responsible for reviewing what the software populated and confirming that nothing is missing before filing.
Filing Deadlines and Requirements
North Carolina unemployment insurance taxes are due quarterly. The filing schedule is straightforward: first quarter returns (January through March) are due April 30, second quarter (April through June) on July 31, third quarter (July through September) on October 31, and fourth quarter (October through December) on January 31.
Employers or their agents — including payroll providers and accountants — with 25 or more employees must file quarterly wage reports electronically or on magnetic media. The state’s Division of Employment Security may assess a penalty against those who fail to comply with that requirement.
Returns can also be mailed to the NC Department of Commerce Division of Employment Security in Raleigh.
How QuickBooks Populates the Form
When you open the NCUI 101 form within QuickBooks, the software attempts to fill in most fields automatically based on the payroll data already in your company file. In most cases, if all of your employee and payroll information is current and complete in QuickBooks, you should not need to manually enter additional data. However, it is worth reviewing every field the software left blank and supplying any missing details before you file.
Understanding Each Line on the Form
The NCUI 101 is a line-item return, and QuickBooks calculates several of the key figures. Here is what each line represents:
Line 1 — Covered Workers
QuickBooks enters the number of covered workers who worked during, or received pay for, the payroll period that includes the 12th of each month in the quarter.
Line 2 — Wages Paid This Quarter
This is the total wages paid during the quarter, calculated by QuickBooks from your payroll records. If the form spans multiple pages, the sum of all page totals on Form NCUI 101 and any attached Form NCUI 101b continuation pages must equal the amount on Line 2.
Line 3 — Excess Wages
This figure represents wages paid during the quarter that exceed the state’s taxable wage base. By definition, this amount cannot be greater than the total wages reported on Line 2.
Line 4 — Wages Subject to Tax
QuickBooks derives this by subtracting the excess wages on Line 3 from the total wages on Line 2. The result is the portion of your payroll that is actually subject to state unemployment tax.
Line 5 — Tax Due for the Quarter
This is the core calculation: Line 4 multiplied by your assigned tax rate. One notable threshold — if the tax due is less than $5.00, payment is not required, but the report itself still must be filed.
Lines 6, 7, and 8 — Interest and Penalties
These lines capture any interest or penalty amounts that may apply to the filing.
Additional Resources Within the Form
QuickBooks provides several built-in help options for employers working through the NCUI 101. The Help button on the form window offers guidance on navigating the form and troubleshooting specific issues. Hyperlinks within the form let you trace where the calculated unemployment insurance amounts originated in your payroll data, which is useful for verifying accuracy.
For employers who want to work with their numbers outside of the form itself, QuickBooks offers the ability to summarize payroll data in Microsoft Excel. You can also save a completed copy of the form as a PDF for your records — a step worth taking before you file, so you retain a snapshot of exactly what was submitted.
When Calculations Go Wrong
If the figures on the form do not match what you expect — whether the taxable wage base, total wages, or the final tax due — the underlying payroll data in your company file may be incomplete or damaged. Running QuickBooks’ built-in verification tools can sometimes surface data inconsistencies that affect payroll forms. For general QuickBooks help with Verify and Rebuild utilities, reviewing employee wage records, or resolving form calculation discrepancies, it pays to confirm your data integrity before the quarterly deadline arrives.