Accounting and financial planning

Colleges prepare their accounts and financial statements which explain how they spend their money and account for their activities. Colleges have developed an effective accounting framework over 20 years in partnership with universities, funding agencies and audit firms.

This section contains accounting and financial planning information for the summer 2018 financial plans and for the 2017-18 accounts.

ESFA have not yet issued the financial plan handbook or spreadsheets for the summer 2018 round. They expect to issue these, along with the college finance spreadsheet in the first half of May 2018.

Updated information from ESFA and AoC for the 2017-18 accounts

Information for earlier years is available here

College accounts direction for 2017-18

ESFA's accounts direction for 2017-18 is available here

College_Accounts_Direction_17_18_200318.pdf (PDF,705.34 KB)

College accounts direction handbook for 2017-18

AoC's College Accounts Direction Handbook for 2017-18 is based very largely on the 2016-17 handbook with some updated text on mergers and some very small corrections for apprenticeship levy and the work placement capacity development funding. AoC is not in a position to advise colleges on adopting the Charity Governance Code but the handbook does provide information about using the College or corporate code. The Casterbridge model set of accounts will be updated by mid May.

Accounts Direction Handbook 201718 v1 20 april 2018.docx (DOCX,165.54 KB)

Post 16 audit code of practice for 2017-18 plus Regularity questionnaire

ESFA's updated post 16 audit code of practice for 2017-18 is available here

Post_16_audit_code_of_practice_17_18_200317.pdf (PDF,686.62 KB)

An updated version of the regularity audit self assessment questionnaire is here

2017_07_18 ACOP - SAQ - 200318-1.pdf.docx (DOCX,51.65 KB)

FE/HE SORP

Colleges follow UK accounting standards which are interpreted for them via the Further and Higher Education Statement of Recommended accounting Practice (F&HE SORP). In 2015, colleges adopted international accounting standards for their accounts which were introduced for non-for-profit organisations like universities, colleges, charities and housing associations via the UK standard FRS102. Responsibility for the SORP rests with universities and colleges in the four parts of the UK. AoC and college representatives worked with university finance directors and people from funding agencies and audit firms to produce the new statement which took effect for 2015/16 financial year.  For those who are interested, the British Universities Finance Directors website explains the background and development of the SORP.

The SORP is available here

Work is now underway to update the SORP.  This work involves university and college organisations across the UK, including AoC. The plan is to update the SORP for financial statements covering the 2019-20 year but, at this stage, the planned changes are minimal. The SORP board will be presenting an updated 2019 SORP to the Financial Reporting Council (FRC) in summer 2018 for approval.

HISTORIC INFORMATION

Finance record 2016-17

ESFA has issued for the 2016-17 finance record spreadsheet which needs to be returned by 31 December 2017

Finance Record template 2017 version 1.1 16 nov 2017.xlsm (XLSM,377.02 KB)

Enhanced pension provision for 31 July 2017

Colleges who need to include an enhanced pension provision in their accounts as at 31 july 2017 should use the spreadsheet made available by AoC for the 2015-16 financial year to accompany the implementation of the new SORP and FRS102. It is not necessary to revalue every provision in financial statements every year. In our view (which is not based on professional advice), the factors affecting this provision include demographic factors and the discount rate adopted for valuing pensions which have not changed in a material way in the last 12 months.

EPP 2016 calculator (with factors) (201609).xls (XLS,794.5 KB)

Accounts direction, handbook and Casterbridge model for 2016-17

College accounts direction

The EFA/SFA college accounts direction for 2016-17 was published in January 2017 and is available here

CF_-_accounts_direction_2016_to_2017.pdf (PDF,113.05 KB)

Accounts direction handbook for 2016-17

The new college accounts direction handbook for 2016-17 accounts is available here. The handbook was substantially revised in 2016 to help apply the new FE/HE SORP (which interprets FRS102) in college accounts and has had some updates in 2017. The handbook and the accompanying Casterbridge college model have been prepared by Bill Lumsden (ex BDO, ex KPMG) who was commissioned to do this work by AoC following a competitive tender. There are a number of small improvements in 2017 but nothing major

