{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Control","Start","Guidance","NSEC-F","Attachment","Finance use only - ESFA","Finance use only- DFE,STA-TRA","System-Business Refrence","System-AccountCode"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":1,"defined_names":15,"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":"Control","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"Tab:",{"$f":"MID(CELL(\"filename\",H1),FIND(\"]\",CELL(\"filename\",H1))+1,32)","v":"Control"}]
[]
[]
[]
[]
[null,"Non Staff Expenses Claim Form"]
[]
[null,"Purpose and overview of workbook"]
[]
[null,"The Purpose of this workbook is for Non-Staff to claim expense and then the information to be loaded on to BC for payments."]
[]
[null,"Workbook developer"]
[]
[null,"Suhail Kazi & Adam Pratt"]
[]
[null,"Owner"]
[]
[null,"Suhail Kazi & Adam Pratt"]
[]
[null,"Validations"]
[]
[]
[]
[null,"Description of worksheets"]
[]
[null,"Tab name","Worksheet name","Type of sheet","Purpose"]
[null,{"$f":"H1","v":"Control"},"Control sheet","Form/Guidance/Calcution/DataTemplate"]
[null,"Overview","Overview of closing periods and exceptions in Business Central"]
[null,"Log","Log of closing periods in Business Central"]
[null,"Exceptions (monthly)","Log of monthly exceptions in Business Central "]
[null,"Exceptions (post p12)","Log of year end exceptions (smaller specific user groups kept open post period end)"]
[null,"COGP","Cabinet Office Global Principles"]
[]
[]
[null,"Adminstrator Password:","DFE123"]

{"sheet":"Start","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[[5,1,5,11],[10,1,10,11],[11,1,11,11]]}
[]
[]
[]
[null,"Non Staff Expenses Claim Form"]
[]
[null,"1. Open this document in Desktop Application."]
[]
[]
[]
[]
[null,"2. Save this document to your Local Drive."]
[null,"3. Enable macros above to use this form."]

{"sheet":"Guidance","index":2,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,2,5,6]]}
[]
[]
[]
[null,"Non-Staff Expense Claim Form"]
[null,1,"Before you complete this form, ensure your Vendor Account has been set up."]
[null,2,"This claim form should be used for non-taxable expenses, travel and other expenses that were necessary in pursuit of Departmental business.  It should not be used by appointed (fees paid) Committee Members for claiming fees or expenses."]
[null,3,"The form must be submitted within one month of incurring expenses and valid receipts must support all claims. Delays in submitting a valid claim may cause processing difficulties and can delay payment. "]
[null,4,"The completed form should be sent to the authoriser/departmental contact."]
[null,5,"Legible receipts must be provided for all claimed items (exception being mileage claims) and you will need to keep a copy of both the receipts and the form for 4 years."]
[null,6,"This form is for costs incurred by individuals and should not be used to reclaim costs which your organisation or school has incurred. Please contact your authoriser or departmental contact if unsure of what you can claim."]
[null,7,"Complete only yellow fields."]
[null,8,"Ensure you have ticked the declaration for claim box before submitting your form to the authoriser/departmental contact."]
[null,9,"Attach any receipts with the email sent to the authoriser/departmental contact."]
[null,10,"Submit by Email."]
[]
[null,"Additional Information"]
[null,1,"Alcohol cannot be reimbursed from public funds."]
[null,2,"Claims should be limited to the actual fare for all necessary travel on public business."]
[null,3,"Economy class air travel is allowable when it provides Value For Money, further details are shown in the Travel policies."]
[null,4,"Taxi fares are not allowable except where there is no other suitable method of public transport or where the urgency of the journey justifies the cost."]
[null,5,"If you use a private motor vehicle on public business, you may claim a mileage allowance. The departmental contact or authorising officer will inform you of the rate per mile."]
[null,6,"Any gratuities cannot be reimbursed from public funds."]
[]
[null,"Please Note                                                                                                                                                                                       "]
[null,1,"Payment for expense claims are made weekly."]
[null,2,"Once the claim has been approved it will be submitted to the next weekly payment run."]
[]
[null,null,"Vendor Account Details"]
[null,null,"Field Name","Data type","Requirement","Comment"]
[null,null,"Vendor Number","Free Text","Mandatory","Enter your Account No."]
[null,null,"Name","Free Text","Mandatory","Enter your Full Name."]
[]
[null,null,"Expense Line"]
[null,null,"Field Name","Data type","Requirement","Comment"]
[null,null,"Date","Date","Mandatory","Enter date of your expense. Enter DD/MM/YYYY."]
[null,null,"Purpose of expense/location","Free Text","Mandatory","Enter the purpose and location of the expense."]
[null,null,"Start Time","Numeric","Optional","Enter start time - if required. Please ensure you use : to separate Hours and Minutes. Format = HH:MM"]
[null,null,"End Time","Numeric","Optional","Enter end time - if required. Please ensure you use : to separate Hours and Minutes. Format = HH:MM"]
[null,null,"Subsistence","Numeric","Optional","Enter the amount of Subsistence."]
[null,null,"Public Transport","Numeric","Optional","Enter the amount of Public Transport."]
[null,null,"Mode of Transport/Engine","Free Text","Optional","Enter the mode of transport and or engine size."]
[null,null,"Total Miles","Numeric","Optional","Enter the total number of miles travelled."]
[null,null,"Mileage Rate","Numeric","Optional","Enter the mileage rate claimed."]
[null,null,"Mileage Amount","Auto","Optional","Will calculate the amount of mileage claimed where appropriate fields have been completed."]
[null,null,"Other Expenses","Numeric","Optional","Enter the amount of any other expense - use the Additional Information field to provide information."]
[null,null,"Amount","Auto","Mandatory","Calculates the total amount of expenditure for this line."]
[null,null,"Additional Information","Free Text","Optional","Include any additional data required - such as journey from/to other expense etc - where required."]
[null,null,"Declaration","Tick Box","Mandatory","Must tick the declaration box before submitting the form."]
[null,null,"Date Submitted","Date","Auto completes","Date will auto complete after you  tick the declaration box."]

