{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["CRYSTAL_PERSIST","Sample (FM81)","Test paper - Adult Skills","D2 FM81","D3 FM25_Adult","Test paper - Apprenticeships","Test paper - Loans","Test paper - 16-19","B3_Temp","B3_Summary","B1 (Detail)","B1 (Summary)","FM38 & FM35 (ASF) references","FM81 (Standards) references","FM36 (Apps) references","Loans references","FM25 (16 to 19) guidance","DVs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":126,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CRYSTAL_PERSIST","index":0,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<CrystalAddin Version=\"1\"/>"]

{"sheet":"Sample (FM81)","index":1,"n_rows":2,"n_cols":143,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Sample: FM81 (Apprenticeship standards)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,1,null,null,null,null,null,null,2,null,null,null,null,null,null,3,null,null,null,null,null,null,4,null,null,null,null,null,null,5,null,null,null,null,null,null,6,null,null,null,null,null,null,7,null,null,null,null,null,null,8,null,null,null,null,null,null,9,null,null,null,null,null,null,10,null,null,null,null,null,null,11,null,null,null,null,null,null,12]
["Transaction no.","Learner reference number","Unique learner number ","Learner name\n(Family name & Given names)","Age at start of programme","Age at aim start","Prior level on enrolment","Funding line","Programme type ","Aim type","Aim sequence number","Learning aim reference","Learning aim title","Aim level","Apprenticeship  standard code","Restart indicator","Funding adjustment for prior learning","Other funding adjustment","Learning start date","Original learning start date","Learning planned end date","Learning actual end date","Completion status ","Outcome ","Achievement date","Withdrawal reason ","Learning support funding","Full or co-funding indicator","Eligibility for enhanced apprenticeship funding","LDM","HHS_1","HHS_2","Subcontracted or partnership UKPRN","Delivery location postcode","End point assessment organisation","Employment status on first day of learning","Employer identifier","Small employer","Total training price (TNP1)","Total assessment price (TNP2)","Total negotiated price","Total training payments (PMR1)","Total assessment payments (PMR2)","Total payments","Total employer payments reimbursed (PMR3)","TOTAL FUNDING","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Core Government contribution","16 to 18 year old apprentice incentive","Small employer incentive","Completion incentive","OPP","Balance","Learning support","Provider specified learner monitoring A","Provider specified learner monitoring B","Provider specified delivery monitoring A","Provider specified delivery monitoring B","Provider specified delivery monitoring C","Provider specified delivery monitoring D"]

{"sheet":"Test paper - Adult Skills","index":2,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Transaction no."]
["Learner reference number"]
["Learner name (Family name & Given names)"]
["Unique learner number"]
["Date of birth"]
["National Insurance number"]
["Postcode prior to enrolment"]
["Disadvantage uplift factor"]
["FM38 Funding (YTD)"]
["FM35 Funding (YTD)"]
["Test",null,null,"Issue","Critical factor",{"$f":"SUM(F12:F34)","v":0},"Test satisfied\nYes/No","Comments"]
[1,"Does evidence exist to confirm that the learner is eligible for ESFA funding?","i","Eligibility for funding","The learner satisfies the ESFA's eligibility criteria.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G12:IV12),2)=1),--($G12:IV12=\"No\"))","v":0}]
[2,"Is the programme as designed eligible for funding and is the correct funding being claimed?","i","Full/co funding and approved qualifications ","Claims for full or co funding are made in accordance with the eligibility, entitlement and age criteria. The learner is working towards an applicable approved qualification. ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G13:IV13),2)=1),--($G13:IV13=\"No\"))","v":0}]
[null,null,"ii","Level 3 FCFJ","Claims under the FCFJ offer are in accordance with the eligibility criteria for the age of the learner and the learner is working towards an approved qualification. ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G14:IV14),2)=1),--($G14:IV14=\"No\"))","v":0}]
[null,null,"iii","English and maths  entitlement and assessment (ASF) ","Full funding can be claimed as part of the learners legal entitlement and where the learners age and prior attainment meet the eligibility criteria. . ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G15:IV15),2)=1),--($G15:IV15=\"No\"))","v":0}]
[null,null,"iv","English and maths assessment and enrolled level (AEB)","The level on which the learner is enrolled is correctly determined by the outcome of the initial assessment.  ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G16:IV16),2)=1),--($G16:IV16=\"No\"))","v":0}]
[null,null,"v","Digital Skills ","Learners are fully funded where they meet the eligibility and age criteria, and the assessment of digital skills shows them to be below level 1. ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G17:IV17),2)=1),--($G17:IV17=\"No\"))","v":0}]
[null,null,"vi","English for speakers of other languages","There must be an assessment of need for each separate qualification to support claims for additional learning to that funded through the matrix rate.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G18:IV18),2)=1),--($G18:IV18=\"No\"))","v":0}]
[null,null,"vii","SWAP","There is a copy of the referral notification from Job Centre Plus confirming start date and times. ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G19:IV19),2)=1),--($G19:IV19=\"No\"))","v":0}]
[null,null,"viii","Delivery location","The ESFA must give permission to claim funding for provision fully delivered outside England.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G20:IV20),2)=1),--($G20:IV20=\"No\"))","v":0}]
[null,null,"ix","Work placement for 19-24 year olds eligibility & delivery","Claims for full funding are only for those learners who meet the funding criteria. The work placement is with an employer between 70-240 hours and evidence exists to show that the employer has fulfilled their obligation. ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G21:IV21),2)=1),--($G21:IV21=\"No\"))","v":0}]
[null,null,"x","Recognition of prior learning/achievement","Any prior learning is taken into account when assessing the learner and calculating the proportion of funding remaining except for exempt qualifications. ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G22:IV22),2)=1),--($G22:IV22=\"No\"))","v":0}]
[null,null,"xi","Duplication/overlap in learning","Any duplication or overlap in learning aim content (including provision funded through another source) is considered when establishing whether a learning aim can be funded and calculating the proportion of funding remaining.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G24:IV24),2)=1),--($G24:IV24=\"No\"))","v":0}]
[null,null,"xii","Breaks in learning","The funding rate, original learning start date, planned duration and funding adjustment for prior learning for a learner returning after a break have been correctly identified and recorded in the ILR, along with the restart indicator.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G25:IV25),2)=1),--($G25:IV25=\"No\"))","v":0}]
[3,"Does learner documentation meet the minimum requirements outlined in the funding rules and agree to underlying data?","i","ILR consistent with evidence pack","Funding is driven by the underlying ILR data which must agree with information confirmed by the learner in the evidence pack.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G25:IV25),2)=1),--($G25:IV25=\"No\"))","v":0}]
[null,null,"ii","Subcontracted provision","Provision delivered by a subcontractor, as recorded in the evidence pack, must be accurately reflected in the ILR.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G26:IV26),2)=1),--($G26:IV26=\"No\"))","v":0}]
[4,"Is the learner eligible for learning support funding and is there evidence of delivery of learning support?","i","Eligible for learning support","Learning support claimed through the ILR is evidenced by a record of the outcome of a thorough assessment, identifying the support the learner needs, in the evidence pack.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G27:IV27),2)=1),--($G27:IV27=\"No\"))","v":0}]
[null,null,"ii","Delivery of learning support","Learning support claimed through the ILR is evidenced by records of delivery of support to meet the learner's identified needs in the evidence pack.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G28:IV28),2)=1),--($G28:IV28=\"No\"))","v":0}]
[5,"Is the learner's programme and the learner's attendance as recorded in the ILR consistent with the underlying records?","i","Learning start date","Funding for a learning aim or programme can be claimed only from the date on which learning activity directly related to the learning aim or programme begins and can be evidenced.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G29:IV29),2)=1),--($G29:IV29=\"No\"))","v":0}]
[null,null,"ii","Learning activity","Funding claimed for the learner's continued participation in learning is confirmed by evidence of learning activity from the start date of each aim (i.e. up to the learning actual end date or to date, as applicable).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G30:IV30),2)=1),--($G30:IV30=\"No\"))","v":0}]
[6,"Where the learner has not achieved, does the learning actual end date recorded in the ILR agree with underlying records?","i","Learning actual end date","The learning actual end date recorded in the ILR reflects the last date that there is evidence of learning activity for each learning aim (or for any learning aim within an apprenticeship framework).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G31:IV31),2)=1),--($G31:IV31=\"No\"))","v":0}]
[null,null,"ii","Transfers","The learner has transferred to a different learning aim, framework or pathway and the correct learning actual end date, withdrawal reason and subsequent start date for the new learning aim, framework or pathway have been accurately recorded in the ILR.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G32:IV32),2)=1),--($G32:IV32=\"No\"))","v":0}]
[7,"Does evidence exist to confirm that the learner has achieved/completed the learning aim/framework?","i","Learning aim achievement","The achievement is correctly recorded in the ILR and is supported by evidence of achievement from the awarding organisation within three months.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G33:IV33),2)=1),--($G33:IV33=\"No\"))","v":0}]
[8,"Is there evidence that the learner is eligible for, and has evidence to support, the claim for a job outcome payment?","i","Eligible job outcome payment","Job outcome payment claimed through the ILR is for an eligible job and is supported by a learner declaration confirming that the funding conditions have been met.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G34:IV34),2)=1),--($G34:IV34=\"No\"))","v":0}]
["FM38 funding error"]
["FM35 funding error"]

{"sheet":"D2 FM81","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Transaction no."]
["Learner reference number"]
["Learner name (Family name & Given names)"]
["Unique learner number"]
["Date of birth"]
["16 to 18 apprenticeship standards funding (YTD)"]
["Adult apprenticeship standards funding (YTD)"]
["Test",null,null,"Issue","Critical factor",{"$f":"SUM(F9:F40)","v":0},"Test satisfied\nYes/No","Comments"]
[1,"Does evidence exist to confirm that the learner is eligible for ESFA funding?","i","Eligibility for funding","The learner satisfies the ESFA's eligibility criteria.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G9:IV9),2)=1),--($G9:IV9=\"No\"))","v":0}]
[2,"Are the learner and employer eligible and has the programme been correctly identified and coded?","i","Age","Apprentices must be aged 15 or over and have legally left school.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G10:IV10),2)=1),--($G10:IV10=\"No\"))","v":0}]
[null,null,"ii","Employed status","Apprentices undertaking apprenticeship standards must be employed (except those that satisfy the conditions for redundancy).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G11:IV11),2)=1),--($G11:IV11=\"No\"))","v":0}]
[null,null,"iii","Employer declaration","Employers must confirm the eligibility of their apprentices as well as their eligibility for incentive payments through a signed employer eligibility declaration.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G12:IV12),2)=1),--($G12:IV12=\"No\"))","v":0}]
[null,null,"iv","Minimum hours of employment","Apprentices are employed for at least 16 hours per week.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G13:IV13),2)=1),--($G13:IV13=\"No\"))","v":0}]
[null,null,"v","Apprenticeship training agencies (ATAs)","Only recognised ATAs can directly employ apprentices only to deliver an apprenticeship.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G14:IV14),2)=1),--($G14:IV14=\"No\"))","v":0}]
[null,null,"vi","Alternative completion conditions","Unemployed and self-employed apprentices must satisfy alternative completion conditions to be eligible.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G15:IV15),2)=1),--($G15:IV15=\"No\"))","v":0}]
[3,"Is the programme as designed eligible for funding and is the correct funding being claimed?","i","Correct funding rates","The correct funding cap and incentive payments for the apprenticeship depend upon the accuracy of the apprenticeship standard value derived from LARS and recorded in the ILR.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G16:IV16),2)=1),--($G16:IV16=\"No\"))","v":0}]
[null,null,"ii","Negotiated price","The agreed price for training and end-point assessment required for the apprenticeship standard as recorded in the written agreement must be accurately recorded in the ILR.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G17:IV17),2)=1),--($G17:IV17=\"No\"))","v":0}]
[null,null,"iii","Mandatory qualifications","The learner is funded only for eligible training to meet the requirements of the end-point assessment as specified by the standard and set out in the commitment statement and written agreement.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G18:IV18),2)=1),--($G18:IV18=\"No\"))","v":0}]
[null,null,"iv","English and maths","Learners must be enrolled on, study and take the test for level 2 English and/or maths where they have not already achieved this level of English and/or maths prior to starting, unless they are assessed as needing to study level 1 first.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G19:IV19),2)=1),--($G19:IV19=\"No\"))","v":0}]
[null,null,"v","Recognition of prior learning","Any prior learning towards a regulated or accredited qualification is taken into account when assessing the learner and determining the price.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G20:IV20),2)=1),--($G20:IV20=\"No\"))","v":0}]
[null,null,"vi","Duplication of funding or learning","Any duplication or overlap in learning aim content (including provision funded through another source) and repetition of learning already carried out to achieve a qualification is considered when establishing whether a learning aim can be funded as part of an apprenticeship and determining the price.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G21:IV21),2)=1),--($G21:IV21=\"No\"))","v":0}]
[null,null,"vii","Apprenticeship duration","The apprenticeship must satisfy the minimum duration requirements, both planned and actual.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G22:IV22),2)=1),--($G22:IV22=\"No\"))","v":0}]
[null,null,"viii","Planned duration for part-time programme","The planned duration of the programme has been extended accordingly to account for the learner's part-time hours.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G23:IV23),2)=1),--($G23:IV23=\"No\"))","v":0}]
[null,null,"ix","Delivery location","The ESFA must give permission to claim funding for provision fully delivered outside England.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G24:IV24),2)=1),--($G24:IV24=\"No\"))","v":0}]
[null,null,"x","Distance learning","The ESFA will not fund an apprenticeship that is delivered only by distance learning.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G25:IV25),2)=1),--($G25:IV25=\"No\"))","v":0}]
[null,null,"xi","Breaks in learning","The ILR must be correctly updated to reflect a break in learning, as evidenced in the apprenticeship evidence pack.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G26:IV26),2)=1),--($G26:IV26=\"No\"))","v":0}]
[4,"Does learner documentation meet the minimum requirements outlined in the funding rules and agree to underlying data?","i","ILR consistent with apprenticeship evidence pack","Government contributions (including incentives) are driven by the underlying ILR data which must agree with information confirmed by the learner in the apprenticeship evidence pack.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G27:IV27),2)=1),--($G27:IV27=\"No\"))","v":0}]
[null,null,"ii","Written agreement and commitment statement","Government co-payments cannot be claimed without a copy of the written agreement between the provider and employer and the commitment statement agreed by the apprentice, provider and employer, both fulfilling the minimum requirements of the funding rules.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G28:IV28),2)=1),--($G28:IV28=\"No\"))","v":0}]
[null,null,"iii","Subcontracted provision","Provision delivered by a subcontractor, as recorded in the apprenticeship evidence pack, must be accurately reflected in the ILR.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G29:IV29),2)=1),--($G29:IV29=\"No\"))","v":0}]
[5,"Is the learner eligible for learning support funding and is there evidence of delivery of learning support?","i","Eligible for learning support","Learning support claimed through the ILR is supported by an assessment and there is a planned programme of support included in the learning agreement.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G30:IV30),2)=1),--($G30:IV30=\"No\"))","v":0}]
[null,null,"ii","Delivery of learning support","Learning support claimed through the ILR is supported by evidence of delivery of the planned programme of support included in the learning agreement.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G31:IV31),2)=1),--($G31:IV31=\"No\"))","v":0}]
[6,"Is the learner's programme and the learner's participation as recorded in the ILR consistent with the underlying records?","i","Learning start date","Funding can be claimed only from the date on which learning activity directly related to the apprenticeship standard, or learning aim (for English/maths), begins and can be evidenced.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G32:IV32),2)=1),--($G32:IV32=\"No\"))","v":0}]
[null,null,"ii","Learning activity","The learner's continued participation in learning (including English and maths) is confirmed by evidence of learning activity from the start date of each aim up to the learning actual end date or to date, as applicable.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G33:IV33),2)=1),--($G33:IV33=\"No\"))","v":0}]
[null,null,"iii","Learning aim achievement","The achievement of a component aim is correctly recorded in the ILR field Outcome and is supported by evidence of achievement from the awarding organisation within three months.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G34:IV34),2)=1),--($G34:IV34=\"No\"))","v":0}]
[7,"Where the learner completes or leaves the programme, does the learning actual end date recorded in the ILR agree with underlying records?","i","Learning actual end date","The learning actual end date recorded in the ILR reflects the last date that there is evidence of learning activity for any part of the standard, except where a learning aim has been completed at an earlier date and recorded as such.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G35:IV35),2)=1),--($G35:IV35=\"No\"))","v":0}]
[null,null,"ii","Transfers","The learner has transferred to a different standard and the correct learning actual end date, withdrawal reason and subsequent start date for the new standard have been accurately recorded in the ILR.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G36:IV36),2)=1),--($G36:IV36=\"No\"))","v":0}]
[8,"Does evidence exist to confirm eligibility for incentive payments to be made to the provider (where applicable)?","i","16- to 18- year old apprentice","The apprentice's date of birth confirms that they were aged 16, 17 or 18, or were a care leaver, when they started their apprenticeship and, together with the employer declaration, confirms eligibility for an incentive payment for employing an apprentice aged 16 to 18.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G37:IV37),2)=1),--($G37:IV37=\"No\"))","v":0}]
[null,null,"ii","Small employer","The employer declaration confirms that the employer has 49 or fewer paid full or part-time employees and so confirms eligibility for an incentive payment for an employer with fewer than 50 staff.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G38:IV38),2)=1),--($G38:IV38=\"No\"))","v":0}]
[null,null,"iii","Completion","As well as eligibility for incentive payment via the employer declaration, the achievement is supported by an apprenticeship completion certificate within three months or, in lieu of this, by evidence of successful end-point assessment, an employer claim form confirming satisfactory completion and a request for a completion certificate.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G39:IV39),2)=1),--($G39:IV39=\"No\"))","v":0}]
[null,null,"iv","Achievement date","The achievement date recorded in the ILR reflects the date on which the learner meets the criteria for a completion incentive payment",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G40:IV40),2)=1),--($G40:IV40=\"No\"))","v":0}]
["16 to 18 apprenticeship standards funding error"]
["Adult apprenticeship standards funding error"]