Accounts Direction Handbook 2016_17 v2.pdf (PDF,408.59 KB)

Accounts Direction Handbook 2016 17 v1 2 (2).docx (DOCX,146.59 KB)

Casterbridge model

A model set of accounts based on the fictional Casterbridge college is also available. The accounts structure and narrative are advisory and it up to individual colleges to present their financial statements in a way that best presents their activities. ESFA have used the model in preparing the financial plan to introduce some element of consistency in data collected. Word and Excel versions are available below.

Casterbridge College accounts 2016 17 v2.pdf (PDF,874.65 KB)

Casterbridge College accounts 2016 17 v2.docx (DOCX,211.96 KB)

Casterbridge College Financial Statements 2016 17 v1.2.xlsx (XLSX,111.62 KB)

 

College accounts data 2015-16

A spreadsheet with data from every college for the 2015-16 financial year derived from college financial statements but some is directly entered onto a year end finance record (there may be transposition or data entry errors).

All College Accounts 2015-16- for AoC-without formulae 27062017 (2).xlsx (XLSX,887.32 KB)

Post 16 Audit Code

The post-16 audit code of practice sets out the Education and Skills Funding Agency (ESFA) assurance and accountability requirements for colleges and other post-16 providers. The audit code draws on ESFA funding agreements. The code is updated each year. This version of the code is relevant for all periods commencing on or after 1 August 2016.

 

Financial planning spreadsheets 2017-18 to 2019-20.

ESFA's summer 2017 financial planning handbook, spreadsheets and template guidance for summer 2017 is available here

Financial Plan 2017 v1.0 final.xlsm (XLSM,1.65 MB)

CF_-_Financial_Planning_Handbook_2017_v20170609.pdf (PDF,381.66 KB)

CF_-_Financial_Planning_Handbook_2017_GUIDANCE_v1.pdf (PDF,110.84 KB)

Financial benchmarking data 2015-16 and 2014-15

The college financial benchmarking tool helps colleges compare their financial performance with others in the sector. Users can filter the benchmark population based on certain criteria. The tool provides a number of benchmarking reports, trend analysis and access to the underlying datasets. This version of the tool includes data submitted in colleges’ 2014/15 and 2015/16 finance records and has been significantly changed from earlier versions. Most of the data is derived from college financial statements but some is directly entered onto a year end finance record and there may be transposition or data entry errors.

Benchmarking_Tool_1415_1516.xlsx (XLSX,4.18 MB) Benchmarking_tool_guidance_1415_1516.docx (DOCX,60.17 KB)

Finance record 2015-16

The 2015-16 finance record spreadsheet was used by colleges to return data from the 2015-16 accounts to the funding agencies. The 2016-17 spreadsheet will be available in the early autumn.

College_finance_record_template_2015_to_2016_v1_2 with data vali....xlsm (XLSM,915.26 KB)

Enhanced pension provision spreadsheet for 31 July 2016

The Enhanced Pension Provision spreadsheet to allow colleges to account for future costs of early retirement or redundancies in their 31st July 2016 financial statements. 

EEP calculator with factors, 12 September 2016 (XLS,794.5 KB)
EPP accounting assumptions 2016 for AoC.pdf (PDF,851.08 KB)

2016 college financial plans (for return by 31 July 2016)

Financial plan spreadsheets

SFA and EFA's new Funding Agency Shared Service Team (FASST) has produced updated financial plan spreadsheets for submission in July 2016. Colleges are required to return plans which provide information on provisional 2015-16 results, 2016-17 budget and a forecast for 2017-18. The data collected has been updated to take account of the new accounting standards (FRS102 and the FE/HE SORP). The spreadsheets and template guidance (which are also be posted on gov.uk) are here

College financial plan template 16 June 2016 v1 4.xlsm (XLSM,1.96 MB)

College financial plan template 14 June 2016 v1.3.xlsm (XLSM,1.73 MB)

College financial plan 2016 template (issued) v1.2.xlsm (XLSM,1.77 MB)

College Financial Plan 2016 template guidance vFINAL.pdf (PDF,315.31 KB)

