BILL AUDITS 
BILL1 
Possible duplicate bill indicated by Pay Amount and start or end or due or statement date equal to an existing bill. 
N/A 
None 
BILL2 
Invoice number is a duplicate of an existing bill. 
N/A 
None 
BILL3

Pay amount does not equal sum of cost line items 
N/A 
None 
BILL4 
Control code is a duplicate of an existing bill. 
N/A 
None 
BILL5 
Select up to 5 line items by observation type code. 
Observation Type

Selected Observation Type Code(s) joined by "OR" logic. 
BILL6 
Select observation type code with a greater than or equal to value. 
Observation Type 
Selected Observation Type Code. 
BILL7 
Select observation type code with a less than or equal to value. 
Observation Type 
Selected Observation Type Code. 
BILL8 
Select up to 5 line items by caption. 
Caption 
Selected Caption(s) "Like", not "Equals" joined by "OR" logic. 
BILL9 
Select line items by caption with a greater than or equal to value. 
Caption 
None 
BILL10 
Select line items by caption with a less than or equal to value. 
Caption 
None 
USAGE AUDITS 
USE1 
Use per Day is greater than the average of the prior 2 calendar months. 
Percent above Average Use Per Day. 
20% 
USE2 
Use per Day is less than the average of the prior 2 calendar months. 
Percent below Average Use Per Day. 
50% 
USE3 
Use per Day is greater than the same month last year. 
Percent above last year's Use Per Day. 
20% 
USE4 
Use per Day is less than the same month last year. 
Percent below last year's Use Per Day. 
50% 
USE5 
Use per Day is the same as the prior two months. Possible estimated bill, but estimated flag not checked. [this audit only applies when use/day >0]. 
Percent difference to allow for rounding. 
0.10% 
USE6 
Use per Day is greater than the highest use/day of any bill for this meter in the last 12 months. 
Percent above highest Use Per Day. 
20% 
USE7 
Use per Day is less than the lowest use/day of any bill for this meter in the last 12 months. 
Percent below highest Use Per Day. 
50% 
USE8 
Cost but no usage for 2 months in a row. Is this meter now inactive? 
N/A 
None (NOTE: Do not flag meters that have NEVER had any usage, i.e. costonly accounts. Only meters for which there is usage at some point in history.) 
USE9 
Use exceeds high limit in common rollup units of measure. 
Use above Common Rollup value. 
100,000 
USE10 
Use below low limit in common rollup units of measure. 
Use below Common Rollup value. 
0 
COST AUDITS 
COST1 
Cost per Day is greater than the same month last year. 
Percent above last year's Cost Per Day. 
20% 
COST2 
Cost per Day is less than the same month last year. 
Percent below last year's Cost Per Day. 
50% 
COST3 
Unit Cost is greater than the same month last year. 
Percent above last year's Unit Cost. 
10% 
COST4 
Unit Cost is less than the same month last year. 
Percent below last year's Unit Cost. 
50% 
COST5 
Cost per Day is greater than the highest cost/day of any bill for this meter in the last 12 months. 
Percent above highest Cost Per Day. 
20% 
COST6 
Cost per day is less than the lowest cost/day of any bill for this meter in the last 12 months. 
Percent below highest Cost Per Day. 
50% 
COST7 
Cost Per Unit is greater than the highest cost/unit of any bill for this meter in the last 12 months. 
Percent above highest Cost Per Unit. 
10% 
COST8 
Cost Per Unit is less than the lowest cost/unit of any bill for this meter in the last 12 months. 
Percent below lowest Cost Per Unit. 
50% 
COST9 
Meter Cost exceeds high limit. 
Cost above: 
50,000 
COST10 
Meter Cost below low limit. 
Cost below: 
5 
COST11 
Unit Cost exceeds high limit. 
Cost above: 
0.25 
COST12 
Unit Cost below low limit. 
Cost below: 
0.04 
COST15 
Cost per Day is greater than the average of the prior two calendar months. 
Percent above Average Cost Per Day 
20% 
COST16 
Cost per Day is less than the average of the prior two calendar months. 
Percent below Average Cost Per Day 
50% 
COST17 
Cost per Unit is greater than the average of the prior two calendar months 
Percent above Average Unit Cost 
20% 
COST18 
Cost per Unit is less than the average of the prior two calendar months. 
Percent below Average Unit Cost. 
50% 
DATE AUDITS 
DAY1 
Abnormally short billing period. 
Days Less Than Average Billing Period Length. 
>5 days below average of prior 12 months 
DAY2 
Abnormally long billing period. 
Days Longer Than Average Billing Period Length. 
>10 days above average of prior 12 months. 
DAY3 
Assigned Billing Period month falls outside of start/end dates. 
N/A 
None 
DAY4 
Start/end dates overlap with another bill for this account and vendor. Deregulated accounts will have overlapping on a meter basis, but not on an account/vendor basis. 
N/A 
None 
DAY5 
Gap between this bill’s start date and prior bill’s end date indicates possible missing bills or incorrect dates. 
Number of Days Between Bills to Indicate gap. 
>1 day in gap 
DAY6 
Due date is too long after bill End Date. 
Number of Days After End Date. 
30 days 
DAY7 
Statement Date is too long after bill End Date.. 
Number of Days After End Date 
10 days 
DAY8 
Bill end date is later than today. 
N/A 
None 
DAY9 
Multiple bills for this account in one billing period [account and vendor]. 
N/A 
>1 bill [looks at accountID] 
DAY10 
Due date or Statement Date is before End Date [only applies when nonnull]. 
N/A 
None 
DEMAND AUDITS 
DEM1 
Abnormal load factor (over 100%). Use too high, demand too low, or days too low. 
Maximum Realistic Load Factor Percentage 
>100% 
DEM2 
Abnormal load factor (.1% to 15%). Use too low, demand too high, or days too high. 
Minimum Realistic Load Factor Percentage 
<15% AND >0% 
DEM3 
Billed demand greater than the same month last year. Skip test if either month = null or zero. 
Percent above previous year. 
20% 
DEM4 
Billed demand less than the same month last year. Skip test if either month = null or zero. 
Percent below previous year. 
50% 
DEM5 
Billed demand greater than the highest billed demand of any bill for this meter in the last 12 months. 
Percent above highest billed demand. 
20% 
DEM6 
Billed demand lower than the lowest billed demand of any bill for this meter in the last 12 months. Months with BD=0 or null are skipped. 
Percent below lowest billed demand. 
50% 
DEM7 
Billed demand exceeds high limit. 
Billed demand above: 
5000 
DEM8 
Billed demand lower than low limit. Include bills with BD=0 ONLY WHEN at least 1 other bill for the same acct/mtr has BD>0, i.e. don’t show every electric meter if they never have demand. 
Billed demand below: 
5 