SpreadsheetsUK Energy Bill Tracker
Instant download
£4.49£4.99 on Etsy · buy direct and save 10%
Buy now: instant downloadChristmas offer: 10% off with code XMAS10 at checkout, until 24 December 2026.
Or get every ThextonLabs product, including this one, in one go (new products included). See the Everything Pass
- Instant digital download, nothing is posted
- Files: PDF, XLSX
- Use on phone, tablet or computer
- Personal use licence
Checkout is handled securely by Stripe. Your download link appears straight after paying. See refunds & licence.
★★★★★
“Very happy with my purchase, instructions for download was easy to understand”
Etsy buyer review
Know exactly what your gas and electricity cost, and whether your direct debit is right. Made for UK homes: pence per kWh, standing charges, 5% VAT, and metric (m³) or imperial (ft³) gas meters.
Just type your meter readings. The spreadsheet does the rest.
WHAT IT DOES
- Turns meter readings into kWh and £: unit rates, daily standing charges and VAT all included
- Converts gas readings (m³ or ft³) into kWh the same way suppliers do, using the calorific value on your bill
- Cost for every reading period, plus your cost per day
- DIRECT DEBIT CHECK: tells you in plain English if you're paying too much or too little each month
- Account balance: in credit or owing, from your payments and refunds
- Estimated monthly and yearly cost, and your yearly kWh for electricity and gas
- Monthly view with a cost-by-month chart (electricity and gas)
- TARIFF COMPARE: type up to 3 quotes and see what each would cost on YOUR real usage, standing charges and exit fees included. The cheapest is highlighted
- Electricity only? Pick "no gas" and gas is left out
- Saving checklist: 22 simple ways to use less, to tick off as you go
WHAT YOU GET
- UK Energy Bill Tracker (.xlsx) for Google Sheets and Excel
- Printable A4 meter-reading log to stick on the fridge (electricity, gas and water)
- Quick Start guide (PDF)
HOW IT WORKS
- Your download page opens straight after paying: download the files from there
- Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
- Excel: just open it (Excel 2010 or later, Windows or Mac, or Excel for the web)
- Type your tariff once, then add readings weekly or monthly in the cream cells. Everything else updates on its own
- Example data is included so you can see how it works: just replace it with yours
GOOD TO KNOW
- Plain formulas only: no macros, no add-ins, no subscriptions
- Formula cells are locked so you can't break them by accident (no password, so you can unlock and customise)
- Apple Numbers and LibreOffice aren't officially supported
- Your supplier's bill is the official figure. This tracker is for budgeting and spotting problems early.
PLEASE NOTE
- This is a DIGITAL download. Nothing physical will be shipped.
- Personal use only. Please don't share or resell the files.
Designed by Thexton Labs. Artwork and layouts were created with our own code, with the help of AI tools.