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

...