information about how you use ‘Get help with ESFA services’. We use this information to make the
website work as well as possible and improve government services.
You have accepted all cookies. You can change your cookie settings at any
This is a new service – your feedback will help us to improve it.
Created 04 August 2022 15:02
I've been asked by a provider to give details of the remaining potential earned cash by using the Main Occupancy report.
To calculate the remaining funding, could I use total of the column "Aim Value" minus the total of "Total earned cash"?
And to calculate the remaining achievement money to earn, can I use "Achievement element (potential or actual earned cash)" minus "Total aim achievement earned cash"?
Or are the any extra steps I should be taking?
No one has replied to this post.
04 August 2022 20:28
I'm not sure what those mean. I work for a local authority where a couple of external providers send an ILR to me, and we add this to the in house information. I then submit this to the ESFA.
If that doesn't help, can you give me some more info on what apps and AEB refers to?
04 August 2022 21:43
AEB: Adult Education Budget
Are they on your ILR or is your organisation a subcontractor?
04 August 2022 21:51 (Edited)
Thanks Kelly - it's Adult Education Budget.
The subcontractor sends in an ILR which I then add to our in house one and another subcontractor. I've downloaded reports and isolated the correct subcontractors learners within the main occupancy report. My question is then how to calculate the remaining potential funding they could get from current learners, as they don't want to go over budget.
05 August 2022 08:08
So you could calculate the way you suggested of subtracting the total earned from the Aim value. However the aim value is worked on the assumption the learner is fully funded, if any are co-funded (meaning you only receive around 50% of the full funding) that wont be accounted for in that amount. You're need to look for the value in the 'Non-public-funded contribution' column and subtract that from the unit price, this will give you the expected co-funded value
Check the Learning delivery funding and monitoring type - full or co funding indicator' column and this will tell you if they are co-funded/fully funded, 1 is for fully funded and 2 for co-funded.
Bear in mind, this all only works if their planned end is in 21/22. If they are due to complete in 22/23 you're need to work out the spilt across years
05 August 2022 08:29