Financial planning handbook

SFA and EFA published a financial planning handbook earlier in 2016 which explained the planning process, their expectations on colleges and their financial health assessment. Key changes for 2016 were:

  • the requirement to share the financial planning checklist with the college's corporation before approval
  • the requirement to explain key assumptions in the template
  • the update to the financial health ratios to take account of the new SORP
  • the adjustment to the scores used in the financial health ratios

The new financial planning handbook is here

Financial Planning Handbook 2016-2018 v2.pdf (PDF,737.27 KB)

A letter from SFA/EFA Peter Lauener to chairs and principals circulated in June 2016 says governors must scrutinise plans

Joint SFA EFA - 14-06-2016 - Letter to Chairs and Principals - Financial Plans.pdf (PDF,141.79 KB)

SFA/EFA's checklist of assumptions (for colleges to use in preparing plans) is available as a Word document here

Financial planning 2016 assumptions checklist Annex 1.docx (DOCX,19.32 KB)

An AoC note on financial plan assumptions (last updated on 15 June 2016) is available here. This sets out some issues which will affect college income and expenditure. There is also a note on the possible impact of the EU referendum vote

AoC briefing note college financial plan assumptions june 2016.pdf (PDF,450.74 KB)

Accounts direction, handbook and Casterbridge model for 2015-16

College accounts direction

The EFA/SFA college accounts direction for 2015-16 was published in January 2016 and is available here

College_Accounts_Direction_1516.pdf (PDF,499.51 KB)

Accounts direction handbook for 2015-16

The new college accounts direction handbook for 2015-16 accounts is available here along with the model accounts for a fictional Casterbridge College. 

Accounts Direction Handbook 2015-16 july 2016 v1.4.pdf (PDF,842.89 KB)

Casterbridge College accounts 2015 16 v1.6 july 2016 Word 2010.docx (DOCX,205.24 KB)

Casterbridge College Financial Statements 2015-16 July 2016.xlsx (XLSX,121.44 KB)

College Accounts for 2014-15, 2013-14 and 2012-13

These very large spreadsheets are the combined SFA and EFA database of college finance records for the years ending 31 July 2015, 31 July 2014 and 31 July 2013. Information was supplied by further education and sixth form colleges in their December finance records (in 2015, 2014 and 2013) which draws information from their audited 2014-15, 2013-14 and 2012-13 accounts plus voluntary benchmarking information. This information is used extensively by finance directors to benchmark their income and costs and is used by interested parties to analyse financial trends in the sector. Unlike similar financial data collected by councils, universities and the NHS, this accounting information is available free of charge. The 2014-15 accounts spreadsheet was updated on 6 May 2016

All College Accounts 2014-15 6 May 2016.xlsm (XLSM,3.62 MB)

All College Accounts 2013-14 - 3 May 2016-without formulae.xlsm (XLSM,1022.69 KB) All College Accounts 2013-14 - 3 May 2016-with formulae.xlsx (XLSX,1.03 MB)

All College Accounts 2012-13 v2 - 24 April 2014 (XLSX,973.2 KB)

If you have any queries on the data, please ask Julian Gravatt. Corrections of errors spotted by individual colleges will need to be reported to SFA or EFA (depending on who their regulator is).

Model management accounts

The Colleges' Finance Directors' Group worked with Darwen Financial Management in 2012 to produce guidance on college management accounts and some good practice examples. There is no requirement for any college to follow this model but we hope that they provide some useful ideas.

Guidance Notes on Completion of Management Accounts Tool.doc (DOC,72.5 KB)

Management Account Good Practice Guide.doc (DOC,107 KB)

Management Accounts Tool.xls (XLS,862 KB)

MAs Guide final report CFDG version.doc (DOC,74.5 KB)

The Model Management Accounts - Exemplar One.doc (DOC,374 KB)

The Model Management Accounts - Exemplar Two.doc (DOC,416 KB)


2014-15 accounts - the accounts direction, the handbook, the finance record spreadsheets and other assistance

The 2014-15 accounts direction from the Skills Funding Agency (SFA) and Education Funding Agemcy (EFA) is here:

