Accruals based on linked meter
Summary
For an Account with a linked interval meter, Envizi offers the option to use meter data to derive accruals for the gap in Account. This option provides a more accurate estimation for Accruals since it is based on the actual consumption recorded in the linked meter.
How does it work?
Historical gaps will be filled in with Accruals generated from meter recordings of each corresponding month. The accruals generated will be taken from the linked meter from the same month.
Note:
This is a system wide feature and applicable to all meter linked Accounts in Envizi (cannot be limited to specific Locations or Groups)
Only available for Electricity / Natural Gas / Water Accounts with a linked interval Meter; default accrual methodology using historical data will apply for other types of Accounts
Scenarios
Things may become a little bit complicated when Account has partial missing data, or the corresponding Meter has partial actual data. The following scenarios are covered:
Account is missing data for the whole month AND linked meter has data for the full month : actual consumption from the meter is used to fill in the Account accruals
Account is missing data partially for a month AND linked meter has data for the full month : actual consumption from the meter is used to calculate a pro-rata meter data consumption for the missing days and fill in Account accruals
Account is missing data for the whole month or partially for a month AND linked meter has partial data for the month : calculate a pro-rata meter data consumption in the month for the missing days and fill in Account accruals
Account is missing data for the whole month or partially for a month AND linked meter does NOT have any data for the month : no Account accruals will be generated for the month in this case.
Account is NOT linked to any meter : the conventional Account accruals methodology which uses historical consumption data will apply. This will be applied to any account that does not have linked meter.
Example
Month | Start Period | End Period | Days | Account Consumption (actual) | Linked Meter Consumption (actual) | Linked Meter # of days of data | Account Consumption (accrued) | Notes |
|---|---|---|---|---|---|---|---|---|
Jan-2014 | 01-Jan-14 | 31-Jan-14 | 31 | 1230 | 1350 | 31 | n/a | |
Feb-2014 | 01-Feb-14 | 28-Feb-14 | 28 | 1150 | 1300 | 28 | n/a | |
Mar-2014 | 01-Mar-14 | 31-Mar-14 | 31 | 1240 | 1250 | 31 | n/a | |
Apr-2014 | 01-Apr-14 | 30-Apr-14 | 30 | 1500 | 1200 | 30 | n/a | |
May-2014 | 01-May-14 | 31-May-14 | 31 | 1234 | 1150 | 31 | n/a | |
June-2014 | 01-Jun-14 | 30-Jun-14 | 30 | 999 | 1100 | 30 | n/a | |
July-2014 | 01-Jul-14 | 31-Jul-14 | 31 | 1601 | 1050 | 31 | n/a | |
Aug-2014 | 01-Aug-14 | 19-Aug-14 | 19 | 895 | 950 | 31 | = (950/31 days) * (12 days missing) = 367.74 | missing partial month Account, with full month Meter |
20-Aug-14 | 31-Aug-14 | 12 | 0 | |||||
Sep-2014 | 01-Sep-14 | 19-Sep-14 | 19 | 895 | 895 | 19 | = 895 / 19 days * (11 days missing in Account) = 518.16 | missing partial month Account, with partial month Meter |
20-Sep-14 | 30-Sep-14 | 11 | 0 | 0 | 0 | |||
Oct-2014 | 01-Oct-14 | 31-Oct-14 | 31 | 0 | 850 | 31 | = 850 / 31 * 31 = 850 | missing whole month Account, with full month Meter |
Nov-2014 | 01-Nov-14 | 30-Nov-14 | 30 | 0 | 800 | 30 | = 800 / 30 * 30 = 800 | |
Dec-2014 | 01-Dec-14 | 31-Dec-14 | 31 | 0 | 750 | 25 | = 750 / 25 days * (31 days missing) = 930 | missing whole month Account, with partial month Meter |
Jan-2015 | 01-Jan-15 | 31-Jan-15 | 31 | 0 | 0 | 0 | 0 | missing whole month Account, missing whole month meter (no accruals will be generated) |