{"sheet":"NSEC-F","index":3,"n_rows":67,"n_cols":34,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,24,66,25],[66,26,66,32],[59,2,59,8],[64,1,65,25],[59,25,59,28],[61,19,61,24],[33,20,33,22],[31,20,31,22],[65,30,65,32],[50,9,50,11],[49,9,49,11],[50,12,50,18],[49,12,49,18],[51,9,51,11],[51,12,51,18],[52,9,52,11],[52,12,52,18],[53,9,53,11],[64,30,64,32],[53,12,53,18],[51,19,51,21],[51,22,51,24],[51,25,51,28],[58,19,58,21],[58,22,58,24],[58,25,58,28],[21,28,21,29],[21,30,21,32],[24,30,24,32],[39,29,39,32],[25,30,25,32],[26,30,26,32],[25,23,25,29],[23,23,23,24],[23,30,23,32],[18,28,18,29],[18,30,18,32],[21,25,21,27],[22,25,22,27],[22,28,22,29],[22,30,22,32],[22,23,22,24],[23,25,23,27],[23,28,23,29],[20,25,20,27],[20,28,20,29],[20,30,20,32],[19,25,19,27],[19,28,19,29],[19,30,19,32],[18,25,18,27],[15,28,15,29],[17,25,17,27],[17,28,17,29],[17,30,17,32],[17,15,17,17],[14,1,14,2],[14,3,14,10],[14,13,14,14],[17,18,17,20],[17,21,17,22],[14,15,14,17],[15,1,15,2],[15,3,15,10],[15,13,15,14],[15,15,15,17],[15,18,15,20],[15,21,15,22],[16,30,16,32],[15,23,15,24],[17,23,17,24],[15,30,15,32],[16,25,16,27],[16,28,16,29],[15,25,15,27],[13,30,13,32],[13,28,13,29],[14,25,14,27],[13,25,13,27],[14,28,14,29],[14,30,14,32],[14,23,14,24],[14,21,14,22],[14,18,14,20],[58,2,58,8],[54,19,54,21],[54,22,54,24],[52,22,52,24],[54,9,54,11],[54,12,54,18],[26,1,27,20],[21,3,21,10],[21,13,21,14],[21,15,21,17],[21,18,21,20],[50,2,50,8],[53,2,53,8],[54,2,54,8],[49,22,49,24],[50,19,50,21],[50,22,50,24],[58,9,58,11],[58,12,58,18],[56,19,56,21],[56,22,56,24],[53,19,53,21],[57,19,57,21],[57,22,57,24],[7,4,7,11],[9,4,9,11],[13,1,13,2],[13,3,13,10],[13,13,13,14],[13,15,13,17],[13,18,13,20],[13,21,13,22],[13,23,13,24],[57,2,57,8],[57,25,57,28],[19,21,19,22],[16,1,16,2],[16,3,16,10],[16,13,16,14],[16,15,16,17],[16,18,16,20],[16,21,16,22],[16,23,16,24],[53,25,53,28],[54,25,54,28],[26,27,26,29],[49,2,49,8],[47,8,47,10],[22,13,22,14],[45,5,45,10],[19,18,19,20],[21,23,21,24],[55,25,55,28],[52,19,52,21],[17,1,17,2],[17,3,17,10],[17,13,17,14],[61,25,61,28],[63,25,63,28],[22,1,22,2],[22,3,22,10],[59,19,59,21],[59,22,59,24],[59,9,59,11],[59,12,59,18],[53,22,53,24],[55,9,55,11],[55,12,55,18],[56,9,56,11],[22,15,22,17],[23,1,23,2],[23,3,23,10],[23,13,23,14],[23,15,23,17],[23,18,23,20],[23,21,23,22],[55,19,55,21],[55,22,55,24],[56,12,56,18],[57,9,57,11],[57,12,57,18],[22,18,22,20],[55,2,55,8],[51,2,51,8],[52,2,52,8],[22,21,22,22],[56,25,56,28],[24,25,24,29],[30,1,33,14],[56,2,56,8],[50,25,50,28],[52,25,52,28],[49,25,49,28],[49,19,49,21],[18,15,18,17],[18,18,18,20],[18,21,18,22],[18,23,18,24],[21,21,21,22],[20,1,20,2],[20,3,20,10],[20,13,20,14],[20,15,20,17],[20,18,20,20],[20,21,20,22],[20,23,20,24],[19,1,19,2],[19,3,19,10],[19,13,19,14],[19,15,19,17],[18,1,18,2],[18,3,18,10],[18,13,18,14],[21,1,21,2],[19,23,19,24]]}
[]
[]
[]
[null,"Non Staff Expenses Claim Form",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,"Department for Education"]
[null,null,null,"."]
[null,"Payee Details"]
[]
[null,"Name",null,null,"Peter Bryan"]
[]
[null,"Vendor Number",null,null,"P0109089"]
[]
[null,"Expense Detail"]
[]
[null,"Date",null,"Purpose of expense/location",null,null,null,null,null,null,null,"Start Time","End Time","Subsistence",null,"Public\nTransport",null,null,"Mode of Transport/Engine",null,null,"Total Miles",null,"Mileage\nRate",null,"Mileage Amount",null,null,"Other\nExpenses",null,"Amount",null,null,"Line No"]
[null,"2025-03-19",null,"TPSPB Subcommittee Meeting",null,null,null,null,null,null,null,"10:00:00","16:00:00",null,null,null,null,null,null,null,null,124.6,null,0.45,null,{"$f":"SUM(V15*X15)","v":56.07},null,null,null,null,{"$f":"SUM(AC15,Z15,P15,N15)","v":56.07},null,null,1]
[null,null,null,"Parking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,6,null,{"$f":"SUM(AC16,Z16,P16,N16)","v":6},null,null,2]
[null,null,null,"Subsistence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,11.8,null,11.8,null,null,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,0,null,null,null,null,0,null,null,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,0,null,null,null,null,0,null,null,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,0,null,null,null,null,0,null,null,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,0,null,null,null,null,0,null,null,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,0,null,null,null,null,0,null,null,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,0,null,null,null,null,0,null,null,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,0,null,null,null,null,0,null,null,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,"Total Amount Claimed",null,null,null,null,{"$f":"SUM(AE15:AG24)","v":73.87}]
[null,"Additional Information"]
[]
[]
[]
[null,"Declaration"]
[null,"By ticking the box, I declare this claim is accurate and made in accordance with the relevant policy/guidance. For mileage claims, I hold a driving licence and my car insurance permits the use of my vehicle on official business. All receipts will be retained by me for a period of 4 years. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","2025-03-24T11:06:38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreed",true]
[]
[null,"Finance Expense Administrators Use Only"]
[]
[null,"1. Check the information on Non - Staff Expense Claim Form to be paid is correct."]
[null,"2. Complete your Name and Due Date"]
[null,"3. Select a Company for each Line Number."]
[null,"4. Complete Cost Centre Number and Account Code."]
[null,"5. Declare you have fully checked the claim for reimbursement of expense."]
[null,"6. Click on 'Manual Adjustments' Button and follow the guidance on completing the UPS Template for Payment."]
[]
[]
[null,"Administrator Name",null,null,null,"Loraine Dodds"]
[]
[null,"Due Date",null,null,null,null,null,null,"2025-03-26"]
[]
[null,"Line No","Company",null,null,null,null,null,null,"Cost Centre",null,null,"Account Code",null,null,null,null,null,null,"Activity Code",null,null,"Analysis Code",null,null,"Total Claimed"]
[null,1,"DFE Core STA TRA",null,null,null,null,null,null,10292,null,null," - Other Travel - Mileage",null,null,null,null,null,null,"0000000",null,null,"00000000",null,null,56.07]
[null,2,"DFE Core STA TRA",null,null,null,null,null,null,10292,null,null," - Other Travel",null,null,null,null,null,null,"0000000",null,null,"00000000",null,null,6]
[null,3,"DFE Core STA TRA",null,null,null,null,null,null,10292,null,null," - Subsistence",null,null,null,null,null,null,"0000000",null,null,"00000000",null,null,11.8]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0000000",null,null,"00000000"]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0000000",null,null,"00000000"]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0000000",null,null,"00000000"]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0000000",null,null,"00000000"]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0000000",null,null,"00000000"]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0000000",null,null,"00000000"]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0000000",null,null,"00000000"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Amount Payable",null,null,null,null,null,{"$f":"SUM(Z51:AC60)","v":73.87}]
[]
[null,"Policy Declaration"]
[null,"By ticking this box, you are certifying that you have fully checked the claim for reimbursement of expenses and assiociated receipts and can confirm that is correct and compliant with policy.",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,"Date","2025-03-24T11:07: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,"Agreed",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signed by:",null,"Dodds, Loraine"]

