Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Authentication
digital resources
136x Filetype XLSX File size 0.17 MB Source: www.milton-keynes.gov.uk
Sheet 1: INFORMATION
| IMPORTANT INFORMATION - PLEASE READ BEFORE COMPLETING | |
| This budget template now includes the original template, the revised template and a forecast template. | |
| If there is any difficulty setting a balanced budget please contact Schools Finance immediately | |
| Original Budget Tab - DUE TO SCHOOLS FINANCE ON 1ST MAY 2021 | |
| - | Complete in conjunction with the Budget Plan Completion Guidance |
| - | Do not submit if there are any checkboxes that are red. There will be a message in cell A5 if the check boxes need reviewing. |
| - | Schools are required to set a balanced budget. If there is any balance to carry forward, this must be identified. |
| Original Budget Workings Tab | |
| - | Use this tab to make notes on line items and calculations |
| Revised Budget Tab - DUE TO SCHOOLS FINANCE ON 1ST NOVEMBER 2021 | |
| - | Opening balances are populated from the Original Budget tab |
| - | Do not submit if there are any checkboxes that are red. There will be a message in cell A5 if the check boxes need reviewing. |
| Revised Budget Workings Tab | |
| - | Use this tab to make notes on line items and calculations |
| Variance Analysis Tab - TO BE COMPLETED WHEN POPULATING THE REVISED BUDGET | |
| - | Red cells in column G on this tab indicate an explanation of the variance between the original budget and the revised budget is required. Do not submit the file if there are any cells that remain red. |
| Forecast Template Tab | |
| - | Enter the year to date actuals in the appropriate column (eg August ytd actuals would be entered in column K. Expected spend of the remaining months can then be profiled and a forecast will be calculated in column S |
| - | Column U shows the variance between the original/revised budget and the forecast with room in column V for explanations. |
| - | This template does not have to be completed as part of the revised budget process. It is included for schools to use as part of their financial monitoring. |
| Submitting the Budget | |
| - | The final version of both original and revised budgets must be signed by both Headteacher and Chair of Governors and a scanned copy of the budget with signatures must be emailed to the Schools Finance team. We are unable to accept an unsigned budget |
| - | An excel copy of the final version must also be emailed to the Schools Finance team |
| Guidance Notes for Completing Budget Plan | ||
| Entries can be entered to two decimal places. | ||
| Income Section | ||
| Always input figures as a negative in this section. | ||
| Figures for I01 and I02 can be found on the toolkit file. All funding should be referenced to the appropriate code. Additional funding may be received through the Cash Advance, again this should be referenced to the appropriate code. | ||
| Note the change of I18 codes to include payments received relating to CV19 contingencies. Costs should be recorded under the relevant expense heading. | ||
| Any additional income over the year should be added to the appropriate remaining CFR income headings and broken down under the workings page and attached. This is invaluable when revising your budget at a later date. | ||
| Expenditure Section | ||
| Always input figures as a positive in this section. | ||
| Any expenditure, which has more than one cost included, should be added to the appropriate remaining CFR expenditure headings and broken down under the workings page and attached. This is invaluable when revising your budget at a later date. | ||
| Where the school is making a revenue contribution to a capital project, monies should be put into E30 and matched to CI04. | ||
| Dedelegated budgets for primary schools need to be included so as to gross up costs and income. The amounts to be included are shown on the dedel tab in this workbook. Please profile the whole amount in April. | ||
| Dedelegated Budgets | ||
| This year, schools are being asked to gross up their figures for the de-delegatd budget posting. The De-delegated budget tab on this file gives the figures that need to be included. 100% of the amount should be included in April. This will not affect the bottom line carry forward, it purely ensures that both the costs and associated income are included within the budget. | ||
| In April, schools should post the de-delegated journal (usually posted in January) to ensure no variances occur on the budget monitoring report. | ||
| Capital Income | ||
| Always input figures as a negative in this section. | ||
| Monies that are being used from revenue expenditure (E30) to balance capital should be put into CI04. | ||
| CI03 should contain any monies received from an external source i.e school fund etc. | ||
| Capital Expenditure | ||
| Always input figures as a positive in this section. | ||
| Balances | ||
| All balances have B/fwd (from the old year) and C/fwd (to the new year). Surplus B/fwds should be shown as a negative and deficits as a positive. Surplus C/fwds should be shown as a positive and deficits as a negative. | ||
| Revenue balances are recorded as follows: | ||
| B01 Committed Revenue Balance. Committed amounts are where a school has entered into a contract or raised a purchase order but the goods or services have not been received by 31st March. Also deficit budgets should also be included as spent money is already committed. | ||
| B02 Uncommitted Revenue Balance. These are any other revenue balances that have not been committed. Funding ear-marked for specific purposes should be shown here. | ||
| B03 Devolved Capital balances. | ||
| B05 Other capital balance which do not fall in the category of Devolved Capital. | ||
| B06 Community focused School activities only. | ||
| Brought forward balances are notified on a year end letter. | ||
| Profiling | ||
| All schools must submit a profiled budget. | ||
| Schools should look closely at the previous years spending to identify appropriate profiles. | ||
| Include teachers pay rise in September (if appropriate) | ||
| All revenue & capital income paid by the LA should be profiled in line with the cash advance schedule. | ||
| Profiles must add up correctly and balance. | ||
| Please note that ALL boxes are to be completed in order to provide a completed budget plan. | ||
| Budget Due 1st May 2021 | ORIGINAL BUDGET PLAN | SPREADSHEET CHECKS | ||||||||||||||||||
| School Name: | Select School Name Here | Financial Year: | 2021/2022 | School Code Completed | No | |||||||||||||||
| School Code: | School Name Completed | No | ||||||||||||||||||
| Your check boxes are not clear (Column U). Please correct | ORIGINAL | Apr. | May | June | July | Aug. | Sept. | Oct. | Nov. | Dec. | Jan. | Feb. | Mar. | Profile Total | Profiling is correct | Yes | ||||
| BUDGET | Capital is correct | Yes | ||||||||||||||||||
| £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | Surplus or Deficit? | Surplus | |||||
| INCOME (Input as minus figures) | Ledger Code | |||||||||||||||||||
| I01 | Funds delegated by the LEA | 4190105 | 0.00 | |||||||||||||||||
| I02 | Funding for sixth form students | 4190110 | 0.00 | |||||||||||||||||
| I03 | SEN funding and High Needs Top Up funding | 4190120 | 0.00 | |||||||||||||||||
| I05 | Pupil Premium | 4190140 | 0.00 | |||||||||||||||||
| I06 | Other government grants | 4190160 | 0.00 | |||||||||||||||||
| I07 | Other grants and payments received | 4190390 | 0.00 | |||||||||||||||||
| I08a | Income from Letting Premises | 4191900 | 0.00 | |||||||||||||||||
| I08b | Other Income from Facilities & Sevices | 4191100 | 0.00 | |||||||||||||||||
| I09 | Income from catering | 4191110 | 0.00 | |||||||||||||||||
| I10 | Receipts from supply teacher insurance claims | 4191600 | 0.00 | |||||||||||||||||
| I11 | Receipts from other insurance claims | 4191610 | 0.00 | |||||||||||||||||
| I12 | Income from contributions to visits etc. | 4190410 | 0.00 | |||||||||||||||||
| I13 | Donations and/or voluntary funds | 4190420 | 0.00 | |||||||||||||||||
| I15 | Pupil focused Extended School Funding & Grants | 4190200 | 0.00 | |||||||||||||||||
| I18a | Covid Job Retention Scheme | 4190386 | 0.00 | |||||||||||||||||
| I18b | Covid Exceptional Costs | 4190387 | 0.00 | |||||||||||||||||
| I18c | Covid Catch up Package | 4190388 | 0.00 | |||||||||||||||||
| I18d | Additional Grants for Schools | 4190380 | 0.00 | |||||||||||||||||
| I16 | Community Focused School Funding and/or Grants | 4190205 | 0.00 | |||||||||||||||||
| I17 | Community Focused School Facilities Income | 4190210 | 0.00 | |||||||||||||||||
| TOTAL INCOME | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
| EXPENDITURE | ||||||||||||||||||||
| E01 | Teaching staff | 6110000 | 0.00 | |||||||||||||||||
| E02 | Supply staff | 6110020 | 0.00 | |||||||||||||||||
| E03 | Education support staff | 6110600 | 0.00 | |||||||||||||||||
| E04 | Premises staff | 6110720 | 0.00 | |||||||||||||||||
| E05 | Administrative & clerical staff | 6110860 | 0.00 | |||||||||||||||||
| E06 | Catering staff | 6110800 | 0.00 | |||||||||||||||||
| E07 | Cost of other staff | 6110640 | 0.00 | |||||||||||||||||
| E08 | Indirect employee expenses | 6116300 | 0.00 | |||||||||||||||||
| E09 | Staff development & training | 6116200 | 0.00 | |||||||||||||||||
| E10 | Supply teacher insurance | 6116610 | 0.00 | |||||||||||||||||
| E11 | Staff related insurance | 6116600 | 0.00 | |||||||||||||||||
| E12 | Building maintenance and improvement | 6121000 | 0.00 | |||||||||||||||||
| E13 | Grounds maintenance and improvement | 6122310 | 0.00 | |||||||||||||||||
| E14 | Cleaning & caretaking | 6122110 | 0.00 | |||||||||||||||||
| E15 | Water & sewerage | 6120800 | 0.00 | |||||||||||||||||
| E16 | Energy | 6120220 | 0.00 | |||||||||||||||||
| E17 | Rates | 6120600 | 0.00 | |||||||||||||||||
| E18 | Other occupation costs | 6120400 | 0.00 | |||||||||||||||||
| E19 | Learning resources (not ICT) | 6140130 | 0.00 | |||||||||||||||||
| E20 | ICT learning resources | 6142430 | 0.00 | |||||||||||||||||
| E21 | Exam fees | 6146100 | 0.00 | |||||||||||||||||
| E22 | Administrative supplies | 6140000 | 0.00 | |||||||||||||||||
| E23 | Other insurance premiums | 6121600 | 0.00 | |||||||||||||||||
| E24 | Special facilities | 6151110 | 0.00 | |||||||||||||||||
| E25 | Catering supplies | 6140200 | 0.00 | |||||||||||||||||
| E26 | Agency supply staff | 6111000 | 0.00 | |||||||||||||||||
| E27 | Bought in professional services – curriculum | 6170100 | 0.00 | |||||||||||||||||
| E28 | Bought in professional services - other | 6170110 | 0.00 | |||||||||||||||||
| E29 | Loan interest | 6181400 | 0.00 | |||||||||||||||||
| E30 | Direct revenue financing (revenue contributions to capital - Match CI04) | 6181500 | 0.00 | |||||||||||||||||
| E31 | Community Focused School Staff | 6110610 | 0.00 | |||||||||||||||||
| E32 | Community Focused School Costs | 6122340 | 0.00 | |||||||||||||||||
| TOTAL EXPENDITURE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
| CAPITAL INCOME (Input as minus figures) | ||||||||||||||||||||
| CI01 | Capital Income | 4190170 | 0.00 | |||||||||||||||||
| CI03 | Private Income | 4190430 | 0.00 | |||||||||||||||||
| CI04 | Direct revenue financing (revenue contributions to capital - Match E30) | 6181510 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
| TOTAL CAPITAL INCOME | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
| CAPITAL EXPENDITURE | ||||||||||||||||||||
| CE01 | Acquisition of land & existing buildings | 6180210 | 0.00 | |||||||||||||||||
| CE02 | New construction, conversion, and renovation | 6180200 | 0.00 | |||||||||||||||||
| CE03 | Vehicles, plant, equipment and machinery | 6180230 | 0.00 | |||||||||||||||||
| CE04 | Information and communications technology | 6180260 | 0.00 | |||||||||||||||||
| TOTAL CAPITAL EXPENDITURE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
| BALANCES BROUGHT FORWARD (Input surpluses as minus figures) | ||||||||||||||||||||
| B01 | Committed Revenue | |||||||||||||||||||
| B02 | Uncommitted Revenue | |||||||||||||||||||
| B06 | Community Funding | |||||||||||||||||||
| TOTAL REVENUE | 0.00 | |||||||||||||||||||
| B03 | Devolved Formula Capital | |||||||||||||||||||
| B05 | Other Capital | |||||||||||||||||||
| TOTAL CAPITAL | 0.00 | |||||||||||||||||||
| TOTAL (SURPLUS)/DEFICIT BROUGHT FORWARD | 0.00 | |||||||||||||||||||
| BALANCES CARRIED FORWARD | ||||||||||||||||||||
| B01 | Committed Revenue | 0.00 | ||||||||||||||||||
| B02 | Uncommitted Revenue | 0.00 | ||||||||||||||||||
| B06 | Community Funding | 0.00 | ||||||||||||||||||
| TOTAL REVENUE | 0.00 | |||||||||||||||||||
| B03 | Devolved Formula Capital | 0.00 | ||||||||||||||||||
| B05 | Other Capital | 0.00 | ||||||||||||||||||
| TOTAL CAPITAL | 0.00 | |||||||||||||||||||
| SURPLUS BALANCE CARRIED FORWARD | 0.00 | |||||||||||||||||||
| Headteacher * | Chair of Governors / Finance Committee | |||||||||||||||||||
| Signature (1): | Signature (2): | |||||||||||||||||||
| Name: | Name: | |||||||||||||||||||
| Position: | Position: | |||||||||||||||||||
| Date Signed: | Date Signed: | |||||||||||||||||||
| The Headteacher and Chair of Governors must sign the budget before it is submitted. | ||||||||||||||||||||
| An Excel version and a signed PDF must be emailed to SchoolsFinance@milton-keynes.gov.uk by 1st May 2021 | ||||||||||||||||||||
no reviews yet
Please Login to review.
