Household bills tracker spreadsheet: keep every UK bill in one place
Set up a simple spreadsheet for council tax, energy, broadband and the rest, with due dates and annual bills, plus templates we've checked.
A bills tracker answers one question: what’s due, when, and how much? It’s the easiest money spreadsheet to keep going, because bills don’t change much from month to month.
The columns to use
| Column | Why it helps |
|---|---|
| Bill | Council tax, energy, water, broadband and so on |
| Provider | Who you pay |
| Amount (£) | The current amount, updated when prices change |
| How often | Monthly, quarterly, yearly, or ten-monthly for council tax |
| Due date | The day it leaves your account |
| Paid by | Which account or card |
| Contract ends | So you can shop around before it rolls over |
Don’t forget the awkward ones
- Council tax is often paid over ten months, which leaves two months clear. Note which ones.
- Annual bills like car insurance or the TV licence: divide by twelve and put that aside each month.
- Subscriptions: list them all. It’s usually the quickest place to save.
Templates that fit
Money Management Template
by Vertex42
A worksheet for tracking account balances, bills and spending in one place.
Free from Vertex42. It keeps account balances, bills and spending in one running view.
The Ultimate Budgeting Sheet
by Payhip seller
A twelve-month budget that handles weekly, fortnightly and four-weekly payments on their real dates.
£5.50 on Payhip. It handles weekly, fortnightly, four-weekly and yearly payments on their real dates, which suits bills that don’t fall monthly.
Rent Payment Schedule
by Spreadsheet123
A schedule for logging rent due and received.
US$9.95 from Spreadsheet123. A schedule for logging rent due and received, for tenants or landlords.
If you’d like bills inside a full budget, see the budget roundup. It includes Budget Grid (£4.99, made by us).
Questions
Which bills should go on the list?
Everything that leaves your account on a schedule: rent or mortgage, council tax, energy, water, broadband, phones, insurance, the TV licence, subscriptions and debt payments.
How do I handle annual bills?
Note the yearly cost and divide it by twelve. Set that amount aside each month so the bill doesn't land all at once.
How often should I update it?
Once a month is enough for most households, plus a quick check whenever a contract or price changes.