{"sheet":"D3 FM25_Adult","index":4,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Transaction no."]
["Learner reference number"]
["Student name (Family name & Given names)"]
["Date of birth"]
["Age on 31 August of funding year"]
["Postcode prior to enrolment"]
["Planned T Level programme hours"]
["Planned learning hours"]
["Planned employability, enrichment & pastoral hours"]
["Funding band"]
["Total funding"]
["Test",null,null,"Issue","Critical factor",{"$f":"SUM(F13:F32)","v":0},"Test satisfied\nYes/No","Comments, by exception"]
[1,"Has the institution correctly assessed that the student is eligible for ESFA funding?","i","Eligibility for funding","The student satisfies the ESFA's eligibility criteria.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G13:IV13),2)=1),--($G13:IV13=\"No\"))","v":0}]
[2,"Does the learning agreement, enrolment form and/or timetable agree to the ILR in terms of data, including eligibility for free meals in FE?","i","ILR consistent with learning agreement","Funding is driven by the underlying ILR data which must agree with information confirmed by the student in the learning agreement.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G14:IV14),2)=1),--($G14:IV14=\"No\"))","v":0}]
[3,"Has the learning agreement, enrolment form and/or timetable been signed by both the student and the institution?","i","Confirmation of learning agreement","The learning agreement must be signed/confirmed by the student and the institution.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G15:IV15),2)=1),--($G15:IV15=\"No\"))","v":0}]
[4,"Is there evidence that the student has been provided with IAG, an Initial assessment, a learning plan and other base documentation (including timetable if applicable)?","i","Base documentation","There must be evidence that the student has been provided with documentation (including IAG, initial assessment, learning agreement and timetable if applicable).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G16:IV16),2)=1),--($G16:IV16=\"No\"))","v":0}]
[5,"For 2023 to 2024 and the requirement to study English, is there evidence to support the values recorded in the ILR?","i","Requirement or exemption from requirement to study English","The values recorded in the ILR for GCSE English qualification grade and Learner FAM type GCSE English condition of funding (ECF) must be accurately completed to support any exemption from condition of funding for English.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G17:IV17),2)=1),--($G17:IV17=\"No\"))","v":0}]
[6,"For 2023 to 2024 and the requirement to study maths, is there evidence to support the values recorded in the ILR?","i","Requirement or exemption from requirement to study maths","The values recorded in the ILR for GCSE maths qualification grade and Learner FAM type GCSE maths condition of funding (MCF) must be accurately completed to support any exemption from condition of funding for maths.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G18:IV18),2)=1),--($G18:IV18=\"No\"))","v":0}]
[7,"Has the correct learning aim been recorded as the core learning aim?","i","Core aims","The correct learning aim must be recorded as the core learning aim.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G19:IV19),2)=1),--($G19:IV19=\"No\"))","v":0}]
[8,"Are the activities included in the programme eligible activities?","i","Eligible study programme activities","The activities included in the study programme must be relevant, planned and must take place during the institution's normal working pattern to be eligible.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G20:IV20),2)=1),--($G20:IV20=\"No\"))","v":0}]
[9,"Has the number of planned hours been correctly recorded in the ILR?","i","Planned hours","The number of study programme planned hours for the academic year must be correctly recorded in the ILR and supported by evidence.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G21:IV21),2)=1),--($G21:IV21=\"No\"))","v":0}]
[10,"Does the start date recorded in the ILR reconcile to registers, or alternative evidence of attendance held?","i","Learning start date","Funding for a learning aim or programme can be claimed only from the date on which learning activity directly related to the learning aim or programme begins and can be evidenced.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G22:IV22),2)=1),--($G22:IV22=\"No\"))","v":0}]
[11,"Is the student undertaking English in order to meet the funding requirements (applicable where there is no evidence that the student is exempt from the condition of funding; see test 5)?","i","Condition of funding (English)","There must be evidence that students needing to undertake English in order to meet the ESFA condition of funding are working towards the qualification and have met the qualifying period for funding for the learning aim.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G23:IV23),2)=1),--($G23:IV23=\"No\"))","v":0}]
[12,"Is the student undertaking maths in order to meet the funding requirements (applicable where there is no evidence that the student is exempt from the condition of funding; see test 6)?","i","Condition of funding (maths)","There must be evidence that students needing to undertake maths in order to meet the ESFA condition of funding are working towards the qualification and have met the qualifying period for funding for the learning aim.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G24:IV24),2)=1),--($G24:IV24=\"No\"))","v":0}]
[13,"If the student is undertaking work experience as part of their programme, have the placement details been fully documented and have arrangements for the recording of attendance been made?","i","Work experience","Where students are undertaking work experience as part of their programme, relevant processes must be followed.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G25:IV25),2)=1),--($G25:IV25=\"No\"))","v":0}]
[14,"If the student is undertaking an industry placement, has it been planned in accordance with the requirements for the T Level programme or capacity and delivery funding?","i","Industry placements","Where an industry placement is recorded, it must contain at least 315 planned hours, additional to the student's T Level or study programme, and it must normally be with no more than two external employers.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G26:IV26),2)=1),--($G26:IV26=\"No\"))","v":0}]
[15,"If the student has withdrawn from the programme, does the period of attendance on the programme qualify for funding?","i","Qualifying period for funding","For funding purposes, students are considered to have started a study programme once they have remained on that programme for at least the qualifying period for funding within the current funding year.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G27:IV27),2)=1),--($G27:IV27=\"No\"))","v":0}]
[16,"Where the student has withdrawn from any qualifications, have the withdrawal details been correctly recorded in the ILR?","i","Withdrawals","The learning actual end date recorded in the ILR reflects the last date that there is evidence of learning activity for each learning aim and the completion status and planned hours must be correctly updated as necessary.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G28:IV28),2)=1),--($G28:IV28=\"No\"))","v":0}]
[17,"For learning aims recorded in the ILR as achieved, is there evidence to support the achievements?","i","Learning aim achievement","The achievement is correctly recorded in the ILR and is supported by evidence from the awarding organisation.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G29:IV29),2)=1),--($G29:IV29=\"No\"))","v":0}]
[18,"Does the range of documents reviewed provide reasonable evidence of student existence and do the student's signatures appear consistent?","i","Student existence","The range of documents reviewed should provide reasonable evidence of student existence.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G30:IV30),2)=1),--($G30:IV30=\"No\"))","v":0}]
[19,"Does the ILR field Subcontracted or partnership UKPRN indicate that subcontracted provision exists?  If yes, please provide the organisation's name and refer to the respective subcontracting working paper.","i","Subcontracting","Subcontracted provision must be eligible for funding",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G31:IV31),2)=1),--($G31:IV31=\"No\"))","v":0}]
[20,"For students flagged as high needs students in the ILR, is there evidence of the home local authority agreement to fund the student's higher support cost needs (i.e. support costs above £6,000)?","i","High needs student support","There must be evidence to support claims for HNS funding.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G32:IV32),2)=1),--($G32:IV32=\"No\"))","v":0}]
["Funding error in sample"]
["Funding error outside sample but in population"]
["Funding error outside sample and population"]
["CHANGE IN HOURS/FUNDING CALCULATOR"]
[null,"Post-audit planned T Level programme hours"]
[null,"Post-audit planned learning hours in year"]
[null,"Post-audit planned employability, enrichment and pastoral hours in year"]
[null,"Post-audit funding band"]
[null,"Change in planned hours"]
[null,"Change in funding"]

{"sheet":"Test paper - Apprenticeships","index":5,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Transaction no."]
["Learner reference number"]
["Learner name (Family name & Given names)"]
["Unique learner number"]
["Date of birth"]
["National Insurance number"]
["Postcode prior to enrolment"]
["Indicative earnings (FIS)"]
["Indicative earnings (FIS): funding age band (16 to 18 or 19+)"]
["Indicative earnings (FIS): employer type (levy or non-levy, from Apps Monthly Payment Report)"]
["Test",null,null,"Issue","Critical factor",{"$f":"SUM(F12:F43)","v":0},"Test satisfied\nYes/No","Comments"]
[1,"Does evidence exist to confirm that the learner is eligible for ESFA funding?","i","Eligibility for funding","The learner satisfies the ESFA's eligibility criteria:\n- Apprentices must be aged 15 or over and have legally left school;\n- The individual must be able to complete the apprenticeship within the planned duration;\n- The individual must not contribute to the cost of their apprenticeship (including using a student loan);\n- The individual must have an eligible residency status per Annex A;\n- The individual must have the right to work in England;\n- Apprentices must spend at least 50% of their working hours in England;\n- The individual must not be undertaking another apprenticeship or other DfE funded programme at the same time; and\n- Individuals in prison must meet the rules to be eligible for apprenticeship funding.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G12:IV12),2)=1),--($G12:IV12=\"No\"))","v":0}]
[2,"Are the learner and employer eligible and has the programme been correctly identified and coded?","i","Employed status (not self employed)","Apprentices must be employed until the end point assessment is complete (except those that satisfy the conditions for redundancy or for particular office holders who are alternative apprentices).\nApprentices must not be self employed as a sole trader or as a shareholder or director with no separate identifiable person to undertake the role of employer.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G13:IV13),2)=1),--($G13:IV13=\"No\"))","v":0}]
[null,null,"ii","National minimum wage","Apprentices must be paid a lawful wage for the time they are in work and in off the-job training.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G14:IV14),2)=1),--($G14:IV14=\"No\"))","v":0}]
[null,null,"iii","Redundancy","Apprentices can continue to participate in their training if they are made redundant and meet the eligibility criteria, and have specified evidence available.\nThe provider must have evidence of any support given to the apprentice to find a new employer and evidence of apprenticeship part-completion, where applicable.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G15:IV15),2)=1),--($G15:IV15=\"No\"))","v":0}]
[null,null,"iv"," Flexi-Job Apprenticeship Agencies (FJAAs)","Main providers must hold documented details of the apprentice’s placement(s).  This includes the name of the host employer(s) and the duration of the placement(s). ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G16:IV16),2)=1),--($G16:IV16=\"No\"))","v":0}]
[3,"Is the programme as designed eligible for funding and is the correct funding being claimed?","i","Negotiated price","The provider must breakdown the total negotiated price associated with the delivery of training and on-programme assessment (TNP1) and agreed this with the employer.  Only eligible costs should be included and actual costs only where applicable.\nThe provider has entered the agreed price for end-point assessment (if known) in TNP2 on the ILR, has not used an estimate and has a written agreement with the EPAO\nAll changes in price to TNP1 or TNP2 (and reason) must be agreed by the employer.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G17:IV17),2)=1),--($G17:IV17=\"No\"))","v":0}]
[null,null,"ii","English and maths","Apprentices must hold or achieve English and maths qualifications as per the funding rule requirements and additional information should be held where the apprentice is assessed as exempt from the normal English and maths requirements (note any impact of duplication of funding or learning).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G18:IV18),2)=1),--($G18:IV18=\"No\"))","v":0}]
[null,null,"iii","Prior learning Knowledge, skills and behaviours: Assessment","There must be an appropriate assessment of the apprentice's knowledge, skills and behaviours prior to commencing the apprenticeship.  \n\nThe initial assessment must meet the funding rules and be documented.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G19:IV19),2)=1),--($G19:IV19=\"No\"))","v":0}]
[null,null,"iv","Prior learning Knowledge, skills and behaviours: \nOutcome","The outcome of the assessment of prior learning, knowledge, skills & behaviours and initial assessment must be agreed with the employer and documented as per the rules.  Note any impact of duplication of funding or learning.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G20:IV20),2)=1),--($G20:IV20=\"No\"))","v":0}]
[null,null,"v","Apprenticeship duration","The apprenticeship must satisfy the 12 month minimum duration requirements, both planned and actual.  This is after the content, duration and price have been adjusted to recognise prior learning.\nThe planned duration of the programme has been extended accordingly to account for the learner's part-time or zero hour contracts.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G21:IV21),2)=1),--($G21:IV21=\"No\"))","v":0}]
[null,null,"vi","Breaks in learning","A break in learning must be used where applicable.  The ILR must be correctly updated to reflect a break in learning, which reconciles to the information recorded in the evidence pack (including any amendments made to off-the-job hours).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G22:IV22),2)=1),--($G22:IV22=\"No\"))","v":0}]
[4,"Does learner documentation meet the minimum requirements outlined in the funding rules and agree to underlying data?","i","ILR consistent with evidence pack","Government contributions (including additional payments) are driven by the underlying ILR data which must agree with information confirmed by the learner in the evidence pack (e.g. postcode and date of birth), including planned and actual off-the job training hours in the respective ILR fields.  This also includes the correct recording of the data fields used to match with apprenticeship service for funding purposes.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G23:IV23),2)=1),--($G23:IV23=\"No\"))","v":0}]
[null,null,"ii","Apprenticeship agreement","There must be a valid apprenticeship agreement signed by the employer and apprentice from the start of, and for the actual duration of the apprenticeship programme that is complete and meets the funding rules. The agreement must not be signed by the same person acting as both the apprentice and the employer.  The apprenticeship agreement must be revised to account for any breaks in learning or applicable changes.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G24:IV24),2)=1),--($G24:IV24=\"No\"))","v":0}]
[null,null,"iii","Training plan","There must be an up-to-date training plan setting out the minimum requirements of the funding rules, signed and dated by the apprentice, main provider and employer, agreed prior to delivery.  Evidence that progress is being made towards the plan. Normal working hours must be included along with confirmation that the apprentice will be allowed to undertake off-the-job training within their normal working hours in addition to English and maths training if required.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G25:IV25),2)=1),--($G25:IV25=\"No\"))","v":0}]
[null,null,"iv","Off the Job calculation and plan","Following initial assessment, the off-the-job training must equate to at least a minimum of 20% of the apprentice's normal working hours (capped at 30 hours per week for full time) over the planned duration of the apprenticeship practical period once statutory annual leave has been deducted. The duration must be extended for apprentices working less than 30 hours.\n\nThe number of planned off-the-job training hours must be documented on the apprenticeship agreement, training plan and the ILR and reconcile.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G26:IV26),2)=1),--($G26:IV26=\"No\"))","v":0}]
[null,null,"v","Subcontracted  provision eligible","Provision delivered by a subcontractor, must be eligible, meet the evidence pack requirements and accurately reflected in the ILR. The provider must directly deliver some of the apprenticeship training and / or on-programme assessment",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G27:IV27),2)=1),--($G27:IV27=\"No\"))","v":0}]
[5,"Is the learner eligible for learning support funding and is there evidence of delivery of learning support?","i","Eligible for learning support","Learning support claimed through the ILR is supported by an assessment that demonstrates the apprentice's learning difficulty or disability and there is a planned programme of support including details of the identified reasonable adjustment required. ",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G28:IV28),2)=1),--($G28:IV28=\"No\"))","v":0}]
[null,null,"ii","Delivery of learning support","Learning support claimed through the ILR is confirmed by evidence of delivery of support to meet the reasonable adjustments and confirm the continuing necessity and appropriateness on a monthly basis, evidenced by reviews.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G29:IV29),2)=1),--($G29:IV29=\"No\"))","v":0}]
[6,"Is the learner's programme and the learner's participation as recorded in the ILR consistent with the underlying records?","i","Learning start date","Funding can be claimed only from the date on which learning activity directly related to the apprenticeship, or learning aim (for English/maths), begins and can be evidenced.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G30:IV30),2)=1),--($G30:IV30=\"No\"))","v":0}]
[null,null,"ii","Learning activity","The learner's continued participation in learning (including English and maths) is confirmed by evidence of learning activity.  The apprentice must be involved in active learning (off-the-job training or English and maths training) every calendar month (every 3 calendar months for front-loaded and block release models) throughout the apprenticeship from the learning start date to the learning actual end date (the practical period).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G31:IV31),2)=1),--($G31:IV31=\"No\"))","v":0}]
[null,null,"iii","Learning aim achievement","The achievement of a component aim, including English and maths, is correctly recorded in the ILR field Outcome and is supported by evidence of achievement from the awarding organisation.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G32:IV32),2)=1),--($G32:IV32=\"No\"))","v":0}]
[null,null,"iv","Off-the-job training delivery for apprentices on programme","Where an apprentice is still on programme, the evidence pack must contain evidence of the actual off-the-job training hours delivered to date including what the activity / session was. Evidence must be available that delivery meets the definition of off-the-job training.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G33:IV33),2)=1),--($G33:IV33=\"No\"))","v":0}]
[7,"Where the learner completes, leaves or transfers from the programme, does the  ILR agree with underlying records?","i","Learning actual end date","The learning actual end date (the date when learning towards the apprenticeship is complete) recorded in the ILR reflects the last date that there is evidence of learning activity.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G34:IV34),2)=1),--($G34:IV34=\"No\"))","v":0}]
[null,null,"ii","Transfers of programme, employer or provider","The learner has transferred to a different employer, provider, programme or learning aim and the correct learning actual end date, withdrawal reason and subsequent start date have been accurately recorded in the ILR.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G35:IV35),2)=1),--($G35:IV35=\"No\"))","v":0}]
[null,null,"iii","Completion of practical period and/or programme","Actual off-the-job hours at the end of practical period:\nWhere an apprentice has completed all learning activities, the evidence pack must contain evidence that the actual off-the-job training hours delivered meet the minimum calculation and definition of off-the-job training.\nActual hours should reconcile to the hours recorded in the ILR (exceptions to this requirement apply).\nWhere the volume of off-the-job training hours delivered is less than the original volume of planned hours agreed at the beginning of the programme with the employer, there is a statement on file to explain the difference which meets the funding rule requirements.\n\nPayment:\nThe completion payment is supported by evidence of completion of end point assessment and supported by evidence of achievement/outcome, evidence that the minimum duration requirement has been met, and, where applicable, evidence that the total employer's co-investment has been collected and recorded.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G36:IV36),2)=1),--($G36:IV36=\"No\"))","v":0}]
[8,"Where the employer or training provider are required to make payments, does evidence exist that the payments have been made?","i","Payment of employer co-investment","The employer co-investment recorded in the ILR is evidenced by a transfer of funding visible in the provider's (or subcontractor's) financial systems; this will typically be in the form of a provider invoice and corresponding employer payment to the provider.  For employer-providers, they must evidence how they have calculated costs.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G37:IV37),2)=1),--($G37:IV37=\"No\"))","v":0}]
[9,"Does evidence exist to confirm eligibility for additional payments made to the provider (where applicable)?","i","16- to 18- year old apprentice","The apprentice's date of birth confirms that they were aged 16, 17 or 18 when they started their apprenticeship and confirms eligibility for an additional payment for employing a young apprentice.  Evidence of payment to employer as per funding rules.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G38:IV38),2)=1),--($G38:IV38=\"No\"))","v":0}]
[null,null,"ii","Relevant 19- to 24- year olds","The apprentice's date of birth confirms that they were aged between 19 and 24 when they started their apprenticeship, and evidence held to confirm they have either an EHC plan or have been in the care of the local authority and consent to inform their employer.  Evidence of payment to employer as per funding rules.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G39:IV39),2)=1),--($G39:IV39=\"No\"))","v":0}]
[null,null,"iii","Care leavers bursary","Apprentices satisfying the definition of a care leaver are eligible for a payment. Evidence should be held to support eligibility and payment to the learner as per funding rules.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G40:IV40),2)=1),--($G40:IV40=\"No\"))","v":0}]
[null,null,"iv","Small employer","For prior year starts: There must be a statement from the employer, along with evidence, confirming eligibility that they had an average of 49 or fewer employees with a contract of service in the 365 days before the apprentice was recruited. This must be obtained before the apprentice starts.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G41:IV41),2)=1),--($G41:IV41=\"No\"))","v":0}]
[10,"Is there sufficient evidence to demonstrate that the provider has met its obligations with regard to the end-point assessment process?","i","Contractual arrangements","There must be evidence of a written agreement with the end point assessment organisation (EPAO) for conducting the end-point assessment where appropriate.\nThere must be evidence to demonstrate payments made by the provider to the EPAO for end-point assessment have been made as per the contract.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G42:IV42),2)=1),--($G42:IV42=\"No\"))","v":0}]
[null,null,"ii","Gateway assessment","There must be records and evidence of completion of the end-point assessment / end point assessment requirements along with evidence that the learner is still employed upon completion of the end-point assessment.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G43:IV43),2)=1),--($G43:IV43=\"No\"))","v":0}]
["Apprenticeship (levy paying employer) funding error"]
["Apprenticeship (non-levy paying employer) funding error"]
["OFF-THE-JOB TRAINING CALCULATOR (see instructions for more details)"]
[null,"Number of normal working hours per week"]
[null,"Planned off-the-job training hours (from ILR where applicable)"]
[null,"Original start date of apprenticeship programme (from ILR)"]
[null,"Practical period planned end date (from ILR where available)"]
[null,"Calculated minimum off-the-job training requirement"]
[null,"Conclusion on planned off-the-job training hours"]

