1. Summary
1.1 About this guidance
This guidance has been produced by Education and Skills Funding Agency (ESFA) as a reference tool for all local authorities. It provides support when completing plans for managing their dedicated schools grant (DSG).
1.2 Review date
This guidance will next be reviewed in 2023.
1.3 Who is this guidance for?
In response to feedback from local authorities and other stakeholders, we have designed a management plan template to help local authorities manage their DSG. ESFA has developed and enhanced this template in partnership with over 60 attendees from local authorities, their representatives and other stakeholders via user research groups and collated feedback.
This document is a step-by-step guide to help local authorities complete the DSG management template. The template is a supportive tool to enable local authorities to formulate and present their DSG management plans. It will be particularly useful for local authorities when discussing and sharing proposals with internal and external bodies, including schools forum (particularly any high needs working groups), special educational needs and disabilities (SEND) partnership or oversight boards established by the council, parent and carer forums and relevant council committees.
Please note: safety valve funding negotiations are a separate exercise to the DSG management plan template. Guidance on this can be found within the high needs safety valve funding in the schools revenue funding 2022 to 2023 operational guide.
1.4 Overview of the DSG management plan template
The DSG is a ring-fenced specific grant, provided outside the local government finance settlement. It must be used in support of the schools budget for the purposes defined in regulation 6 and schedule 2 of the School and Early Years Finance (England) Regulations 2022.
The DSG: conditions of grant 2022 to 2023 paragraph 5.2, requires that any local authority with an overall deficit on its DSG account at the end of the 2021 to 2022 financial year, or whose DSG surplus has substantially reduced during the year, must be able to present a plan to DfE for managing their future DSG spend. We also realise that there will be a requirement for local authorities to share this information with their stakeholders, such as schools forums, parent and carer forum, local headteacher boards or groups.
To help local authorities meet this requirement we have provided a DSG management plan template. This template will help local authorities:
- comply with paragraph 5.2 of the DSG: conditions of grant 2022 to 2023
- monitor how DSG funding is being spent
- highlight areas where local authorities may wish to review spending
- form evidence-based and strategic future plans for the provision of children and young people with SEND
- present complex funding information simply to schools forums and other external stakeholders
- provide a consistent reporting format to help local authorities share best practice and initiatives
The template will help local authorities to focus attention on comparisons of high needs provision and spend, to produce the required plan. We encourage all local authorities to use the template as a planning tool.
We expect the plan to be updated and presented at schools forum meetings and any high needs subgroups regularly and at least on a termly basis. The local authority should aim to present their plan to the schools forum in time for budget planning discussions for 2023 to 2024 and before the deadline for block movement requests if it is submitting one. We realise that the management of DSG balances, both bringing spend in line with income and repaying deficits, will take time for some local authorities. We have developed the template in such a way that it is intended to be a live document.
Management plans should reflect the most current forecast DSG position and be published on the local authority local offer website as set out in the Special educational needs and disability (SEND) Code of Practice: 0 to 25 years.
Relevant leads in the finance and special educational needs (SEN) areas should sign off each version of the management plan (with sign off to be at least at assistant director level).
If you have any questions regarding this guidance or template, please contact the financial management mailbox
1.5 Further guidance
These are additional guidance documents you may also find helpful:
2. Glossary
The ‘introduction page’ within the DSG management template, which is available on Document Exchange, provides information and reference links to acronyms that are used throughout this document, for ease of reference.
3. How to complete the management plan template
This document describes how to use and complete the management plan template and has been designed as a reference guide.
Please note that based on user feedback, the template has been created using Microsoft Excel and is available on Document Exchange. As such, it is expected that users completing the template will at least have a basic knowledge of this software.
This template relies on calculations running automatically as you select your local authority and enter data. To ensure that this is happening correctly please check your settings by clicking on the formulas tab; in the calculation group, click calculation options, and then select automatic if it is not already selected.
A key change to the updated template version is that we expect outturn and future forecasts to be input on pre-recoupment basis.
The high needs benchmarking tool has been removed from the template as it was causing problems with the speed of the template. However, there is a link on the ‘cover’ tab that will take you directly to the GOV.UK page to use the tool.
3.1 Detailed overview
It is recommended that you save a copy of the management plan template locally before you start to edit. In addition, we advise you to continue to save the workbook often so that you do not lose any updates you add.
The guidance has been composed with deliberate repetition between tabs. This is intended so that you can jump from section to section within the template, dependent on your role and responsibility. Tabs are connected and you are only required to add data once, which then pulls through to other cells within the template.
The template is made up of several individual tabs along the bottom of the screen, which are colour coded depending on type:
Tab type | Colour | User input |
Summary | White | Some user narrative and data input |
Introduction | Grey | No user input |
Narrative | Light green | User narrative input |
Placement type | Red | User data input |
Within each tab, sections are coloured to represent the following:
Cell | Colour | Editable or not editable | Requirement |
User input cells | Blue | Editable | You’ll need to enter data |
Pre-populated cells | Yellow | Not editable, these are pre-populated | No requirement |
User input cells | Blue | Editable | You’ll need to enter outturn data for 2021 to 2022 |
Calculation cells | Purple | Not editable | These cells have automatic calculation |
To note: we have designed the template so that if you wish to provide any further information on any of the tabs, for example, links to further supporting information or evidence, there is blank space to do so.
The option to include additional information is in response to user research. However, we would not expect to see documents inserted in lieu of appropriate narrative being provided on the template.
Additional documents should only be added to evidence decisions being taken or statements being made.
The free text boxes within the narrative tabs on the template should provide a brief commentary of a maximum of 2 paragraphs, summarising your plans.
4. Cover tab
The ‘cover’ tab is a narrative tab which requires some user input.
It is important that you update the blue cells to show who last updated the management plan template and when.
Row number | User input instructions |
7 | Drop-down menu to select the relevant local authority name |
10 | Cell ‘D’ is a user input cell to input the date the management plan was last modified |
11 | Cell ‘D’ – intended for internal use for local authority version control |
4.1 Local authority change log
These boxes are for internal use within the local authority to record version history as and when amendments to the management plan are made.
We encourage you to update your plan regularly throughout the year to reflect the most recent forecast position and view this as an on-going live document.
We expect all management plan template users to keep this change log updated throughout the year, on a termly basis and in line with presenting to schools forum meetings.
5. Management plan introduction tab
The management plan introduction tab provides information on the purpose of completing a management plan and a glossary of terminology used throughout the management plan template. This tab does not require any user input.
The template contents section provides hyperlinks which enable speedy navigation through the template. Each tab has a link in cell ‘A1’ to take you back to the table contents.
The ‘data’ section provides details of all published data we have pre-populated throughout the template and hyperlinks to these data sources.
The ‘updates to the management plan template’ section provides a history of changes made to the template for each version.
6. Executive summary tab
The executive summary tab provides a high-level overview of the current financial situation and comprises areas where data is automatically pulled through, and areas where user narrative input is required.
This tab has been added to provide a summary of end of year positions, headline savings and pressures. You may wish to build your own summary which is better suited to your specific stakeholders’ needs.
6.1 Summary of end of year positions
The tables within this section contain pre-populated data which pulls through from the financial tab.
6.2 Headline mitigations/savings
This table requires user input and should have no more than 10 key savings listed, along with their actual or forecast financial cost savings. The adjacent table allows for details of numbers of education, health and care plans (EHCPs).
To have an audit trail to the figures in the template, please provide narrative as to where the mitigation/saving impacts in the area provided to the right of the table labelled ‘not for publication, audit trail (link to other tabs)’ at W28. For example, an inclusion strategy/saving may have planned saving of £x in top ups for resource units in maintained schools and reduction of £y in non-maintained independent schools.
6.3 Headline pressures
This table requires user input and should have no more than 10 key pressures listed, along with their actual or forecast financial costs. The adjacent table allows for details of numbers of EHCPs.
To have an audit trail to the figures in the template, please provide narrative as to where the mitigation/saving impacts in the area provided to the right of the table labelled ‘Not for publication, audit trail (link to other tabs)’ at W46. For example, an inclusion strategy/saving may have planned to save £x in top ups for resource units in maintained schools and reduction of £y in non-maintained independent schools.
6.4 Total number of children and young people supported by the high needs block (with estimated future projections)
This table pulls together data from all the placements tabs to provide a total number of children and young people that are supported by the high needs block (with or without an EHCP), with percentage increase year on year.
6.5 Number of children and young people supported by all provisions (with estimated future projections)
This table pulls together data from all the placements tabs to provide a total number of children and young people with EHCPs, broken down by primary need, that are supported by all provisions, with percentage increase year on year.
7. Summary: financial/children and young people narrative tab
The summary: financial/children and young people narrative tab comprises 3 separate free text boxes which requires user narrative input and should provide a high-level summary of the proposed strategies to manage current pressures.
Please add comments and narrative within the blank free text boxes.
7.1 Financial plan narrative
This narrative should be no more than one concise paragraph which provides a high-level summary of proposed strategies for managing the pressures on the DSG budget.
Please do not refer to further documentation.
This free text box should provide a short narrative detailing how you are managing pressures on the DSG and your strategy for doing so. When completing this box, consideration should be given to:
- how pressures will be prioritised to be addressed
- an assessment of how the management plan addresses these pressures
- proposals put in to place to help alleviate these pressures
7.2 High needs trends
Narrative provided in both ‘high needs trends’ and ‘outcomes’ free text boxes should be no more than one concise paragraph which provides a high-level summary of the strategies for managing the funding of children and young people from the high needs block and how the management plan proposals will ensure positive outcomes for children and young people.
Please do not refer to further documentation.
This free text box should provide a short review of high needs trends and the strategy proposals for managing the number of children and young people receiving individual funding from the high needs block. When completing this section, consideration should be given to the following:
- managing demand, top ups and alternative provision (AP) within the local authority
- measures to ensure these issues are being addressed
- how the management plan aligns with the SEND strategic plan alongside the local authorities priorities
7.3 Outcomes
This free text box should provide a brief description of outcomes, for example:
- greater support for early intervention
- improvements in the capacity of mainstream schools to meet needs without the need for EHCPs
- opportunities to attend schools closer to home
Where proposals may pose a risk to outcomes, this section should briefly describe what is being done to mitigate this risk.
8. Financial summary tab
The ‘financial summary’ tab requires some user narrative and data input.
8.1 Summary of end of year positions
This summary table provides end of year key figures for financial years 2018 to 2019 through to 2026 to 2027. The table is made up of calculation cells which pull through DSG, and user input data taken from the ‘Financial plan per funding block’ table.
The ‘savings forecast’ row (row 10) shows the difference between the unmitigated (forecast prior to accounting for any cost reduction and/or invest to save measures in place) and the mitigated (forecast after accounting for the cost reductions and/or invest to save measures in place) budgets.
It’s important to note that the ‘savings forecast’ row provides a summary of just the savings position and does not include, for example, additional income or block transfers.
8.2 Financial plan per funding block
In relation to the DSG: conditions of grant 2022 to 2023 any local authority required to provide information to the department will be expected to complete this level of financial detail, as laid out in this table and share this with schools forum and other stakeholders.
This table enables you to input the overall DSG position (pre-recoupment total) financial data for both actual and forecast spend. Actual spend will be 2018 to 2019 financial year through to 2021 to 2022 financial year. Forecast spend will be 2022 to 2023 financial year, going up to and including 2026 to 2027 financial year (if you wish to forecast this far). We expect your actual spend to match the section 251 outturn return data.
Supporting narrative for any data discrepancies can be included in the additional comments table to the right-hand side of this tab (column R).
All data input in the ‘overall DSG position (pre-recoupment total)’ table should match the budget on which you are reporting and should reconcile with the latest published DSG allocations.
All expenditure should be input as a positive figure and all income should be input as a negative figure. This will show a surplus as a negative and a deficit as a positive figure.
When completing the ‘overall DSG position (pre-recoupment total)’ table, users should note the following:
‘Mitigated forecast’: forecast after accounting for the cost reduction and/or invest to save measures in place. This is gross funding, and you must ensure that you include recoupment amounts in your expenditure.
‘Unmitigated forecast’: forecast prior to accounting for any cost reduction and/or invest to save measures in place; a ‘do nothing’ forecast. This is gross funding, and you must ensure that you include recoupment amounts in your expenditure.
To note: income should reconcile to the latest DSG allocation announcement for 2022 to 2023 with a clear assumption for any in year early years adjustments (the adjustment based on January 2022 census).
Row number and column | Row description | User input instructions |
14 F | Date outturn last updated | Populate this cell with the date the outturn position is updated |
Expenditure (positive figures)
The cells within this section for each funding block should be input as positive figures.
Row number and column | Row description | User input instructions |
18 to 22 (excluding 21) C to F |
Schools block
Central school services block Early years block Planned spend from DSG reserves |
Actual spend for 2018 to 2019 financial year
Actual spend for 2019 to 2020 financial year Actual spend for 2020 to 2021 financial year Actual spend for 2021 to 2022 financial year |
21 C to F |
High needs block | To note: row 21 requires no user input. This is a calculation row which pulls though pre-populated total expenditure data for each placement type in the high needs block – historic and planned spend as per S251 lines table.
This row is the sum of rows: 83 + 88 + 93 + 98 + 103 + 108 + 113 + 118 = row 21 |
18 to 22 G to P |
Schools block
Central school services block Early years block Planned spend from DSG reserves |
Forecast spend for 2022 to 2023 financial year and going up to and including 2026 to 2027 financial year (if you wish to forecast this far)
To note: row 21 requires no user input. This is a calculation row which pulls though pre-populated total expenditure data from the high needs block – historic and planned spend as per S251 lines table. This row is the sum of rows: To note: The unmitigated forecast for the schools block and central schools services block are calculated cells based on user input from the mitigated budget. |
23 C to P |
Total expenditure | This is a calculation row which is the sum of rows 18 to 22 for each column C to P. |
DSG income (negative figures)
The cells within this section should be input as negative figures and used to input estimated income before any block transfers. You should include any assumptions on additional future funding.
Please use indicative allocations if these are available. If not available, please detail assumptions made at rows 25 to 28. Supporting narrative for assumptions should be recorded in the assumptions free text box on the ‘local authority specific’ tab in the management plan template.
Row number and column | Row description | User input instructions |
25 to 28 C to F |
Schools block
Central school services block Early years block High needs block |
Actual income for 2018 to 2019 financial year
Actual income for 2019 to 2020 financial year Actual income for 2020 to 2021 financial year Actual income for 2021 to 2022 financial year |
25 to 28 G to P |
Schools block
Central school services block Early years block High needs block |
Income for 2022 to 2023 financial year and going up to 2026 to 2027 financial year (if you wish to forecast this far).
The unmitigated forecast columns are calculated cells which will show the same data as the mitigated budget data. If the management plan has pressures relating to additional pupils and students in specialist provision, we would expect the additional income through NFF basic entitlement factor to be reflected. To note: income should reconcile to the latest DSG allocation (actual or provisional), with a clear assumption for any in-year early years adjustments (the adjustment based on the January 2022 census). |
29 C to P |
Total income | This is a calculation row which is the sum of rows 25 to 28 for each column C to P. |
High needs block – other income (negative figures)
The cells within this section for each funding block should be input as negative figures and used to input any other income within the high needs block.
Clinical commissioning groups (CCG’s) contributions could include:
- the CCG’s contribution to the health component of high-cost placements that are initially paid for by the high needs block
- the CCG’s contribution to jointly funded services that are initially funded from the high needs block
Row 32: ‘other (please specify)’ is a row requested by local authorities to record any other high needs block income. Supporting narrative for this data can be input in the ‘additional comments’ table to the right-hand side of the table (column R).
Row number and column | Row description | User input instructions |
31 to 32 C to F |
CCG contribution
Other |
Actual other income you received for 2018 to 2019 financial year
Actual other income you received for 2019 to 2020 financial year Actual other income you received for 2020 to 2021 financial year Actual other income you received for 2021 to 2022 financial year |
31 to 32 G to P |
CCG contribution
Other |
Forecast of any other income you may receive for 2022 to 2023 financial year and going up to and including 2026 to 2027 financial year 9if you wish to forecast this far).
Include any narrative or assumptions made in column R ‘Additional comments’ table to the right-hand side of the ‘Financial plan per funding block’ table. |
33 C to P |
Total other income | This is a calculation row which is the sum of rows 31 to 32 for each column C to P. |
Block transfers (income/block moved to as a negative, outgoing/block moved from as positive. Should net to 0)
The cells within this section for each funding block should be used to input previously agreed block transfers for financial years 2018 to 2019, 2019 to 2020, 2020 to 2021, 2021 to 2022 and 2022 to 2023.
You should also record any proposed future years block transfers. Please note that we have not announced arrangements beyond 2022 to 2023. Therefore, you will need to have a fall-back position if what you are proposing is not allowed either in the DSG: conditions of grant or through the outcome of a disapplication request.
Supporting narrative for any proposed future years block transfers should be recorded in the ‘block movements and disapplications’ free text box on the ‘local authority specific’ tab in the template (row 40). Further guidance on block transfers can be found in the ‘Movement between blocks’ section, pages 46 to 50 of the schools revenue funding 2022 to 2023 operational guide.
Income (block moved to) should be shown as a negative figure. Outgoing block movement (block moved from) should be shown as a positive figure. The total should net to zero.
Row number and column | Row description | User input instructions |
35 to 28 C to F |
Schools block
Central school services block Early years block High needs block |
Previously agreed block transfer amount for 2018 to 2019 financial year
Previously agreed block transfer amount for 2019 to 2020 financial year Previously agreed block transfer amount for 2020 to 2021 financial year Previously agreed block transfer amount for 2021 to 2022 financial year |
35 to 38 G to P |
Schools block
Central school services block Early years block High needs block |
Agreed block transfer amounts for 2022 to 2023 financial year
Forecast block transfer amounts for 2023 to 2024 financial year and going up to and including 2026 to 2027 financial year (if you wish to forecast this far). |
39 C to P |
Total block transfers | This is a calculation row which is the sum of rows 35 to 38 for each column C to P. To note: this row should net to zero. |
In-year net position – deficit/(surplus)
The cells within this section are auto calculated and provide the overall in year net position for each funding block and require no user input. The overall in year calculation is the sum of the following rows:
Expenditure + 2. DSG income + 4. Block transfers = 5. In year net position deficit/surplus.
Row number and column | Row description | User input instructions |
41 C to P |
Schools block | No user input required.
This is a calculation cell which is the total schools block sum of: 1. Expenditure (row 18) + 2. DSG income (row 25) + 4. Block transfers (row 35) = 5. In year net position deficit/surplus (row 41) |
42 C to P |
Central schools services block | No user input required.
This is a calculation cell which is the total central school services block sum of: 1. Expenditure (row 19) + 2. DSG income (row 26) + 4. Block transfers (row 36) = 5. In year net position deficit/surplus (row 42) |
43 C to P |
Early years block | No user input required.
This is a calculation cell which is the total early years block sum of: 1. Expenditure (row 20) + 2. DSG income (row 27) + 4. Block transfers (row 37) = 5. In year net position deficit/surplus (row 43) |
44 C to P |
High needs block | No user input required.
This is a calculation cell which is the total high needs block sum of: 1. Expenditure (row 21) + 2. DSG income (row 28) + 3. High needs block other income (row 33) + 4. Block transfers (row 38) = 5. In year net position deficit/surplus (row 44) |
45 C to P |
Total net | This is a calculation row which is the sum of rows 41 to 44 for each column C to P. |
Other
The cells within this section for row 47, ‘Council contribution’ should be input as a negative figure and used to input both previously agreed transfers of funds and proposed requests to transfer funds.
Row number and column | Row description | User input instructions |
Row 47 C to P |
Council contribution (negative) | This row should be used to input both previously agreed and proposed future years transfers from your general fund account.
To note: from the 2020 to 2021 financial year all council contributions require approval from the secretary of state if the local authority had a DSG deficit at the end of the previous financial year. Further guidance on making this type of request can be found in the ‘DSG deficits and high needs safety valve funding’ section of the schools revenue funding 2022 to 2023 operational guide. The disapplication proformas can be found within the pre-16 schools funding: local authority guidance for 2022 to 2023. |
Row 48 C |
Add brought forward deficit/(surplus) (net) | This is a user input cell.
You will need to input the actual brought forward deficit/(surplus) (net) position at the end of 2018 to 2019 financial year. |
Row 48 D to P |
Add brought forward deficit/(surplus) (net) | This is a calculation cell which pulls data through from row 51 ‘planned year end position.’ |
Row 49 C to P |
Brought forward earmarked amounts in other blocks | This is a user input cell.
To note: this is an optional memorandum item and is not used in the planned year end position calculation. |
Row 51 C to P |
Planned year end position | This is a calculation cell and is the sum of:
‘Total net’ (row 45) + ‘Council contribution’ (row 47) + ‘Add brought forward deficit/(surplus) (net)’ (row 48) = ‘Planned year end position’ (row 51) |
Other spend – historic and planned spend as per S251 lines (memorandum items – this data does not feed elsewhere in the template)
Data tables within this section contain both pre-populated and user input cells.
The yellow pre-populated cells contain published data taken from the S251 outturn returns for 2018 to 2019 financial year, 2019 to 2020 financial year and 2020 to 2021 financial year.
The blue user input cells require data for the 2021 to 2022 financial year and onwards up to and including 2026 to 2027 financial year (if you wish to forecast this far).
Column | User input instructions |
C, D and E | No user input required.
These columns contain pre-populated published data which is pulling through from published S251 data. |
F to K | These columns require input of the total projected mitigated expenditure (forecast accounting for savings and invest to save measures). |
M to Q | These columns require input of the total projected unmitigated expenditure (do-nothing forecast). |
High needs block – historic and planned spend as per S251 lines (populated from data in each tab)
All data within this section is pre-populated.
The total expenditure rows for each placement type pulls through data from the ‘Total expenditure’ row, which is a sum of pre-populated and user input data on each of the placement tabs elsewhere within the template.
‘Year on year change’ cells are calculation cells and require no user input. These calculate the difference between the current year’s total and the previous year’s total.
‘Placement total % change year on year’ cells are calculation cells and require no user input. These calculate the percentage difference between the current year’s total and the previous year’s total.
9. Children and young people summary tab
The children and young people tab requires some user input.
9.1 Data tables
The data tables within the ‘children and young people’ tab contain pre-populated data from published sources and calculation cells which pull through data from the placement type tabs elsewhere in the template.
Row number and column | Data table name | Data tables information source |
10 to 14
C to K for mitigated figures M to T for percentage increase year on year for mitigated figures V to Z for unmitigated figures AB to AF for percentage increase year on year for unmitigated figures AH to AO for total number of exported children by age group |
Total number of EHCPs by age group (with estimated future projections). | This data table contains both pre-populated and calculation cells:
Columns C to F uses pre-populated data taken from the published data Special Education, health and care plans – reporting year 2021 which provides the amalgamated total figure for 2018, 2019, 2020 and 2021 Columns G to K are calculation cells which pull through data from the total numbers in the corresponding tables entered within each placement type tab elsewhere in the template Columns V to Z are user input cells Columns AH to AO are user input cells |
20 to 24
C to K for mitigated figures M to T for percentage increase year of year for mitigated figures V to Z for unmitigated figures AB to AF for percentage increase year on year for unmitigated figures |
Total number of children and young people receiving individual top ups with no EHCP by age group (with estimated future projections).
To note: for children and young people under 5 this includes those supported by the early years block (EYB) as well as the EYB as a source of top up. |
This data box contains calculation cells:
Columns C to K are calculation cells which pull through data from the total numbers in the corresponding tables entered within each placement type tab elsewhere in the template. Columns V to Z are user input cells. Columns AH to AO are user input cells. |
30 to 34
C to K for mitigated figures M to T for percentage increase year on year for mitigated figures V to Z for unmitigated figures AB to AF for percentage increase year on year for unmitigated figures AH to AO for total number of exported children supported by the high needs block with no EHCP or individual top up |
Total number of children and young people supported by the high needs block with no EHCP or individual top up (with estimated future projections). | This data box contains calculation cells:
Columns C to K are calculation cells which pull through data from the total numbers in the corresponding tables entered within each placement type tab elsewhere in the template Columns V to Z are user input cells Columns AH to AO are user input cells |
40 to 52
C to K for mitigated figures M to T for percentage increase year on year for mitigated figures V to Z for unmitigated figures AH to AO for total number of exported children by primary need |
Total number of EHCPs by primary need (with estimated future projections). | This data box contains calculation cells:
Columns C to K are calculation cells which pull through data from the total numbers in the corresponding tables entered within each placement type tab elsewhere in the template. Columns V to Z are user input cells. Columns AH to AO are user input cells. |
58 to 64
C to K for mitigated figures M to T for percentage increase year on year for mitigated figures V to Z for unmitigated figures AB to AF for percentage increase year on year for unmitigated figures AH to AO for total number of exported children by provision type |
Total number of EHCPs by provision type (with estimated future projections). | This data box contains calculation cells:
Columns C to K are calculation cells which pull through data from the total numbers in the corresponding tables entered within each placement type tab elsewhere in the template. Columns V to AA are user input cells Columns AI to AP are user input cells |
The data used within ‘total number of EHCPs by age group (with estimated future projection)’ in columns C to F is the actual position for historical EHCP numbers as taken from the SEN2. These published figures can be found within the ‘download associated files’ dropdown on the EHCPs page. Future template versions will be updated as and when future published data becomes available.
The data used within ‘published census data – pre-populated total number of EHCPs by primary need’ in columns C to F is the actual position for historical EHCP numbers as taken from the school census. These published figures can be found within the ‘download associated files’ dropdown on the ‘special educational needs in England’ page. Future template versions will be updated as and when future published data becomes available.
Your forecast EHCP numbers should consider the children and young people currently receiving support as will be reported on the high needs census and projected numbers rather than an annual average.
We recognise this may not be the number used for budget planning but is an indicator of the likely pressures on the high needs block over time and should be viewed in this context.
Columns AH to AO, lines 10 to 65 is an optional table for recording numbers of children. This has been provided due to user request.
9.2 Graphs
The information displayed within the graphs is representative of the pre-populated and user input data entered in the ‘children and young people’ tab. The graphs show historic and projected years total numbers broken down by each table’s information.
10. High needs recoupment place figures tab
For outturn data and forecast data to be on the same basis, high needs recoupment is required to be added back to outturn figures. This tab has been inserted into the management plan so financial data can be entered into the relevant cells to ensure all placement tabs record pre-recoupment. Recoupment figures must match March DSG allocation amounts and local authorities DSG notes to their accounts.
11. Governance and management tab
The ‘governance and management’ tab is a narrative tab which requires user input. The tab comprises of 2 separate free text boxes to complete.
Please add comments and narrative within the blank free text boxes
11.1 Sign off and review the management plan
This text box is for all relevant contributing parties to sign off the management plan.
We expect the management plan to be signed off by the Director of Children’s Services and the S151 officer within your local authority and across other areas which have also contributed.
The management plan should be taken to your schools forum meetings and discussed by members.
11.2 Workstream log
This is an optional tool enabling you to record internal management plan workflow activity. None of the input here feeds into any other cells and can be completed or left blank at the discretion of the user.
12. Stakeholder engagement, co-production and consultation tab
The ‘stakeholder engagement, co-production and consultation’ tab requires user narrative input. It comprises 6 separate free text boxes to provide details on how you ensure engagement with your various stakeholders.
Please add comments and narrative within the blank free text boxes.
When completing these narrative boxes, consideration should be given to the impact of the engagement with your stakeholders regarding your plans. For example, recommendations for improving service planning and delivery should be made in conjunction with engagement with key stakeholders. Please provide detail of the consultation processes you have already carried out and plans for further engagement to address gaps.
This tab comprises the following stakeholder categories.
12.1 Schools forum
This free text box should detail evidence of consultation with your schools forum regarding your DSG management plans including any feedback or comments. Evidence could include minutes detailing conversations regarding planned proposals (links to this evidence may be attached within this free text box). In completing this section, you may wish to include narrative and evidence of:
- details of consultation with the schools forum regarding proposals and their views on these
- how engaged the schools forum is and plans for further engagement
12.2 Education institutions
This free text box should provide a comprehensive summary evidencing how local early years settings, schools and colleges and other providers are likely to support and implement any proposals that relate to them.
Consideration should be given as to how the local authority has engaged with different education institutions or groups, such as headteacher groups, governors, special educational needs coordinators (SENCOs) and AP representatives. In completing this section, you may wish to include narrative and evidence of:
- details of consultation with schools and the wider sector on proposals and their views on these
- how engaged local schools and the wider sector are and plans for further engagement, including their responsibilities in the management plan proposals
12.3 Parents and carers
The SEND Code of Practice states that every local authority must ensure that children and young people and their parents/carers are involved in discussions and decisions about their individual support and about local provision.
When completing this section, it is important to consider the following:
- consultations take place when proposals are at a formative stage and early enough to make a difference
- adequate time has been given to consultees to respond
- consultees have been given sufficient information about the proposals to make a response
- there is a conscientious consideration of the responses
This free text box should provide a summary of any such consultations. We welcome and encourage you to work together with your parent and carer forum before completing this template and include their feedback and suggestions in this free text box.
This template should be available to the public with key proposals presented in a format that provides evidence of dialogue between you and the parent and carer forum.
12.4 Children and young people
This free text box should provide details of how you have engaged with children and young people regarding your plans, such as the youth participation forum and how likely children and young people will support any management plan proposals that relate to them. In completing this section, you may wish to include information on:
- how far consideration is given to the views of children and young people
- plans to ensure positive engagement with the children and young people sector
As with parent and carer forums, we welcome and encourage you to work together with your children and young people or formulate plans to do so before completing this template.
This template should be available to the public, with key proposals presented in a format that encourages dialogue between you and children and young people.
12.5 Elected members (councillors, mayors)
This free text box should confirm that the management plan has been completed in conjunction with the council. You may also use this text box to provide summaries or links to relevant minutes of council meetings and agenda papers.
12.6 Health partners
This free text box should provide a comprehensive summary detailing how health partners are likely to support and implement any management plan proposals and how you have engaged with them so far. In completing this section, you may wish to include information on:
- how far consideration is given to the views of your health partners
- plans to ensure positive engagement with your health partners going forward
13. Local authority specific narrative tab
The ‘local authority specific’ tab requires user narrative input. The tab comprises 15 separate free text boxes to provide details regarding strategies and plans which relate specifically to your authority.
If you wish to provide further information of these there is space at the bottom of this tab to include links to this evidence, however it is imperative these text boxes are completed and that further evidence is to provide detail of the decisions made, rather than in lieu of completing the box.
Please add comments and narrative within the free text boxes.
The tab comprises the following local authority specific categories.
13.1 Key risks and mitigations
This free text box is to set out key risks which could have an impact on the success of your management plan and the mitigations you will put in place to manage these. You should provide an overall high-level summary of your plan; consideration should be given to both financial and service delivery risks.
It may be helpful to bullet point each risk with its own mitigation so that it is clearly shown and where a risk is identified, you are able to clearly set out the actions you will take to address these. These could be further broken down into short, medium, or long-term.
13.2 Management plan support
This free text box is for you to detail how the department and your stakeholders can provide support to help you devise and deliver an effective management plan. In completing this section, consideration should be given to:
- support from DfE and ESFA. Examples such as, sharing the initiatives other local authorities are currently using, what you would find most helpful from the local authority workshops or the provision of informative webinars
- looking at good practice within neighbouring local authorities
- support from stakeholders
- support within your authority
- how you are planning to achieve this
13.3 Overall EHCP data and projected trends
This free text box should provide a concise commentary of the key pressures (2 to 3 of the most pressing concerns) for any significant trends regarding your EHCP numbers. You should include analysis of the data you have input within the children and young people tab on the management plan template comparable with national and statistical neighbours.
13.4 Strategy and approach to workforce
This free text box should detail what you are doing to support education establishments to meet the needs of children and young people with SEN and to ensure the promotion of inclusive practice. We expect this to be a concise paragraph or bullet points to detail 2 to 3 of your most important actions. In completing this section consideration should be given to:
- assessing whether you have a skilled workforce with sufficient staff to undertake their duties, for example, the services to support mainstream schools such as specialist support teams/outreach from non-maintained special schools or independent schools
- if there is a requirement for improvement, your plans for recruitment and retention, including proposals to develop and sustain the high needs workforce (including those directly employed in delivery and administrative capacities, those indirectly employed in other organisations within the delivery chain, and your approach to retention and development)
13.5 Strategy and approach to EHCP rates
This free text box should detail how you are ensuring there is provision in place for all children and young people with different needs, including strategy proposals going forward. We expect this to be a concise paragraph or bullet points to detail 2 to 3 of your identified key strategies. In completing this section consideration should be given to:
- the quality of the places available
- the sharing of expertise and good practice across your providers
- how providers are encouraged to work together
- how robust panel experts make decisions on EHCPs
- how working in partnership with other local authorities ensures EHCPs are given out at the appropriate level
- evidence of the quality of high needs provision
- the provision in place will ensure children and young people with different needs are able to access the most suitable places for their needs
- how external placements are commissioned, the arrangements in place, including how value is measured and how it is ensured
- relationships concerning tribunal cases
- the support in place to enable children and young people to be provided for adequately in other schools and colleges
- SEN placement planning and the process for reviewing additional support above the core offer (in mainstream and independent)
13.6 Managing demand pressures
This free text box should provide details of your plans to manage demand pressures within EHCP rates, including how the threshold for EHCP numbers is assessed and the overall increase in numbers requiring support from the high needs block. This should include demand pressures within EHCP rates for the 20 to 25 cohort of young people within your authority.
In completing this section, consideration should be given to:
- the overall increase in numbers requiring support from the high needs block and the demand for places across all placement settings
- managing demand pressures at the key pressure points and how associated risks are managed alongside proposed actions
- how sufficiency strategies are used to inform placement practice and measures taken when gaps are identified
- managing cost and spend per capita and any risk associated with any actions which will be taken
- organisational arrangements in place to support the effective management of high needs resources
13.7 Sharing best practice and effective practices
This free text box should provide details on how you have been engaging with other local authorities and sharing both best practice and effective practice. In completing this section, consideration should be given to:
- sharing cost reduction strategies such as better commissioning, scrutiny and review of costs. For example, review of post-16 commissioning or review of AP providers
- comparisons of top up rates against neighbouring local authorities
- investing in local provision strategies used by neighbouring local authorities to reduce reliance on more expensive out of authority placements
- demand management strategies around key spending thresholds. For example, improving the effectiveness of moderation panels or training and support for mainstream providers to meet the needs of children and young people with SEND
- effective early intervention practices. For example, the provision of short-term preventative funding to avoid the need for EHCPs and longer term top up funding
13.8 Assumptions
This free text box should provide details of future years’ assumptions including how you have arrived at projected numbers, such as any future funding or growth assumptions or any other calculations which are not explained elsewhere within the document. When completing this section consideration should be given to:
- the formula used to arrive at the calculations and assumptions made
- why these assumptions have been made
- strategies to reduce costs
Consideration should be given to calculations made in the financial tab regarding spend, including all S251 budget and outturn return lines, numbers of children and young people for future years detailed in each placement type tab and how any population growth may affect these numbers.
13.9 Block movement and disapplications
This free text box should detail plans for proposed block movements and disapplications for future years as detailed on the financial tab.
When completing this section consideration should be given to how these will fit into your overall strategies and ensure that assumptions are as transparent and realistic as possible.
Further guidance on block transfers and disapplications can be found in the ‘movement between blocks’ section of the schools revenue funding 2022 to 2023 operational guide alongside the disapplication proformas.
13.10 Population
This free text box should detail your assumptions regarding population growth within the local authority and how these calculations have been made. When completing this section consideration should be given to:
- the formula used to arrive at the population forecast
- why these assumptions have been made
13.11 Governance and commissioning arrangements with CCGs
This free text box should detail your approach to jointly commissioning services for children and young people with SEND, including how you are using these services and will continue to strengthen these arrangements going forward. In completing this section, consideration should be given to:
- how senior leaders across the local authority and CCGs work closely together to plan, commission and deliver services for children and young people with SEND
- ensuring there is a robust governance structure in place to embed and support a joint working relationship, for example, it may be appropriate to create an improvement board
- how a strong vision cutting across both the local authority and CCG on delivering services for children and young people is ensured, including the effective use of funding
13.12 Capital
This free text box should be used to explain your plans regarding capital funding. In completing this section, consideration should be given to:
- priorities with regards to capital funding and any challenges that you may be currently facing (such as, any free schools planned locally, plans to develop units in mainstream, reshape of the local offer)
- high-level details on any short, medium and long-term milestones or planned projects
- how you expect planned capital investment to support the wider strategy
- contingency plans if primary plans are delayed or rejected and the impact this might have on any associated pressures or savings
13.13 Early years
This free text box should detail any increases in SEND within the early years block and to describe key strategies in supporting early years and how any issues will be addressed. In completing this section, consideration should be given to:
- key strategies in providing support early to prevent needs from escalating
- the impact of the SEN inclusion fund being retained centrally
- services that are funded from centrally retained early years funding such as early years speech and language therapy services
13.14 Special educational needs (SEN) transport costs
This free text box should provide a year-by-year breakdown of your SEN transport costs, including any breakdown of costs charged to the DSG.
Further guidance on SEN transport costs can be found within schedule 2 Regulations 6 and 8 part 1 (historic commitments, paragraphs 2d and 3).
13.15 SEN other costs
This free text box should provide a summary of your other costs charged to the high needs block of the DSG.
14. Placement type narrative tab
Please add comments and narrative within the blank free text boxes
The ‘placement type narrative’ tab requires user narrative input. There are links at the top of this tab which when clicked enable you to be quickly directed to the relevant placement type section within it.
The placement types are as follows:
- mainstream (mainstream schools or academies placements)
- resourced or SEN units (resourced provision or SEN units placements)
- special schools (maintained special schools or special academies placements)
- NMSS or independent (non-maintained special schools or independent
(NMSS or independent) placements) - hospital schools or AP (hospital schools or alternative provision (AP) placements)
- post-16 and FE (post-16 and further education (FE) placements)
- health, social care (health, social care, therapy services and care provision)
- other (other placements or direct payments and any additional expenditure within the S251 which is funded via the high needs block)
Each placement type has 3 separate free text boxes to input narrative. When including a summary of Post-16 placements, consideration should be given to the following:
- post-16 and FE placement type should include young people aged 16+ who are on the roll of mainstream FE, sixth form colleges and special sixth form colleges
- for all other placement types, you should include young people aged 16+ who are on roll with an EHCP
14.1 Key pressures and issues
This free text box should describe the key pressures and issues within each placement type, including the changes in data and projected trends for the next 5 years. In this section consideration should be given to:
- details of what have been and are your current key pressures and issues including the reasons behind the changes in the data and projected trends for the next 5 years
- a brief commentary on the data, providing context or explanation for any significant changes in data and projected trends
- a list of the top 5 key pressures pinpointed for priority
14.2 Summary of strategy and approach to placement type
This free text box should provide a brief commentary of current strategies and approaches to the placement type including your proposals to invest long term to meet a wider range of needs. When completing this section strategic plans might include:
- your approach for managing the demographic demand pressures. For example, managing the growth in EHCPs, managing demand in special schools, AP and out of authority placements
- measures to support mainstream schools in meeting the SEN of a wider range of pupils. For example, through workforce training or clear routes to access specialist expertise
- identification of who currently delivers AP (local authority-maintained school, or a pupil referral unit, academies, independent or un-registered provision) and what percentage of the AP cohort are in each type of establishment
- changes to the focus of existing specialist places, to cater for different or more complex needs
- the creation or expansion of specialist provision attached to mainstream schools (special units or resourced provision)
- the use of AP within mainstream schools (in-school units or resourced provision)
- identification of the need to create or expand social, emotional, mental health in schools rather than AP
- strategic engagement with specialist providers or AP in the NMSS or independent sector, to ensure places offered reflect the changing needs of children and young people. The process for places and how appropriate provision is sourced
- expansion of existing specialist places, to cater for children and young people in AP with EHCP plans
- plans for your 2022 to 2023 SEND capital allocation
14.3 Initiatives
This free text box should detail any current initiatives you are trailing in each placement type. You should include how these are going, such as:
- the reasons for choosing these initiatives
- your confidence that overall, your initiatives will be cost effective
- the value these initiatives will add
In completing this section, consideration should also be given to how you are evaluating these initiatives.
15. Health, social care, therapy services and care provision
The 3 separate free text boxes in this section should be used to detail future demand of contributions from other services for children and young people within the local authority.
15.1 Summary of the inputs made by health and social care partners and proportion of current costs
This free text box should provide a detailed summary of the inputs made by these partners and the proportion of current costs which are covered for health and social care needs of children and young people within the local authority. When completing this section, consideration should be given to:
- provision costs shared with the health authority
- the proportion of cost being met by health and proportion of cost being met by social care
- your relationship with partners and if practice could be improved, how this could be achieved
- contributions made by the health authority in both costs and in writing EHCPs for children and young people
15.2 Health and social care contributions
This free text box should provide details of what you are doing to make sure there are appropriate contributions from health and social care services to ensure the needs of children and young people are being met. When completing this section, consideration should be given to opportunities to identify health and social care contributions and compare these to statistical neighbouring local authorities.
To note: we are aware that local authorities may record this information differently.
15.3 Outline of current and future demand for therapy services
This free text box should provide a brief outline of current and future demand for therapy services and arrangements you have with health services.
When completing this section, consideration should be given to proposals to manage and meet this demand, including the authority’s input into this service.
16. Placement type tabs
The ‘placement type’ tabs detailed below provide data information for individual placement settings and require user data input:
- mainstream (mainstream schools or academies placements)
- resourced or SEN Units (resourced provision or SEN units placements)
- special schools (maintained special schools or special academies placements)
- NMSS or independent (non-maintained special schools or independent
(NMSS or independent) placements) - Hospital schools or AP (hospital schools or alternative provision (AP) placements)
- Post-16 and FE (post-16 and further education (FE) placements)
- health, social care (health, social care, therapy services and care provision)
other (other placements or direct payments and any additional expenditure within the S251 which is funded via the high needs block)
16.1 Data tables
Data tables in placement type tabs contain both pre-populated and user input cells.
Yellow cells: pre-populated cells which contain published data cannot be amended.
Blue cells: user input cells for you to input data.
Purple cells: calculation cells which cannot be amended.
White cells: require no data input.
To note:
- for post-16 and FE placement type you should include young people aged 16+ who are on-roll of mainstream FE, sixth form colleges and special sixth form colleges
- for all other placement types, you should include young people aged 16+ who are on roll with an EHCP
‘Other’ tab:
- five rows have been added in the expenditure section of the ‘other’ tab (rows 13 to 17) to enable you to record other high needs expenditure contained elsewhere within your S251. This will enable all high needs expenditure to be recorded and reconciled to funding
- rows 13 to 17, column B have been deliberately left blank to enable you to input the S251 line number and a very brief description of the high needs expenditure
- rows 13 to 17, columns C to Q enable you to record historical, outturn and predicted forecast other high needs expenditure figures
- these five rows are included within ‘total expenditure’ row 18 on the ‘other’ tab which then feed into ‘local authority specific spending total expenditure’ row 113 on the ‘financial’ tab of the template, as part of your high needs expenditure
16.2 Total projected mitigated expenditure (forecast with savings and invest to save measures) data table
This data table contains both pre-populated and user input cells. The yellow pre-populated cells contain published data which has been taken from:
Row number and column | Data table name | Data table information source |
Starting from 9 up to 25 (due to variation on each placement type tab) C to E |
Published outturn date – prepopulated | Columns C to E use pre-populated data taken from the S251 outturn returns for 2018 to 2019 financial year, 2019 to 2020 financial year and 2020 to 2021 financial year.
To note: columns C to E on ‘Other’ tab include 5 additional rows (rows 13 to 17) to enable you to record other high needs historical expenditure contained elsewhere within your S251. These are blue cells and will require user input. |
Starting from 9 to 25 (due to variation on each placement type tab) F to K |
Total projected mitigated expenditure (forecast with savings and invest to save measures) | Columns F to K require user input. You will need to input predicted forecast budget data going up to and including 2026 to 2027 financial year (if you wish to forecast this far) which shows the cost reductions if the measures in the management plan are implemented. Note, column F will be actual spend 2021 to 2022. To note: columns F to K on ‘Other’ tab include 5 additional rows (rows 13 to 17) to enable you to record other high needs predicted forecast expenditure contained elsewhere within your S251. These are blue cells and will require user input. |
16.3 Total projected unmitigated expenditure (forecast based on current trends without mitigating actions) data table
This data table contains blue cells which are user input cells for you to input total projected unmitigated expenditure (forecast based on current trends without mitigating actions) up to a 5-year forecast period.
Row number and column | Data table name | Data table information source |
9 to 25 (due to variation on each placement type tab) M to Q |
Total projected unmitigated expenditure (forecast based on current trends without mitigating actions) | Columns M to Q require user input. You will need to input predicted forecast budget data going up to and including 2026 to 2027 financial year (if you wish to forecast this far) which shows no cost reduction and/or invest to save measures in place and therefore will be reporting a ‘do nothing’ forecast. To note: columns M to Q on ‘Other’ tab include 5 additional rows (rows 13 to 17) to enable you to record other high needs predicted forecast expenditure contained elsewhere within your S251. These are blue cells and will require user input. |
16.4 EHCP and children and young people data tables
These 4 data tables contain user input cells for you to input both historic and estimated future projections of children and young people with or without an EHCP who are supported within the high needs block. These data tables are included in every placement type tab apart from ‘Health, Social Care’ and the data entered in these tables will pull through to the ‘children and young people’ tab elsewhere in the template.
The tables adjacent contain calculation cells and show the percentage increase year on year for the figures input into each of the 4 data tables.
16.5 Graphs
The information displayed within the graphs is representative of the data on each tab. These show calculated cells which combine pre-populated and user input data.