Accruals per Account by Month is a complex report in Energy Intelligence. Please see below a detailed explanation.
This report will attempt to calculate an estimated bill cost for an Account for a year and month period. It will use recent, historic bill data or metered consumption, depending on the “quality” of metered consumption available. It will only accrue where it there is no actual billing data for the complete month. It will calculate the accrual based on the best data available. The Accrual Type column outlines the accrual methodology that has been used.
It will calculate the accrual based on an hierarchical order (see below).
Notes:
A virtual recording was made in August 2020 regarding Accrual Reporting and this report was covered. Click here to go to the Virtual Training Sessions page, or click here to go directly to the recording.
The report runs in the context of a Calendar year (i.e. the Accrual year selected), for each month within that year and for each account.
The report firstly determines the number of days that a bill is available for in the applicable month for the account. It then compares this to the number of days in the month and works out the difference (this difference effectively represents the number of days that needs to be accrued).
The report will output the calculation method it has used in the “Accrual Type” field on the report (See below for Accrual Types)
If there are one or more bills days missing, then the report calculates the accrual based on the Accrual Types as listed below.
See below for an explanation of each column in the Report. The examples are for the middle row of the above report.
Column | Explanation | Example |
---|---|---|
FILTERING | ||
Year | The year you are accruing | 2020 |
Month | The month (in the above year) that you want to accrue for | August |
Site Group Name | Site Group Name | Local Authority |
Site Name | Site Name | LA Dixon Control Centre |
Account Number | Account Number | 2874526S |
Account Commodity | The Commodity associated with the Account | Gas |
METERED CONSUMPTION IN ACCRUAL MONTH | ||
Days of Meter Cons | The number of days of Metered Consumption in the selected Month (August 2020) has been selected (between 1 and 31) | 5 |
Current Meter Cons | Metered Consumption for the month selected (ie August 2020) | 14,069.00 |
Note: Red indicates there is less that 7 days of data, Green indicates there is 7 or more days of data and will affect which Accrual Type is used (see below) | ||
SAME MONTH / PREVIOUS YEARS BILLED CONSUMPTION AND COST | ||
Previous Year Bill Consumption | Consumption in the Bill for the same month in the previous Year (August 2019) | 7,980 (kWh) |
Previous Year Bill Net (£) | Net cost for the Bill for the same month in the previous year (August 2019) | £449.50 |
Previous Year Daily Net (£) | Daily net amount for the Bill in the same month in the previous year (ie August 2019). The Bill amount (£449.50), divided by the amount of days in the Bill (31) | £14.50 |
Previous Year Net PPU (£) | The PPU on the Bill in the same month in the previous year (August 2019) | £0.0563 |
DAILY NET AMOUNT AND PPU BASED ON INFLATION | ||
Inflation Factor | This is determined by the figure in the Property Key added to the Organisation (see below for more detail) | £1.15 |
Previous Year Daily Net Inflated (£) | Daily net amount for the Bill in the same month in the previous year (August 2019 and £14.50 X the inflation figure (1.15) | £16.68 |
Previous Year PPU Net Inflated (£) | The PPU on the Bill in the same month in the previous year ( August 2019 and £0.0563) X the inflation figure (ie 1.15) | £0.0648 |
PREVIOUS MONTH (IN ACCRUAL YEAR) BILLED CONSUMPTION AND COST | ||
Previous Month Bill Cons | Consumption in the Bill for the previous month (July 2020) | 13,269.70 (kWh) |
Previous Month Bill Net (£) | Net cost for the Bill for the previous month (July 2020) | £708.18 |
Previous Month Daily Net (£) | Daily net amount for the Bill in previous month (July 2020). The Bill amount (£708.18), divided by the amount of days in the Bill (31) | £22.84 |
Previous Month Net PPU (£) | The PPU on the Bill for the previous month (July 2020) | £0.05 |
CURRENT BILLED CONSUMPTION AND COST | ||
Actual Bill Cons | Consumption in the Bill for the current month (August 2020) | 478.80 |
Actual Bill Net (£) | Cost for the Bill for the current month (August 2020) | £61.84 |
Actual Daily Net (£) | Daily net amount for the bill in the current month (August 2020). The Bill amount (£61.84), divided by the amount of days in the Bill (5 - see Actual Bill Days column in the next section) | £12.37 |
Actual PPU Net (£) | The PPU on the Bill for the current month (August 2020) | £0.1302 |
DAYS TO BE ACCRUED AND ACCRUAL AMOUNT | ||
Days in Month | The number of days in the Month you are accruing for (August 2020) | 31 |
Actual Bill Days | The number of days already billed in the period (August 2020 - see section above) | 5 |
Days to Accrue | The number of days to accrue within the period (August 2020) 31 days - 5 days already billed = 26 to bill | 26 |
Accrual (£) | The Accrual amount in £s to accrue to the end of the selected month (August 2020) | £321.57 |
ACCRUAL TYPE
| ||
Accrual Type | The method used to accrue (see below for examples) | Previous Month Bill Daily Average |
If there are no bill days missing, then the accrual is “0” , therefore “No Accrual Required” will show
If metered consumption is deemed reliable** AND there is a bill available that covers part of the month being accrued, the Estimated Bill Cost is calculated as:
[Daily_Avg_Metered_Cons] * [Bill_Avg_PPU_Current_Bill] * [Days_to_Accrue]
Explanation:
If metered consumption is deemed reliable** AND there is not a bill available the covers part of the month being accrued, AND there is a bill available that covers part of the previous month, the Estimated Bill Cost is calculated as:
[Daily_Avg_Metered_Cons] * [Bill_Avg_PPU_Previous_Month_Bill] * [Days_to_Accrue]
Explanation:
If metered consumption is deemed reliable** AND there is not a bill available the covers part of the month being accrued, AND there is not a bill available that covers part of the previous month, the Estimated Bill Cost is calculated as:
[Daily_Avg_Metered_Cons] * [Bill_Avg_PPU_Previous_Year_Bill] * [Days_to_Accrue] * [Inflation_Factor]
Explanation:
If metered consumption is deemed unreliable** AND there is a bill available the covers part of the month being accrued, the Estimated Bill Cost is calculated as:
[Daily_Bill_Avg_Current_Bill] * [Days_to_Accrue]
Explanation:
If metered consumption is deemed unreliable** AND there is not a bill available the covers part of the month being accrued AND there is a bill available that covers part of the previous month, the Estimated Bill Cost is calculated as:
[Daily_Bill_Avg_Previous_Month_Bill] * [Days_to_Accrue]
Explanation:
If metered consumption is deemed unreliable** AND there is not a bill available the covers part of the month being accrued, the Estimated Bill Cost is calculated as:
[Daily_Bill_Avg_Previous_Year_Bill] * [Days_to_Accrue] * [Inflation_Factor]
Explanation:
If no accrual could be calculated, then “Accrual Not Possible” will show
** More than 7 days of non-zero consumption being available in the given month and the total consumption amount is greater than zero would be deemed as reliable data