Household budget spreadsheet UK: Excel, Google Sheets and bills tracker

A household budget spreadsheet (or UK household budget Excel / Google Sheets file with a bills tracker) is the working workbook where you set a monthly plan, log what actually comes in and goes out, convert every bill to a monthly figure, get alerts before contracts end, and track savings goals. This UK guide compares a spreadsheet to the January method walk-through, a Christmas budget spreadsheet and sole-trader bookkeeping, shows the sheets that match a ready Dashboard / Budget & 12-month / Bills & renewals / Savings goals layout, covers Excel vs Sheets, and includes a free DIY method. Sample rows below are made-up. It is not legal, tax or financial advice. For council tax, energy and sinking-fund steps in plain English, use our January budget reset guide first — this page is about the spreadsheet/template workflow, not rewriting that method.

Spreadsheet vs January method vs Christmas budget vs sole-trader bookkeeping

UK searches for "household budget spreadsheet" mix four different jobs. Use the right tool:

WhatJobTypical format
Household budget spreadsheet (this page)Set planned vs actual, track bills as a monthly cost, renewals and savings goals in one reusable fileExcel or Google Sheets (working file)
January budget reset guideMethod: list income, convert bills to monthly, check energy, sinking funds and the three-number checkArticle steps (no download required)
Christmas budget spreadsheetSeasonal category budgets, gift limits and a payday savings plan for Christmas onlyExcel or Google Sheets — see Christmas budget spreadsheet UK
Sole trader bookkeeping spreadsheetBusiness income, expenses and mileage by tax year — not household billsExcel or Google Sheets — see sole trader bookkeeping spreadsheet UK

A simple flow: learn the method on the January budget reset, keep the live numbers in the household spreadsheet, put Christmas money in the Christmas spreadsheet (or the Christmas Budget Planner (£2.99)), and keep business books in the UK Sole Trader Bookkeeping & Self Assessment Tracker (£6.95) — do not mix household and sole-trader columns in one file.

What sheets a UK household budget spreadsheet needs

A practical layout matches the same shape as the UK Household Budget & Bills Tracker (£4.95):

Council tax banding, energy price-cap detail and how to set sinking funds live on the January budget reset — use that guide for the method; use this page for the file layout.

Excel vs Google Sheets for a household budget

NeedExcel (.xlsx)Google Sheets
Working offline / weak Wi-FiStrongNeeds a connection (or offline mode set up first)
Sharing with a partnerOneDrive / email copiesShare a link; both edit live
Drop-downs for frequency / methodData Validation → ListData → Data validation → Dropdown
Monthly equivalent of an annual bill=amount/12 (or /4 for quarterly)Same formula
UK £ and DD/MM/YYYYFormat cells / regional settingsFile → Settings → Locale: United Kingdom

A common UK workflow is to build in Excel, then upload the .xlsx to Google Drive so both of you can update it on a phone. The UK Household Budget & Bills Tracker (£4.95) ships as .xlsx for that reason.

Example budget and bills rows (made-up)

The rows below are a made-up example for an imaginary household. They are illustrative only — not typical amounts, averages or advice.

Category (example)Plan £ / month (example)Actual £ this month (example)Notes (example)
Example — Rent / mortgage950950Paid on the 1st
Example — Council tax14014010-month instalments; Feb/Mar often £0
Example — Energy160175Cold snap; Direct Debit review next month
Example — Food shop320298Under plan this month
Bill (example)Amount (example)Frequency (example)Monthly equiv. (example)Contract end (example)
Example — Broadband£32Monthly£3214 Mar 2027 — shop around from Feb
Example — Car insurance£480Annual£4022 Jun 2027
Example — TV licence£174.50Annual£14.54—

Made-up savings-goal example: Emergency buffer · target £1,000 · by 30 Jun 2027 · saved £250 so far · £62.50 / month. These figures are fiction for layout only.