Accounts direction for 2014-15 financial statements (PDF,901.38 KB)

AoC's accounts direction handbook which containED detailed guidance on preparing 2014-15 accounts is here:

Accounts direction handbook 2014-15 (PDF,1.94 MB)

The 2014-15 Casterbridge College accounts were available as a spreadsheet

Chapter four 4b Model Casterbridge College Financial Statements 2014-15 (XLSX,123.17 KB)

The 2014-15 finance record needed to be completed by 31 December 2015 using data from audited accounts plus additional data for benchmarking and to aid transparency about college finances.

Finance record 2014-15 (XLSM,728.53 KB)

2014-15 is the last year in which the old Further and Higher Education Statement of Recommended Practice (SORP) applies. Next year (2015-16) brings the challenge of implementing a new SORP and making this compatible with international accounting standards which are embodied in the UK Financial Reporting Standard (FRS102).

2015 Enhanced Pension Provision (EPP) spreadsheet

The enhanced pension provision spreadsheet allows colleges to calculate their unfunded pension liability as at 31 July 2014 using a spreadsheet which is available in both Excel 2003 and Excel 2007 versions.  The spreadsheet has 3 worksheets, one for input and two to report data.

EPP2015 (2007) v1 (XLSM,294.74 KB)

EPP2015 (pre 2007) v1 (XLS,717.5 KB)

EPP 2015 accounting assumptions (PDF,89.36 KB)

2013-14 Benchmarking software

The 2013-14 finance benchmarking software makes it easier to analyse data from college accounts.

Financial benchmarking 2013-14 v1.4 8 June 2015 (XLSM,3.62 MB)
Financial Benchmarking 2013-14 (XLSM,3.69 MB)
Guidance for 2013-14 College Financial benchmarking.docx (DOCX,358.13 KB)

2014-15 Accounts Direction

The 2014-15 accounts direction from SFA and EFA is here:

SFA/EFA Accounts Direction for 2014-15 (PDF,901.38 KB)

Benchmarking tool to analyse college accounts

The financial benchmarking tool enables colleges to compare performance and ratios for different years against other colleges. The data in the tool is taken from college finance records. Guidance is also provided to assist with understanding and using the benchmarking tool.

Benchmarking Tool (XLSM,4.45 MB)

Guidance for 2012-13 Financial Benchmarking (PDF,405.62 KB)

Accounts direction for 2013-14

The 2013-14 accounts direction is here


Accounts Direction for 2013-14 Financial Statements (PDF,447.95 KB)

Enhanced Pension Provision spreadsheet 2014

The enhanced pension provision spreadsheet allows colleges to calculate their unfunded pension liability as at 31 July 2014 using a spreadsheet which is available in both Excel 2003 and Excel 2007 versions. The spreadsheet is prepared by KPMG staff as part of the AoC/ CFDG financial reporting project which is ultimately funded by the Skills Funding Agency. The 2013-14 spreadsheet includes updated financial and demographic assumptions which are explained in the attached briefing. The overall impact of the financial assumptions has been that the net interest rate has reduced from 2.50% to 2.25% while the updated mortality tables forecast increased life expectancy. Both changes tend to slightly increase calculated liabilities although the effect varies by the member’s age. In all other respects the methodology is the same as last year.


EPP2014 (pre 2007) (XLS,696 KB)
EPP2014 (pre 2007).xls (XLS,696 KB)
EPP accounting assumptions for 31 July 2014 (PDF,91.81 KB)

2014 Regularity Audit Framework

Colleges have been required by EFA and SFA to have regularity audits for more than 10 years and the framework guiding college external auditors is now out of date.  EFA and SFA have issued an updated framework for 2013-14 which passes more responsibility to colleges, asks them fewer questions but which provides more guidance.

This new framework is an Appendix to the Joint Audit Code of Practice which is itself due for revision during 2014-15. There have been some improvements in recent years to content and clarity about the rules which govern colleges but there is still a little way to go.
Regularity audit framework 2014-15 (PDF,133.72 KB)
Regularity audit framework - word version (DOCX,44.79 KB)

Tags

Funding and Finance