Overview
This page has the details of the Funding dashboard calculations. Navigate to the sections linked below to see the relevant calculation details.
-
Headline
- Page filters
- Monthly values
- Programme Funding
- Learning Support
- Math & English Programme Funding
- Additional Payments for Providers
- Additional Payments for Employers
- Advanced Loans Bursary Funding
- Achievement payment
- Projected Achievement
- Balancing payment
- Uplift payments
- YTD
- Year Total
-
Year to Date
- Page filters
- YTD Summaries
- Potential outcome payments for live learners past planned end date
- Total YTD
- Monthly funding values
-
Funding Data
- Page filters
- On programme funding
- Total YTD
- Potential outcome payments for live learners past planned end date
- Total funding by month
- Page filters
- Total learners including leavers
- Count of aims from total learners
- Number of live learners
- Number of live aims from live learners
- Number of live aims excluded from batch
- Count of live learners unfunded / past end
- Number on learning break
- Live learners with aim type 1
- Live without open aim type 1
-
Funding Detail
- Page filters
- Claim component breakdown by month (current and next three months)
- Current Month
- Funding revenue by month
-
PMR/TNP Report
- Page filters
- TNP total this month
- PMR total this month
- TNP total last month
- PMR total last month
-
Missing Aims, Weighting & Errors
- Page filters
- Data filters
- ILRAims
- Funding
- Episodes
Calculations and page filters
Page filters (across all pages)
Users fullname does not contain “test” or “Do not use”
User is a type “user”
AimDuration is greater than 0
EpisodeStatus is not Unknown or Blank
ULN is not 9999999999
A new Subscription status filter that has been add to all pages. The new filter will allow users to add learners that have a subscription status of Cancelled or Expired to be displayed within the dashboard, by default they are excluded.
Headline
Page filters
No additional filters.
Monthly values
Programme Funding
- Monthly on programme payment - OPP (In Month Programme Funding/In Month OPP/FundingInMonth)
- Funding model is 36 (Apprenticeship)
- Aim duration at least 1 day.
- The aim type is 1.
- On programme in the month
- Achieved in month.
OR - Finished on last day of month.
OR - In learning in month.
- Achieved in month.
- 80% * Post code weighting * Total negotiated price (TNP1 per month value)
ADDED TO - End point assessment price (TNP2 per month value)
- If there has been a change in employer then the residual monthly values (TNP3 & TNP4) replace TNP1 & TNP2 values from the date the change happened.
- Monthly Trainee/Study programme (In Month Programme Funding/In Month Trainee StudyP/FundinginMonth_nonApp)
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- Traineeship 16-19 in month
- Funding model is 25 and Programme Type is 24 (16-19 Traineeship)
- Aim name does not contain English or Mathematics and Functional Skills or GCSE
- Learner is in learning or has completed and passed their qualifying period.
- Provider DfE weighting * Traineeship 16-18 funding amount * Month duration
OR
- Traineeship 19-24 in month
- Funding model is 35 and Programme Type is 24 (19-24 Traineeship)
- Aim name does not contain English or Mathematics and Functional Skills or GCSE
- 80% * Traineeship 19-24 funding amount * Month duration
OR
- Study programme 16-19 in month
- Funding model is 25, Programme Type is empty and Source of Funding is 107 (16-19 Study Programme)
- Aim name does not contain English or Mathematics and Functional Skills or GCSE
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- Learner is in learning or has completed and passed their qualifying period.
- 80% * Provider DfE weighting * Study Programme 16-19 funding amount * Month duration
OR
- Study programme 19-24 in month
- Funding model is 25, Programme Type is empty and Source of Funding is 105 (19-24 Study Programme)
- Aim name does not contain English or Mathematics and Functional Skills or GCSE
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- 80% * Provider DfE weighting * Study Programme 19-24 funding amount * Month duration
ADD
- Functional skills funding in month
- Funding model is 25, Programme Type is empty and Source of Funding is 105 (19-24 Study Programme) or Funding model is 35 and Programme Type is 24 (19-24 Traineeship)
- Aim name contains English or Mathematics and Functional Skills or GCSE
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- 80% * Weighted Aim funding value * Month duration
- Monthly AEB (In Month Programme Funding/In Month AEB/Adult Skills inMonth)
- Funding model is 35 and Programme Type is not 24 (Adult Skills)
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- 80% * Adult skills funding amount * Month duration.
Learning Support
- ALS funding amount as provided by UK Government (In Month LSA/ALS_payment)
Math & English Programme Funding
- English funding in month (In Month Maths & English Programme Funding/In Month English/Eng_FundinginMonth)
- Aim name contains English and Functional Skills or GCSE
- Funding model is 36 (Apprenticeship)
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- Planned end date is after Start date.
- Functional skills funding amount as provided by UK Government divided by number of months between start date and planned end date.
- Maths funding in month (In Month Maths & English Programme Funding/In Month Maths/Mth_FundinginMonth)
- Aim name contains Mathematics and Functional Skills or GCSE
- Funding model is 36 (Apprenticeship)
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- Planned end date is after Start date.
- Functional skills funding amount as provided by UK Government divided by number of months between start date and planned end date.
- Functional skills in month -Trainee/Study programme (In Month Maths & English Programme Funding/In Month Func Skills (Trainee/StudyP)/FS_inMonth_nonApp)
- Funding model is 35 and Programme Type is 24 (19-24 Traineeship) or
- Funding model is 25, Programme Type is empty and Source of Funding is 105 (19-24 Study Programme)
- Aim name contains English or Mathematics and Functional Skills or GCSE
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- 80% * Weighted Aim funding value * Month duration
Additional Payments for Providers
- In Month 16-18 Provider Incentive/FundingDates
- It is month 4 or if duration is 12 months then month 12 else month 13.
- A Standard
- Aim type is 1.
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- Age at start of academic year is 18 or less.
- 50 % * Incentive payment.
Additional Payments for Employers
16 to 18 employer incentive (£1,000 total)
Applies where the apprentice is aged 18 or under at the start of the apprenticeship standard.
Paid in two instalments of 50% each.
The first instalment is paid at day 90 of the apprenticeship.
The second instalment is paid at day 365, or at day 242 if the standard's published typical duration to gateway is under 12 months, or the apprenticeship is a foundation apprenticeship.
Each instalment is only paid while the apprentice is still on the apprenticeship at its payment date.
If the standard's published typical duration to gateway is 12 months or more and the apprentice completes before day 365, the second instalment is not paid. Only the first instalment applies.
Foundation apprenticeship employer incentive
Applies to foundation apprenticeships with a start date on or after 1 August 2025.
Paid in three instalments: £667 at day 90, £667 at day 242, and a £666 progression payment.
The progression payment is only paid where the apprentice completes the foundation apprenticeship, starts a new (non-foundation) apprenticeship with the same employer within 6 months of completion, and is still on that new apprenticeship 90 days after it starts.
Each of the first two instalments is only paid while the apprentice is still on the foundation apprenticeship at its payment date.
Where a programme is not a foundation apprenticeship, the standard two-instalment employer incentive above continues to apply.
£2,000 hiring payment for non-levy employers
Applies to apprenticeships with a practical period start date on or after 1 October 2026, where the employer does not pay the levy.
Applies where the apprentice is aged 16 to 24 at the start of their apprenticeship training, and has not been employed by that employer for more than 90 days before their practical period start date.
Paid in two instalments of £1,000 each.
The first instalment is paid at day 90 from the apprentice's learning start date.
The second instalment is paid at day 365, or at day 242 if the standard's published typical duration to gateway is under 12 months, or the apprenticeship is a foundation apprenticeship.
Where the standard's published typical duration to gateway is 12 months or more and the apprentice completes before day 365, the second instalment is not shown as payable.
Shown on the funding dashboard as a predicted, advisory figure only. The payment is claimed by the employer through the Apprenticeship Service, and is not paid through Aptem.
Clearly labelled on the dashboard as payable to the employer, not the provider.
Advanced Loans Bursary Funding
- In Month ADL/FundingDates
- Funding Model is 99
- Programme type is blank.
- ADL is 1
- Weighted Aim funding value * Postcode weighting * SFA area cost factor for the delivery postcode / prior learning funding adjustment % / number of instalments
Achievement payment
- In Month outcome/FundingDates
- Achievement date, if not available uses actual end date, is in this month.
- Learner outcome is achieved.
- 20% of Aim value
Projected Achievement
- In Month projected outcome/FundingDates
- Actual end date is empty.
- Planned end is after today and before end the month.
- 20% of Aim value.
Balancing payment
- In Month Balancing payment/FundingDates
- Achievement date, if not available uses actual end date, is in this month.
- Learner outcome is achieved.
- Actual end date is before planned end date.
- Monthly amount * number of months remaining.
Uplift payments
- In Month 16-18 uplift/FundingDates
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- Aim type is 1.
- Frameworks only.
- Age at start of academic year is 18 or less.
- 20% of
- Funding model is 36 (Apprenticeship)
- Aim duration at least 1 day.
- The aim type is 1.
- On programme in the month
- Achieved in month.
OR - Finished on last day of month.
OR - In learning in month.
- Achieved in month.
- 80% * Post code weighting * Total negotiated price (TNP1 per month value)
ADDED TO - End point assessment price (TNP2 per month value)
- If there has been a change in employer then the residual monthly values (TNP3 & TNP4) replace TNP1 & TNP2 values from the date the change happened.
YTD
- Sum of monthly payments by funding line up to the current month.
Year Total
- Sum of all monthly payments by funding line for the current academic year.
Year to Date
Page filters
- Category is not Other Non-DfE funding and is not Non Funded
- flg_current_acytd is 1
YTD Summaries
- YTD Total = Sum of monthly payments up to the current month
- YTD OPP (app) = Monthly on programme payment
- YTD Maths (app) = Maths funding in month
- YTD English (app) = English funding in month
- YTD LSA (app) = ALS funding amount as provided by UK Government
- YTD 16-18 Framework uplift = Uplift payments
- YTD 16-18 employer incentive (std) = Additional Payments for Employers
- YTD 16-18 provider incentive (std) = Additional Payments for Providers
- YTD Outcome (app) = Achievement payment
- YTD projected outcome (app) = Projected Achievement
- YTD trainee / study programme = Monthly Trainee/Study programme
- YTD func skill (trainee / study programme) = Functional skills in month -Trainee/Study programme
- YTD AEB skills = Monthly AEB
- YTD ADL (app) = Advanced Loans Bursary Funding
- YTD balancing payments = Balancing payment
Potential outcome payments for live learners past planned end date
- Learner has no actual end date.
- Planned end date is on or before today and before end the month.
- Category not 16-19 Traineeship.
- 20% of Aim value.
Total YTD
- Sum of monthly payments up to the current month.
Monthly funding values
- Headline monthly values in graphical form, showing each funding line.
Funding Data
Page filters
No additional filters.
On programme funding
- Count learners with funding.
- Learner has achieved in the month or finished on the last day of the month or is still in learning.
- Planned end date is equal to or after the end of the month.
- Start date is equal to or after the end of the month.
- Current month
- Sum of monthly payments for the current month.
- Next month
- Sum of monthly payments for the next month.
Total YTD
- Sum of monthly payments up to the current month.
Potential outcome payments for live learners past planned end date
- Learner has no actual end date.
- Planned end date is on or before today and before end the month.
- Category not 16-19 Traineeship.
- 20% of Aim value.
Total learners including leavers
- Count of distinct learners from ILRAims OData feed where
- Aim is not excluded from batch
- ILR status is not blank, excluded or unknown
Count of aims from total learners
- Count of the Id from ILRAims OData feed
Number of live learners
- Count of distinct learners from ILRAims OData feed where
- Aim is not excluded from batch
- ILR status is not blank, excluded or unknown
- Actual end date is blank
Number of live aims from live learners
- Count of the Id from ILRAims OData feed where
- Aim is not excluded from batch
- ILR status is not blank, excluded or unknown
- Aim status is 1
Number of live aims excluded from batch
- Count of the Id from ILRAims OData feed where
- Aim is excluded from batch
- Aim status is 1
Count of live learners unfunded / past end
- Count of distinct learners from ILRAims OData feed where
- Aim is not excluded from batch
- ILR status is not blank, excluded or unknown
- Actual end date is blank
- Planned end is on or before today
Number on learning break
- Count of distinct learners from ILRAims OData feed where:
- Aim is not excluded from batch
- ILR status is not blank, excluded or unknown
- Aim with the latest start date, for the learner, has a status 6
Live learners with aim type 1
- Count of distinct learners from ILRAims OData feed
- No additional filters (only the page filters are applied)
Live without open aim type 1
- The difference between
- Count of distinct learners from ILRAims OData feed where
- Aim is not excluded from batch
- ILR status is not blank, excluded or unknown
- Actual end date is blank
- Aim type = 1
AND
- Count of distinct learners from ILRAims OData feed where
- Aim is not excluded from batch
- ILR status is not blank, excluded or unknown
- Actual end date is blank
- Count of distinct learners from ILRAims OData feed where
Total funding by month
- Headline monthly values in graphical form, showing total only.
Funding Detail
Page filters
Category is not Other Non-ESFA Funding and is not Non Funded
Claim component breakdown by month (current and next three months)
- Graph showing the monthly payments by funding line over 4 months.
Current Month
- Total amount for all funding lines in the current month.
Funding revenue by month
- No additional calculations. Breaks down the monthly payments for the current academic year by funding line per standard, can be drilled down to learner.
PMR/TNP report
Page filters
- Category is not Other Non-DfE funding and is not Non Funded
- Learner’s ILR status in not “Unknown” or “Excluded”
- Aim is not excluded from batch
TNP total this month
- Sum of Amount from ApprenticeshipFinancialRecords OData feed where:
- Aim is not excluded from batch.
- ILR status is not excluded or unknown.
- User's full name does not contain “test” or “Do not use”.
- Learner’s ULN is not blank or “9999999999”.
- Type = TNP.
- Month of date is in the month of today.
PMR total this month
- Sum of Amount from ApprenticeshipFinancialRecords OData feed where:
- Aim is not excluded from batch.
- ILR status is not excluded or unknown.
- User's full name does not contain “test” or “Do not use”.
- Learner’s ULN is not blank or “9999999999”.
- Type = PMR.
- Month of date is in the month of today.
TNP total last month
- Sum of Amount from ApprenticeshipFinancialRecords OData feed where:
- Aim is not excluded from batch.
- ILR status is not excluded or unknown.
- User's full name does not contain “test” or “Do not use”.
- Learner’s ULN is not blank or “9999999999”.
- Type = TNP.
- Month of date is in the month before today.
PMR total last month
- Sum of Amount from ApprenticeshipFinancialRecords OData feed where:
- Aim is not excluded from batch.
- ILR status is not excluded or unknown.
- User's full name does not contain “test” or “Do not use”.
- Learner’s ULN is not blank or “9999999999”.
- Type = PMR.
- Month of date is in the month before today.
Missing aims, weighting & errors
Page filters
- Users fullname does not contain “test” or “Do not use”
- User is a type “user”
Data filters
ILRAims
Programme type is 2, 3, 20, 21, 22, 23, 24, 25 or empty
LearnerId is not null or empty
StartDate and PlannedEndDate are not null
Funding
- All funding calculations are for the current accademic year.
Episodes
- ILR status is not blank, Excluded or Unknown
- Aim is not excluded from batch
- Learner’s name does not contain “test” or “DO NOT USE”