Your Cart
Loading

Home Energy & Utility Bill Tracker UK – Gas & Electricity Meter Readings Spreadsheet (Excel + Google Sheets)

On Sale
£2.99
£2.99
Added to cart

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.

You will get a ZIP (64KB) file