{"sheet":"Test paper - Loans","index":6,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Transaction no."]
["Learner reference number"]
["Learner name (Family name & Given names)"]
["Unique learner number"]
["Date of birth"]
["Advanced Learner Loans Bursary funding (YTD)"]
["Test",null,null,"Issue","Critical factor",{"$f":"SUM(F8:F20)","v":0},"Test satisfied\nYes/No","Comments"]
[1,"Do learner and programme details as recorded in the learning and funding information letter, the loans portal, the learning agreement and the ILR agree?","i","ILR consistent with learner file","Underlying ILR data must agree with information confirmed by the learner in the learner file.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G8:IV8),2)=1),--($G8:IV8=\"No\"))","v":0}]
[null,null,"ii","ILR consistent with loans portal","Information in the learner file, returned to the ESFA in the ILR, must match the data returned to the SLC via the loans portal where applicable.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G9:IV9),2)=1),--($G9:IV9=\"No\"))","v":0}]
[null,null,"iii","Learning and funding information letter","The model learning and funding information letter, available on the GOV.UK website, must be used to create the learner's learning and funding information letter.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G10:IV10),2)=1),--($G10:IV10=\"No\"))","v":0}]
[null,null,"iv","Entitlement to full funding","Learners aged 19 and above without an existing full level 3 or equivalent can be funded by a loan only where they have waived their right to be fully funded either as part of their legal entitlement or through the level 3 free courses for jobs offer.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G11:IV11),2)=1),--($G11:IV11=\"No\"))","v":0}]
[null,null,"v","Delivery outside England","All loans funded provision must be delivered in England.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G12:IV12),2)=1),--($G12:IV12=\"No\"))","v":0}]
[null,null,"vi","Delivery location postcode","The delivery location postcode recorded in the ILR informs the area cost uplift that is applied to claims for loans bursary funding.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G13:IV13),2)=1),--($G13:IV13=\"No\"))","v":0}]
[2,"Is the learner's programme and the learner's attendance as recorded in the ILR and on the loans portal consistent with the underlying records?","i","Learning activity","The learner's continued participation in learning is confirmed by evidence of learning activity from the start date of each aim (i.e. up to the learning actual end date or to date, as applicable).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G14:IV14),2)=1),--($G14:IV14=\"No\"))","v":0}]
[null,null,"ii","Change of circumstances & transfers","Any change is accurately recorded in the ILR, and this matches the loans portal.  A new learning and funding information letter is issued where applicable.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G15:IV15),2)=1),--($G15:IV15=\"No\"))","v":0}]
[null,null,"iii","Learning actual end date","The learning actual end date recorded in the ILR and the loans portal reflects the date of completion or the last date that there is evidence of learning activity for each learning aim.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G16:IV16),2)=1),--($G16:IV16=\"No\"))","v":0}]
[null,null,"iv","Breaks in learning","A break in learning must be accurately recorded in the ILR and on the loans portal.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G17:IV17),2)=1),--($G17:IV17=\"No\"))","v":0}]
[null,null,"v","Subcontracted provision","Providers must directly deliver loans funded provision.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G18:IV18),2)=1),--($G18:IV18=\"No\"))","v":0}]
[3,"Where the learner has received Advanced Learner Loans Bursary Fund support, is the learner eligible for the funding as coded in the ILR?","i","Eligible for loans bursary funding","Loans bursary funding claimed through the ILR is supported by evidence of an assessed need.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G19:IV19),2)=1),--($G19:IV19=\"No\"))","v":0}]
[null,null,"ii","Correct fixed rate used","The fixed rate claimed must reflect the criteria for the respective rate.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G20:IV20),2)=1),--($G20:IV20=\"No\"))","v":0}]
["Advanced Learner Loans Bursary funding error"]

{"sheet":"Test paper - 16-19","index":7,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Transaction no."]
["Learner reference number"]
["Student name (Family name & Given names)"]
["Date of birth"]
["Age on 31 August of funding year"]
["Postcode prior to enrolment"]
["Planned T Level programme hours"]
["Planned learning hours"]
["Planned employability, enrichment & pastoral hours"]
["Funding band"]
["16 to 19 study programmes funding"]
["T Level programme funding"]
["Test",null,null,"Issue","Critical factor",{"$f":"SUM(F14:F35)","v":0},"Test satisfied\nYes/No","Comments, by exception"]
[1,"Has the institution correctly assessed that the student is eligible for ESFA funding?","i","Eligibility for funding","The student satisfies the ESFA's eligibility criteria.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G14:IV14),2)=1),--($G14:IV14=\"No\"))","v":0}]
[2,"Does the learning agreement, enrolment form and/or timetable agree to the ILR in terms of data, including eligibility for free meals in FE?","i","ILR consistent with learning agreement","Funding is driven by the underlying ILR data which must agree with information confirmed by the student in the learning agreement.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G15:IV15),2)=1),--($G15:IV15=\"No\"))","v":0}]
[3,"Has the learning agreement, enrolment form and/or timetable been signed by both the student and the institution?","i","Confirmation of learning agreement","The learning agreement must be signed/confirmed by the student and the institution.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G16:IV16),2)=1),--($G16:IV16=\"No\"))","v":0}]
[4,"Is there evidence that the student has been provided with IAG, an Initial assessment, a learning plan and other base documentation (including timetable if applicable)?","i","Base documentation","There must be evidence that the student has been provided with documentation (including IAG, initial assessment, learning agreement and timetable if applicable).",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G17:IV17),2)=1),--($G17:IV17=\"No\"))","v":0}]
[5,"Is the requirement to study English, is there evidence to support the values recorded in the ILR?","i","Requirement or exemption from requirement to study English","The values recorded in the ILR for GCSE English qualification grade and Learner FAM type GCSE English condition of funding (ECF) must be accurately completed to support any exemption from condition of funding for English.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G18:IV18),2)=1),--($G18:IV18=\"No\"))","v":0}]
[6,"Is the requirement to study maths, is there evidence to support the values recorded in the ILR?","i","Requirement or exemption from requirement to study maths","The values recorded in the ILR for GCSE maths qualification grade and Learner FAM type GCSE maths condition of funding (MCF) must be accurately completed to support any exemption from condition of funding for maths.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G19:IV19),2)=1),--($G19:IV19=\"No\"))","v":0}]
[7,"Has the correct learning aim been recorded as the core learning aim?","i","Core aims","The correct learning aim must be recorded as the core learning aim.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G20:IV20),2)=1),--($G20:IV20=\"No\"))","v":0}]
[8,"Are the activities included in the programme eligible activities?","i","Eligible study programme activities","The activities included in the study programme must be relevant, planned and must take place during the institution's normal working pattern to be eligible.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G21:IV21),2)=1),--($G21:IV21=\"No\"))","v":0}]
[null,null,"ii","Eligible T Level programme activities","The activities included in the T Level programme must be relevant, planned and, with the exception of the industry placement, must take place during the institution's normal working pattern to be eligible.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G22:IV22),2)=1),--($G22:IV22=\"No\"))","v":0}]
[9,"Has the number of planned hours been correctly recorded in the ILR?","i","Planned hours","The number of study programme planned hours for the academic year must be correctly recorded in the ILR and supported by evidence.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G23:IV23),2)=1),--($G23:IV23=\"No\"))","v":0}]
[null,null,"ii","Planned hours (T Level)","The number of planned hours for the whole duration of the T Level programme must be correctly recorded in the ILR, supported by evidence, and must not include English, maths or industry placements.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G24:IV24),2)=1),--($G24:IV24=\"No\"))","v":0}]
[10,"Does the start date recorded in the ILR reconcile to registers, or alternative evidence of attendance held?","i","Learning start date","Funding for a learning aim or programme can be claimed only from the date on which learning activity directly related to the learning aim or programme begins and can be evidenced.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G25:IV25),2)=1),--($G25:IV25=\"No\"))","v":0}]
[11,"Is the student undertaking English in order to meet the funding requirements (applicable where there is no evidence that the student is exempt from the condition of funding; see test 5)?","i","Condition of funding (English)","There must be evidence that students needing to undertake English in order to meet the ESFA condition of funding are working towards the qualification and have met the qualifying period for funding for the learning aim and minimum planned hours threshold.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G26:IV26),2)=1),--($G26:IV26=\"No\"))","v":0}]
[12,"Is the student undertaking maths in order to meet the funding requirements (applicable where there is no evidence that the student is exempt from the condition of funding; see test 6)?","i","Condition of funding (maths)","There must be evidence that students needing to undertake maths in order to meet the ESFA condition of funding are working towards the qualification and have met the qualifying period for funding for the learning aim and minimum planned hours threshold.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G27:IV27),2)=1),--($G27:IV27=\"No\"))","v":0}]
[13,"If the student is undertaking work experience as part of their programme, have the placement details been fully documented and have arrangements for the recording of attendance been made?","i","Work experience","Where students are undertaking work experience as part of their programme, relevant processes must be followed.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G28:IV28),2)=1),--($G28:IV28=\"No\"))","v":0}]
[14,"If the student is undertaking an industry placement, has it been planned in accordance with the requirements for the T Level programme or capacity and delivery funding?","i","Industry placements","Where an industry placement is recorded, it must contain at least 315 planned hours, additional to the student's T Level or study programme, and it must normally be with no more than two external employers.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G29:IV29),2)=1),--($G29:IV29=\"No\"))","v":0}]
[15,"If the student has withdrawn from the programme, does the period of attendance on the programme qualify for funding?","i","Qualifying period for funding","For funding purposes, students are considered to have started a study programme once they have remained on that programme for at least the qualifying period for funding within the current funding year.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G30:IV30),2)=1),--($G30:IV30=\"No\"))","v":0}]
[16,"Where the student has withdrawn from any qualifications, have the withdrawal details been correctly recorded in the ILR?","i","Withdrawals","The learning actual end date recorded in the ILR reflects the last date that there is evidence of learning activity for each learning aim and the completion status and planned hours must be correctly updated as necessary.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G31:IV31),2)=1),--($G31:IV31=\"No\"))","v":0}]
[17,"For learning aims recorded in the ILR as achieved, is there evidence to support the achievements?","i","Learning aim achievement","The achievement is correctly recorded in the ILR and is supported by evidence from the awarding organisation.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G32:IV32),2)=1),--($G32:IV32=\"No\"))","v":0}]
[18,"Does the range of documents reviewed provide reasonable evidence of student existence and do the student's signatures appear consistent?","i","Student existence","The range of documents reviewed should provide reasonable evidence of student existence.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G33:IV33),2)=1),--($G33:IV33=\"No\"))","v":0}]
[19,"Does the ILR field Subcontracted or partnership UKPRN indicate that subcontracted provision exists?  If yes, please provide the organisation's name and refer to the respective subcontracting working paper.","i","Subcontracting","Subcontracted provision must be eligible for funding",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G34:IV34),2)=1),--($G34:IV34=\"No\"))","v":0}]
[20,"For students flagged as high needs students in the ILR, is there evidence of the home local authority agreement to fund the student's higher support cost needs (i.e. support costs above £6,000)?","i","High needs student support","There must be evidence to support claims for HNS funding.",{"$f":"SUMPRODUCT(--(MOD(COLUMN($G35:IV35),2)=1),--($G35:IV35=\"No\"))","v":0}]
["Funding error in sample"]
["Funding error outside sample but in population"]
["Funding error outside sample and population"]
["CHANGE IN HOURS/FUNDING CALCULATOR"]
[null,"Post-audit planned T Level programme hours"]
[null,"Post-audit planned learning hours in year"]
[null,"Post-audit planned employability, enrichment and pastoral hours in year"]
[null,"Post-audit funding band"]
[null,"Change in planned hours"]
[null,"Change in funding"]

