Filing Kansas Form K-CNS 100 in QuickBooks: What Each Line Means
QuickBooks prefills most of the Kansas Quarterly Wage Report, but certain lines need manual review. Here is what each field means and what to check.
QuickBooks Desktop handles the bulk of the Kansas Quarterly Wage Report and Unemployment Tax Return (Form K-CNS 100) automatically, pulling wage and employee data from payroll records already in the system. Even so, several fields demand manual attention before the form is ready to file — and employers with 25 or more workers must submit electronically.
What QuickBooks Fills In Automatically
When a user opens the K-CNS 100 form window, QuickBooks populates most fields using the company, payroll, and employee data already on file. In the typical case where all payroll has been processed inside QuickBooks throughout the quarter, little or no manual entry is needed. The software calculates taxable wages, excess wages, and tax due based on the employer’s assigned unemployment insurance tax rate.
Lines That Need Review
Line 11 — Number of Workers
This figure represents all workers who worked during — or received pay subject to unemployment insurance wages for — the payroll period that includes the 12th of the month. Workers must be counted here even if their earnings exceeded the taxable wage limit for the quarter. QuickBooks derives this number from payroll records, but it is worth verifying against actual headcount, especially if any employees were hired or terminated mid-quarter.
Line 12 — Total Wages
Line 12 should equal the sum of all gross wages for the quarter — the amounts entered in Column 6 of the form plus the Total Wages column from any accompanying K-CNS 101 Schedule A forms. If this number looks off, the discrepancy usually traces back to a missing or misclassified paycheck somewhere in the quarter’s payroll data.
Line 13 — Excess Wages
This line captures the portion of total wages reported on Line 12 that exceeds the taxable wage base for the quarter. QuickBooks calculates this automatically based on the annual taxable wage limit set for Kansas unemployment insurance. Because the wage base is subject to change by state statute, confirming that QuickBooks is using the current year’s figure is a worthwhile step before filing.
Line 14 — Taxable Wages
The result of subtracting excess wages from total wages. This is the amount actually subject to unemployment tax for the quarter.
Line 15 — Unemployment Tax Due
Line 15 displays the employer’s tax rate and the calculated tax amount. QuickBooks multiplies the tax rate by the taxable wages on Line 14. The rate must be entered in the format N.NNNN% — four decimal places. Employers who received a new rate notice from the Kansas Department of Labor should confirm that QuickBooks reflects the current assignment rather than a prior year’s rate.
Line 16 — SUTA Penalty Rate
This line applies only to employers the Kansas Department of Labor has flagged for State Unemployment Tax Avoidance violations. The minimum assigned penalty rate is 2%. If the agency has assigned a SUTA penalty rate, the user checks the “Yes” box and QuickBooks calculates the penalty automatically using 2.0000% as the default. If the assigned rate is higher than 2%, the user must manually edit the rate so the penalty calculates correctly — again entered in N.NNNN% format.
Line 17 — Late Filing Penalty
A late filing penalty of 0.5% of total wages applies when the return is filed after the deadline. Kansas quarterly wage reports are due at the end of the month following each calendar quarter close — April 30, July 31, October 31, and January 31. QuickBooks will calculate this penalty if the filing date falls past the deadline.
E-Filing and E-Payment Setup
Kansas requires electronic filing and payment for employers with 25 or more employees, and third-party administrators handling 25 or more client employees face the same mandate. To e-file and e-pay through QuickBooks, the employer must be enrolled in the Kansas Department of Labor’s electronic filing system and have that enrollment configured in the payroll setup. Once enrolled, users can submit both the form and any payment directly from the form window. For employers below the 25-employee threshold, paper filing remains an option, though electronic submission is available regardless.
Saving a Copy
Before submitting, users can save a copy of the completed form for their records. The save option is available directly in the form window and produces a file that mirrors what gets transmitted to the state.
When the Numbers Do Not Add Up
If Line 12 or another figure looks wrong, the underlying payroll data is the likely culprit. Running a payroll summary report for the quarter and exporting it to Excel for a side-by-side comparison with the form is the fastest way to isolate the problem. A misclassified paycheck, a wage item mapped to the wrong expense account, or an employee set up with the wrong state withholding can all throw off the totals. For broader QuickBooks payroll troubleshooting, verifying that every employee’s state unemployment wage setup points to Kansas is a good starting point.