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