{"sheet":"B3_Temp","index":8,"n_rows":3,"n_cols":63,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19 to 24 traineeships",null,null,null,"AEB other learning",null,null,null,"Adult skills funded provision within FM25",null,null,null,"16 to 18 apprenticeships (Levy paying employers)",null,null,null,"Adult apprenticeships (Levy paying employers)",null,null,null,"16 to 18 apprenticeships (Non-levy paying employers)",null,null,null,"Adult apprenticeships (Non-levy paying employers)",null,null,null,"Advanced Learner Loans Bursary Fund",null,null,null,"16 to 19 study programmes",null,null,null,"T Level programmes",null,null,null,"Total"]
["No.","Original WP Ref.","Learner name (if applicable)","Learner reference no. (if applicable)","Critical factor issue","Critical factor description","Details of potential error","Provider's response to error","Accept provider's response?","Error cleared?","Has a (sub-) population of learners with the same error characteristics as the error in the main sample been identified?","Describe the (sub-) population affected","Has (sub-) population been 100% tested and assurance gained?","Additional testing working paper ref.","Error categorisation","Report issue?\n(Yes/No)","Action plan ref.","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Sample error (£)","Other errors outside sample but within population (£)\n","Errors relating to prior funding years (£)\n","Under-claims (£)","Total funding error (£)","Errors corrected?\n(include file references where applicable)"]
[{"$f":"ROW()-2","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(BF3=0,BG3=0,BI3<>0),\"Under-claim\",IF(K3=\"N/A\",\"N/A\",IF(K3=\"Not found in main sample\",\"PDSAT/Other\",IF(K3=\"No\",\"Random\",IF(AND(K3=\"Yes\",M3=\"Yes\"),\"Ring-fenced\",IF(OR(ISBLANK(K3),ISBLANK(M3)),\"\",\"Random\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$BE3),4)=2),--($R3:$BE3))","v":0},{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$BE3),4)=3),--($R3:$BE3))","v":0},{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$BE3),4)=0),--($R3:$BE3))","v":0},{"$f":"SUMPRODUCT(--(MOD(COLUMN($R3:$BE3),4)=1),--($R3:$BE3))","v":0},{"$f":"SUM(BF3:BH3)","v":0}]

