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. Do you want to include only Active accounts? If this filter is not included your report includes both active and inactive.
  2. Include or not include void bills?
  3. View a subset of your data using the filter Topmost place or Meter group.

Example