UK VAT Registration Threshold Tracker — rolling 12-month check, register-by and effective dates (Excel)

Know the month you cross the VAT line and the exact dates that follow.

A simple Excel tracker for UK sole traders and side-hustlers. Enter your monthly taxable turnover; the sheet computes your rolling 12-month total, flags the first month you go over the VAT registration threshold, and shows the date you must register by and the date your registration takes effect. A separate test covers the "next 30 days alone" rule.

WHAT'S INSIDE (3 sheets)

README: plain-English instructions and the GOV.UK rules used

Turnover: monthly entries with rolling 12-month total and an OVER flag

Check: first month over, register-by date, effective date, headroom, next-30-days test

BUILT FROM GOV.UK RULES (checked 14 October 2026)

The 90,000 GBP registration threshold (editable in the file if the figure changes)

Register within 30 days of the end of the month you went over

Effective from the first day of the second month after you went over

Next-30-days test: register by the end of that 30-day period

INSTANT DOWNLOAD: Excel (.xlsx). Works in Excel, LibreOffice and Google Sheets (upload to Drive).

Not tax advice. Not affiliated with HMRC. This is a record-keeping tool only. Check your own position on GOV.UK or with a qualified adviser.