Excel

Spot errors in your energy bills before they cost you

A structured template for auditing gas and electricity bills. Check rates, reads, VAT and charges against what you should actually be paying.

Utility bill audit spreadsheet

Billing errors are far more common than most organisations realise. Incorrect unit rates, wrongly applied VAT, estimated reads that go unchallenged, and duplicate charges can all result in significant overpayment. This template gives energy consultants and energy managers a structured, repeatable process for auditing gas and electricity bills across any site, making it easy to spot discrepancies and build a case for recovery.

What's inside

  • Unit rate and standing charge validation against contract terms
  • Meter read accuracy checks with estimated read flags
  • VAT rate verification: 5% vs 20% eligibility by usage type
  • Climate Change Levy application and exemption check
  • Duplicate charge and retroactive adjustment detection
  • Pre-built Excel formulas with no setup required

No spam. Unsubscribe anytime.