Kansas Quarterly Wage Report (K-CNS 100) in QuickBooks: What Each Line Means

QuickBooks Desktop handles the heavy lifting on Kansas Form K-CNS 100 — the Quarterly Wage Report and Unemployment Tax Return — but employers are still responsible for verifying the numbers and completing a handful of fields the software cannot populate on its own.

How QuickBooks Approaches the Form

For most companies, QuickBooks automatically fills in the majority of the K-CNS 100 using the payroll data already entered throughout the quarter. In a well-maintained file — one where all company, payroll, and employee records are current — manual entry is typically minimal. Still, the software flags certain fields for review, and users should scan the entire form before filing or submitting payment.

One important threshold: Kansas requires employers with 50 or more employees, and third-party administrators with 50 or more client employees, to file the K-CNS 100 and remit payment electronically. QuickBooks supports e-filing and e-paying directly from the form window.

Fields That Need Your Attention

Line 11 — Number of Workers

This count covers all workers who either worked during or received pay subject to unemployment insurance wages in the payroll period that includes the 12th of the month. Employees must be counted here even if their earnings exceeded the taxable wage limit for the quarter.

Line 12 — Total Wages

This figure should match the combined gross wages reported for the quarter — specifically, the amounts entered in Column 6 of the form plus the Total Wages column from any K-CNS 101 Schedule A attachments.

Line 13 — Excess Wages

QuickBooks calculates this as the portion of total wages reported on Line 12 that surpasses the taxable wage ceiling for the quarter.

Line 14 — Taxable Wages

This is the net taxable wage amount for the quarter after excess wages are removed.

Line 15 — Unemployment Tax Due

Line 15 displays both the employer’s assigned tax rate and the calculated tax amount. QuickBooks multiplies the rate by Line 14 to arrive at the tax due. The rate must be formatted with four decimal places (N.NNNN%).

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 your business has received a SUTA Penalty Rate assignment, check the “Yes” box on the form and QuickBooks will automatically calculate the penalty and enter 2.0000% on Line 16.

If the assigned rate exceeds 2%, the employer must manually edit the rate so the penalty calculates correctly — again using the N.NNNN% format.

Line 17 — Late Filing Penalty

Kansas assesses a late filing penalty calculated as 0.5% of total wages. QuickBooks displays this amount when applicable.

Getting the Numbers Right

When questions arise about where QuickBooks pulled a specific figure, the form window includes a hyperlink that traces values back to their source within the payroll data. The Help button on the form itself offers guidance on general form-window navigation and field-specific troubleshooting.

For employers who want to cross-reference outside of QuickBooks, the software can summarize payroll data for export to Excel — useful for reconciling quarterly totals before filing.

Filing and Saving

QuickBooks allows users to save a copy of the completed form for their records. For those meeting the electronic filing threshold — or any employer who simply prefers the convenience — e-file and e-pay options are available directly through the form interface.

The broader takeaway: QuickBooks automates the arithmetic, but the accuracy of a K-CNS 100 still depends on clean payroll data entered throughout the quarter. Verifying worker counts, confirming tax rates, and checking for any SUTA penalty assignments before submission can prevent filing errors and avoidable penalties down the line.