Home Energy & Utility Bill Tracker UK – Gas & Electricity Meter Readings Spreadsheet (Excel + Google Sheets)
See how much energy you use and check your bills.
What it does:
Settings for your tariff: unit rates (p/kWh) and standing charges (p/day) for electricity and gas, and your gas calorific value
Readings: date, electricity reading and gas reading; days between readings, units used and an estimated cost are worked out
Gas readings in cubic metres (or hundreds of cubic feet) are turned into kWh with the standard UK formula
Bills: what you actually paid for electricity, gas, water and more
Dashboard for any year: electricity and gas kWh, estimated cost and bills paid for each month, and the difference
What you get:
Home-Energy-and-Utility-Bill-Tracker-UK.xlsx – the blank tracker
Home-Energy-and-Utility-Bill-Tracker-UK-EXAMPLE.xlsx – filled with example data
Instructions are on the Start Here tab.
Works in Microsoft Excel 2016 or newer (Windows and Mac), Excel for the web, and Google Sheets (upload the .xlsx to Google Drive and open it with Google Sheets). No macros.
Costs are estimates from the rates you enter; your supplier's bill may differ.
This is a digital download. No physical item will be shipped. For personal use only.