Budget Monitoring

Posted  20th October 2020

A detailed budget plan, with several alternative scenarios based on inevitable twists and turns through the year, is essential to any school.

However, all the best laid plans become ineffective if they are not followed. Budget monitoring is the process which tracks your progress against your plan. Budget monitoring is not only good practice, but essential in any school, especially given the current financial pressures schools are facing through squeezed income and increased expenditure. There are two key components to a solid budget monitoring process:

The bulk of any school’s expenditure is staffing, so the fact it is a moving target, makes it all the more worthy of its own focus.

A payroll reconciliation should be a thorough check of expected employee costs per month to actual employee costs.

Go careful not to make some common mistakes by keeping the below in mind:

  • Always reconcile actual costs to forecast costs. DO NOT check one month’s payslips to the last – what if the last month was wrong?
  • Always reconcile the total cost to the school. DO NOT exclude on-costs. National Insurance and Superannuation variances can have a significant impact on your staffing costs.
  • Set an acceptable variance tolerance so you concentrate on the significant items first. DO NOT make this too lenient. We recommend 0.05% either way.
A proper payroll reconciliation process will identify incorrect staffing forecasts as well as incorrect payments to staff. Any pending payments or corrections identified in the pay reconciliation process should be noted and used later….. hold this thought!

When forecasting your year-end position, be sure to include all year-to-date actual income and expenditure, couple with this any known future income and committed expenditure.

A few tips when collating this information:

  • Committed expenditure for staffing should include:
    • your latest staffing projections which you know to be accurate having completed your payroll reconciliation.
    • all pending corrections, as otherwise these could be missed as they will not be in your actual expenditure. (Consider for a second, you have a 2 month back log of incremental rises, these would not be in your actual expenditure, and neither would they be in your commitments in your original budget profile – a hefty chunk of expenditure to not include in your year-end projection)!
    • Budget for future open staffing positions, have details of any contract details pencilled in, not just an amount.
  • Collate all data at a nominal code level at the very least, cost centre as well if possible.
When you come to analysing and displaying this information, there are several varying methods and schools of thought. SBS recommend a tried and tested model where we project year-end balances by nominal code and reporting code, applying calculations differently depending on the detail:
  • For staffing items project simply use actuals + commitments to project your year-end position. It is important to see an underspend if it exists, you may need it elsewhere in your budget mid-way through the year. We also recommend that you project within staffing by service term or staff group which are determined by job roles.
  • For non-staffing items project the original allocated budget, unless you know for sure that there is a saving OR your actuals + commitments exceed your allocated budget, in which case forecast this figure!
  • All budget variances exceeding 5% in either direction from your allocated budget should be justifiable and explained. This will give confidence to the Governors
The impact of not having in place a robust monthly budget monitoring process could result in the school making key decisions based on inaccurate data, potentially spending a surplus only to realise months later it never really existed. Hopefully, this piece offers you some ideas to implement or provides the reassurance that your budget monitoring process is robust.

If you want to discuss anything around budget planning and monitoring our Finance consultants are here to help on 0345 222 1551 • Option 5 or, alternatively why not book in a quick demo of SBS Budgets, click here