How to make a household budget spreadsheet yourself (free DIY)

  1. Sheet 1 — Income: take-home pay, Child Benefit and any other regular income as monthly figures. If income varies, use a cautious month.
  2. Sheet 2 — Budget: one row per category; columns for plan £ and each month's actual. Add a totals row and a planned-vs-actual variance.
  3. Sheet 3 — Bills & renewals: name, amount, frequency, monthly equivalent (=IF(freq="Annual",amount/12,IF(freq="Quarterly",amount/4,amount))), next payment, contract end, alert if contract end − TODAY() ≤ 45.
  4. Sheet 4 — Savings goals: target, date, saved so far, monthly save = (target − saved) / months left.
  5. Sheet 5 — Dashboard: SUM of plan, SUM of actuals this month, top categories (LARGE / SORT), and a simple month-by-month chart.
  6. Payday ritual: ten minutes each payday — update actuals, check renewals, move the savings transfer. Pair food spending with the weekly meal planner UK guide and the Meal Planner & Shopping List (Printable A4) (£3.25); pair home routines with the cleaning schedule template UK and the Cleaning Schedule & Home Planner (Printable A4) (£3.25).

Prefer not to build the monthly-equivalent formulas, contract alerts and dashboard yourself? The UK Household Budget & Bills Tracker (£4.95) already includes Dashboard, Budget & 12-month tracker, Bills & renewals, Savings goals, drop-downs and Start Here for UK households.

DIY vs ready template vs Christmas vs business books

What is (and is not) in the UK Household Budget & Bills Tracker

More: January budget reset · Christmas budget spreadsheet UK · sole trader bookkeeping spreadsheet UK · weekly meal planner UK · cleaning schedule template UK · 2027 planner UK · 2027 calendar UK

Free tools for this

Frequently asked questions

What is a household budget spreadsheet?

A working Excel or Google Sheets workbook where you set a monthly plan, log actual income and spending, convert bills to a monthly equivalent, track renewals and savings goals. It is different from a one-off paper budget and from a Christmas-only or business bookkeeping spreadsheet.

Is a household budget spreadsheet the same as the January budget reset guide?

No. The January budget reset guide is the method (list income, convert bills, energy, sinking funds, three-number check). This page is the spreadsheet layout. Use the method guide for the steps; use the spreadsheet to keep the numbers live.

Can I make a UK household budget in Excel or Google Sheets?

Yes. Use Income, Budget (plan vs actual by month), Bills & renewals with a monthly-equivalent formula and contract-end alerts, Savings goals, and a Dashboard. Or start from a ready UK template such as our UK Household Budget & Bills Tracker.

How do I track bills and renewals in a spreadsheet?

List each bill with amount, frequency, monthly equivalent, payment method, next payment and contract end. Flag rows where the contract end is within about 45 days so you can shop around before the price rises. Our tracker includes those columns and alerts.

What UK categories should a household budget include?

Common rows include housing, council tax, energy, water, broadband, mobile, TV licence, insurance, transport (including road tax / VED), childcare, food, and income lines such as Child Benefit. A ready UK template may list 36 categories with spare rows so you can rename what you need.

DIY household budget spreadsheet or a ready template?

DIY suits you if you are happy building monthly-equivalent formulas, alerts and a dashboard. A ready template such as our UK Household Budget & Bills Tracker (£4.95) suits you if you want Dashboard, Budget & 12-month tracker, Bills & renewals, Savings goals and Start Here already set up for Excel and Google Sheets.

How does a household budget differ from Christmas or sole-trader spreadsheets?

A household budget is year-round home income, bills and savings. A Christmas budget spreadsheet is seasonal categories and gift limits. Sole-trader bookkeeping is business income and expenses for Self Assessment. Keep household and business in separate files.

What is included in the UK Household Budget & Bills Tracker?

Dashboard (planned vs actual, this month, year so far, spending by group, top 5 outgoings, month-by-month chart); Budget & 12-month tracker with 36 UK categories; Bills & renewals with monthly equivalent and contract-end alerts; Savings goals; editable drop-downs; Start Here. Excel .xlsx for Google Sheets upload. UK edition in £ with DD/MM/YYYY. Digital download; planning tool only — not legal, tax or financial advice; nothing is posted.

Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.