{"sheet":"Attachment","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Non Staff Expenses Claim Form"]
[null,null,"Receipts"]
[null,null,"To add a receipt, please: "]
[null,null,"1. Click the \"Add Reeipt\" button above and select the file to add."]
[null,null,"2. Update the description to reflect the line items on the form"]
[]
[null,null,"To delete a receipt, select the file and press delete on your keyboard"]
[]
[null,null,"Description","Attachment"]
[null,null,"Rail Travel"]

{"sheet":"Finance use only - ESFA","index":5,"n_rows":18,"n_cols":29,"rows_kept":18,"cut":false,"hidden":true,"merged":[[2,4,2,5],[4,3,5,9]]}
[null,null,"Business use only -  ESFA"]
[null,null,1,"Complete Line No. from the expense form."]
[null,null,2,"Locate required template on the Finance Den, following the link: ","Click here for Manual Adjustments"]
[null,null,3,"Save a copy of the template on your desktop."]
[null,null,4,"Copy only the cells under the grey headers below onto the UPS template, as the yellow headers are pre-populated in the template / or press the copy button (which would copy the data from the form), Open up the Template, Click Paste special --> Tick Values --> Tick Skip Blanks --> Press Ok. "]
[]
[null,null,5,"Follow the 'How to complete a template guidance' on the Finance Den."]
["Company","Company Line No.","Line No","Document Type","Account Number","Provider name","Parent/Child","UKPRN","UPIN","Funding Type Code","Values excl. VAT","Posting Date","External Document Number","Project Code\nDimension 1","Ext. Ref. 1\nHolding Date","Ext. Ref. 5\nRemittance Comments","Payment Date","G/L Account Code","G/L Account Name","VAT Code"," Ext. Ref. 4","Cost Centre Code\nDimension 2","Contract No.\nDimension 3","Establishment Code","Expenditure type Code","Ext. Ref. 2\n","Ext. Ref. 3\n","Ext. Ref. 6\n","Remittance Description"]
["ESFA",{"$f":"A9&C9","v":"ESFA"},null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!B2:K12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!B3:K13,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!B4:K14,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!B5:K15,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!B6:K16,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!B7:K17,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!B8:K18,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!B9:K19,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!B10:K20,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]
["ESFA","ESFA",null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!B11:K21,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$K$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$K$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$K$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""}]

