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
- Select the Date range or Account period to analyze.
- Set the Highlight variance %. Variations up to 3% are normal.
- Adjust the filter Bill is from external vendor.
Other filters to consider for Report-35
- Do you want to include only Active accounts? If this filter is not included your report includes both active and inactive.
- Include or not include void bills?
- View a subset of your data using the filter Topmost place or Meter group.