formualizer

Excel workbook · Catalog edition 2026

Kentucky Withholding Tax Calculator 2026

Kentucky Department of Revenue

Calculate Kentucky 2026 employer withholding from taxable wages and exact pay-frequency selections using the publisher's workbook.

Inputs
5
Outputs
3
File size
113 KB
Verification
Independent scenario check

Try it

Try it loads a copy of this file from formualizer.com.

Calculation of WithholdingA6:D12

Saved workbook valuesInputOutput

RowABCD
6Employee Name (Optional)Select Pay FrequencyEnter Taxable Wages Per Pay PeriodWithholding
7
8
9
10
11
12

What was checked

Changed-input scenarios match an independent calculation.

Scope and limitations

Catalog calculations, not certification.

Try it uses Formualizer’s formula adjustment to report zero when the withholding workbook displays a blank.

Calculation of Withholding!A1 identifies 2026.

  • The workbook title identifies 2026. The source has no cached formula values for any of its 3988 formulas, so baseline Excel-cache parity cannot be claimed; independent arithmetic covers all six frequency factors, low wages, thresholds and final-row behavior.
  • The runtime adapter wraps only D7, D8 and D2000 in N(originalFormula), converting source empty-string display blanks to numeric zero at mapped outputs. Positive-wage numeric results are unchanged. Original XLSX bytes remain intact and traces expose N(). Other rows selected through selectCells retain source blank strings.
  • The workbook applies 3.5% to annualized taxable wages less $3,360, divides by frequency and floors negative withholding to zero. It does not round formulas to cents; retain returned precision or apply payroll-system rounding separately.
  • Exact lookup strings are Monthly, Semi Monthly, Weekly, BI-Weekly, Daily and Annual. Positive wages with blank or invalid frequency produce a source lookup error. Quick-flow enum enforces spelling; schedule enum conventions are documented and must be followed by callers.
  • Quick flow deliberately has two inputs and one output because that is the complete single-employee calculation. There are no filing-status, allowances or additional-withholding inputs in the publisher's source.
  • Full flow maps all 1994 source rows as 1994×1 column arrays. Source blank cells remain blank if omitted. Avoid overlapping scalar and schedule writes in the same request. Presentation headings and hidden lookup constants are not editable ports.
  • Full-flow mapped outputs are first, second and last employee diagnostics. For other employees request Calculation of Withholding!D<row> through selectCells and trace that cell explicitly. The runtime trace collector does not automatically expand range outputs, so outputs use scalar coordinates.
  • This is a version-pinned workbook mapping, not payroll advice or a Kentucky Department of Revenue endorsement. No live check of the publisher's latest release was performed.
  • The source returns either a blank string or a number. The mapped scalar outputs convert blank display values to numeric zero.

What it computes

Ports for the compact flow: quick_withholding. The full port contract includes all 8 ports.

Inputs (2)
Port / descriptionType / constraints / default
pay_frequency

Exact source enum: Monthly (12), Semi Monthly (24), Weekly (52), BI-Weekly (26), Daily (365), Annual (1). Source default blank/null; required with positive wages. No mode switch.

Type: string

Constraints: nullable: true; one of: Monthly, Semi Monthly, Weekly, BI-Weekly, Daily, Annual

Default: null

taxable_wages

Nonnegative USD taxable wages for one pay period; source default blank/null treated as zero. Supply taxable wages after applicable payroll exclusions, not annual gross wages.

Type: number

Constraints: nullable: true; min: 0

Default: null

Outputs (1)
Port / descriptionType / constraints / default
withholding

Nonnegative USD withholding for row 7, unrounded source formula (display formats show cents). Runtime N(originalFormula) converts source display blanks to zero.

Type: number

Questions this workbook answers

  • How is 2026 Kentucky employer withholding calculated?
  • What pay frequencies does Kentucky support?
  • Does this Kentucky workbook round withholding to cents?

Questions and answers

How is 2026 Kentucky employer withholding calculated?

Annualize taxable pay with the source frequency factor, subtract $3,360, multiply by 3.5%, divide by frequency, and floor the withholding at zero.

What pay frequencies does Kentucky support?

Monthly=12, Semi Monthly=24, Weekly=52, BI-Weekly=26, Daily=365 and Annual=1. Exact source spelling is required.

Does this Kentucky workbook round withholding to cents?

No. The display format shows cents but formulas retain precision. Returned results preserve that source behavior.

For agents

Connect an MCP client to the catalog endpoint:

https://catalog.formualizer.com/v1/mcp

Slug: ky-withholding-tax · Edition: 2026

search_workbooks
Optional arguments: query (string), theme (string), tag (string).
inspect_workbook
Required: slug (string). Optional: edition (string), flow (string).
evaluate_workbook
Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
  "name": "evaluate_workbook",
  "arguments": {
    "slug": "ky-withholding-tax",
    "edition": "2026",
    "flow": "quick_withholding",
    "inputs": {
      "pay_frequency": "Weekly",
      "taxable_wages": 1000
    }
  }
}

cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.

Flows

quick_withholding

Quick Kentucky withholding

The single-employee calculation has two inputs. Omitted inputs retain the source blank cells. Returns unrounded per-period tax. The mixed string/number Hidden Table!H7 pre-floor diagnostic is available through selectCells.

2 input ports · 1 output ports. Full membership in the port contract.

full_payroll

Full Kentucky payroll schedule

All 1994 source payroll rows can be populated through three column schedules. Scalar outputs trace the first, second and last employees; use selectCells for any other Calculation of Withholding!D row and an explicit trace coordinate for its lineage. Do not combine scalar row-7 inputs with overlapping schedule inputs.

5 input ports · 3 output ports. Full membership in the port contract.

REST example

Bundle scenario: weekly · Flow: quick_withholding

curl 'https://catalog.formualizer.com/v1/models/ky-withholding-tax/2026/evaluate?flow=quick_withholding' \
  -H 'Content-Type: application/json' \
  --data '{"inputs":{"pay_frequency":"Weekly","taxable_wages":1000}}'

Expected response

Expected values from the bundle, subject to the check level above.

{
  "outputs": {
    "withholding": 32.73846153846154
  }
}

Looking for another spreadsheet? Request a workbook.