{"sheet":"Finance use only- DFE,STA-TRA","index":6,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":true,"merged":[[2,4,2,5],[4,3,5,9]]}
[null,null,"Business use only -  DFE Core, STA, TRA Template"]
[null,null,1,"Complete Line No. from the expense form."]
[null,null,2,"Locate required template on the Finance Den, following the link: ","Click here for Manual Adjusments"]
[null,null,3,"Save a copy of the template on your desktop."]
[null,null,4,"Copy only the cells under the grey headers below onto the UPS template, as the yellow headers are pre-populated in the template / or press the copy button (which would copy the data from the form), Open up the Template, Click Paste special --> Tick Values --> Tick Skip Blanks --> Press Ok. "]
[]
[null,null,5,"Follow the 'How to complete a template guidance' on the Finance Den."]
["Company","Company Line No.","Line No","Document Type","Vendor Number","Provider Name","Parent/Child","UKPRN","UPIN","Funding Type Code","Values excl. VAT","Posting Date ","Due Date","External Document Number","Ext. Ref. 5\nRemittance Comments","Category Code Name","Category Code","Index","Cost Centre Code\nDimension 2","G/L Account Code","VAT Code","Activity Code","Analysis Code","Grant Type Description","Grant Type","Ext. Ref. 6\n"]
["DFE Core STA TRA",{"$f":"A9&C9","v":"DFE Core STA TRA"},null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]
["DFE Core STA TRA","DFE Core STA TRA",null,{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,3,0),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$M$12,12,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,10,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,5,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,6,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$M$12,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,'System-Business Refrence'!$B$2:$L$12,7,0),\"\")","v":""}]

