← TemplatesKRA & statutory

Free Turnover Tax (ToT) Estimator (Excel) for Kenya

Turnover Tax is simple — 1.5% of gross monthly sales — but the thresholds catch people out. This free estimator does the maths: enter each month's sales, see your ToT and your running yearly turnover, and get a clear warning the moment you cross the KES 1 million or KES 25 million KRA boundary.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

1.5% ToT per month + running yearly turnover
Threshold warnings at KES 1M and KES 25M
Rate + bands isolated on an editable, dated Rates tab
Annual ToT total and monthly chart
Plain-language status: below / in-band / above

The tabs

Start Here (guide)
Rates (dated + sourced)
Turnover
Dashboard

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

The 1.5% rate and the KES 1M / 25M band live on a Rates tab, each dated and sourced, so if KRA moves a figure you change one cell. Enter your monthly gross sales and the sheet computes ToT per month, your cumulative turnover for the year, and the annual total. The Dashboard tells you plainly whether you're below the band (ToT optional), inside it (file 1.5% monthly), or above KES 25M (time to register for VAT and normal tax).

ToT is charged on gross sales with no expense deductions and is filed monthly by the 20th — the guide spells this out. Opens in Excel or Google Sheets. Always confirm current rates at kra.go.ke before filing.

To keep the sales records behind these numbers, Biashara Yangu tracks your takings automatically, free.

Do it online instead

Track the sales behind ToT — free with Biashara Yangu

Open the free tool →

Frequently asked questions

Who pays Turnover Tax in Kenya?

ToT is for resident businesses whose gross annual turnover is between KES 1 million and KES 25 million. It's 1.5% of gross monthly sales, filed and paid by the 20th of the following month. Confirm current rules at kra.go.ke.

What happens if my turnover crosses KES 25 million?

You must leave ToT and register for VAT and normal income tax. The dashboard warns you as soon as your running turnover crosses the threshold, so you can act early rather than fall foul of KRA.

Are expenses deducted from ToT?

No. Turnover Tax is charged on gross sales, with no deduction for expenses — which is why it's simple but why keeping accurate sales records matters.

VAT Return (VAT-3) Prep →KRA Tax Calculator →Duka Income & Expense Tracker →All templates →