QuickBooks State Forms: Kansas K-CNS 100 Quarterly Wage Report

QuickBooks Desktop and QuickBooks Online both support the Kansas Quarterly Wage Report and Unemployment Tax Return — Form K-CNS 100 — and in most setups the software prefills the majority of fields automatically from existing payroll data. Even so, several lines on this state form demand manual attention, and employers who skip the review step risk filing incorrect wage totals or miscalculating penalties and interest.

What QuickBooks Fills In Automatically

When all company, payroll, and employee data is current inside QuickBooks, the software populates most of the K-CNS 100 without additional input. The general workflow is to open the state forms section from within the payroll area, select Kansas as the state, and choose the quarterly unemployment form for the relevant quarter. Once generated, the form should be reviewed line by line rather than filed immediately — QuickBooks handles the heavy lifting, but it cannot verify every figure on its own.

Electronic Filing Threshold

One point worth flagging up front: Kansas requires electronic filing and payment for employers with 25 or more employees, and for third-party administrators handling 25 or more client employees. Smaller employers have more flexibility, but the 25-employee threshold is the cutoff to keep in mind when deciding whether to e-file.

Lines That Need Manual Review

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 each month in the quarter. The figure should include workers even if their earnings exceeded the taxable wage limit for the year.

Line 12 — Total Wages

This line should equal the combined gross wages for the quarter across all columns and any attached Schedule A forms (K-CNS 101). If the number looks off, the discrepancy usually traces back to a missing or duplicated paycheck entry earlier in the quarter.

Line 13 — Excess Wages

Excess wages are the portion of total wages reported on Line 12 that exceeds the annual taxable wage limit during the current quarter. QuickBooks calculates this based on the wage base configured in your state unemployment setup, so verifying that setup is worthwhile if the figure seems unexpected.

Line 14 — Taxable Wages

This is straightforward: total wages minus excess wages equals taxable wages for the quarter.

Line 15 — Unemployment Tax Due

QuickBooks multiplies your assigned tax rate by the taxable wages on Line 14. The critical detail here is format — the rate must be entered as a four-decimal percentage (for example, a rate written in the pattern of a single digit, a decimal point, and four trailing digits). An incorrectly formatted rate will throw off the entire calculation.

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 assigned penalty rate is at minimum 2 percent. If you have received a SUTA penalty assignment, check the “Yes” box on the form and QuickBooks will calculate the penalty automatically using the 2 percent floor. However, if your assigned rate is higher than 2 percent, you must manually edit the rate so the penalty calculates correctly — again using the four-decimal format.

Line 17 — Late Filing Penalty

Late filings trigger a penalty of half a percent of total wages for each month the return is overdue, with partial months rounded up. The minimum assessment is $25 and the maximum is $200. Even a return reporting zero wages will be hit with the $25 minimum if it is delinquent.

Line 18 — Interest on Late Payment

Past-due unemployment taxes accrue interest at 1 percent per month, again with partial months rounded up. To compute the amount, multiply the number of months late by 1 percent, then multiply that result by the tax due shown on Line 15.

Line 19 — Prior Overpayment

If you overpaid unemployment taxes in a previous quarter, you can apply that credit here. The process involves completing a separate adjustment form — K-CNS 111 — and entering the total tax overpaid. If the state agency sent a formal credit memo (K-CNS 2101), that document serves as the reference for the overpayment amount.

The Bottom Line

QuickBooks handles the arithmetic and prefills the bulk of the K-CNS 100, but the form still requires a careful line-by-line check before submission. Tax rate formatting, penalty overrides, and prior-quarter credits are the areas most likely to cause problems if left unreviewed.