{"sheet":"B3_Summary","index":9,"n_rows":4,"n_cols":23,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["B3 summary by critical factor","FM38 Adult Skills Fund",null,"FM35 Adult Skills Fund",null,null,null,"16 to 18 apprenticeships (Levy paying employers)",null,"Adult apprenticeships (Levy paying employers)",null,"16 to 18 apprenticeships (Non-levy paying employers)",null,"Adult apprenticeships (Non-levy paying employers)",null,"Advanced Learner Loans Bursary Fund",null,"16 to 19 study programmes",null,"T Level programmes",null,"Total errors"]
["Critical factor issue","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)",null,null,"Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)","Learners in sample with funding error","Total funding error (£)"]
["Payment of employer co-investment",{"$f":"COUNTIFS(B3_CF,$A3,ISE_FM38,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_FM38)+SUMIF(B3_CF,$A3,OSE_FM38)+SUMIF(B3_CF,$A3,PFY_FM38)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_FM35,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_FM35)+SUMIF(B3_CF,$A3,OSE_FM35)+SUMIF(B3_CF,$A3,PFY_FM35)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_FM25_ADULT,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_FM25_ADULT)+SUMIF(B3_CF,$A3,OSE_FM25_ADULT)+SUMIF(B3_CF,$A3,PFY_FM25_ADULT)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_1618APPL,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_1618APPL)+SUMIF(B3_CF,$A3,OSE_1618APPL)+SUMIF(B3_CF,$A3,PFY_1618APPL)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_ADAPPL,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_ADAPPL)+SUMIF(B3_CF,$A3,OSE_ADAPPL)+SUMIF(B3_CF,$A3,PFY_ADAPPL)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_1618APPN,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_1618APPN)+SUMIF(B3_CF,$A3,OSE_1618APPN)+SUMIF(B3_CF,$A3,PFY_1618APPN)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_ADAPPN,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_ADAPPN)+SUMIF(B3_CF,$A3,OSE_ADAPPN)+SUMIF(B3_CF,$A3,PFY_ADAPPN)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_ALL,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_ALL)+SUMIF(B3_CF,$A3,OSE_ALL)+SUMIF(B3_CF,$A3,PFY_ALL)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_FM25_1619,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_FM25_1619)+SUMIF(B3_CF,$A3,OSE_FM25_1619)+SUMIF(B3_CF,$A3,PFY_FM25_1619)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(B3_CF,$A3,ISE_TLEVEL,\">0\")","v":{"$error":"#REF!"}},{"$f":"SUMIF(B3_CF,$A3,ISE_TLEVEL)+SUMIF(B3_CF,$A3,OSE_TLEVEL)+SUMIF(B3_CF,$A3,PFY_TLEVEL)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT(--(MOD(COLUMN($B3:$U3),2)=0),--($B3:$U3))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT(--(MOD(COLUMN($B3:$U3),2)=1),--($B3:$U3))","v":{"$error":"#REF!"}}]
["TOTAL",null,{"$f":"SUM(C3:C3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E3:E3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G3:G3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I3:I3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K3:K3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M3:M3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O3:O3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(Q3:Q3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(S3:S3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(U3:U3)","v":{"$error":"#REF!"}},null,{"$f":"SUM(W3:W3)","v":{"$error":"#REF!"}}]

{"sheet":"B1 (Detail)","index":10,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Reconciliation statement"]
[]
[null,null,"Adult Skills Fund",null,null,null,null,"16 to 19 provision"]
["Description","Apprenticeships (starts on or after 1 May 2017)","FM38","FM35",null,"TOTAL","Loans Bursary fund","16 to 19 study programmes","T Level programmes","TOTAL","OVERALL TOTAL"]
["Balance from reviewed ILR\n\nApprenticeships/Adult:\n- from Year To Date column of Funding Summary Report for reviewed ILR\n\n16 to 19:\n- from FIS Report: 16-19 Funding Claim Report for reviewed ILR",null,null,null,null,{"$f":"SUM(C5:E5)","v":0},null,null,null,{"$f":"SUM(H5:I5)","v":0},{"$f":"SUM(B5,F5,G5,J5)","v":0}]
[]
["Adjustments from assurance review (as per B3)"]
["Funding errors",{"$f":"-INT(ROUND(SUMIF(ISE_1618APPL,\">=0\",ISE_1618APPL)+ SUMIF(OSE_1618APPL,\">=0\",OSE_1618APPL)+SUMIF(ISE_1618APPN,\">=0\",ISE_1618APPN)+ SUMIF(OSE_1618APPN,\">=0\",OSE_1618APPN)+SUMIF(ISE_ADAPPL,\">=0\",ISE_ADAPPL)+ SUMIF(OSE_ADAPPL,\">=0\",OSE_ADAPPL)+SUMIF(ISE_ADAPPN,\">=0\",ISE_ADAPPN)+ SUMIF(OSE_ADAPPN,\">=0\",OSE_ADAPPN),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(ISE_FM38,\">=0\",ISE_FM38)+SUMIF(OSE_FM38,\">=0\",OSE_FM38),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(ISE_FM35,\">=0\",ISE_FM35)+SUMIF(OSE_FM35,\">=0\",OSE_FM35),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(ISE_FM25_ADULT,\">=0\",ISE_FM25_ADULT)+SUMIF(OSE_FM25_ADULT,\">=0\",OSE_FM25_ADULT),0))","v":{"$error":"#REF!"}},{"$f":"SUM(C8:E8)","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(ISE_ALL,\">=0\",ISE_ALL)+SUMIF(OSE_ALL,\">=0\",OSE_ALL),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(ISE_FM25_1619,\">=0\",ISE_FM25_1619)+SUMIF(OSE_FM25_1619,\">=0\",OSE_FM25_1619),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(ISE_TLEVEL,\">=0\",ISE_TLEVEL)+SUMIF(OSE_TLEVEL,\">=0\",OSE_TLEVEL),0))","v":{"$error":"#REF!"}},{"$f":"SUM(H8:I8)","v":{"$error":"#REF!"}},{"$f":"SUM(B8,F8,G8,J8)","v":{"$error":"#REF!"}}]
["Under claims",{"$f":"-INT(ROUND(SUMIF(U_1618APPL,\"<=0\",U_1618APPL)+SUMIF(U_1618APPN,\"<=0\",U_1618APPN)+SUMIF(U_ADAPPL,\"<=0\",U_ADAPPL)+SUMIF(U_ADAPPN,\"<=0\",U_ADAPPN),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(U_T35,\"<=0\",U_T35),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(U_AEB,\"<=0\",U_AEB),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(U_FM25_ADULT,\"<=0\",U_FM25_ADULT),0))","v":{"$error":"#REF!"}},{"$f":"SUM(C9:E9)","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(U_ALL,\"<=0\",U_ALL),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(U_FM25_1619,\"<=0\",U_FM25_1619),0))","v":{"$error":"#REF!"}},{"$f":"-INT(ROUND(SUMIF(U_TLEVEL,\"<=0\",U_TLEVEL),0))","v":{"$error":"#REF!"}},{"$f":"SUM(H9:I9)","v":{"$error":"#REF!"}},{"$f":"SUM(B9,F9,G9,J9)","v":{"$error":"#REF!"}}]
["TOTAL: Adjustments from assurance review",{"$f":"SUM(B8:B9)","v":{"$error":"#REF!"}},{"$f":"SUM(C8:C9)","v":{"$error":"#REF!"}},{"$f":"SUM(D8:D9)","v":{"$error":"#REF!"}},{"$f":"SUM(E8:E9)","v":{"$error":"#REF!"}},{"$f":"SUM(C10:E10)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G9)","v":{"$error":"#REF!"}},{"$f":"SUM(H8:H9)","v":{"$error":"#REF!"}},{"$f":"SUM(I8:I9)","v":{"$error":"#REF!"}},{"$f":"SUM(H10:I10)","v":{"$error":"#REF!"}},{"$f":"SUM(K8:K9)","v":{"$error":"#REF!"}}]
[]
["Provider adjustments"]
[null,null,null,null,null,{"$f":"SUM(C13:E13)","v":0},null,null,null,{"$f":"SUM(H13:I13)","v":0}]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
["TOTAL: Provider adjustments",{"$f":"SUM(B13:B31)","v":0},{"$f":"SUM(C13:C31)","v":0},{"$f":"SUM(D13:D31)","v":0},{"$f":"SUM(E13:E31)","v":0},0,{"$f":"SUM(G13:G31)","v":0},{"$f":"SUM(H13:H31)","v":0},{"$f":"SUM(I13:I31)","v":0},0,{"$f":"SUM(B32,F32,G32,J32)","v":0}]
[]
["EXPECTED TOTAL VALUE OF ILR FUNDING CLAIMED",{"$f":"SUM(B5,B10,B32)","v":{"$error":"#REF!"}},{"$f":"SUM(C5,C10,C32)","v":{"$error":"#REF!"}},{"$f":"SUM(D5,D10,D32)","v":{"$error":"#REF!"}},{"$f":"SUM(E5,E10,E32)","v":{"$error":"#REF!"}},{"$f":"SUM(C34:E34)","v":{"$error":"#REF!"}},{"$f":"SUM(G5,G10,G32)","v":{"$error":"#REF!"}},{"$f":"SUM(H5,H10,H32)","v":{"$error":"#REF!"}},{"$f":"SUM(I5,I10,I32)","v":{"$error":"#REF!"}},{"$f":"SUM(H34:I34)","v":{"$error":"#REF!"}},{"$f":"SUM(K5,K10,K32)","v":{"$error":"#REF!"}}]
[]
["CHECK SECTION"]
["Balance from closing ILR\n\nApprenticeships/Adult:\n- from Year To Date column of Funding Summary Report for closing ILR\n\n16 to 19:\n- take from FIS Report: 16-19 Funding Claim Report for closing ILR",null,null,null,null,{"$f":"IF(AND(C37=\"\",D37=\"\",E37=\"\"),\"\",SUM(C37:E37))","v":""},null,null,null,null,{"$f":"SUM(B37,F37,G37,J37)","v":0}]
["Difference between closing ILR and reconciliation",{"$f":"IF(ISBLANK(B37),\"\",B37-B34)","v":""},{"$f":"IF(ISBLANK(C37),\"\",C37-C34)","v":""},{"$f":"IF(ISBLANK(D37),\"\",D37-D34)","v":""},{"$f":"IF(ISBLANK(E37),\"\",E37-E34)","v":""},{"$f":"IF(F37=\"\",\"\",F37-F34)","v":""},{"$f":"IF(ISBLANK(G37),\"\",G37-G34)","v":""},{"$f":"IF(ISBLANK(H37),\"\",H37-H34)","v":""},{"$f":"IF(ISBLANK(I37),\"\",I37-I34)","v":""},{"$f":"IF(ISBLANK(J37),\"\",J37-J34)","v":""},{"$f":"SUM(B38,F38,G38,J38)","v":0}]
[]
["Manual adjustments"]
[null,null,null,null,null,{"$f":"SUM(C41:E41)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTAL: Manual adjustments",{"$f":"SUM(B41:B46)","v":0},{"$f":"SUM(C41:C46)","v":0},{"$f":"SUM(D41:D46)","v":0},{"$f":"SUM(E41:E46)","v":0},0,{"$f":"SUM(G41:G46)","v":0},{"$f":"SUM(H41:H46)","v":0},{"$f":"SUM(I41:I46)","v":0},{"$f":"SUM(J41:J46)","v":0},{"$f":"SUM(B47,F47,G47,J47)","v":0}]
[]
["Total value of funding claimed",{"$f":"SUM(B34,B47)","v":{"$error":"#REF!"}},{"$f":"SUM(C34,C47)","v":{"$error":"#REF!"}},{"$f":"SUM(D34,D47)","v":{"$error":"#REF!"}},{"$f":"SUM(E34,E47)","v":{"$error":"#REF!"}},{"$f":"SUM(C49:E49)","v":{"$error":"#REF!"}},{"$f":"SUM(G34,G47)","v":{"$error":"#REF!"}},{"$f":"SUM(H34,H47)","v":{"$error":"#REF!"}},{"$f":"SUM(I34,I47)","v":{"$error":"#REF!"}},{"$f":"SUM(J34,J47)","v":{"$error":"#REF!"}},{"$f":"SUM(K34,K47)","v":{"$error":"#REF!"}}]

{"sheet":"B1 (Summary)","index":11,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Reconciliation statement"]
[]
[null,null,null,"Adult Skills Fund",null,null,null,null,"16 to 19 provision"]
["Ref","Description","Apprenticeships (starts on or after 1 May 2017)","FM38","FM35",null,"TOTAL","Loans Bursary fund","16 to 19 study programmes","T Level programmes","TOTAL","OVERALL TOTAL"]
["a.","Balance from reviewed ILR",{"$f":"'B1 (Detail)'!B5","v":0},{"$f":"'B1 (Detail)'!C5","v":0},{"$f":"'B1 (Detail)'!D5","v":0},{"$f":"'B1 (Detail)'!E5","v":0},{"$f":"SUM(D5:F5)","v":0},{"$f":"'B1 (Detail)'!G5","v":0},{"$f":"'B1 (Detail)'!H5","v":0},{"$f":"'B1 (Detail)'!I5","v":0},{"$f":"SUM(I5:J5)","v":0},{"$f":"'B1 (Detail)'!K5","v":0}]
["b.","Adjustments from assurance review",{"$f":"'B1 (Detail)'!B10","v":{"$error":"#REF!"}},{"$f":"'B1 (Detail)'!C10","v":{"$error":"#REF!"}},{"$f":"'B1 (Detail)'!D10","v":{"$error":"#REF!"}},{"$f":"'B1 (Detail)'!E10","v":{"$error":"#REF!"}},{"$f":"SUM(D6:F6)","v":{"$error":"#REF!"}},{"$f":"'B1 (Detail)'!G10","v":{"$error":"#REF!"}},{"$f":"'B1 (Detail)'!H10","v":{"$error":"#REF!"}},{"$f":"'B1 (Detail)'!I10","v":{"$error":"#REF!"}},{"$f":"SUM(I6:J6)","v":{"$error":"#REF!"}},{"$f":"'B1 (Detail)'!K10","v":{"$error":"#REF!"}}]
["c.","Provider adjustments",{"$f":"'B1 (Detail)'!B32","v":0},{"$f":"'B1 (Detail)'!C32","v":0},{"$f":"'B1 (Detail)'!D32","v":0},{"$f":"'B1 (Detail)'!E32","v":0},{"$f":"SUM(D7:F7)","v":0},{"$f":"'B1 (Detail)'!G32","v":0},{"$f":"'B1 (Detail)'!H32","v":0},{"$f":"'B1 (Detail)'!I32","v":0},{"$f":"SUM(I7:J7)","v":0},{"$f":"'B1 (Detail)'!K32","v":0}]
["d.","Balance as per closing ILR",{"$f":"SUM(C5:C7)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["e.","Manual adjustments",{"$f":"'B1 (Detail)'!B47","v":0},{"$f":"'B1 (Detail)'!C47","v":0},{"$f":"'B1 (Detail)'!D47","v":0},{"$f":"'B1 (Detail)'!E47","v":0},{"$f":"SUM(D9:F9)","v":0},{"$f":"'B1 (Detail)'!G47","v":0},{"$f":"'B1 (Detail)'!H47","v":0},{"$f":"'B1 (Detail)'!I47","v":0},{"$f":"SUM(I9:J9)","v":0},{"$f":"'B1 (Detail)'!K47","v":0}]
["f.","Total value of funding claimed",{"$f":"SUM(C8:C9)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"FM38 & FM35 (ASF) references","index":12,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,null,null,null,"Funding rules 2024 to 2025\n(note: these rules apply only to 2024/25 starts unless stated otherwise. For starts in previous years, refer to respective funding rules)"]
["No.","Test",null,"Issue","Critical factor","References\nFor documents in HTML formal, items listed are headings on respective webpage.\nOthers references are paragraph numbers (see below for key)\n(note: these references relate to adult education provision funded by the ESFA.  For provision funded by devolved authorities, refer to the relevant devolved authority's funding rules)",null,"FM38","FM35"]
[1,"Does evidence exist to confirm that the learner is eligible for ESFA funding?","i","Eligibility for funding","The learner satisfies the ESFA's eligibility criteria.","AEB2324:\nWho we fund\nResidency eligibility \nIndividuals who are not eligible for funding\nEvidence\nEvidence Pack\nAnnex A: eligibility for funding\n\n\n","ASF2425:\nWho we fund\nResidency eligibility \nIndividuals who are not eligible for funding\nEvidence\nEvidence Pack\nAnnex A: eligibility for funding\n\n","Yes","Yes"]
[2,"Is the programme as designed eligible for funding and is the correct funding being claimed?","i","Full/co funding and approved qualifications ","Claims for full or co funding are made in accordance with the eligibility, entitlement and age criteria. The learner is working towards an applicable approved qualification. ","AEB2324:\nWhat we will not fund\nApproved qualifications\nNon-regulated learning\nLearning in the workplace\nEvidence Pack\nGovernment contribution charts\nDefinitions used in the AEB\nFull level 2\nIndividuals aged 19 to 23 (excluding English, maths, digital and ESOL)\nIndividuals aged 24 or older (excluding English, maths, digital and ESOL)\n","ASF2425:\nWhat we will not fund\nApproved qualifications\nLearning for level 2 and below (including the full level 2 entitlement), \nLearning at level 3 legal entitlement and the level 3 FCFJ\nEarnings threshold, \nUnemployed\nAnnex C: Government contribution charts","Yes","Yes"]
[null,null,"ii","Level 3 FCFJ","Claims under the FCFJ offer are in accordance with the eligibility criteria for the age of the learner and the learner is working towards an approved qualification. ","AEB2324\nFree courses for jobs\nLevel 3 free courses for jobs offer for 19 to 23-year-old learners\nESFA funded level 3 free courses for jobs offer (grant)\nAnnex C: Government contribution charts","ASF2425:\nApproved qualifications\nLevel 3 FCFJ offer\nLearning at level 3 legal entitlement and the level 3 FCFJ\nAnnex C: Government contribution charts","Yes","Yes"]
[null,null,"iii","English and maths  entitlement and assessment (ASF) ","Full funding can be claimed as part of the learners legal entitlement and where the learners age and prior attainment meet the eligibility criteria. . ","See below","ASF2425:\nEnglish, maths and digital for those aged 19 or older","Yes"]
[null,null,"iv","English and maths assessment and enrolled level (AEB)","The level on which the learner is enrolled is correctly determined by the outcome of the initial assessment.  ","AEB2324:\nEvidence Pack\nEnglish and maths for those aged 19 or older","See above",null,"Yes"]
[null,null,"v","Digital Skills ","Learners are fully funded where they meet the eligibility and age criteria, and the assessment of digital skills shows them to be below level 1. ","AEB2324:\nDigital entitlement for those aged 19 or older","ASF2425:\nDigital skills","Yes","Yes"]
[null,null,"vi","English for speakers of other languages","There must be an assessment of need for each separate qualification to support claims for additional learning to that funded through the matrix rate.","AEB2324:\nEvidence Pack\nEnglish for speakers of other languages (ESOL)\nPSM:\nSection 4, Recording learning aims: completing the Learning Delivery entity, Additional delivery hours\nFRF2324:\n57, 58","ASF2425:\nEvidence Pack\nESOL\nPSM:\nRecording learning aims: completing the Learning Delivery entity, Additional delivery hours\nFRF2425:\n64,65","Yes","Yes"]
[null,null,"vii","SWAP","There is a copy of the referral notification from Job Centre Plus confirming start date and times. ","AEB2324:\nSector-based work academy programme (SWAP)","ASF2425:\nSWAP","Yes","Yes"]
[null,null,"viii","Delivery location","The ESFA must give permission to claim funding for provision fully delivered outside England.","AEB2324:\nLearners who live in Wales, Scotland or Northern Ireland","ASF2425:\nLearners who live in Wales, Scotland or Northern Ireland","Yes","Yes"]
[null,null,"ix","Work placement for 19-24 year olds eligibility & delivery","Claims for full funding are only for those learners who meet the funding criteria. The work placement is with an employer between 70-240 hours and evidence exists to show that the employer has fulfilled their obligation. ","N/A","ASF2425:\nWork placement for 19 to 24 year olds","Yes","Yes"]
[null,null,"x","Recognition of prior learning/achievement","Any prior learning is taken into account when assessing the learner and calculating the proportion of funding remaining except for exempt qualifications. ","AEB2324:\nRecognition of prior learning (RPL)\nEvidence Pack","ASF2425:\nRecognition of prior learning (RPL)\nEvidence Pack","Yes","Yes"]
[null,null,"xi","Duplication/overlap in learning","Any duplication or overlap in learning aim content (including provision funded through another source) is considered when establishing whether a learning aim can be funded and calculating the proportion of funding remaining.","AEB2324:\nWhat we will not fund\nEvidence Pack","ASF2425:\nWhat we will not fund\n","Yes","Yes"]
[null,null,"xii","Breaks in learning","The funding rate, original learning start date, planned duration and funding adjustment for prior learning for a learner returning after a break have been correctly identified and recorded in the ILR, along with the restart indicator.","AEB2324:\nBreaks in learning\nEvidence Pack","ASF2425:\nBreaks in learning\nEvidence Pack","Yes","Yes"]
[4,"Does learner documentation meet the minimum requirements outlined in the funding rules and agree to underlying data?","i","ILR consistent with evidence pack","Funding is driven by the underlying ILR data which must agree with information confirmed by the learner in the evidence pack.","AEB2324:\nEvidence Pack\nIndividualised learner record (ILR)","ASF2425:\nEvidence Pack\nIndividualised learner record (ILR)","Yes","Yes"]
[null,null,"ii","Subcontracted provision","Provision delivered by a subcontractor, as recorded in the evidence pack, must be accurately reflected in the ILR.","AEB2324:\nEvidence Pack\nSUB2324:\n7.1, 7.2","ASF2425:\nEvidence Pack\nSUB2324:\n7.1, 7.2","Yes","Yes"]
[3,"Is the learner eligible for learning support funding and is there evidence of delivery of learning support?","i","Eligible for learning support","Learning support claimed through the ILR is evidenced by a record of the outcome of a thorough assessment, identifying the support the learner needs, in the evidence pack.","AEB2324:\nEvidence Pack\nLearning support","ASF2425:\nEvidence Pack\nLearning support","Yes","Yes"]
[null,null,"ii","Delivery of learning support","Learning support claimed through the ILR is evidenced by records of delivery of support to meet the learner's identified needs in the evidence pack.","AEB2324:\nEvidence Pack\nLearning support","ASF2425:\nEvidence Pack\nLearning support","Yes","Yes"]
[5,"Is the learner's programme and the learner's attendance as recorded in the ILR consistent with the underlying records?","i","Learning start date","Funding for a learning aim or programme can be claimed only from the date on which learning activity directly related to the learning aim or programme begins and can be evidenced.","AEB2324:\nEvidence Pack\nStarting, participating and achieving","ASF2425:\nEvidence Pack\nStarting, participating and achieving","Yes","Yes"]
[null,null,"ii","Learning activity","Funding claimed for the learner's continued participation in learning is confirmed by evidence of learning activity from the start date of each aim (i.e. up to the learning actual end date or to date, as applicable).","AEB2324:\nEvidence Pack\nStarting, participating and achieving","ASF2425:\nEvidence Pack\nStarting, participating and achieving","Yes","Yes"]
[6,"Where the learner has not achieved, does the learning actual end date recorded in the ILR agree with underlying records?","i","Learning actual end date","The learning actual end date recorded in the ILR reflects the last date that there is evidence of learning activity for each learning aim (or for any learning aim within an apprenticeship framework).","AEB2324:\nEvidence Pack\nLeaving learning","ASF2425:\nEvidence Pack\nLeaving learning","Yes","Yes"]
[null,null,"ii","Transfers","The learner has transferred to a different learning aim, framework or pathway and the correct learning actual end date, withdrawal reason and subsequent start date for the new learning aim, framework or pathway have been accurately recorded in the ILR.","PSM:\nVarious sections on Transfers","PSM:\nVarious sections on Transfers","Yes","Yes"]
[7,"Does evidence exist to confirm that the learner has achieved/completed the learning aim/framework?","i","Learning aim achievement","The achievement is correctly recorded in the ILR and is supported by evidence of achievement from the awarding organisation within three months.","AEB2324:\nEvidence Pack","ASF2425:\nEvidence Pack","Yes","Yes"]
[8,"Is there evidence that the learner is eligible for, and has evidence to support, the claim for a job outcome payment?","i","Eligible job outcome payment","Job outcome payment claimed through the ILR is for an eligible job and is supported by a learner declaration confirming that the funding conditions have been met.","AEB2324:\nEvidence Pack\nJob outcome payments\nSILR 2024/25: Other employment type Code 4. ","ASF2425:\nEvidence Pack\nJob outcome payments\nSILR 2024/25: Other employment type Code 4.  ","Yes","Yes"]
[]
["Key:"]
["AEB2324:  Adult education budget: funding and performance management rules 2023 to 2024"]
["ASF2425: https://www.gov.uk/government/publications/adult-skills-fund-funding-rates-and-formula"]
["SUB2324:  Subcontracting funding rules for post-16 education and training (excluding apprenticeships): 1 August 2023 to 31 July 2024"]
["SUB2425: https://assets.publishing.service.gov.uk/media/66697afc9d27ae501186db36/24-25_Subcontracting_funding_rules_for_post-16_education_and_training__excluding_apprenticeships_.pdf"]
["FRF2324:  ESFA Funded Adult Education Budget Funding Rates and Formula 2023 to 2024"]
["FRF2425: https://www.gov.uk/government/publications/adult-skills-fund-funding-rates-and-formula/esfa-funded-adult-skills-fund-funding-rates-and-formula-2024-to-2025"]
["PSM:  Provider Support Manual for 2023 to 2024"]
["PSM:  Provider Support Manual for 2024 to 2025"]
["SILR:  Specification of the Individualised Learner Record for 2023 to 2024"]
["SILR:  Specification of the Individualised Learner Record for 2024 to 2025"]

{"sheet":"FM81 (Standards) references","index":13,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"Carry-in apprenticeship standards\nFunding rules 2016 to 2017 apply"]
["No.","Test",null,"Issue","Critical factor","References\nParagraph numbers unless otherwise stated\n(see below for key)\n(see also SFA: common and performance management funding rules for the 2016 to 2017 funding year, paragraphs A83 to A106)"]
[1,"Does evidence exist to confirm that the learner is eligible for ESFA funding?","i","Eligibility for funding","The learner satisfies the ESFA's eligibility criteria.","SFACOM:  A17 to A25, A89.2, A90, A107 to A134, Annex A\nAPPSTD:  D59"]
[2,"Are the learner and employer eligible and has the programme been correctly identified and coded?","i","Age","Apprentices must be aged 15 or over and have legally left school.","SFACOM:  A18.2"]
[null,null,"ii","Employed status","Apprentices undertaking apprenticeship standards must be employed (except those that satisfy the conditions for redundancy).","APPCOM:  B3\nAPPSTD:  D58, D137 to D139, D165"]
[null,null,"iii","Employer declaration","Employers must confirm the eligibility of their apprentices as well as their eligibility for incentive payments through a signed employer eligibility declaration.","APPSTD:  D111, D119, D131, D149.1, D165"]
[null,null,"iv","Minimum hours of employment","Apprentices are employed for at least 16 hours per week.","APPCOM:  B18.1, B18.5.1, B18.5.6, B19, B20, B22"]
[null,null,"v","Apprenticeship training agencies (ATAs)","Only recognised ATAs can directly employ apprentices only to deliver an apprenticeship.","APPCOM:  B14 to B17"]
[null,null,"vi","Alternative completion conditions","Unemployed and self-employed apprentices must satisfy alternative completion conditions to be eligible.","APPCOM:  B9"]
[3,"Is the programme as designed eligible for funding and is the correct funding being claimed?","i","Correct funding rates","The correct funding cap and incentive payments for the apprenticeship depend upon the accuracy of the apprenticeship standard value derived from LARS and recorded in the ILR.","APPSTD:  D20, D154.1"]
[null,null,"ii","Negotiated price","The agreed price for training and end-point assessment required for the apprenticeship standard as recorded in the written agreement must be accurately recorded in the ILR.","APPSTD:  D21, D26, D29, D90, D168, D179"]
[null,null,"iii","Mandatory qualifications","The learner is funded only for eligible training to meet the requirements of the end-point assessment as specified by the standard and set out in the commitment statement and written agreement.","APPSTD:  D87, D97 to D99, D154.2"]
[null,null,"iv","English and maths","Learners must be enrolled on, study and take the test for level 2 English and/or maths where they have not already achieved this level of English and/or maths prior to starting, unless they are assessed as needing to study level 1 first.","SFACOM:  A89.3\nAPPSTD:  D41, D43 to D46"]
[null,null,"v","Recognition of prior learning","Any prior learning towards a regulated or accredited qualification is taken into account when assessing the learner and determining the price.","SFACOM:  A35 to A38, A89.4, A92.2\nAPPSTD:  D31, D165"]
[null,null,"vi","Duplication of funding or learning","Any duplication or overlap in learning aim content (including provision funded through another source) and repetition of learning already carried out to achieve a qualification is considered when establishing whether a learning aim can be funded as part of an apprenticeship and determining the price.","SFACOM:  A28, A30, A31, A89.4, A106\nAPPCOM:  B7\nAPPSTD:  D90.8"]
[null,null,"vii","Apprenticeship duration","The apprenticeship must satisfy the minimum duration requirements, both planned and actual.","SFACOM:  A92.4\nAPPCOM:  B23, B24, B29\nAPPSTD:  D57"]
[null,null,"viii","Planned duration for part-time programme","The planned duration of the programme has been extended accordingly to account for the learner's part-time hours.","APPCOM:  B18.5.4, B28"]
[null,null,"ix","Delivery location","The ESFA must give permission to claim funding for provision fully delivered outside England.","SFACOM:  A29"]
[null,null,"x","Distance learning","The ESFA will not fund an apprenticeship that is delivered only by distance learning.","APPCOM:  B8"]
[null,null,"xi","Breaks in learning","The ILR must be correctly updated to reflect a break in learning, as evidenced in the apprenticeship evidence pack.","SFACOM:  A39 to A42, A89.4\nAPPSTD:  D135, Table 2"]
[4,"Does learner documentation meet the minimum requirements outlined in the funding rules and agree to underlying data?","i","ILR consistent with apprenticeship evidence pack","Government contributions (including incentives) are driven by the underlying ILR data which must agree with information confirmed by the learner in the apprenticeship evidence pack.","SFACOM:  A84 to A93, A103, A104\nAPPSTD:  D164, Table 2\nSILR"]
[null,null,"ii","Written agreement and commitment statement","Government co-payments cannot be claimed without a copy of the written agreement between the provider and employer and the commitment statement agreed by the apprentice, provider and employer, both fulfilling the minimum requirements of the funding rules.","APPSTD:  D69, D147.1, D147.2, D148 to D155, D165"]
[null,null,"iii","Subcontracted provision","Provision delivered by a subcontractor, as recorded in the apprenticeship evidence pack, must be accurately reflected in the ILR.","SFACOM:  A63.2, A91\nAPPSTD:  D71, D72, D165"]
[5,"Is the learner eligible for learning support funding and is there evidence of delivery of learning support?","i","Eligible for learning support","Learning support claimed through the ILR is supported by an assessment and there is a planned programme of support included in the learning agreement.","SFACOM:  A89.8\nAPPCOM:  B35, B36.1, B36.2, B36.4, B36.5\nAPPSTD:  D149.6, D165"]
[null,null,"ii","Delivery of learning support","Learning support claimed through the ILR is supported by evidence of delivery of the planned programme of support included in the learning agreement.","SFACOM:  A89.8\nAPPCOM:  B36.3\nAPPSTD:  D165"]
[6,"Is the learner's programme and the learner's participation as recorded in the ILR consistent with the underlying records?","i","Learning start date","Funding can be claimed only from the date on which learning activity directly related to the apprenticeship standard, or learning aim (for English/maths), begins and can be evidenced.","SFACOM:  A89.9, A97\nAPPSTD:  D165"]
[null,null,"ii","Learning activity","The learner's continued participation in learning (including English and maths) is confirmed by evidence of learning activity from the start date of each aim up to the learning actual end date or to date, as applicable.","SFACOM:  A89.9, A98\nAPPSTD:  D147.3, D147.4"]
[null,null,"iii","Learning aim achievement","The achievement of a component aim is correctly recorded in the ILR field Outcome and is supported by evidence of achievement from the awarding organisation within three months.","SFACOM:  A89.12"]
[7,"Where the learner completes or leaves the programme, does the learning actual end date recorded in the ILR agree with underlying records?","i","Learning actual end date","The learning actual end date recorded in the ILR reflects the last date that there is evidence of learning activity for any part of the standard, except where a learning aim has been completed at an earlier date and recorded as such.","SFACOM:  A89.9, A101, A102\nAPPSTD:  Table 2\nSILR:  Learning actual end date field in Learning Delivery entity"]
[null,null,"ii","Transfers","The learner has transferred to a different standard and the correct learning actual end date, withdrawal reason and subsequent start date for the new standard have been accurately recorded in the ILR.","PSM:  Various sections on Transfers"]
[8,"Does evidence exist to confirm eligibility for incentive payments to be made to the provider (where applicable)?","i","16- to 18- year old apprentice","The apprentice's date of birth confirms that they were aged 16, 17 or 18, or were a care leaver, when they started their apprenticeship and, together with the employer declaration, confirms eligibility for an incentive payment for employing an apprentice aged 16 to 18.","APPSTD:  D33, D76, D77, D80 to D83, D113, D131, D149.1, D165"]
[null,null,"ii","Small employer","The employer declaration confirms that the employer has 49 or fewer paid full or part-time employees and so confirms eligibility for an incentive payment for an employer with fewer than 50 staff.","APPSTD:  D33, D76 to D79, D113, D131, D149.2, D165"]
[null,null,"iii","Completion","As well as eligibility for incentive payment via the employer declaration, the achievement is supported by an apprenticeship completion certificate within three months or, in lieu of this, by evidence of successful end-point assessment, an employer claim form confirming satisfactory completion and a request for a completion certificate.","SFACOM:  A89.12, A99\nAPPCOM:  B29\nAPPSTD:  D33, D76, D77, D85, D113, D131, D165"]
[null,null,"iv","Achievement date","The achievement date recorded in the ILR reflects the date on which the learner meets the criteria for a completion incentive payment","APPSTD:  D85.4"]
[]
["Key:"]
["SFACOM:  Skills Funding Agency: common and performance management funding rules for the 2016 to 2017 funding year"]
["APPCOM:  Apprenticeships: common funding and performance management rules for the 2016 to 2017 funding year"]
["APPSTD:  Apprenticeship standards funding rules 2016 to 2017"]
["PSM:  Provider Support Manual for 2021 to 2022"]
["SILR:  Specification of the Individualised Learner Record"]
["For starts in prior years, refer to respective year's funding rules"]

{"sheet":"FM36 (Apps) references","index":14,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Funding rules August 2023 to July 2024\n(note: these rules apply only to 2023/24 starts unless stated otherwise. For starts in previous years, refer to respective funding rules)"]
["No.","Test",null,"Issue","Critical factor","References\n(see below for key)"]
[1,"Does evidence exist to confirm that the learner is eligible for ESFA funding?","i","Eligibility for funding","The learner satisfies the ESFA's eligibility criteria:\n- Apprentices must be aged 15 or over and have legally left school;\n- The individual must be able to complete the apprenticeship within the planned duration;\n- The individual must not contribute to the cost of their apprenticeship (including using a student loan);\n- The individual must have an eligible residency status per Annex A;\n- The individual must have the right to work in England;\n- Apprentices must spend at least 50% of their working hours in England;\n- The individual must not be undertaking another apprenticeship or other DfE funded programme at the same time; and\n- Individuals in prison must meet the rules to be eligible for apprenticeship funding.","Learner Eligibility, \nEligibility Criteria,  \nPrisoner Apprenticeships,\nAnnex A: Eligibility Criteria (who we fund). "]
[2,"Are the learner and employer eligible and has the programme been correctly identified and coded?","i","Employed status (not self employed)","Apprentices must be employed until the end point assessment is complete (except those that satisfy the conditions for redundancy or for particular office holders who are alternative apprentices).\nApprentices must not be self employed as a sole trader or as a shareholder or director with no separate identifiable person to undertake the role of employer.","Individuals who are eligible for funding,\nIndividuals who are not eligible for funding,\nEmployment arrangements (between the employer and the apprentice),\nAlternative English apprenticeship,\nFlexi-Job Apprenticeship Agencies (FJAAs),\nPrisoner Apprenticeships,\nEnd-point assessments,\nBreaks in learning."]
[null,null,"ii","National minimum wage","Apprentices must be paid a lawful wage for the time they are in work and in off the-job training.","Apprentice wages."]
[null,null,"iii","Redundancy","Apprentices can continue to participate in their training if they are made redundant and meet the eligibility criteria, and have specified evidence available.\nThe provider must have evidence of any support given to the apprentice to find a new employer and evidence of apprenticeship part-completion, where applicable.","Individuals who are eligible for funding,\nEpisodes of learning below the minimum duration requirement,\nEnd-point assessments,\nBreaks in learning,\nRedundancy."]
[null,null,"iv"," Flexi-Job Apprenticeship Agencies (FJAAs)","Main providers must hold documented details of the apprentice’s placement(s).  This includes the name of the host employer(s) and the duration of the placement(s). ","Rules for employers (including employer-providers and Flexi-Job \nApprenticeship Agencies),\nFlexi-Job Apprenticeship Agencies (FJAAs)."]
[3,"Is the programme as designed eligible for funding and is the correct funding being claimed?","i","Negotiated price","The provider must breakdown the total negotiated price associated with the delivery of training and on-programme assessment (TNP1) and agreed this with the employer.  Only eligible costs should be included and actual costs only where applicable.\nThe provider has entered the agreed price for end-point assessment (if known) in TNP2 on the ILR, has not used an estimate and has a written agreement with the EPAO.\nAll changes in price to TNP1 or TNP2 (and reason) must be agreed by the employer.","\nTaking account of prior learning and experience (all learners),\nEligible costs,\nEnd-point assessments,\nThe price of an apprenticeship."]
[null,null,"ii","English and maths","Apprentices must hold or achieve English and maths qualifications as per the funding rule requirements and additional information should be held where the apprentice is assessed as exempt from the normal English and maths requirements (note any impact of duplication of funding or learning).","\n\nRecognition of prior learning and experience,\nSupport for English and maths training,\nJudgement of an apprentice’s current level\nExceptions to the regular English and maths minimum requirements, for people with special educational needs, learning difficulties or disabilities\nThe outcome of the initial assessment"]
[null,null,"iii","Prior learning Knowledge, skills and behaviours: Assessment","There must be an appropriate assessment of the apprentice's knowledge, skills and behaviours prior to commencing the apprenticeship.  \n\nThe initial assessment must meet the funding rules and be documented.","\nInitial assessment,\nRecognition of prior learning and experience,\nThe outcome of the initial assessment\n"]
[null,null,"iv","Prior learning Knowledge, skills and behaviours: \nOutcome","The outcome of the assessment of prior learning, knowledge, skills & behaviours and initial assessment must be agreed with the employer and documented as per the rules.  Note any impact of duplication of funding or learning.","\nInitial assessment,\nRecognition of prior learning and experience,\nThe outcome of the initial assessment,\nThe price of an apprenticeship"]
[null,null,"v","Apprenticeship duration","The apprenticeship must satisfy the 12 month minimum duration requirements, both planned and actual.  This is after the content, duration and price have been adjusted to recognise prior learning.\nThe planned duration of the programme has been extended accordingly to account for the learner's part-time or zero hour contracts.","Minimum duration of practical period,\nChange of circumstance"]
[null,null,"vi","Breaks in learning","A break in learning must be used where applicable.  The ILR must be correctly updated to reflect a break in learning, which reconciles to the information recorded in the evidence pack (including any amendments made to off-the-job hours).","Delivering off-the-job training,\nBreaks in learning,\nMaternity, adoption and shared parental leave"]
[4,"Does learner documentation meet the minimum requirements outlined in the funding rules and agree to underlying data?","i","ILR consistent with evidence pack","Government contributions (including additional payments) are driven by the underlying ILR data which must agree with information confirmed by the learner in the evidence pack (e.g. postcode and date of birth), including planned and actual off-the job training hours in the respective ILR fields.  This also includes the correct recording of the data fields used to match with apprenticeship service for funding purposes.","Throughout document"]
[null,null,"ii","Apprenticeship agreement","There must be a valid apprenticeship agreement signed by the employer and apprentice from the start of, and for the actual duration of the apprenticeship programme that is complete and meets the funding rules. The agreement must not be signed by the same person acting as both the apprentice and the employer.  The apprenticeship agreement must be revised to account for any breaks in learning or applicable changes.","Apprenticeship agreement (between the employer and the apprentice),\nThe training plan,\nBreaks in learning\nRedundancy."]
[null,null,"iii","Training plan","There must be an up-to-date training plan setting out the minimum requirements of the funding rules, signed and dated by the apprentice, main provider and employer, agreed prior to delivery.  Evidence that progress is being made towards the plan. Normal working hours must be included along with confirmation that the apprentice will be allowed to undertake off-the-job training within their normal working hours in addition to English and maths training if required.","The training plan"]
[null,null,"iv","Off the Job calculation and plan","Following initial assessment, the off-the-job training must equate to at least a minimum of 20% of the apprentice's normal working hours (capped at 30 hours per week for full time) over the planned duration of the apprenticeship practical period once statutory annual leave has been deducted. The duration must be extended for apprentices working less than 30 hours.\n\nThe number of planned off-the-job training hours must be documented on the apprenticeship agreement, training plan and the ILR and reconcile.","Off-the-job training,\nSee also: Guidance: Apprenticeships: off-the-job training (https://www.gov.uk/government/publications/apprenticeships-off-the-job-training)"]
[null,null,"v","Subcontracted  provision eligible","Provision delivered by a subcontractor, must be eligible, meet the evidence pack requirements and accurately reflected in the ILR. The provider must directly deliver some of the apprenticeship training and / or on-programme assessment","Subcontracting"]
[5,"Is the learner eligible for learning support funding and is there evidence of delivery of learning support?","i","Eligible for learning support","Learning support claimed through the ILR is supported by an assessment that demonstrates the apprentice's learning difficulty or disability and there is a planned programme of support including details of the identified reasonable adjustment required. ","Apprentices who need access to learning support \n\nSee also: Guidance: Support for apprentices with a learning difficulty or disability\n\nhttps://www.gov.uk/government/publications/support-for-apprentices-with-a-learning-difficulty-or-disability"]
[null,null,"ii","Delivery of learning support","Learning support claimed through the ILR is confirmed by evidence of delivery of support to meet the reasonable adjustments and confirm the continuing necessity and appropriateness, evidenced by reviews.","Apprentices who need access to learning support \n\nSee also: Guidance: Support for apprentices with a learning difficulty or disability\n\nhttps://www.gov.uk/government/publications/support-for-apprentices-with-a-learning-difficulty-or-disability"]
[6,"Is the learner's programme and the learner's participation as recorded in the ILR consistent with the underlying records?","i","Learning start date","Funding can be claimed only from the date on which learning activity directly related to the apprenticeship, or learning aim (for English/maths), begins and can be evidenced.","Apprenticeship agreement (between the employer and the apprentice). \nDelivering off-the-job training\nThe training plan,\nSupport for English and maths training."]
[null,null,"ii","Learning activity","The learner's continued participation in learning (including English and maths) is confirmed by evidence of learning activity.  The apprentice must be involved in active learning (off-the-job training or English and maths training) every calendar month (every 3 calendar months for front-loaded and block release models) throughout the apprenticeship from the learning start date to the learning actual end date (the practical period).","Off-the-job training,\nSupport for English and maths training."]
[null,null,"iii","Learning aim achievement","The achievement of a component aim, including English and maths, is correctly recorded in the ILR field Outcome and is supported by evidence of achievement from the awarding organisation.","Support for English and maths training,\nCertification."]
[null,null,"iv","Off-the-job training delivery for apprentices on programme","Where an apprentice is still on programme, the evidence pack must contain evidence of the actual off-the-job training hours delivered to date including what the activity / session was. Evidence must be available that delivery meets the definition of off-the-job training.","Off-the-job training,"]
[7,"Where the learner completes, leaves or transfers from the programme, does the  ILR agree with underlying records?","i","Learning actual end date","The learning actual end date (the date when learning towards the apprenticeship is complete) recorded in the ILR reflects the last date that there is evidence of learning activity.","Change of circumstance,\nOff-the-job training."]
[null,null,"ii","Transfers of programme, employer or provider","The learner has transferred to a different employer, provider, programme or learning aim and the correct learning actual end date, withdrawal reason and subsequent start date have been accurately recorded in the ILR.","Change of circumstance."]
[null,null,"iii","Completion of practical period and/or programme","Actual off-the-job hours at the end of practical period:\nWhere an apprentice has completed all learning activities, the evidence pack must contain evidence that the actual off-the-job training hours delivered meet the minimum calculation and definition of off-the-job training.\nActual hours should reconcile to the hours recorded in the ILR (exceptions to this requirement apply).\nWhere the volume of off-the-job training hours delivered is less than the original volume of planned hours agreed at the beginning of the programme with the employer, there is a statement on file to explain the difference which meets the funding rule requirements.\n\nPayment:\nThe completion payment is supported by evidence of completion of end point assessment and supported by evidence of achievement/outcome, evidence that the minimum duration requirement has been met, and, where applicable, evidence that the total employer's co-investment has been collected and recorded.","End-point assessments,\nOff-the-job training."]
[8,"Where the employer or training provider are required to make payments, does evidence exist that the payments have been made?","i","Payment of employer co-investment","The employer co-investment recorded in the ILR is evidenced by a transfer of funding visible in the provider's (or subcontractor's) financial systems; this will typically be in the form of a provider invoice and corresponding employer payment to the provider.  For employer-providers, they must evidence how they have calculated costs.","Employer co-investment."]
[9,"Does evidence exist to confirm eligibility for additional payments made to the provider (where applicable)?","i","16- to 18- year old apprentice","The apprentice's date of birth confirms that they were aged 16, 17 or 18 when they started their apprenticeship and confirms eligibility for an additional payment for employing a young apprentice.  Evidence of payment to employer as per funding rules.","Additional payments for employers, providers and apprentices"]
[null,null,"ii","Relevant 19- to 24- year olds","The apprentice's date of birth confirms that they were aged between 19 and 24 when they started their apprenticeship, and evidence held to confirm they have either an EHC plan or have been in the care of the local authority and consent to inform their employer.  Evidence of payment to employer as per funding rules.","Additional payments for employers, providers and apprentices"]
[null,null,"iii","Care leavers bursary","Apprentices satisfying the definition of a care leaver are eligible for a payment. Evidence should be held to support eligibility and payment to the learner as per funding rules.","Additional payments for employers, providers and apprentices"]
[null,null,"iv","Small employer","For prior year starts: There must be a statement from the employer, along with evidence, confirming eligibility that they had an average of 49 or fewer employees with a contract of service in the 365 days before the apprentice was recruited. This must be obtained before the apprentice starts.","Refer to previous year rules under section Employer co-investment.\n\n"]
[10,"Is there sufficient evidence to demonstrate that the provider has met its obligations with regard to the end-point assessment process?","i","Contractual arrangements","There must be evidence of a written agreement with the end point assessment organisation (EPAO) for conducting the end-point assessment where appropriate.\nThere must be evidence to demonstrate payments made by the provider to the EPAO for end-point assessment have been made as per the contract.","End-point assessments"]
[null,null,"ii","Gateway assessment","There must be records and evidence of completion of the end-point assessment / end point assessment requirements along with evidence that the learner is still employed upon completion of the end-point assessment.","End-point assessments"]
[]
["Key:"]
["APP:  Apprenticeship funding rules August 2023 to July 2024"]
["For starts in prior years, refer to respective year's funding rules"]

{"sheet":"Loans references","index":15,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Funding rules 2023 to 2024\n(note: these rules apply only to 2023/24 starts unless stated otherwise. For starts in previous years, refer to respective funding rules)"]
["No.","Test",null,"Issue","Critical factor","References\nParagraph numbers\n(see below for key)","Loans"]
[1,"Do learner and programme details as recorded in the learning and funding information letter, the loans portal, the learning agreement and the ILR agree?","i","ILR consistent with learner file","Underlying ILR data must agree with information confirmed by the learner in the learner file.","ALL:  22","Yes"]
[null,null,"ii","ILR consistent with loans portal","Information in the learner file, returned to the ESFA in the ILR, must match the data returned to the SLC via the loans portal where applicable.","ALL:  16.2, 16.3, 22","Yes"]
[null,null,"iii","Learning and funding information letter","The model learning and funding information letter, available on the GOV.UK website, must be used to create the learner's learning and funding information letter.","ALL:  6, 16.1, 19.1","Yes"]
[null,null,"iv","Entitlement to full funding","Learners aged 19 and above without an existing full level 3 or equivalent can be funded by a loan only where they have waived their right to be fully funded either as part of their legal entitlement or through the level 3 free courses for jobs offer.","ALL:  6","Yes"]
[null,null,"v","Delivery outside England","All loans funded provision must be delivered in England.","ALL:  6, 9","Yes"]
[null,null,"vi","Delivery location postcode","The delivery location postcode recorded in the ILR informs the area cost uplift that is applied to claims for loans bursary funding.","ALL:  17.7, 30","Yes\n(Bursary)"]
[2,"Is the learner's programme and the learner's attendance as recorded in the ILR and on the loans portal consistent with the underlying records?","i","Learning activity","The learner's continued participation in learning is confirmed by evidence of learning activity from the start date of each aim (i.e. up to the learning actual end date or to date, as applicable).","ALL:  16.4 (In learning)","Yes"]
[null,null,"ii","Change of circumstances & transfers","Any change is accurately recorded in the ILR, and this matches the loans portal.  A new learning and funding information letter is issued where applicable.","ALL:  16.4 (If a learner's circumstances change, Learner transfers), 19.1","Yes"]
[null,null,"iii","Learning actual end date","The learning actual end date recorded in the ILR and the loans portal reflects the date of completion or the last date that there is evidence of learning activity for each learning aim.","ALL:  19.1","Yes"]
[null,null,"iv","Breaks in learning","A break in learning must be accurately recorded in the ILR and on the loans portal.","ALL:  16.4 (Breaks in learning)","Yes"]
[null,null,"v","Subcontracted provision","Providers must directly deliver loans funded provision.","ALL:  7","Yes"]
[3,"Where the learner has received Advanced Learner Loans Bursary Fund support, is the learner eligible for the funding as coded in the ILR?","i","Eligible for loans bursary funding","Loans bursary funding claimed through the ILR is supported by evidence of an assessed need.","ALL:  17","Yes\n(Bursary)"]
[null,null,"ii","Correct fixed rate used","The fixed rate claimed must reflect the criteria for the respective rate.","ALL:  18.1, 18.2","Yes\n(Bursary)"]
[]
["Key:"]
["ALL:  Advanced Learner Loans funding rules: 2023 to 2024"]
["For starts in prior years, refer to respective year's funding rules"]

{"sheet":"FM25 (16 to 19) guidance","index":16,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Funding regulations for young people 2023 to 2024\n(note: these regulations apply only to 2023/24 starts unless stated otherwise. For starts in previous years, refer to respective funding rules)"]
["No.","Test",null,"Issue","Critical factor","References\nParagraph numbers\n(see below for key)","Guidance to auditors","Outcome for negative responses","Current year funding impact","Lagged funding impact only","Study programmes","T Levels"]
[1,"Has the institution correctly assessed that the student is eligible for ESFA funding?","i","Eligibility for funding","The student satisfies the ESFA's eligibility criteria.","FR:  11, 26 to 83\n\nNote: Students may be over 19 if they are still on a programme which they began pre-19 at either sixth form colleges or academies or up to 25 years old if they are classified as 'high needs'.\n\nSpecific references within above to 19 to 24 year olds:\nFR:  11b, 45 to 47","General:\n•  Check eligibility for residency, age (institution management must check enrolment forms to see if evidence has been gathered on the residency status and eligibility of the student).\n•  For age, the critical funding audit issue is has the student's date of birth been correctly recorded in the ILR and is it consistent with the Source of funding field.  If the date of birth is correctly recorded for all students, only those over the age of 25 at the start of any funding year are rejected for 16 to 19 funding purposes.  It is a funding error if any student is recorded as a 19+ continuing student whilst not continuing to study learning aims started when they were funded as a 16 to 19 year old student (students are only eligible for funding if they meet the criteria in paragraphs 45 and 46 of the funding regulations.\n\nHNS (High Needs Students):\n•  Check eligibility for 19 to 24 funded students, high needs eligibility.\n•  Students aged 19 to 24 are only eligible for ESFA funding for young people if they are high needs students (see test 2) and have an Education, Health and Care plan.  If this is incorrectly recorded in the ILR then the funding may also be incorrect.\n•  If this is not available on site, is there evidence that one exists, e.g. an email or other documentation between the institution and the LA?","General:\n•  Funding error if the student is not eligible for funding.  Funding error if any student recorded as a 19+ continuing student is not continuing to study learning aims started whilst they were funded as a 16 to 19 year old student.  The institution must amend its data return to record such students as not eligible for ESFA funding.\n•  Control error if documentation not as per guidance.  Note that for ILR funded students, FIS automatically screens out over-age students (i.e. 25+) so they are not normally a funding error if the date of birth is correctly recorded.\n\nHNS:\nFor 19 to 24 year old students with no EHC plan, internal control weakness if:\n•  institution is not able to provide a copy of the EHC plan for post-19 students identified in the audit sample;\nand there is no evidence of:\n•  LA confirming it has implemented/is planning to implement an EHC plan; or\n•  institution requesting a copy of the EHC plan; or\n•  institution requesting an EHC plan be undertaken by the LA, i.e. where the LA has indicated the young person should be subject to one.\nFunding errors should only be recorded on the audit report for 19 to 24 year old high needs students where the institution has not provided the necessary evidence (bullets above or evidence of element 3 funding via LA) within the audit response timeframe, to confirm the student is eligible to receive ESFA funding.","Yes","Yes","Yes","Yes"]
[2,"Does the learning agreement, enrolment form and/or timetable agree to the ILR in terms of data, including eligibility for free meals in FE?","i","ILR consistent with learning agreement","Funding is driven by the underlying ILR data which must agree with information confirmed by the student in the learning agreement.","FR:  20 to 22, 80 to 83\n\nFree Meals in FE guidance:\nhttps://www.gov.uk/guidance/16-to-19-funding-free-meals-in-further-education-funded-institutions","Compare records.\n\nFree Meals in FE\n•  The criteria for recording students in the ILR in 2024 to 2025 to support future allocations for free meals in FE are set out in the ILR section. \n•  Advice on eligibility is set out in student eligibility section. \n•  Advice on the necessary verification of student eligibility is also set out on the webpage. (Eligible students are recorded in ILR field Learner FAM type/code Free meals eligibility (FME) 1 or 2).","•  If the ILR shows a study programme or T Level programme which the student is not doing, or the total planned hours (after qualifying period) are overstated, this may constitute a funding error if the correct number of planned hours falls into a lower band from that which has been recorded.\n•  Please note that if the correct number of planned hours falls into a higher band from that which has been recorded, then the understatement should also be reported.\n•  Otherwise it is a control issue.\n\nFree Meals in FE\n•  Students must be correctly recorded to count for future allocation lagged funding numbers.  \n•  Errors will not usually affect the current year funding values but will affect future funding allocations.","Yes\n(except Free Meals in FE)","Yes","Yes","Yes"]
[3,"Has the learning agreement, enrolment form and/or timetable been signed by both the student and the institution?","i","Confirmation of learning agreement","The learning agreement must be signed/confirmed by the student and the institution.","FR:  80 to 83, 145 to 152","Check for signed documents, including guidance for electronic signatures.","This will usually be an internal controls issue, unless there is the possibility that the student did not commence the study programme or does not exist (rare).","Control usually","Control usually","Yes","Yes"]
[4,"Is there evidence that the student has been provided with IAG, an Initial assessment, a learning plan and other base documentation (including timetable if applicable)?","i","Base documentation","There must be evidence that the student has been provided with documentation (including IAG, initial assessment, learning agreement and timetable if applicable).","FR:  80 to 83","Check that the learning agreement, enrolment form and/or timetable includes all of the key details as per paragraph 82 of the funding regulations.","•  Not a funding error at an individual student level.\n•  If it is apparent that any groups of students have been enrolled on a programme of study which is not appropriate for their needs then this should be referred to the ESFA Funding Allocation and Student Support (FASS) team for further discussions as this may constitute a funding error.","Control usually","Control usually","Yes","Yes"]
[5,"Is the requirement to study English, is there evidence to support the values recorded in the ILR?","i","Requirement or exemption from requirement to study English","The values recorded in the ILR for GCSE English qualification grade and Learner FAM type GCSE English condition of funding (ECF) must be accurately completed to support any exemption from condition of funding for English.","FR:  15, 204 to 217\n\nCondition of funding guidance:\nhttps://www.gov.uk/guidance/16-to-19-funding-maths-and-english-condition-of-funding","Check that the two fields in the ILR pertaining to the condition of funding have been correctly completed. These are:\n•  Learner FAM type GCSE English condition of funding (ECF)\n  - code 1: Learner is exempt from GCSE English condition of funding due to a learning difficulty or disability\n  - code 2: Learner is exempt from GCSE English condition of funding as they hold an equivalent overseas qualification\n  - code 3: Learner has met the GCSE English condition of funding as they hold an approved equivalent UK qualification.\n•  ILR field GCSE English qualification grade, which must be evidenced for grades A* to D or 9 to 3.\n\nThis note applies to both tests 5 and 6\n•  Please note that the only acceptable evidence to support exemption due to overseas qualification is information obtained from UK NARIC.  Evidence to support exemption in accordance with the guidance together with evidence of disability\n•  statement of Special Educational Need (SEN) or an Education Health (EHC) Care plan, AND\n•  an evidenced assessment that the student is not able to study these subjects, authorised by an appropriate professional in the institution such as the head of SEN or Student Support; the assessment should be structured and documented.","•  Students must be correctly recorded to count for future allocation lagged funding numbers.\n•  Errors will not usually affect the current year funding values but will affect future funding allocations.","No","Yes","Yes","Yes"]
[6,"Is the requirement to study maths, is there evidence to support the values recorded in the ILR?","i","Requirement or exemption from requirement to study maths","The values recorded in the ILR for GCSE maths qualification grade and Learner FAM type GCSE maths condition of funding (MCF) must be accurately completed to support any exemption from condition of funding for maths.","FR:  15, 204 to 217\n\nCondition of funding guidance:\nhttps://www.gov.uk/guidance/16-to-19-funding-maths-and-english-condition-of-funding\n","Check that the 2 fields in the ILR pertaining to the condition of funding have been correctly completed. These are:\n•  Learner FAM type GCSE maths condition of funding (MCF)\n  - code 1: Learner is exempt from GCSE maths condition of funding due to a learning difficulty or disability\n  - code 2: Learner is exempt from GCSE maths condition of funding as they hold an equivalent overseas qualification\n  - code 3: Learner has met the GCSE maths condition of funding as they hold an approved equivalent UK qualification.\n•  ILR field GCSE maths qualification grade, which must be evidenced for grades A* to D or 9 to 3.\n\nThis note applies to both tests 5 and 6\n•  Please note that the only acceptable evidence to support exemption due to overseas qualification is information obtained from UK NARIC.  Evidence to support exemption in accordance with the guidance together with evidence of disability\n•  statement of Special Educational Need (SEN) or an Education, Health and Care (EHC) plan, AND\n•  an evidenced assessment that the student is not able to study these subjects, authorised by an appropriate professional in the institution such as the head of SEN or Student Support; the assessment should be structured and documented.","•  Students must be correctly recorded to count for future allocation lagged funding numbers.\n•  Errors will not usually affect the current year funding values but will affect future funding allocations.","No","Yes","Yes","Yes"]
[7,"Has the correct learning aim been recorded as the core learning aim?","i","Core aims","The correct learning aim must be recorded as the core learning aim.","R&F:  65 to 74","The aim of this test is not for auditors to determine what is or is not a core aim.  It is a data check where auditors must ensure that the core aim of the study programme as agreed on the learning plan or learning agreement has been recorded accurately in the ILR.\nHowever, note that when a student has work experience as the core aim of their study programme, it must be an external placement.  Should the work experience consist predominantly of internal work placement(s), it must not be the core aim.\nPlease note that the core aim is used:\na. to calculate future programme cost weighting;\nb. to determine whether a student is retained on the programme or not, for future funding retention factors; and\nc. whether the programme consists of substantial qualification, work experience or other.\nIMPORTANT NOTE:  Please do not use the terminology \"academic\" or \"vocational\" qualification but use \"substantial qualification, work experience or other\".","•  Funding error if the work experience learning aim is recorded as a core aim but contains only internal work placements (excludes high needs students and those with an EHC plan).\n\nOtherwise:\n•  No funding impact expected in current year from recording the wrong core aim as this simply affects \"lagged funding factors\".\n•  Possible funding error for future allocations only - if the core aim in the ILR is not the core aim on the learning plan and, as a result, the correct aim would bring the programme cost weighting down for future funding allocations.\n•  Hence a data error and not a funding error for 2023/24.\n•  Otherwise it will be a control issue.","Yes","Yes","Yes","Yes"]
[8,"Are the activities included in the programme eligible activities?","i","Eligible study programme activities","The activities included in the study programme must be relevant, planned and must take place during the institution's normal working pattern to be eligible.","FR:  92 to 115, 133 to 139, 165, Annex B\nR&F:  45 to 51, 88 to 90","•  Please review the study programme to ensure that activities (whether qualification or non-qualification) that are not eligible to be funded (as detailed in the funding guidance) are not included in the planned hours.\n•  Note that non-qualification planned hours must be less than 50% of the study programme's total planned hours (except for high needs students and students with an Education, Health and Care plan).\n•  Providers must be able to demonstrate and evidence costs that are reasonable and proportionate to the funding generated by non-qualification hours (Annex B).\n•  The guidance allows study hours delivered for withdrawn learning aims before the start criteria is met to be included in total study hours for the year where this affects the funding band for the student.\n•  Neither paid employment nor paid work experience is eligible to count as fundable non-qualification hours without prior ESFA approval.","Possible funding error if, by excluding the ineligible activities, the planned hours would reduce the study programme to part-time or a lower band.","Yes","Yes","Yes"]
[null,null,"ii","Eligible T Level programme activities","The activities included in the T Level programme must be relevant, planned and, with the exception of the industry placement, must take place during the institution's normal working pattern to be eligible.","R&F:  14 to 18, 39 to 44, 52, 68, 69, 122, 123,  137, 148, 152 to 154, 157, 176 to 178","•  Please review the T Level programme to ensure that the planned hours do not include industry placements, English and maths study, and additional qualifications that are not required for completion of the T Level.\n•  Please also review the T Level programme to ensure that activities (whether qualification or non-qualification) that are not eligible to be funded (as detailed in the funding guidance) are not included in the planned hours.","Possible funding error if English, maths, industry placements or any ineligible activities are included in T Level planned hours.\nPossible funding error if, by excluding any parts of the T Level requirements that are not delivered over the course of the two year programme, the programme becomes ineligible for funding (note: mainly a year 2 issue in T Levels).\nFor funding audit purposes the error reporting is only necessary where part of T level delivery does not match delivery recorded in the ILR.  If student data record shows T Level requirements are not met, this is a matter for 16 to 19 funding directorate through monitoring reports.","Yes","Yes",null,"Yes"]
[9,"Has the number of planned hours been correctly recorded in the ILR?","i","Planned hours","The number of study programme planned hours for the academic year must be correctly recorded in the ILR and supported by evidence.","FR:  82, 98, 99, 125 to 139, Annexes B and C\nR&F:  33 to 52, 88 to 90","See important advice on recording study programme planned hours in paragraphs 98, 99 and 125 to 132 of the funding regulations\n\n•  Data check:  Check that the planned hours recorded match to the ILR.\n•  An additional check is needed for compressed delivery, particularly if the study hours are in excess of 30 hours a week (6 study hours per day) as this may mean the study hours have been wrongly recorded.\n•  No planned hours should average more than 40 hours per week.\n•  Any changes to learning aims within first six weeks (for example withdrawing from one learning aim after first 4 weeks) require reassessment of planned hours by provider who can take into account any replacement activities and the planned hours already delivered.","Possible funding error if the planned hours reduces the study programme to part time / lower band.\nStudents (usually in the higher funding bands of 3 to 5) who start and complete a study programme very early should have planned hours reduced to their period of actual attendance.  This is explained in paragraph 99 of the funding regulations with reason for advice in paragraph 126.\nAll planned hour records need to meet the requirement in paragraph 120 to be both realistic and deliverable.  For example, students who complete study programmes in one term should be funded for only that term.  Full year students who withdraw after the first six weeks and who are not recorded as meeting funding retention criteria should not usually need to have their planned hours reduced as the funding retention penalty reduces the funding being paid for such students (see paragraph 98).","Yes","Yes","Yes"]
[null,null,"ii","Planned hours (T Level)","The number of planned hours for the whole duration of the T Level programme must be correctly recorded in the ILR, supported by evidence, and must not include English, maths or industry placements.","R&F:  14 to 18, 39 to 44, 52, 68, 69, 122, 123,  137, 148, 152 to 154, 157, 176 to 178","•  Data check:  Check that the planned hours recorded match to the ILR.","Possible funding error if English, maths, industry placements or any ineligible activities are included in T Level planned hours.","Yes","Yes",null,"Yes"]
[10,"Does the start date recorded in the ILR reconcile to registers, or alternative evidence of attendance held?","i","Learning start date","Funding for a learning aim or programme can be claimed only from the date on which learning activity directly related to the learning aim or programme begins and can be evidenced.","FR:  140 to 144, 153 to 155\nR&F:  33 to 52, 62 to 69","•  Data check:  Check attendance evidence to confirm the study programme start date.\n•  Complete a data check to ensure that the student is in attendance for the start and end dates of the study programme.\n•  The guidance allows study hours delivered for withdrawn learning aims before the start criteria are met, to be included in total study hours for the year where this affects the funding band for the student.\n•  To assist institutions in meeting all wider Government COVID-19 movement restrictions, evidence of continued participation needs to be provided in accordance with the advice in paragraph 131 of the funding regulations (the same advice is also in paragraph 4 of Annex C).","•  Control issue if start date does not match.\n•  Possible funding error if no attendance evidence is available to confirm the qualifying period of the study programme or T Level programme.","Control usually","Control usually","Yes","Yes"]
[11,"Is the student undertaking English in order to meet the funding requirements (applicable where there is no evidence that the student is exempt from the condition of funding; see test 5)?","i","Condition of funding (English)","There must be evidence that students needing to undertake English in order to meet the ESFA condition of funding are working towards the qualification and have met the qualifying period for funding for the learning aim.","FR:  15, 206 to 223\n\nCondition of funding guidance:\nhttps://www.gov.uk/guidance/16-to-19-funding-maths-and-english-condition-of-funding","•  Data check:  Check attendance evidence to confirm the study programme start date, the planned and actual dates of any learning aim being recorded for English/ESOL that may also be used to meet the CoF requirement.\n•  Review the ILR, individual learning plan, the class attendance register and, if available, the registration with the awarding body to confirm student is working towards the qualification.\n•  See Regulations  paragraph 223 Q&A 4 - due to the flexibility stated, funding auditors will raise MLP for non complance with the minimum planned hours threshold for the funding year 2024 to 2025 only.","•  Students must be correctly recorded to count for future allocation lagged funding numbers.\n•  Errors will not usually affect the current year funding values but will affect future funding allocations.","No","Yes","Yes","Yes"]
[12,"Is the student undertaking maths in order to meet the funding requirements (applicable where there is no evidence that the student is exempt from the condition of funding; see test 6)?","i","Condition of funding (maths)","There must be evidence that students needing to undertake maths in order to meet the ESFA condition of funding are working towards the qualification and have met the qualifying period for funding for the learning aim.","FR:  15, 206 to 223\n\nCondition of funding guidance:\nhttps://www.gov.uk/guidance/16-to-19-funding-maths-and-english-condition-of-funding","•  Data check:  Check attendance evidence to confirm the study programme start date, the planned and actual dates of any learning aim being recorded for maths that may also be used to meet the CoF requirement.\n•  Review the ILR, individual learning plan, the class attendance register and, if available, the registration with the awarding body to confirm student is working towards the qualification.\n•  See Regulations  paragraph 223 Q&A 4 - due to flexibility stated, funding auditors will raise MLP for non compliance with the minimum planned hour thresholds for the funding year 2024 to 2025 only.","•  Students must be correctly recorded to count for future allocation lagged funding numbers.\n•  Errors will not usually affect the current year funding values but will affect future funding allocations.","No","Yes","Yes","Yes"]
[13,"If the student is undertaking work experience as part of their programme, have the placement details been fully documented and have arrangements for the recording of attendance been made?","i","Work experience","Where students are undertaking work experience as part of their programme, relevant processes must be followed.","FR:  107 to 110\nR&F:  70","•  Check documentation to ensure that work experience processes are being followed (work experience is planned, organised and supervised).\n•  Here we would check that there is evidence that the student agreed to the placement, the paperwork clearly states what is required (days and times and who to see on arrival) and that there is attendance evidence from the placement provider.\n•  Neither paid employment nor paid work experience is eligible to count as fundable non-qualification hours without prior ESFA approval (see test 8i).","Control issue if requirements are not being followed, otherwise funding error if student withdraws without meeting the qualifying period and/or resulting in drop to part time or lower band.","Control usually","Control usually","Yes"]
[14,"If the student is undertaking an industry placement, has it been planned in accordance with the requirements for the T Level programme or capacity and delivery funding?","i","Industry placements","Where an industry placement is recorded, it must contain at least 315 planned hours, additional to the student's T Level or study programme, and it must normally be with no more than two external employers.","R&F:  152 to 154\n\nCapacity and delivery fund information:\nhttps://www.gov.uk/government/publications/industry-placements-capacity-and-delivery-fund-2023-to-2024/industry-placements-capacity-and-delivery-fund-2023-to-2024","•  Note that there is a specific learning aim, ZWRKX003, that applies only to industry placements for T Level students.\n•  Check the advice on the website detailed in the References column relating to industry placements within the capacity and delivery fund for 2024 to 2025.\n•  Note that there is a specific learning aim, ZWRKX002, that applies only to industry placements for providers receiving capacity and delivery funding.","•  Management letter point advising the provider that to fulfil the requirements of the T Level programme, it will need to deliver an industry placement in accordance with the requirements before the end of the student's two-year programme.\n•  Advise the ESFA if industry placements recorded as meeting the CDF requirements fail to meet the test so that we can raise the matter with the provider.","No","Yes","Yes","Yes"]
[15,"If the student has withdrawn from the programme, does the period of attendance on the programme qualify for funding?","i","Qualifying period for funding","For funding purposes, students are considered to have started a study programme once they have remained on that programme for at least the qualifying period for funding within the current funding year.","FR:  75, 134, 137, 140 to 144, Annex C\nR&F:  75 to 91","•  Check the study programme planned length and qualifying period.\n•  The planned programme length is determined using the earliest start date and latest planned end date of all aims within a study programme.\n•  The actual length used to determine whether or not the student has met the qualifying period uses the earliest start date and latest planned and actual end dates of all aims within a study programme.\n•  Programmes shorter than two weeks are not funded.\n•  Note that students that meet study programme start criteria are not usually expected to have study hours amended later in the year including any reductions for aims not yet started (Completion status field value in ILR is code 3 (withdrawal) or 6 (break in learning)).\n•  The qualifying period is set at six weeks for students with study programmes of either 485 or more planned hours or programmes of more than 24 weeks, and two weeks for all part-time students below 485 planned hours whose programme is due to take between 2 weeks and 24 weeks.","•  Funding error if a student has left the institution before the qualifying period and an incorrect withdrawal date has generated funding.\n•  Also a funding error if incorrect withdrawal date is recorded and one or more learning aims would not meet the qualifying period, therefore taking the planned hours of the study programme into a lower band or part-time.\n•  Possible lagged funding retention issue if students are recorded as completed when they have withdrawn during the year from their core learning aim.\n•  Control issue if the incorrect withdrawal date is after the qualifying period for all non-core or CoF learning aims.","Yes","Yes","Yes","Yes"]
[16,"Where the student has withdrawn from any qualifications, have the withdrawal details been correctly recorded in the ILR?","i","Withdrawals","The learning actual end date recorded in the ILR reflects the last date that there is evidence of learning activity for each learning aim and the completion status and planned hours must be correctly updated as necessary.","FR:  134, 137, 140 to 144, Annex C\nR&F:  75 to 91","•  Check that all learning aims which show as “continuing” are in fact still being studied by the student and that the student has not actually withdrawn.\n•  If the student has withdrawn from the study programme or one or more eligible learning aims before the qualifying period the planned hours should have been reduced accordingly.\n•  Note that students that meet study programme start criteria are not usually expected to have study hours amended later in the year including any reductions for aims not yet started.\n•  Data check:  Check that the correct value for Completion status has been recorded in the ILR (code 3 (withdrawal) or code 6 (break in learning)).\n•  See advice in test 10 on our response for COVID-19 issues.","•  Funding error if a student has left the institution before the qualifying period and an incorrect withdrawal date has generated funding.\n•  Also a funding error if incorrect withdrawal date is recorded and one or more learning aims would not meet the qualifying period, therefore taking the planned hours of the study programme into a lower band or part-time.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \n•  Possible lagged funding retention issue if students are recorded as completed when they have withdrawn during the year from their core learning aim.\n•  Control issue if the incorrect withdrawal date is after the qualifying period for all non-core or CoF learning aims.","Yes","Yes","Yes","Yes"]
[17,"For learning aims recorded in the ILR as achieved, is there evidence to support the achievements?","i","Learning aim achievement","The achievement is correctly recorded in the ILR and is supported by evidence from the awarding organisation.","FR:  160 to 164","•  For this question, we are checking student retention, not success.  Expected evidence for student retention:\n   a) if completed - either evidence from an external awarding body of success in the core qualification or evidence, from registers or otherwise, that the student had completed the learning activities leading to the core qualification (Completion status field value in ILR is code 2 (completed)).\n   b) if continuing - evidence (for example, registers) that the student was still attending the core qualification at the end of the academic year (Completion status field value in ILR is code 1 (continuing)).\n•  See advice in test 10 on our response for COVID-19 issues.","•  If the Completion status value is incorrect, this may result in a lagged funding error (a data error that will affect future funding allocation).\n•  if a completion code has been entered when the student withdrew during the year, see tests 14 and 15.","No","Yes","Yes","Yes"]
[18,"Does the range of documents reviewed provide reasonable evidence of student existence and do the student's signatures appear consistent?","i","Student existence","The range of documents reviewed should provide reasonable evidence of student existence.","Tests 1 to 17 above","Check records for existence and report any concerns where the overall documentation is non-existent, weak or where concerns arise over whether the documentation is genuine.","Funding error if learner does not exist.","Yes","Yes","Yes","Yes"]
[19,"Does the ILR field Subcontracted or partnership UKPRN indicate that subcontracted provision exists?  If yes, please provide the organisation's name and refer to the respective subcontracting working paper.","i","Subcontracting","Subcontracted provision must be eligible for funding","FR:  185, 186","•  Check if appropriate documentation is in place.\n•  Check that ILR field Subcontracted or partnership UKPRN is correctly completed.","•  Internal control issues if the appropriate documentation is not in place.\n•  Funding error if ineligible provision is included within data returns.","Yes","Yes","Yes","Yes"]
[20,"For students flagged as high needs students in the ILR, is there evidence of the home local authority agreement to fund the student's higher support cost needs (i.e. support costs above £6,000)?","i","High needs student support","There must be evidence to support claims for HNS funding.","R&F:  159 to 163","HNS:\n•  HNS are those whose additional support costs are greater than £6,000; this applies to 16 to 18 year olds and 19 to 24 year olds.  Where this is the case, the student's local authority should be paying these additional support costs (element 3) and there should be a contract or individual placement plan with the local authority to agree this funding.\n•  The ESFA pays the first £6,000 of additional support costs (element 2).\n•  Check if appropriate documentation with the LA is in place.\n•  Missing paperwork does not automatically make student funding recoverable.","Internal control issue if the appropriate documentation is not in place.","Control usually","Control usually","Yes","Yes"]
[]
["Key:"]
["FR:  Funding guidance for young people 2023 to 2024: Funding regulations"]
["R&F:  Funding guidance for young people 2023 to 2024: Funding rates & formula"]
["For T Level programmes, refer also to the T Level Action Plan and other T Level information available on GOV.UK"]
["For starts in prior years, refer to respective year's funding rules"]

{"sheet":"DVs","index":17,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Workbook_open completed",0,null,"Yes","16 to 18","Levy"]
[null,null,null,"No","19+","Non-levy"]
["B3_Endrow (Last used row of B3)",3,null,"N/A","16 to 18 and 19+","Levy and Non-levy"]
["B3_Newlastrow",null,null,null,null,"Check funding type"]
[]
["B3_Lastrow value when Name_Ranges were last run",3]
[]
[]
["1730 hours (T level Band 9)",6534,9]
["1580 hours (T level Band 8)",5991,8]
["1380 hours (T level Band 7)",5448,7]
["1180 hours (T level Band 6)",4723,6]
["580+ hours (Band 5)",4542,5]
["485+ hours (Band 4a)",3757,4.0999999999999996]
["485 to 579 hours (Band 4b)",3757,4.2]
["385 to 484 hours (Band 3)",3056,3]
["300 to 384 hours (Band 2)",2416,2]
["Up to 299 hours (Band 1)",4542,1]
["T Level is in year 3, not funded",0]
["Band 9",6534]
["Band 8",5991]
["Band 7",5448]
["Band 6",4723]
["Band 5",4542]
["Band 4a",3757]
["Band 4b",3757]
["Band 3",3056]
["Band 2",2416]
["Band 1",4542]
["band 9",6108]
["band 8",5584]
["band 7",5061]
["band 6",4363]
["band 5",4542]
["band 4a",3757]
["band 4b",3757]
["band 3",3056]
["band 2",2416]
["band 1",4542]
["Not funded",0]