Filing North Carolina Form NCUI 101 in QuickBooks: What Prefills and What to Check
QuickBooks auto-fills most of North Carolina's quarterly unemployment insurance form, but employers should verify wage calculations, employee counts, and e-filing thresholds before submitting.
QuickBooks Desktop users responsible for North Carolina unemployment insurance reporting can generate and file Form NCUI 101 — the Employer’s Quarterly Tax and Wage Report — directly from within the software. The form calculates and reports state unemployment insurance tax on wages paid during each quarter, and QuickBooks prefills most fields automatically based on existing payroll data. Several fields, however, may require manual review, and employers with ten or more employees face a mandatory electronic filing requirement.
Due Dates and the E-Filing Threshold
North Carolina unemployment insurance taxes are due quarterly. The filing deadlines are April 30 for the first quarter (January through March), July 31 for the second quarter (April through June), October 31 for the third quarter (July through September), and January 31 for the fourth quarter (October through December).
Employers — and their agents such as payroll providers or accountants — with 10 or more employees must file quarterly wage reports electronically. The Division of Employment Security may assess a penalty for noncompliance. QuickBooks supports e-filing for this form, or employers can enter their information directly through the state’s online portal.
Generating the Form in QuickBooks
To access Form NCUI 101, open the Employees menu and select Payroll Tax Forms & W-2s, then choose Process Payroll Forms. Select Quarterly Form 941/Schedule B - NCUI 101 (or the applicable state quarterly unemployment form) from the list and click Create Form. Enter the quarter and year, then proceed through the on-screen prompts.
QuickBooks will prefill most fields using the company, payroll, and employee data already stored in the company file. In most cases, if all payroll data has been entered consistently throughout the quarter, no additional manual input is needed. Users should still review every field the software did not populate automatically.
Key Fields to Review
Employee Counts — QuickBooks automatically enters the number of covered workers who worked during or received pay for the payroll period that includes the 12th of each month. Verify these headcounts against your actual payroll records.
Wages Paid This Quarter — QuickBooks calculates this figure from payroll data already in the file. The sum of the page totals on Form NCUI 101 and all pages of Form NCUI 101b must equal the total wages amount shown.
Excess Wages — This represents wages paid during the quarter that exceed the taxable wage base. The figure cannot be more than total wages. North Carolina sets an annual taxable wage base per employee; once an employee’s year-to-date wages cross that threshold, additional wages become excess and are not subject to further unemployment tax for the remainder of the year.
Wages Subject to Tax — Calculated by subtracting excess wages from total wages.
Tax Due for the Quarter — Derived by applying the employer’s assigned tax rate to the wages subject to tax. Each employer’s rate is assigned by the state and varies based on experience rating.
Total Tax Due — The sum of tax due plus any interest and penalties. Remittance should be made payable to the Division of Employment Security.
If the Numbers Look Wrong
If the prefilled amounts do not match expectations, the underlying payroll data in the company file is the likely culprit. Missing or misclassified paychecks, incorrect state tax setup, or employee records with wrong state assignments can all throw off the calculations. Running a payroll summary report for the quarter and comparing it to the form is the fastest way to identify discrepancies.
For employers who want to cross-reference figures outside of QuickBooks, the software can summarize payroll data in a format compatible with Microsoft Excel. This export lets you manually verify wage totals, employee counts, and tax calculations before submitting the official form.
Saving and Submitting
QuickBooks allows users to save a copy of the completed form as a PDF for internal records. If mailing a paper return rather than e-filing, the address is:
NC Dept. of Commerce, Division of Employment Security P.O. Box 26504 Raleigh, NC 27611-6504
For troubleshooting specific fields or form-window behavior, the Help button within the form window itself provides context-sensitive guidance on the element currently in view.