UK Energy Bill Tracker

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.