Database Statistics (Excel only)

An Excel summary of database activity. Includes total database counts for accounts, meters, buildings, and bills. Includes detailed information regarding bills created within the latest 12-month period. Includes detailed charts for types of bills created and age of bills when entered. Also includes historic trends for main object types created over time.

Summary Tab

  • Only lists buildings.
  • BAM is short for bill/account/meter. This represents the unique Bill ID, account, and meter combinations.

Age of Bills Tab

This tab gives you an idea how soon a bill is entered into UtilityManagement after being received. This can help identify an inefficient bill entry process or simply help identify when historical bills were added.

The bill counts are cumulative. The last two columns (Created 91-120 days after bill and Created over 120 days after bill) should total together to match the count of bills created in that month, including void bills, chargeback bills, and inactive accounts. All bills regardless of their creation method are included in the count.

Created X days after a bill

The count of days is determined by the difference between the bill's end date and creation date.