{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Controls","Student testing","Error summary","Temp","Annex A","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"comments":2,"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":"Controls","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,2,20,3],[19,2,19,3],[18,2,18,3],[17,2,17,3],[21,2,21,3],[16,2,16,3],[15,2,15,3],[14,2,14,3],[6,2,6,3],[4,2,4,3],[5,2,5,3],[13,2,13,3],[12,2,12,3],[11,2,11,3],[10,2,10,3],[9,2,9,3],[8,2,8,3],[7,2,7,3]]}
["16 to 19 financial support: Controls questionnaire"]
[null,null,"16 to 19 Bursary Fund","Free meals in further education"]
["Allocation"]
["Year-to-date payments"]
["No.","Category","Control question",null,"Provider's response","Control satisfactory?","Comments"]
[1,"General","Do you use your 16 to 19 Bursary Fund or free meals in further education funding allocation to cover administrative costs?  If so, how much?  What percentage of the funding do you use?"]
[{"$f":"A6+1","v":2},"General","Describe your controls for ensuring that you do not carry forward funding for discretionary bursary and/or free meals in further education over more than one funding year.\n\nWhere you hold unspent funds from any year prior to the 2020 to 2021 academic year, have you contacted the ESFA to arrange to return these funds?"]
[3,"16 to 19 Bursary Fund","Describe your management, staffing, payment and organisational arrangements for administering the 16 to 19 Bursary Fund."]
[4,"16 to 19 Bursary Fund","Describe your specific administrative procedures for evidencing bursary applications and awards.  For example:\n\nBursary for vulnerable groups\ni)  Student funding application and claim forms;\nii)  Evidence to confirm eligibility to receive bursary for vulnerable groups;\niii)  Evidence of assessments of students' actual financial needs;\niv)  Evidence of payment received from the Student Bursary Support Service and payment made to students.\n\nDiscretionary bursary\ni)  Application form and evidence to confirm eligibility+C9 to receive discretionary bursary;\nii)  Evidence of income, used to assess eligibility;\niii)  Evidence of assessments of students’ actual financial needs;\niv)  Receipts for purchases made on behalf of students, such as equipment."]
[5,"16 to 19 Bursary Fund","Have you developed and published a statement, available to young people and the ESFA, setting out how you will administer and distribute your 16 to 19 Bursary Fund?\n\nIf so, does it include the eligibility criteria and the type of help being offered?\n\nNote: Block, blanket or flat rate payments are not permitted.  Payments must be based on actual financial need."]
[{"$f":"A10+1","v":6},"16 to 19 Bursary Fund","Do you raise awareness of the 16 to 19 Bursary Fund when marketing your courses to young people, for example, by working in partnership with local authorities or with feeder schools?\n\nIn particular, where you offer provision from more than one location, or through subcontracts, how do you ensure that any student attending such provision can apply for a bursary?"]
[7,"16 to 19 Bursary Fund","Describe your controls for ensuring the accurate recording, storage and security of 16 to 19 Bursary Fund evidence and data?"]
[{"$f":"A12+1","v":8},"16 to 19 Bursary Fund","How often do you review the 16 to 19 Bursary Fund guidance, available on the GOV.UK website, to ensure that you keep up-to-date with any changes?"]
[9,"16 to 19 Bursary Fund","Describe your controls for ensuring that you check that students in receipt of a bursary satisfy the general eligibility requirements, set out in the 16 to 19 Bursary Fund guide: 2021 to 2022 academic year, as follows:\n\ni)  age;\nii)  eligible education provision;\niii)  residency."]
[{"$f":"A14+1","v":10},"16 to 19 Bursary Fund","Is receipt of a bursary conditional on students meeting agreed standards that you set, for example, relating to attendance and/or standards of behaviour?\n\nIf so, do you hold evidence, such as a signed agreement, confirming that each student has agreed to the conditions?"]
[11,"16 to 19 Bursary Fund: Bursary for vulnerable groups","Describe your controls for ensuring that you hold appropriate evidence to support claims made for students applying for bursary for vulnerable groups.\n\nDo you retain copies of documents that confirm eligibility, for example, a letter from the DWP setting out the benefit to which a student is entitled or written confirmation from the local authority of a student's current or previous looked-after status?"]
[{"$f":"A16+1","v":12},"16 to 19 Bursary Fund: Bursary for vulnerable groups","Having undertaken an assessment of a student's actual needs and determining the actual amount of support that they require, describe your controls for ensuring that you draw down bursary for vulnerable groups payments from the Student Bursary Support Service in a timely and accurate manner.\n\nDescribe your procedures for ensuring that you do not claim for duplicate students or students no longer in education."]
[13,"16 to 19 Bursary Fund: Discretionary bursary","Describe your controls for ensuring that you award discretionary bursaries only to students facing financial barriers to participation, for example, the costs of transport, meals, books, equipment and other course-related items.\n\nDescribe also your controls for ensuring that you have appropriately assessed applications and documented actual financial need, and that you have taken into account any allowances or other sources of financial support."]
[{"$f":"A18+1","v":14},"Free meals in further education","Describe your administrative procedures for recording free meals in further education applications and awards, including:\n \ni)  checks to ensure that there is a fully and accurately completed application form for each student;\nii)  checks on students’ eligibility, covering age, residency and receipt of qualifying benefits (student or parents).\niii)  recording in the ILR the Learner funding and monitoring type code/value FME2 for all eligible students who have taken up a free meal at any point during the academic year."]
[15,"Free meals in further education","Where you determine that it is necessary to enhance the £2.41 free meals funding rate from the 16 to 19 Bursary Fund or other sources:\n\na)  how do you ensure and evidence value for money and reasonableness of this enhancement?\n\nb)  if you have adopted a significant variation to the standard rate, what is your rationale and have you documented it?\n\nc)  how do you ensure that there is no negative impact on the discretionary bursary fund and that money remains available to support students facing other barriers to participation?"]
[{"$f":"A20+1","v":16},"Free meals in further education","Describe how you make available free meals provision for students when they are off-site, for example, attending a work placement or work experience?"]
[17,"Free meals in further education","Do you make cash payments to students?\n\nIf so, describe how you ensure that you make such payments in accordance with the exceptional circumstances set out in the guidance?"]

{"sheet":"Student testing","index":1,"n_rows":34,"n_cols":34,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["16 to 19 financial support: Substantive testing working paper"]
[null,null,null,null,null,null,null,"All bursaries",null,"Bursaries for vulnerable groups",null,null,null,null,null,null,null,"Discretionary bursaries",null,null,null,null,null,"All bursaries","Free meals in further education",null,null,null,null,null,null,"16 to 19 financial support sample summary"]
[null,"All links relating to guidance for 16 to 19 Bursary Fund testing are to sections of the 16 to 19 Bursary Fund guide: 2021 to 2022 academic year page of the GOV.UK website.\n\nAll links relating to guidance for free meals in further education testing are to sections of the 16 to 19 funding: free meals in further education funded institutions for 2021 to 2022 page of the GOV.UK website.\n",null,null,"2021 to 2022 academic year:\n\nTotal year-to-date payments per student",null,null,"Is there a fully  completed bursary application form, signed by the student?","Is there evidence confirming that the student satisfies the general eligibility criteria?\n\n(i.e. age, residency and type of provision)","Is there evidence confirming that the student satisfies the specific eligibility criteria for receipt of a bursary for vulnerable groups?\n\nVulnerable groups:\n- In care\n- Care leaver\n- receiving IS, or UC because they are financially supporting themselves or financially supporting themselves and someone who is dependent on them and living with them such as a child or partner\n- receiving DLA or PIP in their own right as well as ESA or UC in their own right",null,"Is there evidence of an assessment of need, including the student's actual participation costs and amount of funding required?","Is all of the following evidence available to demonstrate the correct draw down of funds from the Student Bursary Support Service (SBSS):\n\n(i) funding claim form;\n(ii) funding statement;\n(iii) remittance advice;\n(iv) payment received from the SBSS?",null,"Has the provider awarded the bursary for vulnerable groups in accordance with the funding guidance?\n\n","Has the provider paid the bursary for vulnerable groups to the student as agreed?","Bursary for vulnerable groups\n\nIn sample funding error","Briefly describe the reason(s) for the discretionary bursary award\n\n(e.g. to cover cost of meals, travel, books and equipment)","Is there evidence of the provider's individual assessment of the student's financial need?","Is there evidence confirming that the student satisfies the provider's specific eligibility criteria for receipt of a discretionary bursary, as per its bursary policy?",null,"Has the provider given the value of the discretionary bursary to the student (in cash or in kind) as agreed?","Discretionary bursary\n\nIn sample funding error","Comments","Is there a fully completed free meals in further education application, signed by the student or their parent or guardian?","Is there evidence confirming that the student satisfies the general eligibility criteria?\n\n(i.e. age and residency)","Is there evidence confirming that the student is, or has parents that are, in receipt of one or more of the eligible benefits listed in the funding guidance?",null,"Has the provider recorded the Learner funding and monitoring type code/value FME2 in the ILR?","Free meals in further education\n\nIn sample funding error","Comments","Total payments","Total funding error","Control issues "]
["No.","Name","Learner reference number","Type of bursary","Bursary for vulnerable groups","Discretionary bursary","Free meals in further education",null,null,null,"Record the benefit and describe the evidence held",null,null,"Record which evidence is missing",null,null,null,null,null,null,"Describe the evidence held",null,null,null,null,null,null,"Describe the evidence held",null,null,null,{"$f":"SUM(AF5:AF34)","v":0},{"$f":"SUM(AG5:AG34)","v":0}]
[1,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":"SUM(E5:G5)","v":0},{"$f":"Q5+W5+AD5","v":0}]
[2,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,0,0]
[3,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,0,0]
[4,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,0,0]
[5,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,0,0]
[6,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,0,0]
[7,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,0,0]
[8,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,0,0]
[9,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,0,0]
[10,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,0,0]
[11,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,0,0]
[12,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,0,0]
[13,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,0,0]
[14,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,0,0]
[15,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,0,0]
[16,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,0,0]
[17,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,0,0]
[18,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,0,0]
[19,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,0,0]
[20,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,0,0]
[21,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,0,0]
[22,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,0,0]
[23,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,0,0]
[24,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,0,0]
[25,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,0,0]
[26,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,0,0]
[27,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,0,0]
[28,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,0,0]
[29,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,0,0]
[30,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,0,0]

{"sheet":"Error summary","index":2,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["No.","Working paper ref.","Name","Learner reference no.","Type of financial support","Details of error","Sample error (£)","Outside sample error (£)"]
[{"$f":"ROW()-1","v":1}]

{"sheet":"Temp","index":3,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["No.","Working paper ref.","Name","Learner reference no.","Type of financial support","Details of error","Sample error (£)","Outside sample error (£)"]
[{"$f":"ROW()-1","v":1}]

{"sheet":"Annex A","index":4,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Funding errors summary"]
[null,null,"16 to 19 financial support"]
["Ref","Description","16 to 19 Bursary Fund:\nBursaries for vulnerable groups","16 to 19 Bursary Fund:\nDiscretionary bursaries","Free meals in further education","TOTAL"]
["a.","Value of the population",null,null,null,{"$f":"SUM(C4:E4)","v":0}]
["b.","Value of the sample",{"$f":"ROUND(SUM(SV_VB),0)","v":0},{"$f":"ROUND(SUM(SV_DB),0)","v":0},{"$f":"ROUND(SUM(SV_FMFE),0)","v":0},{"$f":"SUM(C5:E5)","v":0}]
["c.","Value of actual errors from the sample",{"$f":"ROUND(SUM(SE_VB),0)","v":0},{"$f":"ROUND(SUM(SE_DB),0)","v":0},{"$f":"ROUND(SUM(SE_FMFE),0)","v":0},{"$f":"SUM(C6:E6)","v":0}]
[]
["d.","Sample error rate",{"$f":"IFERROR(C6/C5,0)","v":0},{"$f":"IFERROR(D6/D5,0)","v":0},{"$f":"IFERROR(E6/E5,0)","v":0},0,"c / b"]
[]
["e.","Value of actual errors outside the sample but within the population",{"$f":"ROUND(SUM(IF(B3_FSType=\"Bursary for vulnerable groups\",OSE)),0)","v":0},{"$f":"ROUND(SUM(IF(B3_FSType=\"Discretionary bursary\",OSE)),0)","v":0},{"$f":"ROUND(SUM(IF(B3_FSType=\"Free meals in further education\",OSE)),0)","v":0},{"$f":"SUM(C10:E10)","v":0}]
[]
["f.","Total actual errors",{"$f":"C6+C10","v":0},0,0,{"$f":"SUM(C12:E12)","v":0},"c + e"]
[]
["g.","Has an estimated error been agreed?","NO","NO","NO"]
[]
["h.","Value of estimated errors",{"$f":"ROUND(IF(C14=\"NO\",0,(IF(C10>(C8*C4-C6),0,(C8*C4-(C6+C10))))),0)","v":0},{"$f":"ROUND(IF(D14=\"NO\",0,(IF(D10>(D8*D4-D6),0,(D8*D4-(D6+D10))))),0)","v":0},{"$f":"ROUND(IF(E14=\"NO\",0,(IF(E10>(E8*E4-E6),0,(E8*E4-(E6+E10))))),0)","v":0},{"$f":"SUM(C16:E16)","v":0},"calculated estimate\n(d x a)-c-e"]
[]
["j.","Total funds at risk to be reported, and corrected or recovered",{"$f":"C12+C16","v":0},{"$f":"D12+D16","v":0},0,{"$f":"SUM(C18:E18)","v":0},"f + h"]
[]
["k.","Overall error rate\n(applicable following 100% testing, where sample error rate ≥ 5%)",{"$f":"IF(C8>=0.05,IFERROR(C18/C4,0),\"\")","v":""},{"$f":"IF(D8>=0.05,IFERROR(D18/D4,0),\"\")","v":""},"",null,"j / a"]
[]
["Values rounded to the nearest £."]
["Where they are calculated based on the sample error rate, estimated error values (h) do not include the actual errors within the population (c + e) to ensure that the same errors are not counted twice."]

{"sheet":"Lists","index":5,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Vulnerable"]
["Discretionary"]
["Both vulnerable and discretionary"]
["None"]
[]
["Bursary for vulnerable groups"]
["Discretionary bursary"]
["Free meals in further education"]