QuickBooks Instructions - May/2024 - Instructions for Creating QuickBooks File to Upload NCUI101 Data to NCSUITS

Oct 22, 2026

North Carolina Division of Employment Security provides step-by-step QuickBooks instructions to generate a state unemployment insurance (SUI) E-file for uploading NCUI101 data to NCSUITS. The guide covers updating the employer ID to the 10-digit NCSUITS Employer ID, creating the NC state SUI tax file through Payroll Tax Forms & W-2s, verifying state, year, and quarter, and producing the required fixed-width ASCII .txt file. It also addresses how to handle zero employee count and SUI wages notifications, and notes agent-specific requirements to insert the employer FEIN into the RE record line.

LanguageEnglish

CategoryResearch & Report

FormatPDF

Pages3

Reading Time8 min

AccessFree to download

QuickBooks Instructions

Prepare QuickBooks and Update Employer ID

Create NC State Unemployment Insurance Tax File

Run the QuickBooks SUI E-file Interview

Save and Upload the Required .txt File

North Carolina Division of Employment Security Instructions for creating QuickBooks file for uploading NCUI101 data to NCSUITS QuickBooks Instructions North Carolina State Unemployment Insurance Tax System [des.nc.gov/ncsuits](des.nc.gov/ncsuits) May/2024 NOTE: QuickBooks has updated their software to accommodate NCSUITS. Make sure you have updated your QuickBooks to the most recent update available 1. In QuickBooks, update employer ID to the 10-digit NCSUITS Employer ID. • If using QuickBooks Desktop, you need to update the SUI employer ID to the NCSUITS 10-digit number (one-time process) . Go to Lists > select Payroll Item List > double-click your state Unemployment item > select Next > enter your Employer ID Number > select Next > select Finish. 2. To create the NC State Unemployment Insurance tax file, Choose Employees. 3. Then choose Payroll Tax Forms & W-2s. 4. Click on Create State SUI E-file. 5. Select the State (NC) . 6. Click Continue. 7. Click Continue again. 8. Check the state, year and quarter for accuracy (defaults to current quarter due); update as needed and then click Get QuickBooks Data. 9. Click OK. 10. At the top of the spreadsheet, Click the Add-ins tab. 11. Near the top left, click QuickBooks Payroll State SUI E-file. 12. Click Start Interview. NOTE: Always save your file as a .txt file format. 13. Confirm the company information and click Next. 14. Select whether you are an agent (Third-Party) or Employer. 15. Verify the Information. 16. Verify the Submitter information and click Next. 17. Create State UI file. 18. Click OK. 19. Save with a .txt file format (This file will be uploaded as a EFW2 in NCSUITS) . 20. You will receive the following notification (below) from QuickBooks once the file is created. Please disregard that the Employee Count and SUI Wages show as zero; the NCSUITS system will validate the number of records and the SUI wages. See example below: Complete! Your State file has been created with 0 state records. Next Step 1. Submit the state UI file (see file name below) to your state agency, following their instructions. Click State UI Filing help below for more details. Consider saving this Excel workbook for your records. Keep both the workbook and the UI file for future reference. Many states require you keep these records for several years. File Information IMPORTANT: This is the state UI file to submit to North Carolina: File Type: Character Set: File Name: Employee Count: SUI Wages: Fixed Width ASCII-1 C:\Users\siste\OneDrive\Documents\NC_Quarterly.txt 0 0.00 State Filing help Note to Agents: you will need to review the .txt file and MUST add the employer FEIN to the RE record line, columns 19 to 27. There should only be 12 spaces in between the last number of the employer FEIN and the employer’s name. Make sure that any extra spaces after that are deleted to ensure the employer’s name starts at column 40. See the NCSUITS Wage Report and Payment File Documentation for more information at NCSUITS Documents | DES. 21. Upload the .txt file in NCSUITS as an EFW2 file submission.

FAQs

What must be updated in QuickBooks before creating the NCSUITS file?

Update the employer ID in QuickBooks to the 10-digit NCSUITS Employer ID. For QuickBooks Desktop, update the SUI employer ID in the Payroll Item List as a one-time process.

How do you generate the NC state unemployment insurance tax file in QuickBooks?

In QuickBooks, choose Employees, then Payroll Tax Forms & W-2s, select Create State SUI E-file, choose the State (NC), and continue through the prompts while verifying the state, year, and quarter.

What file format should be saved and how is it uploaded to NCSUITS?

Save the output as a .txt file format (fixed width ASCII-1). Upload the .txt file in NCSUITS as an EFW2 file submission.

Oct 22, 2026

Uploaded by RuangKosong