Kansas Quarterly Wage Report (Form K-CNS 100) in QuickBooks: What Users Need to Know

QuickBooks users responsible for Kansas unemployment tax filings have raised questions about where to find and how to complete Form K-CNS 100, the Kansas Quarterly Wage Report and Unemployment Tax Return. The form is used to report wages paid and unemployment insurance tax due to the State of Kansas on a quarterly basis, and QuickBooks is designed to prefill most of the relevant fields automatically based on existing company, payroll, and employee data.

What the Form Covers

Form K-CNS 100 consolidates quarterly wage reporting and unemployment tax obligations for Kansas employers. QuickBooks pulls wage and payroll information directly from the company file to populate the form, which generally means that if all payroll data has been entered correctly throughout the quarter, minimal manual input is required. However, several fields demand careful review, and in some cases manual entry, before the form is ready to be filed.

One important threshold: employers with 50 or more employees, and third-party administrators handling 50 or more client employees, are required to both file the form and remit payment electronically.

Fields That May Require Manual Entry

While QuickBooks handles the bulk of the calculations, users should pay particular attention to lines that depend on agency-assigned rates or specific headcount methodology.

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 even if their earnings exceeded the taxable wage limit for the quarter. Because this is a headcount tied to a specific pay period rather than a simple roster total, it is one of the values QuickBooks may not fully automate.

Lines 12 Through 14 — Wage Breakdown

• Line 12 (Total Wages): This should equal the sum of gross wages for the quarter as reported in the form’s wage column, plus any totals from accompanying Schedule A (Form K-CNS 101) attachments.
• Line 13 (Excess Wages): The portion of total wages that exceeds the taxable wage limit for the quarter.
• Line 14 (Taxable Wages): Total taxable wages for the quarter after subtracting excess wages.

These lines are generally derived from payroll data already in QuickBooks, assuming all wages have been recorded accurately.

Line 15 — Unemployment Tax Due

QuickBooks calculates the tax amount by multiplying the employer’s tax rate by the taxable wages on Line 14. The tax rate must be entered in a precise format — four decimal places expressed as a percentage (for example, a rate entered as a number followed by a percent sign with four digits after the decimal point). An incorrectly formatted rate will produce an inaccurate tax calculation.

Line 16 — SUTA Penalty Rate

This line applies only to employers who have been assigned a State Unemployment Tax Avoidance penalty rate by the Kansas Department of Labor. The minimum penalty rate is 2 percent. If you have been assigned a SUTA penalty rate, checking the “Yes” box on the form prompts QuickBooks to automatically calculate the penalty and enter the default 2 percent rate on Line 16.

However, if the assigned penalty rate exceeds 2 percent, you must manually edit the rate so the penalty is calculated correctly. This is a common pitfall — leaving the default rate in place when the agency has assigned a higher one will understate the amount due.

Filing and Payment Options

QuickBooks supports both electronic filing and electronic payment for the Kansas quarterly return. Users who meet the 50-employee threshold are required to file and pay electronically, though the option is available to all filers. The form window includes access to filing and payment tools, and users can save a copy of the completed form for their records.

For employers who need to review or reconcile their payroll data outside of QuickBooks before filing, the software offers the ability to summarize payroll data in a spreadsheet format, which can be useful for cross-referencing wage totals against the form’s calculated values.

Reviewing Prefilled Data

The core takeaway from the community discussion is straightforward: QuickBooks does the heavy lifting on Kansas Form K-CNS 100, but the form is only as accurate as the data feeding it. Employers should verify that all quarterly wages have been posted, confirm that any agency-assigned rates — whether standard unemployment tax rates or SUTA penalty rates — are entered correctly and in the proper format, and review the worker headcount on Line 11 against the specific payroll period including the 12th of each month in the quarter.

For general payroll form troubleshooting, the in-product Help button on the form window provides field-level guidance and links to explanations of how QuickBooks arrived at each calculated figure.