Bill audits overview

Bill audits are powerful tools for data validation and examine utility bill data for accuracy and unusual patterns of use or cost.

Bill audits

Flagged bills overview

Bill flags mark a bill for manual review and indicate there may be a problem. When no further action is needed for the bill, a user updates the flag status to resolved. Bill Flags were introduced with release 7.5.

Flagged bills

How do bills get flagged?

Bill audits 

Most impactful bill audits

Report-13 Bill Analysis

Report-13 helps you to spot and analyze abnormal bills. As each bill is created, separate quadratic regressions of use, cost, and demand vs. average mean daily temperature in the billing period are run for the bill and 24 months of history.

Chargeback bills and audits

For bill splits and summary bills, problems with the source bills lead to problems with generated bills.

Bill Audits are performed on source bills to help you determine if they are correct. If the source bills are correct it would follow that the generated bills are correct.

The chargeback workflow screen is designed to help you easily identify issues before and after creating chargeback bills.


For most types of chargebacks there can be legitimate reasons for multiple bills in a billing period, and this would cause a large number of bills to be flagged in error.

Chargeback bills analysis

Review generated bills on the the workflow screen.

Flag and audit examplesflagged bill and message

Any bills entered or imported before release 7.5 are not flagged unless you edit and save the bill or reimport the bills.

For any bills entered or imported before release 7.5, EnergyCAP performs a preliminary audit when you edit the bill to warn you about potential issues. The bill is NOT flagged until you save the bill. See the example below.

Viewing the bill. viewing a bill

Edit the bill and receive audit message.audit message

Flags assigned after the bill is saved.flagged bill

Flag type for bill audits

Only EnergyCAP can assign the flag type Audit Exception.

Where to view flagged bills

Flagged bills can be viewed in different locations:

Bills Module

bill list

Flag details

View a bill to review bill flags or take actions on the flag.

flagged bill actions

Bill flag during manual bill entry

If your user role has permission you see additional options when entering and saving a flagged bill.

saving a flagged bill

Save bill and resolve flag

Resolve the flag while saving the bill. This action, as all actions, are recorded in flag details.

save and resolve a flagged bill

Save and flag bill

Save the bill and flag it for future review.

Resolve a bill flag

If your edit of a flagged bill resolves the flag, the flag status is automatically resolved and recorded in the flag details tab.

When no edit or further action is needed you need to manually change the flag status to resolved.

If no edit is required you may need to update the flag status to resolved manually because no further action is needed. Update the comments section as needed. As a reminder, the flag details tab stores the history of all flag status updates and comments.

If you resolve a flag but the data issue is not resolved, the audit message is not displayed when viewing a bill. If you edit the bill, the audit message is displayed and the bill is (re)flagged when the bill is saved.

bill list

Assign and update a bill flag

If your user role has permission, you can flag any bill that requires additional attention and update any flag settings.

flag a bill

Resolve flags in bulk

You can resolve, assign, or update multiple flagged bills at once on the Flags tab.

  1. On the Flags tab use the filters to find the specific bills.
  2. Select one or more bills.
  3. Use the drop menu Flag Actions and select Resolve, Assign, or Update.

Bill flag permissions

bill flag permissions permissions

Bill audit comparison across versions

Installed Client Version 3 Version 7 Default Setting
3 BILL01 Likely duplicate bill  
4 BILL02 Invoice number is repeated on account  
5 DAY05 Gap of one or more days between this bill and the preceding bill on the same account  
32 DAY04

Bill overlaps with another bill on the same account

33 DAY09 Multiple bills for the same account in the same billing period  
1,2,34 DAY01/DAY02 Bill is significantly shorter or longer than previous bills for the same account 50%
  N/A Too many consecutive estimated bills on account 3 bills
6 DAY08 Bill unexpectedly ends in the future  
17 DAY03 Billing period is outside the bill's start and end dates  
DAY10 Due date is before the end date of the bill  
7 DAY06 Due date is too many days after the end date of the bill 60 days
DAY10 Statement date is before the end date of the bill  
DAY07 Statement date is too many days after the end date of the bill 30 days
28 USE06 Use per day is higher than expected based on prior bills on the same meter  
14 COST05 Cost per day is higher than expected based on prior bills on the same meter  
49 BILL05 Bill contains one of the following line item types  
BILL08 Bill contains one of the following line item descriptions (captions)  
BILL11 Calculated total bill cost does not match provided total bill cost from the following line item types  
  N/A Imported Bills: Account alert is active on account (non-fail type)  
  N/A Imported Bills: Rate schedule in import file does not match rate schedule assigned to meter  
  N/A Imported Bills: Serial number in import file does not match serial number assigned to meter