{"sheet":"System-Business Refrence","index":7,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Company Line No.","Document Type","Vendor Number","Funding Type Code","Account Codes","Cost Center","Analysis Code","Activity Code","Amount","Purpose and Location Expenses","Posting Date","Due Date"]
[null,{"$f":"'NSEC-F'!C51&'NSEC-F'!B51","v":"DFE Core STA TRA1"},"Invoice",{"$f":"rVendorNumber","v":"P0109089"},"NONEMPEXP",{"$f":"'NSEC-F'!M51","v":" - Other Travel - Mileage"},{"$f":"'NSEC-F'!J51","v":10292},null,null,{"$f":"'NSEC-F'!Z51","v":56.07},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D15&\"\"","v":"NSECF_P0109089_Peter Bryan_TPSPB Subcommittee Meeting"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C52&'NSEC-F'!B52","v":"DFE Core STA TRA2"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M52","v":" - Other Travel"},{"$f":"'NSEC-F'!J52","v":10292},null,null,{"$f":"'NSEC-F'!Z52","v":6},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D16&\"\"","v":"NSECF_P0109089_Peter Bryan_Parking"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C53&'NSEC-F'!B53","v":"DFE Core STA TRA3"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M53","v":" - Subsistence"},{"$f":"'NSEC-F'!J53","v":10292},null,null,{"$f":"'NSEC-F'!Z53","v":11.8},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D17&\"\"","v":"NSECF_P0109089_Peter Bryan_Subsistence"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C54&'NSEC-F'!B54","v":"4"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M54","v":0},{"$f":"'NSEC-F'!J54","v":0},null,null,{"$f":"'NSEC-F'!Z54","v":0},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D18&\"\"","v":"NSECF_P0109089_Peter Bryan_"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C55&'NSEC-F'!B55","v":"5"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M55","v":0},{"$f":"'NSEC-F'!J55","v":0},null,null,{"$f":"'NSEC-F'!Z55","v":0},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D19&\"\"","v":"NSECF_P0109089_Peter Bryan_"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C56&'NSEC-F'!B56","v":"6"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M56","v":0},{"$f":"'NSEC-F'!J56","v":0},null,null,{"$f":"'NSEC-F'!Z56","v":0},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D20&\"\"","v":"NSECF_P0109089_Peter Bryan_"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C57&'NSEC-F'!B57","v":"7"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M57","v":0},{"$f":"'NSEC-F'!J57","v":0},null,null,{"$f":"'NSEC-F'!Z57","v":0},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D21&\"\"","v":"NSECF_P0109089_Peter Bryan_"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C58&'NSEC-F'!B58","v":"8"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M58","v":0},{"$f":"'NSEC-F'!J58","v":0},null,null,{"$f":"'NSEC-F'!Z58","v":0},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D22&\"\"","v":"NSECF_P0109089_Peter Bryan_"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C59&'NSEC-F'!B59","v":"9"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M59","v":0},{"$f":"'NSEC-F'!J59","v":0},null,null,{"$f":"'NSEC-F'!Z59","v":0},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D23&\"\"","v":"NSECF_P0109089_Peter Bryan_"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[null,{"$f":"'NSEC-F'!C60&'NSEC-F'!B60","v":"10"},"Invoice","P0109089","NONEMPEXP",{"$f":"'NSEC-F'!M60","v":0},{"$f":"'NSEC-F'!J60","v":0},null,null,{"$f":"'NSEC-F'!Z60","v":0},{"$f":"\"NSECF_\"&rVendorNumber&\"_\"&rName&\"_\"&'NSEC-F'!D24&\"\"","v":"NSECF_P0109089_Peter Bryan_"},{"$f":"'NSEC-F'!$AE$65","v":"2025-03-24T11:07:30"},{"$f":"'NSEC-F'!$I$48","v":"2025-03-26"}]
[]
[null,{"$f":"MID(INFO(\"DIRECTORY\"),10,LEN(INFO(\"DIRECTORY\"))-LEN(MID(INFO(\"DIRECTORY\"),FIND(\"\\\",INFO(\"DIRECTORY\"),10),1000))-LEN(\"C:\\Users\\\"))","v":"ldodds2"}]
[null,{"$f":"INFO(\"SYSTEM\")","v":"pcdos"}]
[null,{"$f":"INFO(\"ORIGIN\")","v":"$A:$B$1"}]
[null,{"$f":"INFO(\"OSVERSION\")","v":"Windows (64-bit) NT 10.00"}]
[null,{"$f":"INFO(\"DIRECTORY\")","v":"C:\\Users\\ldodds2\\OneDrive - Department for Education\\Documents\\"}]

