QuickBooks and North Carolina Form NCUI 101: What Users Need to Know
QuickBooks prefills most of North Carolina's quarterly unemployment insurance tax form, but certain fields and filing rules require employer attention.
QuickBooks payroll users responsible for North Carolina unemployment insurance tax often encounter questions when working with Form NCUI 101, the Employer’s Quarterly Tax and Wage Report. The form is used to report state unemployment insurance tax calculated on wages paid during a given quarter, and while QuickBooks is designed to prefill most of the relevant data automatically, employers are still responsible for reviewing and completing fields the software leaves blank.
Filing Deadlines and E-Filing Requirements
North Carolina unemployment insurance taxes are due quarterly. The deadline for the first quarter — covering January through March — is April 30. The second quarter, spanning April through June, is due July 31. The third quarter, July through September, must be filed by October 31. The fourth quarter, October through December, is due January 31 of the following year.
Employers and their agents — including payroll providers and accountants — with 10 or more employees are required to file quarterly wage reports electronically or on magnetic media. The state’s Division of Employment Security may assess a penalty for failure to comply with this requirement. QuickBooks supports electronic filing for this form, and employers can also enter their information directly through the state’s online portal.
For employers who prefer to file by mail, the return can be sent to the NC Department of Commerce Division of Employment Security at P.O. Box 26504, Raleigh, NC 27611-6504.
How QuickBooks Handles the Form
When a user opens NCUI 101 within QuickBooks, the software attempts to prefill most fields using existing company, payroll, and employee data. In most cases, if all of that information has been entered and maintained correctly throughout the quarter, little to no manual entry is required. However, users should carefully review any fields QuickBooks did not populate automatically and enter the necessary information before filing.
For general guidance on using the form window or troubleshooting specific issues, the Help button within the form window provides additional context. QuickBooks also offers hyperlinks within the form view that explain where specific numbers originated in the company file, which can help users verify accuracy.
Line-by-Line Breakdown
The accepted community guidance walks through several key lines on the form:
Line 1 covers the number of covered workers. QuickBooks automatically enters the count of employees who worked during or received pay for the payroll period that includes the 12th of each month.
Line 2 represents total wages paid during the quarter. QuickBooks calculates this figure. The sum of the page totals on Form NCUI 101 and all pages of the accompanying Form NCUI 101b must equal the amount shown on this line.
Line 3 captures excess wages — the portion of wages paid during the quarter that exceeds the state’s taxable wage base. This figure cannot exceed the amount on Line 2.
Line 4 is the amount of wages subject to tax, calculated by subtracting the excess wages on Line 3 from the total wages on Line 2.
Line 5 shows the tax due for the quarter, calculated by multiplying the wages subject to tax on Line 4 by the applicable tax rate displayed on the form.
Additional Tools and Export Options
For users who want to review their payroll data outside of the form itself, QuickBooks can summarize payroll data for export to Microsoft Excel. This can be useful for reconciliation or record-keeping purposes. The software also provides an option to save a completed copy of the payroll form as a PDF, which employers can retain for their files.
What to Watch For
The most common stumbling block users report is assuming that every field will populate automatically. While QuickBooks handles the calculations and most of the data entry, employers should verify that employee counts, wage totals, and tax rates align with their records before submitting. The excess wages calculation on Line 3 is particularly important, as it directly affects the taxable wage amount and the final tax due.
Users who notice discrepancies between their QuickBooks data and the figures on the form should review their payroll setup and employee records to ensure all wage and tax information is current. Inaccuracies at the source level — such as incorrect tax rates or missing employee data — will carry through to the generated form.