Utility Billing Audit Workbook

A rising bill is easy to notice. What's driving it is not

An estimated reading, a tariff that quietly reverted to a higher default rate, or a standing charge that doesn't match what you agreed can all inflate a bill without anything looking obviously wrong at a glance. Catching it takes actually comparing what's billed against what your meter and your contract say — bill by bill, not just once.

This workbook lines up your bills against your actual readings and agreed tariff, with an auto-calculated discrepancy column that flags exactly where the numbers stop matching.

• Bill-by-Bill Log — period, reading type (actual or estimated), and amount charged
• Auto-Calculated Discrepancy Column — the gap between billed and expected, flagged automatically
• Tariff Reference — your agreed unit rate and standing charge, checked against what's actually billed
• Year-on-Year Comparison — this period against the same period last year, to separate a real increase from an error

Step by step

1. Download the workbook and enter your tariff details — unit rate and standing charge.
2. Log each bill as it arrives, noting whether it's based on an actual or estimated reading.
3. The discrepancy column flags automatically where a bill doesn't match your tariff or usage.
4. Use the year-on-year view to check whether a spike is a real change or a billing error.

• Editable Excel workbook
• Bill log with auto-calculated discrepancy column
• Tariff reference and year-on-year comparison
• Works on any device