{"sheet":"System-AccountCode","index":8,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Category","Account codes",null,"Temp","Account Code Name","Category Code","ESFA Account Code"]
[null,5215303000,"EXP - PURCH OF GDS/SERV - OTHER FACILITIES COSTS - CONFS, EXHIBITIONS AND EVENTS","EXP - PURCH OF GDS/SERV - OTHER FACILITIES COSTS - CONFS, EXHIBITIONS AND EVENTS",{"$f":"A2&\" - \" &PROPER(D2)","v":" - Exp - Purch Of Gds/Serv - Other Facilities Costs - Confs, Exhibitions And Events"}]
[null,5212103003,"EXP - PURCH OF GDS/SERV - PERSONNEL RELATED - CHILDCARE MNGMT FEES & SUBS COSTS","EXP - PURCH OF GDS/SERV - PERSONNEL RELATED - CHILDCARE MNGMT FEES & SUBS COSTS"," - Exp - Purch Of Gds/Serv - Personnel Related - Childcare Mngmt Fees & Subs Costs"]
[null,5212103001,"EXP - PURCH OF GDS/SERV - PERSONNEL RELATED - SUBSCRIPTION TO PROF BODIES","EXP - PURCH OF GDS/SERV - PERSONNEL RELATED - SUBSCRIPTION TO PROF BODIES"," - Exp - Purch Of Gds/Serv - Personnel Related - Subscription To Prof Bodies"]
[null,5212103002,"EXP - PURCH OF GDS/SERV - PERSONNEL RELATED - WELFARE SERVICES","EXP - PURCH OF GDS/SERV - PERSONNEL RELATED - WELFARE SERVICES"," - Exp - Purch Of Gds/Serv - Personnel Related - Welfare Services"]
[null,5219100000,"EXP - PURCHASE OF GOODS/SERVICES - AIR TRAVEL","AIR TRAVEL"," - Air Travel"]
[null,5215200000,"EXP - PURCHASE OF GOODS/SERVICES - CATERING & HOSPITALITY","CATERING & HOSPITALITY"," - Catering & Hospitality"]
[null,5215203001,"EXP - PURCHASE OF GOODS/SERVICES - CATERING & HOSPITALITY - MEETING REFRESHMENTS","CATERING & HOSPITALITY - MEETING REFRESHMENTS"," - Catering & Hospitality - Meeting Refreshments"]
[null,5215203002,"EXP - PURCHASE OF GOODS/SERVICES - CATERING & HOSPITALITY - WORKING LUNCHES","CATERING & HOSPITALITY - WORKING LUNCHES"," - Catering & Hospitality - Working Lunches"]
[null,5219600001,"EXP - PURCHASE OF GOODS/SERVICES - COMMITTEE EXPENSES","COMMITTEE EXPENSES"," - Committee Expenses"]
[null,5219600002,"EXP - PURCHASE OF GOODS/SERVICES - FOREIGN SUBSISTENCE","FOREIGN SUBSISTENCE"," - Foreign Subsistence"]
[null,5219500000,"EXP - PURCHASE OF GOODS/SERVICES - HOTELS & ACCOMMODATION","HOTELS & ACCOMMODATION"," - Hotels & Accommodation"]
[null,5217100000,"EXP - PURCHASE OF GOODS/SERVICES - OFFICE RELATED","OFFICE RELATED"," - Office Related"]
[null,5217100001,"EXP - PURCHASE OF GOODS/SERVICES - OFFICE RELATED - PUBLICATIONS","OFFICE RELATED - PUBLICATIONS"," - Office Related - Publications"]
[null,5224100007,"EXP - PURCHASE OF GOODS/SERVICES - OTHER - PROGRAMME EXPENDITURE","OTHER - PROGRAMME EXPENDITURE"," - Other - Programme Expenditure"]
[null,5224100008,"EXP - PURCHASE OF GOODS/SERVICES - OTHER - RESEARCH AND DEVELOPMENT","OTHER - RESEARCH AND DEVELOPMENT"," - Other - Research And Development"]
[null,5219700001,"EXP - PURCHASE OF GOODS/SERVICES - OTHER FOREIGN TRAVEL","OTHER FOREIGN TRAVEL"," - Other Foreign Travel"]
[null,5211400000,"EXP - PURCHASE OF GOODS/SERVICES - OTHER PROFESSIONAL SERVICES","OTHER PROFESSIONAL SERVICES"," - Other Professional Services"]
[null,5219700000,"EXP - PURCHASE OF GOODS/SERVICES - OTHER TRAVEL","OTHER TRAVEL"," - Other Travel"]
[null,5219700002,"EXP - PURCHASE OF GOODS/SERVICES - OTHER TRAVEL - MILEAGE","OTHER TRAVEL - MILEAGE"," - Other Travel - Mileage"]
[null,5219703000,"EXP - PURCHASE OF GOODS/SERVICES - OTHER TRAVEL - TRANSPORT","OTHER TRAVEL - TRANSPORT"," - Other Travel - Transport"]
[null,5212100000,"EXP - PURCHASE OF GOODS/SERVICES - PERSONNEL RELATED","PERSONNEL RELATED"," - Personnel Related"]
[null,5212103007,"EXP - PURCHASE OF GOODS/SERVICES - PERSONNEL RELATED - COMFORT GIFTS","PERSONNEL RELATED - COMFORT GIFTS"," - Personnel Related - Comfort Gifts"]
[null,5212100006,"EXP - PURCHASE OF GOODS/SERVICES - PERSONNEL RELATED - EYE SIGHT TESTING","PERSONNEL RELATED - EYE SIGHT TESTING"," - Personnel Related - Eye Sight Testing"]
[null,5212100003,"EXP - PURCHASE OF GOODS/SERVICES - PERSONNEL RELATED - MEMBERSHIP OF ORGANISATIONS","PERSONNEL RELATED - MEMBERSHIP OF ORGANISATIONS"," - Personnel Related - Membership Of Organisations"]
[null,5212100001,"EXP - PURCHASE OF GOODS/SERVICES - PERSONNEL RELATED - RELOCATION EXPENSES","PERSONNEL RELATED - RELOCATION EXPENSES"," - Personnel Related - Relocation Expenses"]
[null,5219200000,"EXP - PURCHASE OF GOODS/SERVICES - RAIL TRAVEL","RAIL TRAVEL"," - Rail Travel"]
[null,5219600000,"EXP - PURCHASE OF GOODS/SERVICES - SUBSISTENCE","SUBSISTENCE"," - Subsistence"]
[null,5219603001,"EXP - PURCHASE OF GOODS/SERVICES - SUBSISTENCE - T&S TRAVEL ALLOWANCES","SUBSISTENCE - T&S TRAVEL ALLOWANCES"," - Subsistence - T&S Travel Allowances"]
[null,5219300000,"EXP - PURCHASE OF GOODS/SERVICES - TAXI SERVICES","TAXI SERVICES"," - Taxi Services"]
[null,5218200002,"EXP - PURCHASE OF GOODS/SERVICES - TELECOMS - TELEPHONE","TELECOMS - TELEPHONE"," - Telecoms - Telephone"]
[null,5211300000,"EXP - PURCHASE OF GOODS/SERVICES - TRAINING & DEVELOPMENT","TRAINING & DEVELOPMENT"," - Training & Development"]