Introduction

This report is for Electricity, Gas and Water accounts only else the account gives a row of zeroes.

This works on the basis that it will accrue:

Either Basic accrual (latest bill) or Price Annual (latest for p/unit cost rate and nearest bill going forwards after the accrual date but in last year, for consumption rate.
If it finds units charges and standing charges on the latest bill (the expected situation) it accrues these separately to give a much more accurate accrual than using an average rate for the latest bill.
If last year’s bill is for negative consumption when doing a Price Annual accrual it will default to using the latest bill this year resulting in a Basic Accrual.
It will accrue sewerage-only accounts if the ‘s’ flag only is ticked in the account screen and label the utility as Waste water. (If ‘s’ and ‘w’ are both ticked it will do an appropriate accrual for water and sewerage).
If bills have just costs (such as MOP accounts) it will accrue the MOP charges on a per day basis.
If bills have cons and all costs in one lump (rather than separate cost rates for the units) then it will use an average pence rate.
The report tells you the bill it has used to discover daily consumption rate and if necessary a reason for the bill it has selected.
If last year and this year are both credits then no accrual will be done.

You can set an ‘accrue from’ date so that to give the year end forecast from now (near the end of Feb) you can firstly accrue to the end of Feb which will attempt to use last Feb’s bill for daily consumption rate, then accrue from 1^st – 31^st March to get 31 days’ accrual with an attempt at using last March’s bill for daily consumption for this period. This is better than accruing to 31^st March in 1 hit which will use last March’s bill inaccurately for the remainder of February as well as the whole of March.

If the report encounters a discount % figure, as a simplification it will just use the average p/unit rate for such accounts.

P/unit totals for electricity includes contract rates, CCL:, DUOS, and green electricity additional rates. This is multiplied by the no. of units on the bill used for rates (i.e. on the latest bill) and this all inclusive sum is subtracted from the bill total to give standing charges. This residual standing charge is then divided by the days on the ‘rates’ bill to give an accruable daily standing charge.

Open the Reporting Activity

Click on the Reporting Activity

Create the Report

Choose the data to run the Accrual Master Report on

From the Data Selector, choose the Accounts (or Monitoring Points) you want to run the Accruals Master Report on.

Choose the Report type

From the right hand side, search for 'Accruals Master' and highlight the Report

Choose the criteria to run the Report on

From the bottom right, choose the criteria you want to run the report on.

Report template - Choose Table (simple) or Table (Table will give you more information such as VAT rates)

Accrual Date - Choose the date you want to accrue to

Account Selection Criteria - Choose Only use 'Active accounts or Use all accounts

Accrue using (where possible) - Choose

Latest Bill for Cost Rate and bill Last Year for Consumption ('Price Annual Accrual') - this will give you the best cost as based on the latest bill, but the consumption will be based on the same period last year

or

Latest Bill for Cost Rate and Consumption ('Basic Accrual') - this will use the latest bill for both the cost and the consumption

Use start date - tick if you want to use a start date other than today

Accrual start date - change if you have ticked above

Optional report subheading - enter a subheading if required

Run the Report

Click and wait for the middle of the screen to populate with the Report

View the Report

Click on to view the Report in Excel

Save the Report to the Document Library

Alternatively, you can run the Report to the Document Library activity to make it run quicker and save it within Sigma

Choose the same criteria as above, but instead of clicking on Run Report, click Schedule
Click Report output
Choose from either
- PDF or XLS

Click OK to save the Report

View the Report in the Document Library

Open the Document Library Activity
Click on the Reports Folder
Open the dated Folders ie, open 2020, open 8, open 7 to see the Report on the right of the screen
Right click on the Report and then click Open to download

Detailed Report explanation

Accruals Master Table (simple)

This has less columns than the Table, but will give you the basic details used to create the Accrual.

Below is a guide to each column

Column	Example	Explanation
A - Site	LA Dixon Control Centre	Site name
B - Account	2874526S	Account number
C - Bill (for Cons)	31/08/2019	The date of the Bill used for consumption (last year) - as per criteria selected
D - Cons/day	257.42	The daily consumption from the bill in Column C
E - Latest Bill	05/08/2020	Date of latest bill in Sigma
F - Net ppu (Acc.Cost)/(Acc.Cons)	7.853	The average ppu from the bill in column C (including CCL)
G - Accrual/day (£)	20.22	The accrual cost per day
H - Days to Accrue	26	The amount of days needed to be accrued, ie the accrual date is 31/08/2020, using the date in Column E
I - Net Accrual (£)	525.62	Net Accrual in ££s using the accrued Standing Charge and accrued Units
J - Gross (£)	551.88	The Gross Accrual in ££s
K - Accrued Cons	6693	The accrued consumption up until the Accrual Date (31/08/2020) (in kWh). The amount of many days to Accrue (column H) x daily accrual consumption(column D)
L - Units	kWh	Measurement
M - Utility	Gas	Utility
N - Method	Price Annual	Price Annual/Bill Problem

Accruals Master Table

This has more columns than the Table (simple), and shows all the details used to create the Accrual.

Below is a guide to each column

Column	Example	Explanation
A - Site	LA Dixon Control Centre	Site name
B - Account	2874526S	Account number
C - Utility	Gas	Utility
D - 'Consumption Bill'	31/08/2019	The date of the Bill used for consumption (last year) - as per criteria selected
E - Days on 'cons bill'	31	The amount of days in the bill in column D - quality check
F - Metered Cons/Day ('cons bill')	257.42	The Daily consumption from the bill in column D in kWh
G - Units	kWh	Units in bill
H - Latest bill	05/08/2020	Date of latest bill in Sigma
I - Net rate p/unit (metered)	4.83110	The average ppu from the bill in column H (including CCL)
J - Accrued Consumption	6692.90	What the accrued consumption is up until 31/08/2020 (in kWh). The amount of days to Accrue (column N) x daily accrual rate (column F)
K - Accrued Units Chg (£)	323.34	The Accrued cost of the units in Column J
L - Latest bill days	5	The amount of days in the latest bill
M - Latest Standing Chg (£)	38.90	The standing charge (and all other charges in the latest bill)
N - Days to Accrue	26	The amount of days needed to Accrue, ie the accrual date is 31/08/2020, using the date in Column H
O - Accrued Standing Chg (£)	202.28	What the Accrued Standing charge will be for the period. Column M / Column L x Column N
P - Net Accrual (£)	525.62	Net Accrual in ££s. Total of column O and K
Q - Vat rate%	5	The VAT rate
R - VAT (£)	26.26	The cost of the VAT
S - Gross Accrual (£)	551.88	The Gross Accrual in ££s
T - Method	Price Annual	Price Annual/Bill Problem

Browser not supported