Report this item to Etsy

UK Energy Bill Tracker Spreadsheet, Gas & Electric Meter Reading Log

Price:$6.97

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 3 PDF, 1 other file

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
- Download the files from your Etsy Purchases page
- 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.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

Be the first to review this item

No reviews yet. See what customers say about other items from this shop.

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Buy to Let Spreadsheet

Work Hours Log

Accounts Tracker

Server Tip Tracker

Hourly Wage Tracker

Work Time Log

Listed on Oct 5, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates