UK Monthly Budget Planner Spreadsheet: April to March, Council Tax, TV Licence, Energy & Bills, Side Hustle Income + Tax Bill Pot (Excel & Google Sheets)
A simple UK budget spreadsheet that runs April to March, with the bills UK households actually pay, a side-hustle income line and a Tax bill pot. Plan once, log as you go, and see what's left each month. Works in Excel and Google Sheets.
Lots of budget templates are built for the US: no council tax, no TV licence and a January to December year. This one is built for UK households.
What it does
• UK categories ready to go: take-home pay, side-hustle income, rent or mortgage, council tax, energy, water, TV licence, home insurance, mobile, broadband, subscriptions, travel and commute, fuel and car, childcare, groceries and more. Rename or add your own (up to 40).
• April to March budget year: runs April to March, close to the UK tax year (6 April to 5 April), so your side-hustle income and tax savings sit in roughly the same year. Months are whole calendar months.
• Type it once: enter a usual monthly amount and it fills all 12 months. Change any single month that's different, like a yearly insurance payment or the months with no council tax instalment.
• Money Log: one row per payment in or out. The Actuals sheet adds it all up for you.
• Dashboard: pick a month to see planned vs actual, what's left over, and a status for every category (within plan, over plan, on track).
• Tax bill pot: set your own target and watch your progress as you put money aside each month.
• Month-by-month table and chart for the whole year.
What's included
• UK-Monthly-Budget-Planner.xlsx: the blank planner.
• UK-Monthly-Budget-Planner-EXAMPLE.xlsx: the same file filled with clearly labelled made-up figures.
• A Google Sheets guide.
Good to know
• Not tax advice or financial advice: it's a budgeting tool. It doesn't work out tax, bills or benefits; the Tax bill pot target is your own figure.
• Plain formulas only: no macros, no add-ons, no subscription.
• Refunds and cancellations: https://payhip.com/BootstrapSheets/refunds-and-cancellations (your statutory rights aren't affected).
• From Bootstrap Sheets: plain, UK-focused spreadsheets for side hustles and small budgets.