Academy Support

 

The following spreadsheet toolkit and useful documents are only available
to subscribers to either our Premier or Premier Plus Support Visit service.

Our model Policy Document templates must be personalised to suit your Trust
before being formally adopted by the Board of Trustees.

UPDATES:

  • The 2019/20 versions of our Academy budget planning toolkit have now been added, these include the 1 Year Budget Planner, Support Staff and Teaching Staff Calculators, Forward Financial Planner 2019-2024 (please take care to use the relevant tabs for estimating your SEN funding, details are in the guidance notes), and Catering Trading Account spreadsheets.
  • Cashflow forecast – This has been updated and simplified to make the task of monitoring your cashflow much quicker and easier. There are 2 versions: Version 1 – academies not using our ‘Academy 1 year Budget Plan with EHCP cashflow profiling’ must use the ‘Academy Simple Cashflow Forecast’ where budget figures have to be entered manually: Version 2 entitled ‘New Academy Cashflow with import option’ which enables budget figures to be downloaded directly from our 1 year budget planner with EHCP tab, straight into the cashflow spreadsheet, pre-populating the initial forecast sheet.
  • Academy Financial Regulations Template – this document is updated annually to reflect the changes in the Academies Financial Handbook. We also produce a main changes document so that you can simply make the changes to your existing template to save as an updated version ready for governor approval in the Autumn term. A reminder for new converters that the template should be personalised to meet the needs of the academy before being approved by the Full Governing Body / Board of Trustees.
  • Policy document templates – Following customer requests, we have numbered the points in the policy documents and included a contents page for ease of reference.
  • NEW POLICY TEMPLATE – We have added a Revenue and Capital Reserves Policy template to our toolkit, following customer requests. As with all our policy templates, this must be personalised to suit your academy trust.

NEW ADDITIONS TO THE TOOLKIT:

  • Financial Health & Efficiency Dashboard – This spreadsheet produces a financial dashboard that shows pictorial representation and statistical percentage information to assist in your reporting to trustees. There are two versions, one for Stand-alone academies and one for Multi Academy Trusts.
  • Financial Skills Matrix for Schools Staff – A new addition to our Policy Document templates, this matrix should be completed by all staff with financial responsibility and can be used for trustees to assess whether there is sufficient financial expertise spread across the staff and also that they are not over reliant on one person. Individuals can use the matrix as evidence of training needs for their own professional development.
  • Capitalised Asset register & Depreciation Calculator is designed to keep a record of the Fixed Assets that make up the value shown in your annual financial statements. The spreadsheet automatically calculates the monthly depreciation on these assets to aid in the completion of your budget forecast returns.
  • Accruals template has been updated to include sections for all current assets and liabilities in order to assist in collating your year-end creditors/debtors etc, and enable you to see the net effect on your carry forward position.
  • MAT Accruals template – the MAT version of our accruals template has a full set of tabs for each academy plus summary sheet so you can see the net effect on each academy’s carry forward position, plus an automatically generated full summary sheet for the whole MAT showing the total current assets and liabilities as well as the overall net effect on the year end position.
  • Salary Variance spreadsheet is designed for use where the finance system does not automatically display variances in salary payments (ie. PS Financials, Civica, RM, SAGE) in order to evidence monitoring of actual versus expected salary payments.
  • PSF specific tools – Estimated Carry Forward Calculator, Bank Reconciliation, VAT Reconciliation, Control Account Reconciliation
  • Virement Tracker – in answer to customer request we have produced a simple spreadsheet that enables you to keep track of your virements and automatically produces the virement form for authorized signature.
  • Finance Task Checklists have now been added for Headteachers. School Business Managers and Finance Officers.  These checklists should be used to ensure compliance with the Finance Regulations.
  • A simple Annual Contracts Spreadsheet has been added to the toolkit to assist academies in keeping a single record of all contracts that can be regularly reviewed for renewal and cancellation dates. This will also be helpful for internal audit purposes.
