Knowledgebase:
EC Express: Audit Descriptions
Posted by Matthew Heinz on 06 June 2012 03:06 PM

Audit Descriptions

Audits in EnergyCAP Online/Express are grouped into four categories that suggest their function and application.

  • Bill Audits examine primary elements of the bill itself, including statement dates, billed amount, control codes, observation types, etc. For organizations with in-house coding expertise, the BILL11 Audit even provides a method for executing a stored procedure against a selected group of bills.
  • Usage Audits examine usage values on the bill for accuracy/reasonableness, based on previous billing data.
  • Cost Audits examine cost values on the bill for accuracy/reasonableness, based on previous billing data. billing data.
  • Demand Audits examine values for electrical demand, based on previous billing data.

Below is a tabular list of Audits in EnergyCAP. Information items included are:

  • CODE: The code ID for the audit
  • DESCRIPTION: The Audit description/purpose.
  • LABEL: Name of measured parameter category (if applicable)
  • DEFAULT: The default value for the audit (if applicable).
CODEDESCRIPTION LABELDEFAULT
AUDIT LIST
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. cost-only 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 non-null]. 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

 


(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: