Report-17 and 17a

Missing and Overlapping Bills by Meter

An Excel report that identifies gaps and overlaps in utility bills.

Gap only report

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

Report-17 can identify three different problems

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

No bills

Does each month have a bill?

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


Gaps

Months marked pink and blue have a gap (you indicated the acceptable gap when running the report).

If you enter 1 as an acceptable gap, months with a gap of 2 or more days are pink or blue. 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.

Overlaps

Months marked yellow and blue have one or more days with overlapping bills.

Gaps and Overlaps

Months marked blue have have a gap in billing and also overlaps.

Hyperlinks in reports

Quickly go to the meter, vendor, or account with hyperlinks.

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

Available filters for Report-17

Required filters

  • Billing period
  • Color code period if allowable gap day is
  • Only include meters with color coded periods
  • Sort by

Recommended filters

  • Account is active - If this filter is not included, includes both active and inactive accounts are including in the report.
  • Account name
  • Account number
  • Commodity
  • Commodity category
  • Include active meters with no bills
  • Topmost cost center code
  • Topmost cost center name
  • Topmost place code
  • Topmost place name
  • Vendor code
  • Vendor name

Optional Filters

  • Accounts in cost center code
  • Accounts in cost center name
  • Display group name in category
  • Meter group
  • Meter serial number
  • Meters in site code
  • Meters in site name
  • Only include billing periods with missing days
  • Site group
  • Vendor role