Report-17 and 17a

Last updated April 30, 2026

Missing and Overlapping Bills by Meter

This report makes it easy to spot billing issues quickly and take action to correct missing or duplicate data. Report-17 identifies gaps and overlaps in utility bills for each meter.

What the report shows

  • Meter code and meter name
  • Number of bills in the selected date range
  • Average cost per bill
  • Average cost per day
  • Total estimated value of problem days
  • Billing periods in the date range
  • Billing periods without bills
  • Billing periods with multiple bills
  • Total days without bills
  • Total overlapping days

Why it’s useful

This report helps you:

  • Quickly identify missing or duplicate billing periods
  • Spot issues using color-coded highlights
  • Use hyperlinks to jump directly to the data in EnergyCAP for review

Report-17 is available as: Excel, Excel data only

Gap only report

If you want to report on gaps only, use Report-17-GAP and Report-17a-GAP.

Report-17 - Missing and Overlapping Bills by Meter thumbnail with a table of meters and a grid of monthly columns, with some cells color-coded; text is too small to read.

Report-17 helps you identify three types of billing issues

  • Months with no bills
  • Gaps in billing periods
  • Overlapping bills

Months with no bills

This check answers: Does each month have a bill?

  • 0 - no bills in the month
  • 1 - one bill in the month
  • 2 - two bills in the month

If every month has one bill, you'll see no colored squares, indicating no issues.

Report-17 - Overlapping and Days Without Bills by Meter by Billing Period table with cost columns and monthly cells 202101 to 202107 color-coded pink, yellow and blue; a callout says every month has a bill, no colored squares means no problems.
Report-17 filters with Billing Period between January 2021 and July 2021, Color Code if Days without Bills, and Show Only Color-Coded Meters set to Yes; a callout says it will only have problem meters in report.

Gaps

Months highlighted in pink or blue indicate a gap in billing.

  • You define the acceptable gap when running the report.
  • For example, if you allow a 1-day gap, only gaps of 2 or more days are highlighted.
  • This means small gaps may not appear, but could still add up over time.

If you enter 1 as an acceptable gap, this means a one-day gap is not colored, and over the course of a year you could be missing up to 12 days of billing data.

Report-17 Overlapping and Days Without Bills by Meter by Billing Period with an outlined row showing 11 days with no bill and a callout explaining that pink/blue GAPS are months with days not covered by a bill.
Report filters with Billing Period between January 2021 and July 2021, and the Color Code if Days without Bills greater than 0 filter outlined, followed by Show Only Color-Coded Meters Yes, Sort Report By Total days w/o bills, Account is Active, and Inc Active Meters with No Bills No.

Overlaps

Months highlighted in yellow or blue indicate overlapping bills (multiple bills covering the same days).

Report-17 table with callouts pointing to 29 total overlapping days and explaining that OVERLAPS in yellow/blue are months that have days with overlapping bills.

Gaps and Overlaps

Months highlighted in blue indicate both a gap and overlapping bills within the same month.

Report-17 table with a callout on one billing-period cell labeled OVERLAPS AND GAPS in the same month.

Set your filters for Report-17

  1. Time period
    Set your Billing period or Accounting period
  2. Color code billing period if allowable gap days is - enter the number of days that is acceptable for your organization to have gaps between bills.
  3. Report on a subset of data
    Set a filter such as Topmost place, Site group, or Commodity.
  4. Only include meters with color coded billing periods
    Set to Yes to exclude meters with all bills, no gaps, and no overlaps.

Example filter for Report-17

Report-17 filters: Color Code if Days without Bills greater than 1, Date Range January 2020 to June 2020, Show Only Color-Coded Meters Yes, Sort Report By Estimated Problem Value, Account is Active, Inc Active Meters with No Bills No, and Show Bills w/ Missing Days Only Yes.

Sample Report-17 - Overlapping and Days Without Bills by Meter by Billing Period for Happy Valley, listing vendor, account, meter, bill counts, costs, total days without bills, overlapping days, and color-coded monthly columns 202001 to 202006.

Available filters for Report-17

Required filters

  • Billing period - Select the periods you want to review for missing or overlapping bills.
  • Color code period if allowable gap day is - Color code months that exceed your organization's allowable gap days. If you enter 1 you could be missing up to 12 days of billing data over the course of a year. Typically the meter read date is both the start and end date. To avoid double counting, the start date is counted and the end date is not.
  • Only include meters with color coded periods - Select yes or no.
  • Sort by - Select how you want the report sorted.

Recommended filters

  • Account is active - If this filter is not included, both active and inactive accounts are included in the report.
  • Account name  - Filter to one or more accounts. This filter is not compatible with topmost or group filters.
  • Account number - Filter for one or more accounts. This filter is not compatible with topmost or group filters.
  • Commodity - Select one or more commodities to include in the report. Not compatible with the commodity category filter.
  • Commodity category - Select one or more commodity categories to include in the report. Not compatible with the commodity filter.
  • Group by - Consolidates the report and view results by one account, if multiple accounts.
  • Include active meters with no bills - Select yes or no.
  • Topmost cost center code - When you use this filter you are selecting the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
  • Topmost cost center name - When you use this filter you are selecting the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
  • Topmost place code - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
  • Topmost place name - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
  • Vendor code - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. You can combine with other filters if you want to refine your results.
  • Vendor name - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. You can combine with other filters if you want to refine your results.

Optional Filters

  • Accounts in cost center code - Filter to include accounts directly under one or more cost centers. To see all the accounts at a certain level in your hierarchy use the Topmost cost center filter. This filter is not compatible with other topmost or group filters.
  • Accounts in cost center name - Filter to include accounts directly under one or more cost centers. To see all the accounts at a certain level in your hierarchy use the Topmost cost center filter. This filter is not compatible with other topmost or group filters.
  • Display group name in category - Adds a column to the report to include the meter group name for the selected category.
  • Meter group - Filter for specific groups. To include all group members, do not set a topmost filter. TIP: You can combine with other filters if you want to refine your results.
  • Meter serial number - Filter by one or more meters. To include all results do not set a topmost, group, or other filters.
  • Meters in site code - Filter by one or more meters. To include all results do not set a topmost, group, or other filters.
  • Meters in site name - Filter to include meters directly under one or more sites.
    TIP: To see all the meters at a certain level in your hierarchy use the Topmost place filter. This filter is not compatible with other topmost or group filters.
  • Only include billing periods with missing days - Select yes or no.
  • Site group - Filter for specific groups. To include all group members, do not set a topmost filter. TIP: You can combine with other filters if you want to refine your results.
  • Vendor role - Select the vendor role you want to include in the report.