Energy Tariff Comparison Workbook
The headline price rarely tells the whole story. Compare tariffs on what you'll actually pay, using your own real usage.
The cheapest-looking tariff isn't always the cheapest one
A lower unit rate can be outweighed by a higher standing charge. A sign-up discount can vanish after a few months and leave you paying more than before. Comparing tariffs on the headline monthly estimate alone — instead of your own actual usage — is how switches end up costing more than staying put.
This workbook calculates the real annual cost of each tariff using your own usage figures, with the sign-up discount, exit fees, and standing charge all factored in separately from the unit price.
- Current Usage Record — your annual consumption, split by time of day if your tariff requires it
- Tariff Comparison Table — unit rate, standing charge, and contract length for each offer, side by side
- Auto-Calculated Real Cost — true annual cost using your own usage, not a generic average household
- Fine-Print Tracker — exit fees, sign-up discounts, and when each one actually expires
Step by step
- Download the workbook and enter your annual usage from a recent bill.
- Add each tariff you're comparing — unit rate, standing charge, and contract terms.
- The workbook calculates the real annual cost of each one using your own usage.
- Check the fine-print tracker for exit fees before you commit to switching.
Anyone comparing energy tariffs before switching supplier
Whether you're weighing two or several offers, this calculates what each one actually costs using your own usage, not the provider's generic estimate.
- Editable Excel workbook
- Tariff comparison table with auto-calculated real cost
- Fine-print and exit-fee tracker
- Works on any device
Compare what you'll actually pay, not the headline price.
Unit rate, standing charge, and your own usage — calculated automatically.
Get it — $5.90 →One-time $5.90 · Excel · Works on any device