Household budget planner (UK): council tax, energy, bills and sinking funds in one sheet
A household budget planner for the UK has to do three things a generic template does not: put council tax in the right months (usually ten monthly instalments, twelve if the council agrees to spread them), turn energy unit rates and standing charges into a monthly estimate that can be checked against the Direct Debit, and spread annual bills such as the MOT, insurance or the boiler service over twelve months.
What a UK budget planner must handle
Start with the pay rhythm. Weekly, fortnightly, four-weekly and monthly pay do not land in the same way: in most years, four-weekly pay gives 13 payments (52 weeks divided by four), so one month contains two, and fortnightly pay gives 26, so two months contain three. A planner that only knows monthly income gets those months wrong.
The Money and Pensions Service publishes a free online Budget Planner on MoneyHelper; the GOV.UK algorithmic transparency record for that tool (published 10 February 2025) describes it as "a free online tool", "taking just 5-10 minutes to complete", and says users can download their budget as an Excel spreadsheet. It is a good first pass; the structure below is for the file you keep month after month.
| Block | Why it is UK-specific | What the sheet calculates |
|---|---|---|
| Income with real paydays | Weekly, fortnightly, four-weekly and monthly pay | Which months carry an extra payday; irregular income smoothed |
| Council tax | Usually 10 instalments, 12 if the council agrees, discounts to check | The amount in each month, or a smoothed twelfth |
| Energy | The Ofgem cap is updated every three months | Yearly cost from meter readings; catch-up or credit against the Direct Debit |
| Bills and subscriptions | Annual renewals and commitment end dates | Yearly cost; the saving of each cancellation decision |
| Sinking funds | MOT, servicing, tyres, boiler, gifts | Monthly amount to set aside; balance of each pot |
| Monthly budget | Everything above linked in | Planned against actual, left after fixed bills, balance, savings rate |
Council tax: 10 or 12 instalments
GOV.UK's page on paying your council tax bill (consulted 19 October 2026) says the cost "is usually split into 10 monthly payments"; if you are having trouble paying, it advises contacting your council, which can help "by spreading your payments over 12 months instead of 10". On a fictitious annual bill of £1,800, ten instalments mean £180 in each of ten months and nothing in the other two; twelve mean £150 every month.
A planner handles this in one of three ways: type the ten instalments where they fall; type twelve if the council has agreed; or budget a twelfth every month and let a small pot absorb the two empty months, which keeps the monthly budget constant without asking the council for anything.
A full bill is based on at least two adults living in the home; "you'll get 25% off your bill" if you live on your own, 50% if everyone in the household is disregarded, and full-time students are among the people not counted; you have to apply, even if you are disregarded (GOV.UK, "Council Tax: who has to pay", consulted 19 October 2026). The band is assessed by the Valuation Office from the property's value on 1 April 1991 in England (bands A to H) and 1 April 2003 in Wales (bands A to I), per GOV.UK's guidance on how bands are assessed, last updated 15 June 2026. More in Council tax in your monthly budget: instalments, bands and discounts to check.
Energy and the price cap
The Ofgem price cap does not cap your bill. It sets a ceiling on "the maximum rates and standing charges that energy suppliers can charge" customers on default tariffs, and it is updated every three months (Ofgem press release of 26 August 2026). For 1 October to 31 December 2026, Ofgem puts an average household using both electricity and gas at £1,723 over a year, up from £1,663; the average Direct Debit rates it publishes for that period, across England, Scotland and Wales, are 26.32p per kWh and 54.83p a day for electricity, 7.97p per kWh and 29.68p a day for gas (Ofgem, energy price cap unit rates and standing charges, consulted 19 October 2026). Your own bill's rates are the ones to type.
The useful calculation is your own yearly cost. Take a fictitious home using 2,900 kWh of electricity and 11,000 kWh of gas a year, at those average rates:
- Electricity: 2,900 × 26.32p = £763.28, plus 365 × 54.83p = £200.13, giving £963.41.
- Gas: 11,000 × 7.97p = £876.70, plus 365 × 29.68p = £108.33, giving £985.03.
- Total: £1,948.44 a year, or £162.37 a month.
If that household's Direct Debit is £140, it builds a shortfall of about £22 a month at these rates, before the next quarterly change. The mechanics are in Energy bills in your budget (UK): the price cap, standing charges and monthly estimates.
Subscriptions and annual bills
The bills tab is a list with five columns: name, amount, frequency, commitment end date and "Do I use it?". The sheet turns amount and frequency into a yearly cost, and the answer to the last question into a decision with its saving. Annual bills, such as insurance, breakdown cover, a TV licence or a software renewal, sit here with their renewal month, so that the monthly budget carries a twelfth of each.
Sinking funds
A sinking fund is a monthly amount set aside for a cost that is certain but not monthly: MOT and servicing, tyres, boiler service, gifts, a holiday, school costs. For each one, the sheet needs the target amount, the month it falls, what is already in the pot and the number of months left; the monthly amount is the difference divided by the months left. A twelve-month calendar then shows which pots pay out when.
Monthly review
Once the sheet exists, the monthly review is a short routine:
- Type the actual amounts of the month just ended, by category, from the banking app.
- Type the electricity and gas readings; check the catch-up or credit against the Direct Debit.
- Check the council tax line: was the instalment taken, and is one of the two empty months coming?
- Move the sinking fund amounts to the savings pot and mark the pots that paid out.
- Read three figures: left after fixed bills, the balance, and the savings rate.
- Look at the lines over plan three months running and decide whether the plan or the spending should change.
New to budgeting? Start with one month: Free monthly budget template for Excel: the 15-minute method.
FAQ
Can I pay council tax over 12 months instead of 10?
GOV.UK says the cost is usually split into 10 monthly payments and, if you are having trouble paying, that your council can help by spreading it over 12 months instead; contact the council to ask. In the planner, you can also keep the 10 instalments and budget a twelfth every month, letting a small pot carry the two months with no payment.
Does the energy price cap limit my total bill?
No. It limits the unit rates and standing charges suppliers can charge customers on default tariffs. Your bill is your usage multiplied by those rates, plus the standing charges for the days in the period.
Does this structure work in Scotland or Northern Ireland?
Most blocks apply anywhere. The council tax block follows the England and Wales rules on GOV.UK; Scottish council tax bands and Northern Ireland domestic rates are not covered by the planner.