Back to UtilityTrac Main Menu

Audit Descriptions

Audits in UtilityTrac Plus 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 UtilityTrac Plus. 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).

 

AUDIT LIST

CODE DESCRIPTION LABEL DEFAULT
BILL AUDITS
BILL 1 Possible duplicate bill indicated by Pay Amount and start or end or due or statement date equal to an existing bill. N/A None
BILL 2 Invoice number is a duplicate of an existing bill. N/A None
BILL 3 Pay amount does not equal sum of cost line items N/A None
BILL 4 Control code is a duplicate of an existing bill. N/A None
BILL 5 Select up to 5 line items by observation type code. Observation Type Selected Observation Type Code(s) joined by "OR" logic.
BILL 6 Select observation type code with a greater than or equal to value. Observation Type Selected Observation Type Code.
BILL 7 Select observation type code with a less than or equal to value. Observation Type Selected Observation Type Code.
BILL 8 Select up to 5 line items by caption. Caption Selected Caption(s) -"Like", not "Equals"- joined by "OR" logic
BILL 9 Select line items by caption with a greater than or equal to value. Caption None
BILL 10 Select line items by caption with a less than or equal to value. Caption None
BILL 11 Execute a custom stored procedure. N/A None [stored procedure name]
USAGE AUDITS
USE 1 Use per Day is greater than the average of the prior 2 calendar months. Percent above Average Use Per Day. 20%
USE 2 Use per Day is less than the average of the prior 2 calendar months. Percent below Average Use Per Day 50%
USE 3 Use per Day is greater than the same month last year. Percent above last year's Use Per Day. 20%
USE 4 Use per Day is less than the same month last year. Percent below last year's Use Per Day. 50%
USE 5 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%
USE 6 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%
USE 7 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%
USE 8 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.)
USE 9 Use exceeds high limit in common rollup units of measure. Use above Common Rollup value. 100,000
USE 10 Use below low limit in common rollup units of measure. Use below Common Rollup value. 0
COST AUDITS

COST 1

Cost per Day is greater than the same month last year. Percent above last year's Cost Per Day. 20%
COST 2 Cost per Day is less than the same month last year. Percent below last year's Cost Per Day. 50%
COST 3 Unit Cost is greater than the same month last year. Percent above last year's Unit Cost. 10%
COST 4 Unit Cost is less than the same month last year. Percent below last year's Unit Cost. 50%
COST 5 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%
COST 6 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%
COST 7 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%
COST 8 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%
COST 9 Meter Cost exceeds high limit. Cost above 50,000
COST 10 Meter Cost below low limit. Cost below 5
COST 11 Unit Cost exceeds high limit. Cost above 0.25
COST 12 Unit Cost below low limit. Cost below 0.04
COST 15 Cost per Day is greater than the average of the prior two calendar months. Percent above Average Cost Per Day 20%
COST 16 Cost per Day is less than the average of the prior two calendar months. Percent below Average Cost Per Day 50%
COST 17 Cost per Unit is greater than the average of the prior two calendar months Percent above Average Unit Cost 20%
COST 18 Cost per Unit is less than the average of the prior two calendar months. Percent below Average Unit Cost. 50%
DATE AUDITS
DAY 1 Abnormally short billing period. Days Less Than Average Billing Period Length. >5 days below average of prior 12 months
DAY 2 Abnormally long billing period. Days Longer Than Average Billing Period Length. >10 days above average of prior 12 months.
DAY 3 Assigned Billing Period month falls outside of start/end dates. N/A None
DAY 4 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
DAY 5 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
DAY 6 Due date is too long after bill End Date. Number of Days After End Date. 30 days
DAY 7 Statement Date is too long after bill End Date. Number of Days After End Date 10 days
DAY 8 Bill end date is later than today. N/A None
DAY 9 Multiple bills for this account in one billing period [account and vendor]. N/A >1 bill [looks at accountID]
DAY 10 Due date or Statement Date is before End Date [only applies when non-null]. N/A None
DEMAND AUDITS
DEM 1 Abnormal load factor (over 100%). Use too high, demand too low, or days too low. Maximum Realistic Load Factor Percentage >100%
DEM 2 Abnormal load factor (.1% to 15%). Use too low, demand too high, or days too high. Minimum Realistic Load Factor Percentage <15% AND >0%
DEM 3 Billed demand greater than the same month last year. Skip test if either month = null or zero. Percent above previous year. 20%
DEM 4 Billed demand less than the same month last year. Skip test if either month = null or zero. Percent below previous year. 50%
DEM 5 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%
DEM 6 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%
DEM 7 Billed demand exceeds high limit. Billed demand above: 5000
DEM 8 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

 

Did you find this helpful? 

 

Back to Top