Report-35

Bill Use Reconciliation Report

This Excel report helps you verify the accuracy of interval data by comparing it to your monthly utility bills.

Key Features

  • One tab per commodity (for example, electric, gas, water).
  • Variance filters highlight outliers for easy review.
  • Interval use is summed and converted to monthly totals for side-by-side comparison with the bill.
  • If demand data is available:
    • Compares interval-based peak demand to billed demand.

Use Case

Quickly confirm whether:

  • Interval data aligns with billed amounts.
  • Any major discrepancies need further investigation.

Report-30 checks new readings for reasonableness before creating a chargeback bill.

Report-35 Tip: Understanding Use vs. Demand Variance

  • If a bill shows low Use variance but high Demand variance, it may mean:

    • The Billed Demand was set based on a previous month’s peak.
    • This is common with tariffs that include a demand ratchet charge penalty.
    • ✅ Check your tariff and bill details to confirm if this applies.

Normal Variations

  • Up to 3% variance is typical due to timing differences.
    • EnergyCAP does not track the exact time utility readings are taken.
  • Over time, positive and negative variances should balance out.

Set your filters for Report-35

  1. Select the Date range or Account period to analyze.
  2. Set the Highlight variance %. Variations up to 3% are normal.
  3. Adjust the filter Bill is from external vendor.

Other filters to consider for Report-35

  1. Active accounts only
    Decide whether to include only active accounts.
    If this filter is not applied, your report includes both active and inactive accounts.
  2. Void bills
    Include if you want a full audit history.
    Exclude to focus only on valid financial activity.
  3. View a subset of your data
    Use the filter Topmost place or Meter group.

Example