QuickBooks and North Carolina Form NCUI 101: What Prefills and What to Check
QuickBooks auto-fills most of North Carolina's quarterly unemployment tax form, but employers must verify key lines and know the filing deadlines and thresholds.
QuickBooks Desktop handles the heavy lifting for North Carolina’s quarterly unemployment insurance filing, but employers still need to review the prepopulated fields, confirm the math, and meet the state’s submission deadlines. Here is what the software fills in, where the numbers come from, and what remains in the employer’s hands.
What Form NCUI 101 Covers
Form NCUI 101 — the Employer’s Quarterly Tax and Wage Report — is how North Carolina businesses report and pay state unemployment insurance tax on wages paid during the quarter. QuickBooks generates the form using the payroll data already entered throughout the quarter, so in most cases the fields populate automatically and no manual entry is needed.
The completed return can be mailed to the NC Department of Commerce, Division of Employment Security, P.O. Box 26504, Raleigh, NC 27611-6504.
Quarterly Due Dates
North Carolina unemployment insurance taxes follow a quarterly schedule:
- First quarter (January–March): April 30
- Second quarter (April–June): July 31
- Third quarter (July–September): October 31
- Fourth quarter (October–December): January 31
Electronic Filing Threshold
Employers and their agents — payroll providers, accountants, and other third-party filers — with 25 or more employees must submit quarterly wage reports electronically or on magnetic media. The Division of Employment Security can assess a $25 penalty for noncompliance.
Generating the Form in QuickBooks
To open and review NCUI 101 inside QuickBooks Desktop, navigate to the Employees menu, select Payroll Forms, then choose Process Payroll Forms. Select Quarterly Form 941/Wage Report (or the state unemployment option, depending on your QuickBooks version) and pick NCUI 101 from the available forms. Choose the correct quarter and click OK to generate the form.
QuickBooks populates most fields automatically based on your company, payroll, and employee data. Before filing, scroll through every field and confirm that nothing is missing or incorrect. Any field the software could not populate will be blank — those require manual entry.
For general help with the form window or to troubleshoot specific display issues, click the Help button within the form window itself.
Line-by-Line Breakdown
Line 1 — Covered workers. QuickBooks enters the number of employees 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. The software calculates total quarterly wages. If the form includes continuation pages (Form NCUI 101b), the sum of all page totals must match this line.
Line 3 — Excess wages. This reflects wages paid during the quarter that exceed North Carolina’s taxable wage base. By definition, this figure cannot exceed Line 2.
Line 4 — Wages subject to tax. QuickBooks subtracts Line 3 from Line 2 to arrive at the taxable wage amount.
Line 5 — Tax due for the quarter. The software multiplies Line 4 by your assigned tax rate (shown on the form). If the resulting tax is under $5.00, no payment is required — but the report must still be filed.
Lines 6, 7, and 8 — Interest and penalties. These lines capture any accrued interest or penalty amounts owed.
Exporting and Saving the Form
Employers who want a spreadsheet summary of the underlying payroll data can export it to Excel from within QuickBooks. For recordkeeping, the form can also be saved as a PDF directly from the form window — select the option to save or print the completed return rather than submitting it, then choose PDF as the output.
What to Watch For
Because QuickBooks derives every figure from existing payroll entries, the accuracy of NCUI 101 depends entirely on the accuracy of the data already in the file. Quarterly wages, employee counts, and tax rates all flow from prior pay runs, so any errors in those records will carry through to the form. Review each line before filing, verify that continuation page totals reconcile to Line 2, and confirm the tax rate displayed on the form matches what the state assigned your business.