Councils have managed their finances well but significant challenges lie ahead, says the Accounts Commission.
Please note that paragraph 44 and exhibit 6 of this report have been updated post publication to correct an error identified in supporting data.
Councils produce annual accounts on an annual basis for financial years ending 31 March. Draft or unaudited accounts are published each year by 30 June and we ask auditors to submit a return based on this unaudited information. We compile a database that allows auditors to carry out high level comparative analysis between councils as part of the audit process.
In recent years we have updated the unaudited accounts database for changes made to annual accounts as a result of audit and we have created a spreadsheet to allow this information to be compared across years.
The workbook below provides an extract from this spreadsheet and focuses on three of the major financial statements from the accounts - Movement in Reserves Statement, Comprehensive Income and Expenditure Statement, and Balance Sheet.
The Movement in Reserves Statement (MIRS): This statement contains the opening and closing balances of the different reserves held by councils. It also records any adjustments to and from reserves that councils must make to meet statutory obligations.
The Comprehensive Income and Expenditure Statement (CI&ES): This statement shows what councils have spent on individual services, other operating costs such as interest costs and sources of council income such as Scottish Government grants and council tax.
The Balance Sheet (BS): This statement shows everything that councils own (assets), what they owe (liabilities) and how they have financed this as shown in the balance of their reserves.
The source of each item in the spreadsheet is shown by the inclusion of the relevant abbreviation. Figures that are a combination of others include the word ‘overview’ in their title. These can also be identified on the ‘Data’ worksheet as they are coloured orange. This method can also be used to identify how these have been calculated.
Data for 2014/15 and 2015/16 is derived from audited accounts and has undergone some cross checking and validation. However, there are some limitations to the data for earlier years which is based on the unaudited accounts and has not been updated for any restatements arising from changes in accounting policy or correction or material errors in subsequent years.
We have also included some contextual information from National Records of Scotland (population and number of households) and from Scottish Government statistics (staffing and pupil numbers). This has been mapped across financial years to allow different types of analysis to be carried out.
To allow real terms analysis to be carried out we use HM Treasury GDP deflators to adjust values for inflation. This is the standard way of analysing public sector expenditure. The date these GDP deflators were published is included in the workbook and they are consistent with those used in ‘Local government in Scotland: Financial Overview 2015/16’.
The workbook consists of a main input sheet that controls a series of charts and tables. The yellow cells on the input sheet can be used to select items from drop down lists:
In the ratio section of the input sheet you can then select:
These selections generate a series of charts that can be found on the ‘Charts’ and ‘Ratio Charts’ sheets. These can then be accessed using the hyperlinks in the workbook or by selecting the individual worksheets.
The remaining three sheets will show you the items you have selected but for all 32 councils, also allowing you to select years to auto calculate changes between years, and the raw data the workbook uses.