Tracking your energy bills in Excel is one of the most useful things you can do if you want to understand your household or property costs over time. A well-structured spreadsheet lets you spot usage trends, compare costs between billing periods, and have all your figures in one place for tax or accounting purposes.
The problem is that getting the data from a PDF bill into Excel is tedious - and most people give up after a month or two of manual data entry. This guide shows you how to set up an energy bill tracker and, more importantly, how to populate it automatically without typing a single figure from your bills.
A useful energy bill tracker should capture these columns at minimum:
| Column | Why it's useful |
|---|---|
| Bill date | Lets you sort and filter by time period |
| Supplier | Useful if you switch supplier mid-year |
| Fuel type | Separate electricity and gas costs |
| Billing period (start/end) | Identifies exactly what period you're paying for |
| Usage (kWh) | Track consumption independently of price changes |
| Unit rate (p/kWh) | Spot when your rate changes and by how much |
| Standing charge (p/day) | Track the fixed daily cost separately |
| Total charge (£) | The bottom line cost per period |
| VAT (£) | Useful for business expense tracking |
If you're a landlord or property manager tracking costs across multiple properties, add a Property column at the start so you can filter and pivot by address.
The obvious approach is to open each monthly bill PDF and type the figures into your spreadsheet. For a simple single-fuel bill with one tariff period this takes 5-10 minutes. The problems start when:
Most people start with the best intentions and abandon the tracker within a few months because the data entry is just too time-consuming. The solution is to automate the data extraction step.
BillConverter converts your UK utility bill PDF into a structured Excel file automatically. Every field you'd want in your tracker is already extracted and organised - you just paste the rows into your master spreadsheet.
The workflow becomes:
The whole process takes under two minutes per bill. For a landlord with 5 properties on different suppliers, that's about 10 minutes a month to keep a complete, accurate energy cost record across the entire portfolio.
Try it now - convert your first bill and see the Excel output. Free, no account needed.
Convert my bill →Once you have the BillConverter output, here's how to build a master tracker that grows month by month:
Tip: Format the Bill Date and Period Start/End columns as dates in Excel (select the column → Format Cells → Date) so you can sort and filter by time period properly.
Once you have a few months of data in your tracker:
If you manage multiple properties, add a Property column to your master tracker. When you paste rows from BillConverter, fill in the property address manually - or use a short reference code (P1, P2 etc) if addresses are long. This lets you filter and analyse costs per property instantly.
For a portfolio of five properties on monthly bills, you'd add roughly 10-15 rows per month - about 120-150 rows per year. A pivot table on this data gives you an instant annual energy cost breakdown by property and fuel type, which is exactly what you'd need for a tax return or a portfolio review.
The first two conversions per month are free with no account needed. For regular use, a top-up of 20 conversions costs £1.99 (around 10p per bill), or you can subscribe for unlimited conversions at £4.99 per month - which works out at less than a single hour of manual data entry time.