Andy forensic utility bill audit

Seven files per job.

Six narrative documents in .docx and the register workbook in .xlsx. All editable — they arrive as drafts on your letterhead practice, not as locked output.

  1. Bill Register

    One row per statement per meter: service period, days, determinants, each charge component as billed and as recomputed, and the variance. Every figure in the other six documents resolves to a row here.

    register.xlsx
  2. Forensic Audit Report

    The narrative: scope, accounts and periods examined, method, each finding in sequence with its tariff basis and arithmetic, and the aggregate exposure.

    .docx
  3. Findings Reference

    Each finding on its own, indexed by reference number — the tariff provision tested, the statements affected, the rebuild, and what the utility would have to show to rebut it.

    .docx
  4. Refund Demand Letter

    Addressed to the utility, stating the findings raised, the amount claimed, and the period. Drafted for your signature — review it against the tariff in force before it leaves your office.

    .docx
  5. Client Strategy Letter

    For the client rather than the utility: what was found, what is worth pursuing, the trade-off between informal dispute and a formal Commission complaint, and what to expect on timing.

    .docx
  6. Engagement Agreement

    Scope, fee basis, and term, drafted to the engagement the audit was run under.

    .docx
  7. Letter of Authorization

    The client's authorization for you to obtain account records and correspond with the utility on their behalf.

    .docx

The register, in practice

Four consecutive statements from an account carrying the demand ratchet error, as the register records them. The variance column is the same on each because the error is the same on each.

Bill Register — extract, account 2 of 4 Constructed example. Not a client record.
Statement Service period Days kWh Billed kW Amount Recomputed Variance
2025-0201 Feb – 28 Feb 2025 28214,8001,207 41,882.1931,861.7110,020.48
2025-0101 Jan – 31 Jan 2025 31238,6401,207 44,905.6034,885.1210,020.48
2024-1201 Dec – 31 Dec 2024 31251,1201,207 46,338.7736,318.2910,020.48
2024-1101 Nov – 30 Nov 2024 30229,4001,207 43,110.0533,089.5710,020.48
Four of eleven affected statements 120933,960 176,236.61136,154.6940,081.92