Audio lesson · 8 minutes
Reconciling funding month by month
How to compare what the return earned against what you expected, explain the movement, and stop year-end surprises before they form.
The audio for this lesson has not been rendered yet. The approved script and the full transcript are below, and they are the content: the audio is a derived format. We publish the words rather than a player that does not work.
Chapters
- Why earnings move
- The monthly routine
Transcript
The complete text of the lesson. It is indexable, searchable and readable on its own, so nobody has to listen to get the content.
Introduction
Reconciling funding month by month. How to compare what the return earned against what you expected, explain the movement, and stop year-end surprises before they form.
Why earnings move
The common causes are few: withdrawals recorded this month that remove earnings from earlier ones, records rejected at validation, monitoring codes changed, band changes from amended hours, and genuine delivery change. Rule them out in that order. The first two explain most movements.
The monthly routine
Writing the explanation down is the step that converts the routine from a task into a control. It also means the same question next month takes minutes rather than hours. Where the movement cannot be explained, that is the finding. An unexplained movement is a data problem that has not been located yet.
Turning reconciliation into a forecast
Forecasting from earnings to date plus planned delivery is straightforward arithmetic. What makes it useful or useless is whether the earnings to date are real. A forecast built on a return containing learners who have left forecasts the error too, and it does so confidently. That is why the data quality checks and the forecast belong to the same routine rather than to different teams. The useful discipline is to state the forecast with its assumptions: what has been delivered, what is planned, and what is known to be uncertain in the data. A forecast presented as a single number invites false confidence. For streams that reconcile, the forecast has a decision attached: if delivery is tracking below allocation, what is being done, and by when does it have to start to make a difference.
Read it instead
Reconciling funding month by monthThe written module carries the same content at three depths, with the worked examples, the pitfalls and the sources.
Sources
These are the official documents this page rests on. Where a figure, a deadline or an exact rule matters, the document is the authority and this page is the explanation.
Content reused from GOV.UK is Crown copyright, used under the Open Government Licence. FEFunding is not endorsed by the Department for Education.