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?

Bills can be flagged 

Bill Audits 

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

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

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 a variety of locations:

Bills Module

Any Flags Tab

Flag Details

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

Bill Flag during Manual Bill Entry

If your user role and permissions allow you may see additional options when entering and saving a flagged bill.

Save Bill and Resolve Flag

Allows you to resolve the flag while saving the bill. This action is recorded in flag details.

Save and Flag Bill

Save the bill and flag it for future review.

Resolve a Bill Flag

Update flag status to resolved when 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.

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.

Assign and Update a Bill Flag

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

Bill Flag Permissions

Bill Audit Comparison - Version 3 to Version 7

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

Bill overlaps with another bill on the same account

 
DAY09 Multiple bills for the same account in the same billing period  
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
DAY08 Bill unexpectedly ends in the future  
DAY03 Billing period is outside the bill's start and end dates  
DAY10 Due date is before the end date of the bill  
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
USE06 Use per day is higher than expected based on prior bills on the same meter  
COST05 Cost per day is higher than expected based on prior bills on the same meter  
BILL05 Bill contains one of the following line item types  
BILL08 Bill contains one fo 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