BudgetingB03

UK Council Tax & Utilities Bill Calendar

£9.99digital download

Lines up council tax and every direct debit into one month-by-month grid, with the real 10-month cycle built in.

  • Excel (.xlsx)

Who it's for: UK households and renters who want to see exactly what leaves their account each month, council tax included.

About this template

Most budget spreadsheets treat council tax like any other monthly bill, but in the UK it's normally spread over 10 instalments from April to January, with nothing due in February and March — and you have the right to switch to 12 months instead. This calendar builds that in properly: enter your annual council tax once, pick your plan, and every month shows the correct instalment. Your other direct debits — energy, water, broadband, TV Licence, insurance, subscriptions — line up alongside it in one clean grid.

The five tabs include:

  • Settings, with a live 'council tax at a glance' panel for your chosen plan
  • Bills, the one tab you really type into: name, category, payee, due day, frequency and amount
  • A Bill Calendar with a 12-column April-to-March grid, monthly and running totals, and your most and least expensive months
  • A Council Tax & UK Bills guide covering the mechanics in plain English

Enter £1,800 a year and the sheet splits it to £180 across April–January (£0 in February and March) on the standard plan, or £150 every month on the 12-month plan, with April carrying any odd pennies so the total matches your bill exactly. A 34-bill worked example was independently re-checked across both plans, quarterly and half-yearly bills, and a negative credit. 94 of 94 QA checks pass.

This is a planning and organising tool — it never moves money or contacts your council or suppliers.

What's inside

  • Settings: billing year and 10-/12-month council-tax plan
  • Bills log (name, category, payee, day, frequency, amount)
  • Bill Calendar: 12-column grid with monthly and running totals
  • Most/least expensive month callouts
  • Council Tax & UK Bills guide (10-month cycle, single-person discount)
  • QA & Version tab (94/94 checks)

Ready to download?

Get it on Etsy — £9.99

General information, not tax or financial advice. Always confirm your own position with HMRC or a qualified adviser. Created with AI assistance under the owner's direction; every formula is human-verified against a worked example, with a QA sheet included in the download.