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 

flagged bill and message

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 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 a variety of 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 and permissions allow you see additional options when entering and saving a flagged bill.

saving a flagged bill

Save Bill and Resolve Flag

Allows you to 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

Update the 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 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 and permissions allow, you can flag any bill that requires additional attention and update any flag settings.

flag a bill

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 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