ACADEMIES FINANCIAL HANDBOOK
File Name Description Last Updated
Academies Financial Handbook September 2018 2019-03-06 18:22:10 View
NEWSLETTERS
File Name Description Last Updated
Academy Newsletter Issue 19 - Sept 18 2019-03-06 18:36:50 View
Academy Newsletter Issue 20 - Dec 18 2019-03-06 18:36:51 View
POLICY TEMPLATES
File Name Description Last Updated
Academy Best Value Statement template 2018 2019-03-06 18:51:36 View
Academy Gifts and Hospitality Policy template 2017 2019-03-06 18:51:56 View
Model Register for Gifts and Hospitality Received and Given 2019-03-06 18:52:07 View
Academy Charging and Remissions Policy template 2018 2019-03-06 18:52:19 View
Academy Procurement Policy template 2018 2019-03-06 18:52:32 View
Academy Lettings Policy template 2018 2019-03-06 18:53:00 View
Financial Management Skills Matrix for school or academy staff 2019-03-06 18:53:11 View
Academy Financial Regulations Template Sept 2018 AFH 2019-03-06 18:53:26 View
Academy Financial Regulations 2018 main changes document 2019-03-06 18:53:36 View
Academy Financial Regulations Template Sept 2017 AFH 2019-03-06 18:53:50 View
Finance Regs Appendix - Declaration of Pecuniary and Personal Interest 2019-03-06 18:54:04 View
Finance Regs Appendix - Academy Fin Regs Mileage 2019-03-06 18:54:15 View
Finance Regs Appendix - Academy Fin Regs Daily Income 2019-03-06 18:54:29 View
Finance Regs Appendix - Academy Fin Regs Class Activity 2019-03-06 18:54:40 View
Academy Revenue and Capital Reserves Policy 2019-05-10 16:48:28 View
CHECKLISTS
File Name Description Last Updated
Academy Finance Officer Finance Task Checklist 2018 2019-03-06 19:10:43 View
Academy Headteacher Finance Task Checklist 2018 2019-03-06 19:10:45 View
Academy SBM Finance Task Checklist 2018 2019-03-06 19:10:45 View
SPREADSHEET TOOLKIT
File Name Description Last Updated
Academy 1 Year Budget Plan 2018.19 2019-03-06 19:26:59 View
Academy 5 Year Budget Plan 2018 to 2023 2019-03-06 19:26:59 View
PSF Academy 1 year budget planner 2018.19 2019-03-06 19:27:18 View
Academy Support Staff Salary Calculator 2018-19 2019-03-06 19:27:55 View
Capitalised Asset Register & Depreciation Calculator 2018-19 2019-03-06 19:28:21 View
Annual Contracts Spreadsheet 2019-03-06 19:28:21 View
Cashflow with import option 2018/19 2019-03-06 19:28:24 View
Cashflow 2018/19 2019-03-06 19:28:44 View
Catering Trading Account - Junior School 2018/19 2019-03-06 19:28:44 View
Catering Trading Account - Infant and Primary School 2018/19 2019-03-06 19:29:06 View
Trading Account - Nursery/Breakfast/After School Club 2018/19 2019-03-06 19:29:06 View
Control Account Reconciliation FMS 2018/19 2019-03-06 19:29:29 View
PSF Control Account Reconciliation 2018/19 2019-03-06 19:29:29 View
Estimated Carry Forward Calculator - PS Financials 2018/19 2019-03-06 19:29:52 View
Estimated Carry Forward Calculator - FMS6 - 18/19. 2019-03-06 19:29:52 View
Financial Health & Efficiency Dashboard - MAT version - FMS 2019-03-06 19:29:55 View
Financial Health & Efficiency Dashboard - Stand-alone academy version - FMS 2019-03-06 19:29:56 View
Salary Variance Spreadsheet 2018/19 2019-03-06 19:30:17 View
Funding Tracker 2018-19 2019-03-06 19:30:17 View
Virement Tracker 2019-03-06 19:30:19 View
PSF Bank Account Reconciliation 2018/19 2019-03-06 19:30:35 View
Bank Reconciliation 2019-03-06 19:30:35 View
Petty Cash Imprest Account Reconciliation 2019-03-06 19:30:57 View
VAT Reconciliation Form 2018/19 2019-03-06 19:30:57 View
PSF VAT Reconciliation 2018/19 2019-03-06 19:31:07 View
Academy 1year Budget Plan 2019.20 2019-05-10 08:53:25 View
Academy 5 year budget plan 2019 to 2024 v1 2019-05-10 09:06:59 View
Academy Support Staff Salary Calculator 2019-20 v19.3 2019-05-10 09:09:00 View
Academy Teaching Staff Salary Calculator 2019-20 v19.1 2019-05-10 09:10:42 View
Academy CashFlow 2019.20 2019-05-10 09:58:09 View
Academy Junior Schools-Catering Trading Account 2019-20 2019-05-10 10:09:07 View
Academy Primary/Infant -Catering Trading Account 2019-20 Includes a UIFSM calculator tab 2019-05-10 10:11:00 View
Academy Secondary -Catering Trading Account 2019-20 2019-05-10 10:13:08 View
Academy Cashflow with import option 2019.20 The import function is compatible with EFS 1 year budget planner only 2019-05-10 12:15:28 View
Academy Accruals template 31 AUGUST 2019.xlsx We have a MAT version available on request 2019-05-10 12:19:57 View

Please contact our advice line on 033301 39832 or email enquiries.efs@EESforschools.org for further help or assistance.

Sign up to the EES for Schools newsletter

Privacy Policy