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

Available filters for Report-35

Recommended filters

  • Accounts in cost center code
  • Accounts inc cost center name
  • Bill is void - If this filter is not included both void and not void are included.
  • Commodity
  • Commodity category
  • Date range
  • Highlight variance %
  • Meter group
  • Topmost place code
  • Topmost place name

Optional Filters

  • Account is active - If this filter is not included, includes both active and inactive accounts are including in the report.
  • Accounting period
  • Bill has been split
  • Bill import verified
  • Bill is verified
  • Bill is approved
  • Bill is from external vendor - When this filter is not selected, the report includes data from both vendor (external) and chargeback (internal) bills.
  • Exported to AP
  • Exported to GL
  • Held from accounting export
  • Include accrual bills
  • Include reversed accrual bills
  • Meter code
  • Meter name
  • Meter serial number
  • Meters in site code
  • Meters in site name
  • Observation method
  • Vendor code
  • Vendor name