Quickbooky

Accounting News

Payroll & Forms

QuickBooks and South Carolina Form UCE-120: What Auto-Fills and What Needs Review

QuickBooks prefills most of South Carolina's quarterly UCE-120 wage report, but certain fields and multi-page filings still require manual attention.

COMMUNITY ISSUESQUICKBOOKY

QuickBooks Desktop handles South Carolina’s Employer Quarterly Wage Report — Form UCE-120 — by pulling wage data directly from payroll records, but users filing this state return regularly encounter gaps between what the software auto-populates and what the South Carolina Department of Employment and Workforce actually requires. Understanding those gaps before filing can prevent rejected returns and incorrect wage totals.

What the Form Covers

Form UCE-120 is the quarterly wage report submitted to the South Carolina Department of Employment and Workforce. It reports total quarterly wages broken down by employee. One point that often causes confusion: the state requires only the wage detail for each employee to be filed. South Carolina itself calculates the contribution data — the amount due for the quarter — using the tax rate assigned to the employer for the year. QuickBooks users therefore do not need to manually compute the contribution on this form; they need to ensure the wage figures are accurate.

What QuickBooks Fills Automatically

In most cases, QuickBooks prefills the majority of fields on the UCE-120 using existing company, payroll, and employee data. When all of that information is already entered correctly in the company file, there is typically little or no additional manual entry required on the form itself. The software pulls each employee’s quarterly wage totals and places them on the appropriate lines.

Employees who did not earn wages during the quarter are excluded entirely — the program does not list them on the wage report. This is expected behavior, not an error.

Fields That Require Manual Review

Two fields in particular demand attention because QuickBooks does not populate them:

Total No. of Pages. This figure includes the primary UCE-120 page plus any continuation sheets attached. If the filing spans multiple pages, the employer must account for every page in this count.

Total No. of Employees. This is the count of all employees being reported for the quarter. Accuracy here matters because it must reconcile with the wage detail listed.

For any field the software left blank, the form window’s built-in Help button provides field-level guidance. Users can also trace where specific numbers originated by following the hyperlinks within the form to see how QuickBooks derived each figure from underlying payroll data.

The 23-Employee Threshold and Continuation Sheets

A structural detail that catches some employers off guard: the UCE-120 itself accommodates up to 23 employees. Once an employer exceeds that headcount, QuickBooks automatically generates continuation sheets — Form UCE-120A — to report the additional employees. These supplemental pages become part of the total filing, which is why the Total No. of Pages field must include them in its count.

Correcting Wage Figures the Right Way

One of the most common pitfalls with the UCE-120 in QuickBooks is attempting to edit wage amounts directly on the form. The recommended approach is the opposite: make any wage corrections in the underlying QuickBooks payroll data itself. Once the payroll records are adjusted, the corrected amounts flow through to the form automatically. This applies to both standard wage totals and excess wage calculations.

How Excess Wages Are Calculated

QuickBooks computes excess wages on line 11 of the UCE-120 by subtracting net taxable wages from total wages paid during the quarter, using the payroll data stored in the company file. As with any wage figure on this form, if the excess wage total needs adjustment, the change should be made at the payroll-data level — not by overwriting the number on the form. The corrected calculation then propagates to line 11 on its own.

Exporting and Saving the Form

Employers who need to retain a copy of the filed form or share it outside of QuickBooks have a couple of options. The form can be saved as a PDF directly from the form window, which is useful for recordkeeping or for submitting a copy to an outside accountant. For deeper analysis, QuickBooks also supports summarizing payroll data in Microsoft Excel, which can help with reconciliation or internal review before the quarterly filing is finalized.

When Numbers Don’t Reconcile

If the figures on the UCE-120 do not match expected totals, the first step is verifying that all payroll items — earnings, deductions, and company contributions — are correctly mapped in the employee and payroll setup. Because the form draws entirely from live payroll data, discrepancies almost always trace back to a data-entry issue or a misclassified payroll item earlier in the quarter. Correcting the source data and regenerating the form is the cleanest path to an accurate filing.

← Back to Community Issues