{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Instructions","General Information","Accountants' Report","Contents","Board of Management Report","Accounts Report","Income & Exp Account","Balance Sheet","Notes to the accounts (1)","Notes to the accounts (2)","Notes to the accounts (3)","Income Account","Expenditure Account (1)","Expenditure Account (2)","Detailed Balance Sheet","Financial Report Parents (1)","Financial Report Parents (2)","Cash Flow Statement","Import","Import From Manual","Import Comparisons","Import Manual Comparisons"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":34,"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":"Instructions","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"FSSU Main Menu"]
[]
[null,null,null,"Accountants' Report Master Template"]
[]
[]
["Steps","Task"]
[]
[]
[1,"Import from Manual System - >>"]
[null,null,null,null,null,null,null,null,"click"]
[]
[2,"Import Comparisons - >>"]
[]
[]
["3a","Print Accountants' Report Standard ->>"]
[]
[null,"or"]
[]
["3b","Print Accountants' Report With Cashflow ->>"]
[]
[4,"Create Portal Import File ->>"]
[]
[]
[]
[null,"Admin"]

{"sheet":"General Information","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,3],[29,1,29,3],[31,3,31,4],[3,1,3,2],[5,1,5,2],[8,1,8,4],[9,1,9,4],[10,1,10,4],[12,1,12,4],[19,1,19,3],[21,3,21,4],[24,1,24,3],[26,3,26,4],[16,3,16,4]]}
[null,{"$f":"E4","v":"Sample School"},null,null,null,"Instructions"]
[null,"General Information"]
[]
[null,"School Name",null,null,"Sample School"]
[]
[null,"School Address"]
[]
[]
[null,"Roll Number",null,null,null,"12345G"]
[]
[null,"RCN Number"]
[]
[null,"Pupil Enrolment for the Year"]
[]
[null,"Patron",null,null,"Name"]
[]
[null,null,null,"Address"]
[]
[]
[null,"Trustee (where applicable)",null,null,"Name"]
[]
[null,null,null,"Address"]
[]
[]
[null,"Accountant/Auditor",null,null,"Name"]
[]
[null,null,null,"Address"]
[]
[]
[null,"Bankers",null,null,"Name"]
[]
[null,null,null,"Address"]

{"sheet":"Accountants' Report","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,1,7,7],[18,1,18,7],[20,0,20,8],[24,0,24,2],[4,1,4,7],[14,2,14,6],[13,2,13,6]]}
[null,null,null,null,null,null,"Instructions"]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'General Information'!E4","v":"Sample School"}]
[]
[]
[]
[]
[]
[null,null,"Accountant’s Report"]
[null,null,"FINANCIAL ACCOUNTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For the Year",null,null,"September 1,","2020","TO ","August 31, ","2021"]

{"sheet":"Contents","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2],[6,0,7,0],[6,1,6,5],[6,6,7,6],[21,1,21,4],[7,1,7,5],[9,1,9,5],[11,1,11,5],[19,1,19,5],[13,1,13,5],[15,1,15,5],[17,1,17,5]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,"Instructions"]
[null,"Contents"]
[]
[null,null,null,null,null,null,null,"Page"]
[]
[null,"Board of Management Report",null,null,null,null,"                    ","1-2"]
[]
[null,"Accountant’s/Audit Report",null,null,null,null,null,3]
[]
[null,"Income and Expenditure Account",null,null,null,null,null,4]
[]
[null,"Balance Sheet",null,null,null,null,null,5]
[]
[null,"Notes to the Accounts   ",null,null,null,null,null,"6-8"]
[]
[null,"Detailed Income and Expenditure Account",null,null,null,null,null,"9-11"]
[]
[null,"Detailed Balance Sheet",null,null,null,null,null,12]
[]
[null,"Financial Report to Parents",null,null,null,null,null,"13-14"]
[]
[null,"Cash Flow Statement (Optional)",null,null,null,null,null,15]

{"sheet":"Board of Management Report","index":4,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[26,0,26,8],[30,0,32,8],[36,0,37,7],[52,0,54,7],[5,0,5,8],[8,0,8,8],[11,0,11,8],[15,0,17,7],[21,1,22,7],[24,0,25,8]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
[]
["BOARD OF MANAGEMENT REPORT"]
["FOR THE YEAR ENDED 31ST AUGUST 2021"]
[null,null,null,null,"SAMPLE"]
["The Boards presents its report and financial statements for the year ended 31st August 2021"]
[]
["•","Objectives and Activities;"]
["The principal activity of the school was to provide education in the context of the ethos of a Primary School in accordance with the founding intention, as articulated by the Patron."]
[" "]
["•","Achievements and Performance;"]
["The level of activity for the year and the financial position were satisfactory. The Board expects that the level of activity will be sustained for the foreseeable future."]
[]
["•","Financial Review and Responsibility for Finances;"]
[]
["Section 18 of the Education Act requires the board to keep all proper and usual accounts and records of all monies received by it or expenditure incurred by it, and to prepare financial statements for each financial year, which give a true and fair view of the state of affairs of the school, and of the surplus or deficit of the school for that year. In preparing them the board is required to:"]
[]
[]
[]
["•","Select suitable accounting policies and apply them consistently"]
["•","Make adjustments and estimates that are reasonable and prudent"]
["•","Prepare the financial statement on a \"going concern basis\" unless it is inappropriate to presume that the school will continue to operate."]
[]
[]
["The board is responsible for keeping proper accounts, which disclose with reasonable accuracy at any time the financial position of the school and to enable them to ensure that the financial statements comply with the Education Act 1998. There are also responsible for safeguarding the assets of the school and hence for taking reasonable steps for the prevention and detection of fraud and other irregularities. "]
[]
["At year end, annual accounts are submitted to the FSSU. "]
[]
["•","Structure, Governance and Management; "]
[]
["The measures taken by the Board to ensure compliance with the requirements of the Governance Manual 2019-2023 and the Education Act 1998, regarding proper books of account, are the implementation of necessary policies and procedures for recording transactions, the employment of competent accounting personnel with appropriate expertise, and the provision of adequate resources to the financial function. The books of account of the school are maintained at the school premises."]
[]
[]
[]
["•","Reference and Administrative details;"]
[]
["The Board of Management maintain records in compliance with the Primary School Guidelines 2019-2023 and the Education Act 1998."]
[]
[]
[]
["Names of Board Members:"]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
["Auditors / Accountants"]
[]
["……………………………………………………………., continue in office as Auditors/Accountants in accordance with the requirement of the board in pursuance of adherence to the Education Act 1998."]
[]
[]
[]
[]
[]
[]
["On behalf of the Board;"]
[]
[]
[]
["Chairperson",null,null,null,null,"Board Member"]
["Date: 00 /00/ 00",null,null,null,null,"Date: 00 /00/ 00"]

{"sheet":"Accounts Report","index":5,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[21,5,21,7],[22,5,22,7],[8,0,8,5],[9,0,12,7],[20,5,20,7],[16,0,16,3],[3,4,3,6],[2,0,2,7],[16,5,16,7],[6,1,6,3],[3,1,3,3],[7,0,7,7],[4,0,4,7]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
[]
["ACCOUNTANT'S REPORT ON THE ACCOUNTS TO THE BOARD "]
[]
["  OR "]
[]
[]
[" AUDITOR’S REPORT TO TRUSTEE/PATRON"]

{"sheet":"Income & Exp Account","index":6,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,0,3,5],[17,1,17,2],[9,1,9,2],[11,1,11,2],[13,1,13,2],[15,1,15,2]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,"Instructions"]
[]
[]
["Income and Expenditure Account for the year ended",null,null,null,null,null,{"$f":"'Accountants'' Report'!G25","v":"August 31, "},{"$f":"'Accountants'' Report'!H25","v":"2021"}]
[]
[]
[null,null,null,null,null,"   Actual                    ",null,"Actual"]
[null,null,null,null,null,"2020/2021",null,"2019/2020"]
[]
[null,"Total Income ",null,null,null,{"$f":"SUM('Income Account'!F99)","v":0},null,{"$f":"'Income Account'!H99","v":0}]
[]
[null,"Total Expenditure",null,null,null,{"$f":"'Expenditure Account (2)'!F83","v":0},null,{"$f":"'Expenditure Account (2)'!H83","v":0}]
[]
[null,"Surplus / Deficit  ",null,null,null,{"$f":"F10-F12","v":0},null,{"$f":"H10-H12","v":0}]
[]
[null,"Opening Balance",null,null,null,{"$f":"'Detailed Balance Sheet'!F74","v":0},null,{"$f":"'Detailed Balance Sheet'!H74","v":0}]
[]
[null,"Closing Balance",null,null,null,{"$f":"F14+F16","v":0},null,{"$f":"H14+H16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["On behalf of the board;"]
[]
[]
[]
[]
[null,"Chairperson",null,null,null,"Board Member"]
[]
[]
[null,"Date   "]

{"sheet":"Balance Sheet","index":7,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[40,1,40,3],[40,5,40,7],[42,1,42,2],[43,1,43,2],[22,6,23,6],[22,7,23,7],[29,1,29,3],[31,1,31,3],[39,1,39,3],[39,5,39,7],[22,4,23,4],[22,5,23,5],[33,1,33,3],[25,1,25,3],[27,1,27,3],[35,1,35,3],[5,1,5,2],[7,1,7,3],[12,1,12,2],[14,1,14,3],[8,1,8,3],[10,1,10,3],[22,0,23,0],[15,1,15,3],[18,1,18,3],[20,1,20,3],[22,1,22,3],[17,1,17,2],[16,1,16,3]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,"Instructions"]
[]
[null,"Balance Sheet as at ",null,null,"August 31, ",{"$f":"'Accountants'' Report'!H25","v":"2021"}]
[null,null,null,null,null,"Actual ",null,"Actual"]
[null,null,null,null,null,"2020/2021",null,"2019/2020"]
[null,"1.  Fixed Assets",null,null,"Note 2"]
[]
[null,"Fixtures and Fittings ",null,null,null,{"$f":"'Detailed Balance Sheet'!F8+'Detailed Balance Sheet'!F9+'Detailed Balance Sheet'!F10+'Detailed Balance Sheet'!F11","v":0},null,{"$f":"'Detailed Balance Sheet'!H8+'Detailed Balance Sheet'!H9+'Detailed Balance Sheet'!H10+'Detailed Balance Sheet'!H11","v":0}]
[null,"ICT Infrastructure ",null,null,null,{"$f":"'Detailed Balance Sheet'!F16+'Detailed Balance Sheet'!F17+'Detailed Balance Sheet'!F14+'Detailed Balance Sheet'!F15","v":0},null,{"$f":"'Detailed Balance Sheet'!H16+'Detailed Balance Sheet'!H17+'Detailed Balance Sheet'!H14+'Detailed Balance Sheet'!H15","v":0}]
[null,"Capital Other",null,null,null,{"$f":"'Detailed Balance Sheet'!F6+'Detailed Balance Sheet'!F7+'Detailed Balance Sheet'!F12+'Detailed Balance Sheet'!F13+'Detailed Balance Sheet'!F18+'Detailed Balance Sheet'!F19","v":0},null,{"$f":"'Detailed Balance Sheet'!H6+'Detailed Balance Sheet'!H7+'Detailed Balance Sheet'!H12+'Detailed Balance Sheet'!H13+'Detailed Balance Sheet'!H18+'Detailed Balance Sheet'!H19","v":0}]
[null,"Total Fixed Assets",null,null,null,{"$f":"F8+F9+F10","v":0},null,{"$f":"H8+H9+H10","v":0}]
[]
[null,"2.  Current Assets",null,null,"Note 3"]
[]
[null,"Debtors and prepaid expenses ",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F22:F25)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H22:H25)","v":0}]
[null,"Cash at bank and in hand",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F26:F35)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H26:H35)","v":0}]
[null,"Total Current Assets",null,null,null,{"$f":"F15+F16","v":0},null,{"$f":"H15+H16","v":0}]
[]
[null,"3.  Current Liabilities",null,null,"Note 4"]
[]
[null,"Creditors and accrued expenses",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F38:F69)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H38:H69)","v":0}]
[]
[null,"4. Long Term Liabilities",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F70)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H70)","v":0}]
[null,"Long Term Loan"]
[]
[null,"Assets less Liabilities",null,null,null,{"$f":"F11+F17-F21-F23","v":0},null,{"$f":"H11+H17-H21-H23","v":0}]
[]
[null,"Capital and Reserves"]
[]
[null,"5. Contribution towards the Cost of Fixed Assets",null,null,"Note 5,6",{"$f":"SUM('Detailed Balance Sheet'!F75:F94)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H75:H94)","v":0}]
[]
[null,"6. Current Period Surplus/Deficit on Income and Expenditure Account",null,null,null,{"$f":"'Income & Exp Account'!F14","v":0},null,{"$f":"'Income & Exp Account'!H14","v":0}]
[]
[null,"7. Prior Periods Surplus/Deficit on Income and Expenditure Account",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F74)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H74)","v":0}]
[]
[null,"Total Capital and Reserves",null,null,null,{"$f":"F30+F32+F34","v":0},null,{"$f":"H30+H32+H34","v":0}]
[]
["On behalf of the board;"]
[]
[]
[null,"Chairperson",null,null,null,"Board Member"]
[]
[]
[null,"Date   "]

{"sheet":"Notes to the accounts (1)","index":8,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,3,27,4],[28,3,28,4],[29,3,29,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[24,3,26,4],[24,6,26,6],[11,6,11,8],[11,9,11,10],[12,1,12,5],[13,1,13,5],[14,1,14,5],[12,6,14,8],[12,9,14,10],[9,6,9,8],[9,9,9,10],[10,1,10,5],[10,6,10,8],[10,9,10,10],[7,6,7,8],[7,9,7,10],[8,1,8,5],[8,6,8,8],[8,9,8,10],[5,6,5,8],[5,9,5,10],[6,1,6,5],[6,6,6,8],[6,9,6,10],[1,10,2,10],[3,1,3,6],[4,1,4,5],[4,6,4,8],[4,9,4,10],[30,2,30,3],[17,3,17,4],[1,3,2,3],[1,4,2,4],[5,1,5,5],[23,3,23,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[7,1,7,5],[9,1,9,5],[11,1,11,5],[15,2,15,3],[16,2,16,3],[21,2,22,2],[21,3,22,4]]}
[null,{"$f":"'General Information'!B1","v":"Sample School"},null,null,null,null,null,"Instructions"]
[null,"Notes to Financial Statements"]
[]
[null,"1. Accounting Policies: Depreciation, Unspent Government Grants, etc."]
[null,"Depreciation Policy"]
[null,"Items are valued at cost less depreciation based upon the straight-line methodology.  "]
[null,"Fixtures, Fittings & Equipment are depreciated over a five-year useful life.  "]
[null,"Computer/ICT equipment is depreciated over a three-year useful life."]
[]
[null,"Unspent Grants"]
[null,"Specific Government Grants are deferred only if fulfilment of the conditions is incomplete i.e. it cannot be recognised in the year of receipt if the monies have not been allocated against the reason for the grant being given."]
[]
[null,"2. Fixed Assets: Cost, Additions, Depreciation, Net Book Value"]
[]
[null,"   Example: "]
[null,null,"Fixtures, Fittings & Equipment",null,null,"Computer Equipment",null,"Total"]
[null,null,{"$f":"'Balance Sheet'!F5","v":"2020/2021"},null,null,{"$f":"'Balance Sheet'!F5","v":"2020/2021"}]
[null,"Opening Balance ","xxx",null,null,"xxx",null,"xxx"]
[null,"Additions ","xxx",null,null,"xxx",null,"xxx"]
[null,"Disposals ","xxx",null,null,"xxx",null,"xxx"]
[null,"Closing Balance ","xxx",null,null,"xxx",null,"xxx"]
[]
[null,"Accumulated Depreciation"]
[null,"Opening Balance ","xxx",null,null,"xxx",null,"xxx"]
[null,"Current Year Depreciation","xxx",null,null,"xxx",null,"xxx"]
[]
[null,"Depreciation on Disposal","xxx",null,null,"xxx",null,"xxx"]
[]
[null,"Closing Balance Depreciation","xxx",null,null,"xxx",null,"xxx"]
[null,"Net Book Value","xxx",null,null,"xxx",null,"xxx"]

{"sheet":"Notes to the accounts (2)","index":9,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,11,8,11],[14,1,14,2],[16,1,17,9],[21,2,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[12,1,12,2],[13,1,13,2],[7,1,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,8,8,8],[7,9,8,9],[10,1,10,2],[11,1,11,2],[9,1,9,2],[7,10,8,10],[5,1,5,5],[5,6,5,8],[5,9,5,10],[6,9,6,10],[1,10,2,10],[4,6,4,8],[4,9,4,10]]}
[null,{"$f":"'General Information'!B1","v":"Sample School"},null,null,null,null,null,null,null,"Instructions"]
[]
[null,"3. Debtors and Prepaid Expenses"]
[]
[null,"4. Creditors and Accrued Expenses"]
[]
[null,"Example:"]
[null,"Unspent Grants",null,"Unspent 01-Sep-XX",null,"Government Grants Received",null,"Recognised in I & E",null,"Transfer to Capital Reserves",null,"Unspent  31-Aug-XX"]
[null,null,null,null,null,null,null,"Account"]
[null,"DEIS Grant",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"Book Grant",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"ICT Grant",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"Special Education Equipment",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"DSP Grants - School Meals Grant",null,"xxx",null,"xxx",null,"X xxx x",null,"xxx",null,"xxx"]
[null,null,null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[]
[null,"5. Contribution towards the cost of fixed assets: DE Capital Grants, Fund-raising, Donations, Patron/Trustee Contributions, etc"]
[]
[]
[null,"Example:"]
[null,null,null,"Capital Building",null,"Capital Building",null,"Capital Building",null,"Capital Building"]
[null,null,"DE Grant Contribution",null,"Fundraising Contribution",null,"Parents Contribution",null,"Patron/Trustee Contribution",null,"Total"]
[null,"Income"]
[null,"Opening Balance",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"Received during the year",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"Closing Balance",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"Expenditure"]
[null,"Opening Balance",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"Expended during the year",null,"xxx",null,"xxx",null,"xxx",null,"xxx",null,"xxx"]
[null,"Closing Balance",null,"xxxxx",null,"xxxxx",null,"xxxxx",null,"xxxxx",null,"xxxxx"]
[null,"Net contribution land & buildings",null,"xxxxx",null,"xxxxx",null,"xxxxx",null,"xxxxx",null,"xxxxx"]

{"sheet":"Notes to the accounts (3)","index":10,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'General Information'!B1","v":"Sample School"},null,null,null,null,"Instructions"]
[]
[null,"5.1 Amortisation of non-building Capital Grants"]
[null,"Equipment ICT Capital Total",null,null,null,"Equipment",null,"ICT Capital",null,"Total"]
[null,"Grants received   "]
[null,"Opening Balance ",null,null,null,"xxx",null,"xxx",null,"xxx"]
[null,"Received during the year",null,null,null,"xxx",null,"xxx",null,"xxx"]
[null,"Closing Balance ",null,null,null,"xxx",null,"xxx",null,"xxx"]
[null,"Amortisation "]
[null,"Opening Balance ",null,null,null,"xxx",null,"xxx",null,"xxx"]
[null,"Amortisation for the year  ",null,null,null,"xxx",null,"xxx",null,"xxx"]
[null,"Closing Balance",null,null,null,"xxx",null,"xxx",null,"xxx"]
[null,"Net Contribution    ",null,null,null,"xxx",null,"xxx",null,"xxx"]
[]
[]
[null,"5.2 Summary"]
[null,"Contribution towards the cost of Fixed Assets"]
[null,null,null,null,null,"20XX",null,"20XX"]
[null,"Contribution towards the cost of Land and Buildings",null,null,null,"xxx",null,"xxx"]
[null,"Building Fund Account",null,null,null,"xxx",null,"xxx"]
[null,"Other Capital Grants",null,null,null,"xxx",null,"xxx"]
[null,null,null,null,null,"xxx",null,"xxx"]

{"sheet":"Income Account","index":11,"n_rows":99,"n_cols":10,"rows_kept":99,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
["Detailed Income and Expenditure Account for the year ended ",null,null,null,null,null,{"$f":"'Accountants'' Report'!G25","v":"August 31, "},{"$f":"'Accountants'' Report'!H25","v":"2021"}]
[null,"Income",null,null,null,"Current Actual                    ",null,"Last Year Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2020/2021"},null,{"$f":"'Balance Sheet'!H5","v":"2019/2020"}]
[null,"1. Department of Education Income                                                                     "]
[3010,"Capitation/Non Pay Budget",null,null,null,{"$f":"-IFERROR(VLOOKUP(A6,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A6,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F6=0,H6=0),\"N\",\"Y\")","v":"N"}]
[3020,"DEIS Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A7,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A7,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F7=0,H7=0),\"N\",\"Y\")","v":"N"}]
[3030,"Non Teachers Pay Budget",null,null,null,{"$f":"-IFERROR(VLOOKUP(A8,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A8,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3050,"Ancillary/School Support Services Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A9,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A9,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3100,"Secretarial Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A10,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A10,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3130,"Caretaker Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A11,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A11,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3140,"Special Education Equipment Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A12,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A12,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3150,"Book Grant Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A13,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A13,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3160,"Book Rental Scheme Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A14,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A14,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3170,"Special Subject Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A15,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A15,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3190,"JCSP Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A16,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A16,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3200,"Transition Year Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A17,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A17,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3210,"Leaving Certificate Applied Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A18,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A18,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3220,"Grant for Traveller Students",null,null,null,{"$f":"-IFERROR(VLOOKUP(A19,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A19,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3225,"Amortisation of  DE Equipment Grants",null,null,null,{"$f":"-IFERROR(VLOOKUP(A20,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A20,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3226,"Amortisation of  DE ICT Grants",null,null,null,{"$f":"-IFERROR(VLOOKUP(A21,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A21,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3227,"Amortisation of Other DE Grants",null,null,null,{"$f":"-IFERROR(VLOOKUP(A22,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A22,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3230,"ICT Grant Non Capital",null,null,null,{"$f":"-IFERROR(VLOOKUP(A23,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A23,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3240,"Supervision and Substitution Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A24,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A24,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3245,"Physics/Chemistry Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A25,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A25,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3255,"State Exam Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A26,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A26,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3260,"School Excellence Fund Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A27,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A27,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3270,"Sports Complex Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A28,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A28,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3275,"Minor Works Grant-Non Capital",null,null,null,{"$f":"-IFERROR(VLOOKUP(A29,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A29,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3276,"Temporary Accommodation Grant Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A30,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A30,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3277,"COVID Minor Works Grant           ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A31,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A31,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3280,"COVID Aide Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A32,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A32,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3281,"COVID Capitation PPE Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A33,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A33,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3282,"COVID Enhanced Supervision Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A34,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A34,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3283,"COVID Capitation for Additional Cleaning Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A35,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A35,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3284,"COVID Funding for Replacement Caretaker Hours",null,null,null,{"$f":"-IFERROR(VLOOKUP(A36,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A36,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3285,"COVID Funding for Replacement Secretarial Hours",null,null,null,{"$f":"-IFERROR(VLOOKUP(A37,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A37,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3286,"COVID Funding for Replacement Cleaner Hours",null,null,null,{"$f":"-IFERROR(VLOOKUP(A38,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A38,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3287,"COVID Funding for Replacement Bus Escort Hours",null,null,null,{"$f":"-IFERROR(VLOOKUP(A39,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A39,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3290,"Other Non Capital DE Grant Income                           ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A40,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A40,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3292,"Standardised Testing Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A41,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A41,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3293,"Summer Provision Grant                         ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A42,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A42,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3294,"Bus Escort Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A43,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A43,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Department of Education Income       ",null,null,null,{"$f":"SUM(F6:F43)","v":0},null,{"$f":"SUM(H6:H43)","v":0}]
[null,"2. Other State Income                                                                     "]
[3295,"Department of Children and Youth Affairs Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A46,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A46,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F46=0,H46=0),\"N\",\"Y\")","v":"N"}]
[3296,"DEASP School Meals Grant",null,null,null,{"$f":"-IFERROR(VLOOKUP(A47,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A47,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3297,"Erasmus Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A48,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A48,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3298,"HSE Funding",null,null,null,{"$f":"-IFERROR(VLOOKUP(A49,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A49,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3299,"Other State Funding",null,null,null,{"$f":"-IFERROR(VLOOKUP(A50,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A50,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Other State Income",null,null,null,{"$f":"SUM(F46:F50)","v":0},null,{"$f":"SUM(H46:H50)","v":0}]
[null,"3. School Generated Income                                                   "]
[3300,"Education Fees (Fee paying schools)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A53,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A53,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F53=0,H53=0),\"N\",\"Y\")","v":"N"}]
[3310,"Transition Year Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A54,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A54,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3330,"Book Rental Scheme Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A55,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A55,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3335,"Classroom Books Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A56,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A56,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3350,"Hire of Facilities Rental Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A57,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A57,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3360,"Sports Complex Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A58,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A58,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3370,"Locker Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A59,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A59,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3375,"Journals and Year Book Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A60,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A60,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3390,"School Administration Charges",null,null,null,{"$f":"-IFERROR(VLOOKUP(A61,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A61,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3395,"Practical Subjects Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A62,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A62,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3410,"Adult Education Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A63,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A63,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3420,"Canteen Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A64,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A64,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3430,"Tuck Shop Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A65,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A65,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3440,"Uniforms Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A66,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A66,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3460,"Career Guidance Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A67,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A67,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3450,"Religion/Ethos Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A68,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A68,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3490,"After School Study/Club Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A69,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A69,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3495,"Mock Exam Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A70,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A70,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3500,"Games Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A71,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A71,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3510,"Bus Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A72,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A72,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3520,"School Musical/Drama Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A73,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A73,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3530,"School Tours Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A74,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A74,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3531,"School Swimming Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A75,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A75,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3535,"Student Insurance Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A76,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A76,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3540,"Pre-School Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A77,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A77,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3545,"Summer Camps Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A78,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A78,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3550,"Reimbursable Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A79,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A79,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3570,"Other School Generated Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A80,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A80,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3572,"School Arts and Crafts Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A81,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A81,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3573,"School Dance Income                                                                ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A82,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A82,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3574,"Restricted School Fundraising (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A83,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A83,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3575,"Unrestricted School Fundraising  (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A84,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A84,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3580,"Discounts Given",null,null,null,{"$f":"-IFERROR(VLOOKUP(A85,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A85,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total School Generated Income",null,null,null,{"$f":"SUM(F53:F85)","v":0},null,{"$f":"SUM(H53:H85)","v":0}]
[null,"4. Other Income                                                            "]
[3650,"Voluntary Contributions",null,null,null,{"$f":"-IFERROR(VLOOKUP(A88,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A88,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3700,"Income from Parents Association",null,null,null,{"$f":"-IFERROR(VLOOKUP(A89,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A89,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3770,"Insurance Claim Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A90,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A90,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3800,"Bank Interest Received",null,null,null,{"$f":"-IFERROR(VLOOKUP(A91,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A91,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3840,"Amortisation of Non DE funding                                             ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A92,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A92,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3850,"Other Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A93,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A93,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3851,"Designated Income (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A94,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A94,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3852,"Restricted External Fundraising  (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A95,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A95,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3853,"Unrestricted External Fundraising  (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A96,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A96,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Other Income",null,null,null,{"$f":"SUM(F88:F96)","v":0},null,{"$f":"SUM(H88:H96)","v":0}]
[]
[null,"TOTAL INCOME",null,null,null,{"$f":"F44+F51+F86+F97","v":0},null,{"$f":"H44+H51+H86+H97","v":0}]

{"sheet":"Expenditure Account (1)","index":12,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
["Detailed Income and Expenditure Account for the year ended ",null,null,null,null,null,{"$f":"'Accountants'' Report'!G25","v":"August 31, "},{"$f":"'Accountants'' Report'!H25","v":"2021"}]
[null,"Expenditure",null,null,null,"Actual                    ",null,"Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2020/2021"},null,{"$f":"'Balance Sheet'!H5","v":"2019/2020"}]
[null,"5. Education Salary                                                 "]
[4110,"Substitute Teachers Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A6,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A6,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F6=0,H6=0),\"N\",\"Y\")","v":"N"}]
[4111,"Privately Paid Teachers Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A7,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A7,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F7=0,H7=0),\"N\",\"Y\")","v":"N"}]
[4112,"Chaplain Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A8,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A8,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4150,"Supervision and Substitution Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A9,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A9,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4155,"State Exam Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A10,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A10,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4170,"Adult Education Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A11,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A11,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4180,"Sport Coach Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A12,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A12,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4181,"Canteen Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A13,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A13,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4190,"After School Study/Club Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A14,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A14,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4191,"Summer Camps Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A15,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A15,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4196,"Bus Escort Salary Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A16,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A16,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4197,"COVID Replacement Bus Escort Hours Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A17,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A17,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4198,"Other Educational Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A18,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A18,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4199,"HSE Funded Salaries Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A19,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A19,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Education Salary",null,null,null,{"$f":"SUM(F5:F19)","v":0},null,{"$f":"SUM(H5:H19)","v":0}]
[null,"6. Education Other Expenditure"]
[4310,"Teaching Aids Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A22,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A22,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F22=0,H22=0),\"N\",\"Y\")","v":"N"}]
[4330,"Religion/Ethos Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A23,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A23,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4350,"Art Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A24,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A24,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4370,"Home Economics Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A25,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A25,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4390,"Science Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A26,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A26,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4410,"ICT Grant Non - Capital Expense                   ",null,null,null,{"$f":"IFERROR(VLOOKUP(A27,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A27,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4420,"Computer Maintenance & Support Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A28,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A28,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4430,"Woodwork / Building Construction Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A29,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A29,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4450,"Metalwork / Engineering Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A30,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A30,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4470,"Technology Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A31,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A31,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4490,"Other Subjects Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A32,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A32,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4550,"Leaving Cert Applied Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A33,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A33,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4570,"LCVP Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A34,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A34,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4590,"Transition Year Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A35,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A35,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4610,"Learning Support Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A36,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A36,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4620,"Teacher Inservice and Training Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A37,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A37,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4630,"Career Guidance Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A38,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A38,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4635,"Student Wellbeing Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A39,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A39,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4640,"Library Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A40,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A40,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4650,"Physical Education Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A41,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A41,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4670,"Games (excl. travel) Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A42,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A42,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4671,"Travel Games Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A43,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A43,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4690,"Bus Hire Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A44,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A44,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4710,"School Tours Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A45,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A45,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4720,"School Musical/Drama Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A46,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A46,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4730,"Book Grant Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A47,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A47,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4740,"Book Rental Scheme Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A48,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A48,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4741,"Classroom Book Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A49,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A49,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4750,"Mock Examinations Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A50,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A50,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4760,"School Yearbook/Journal Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A51,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A51,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4770,"Trophies and Prizes Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A52,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A52,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4780,"Uniform Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A53,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A53,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4810,"Home School Liaison Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A54,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A54,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4815,"School Excellence Fund Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A55,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A55,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4850,"Student Council Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A56,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A56,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4908,"Other Summer Camps Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A57,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A57,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4909,"Other Summer Provision Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A58,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A58,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4910,"Other Educational Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A59,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A59,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4911,"Department of Children and Youth Affairs Activities Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A60,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A60,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4912,"DSP School Meals Food Costs                       ",null,null,null,{"$f":"IFERROR(VLOOKUP(A61,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A61,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4913,"Erasmus Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A62,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A62,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4914,"Other Non Capital DE Grants Expense                       ",null,null,null,{"$f":"IFERROR(VLOOKUP(A63,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A63,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4915,"Other Canteen Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A64,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A64,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4916,"Student Insurance Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A65,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A65,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4917,"Standardised Testing Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A66,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A66,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4918,"Designated Expenditure (Non Capital)",null,null,null,{"$f":"IFERROR(VLOOKUP(A67,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A67,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4919,"Special Educational Equipment (Non Capital) Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A68,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A68,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4920,"School Dance Expense                                               ",null,null,null,{"$f":"IFERROR(VLOOKUP(A69,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A69,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4921,"School Swimming Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A70,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A70,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4922,"Restricted School Fundraising Expenses  (Non Capital)",null,null,null,{"$f":"IFERROR(VLOOKUP(A71,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A71,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4923,"Restricted External Fundraising Expenses  (Non Capital)",null,null,null,{"$f":"IFERROR(VLOOKUP(A72,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A72,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4924,"Unrestricted External Fundraising Expenses (Non Capital)",null,null,null,{"$f":"IFERROR(VLOOKUP(A73,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A73,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4925,"Unrestricted School Fundraising Expenses (Non Capital)",null,null,null,{"$f":"IFERROR(VLOOKUP(A74,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A74,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4927,"School Arts and Crafts Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A75,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A75,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4928,"Other HSE Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A76,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A76,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[4930,"Pre-School Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A77,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A77,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Education Other Expenditure",null,null,null,{"$f":"SUM(F22:F77)","v":0},null,{"$f":"SUM(H22:H77)","v":0}]

{"sheet":"Expenditure Account (2)","index":13,"n_rows":88,"n_cols":10,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,0,1,5],[36,1,36,3],[65,1,65,2],[74,1,74,2]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
["Detailed Income and Expenditure Account for the year ended ",null,null,null,null,null,{"$f":"'Accountants'' Report'!G25","v":"August 31, "},{"$f":"'Accountants'' Report'!H25","v":"2021"}]
[null,"Expenditure",null,null,null,"Actual                    ",null,"Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2020/2021"},null,{"$f":"'Balance Sheet'!H5","v":"2019/2020"}]
[null,"7. Repairs, Maintenance & Establishment                                              "]
[5010,"Caretaker Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A6,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A6,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F6=0,H6=0),\"N\",\"Y\")","v":"N"}]
[5011,"COVID Replacement Caretaker Hours Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A7,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A7,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F7=0,H7=0),\"N\",\"Y\")","v":"N"}]
[5020,"Caretaker Sports Complex Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A8,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A8,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5030,"Caretaker Pension Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A9,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A9,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5110,"Cleaners Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A10,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A10,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5111,"COVID Replacement Cleaner Hours Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A11,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A11,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5112,"Cleaners' Pension Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A12,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A12,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5150,"Contract Cleaners Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A13,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A13,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5170,"Cleaning Materials Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A14,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A14,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5175,"Other Cleaning and Sanitation Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A15,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A15,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5310,"Repairs to Buildings and Grounds Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A16,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A16,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5315,"Minor Works Grant (Non Capital) Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A17,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A17,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5316,"COVID Minor Works Grant Expense    ",null,null,null,{"$f":"IFERROR(VLOOKUP(A18,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A18,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5350,"Repairs to Furniture, Fittings and Equipment Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A19,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A19,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5400,"Routine Security Expense                                                        ",null,null,null,{"$f":"IFERROR(VLOOKUP(A20,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A20,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5450,"General Insurance Expense                                                   ",null,null,null,{"$f":"IFERROR(VLOOKUP(A21,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A21,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5510,"Heating Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A22,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A22,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5550,"Light and Power Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A23,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A23,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5551,"Rent of Temporary Accommodation Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A24,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A24,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5552,"Other Rental Costs Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A25,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A25,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5610,"Refuse Expense                          ",null,null,null,{"$f":"IFERROR(VLOOKUP(A26,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A26,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5611,"Water Rates Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A27,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A27,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5700,"Licence Fee to Patron/Trustee Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A28,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A28,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5710,"Sports Complex Repairs & Maintenance Expenses                               ",null,null,null,{"$f":"IFERROR(VLOOKUP(A29,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A29,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5800,"Other Repairs and Maintenance Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A30,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A30,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5801,"COVID Aide Grant Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A31,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A31,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5802,"COVID Capitation for PPE Grant Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A32,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A32,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5803,"COVID Enhanced Supervision Grant Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A33,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A33,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5804,"COVID Capitation for Cleaning Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A34,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A34,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[5805,"COVID Capitation for Cleaning Non Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A35,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A35,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Repairs, Maintenance & Establishment",null,null,null,{"$f":"SUM(F6:F35)","v":0},null,{"$f":"SUM(H6:H35)","v":0}]
[null,"8. Administration"]
[6010,"Clerical Officers/Secretarial Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A38,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A38,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F38=0,H38=0),\"N\",\"Y\")","v":"N"}]
[6011,"COVID Replacement Secretary Hours Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A39,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A39,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6050,"Clerical Officers/Secretarial Pension Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A40,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A40,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6070,"Sports Complex Administrative Wages Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A41,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A41,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6100,"Recruitment Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A42,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A42,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6150,"Advertising / Public Relations Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A43,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A43,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6210,"Postage Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A44,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A44,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6250,"Telephone Expense / SMS Text",null,null,null,{"$f":"IFERROR(VLOOKUP(A45,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A45,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6300,"Printing and Stationery Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A46,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A46,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6305,"Photocopying Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A47,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A47,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6350,"Office Equipment (Non Capital) Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A48,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A48,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6355,"Non-ICT Grant Funded Office Computers Expense        ",null,null,null,{"$f":"IFERROR(VLOOKUP(A49,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A49,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6400,"Accounting / Auditing Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A50,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A50,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6450,"Other Professional Fees Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A51,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A51,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6500,"Travel and Subsistence Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A52,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A52,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6600,"Principals Expenses",null,null,null,{"$f":"IFERROR(VLOOKUP(A53,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A53,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6650,"Board of Management Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A54,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A54,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6700,"Annual Subscriptions Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A55,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A55,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6730,"InSchool Administration System Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A56,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A56,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6731,"Accounting Software / Payroll Software Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A57,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A57,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6750,"Donations to Charity",null,null,null,{"$f":"IFERROR(VLOOKUP(A58,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A58,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6755,"Medical and First Aid Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A59,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A59,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6780,"Staff Room Expenses",null,null,null,{"$f":"IFERROR(VLOOKUP(A60,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A60,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6800,"Hospitality Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A61,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A61,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6830,"Tuck Shop Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A62,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A62,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6870,"Sports Complex Administrative Expenses",null,null,null,{"$f":"IFERROR(VLOOKUP(A63,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A63,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[6900,"Other Administration Expenses",null,null,null,{"$f":"IFERROR(VLOOKUP(A64,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A64,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Administration Expenditure",null,null,null,{"$f":"SUM(F38:F64)","v":0},null,{"$f":"SUM(H38:H64)","v":0}]
[null,"9. Financial"]
[7300,"Leasing Expenses",null,null,null,{"$f":"IFERROR(VLOOKUP(A67,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A67,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F67=0,H67=0),\"N\",\"Y\")","v":"N"}]
[7320,"Loan Charges Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A68,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A68,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[7400,"Bank Interest Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A69,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A69,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[7450,"Bank Charges Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A70,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A70,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[7500,"Pensioners Payroll Expense",null,null,null,{"$f":"IFERROR(VLOOKUP(A71,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A71,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[7800,"Reimbursable Expenses",null,null,null,{"$f":"IFERROR(VLOOKUP(A72,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A72,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[7850,"Discounts Received",null,null,null,{"$f":"IFERROR(VLOOKUP(A73,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A73,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Financial Expenses",null,null,null,{"$f":"SUM(F67:F73)","v":0},null,{"$f":"SUM(H67:H73)","v":0}]
[null,"10. Depreciation"]
[8000,"Annual Depreciation: Buildings",null,null,null,{"$f":"IFERROR(VLOOKUP(A76,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A76,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F76=0,H76=0),\"N\",\"Y\")","v":"N"}]
[8020,"Annual Depreciation: Fixtures, Fittings and Equipment",null,null,null,{"$f":"IFERROR(VLOOKUP(A77,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A77,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[8040,"Annual Depreciation: Motor Vehicles",null,null,null,{"$f":"IFERROR(VLOOKUP(A78,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A78,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[8060,"Annual Depreciation: ICT",null,null,null,{"$f":"IFERROR(VLOOKUP(A79,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A79,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[8080,"Annual Depreciation: Other",null,null,null,{"$f":"IFERROR(VLOOKUP(A80,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A80,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Depreciation",null,null,null,{"$f":"SUM(F76:F80)","v":0},null,{"$f":"SUM(H76:H80)","v":0}]
[]
[null,"TOTAL EXPENDITURE   ",null,null,null,{"$f":"SUM('Expenditure Account (1)'!F20+'Expenditure Account (1)'!F78+F36+F65+F74+F81)","v":0},null,{"$f":"SUM('Expenditure Account (1)'!H20+'Expenditure Account (1)'!H78+H36+H65+H74+H81)","v":0}]
[]
[null,"SURPLUS / DEFICIT     ",null,null,null,{"$f":"SUM('Income Account'!F99)-('Expenditure Account (2)'!F83)","v":0},null,{"$f":"SUM('Income Account'!H99-'Expenditure Account (2)'!H83)","v":0}]
[]
[null,"N.B. All schools are required to classify all items of income and expenditure in accordance "]
[null,"with the layout shown above. Netting off Income and Expenditure is not permissible."]

{"sheet":"Detailed Balance Sheet","index":14,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
[null,"Detailed Balance Sheet for the year ended",null,null,null,{"$f":"'Accountants'' Report'!G25","v":"August 31, "},{"$f":"'Accountants'' Report'!H25","v":"2021"}]
[null,null,null,null,null,"Actual                    ",null,"Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2020/2021"},null,{"$f":"'Balance Sheet'!H5","v":"2019/2020"}]
[null,"Fixed Asset"]
[1400,"Capital: Land and Buildings",null,null,null,{"$f":"IFERROR(VLOOKUP(A6,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A6,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F6=0,H6=0),\"N\",\"Y\")","v":"N"}]
[1410,"Accumulated Depreciation: Land and Buildings",null,null,null,{"$f":"IFERROR(VLOOKUP(A7,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A7,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F7=0,H7=0),\"N\",\"Y\")","v":"N"}]
[1420,"Capital: Fixtures, Fittings and Equipment",null,null,null,{"$f":"IFERROR(VLOOKUP(A8,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A8,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1425,"Capital: Covid Minor Works Fixtures, Fittings and Equipment",null,null,null,{"$f":"IFERROR(VLOOKUP(A9,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A9,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1430,"Accumulated Depreciation: Fixtures, Fittings and Equipment",null,null,null,{"$f":"IFERROR(VLOOKUP(A10,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A10,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1435,"Accumulated Depreciation: Covid Minor Works Fixtures, Fittings and Equipment",null,null,null,{"$f":"IFERROR(VLOOKUP(A11,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A11,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1440,"Capital: Motor Vehicles",null,null,null,{"$f":"IFERROR(VLOOKUP(A12,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A12,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1450,"Accumulated Depreciation: Motor Vehicles",null,null,null,{"$f":"IFERROR(VLOOKUP(A13,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A13,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1460,"Capital: ICT",null,null,null,{"$f":"IFERROR(VLOOKUP(A14,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A14,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1465,"Capital: Covid Minor Works ICT",null,null,null,{"$f":"IFERROR(VLOOKUP(A15,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A15,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1470,"Accumulated Depreciation: ICT",null,null,null,{"$f":"IFERROR(VLOOKUP(A16,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A16,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1475,"Accumulated Depreciation: Covid Minor Works ICT",null,null,null,{"$f":"IFERROR(VLOOKUP(A17,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A17,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1480,"Capital: Other",null,null,null,{"$f":"IFERROR(VLOOKUP(A18,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A18,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1490,"Accumulated Depreciation Other",null,null,null,{"$f":"IFERROR(VLOOKUP(A19,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A19,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[]
[null,"Current Asset"]
[1700,"Sales Ledger Control",null,null,null,{"$f":"IFERROR(VLOOKUP(A22,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A22,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1710,"Stock",null,null,null,{"$f":"IFERROR(VLOOKUP(A23,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A23,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1720,"Prepayments",null,null,null,{"$f":"IFERROR(VLOOKUP(A24,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A24,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1730,"Grants Due",null,null,null,{"$f":"IFERROR(VLOOKUP(A25,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A25,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1800,"Current Account 1",null,null,null,{"$f":"IFERROR(VLOOKUP(A26,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A26,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1801,"Current Account 2",null,null,null,{"$f":"IFERROR(VLOOKUP(A27,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A27,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1802,"Current Account 3",null,null,null,{"$f":"IFERROR(VLOOKUP(A28,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A28,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1803,"DEASP School Meal Bank Account",null,null,null,{"$f":"IFERROR(VLOOKUP(A29,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A29,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1810,"Deposit Account",null,null,null,{"$f":"IFERROR(VLOOKUP(A30,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A30,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1820,"Parents Council/Association Bank Account",null,null,null,{"$f":"IFERROR(VLOOKUP(A31,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A31,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1850,"Credit Card Account",null,null,null,{"$f":"IFERROR(VLOOKUP(A32,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A32,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1870,"Online Payment Solution Clearing Account",null,null,null,{"$f":"IFERROR(VLOOKUP(A33,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A33,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1900,"Petty Cash Account",null,null,null,{"$f":"IFERROR(VLOOKUP(A34,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A34,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[1950,"Cash Control Account",null,null,null,{"$f":"IFERROR(VLOOKUP(A35,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(A35,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[]
[null,"Current Liability"]
[2100,"Creditors Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A38,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A38,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2105,"School Income Received in Advance",null,null,null,{"$f":"-IFERROR(VLOOKUP(A39,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A39,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2150,"Grants Received in Advance",null,null,null,{"$f":"-IFERROR(VLOOKUP(A40,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A40,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2151,"Book Grant Received in Advance",null,null,null,{"$f":"-IFERROR(VLOOKUP(A41,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A41,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2152,"DEIS Grant Received in Advance",null,null,null,{"$f":"-IFERROR(VLOOKUP(A42,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A42,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2160,"Book Grant Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A43,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A43,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2165,"ICT Grant Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A44,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A44,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2166,"Minor Works Grant Unspent ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A45,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A45,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2167,"JCSP Grant Unspent ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A46,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A46,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2168,"Non Teachers Pay Budget Grant Unspent ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A47,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A47,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2169,"COVID Minor Works Grant Unspent ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A48,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A48,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2170,"Supervision and Substitution Grant Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A49,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A49,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2171,"Other Ringfenced Grants Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A50,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A50,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2172,"Other Ringfenced Income Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A51,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A51,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2180,"School Excellence Fund Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A52,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A52,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2181,"COVID Aide Grant Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A53,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A53,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2182,"COVID Capitation for PPE Grant Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A54,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A54,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2183,"COVID Enhanced Supervision Grant Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A55,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A55,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2184,"COVID Capitation for Additional Cleaning Grant Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A56,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A56,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2185,"COVID Replacement Hours Unspent",null,null,null,{"$f":"-IFERROR(VLOOKUP(A57,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A57,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2200,"Net Wages Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A58,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A58,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2210,"Union Fees Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A59,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A59,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2220,"Single Public Service Pension Scheme Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A60,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A60,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2230,"ASC Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A61,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A61,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2240,"PRSA Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A62,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A62,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2250,"PAYE/PRSI/USC/LPT Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A63,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A63,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2260,"Reverse VAT Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A64,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A64,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2270,"RCT Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A65,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A65,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2310,"Bank Loans",null,null,null,{"$f":"-IFERROR(VLOOKUP(A66,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A66,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2320,"Other Loan",null,null,null,{"$f":"-IFERROR(VLOOKUP(A67,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A67,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2330,"Leasing",null,null,null,{"$f":"-IFERROR(VLOOKUP(A68,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A68,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2440,"Accruals",null,null,null,{"$f":"-IFERROR(VLOOKUP(A69,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A69,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2600,"Long Term Loan ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A70,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A70,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,null,null,null,null,{"$f":"SUM(F6:F19,F22:F35)-SUM(F38:F70)","v":0},null,{"$f":"SUM(H6:H19,H22:H35)-SUM(H38:M70)","v":0}]
[null,"Capital & Reserves"]
[2700,"Retained Surplus",null,null,null,{"$f":"SUM('Income & Exp Account'!F14)","v":0},null,{"$f":"SUM('Income & Exp Account'!H14)","v":0},null,{"$f":"IF(AND(F73=0,H73=0),\"N\",\"Y\")","v":"N"}]
[2710,"Surplus Brought Forward",null,null,null,{"$f":"-IFERROR(VLOOKUP(A74,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A74,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F74=0,H74=0),\"N\",\"Y\")","v":"N"}]
[3900,"DE Capital Building Grant Income                                         ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A75,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A75,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3901,"Capital Projects Fundraising Income                                        ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A76,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A76,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3902,"Parents Contribution to Capital Projects Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A77,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A77,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3903,"Patron/Trustee Contribution to Capital Projects Income    ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A78,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A78,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3904,"Other State Capital Projects Income                                           ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A79,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A79,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3905,"Covid Minor Works Capital Grant Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A80,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A80,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3906,"Accumulated Amortisation of Capital Building Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A81,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A81,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3907,"Capital Donations Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A82,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A82,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3920,"DE Fixtures, Fittings & Equipment Grant Income                                     ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A83,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A83,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3921,"DE ICT Grant Capital Income                                                                   ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A84,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A84,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3925,"Accumulated Amortisation of Capital Equipment Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A85,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A85,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3926,"Accumulated Amortisation of ICT Grant Capital Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A86,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A86,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3940,"DE Capital Building Grant Expense                                         ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A87,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A87,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3941,"Covid Minor Works Building Expense",null,null,null,{"$f":"-IFERROR(VLOOKUP(A88,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A88,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3960,"Capital Building Fundraising Expense                                 ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A89,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A89,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3970,"Parents Contribution to Capital Building Expense            ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A90,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A90,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3990,"Patron/Trustee Contribution to Capital Building Expense  ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A91,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A91,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3991,"Other State Capital Building Expense                             ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A92,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A92,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3992,"Capital Donations Building Expense",null,null,null,{"$f":"-IFERROR(VLOOKUP(A93,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A93,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3995,"Building Fund Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A94,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A94,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,null,null,null,null,{"$f":"SUM(F73:F94)","v":0},null,{"$f":"SUM(H73:H94)","v":0}]

{"sheet":"Financial Report Parents (1)","index":15,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,1,3,5],[33,3,33,5],[34,3,34,5],[18,1,18,2]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
[null,"Financial Report to Parents"]
[]
[null,"Summary Financial Statement for the School Year",null,null,null,null,{"$f":"'Expenditure Account (1)'!F4","v":"2020/2021"}]
[]
[null,"Income ",null,null,null,null,null,"€"]
[null,"Department of Education Funding",null,null,null,null,null,{"$f":"SUM(PR_DES_Inc)","v":0}]
[null,"Other State Funding",null,null,null,null,null,{"$f":"SUM(PR_Oth_State_Fund)","v":0}]
[]
[null,"School Income",null,null,"Parent Voluntary Contributions",null,null,{"$f":"SUM('Income Account'!F88)","v":0}]
[null,null,null,null,"Rental School Property",null,null,{"$f":"SUM('Income Account'!F57+'Income Account'!F58)","v":0}]
[null,null,null,null,"Fundraising ",null,null,{"$f":"SUM(PR_Fundraising)","v":0}]
[null,null,null,null,"Parents Association",null,null,{"$f":"SUM('Income Account'!F89)","v":0}]
[null,null,null,null,"Other Income",null,null,{"$f":"SUM(PR_Oth_Inc)","v":0}]
[]
[null,"Total Income",null,null,null,null,null,{"$f":"SUM(H7:H14)","v":0}]
[]
[null,"Expenditure"]
[null,"Education Expenditure ",null,null,"Classroom Materials and Teaching Aids ",null,null,{"$f":"SUM(PR_Class_Mat_Teach_Aids)","v":0}]
[null,null,null,null,"All Other Education Related Expenditure",null,null,{"$f":"SUM(PR_All_Oth_Ed_Exp)","v":0}]
[]
[null,"School Maintenance",null,null,"Light, Heat and Power",null,null,{"$f":"SUM('Expenditure Account (2)'!F22:F23)","v":0}]
[null,null,null,null,"Insurance",null,null,{"$f":"'Expenditure Account (2)'!F21","v":0}]
[null,null,null,null,"Cleaning and waste disposal",null,null,{"$f":"SUM('Expenditure Account (2)'!F13:F15)","v":0}]
[null,null,null,null,"Rent, Rates and Local Charges",null,null,{"$f":"SUM('Expenditure Account (2)'!F24:F28)","v":0}]
[null,null,null,null,"All Other Caretaking and Maintenance ",null,null,{"$f":"SUM(PR_All_Oth_Care_Main)","v":0}]
[]
[null,"School Administration",null,null,"Printing, Postage and Stationary",null,null,{"$f":"SUM('Expenditure Account (2)'!F44+'Expenditure Account (2)'!F46+'Expenditure Account (2)'!F47)","v":0}]
[null,null,null,null,"In-School Administration Systems",null,null,{"$f":"SUM('Expenditure Account (2)'!F56:F57)","v":0}]
[null,null,null,null,"Telephone/SMS",null,null,{"$f":"'Expenditure Account (2)'!F45","v":0}]
[null,null,null,null,"All other Administration Expenses ",null,null,{"$f":"SUM(PR_All_oth_Admin_Exp)","v":0}]
[]
[null,"Financial",null,null,"Bank Charges, Interest, Leasing",null,null,{"$f":"SUM('Expenditure Account (2)'!F67:F73)","v":0}]
[]
[null,"Total Expenditure",null,null,null,null,null,{"$f":"SUM(H19:H34)","v":0}]
[]
[null,"Surplus (Deficit) for the year",null,null,null,null,null,{"$f":"SUM('Financial Report Parents (1)'!H16-'Financial Report Parents (1)'!H35)","v":0}]

{"sheet":"Financial Report Parents (2)","index":16,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,1,5,5],[31,3,31,5],[32,3,32,5],[15,0,21,0],[21,1,21,4]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
[]
[null,"Financial Report to Parents"]
[]
[]
[null,"Summary Financial Statement for the School Year",null,null,null,null,{"$f":"'Expenditure Account (1)'!F4","v":"2020/2021"}]
[]
[]
[null,"Capital Building Projects"]
[]
[]
[null,"Income ",null,null,"Department Capital Grants Income",null,null,{"$f":"SUM('Detailed Balance Sheet'!F75)","v":0}]
[null,null,null,null,"Other Capital Income",null,null,{"$f":"SUM('Detailed Balance Sheet'!F76+'Detailed Balance Sheet'!F77+'Detailed Balance Sheet'!F78)","v":0}]
[null,null,null,null,"Other State Capital Income",null,null,{"$f":"'Detailed Balance Sheet'!F79","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H14)","v":0}]
[null,"Less: Expenditure ",null,null,"Department Capital Grants Expenditure",null,null,{"$f":"-'Detailed Balance Sheet'!F87","v":0}]
[null,null,null,null,"Other Capital Expenditure",null,null,{"$f":"-SUM('Detailed Balance Sheet'!F89+'Detailed Balance Sheet'!F90+'Detailed Balance Sheet'!F91)","v":0}]
[null,null,null,null,"Other State Capital Expenditure",null,null,{"$f":"-'Detailed Balance Sheet'!F92","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H16:H18)","v":0}]
[]
[]
[null,"Surplus (Deficit) for the year",null,null,null,null,null,{"$f":"SUM(H15-H19)","v":0}]

{"sheet":"Cash Flow Statement","index":17,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,1,33,2],[34,1,34,2],[3,5,6,5],[30,1,30,3],[30,5,30,7],[31,1,31,3],[31,5,31,7]]}
[null,{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,"Instructions"]
[]
[null,"Cash Flow Statement for the year ended (Optional)",null,null,"August 31, ",{"$f":"'Accountants'' Report'!H25","v":"2021"}]
[null,null,null,null,"20XX",null,"    20XX"]
[null,null,"Note",null,"€",null,"€"]
[]
[null,"Cash flow from operating activities"]
[null,"(Deficit) for the year"]
[null,"Adjustments:"]
[null,"Depreciation"]
[null,"Amortisation of Capital Grants"]
[null,"Decrease/(lncrease) in Debtors"]
[null,"(Decrease)/Increase in Creditors"]
[null,"Net cash inflow from school activities"]
[null,"Cash flow from investing activities"]
[null,"Capital Expenditure"]
[null,"Future Funds Contributions"]
[null,"Net cash inflow from investing activities"]
[]
[]
[]
[null,"Increase in cash"]
[null,"Cash and cash equivalents at 1st September 20XX"]
[null,"Cash and cash equivalents at 31st August 20XX"]
[]
[]
[]
[]
["Approved on behalf of the Board:"]
[]
[]
[null,"Chairperson",null,null,null,"Board Member"]
[]
[]
[null,"Date   "]

{"sheet":"Import","index":18,"n_rows":312,"n_cols":3,"rows_kept":312,"cut":false,"hidden":false,"merged":[]}
["Roll No","12345G","Instructions"]
["Nominal Code"]
["Nominal Code","Final Accounts ","Description"]
[3010,0,"Capitation/Non Pay Budget"]
[3020,0,"DEIS Grant"]
[3030,0,"Non Teachers Pay Budget"]
[3050,0,"Ancillary/School Support Services Grant"]
[3100,0,"Secretarial Grant"]
[3130,0,"Caretaker Grant"]
[3140,0,"Special Education Equipment Grant"]
[3150,0,"Book Grant Income"]
[3160,0,"Book Rental Scheme Grant"]
[3170,0,"Special Subject Grant"]
[3190,0,"JCSP Grant"]
[3200,0,"Transition Year Grant"]
[3210,0,"Leaving Certificate Applied Grant"]
[3220,0,"Grant for Traveller Students"]
[3225,0,"Amortisation of  DE Equipment Grants"]
[3226,0,"Amortisation of  DE ICT Grants"]
[3227,0,"Amortisation of Other DE Grants"]
[3230,0,"ICT Grant Non Capital"]
[3240,0,"Supervision and Substitution Grant"]
[3245,0,"Physics/Chemistry Grant"]
[3255,0,"State Exam Income"]
[3260,0,"School Excellence Fund Income"]
[3270,0,"Sports Complex Grant"]
[3275,0,"Minor Works Grant-Non Capital"]
[3276,0,"Temporary Accommodation Grant Income"]
[3277,0,"COVID Minor Works Grant           "]
[3280,0,"COVID Aide Grant"]
[3281,0,"COVID Capitation PPE Grant"]
[3282,0,"COVID Enhanced Supervision Grant"]
[3283,0,"COVID Capitation for Additional Cleaning Grant"]
[3284,0,"COVID Funding for Replacement Caretaker Hours"]
[3285,0,"COVID Funding for Replacement Secretarial Hours"]
[3286,0,"COVID Funding for Replacement Cleaner Hours"]
[3287,0,"COVID Funding for Replacement Bus Escort Hours"]
[3290,0,"Other Non Capital DE Grant Income                           "]
[3292,0,"Standardised Testing Grant"]
[3293,0,"Summer Provision Grant                         "]
[3294,0,"Bus Escort Grant"]
[3295,0,"Department of Children and Youth Affairs Income"]
[3296,0,"DEASP School Meals Grant"]
[3297,0,"Erasmus Income"]
[3298,0,"HSE Funding"]
[3299,0,"Other State Funding"]
[3300,0,"Education Fees (Fee paying schools)"]
[3310,0,"Transition Year Income"]
[3330,0,"Book Rental Scheme Income"]
[3335,0,"Classroom Books Income"]
[3350,0,"Hire of Facilities Rental Income"]
[3360,0,"Sports Complex Income"]
[3370,0,"Locker Income"]
[3375,0,"Journals and Year Book Income"]
[3390,0,"School Administration Charges"]
[3395,0,"Practical Subjects Income"]
[3410,0,"Adult Education Income"]
[3420,0,"Canteen Income"]
[3430,0,"Tuck Shop Income"]
[3440,0,"Uniforms Income"]
[3450,0,"Religion/Ethos Income"]
[3460,0,"Career Guidance Income"]
[3490,0,"After School Study/Club Income"]
[3495,0,"Mock Exam Income"]
[3500,0,"Games Income"]
[3510,0,"Bus Income"]
[3520,0,"School Musical/Drama Income"]
[3530,0,"School Tours Income"]
[3531,0,"School Swimming Income"]
[3535,0,"Student Insurance Income"]
[3540,0,"Pre-School Income"]
[3545,0,"Summer Camps Income"]
[3550,0,"Reimbursable Income"]
[3570,0,"Other School Generated Income"]
[3572,0,"School Arts and Crafts Income"]
[3573,0,"School Dance Income                                                                "]
[3574,0,"Restricted School Fundraising (Non Capital)"]
[3575,0,"Unrestricted School Fundraising  (Non Capital)"]
[3580,0,"Discounts Given"]
[3650,0,"Voluntary Contributions"]
[3700,0,"Income from Parents Association"]
[3770,0,"Insurance Claim Income"]
[3800,0,"Bank Interest Received"]
[3840,0,"Amortisation of Non DE funding                                             "]
[3850,0,"Other Income"]
[3851,0,"Designated Income (Non Capital)"]
[3852,0,"Restricted External Fundraising  (Non Capital)"]
[3853,0,"Unrestricted External Fundraising  (Non Capital)"]
[4110,0,"Substitute Teachers Expense"]
[4111,0,"Privately Paid Teachers Expense"]
[4112,0,"Chaplain Salaries Expense"]
[4150,0,"Supervision and Substitution Salaries Expense"]
[4155,0,"State Exam Salaries Expense"]
[4170,0,"Adult Education Salaries Expense"]
[4180,0,"Sport Coach Salaries Expense"]
[4181,0,"Canteen Salaries Expense"]
[4190,0,"After School Study/Club Salaries Expense"]
[4191,0,"Summer Camps Salaries Expense"]
[4196,0,"Bus Escort Salary Expense"]
[4197,0,"COVID Replacement Bus Escort Hours Expense"]
[4198,0,"Other Educational Salaries Expense"]
[4199,0,"HSE Funded Salaries Expense"]
[4310,0,"Teaching Aids Expense"]
[4330,0,"Religion/Ethos Expense"]
[4350,0,"Art Expense"]
[4370,0,"Home Economics Expense"]
[4390,0,"Science Expense"]
[4410,0," ICT Grant Non - Capital Expense                   "]
[4420,0,"Computer Maintenance & Support Expense"]
[4430,0,"Woodwork / Building Construction Expense"]
[4450,0,"Metalwork / Engineering Expense"]
[4470,0,"Technology Expense"]
[4490,0,"Other Subjects Expense"]
[4550,0,"Leaving Cert Applied Expense"]
[4570,0,"LCVP Expense"]
[4590,0,"Transition Year Expense"]
[4610,0,"Learning Support Expense"]
[4620,0,"Teacher Inservice and Training Expense"]
[4630,0,"Career Guidance Expense"]
[4635,0,"Student Wellbeing Expense"]
[4640,0,"Library Expense"]
[4650,0,"Physical Education Expense"]
[4670,0,"Games (excl. travel) Expense"]
[4671,0,"Travel Games Expense"]
[4690,0,"Bus Hire Expense"]
[4710,0,"School Tours Expense"]
[4720,0,"School Musical/Drama Expense"]
[4730,0,"Book Grant Expense"]
[4740,0,"Book Rental Scheme Expense"]
[4741,0,"Classroom Book Expense"]
[4750,0,"Mock Examinations Expense"]
[4760,0,"School Yearbook/Journal Expense"]
[4770,0,"Trophies and Prizes Expense"]
[4780,0,"Uniform Expense"]
[4810,0,"Home School Liaison Expense"]
[4815,0,"School Excellence Fund Expense"]
[4850,0,"Student Council Expense"]
[4908,0,"Other Summer Camps Expense"]
[4909,0,"Other Summer Provision Expense"]
[4910,0,"Other Educational Expense"]
[4911,0,"Department of Children and Youth Affairs Activities Expense"]
[4912,0,"DSP School Meals Food Costs                       "]
[4913,0,"Erasmus Expense"]
[4914,0,"Other Non Capital DE Grants Expense                       "]
[4915,0,"Other Canteen Expense"]
[4916,0,"Student Insurance Expense"]
[4917,0,"Standardised Testing Expense"]
[4918,0,"Designated Expenditure (Non Capital)"]
[4919,0,"Special Educational Equipment (Non Capital) Expense"]
[4920,0,"School Dance Expense                                               "]
[4921,0,"School Swimming Expense"]
[4922,0,"Restricted School Fundraising Expenses  (Non Capital)"]
[4923,0,"Restricted External Fundraising Expenses  (Non Capital)"]
[4924,0,"Unrestricted External Fundraising Expenses (Non Capital)"]
[4925,0,"Unrestricted School Fundraising Expenses (Non Capital)"]
[4927,0,"School Arts and Crafts Expense"]
[4928,0,"Other HSE Expense"]
[4930,0,"Pre-School Expense"]
[5010,0,"Caretaker Wages Expense"]
[5011,0,"COVID Replacement Caretaker Hours Expense"]
[5020,0,"Caretaker Sports Complex Wages Expense"]
[5030,0,"Caretaker Pension Expense"]
[5110,0,"Cleaners Wages Expense"]
[5111,0,"COVID Replacement Cleaner Hours Expense"]
[5112,0,"Cleaners' Pension Expense"]
[5150,0,"Contract Cleaners Expense"]
[5170,0,"Cleaning Materials Expense"]
[5175,0,"Other Cleaning and Sanitation Expense"]
[5310,0,"Repairs to Buildings and Grounds Expense"]
[5315,0,"Minor Works Grant (Non Capital) Expense"]
[5316,0,"COVID Minor Works Grant Expense    "]
[5350,0,"Repairs to Furniture, Fittings and Equipment Expense"]
[5400,0,"Routine Security Expense                                                        "]
[5450,0,"General Insurance Expense                                                   "]
[5510,0,"Heating Expense"]
[5550,0,"Light and Power Expense"]
[5551,0,"Rent of Temporary Accommodation Expense"]
[5552,0,"Other Rental Costs Expense"]
[5610,0,"Refuse Expense                          "]
[5611,0,"Water Rates Expense"]
[5700,0,"Licence Fee to Patron/Trustee Expense"]
[5710,0,"Sports Complex Repairs & Maintenance Expenses                               "]
[5800,0,"Other Repairs and Maintenance Expense"]
[5801,0,"COVID Aide Grant Wages Expense"]
[5802,0,"COVID Capitation for PPE Grant Expense"]
[5803,0,"COVID Enhanced Supervision Grant Wages Expense"]
[5804,0,"COVID Capitation for Cleaning Wages Expense"]
[5805,0,"COVID Capitation for Cleaning Non Wages Expense"]
[6010,0,"Clerical Officers/Secretarial Wages Expense"]
[6011,0,"COVID Replacement Secretary Hours Expense"]
[6050,0,"Clerical Officers/Secretarial Pension Expense"]
[6070,0,"Sports Complex Administrative Wages Expense"]
[6100,0,"Recruitment Expense"]
[6150,0,"Advertising / Public Relations Expense"]
[6210,0,"Postage Expense"]
[6250,0,"Telephone Expense / SMS Text"]
[6300,0,"Printing and Stationery Expense"]
[6305,0,"Photocopying Expense"]
[6350,0,"Office Equipment (Non Capital) Expense"]
[6355,0,"Non-ICT Grant Funded Office Computers Expense        "]
[6400,0,"Accounting / Auditing Expense"]
[6450,0,"Other Professional Fees Expense"]
[6500,0,"Travel and Subsistence Expense"]
[6600,0,"Principals Expenses"]
[6650,0,"Board of Management Expense"]
[6700,0,"Annual Subscriptions Expense"]
[6730,0,"InSchool Administration System Expense"]
[6731,0,"Accounting Software / Payroll Software Expense"]
[6750,0,"Donations to Charity"]
[6755,0,"Medical and First Aid Expense"]
[6780,0,"Staff Room Expenses"]
[6800,0,"Hospitality Expense"]
[6830,0,"Tuck Shop Expense"]
[6870,0,"Sports Complex Administrative Expenses"]
[6900,0,"Other Administration Expenses"]
[7300,0,"Leasing Expenses"]
[7320,0,"Loan Charges Expense"]
[7400,0,"Bank Interest Expense"]
[7450,0,"Bank Charges Expense"]
[7500,0,"Pensioners Payroll Expense"]
[7800,0,"Reimbursable Expenses"]
[7850,0,"Discounts Received"]
[8000,0,"Annual Depreciation: Buildings"]
[8020,0,"Annual Depreciation: Fixtures, Fittings and Equipment"]
[8040,0,"Annual Depreciation: Motor Vehicles"]
[8060,0,"Annual Depreciation: ICT"]
[8080,0,"Annual Depreciation: Other"]
[1400,0,"Capital: Land and Buildings"]
[1410,0,"Accumulated Depreciation: Land and Buildings"]
[1420,0,"Capital: Fixtures, Fittings and Equipment"]
[1425,0,"Capital: Covid Minor Works Fixtures, Fittings and Equipment"]
[1430,0,"Accumulated Depreciation: Fixtures, Fittings and Equipment"]
[1435,0,"Accumulated Depreciation: Covid Minor Works Fixtures, Fittings and Equipment"]
[1440,0,"Capital: Motor Vehicles"]
[1450,0,"Accumulated Depreciation: Motor Vehicles"]
[1460,0,"Capital: ICT"]
[1465,0,"Capital: Covid Minor Works ICT"]
[1470,0,"Accumulated Depreciation: ICT"]
[1475,0,"Accumulated Depreciation: Covid Minor Works ICT"]
[1480,0,"Capital: Other"]
[1490,0,"Accumulated Depreciation Other"]
[1700,0,"Sales Ledger Control"]
[1710,0,"Stock"]
[1720,0,"Prepayments"]
[1730,0,"Grants Due"]
[1800,0,"Current Account 1"]
[1801,0,"Current Account 2"]
[1802,0,"Current Account 3"]
[1803,0,"DEASP School Meal Bank Account"]
[1810,0,"Deposit Account"]
[1820,0,"Parents Council/Association Bank Account"]
[1850,0,"Credit Card Account"]
[1870,0,"Online Payment Solution Clearing Account"]
[1900,0,"Petty Cash Account"]
[1950,0,"Cash Control Account"]
[2100,0,"Creditors Control Account"]
[2105,0,"School Income Received in Advance"]
[2150,0,"Grants Received in Advance"]
[2151,0,"Book Grant Received in Advance"]
[2152,0,"DEIS Grant Received in Advance"]
[2160,0,"Book Grant Unspent"]
[2165,0,"ICT Grant Unspent"]
[2166,0,"Minor Works Grant Unspent "]
[2167,0,"JCSP Grant Unspent "]
[2168,0,"Non Teachers Pay Budget Grant Unspent "]
[2169,0,"COVID Minor Works Grant Unspent "]
[2170,0,"Supervision and Substitution Grant Unspent"]
[2171,0,"Other Ringfenced Grants Unspent"]
[2172,0,"Other Ringfenced Income Unspent"]
[2180,0,"School Excellence Fund Unspent"]
[2181,0,"COVID Aide Grant Unspent"]
[2182,0,"COVID Capitation for PPE Grant Unspent"]
[2183,0,"COVID Enhanced Supervision Grant Unspent"]
[2184,0,"COVID Capitation for Additional Cleaning Grant Unspent"]
[2185,0,"COVID Replacement Hours Unspent"]
[2200,0,"Net Wages Control Account"]
[2210,0,"Union Fees Control Account"]
[2220,0,"Single Public Service Pension Scheme Control Account"]
[2230,0,"ASC Control Account"]
[2240,0,"PRSA Control Account"]
[2250,0,"PAYE/PRSI/USC/LPT Control Account"]
[2260,0,"Reverse VAT Control Account"]
[2270,0,"RCT Control Account"]
[2310,0,"Bank Loans"]
[2320,0,"Other Loan"]
[2330,0,"Leasing"]
[2440,0,"Accruals"]
[2600,0,"Long Term Loan "]
[2700,0,"Retained Surplus"]
[2710,0,"Surplus Brought Forward"]
[3900,0,"DE Capital Building Grant Income                                         "]
[3901,0,"Capital Projects Fundraising Income                                        "]
[3902,0,"Parents Contribution to Capital Projects Income"]
[3903,0,"Patron/Trustee Contribution to Capital Projects Income    "]
[3904,0,"Other State Capital Projects Income                                           "]
[3905,0,"Covid Minor Works Capital Grant Income"]
[3906,0,"Accumulated Amortisation of Capital Building Income"]
[3907,0,"Capital Donations Income"]
[3920,0,"DE Fixtures, Fittings & Equipment Grant Income                                     "]
[3921,0,"DE ICT Grant Capital Income                                                                   "]
[3925,0,"Accumulated Amortisation of Capital Equipment Income"]
[3926,0,"Accumulated Amortisation of ICT Grant Capital Income"]
[3940,0,"DE Capital Building Grant Expense                                         "]
[3941,0,"Covid Minor Works Building Expense"]
[3960,0,"Capital Building Fundraising Expense                                 "]
[3970,0,"Parents Contribution to Capital Building Expense            "]
[3990,0,"Patron/Trustee Contribution to Capital Building Expense  "]
[3991,0,"Other State Capital Building Expense                             "]
[3992,0,"Capital Donations Building Expense"]
[3995,0,"Building Fund Account"]
[]
["Check",{"$f":"SUM(Nominal_Code_LT3[[Final Accounts ]])","v":0}]

{"sheet":"Import From Manual","index":19,"n_rows":314,"n_cols":7,"rows_kept":314,"cut":false,"hidden":true,"merged":[]}
["Roll No","12345G",null,null,"Instructions",null,"Do not delete"]
["Nominal Code"]
["Nominal Code","Final Accounts "]
[null,0,null,null,3010,{"$f":"IFERROR(VLOOKUP(E4,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,0,null,null,3020,{"$f":"IFERROR(VLOOKUP(E5,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,0,null,null,3030,0]
[null,0,null,null,3050,0]
[null,0,null,null,3100,0]
[null,0,null,null,3130,0]
[null,0,null,null,3140,0]
[null,0,null,null,3150,0]
[null,0,null,null,3160,0]
[null,0,null,null,3170,0]
[null,0,null,null,3190,0]
[null,0,null,null,3200,0]
[null,0,null,null,3210,0]
[null,0,null,null,3220,0]
[null,0,null,null,3225,0]
[null,0,null,null,3226,0]
[null,0,null,null,3227,0]
[null,0,null,null,3230,0]
[null,0,null,null,3240,0]
[null,0,null,null,3245,0]
[null,0,null,null,3255,0]
[null,0,null,null,3260,0]
[null,0,null,null,3270,0]
[null,0,null,null,3275,0]
[null,0,null,null,3276,0]
[null,0,null,null,3277,0]
[null,0,null,null,3280,0]
[null,0,null,null,3281,0]
[null,0,null,null,3282,0]
[null,0,null,null,3283,0]
[null,0,null,null,3284,0]
[null,0,null,null,3285,0]
[null,0,null,null,3286,0]
[null,0,null,null,3287,0]
[null,0,null,null,3290,0]
[null,0,null,null,3292,0]
[null,0,null,null,3293,0]
[null,0,null,null,3294,0]
[null,0,null,null,3295,0]
[null,0,null,null,3296,0]
[null,0,null,null,3297,0]
[null,0,null,null,3298,0]
[null,0,null,null,3299,0]
[null,0,null,null,3300,0]
[null,0,null,null,3310,0]
[null,0,null,null,3330,0]
[null,0,null,null,3335,0]
[null,0,null,null,3350,0]
[null,0,null,null,3360,0]
[null,0,null,null,3370,0]
[null,0,null,null,3375,0]
[null,0,null,null,3390,0]
[null,0,null,null,3395,0]
[null,0,null,null,3410,0]
[null,0,null,null,3420,0]
[null,0,null,null,3430,0]
[null,0,null,null,3440,0]
[null,0,null,null,3450,0]
[null,0,null,null,3460,0]
[null,0,null,null,3490,0]
[null,0,null,null,3495,0]
[null,0,null,null,3500,0]
[null,0,null,null,3510,0]
[null,0,null,null,3520,0]
[null,0,null,null,3530,{"$f":"IFERROR(VLOOKUP(E68,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,0,null,null,3531,0]
[null,0,null,null,3535,0]
[null,0,null,null,3540,0]
[null,0,null,null,3545,0]
[null,0,null,null,3550,0]
[null,0,null,null,3570,0]
[null,0,null,null,3572,0]
[null,0,null,null,3573,0]
[null,0,null,null,3574,0]
[null,0,null,null,3575,0]
[null,0,null,null,3580,0]
[null,0,null,null,3650,0]
[null,0,null,null,3700,0]
[null,0,null,null,3770,0]
[null,0,null,null,3800,0]
[null,0,null,null,3840,0]
[null,0,null,null,3850,0]
[null,0,null,null,3851,0]
[null,0,null,null,3852,0]
[null,0,null,null,3853,0]
[null,0,null,null,4110,0]
[null,0,null,null,4111,0]
[null,0,null,null,4112,0]
[null,0,null,null,4150,0]
[null,0,null,null,4155,0]
[null,0,null,null,4170,0]
[null,0,null,null,4180,0]
[null,0,null,null,4181,0]
[null,0,null,null,4190,0]
[null,0,null,null,4191,0]
[null,0,null,null,4196,0]
[null,0,null,null,4197,0]
[null,0,null,null,4198,0]
[null,0,null,null,4199,0]
[null,0,null,null,4310,0]
[null,0,null,null,4330,0]
[null,0,null,null,4350,0]
[null,0,null,null,4370,0]
[null,0,null,null,4390,0]
[null,0,null,null,4410,0]
[null,0,null,null,4420,0]
[null,0,null,null,4430,0]
[null,0,null,null,4450,0]
[null,0,null,null,4470,0]
[null,0,null,null,4490,0]
[null,0,null,null,4550,0]
[null,0,null,null,4570,0]
[null,0,null,null,4590,0]
[null,0,null,null,4610,0]
[null,0,null,null,4620,0]
[null,0,null,null,4630,0]
[null,0,null,null,4635,0]
[null,0,null,null,4640,0]
[null,0,null,null,4650,0]
[null,0,null,null,4670,0]
[null,0,null,null,4671,0]
[null,0,null,null,4690,0]
[null,0,null,null,4710,0]
[null,0,null,null,4720,0]
[null,0,null,null,4730,0]
[null,0,null,null,4740,0]
[null,0,null,null,4741,0]
[null,0,null,null,4750,0]
[null,0,null,null,4760,{"$f":"IFERROR(VLOOKUP(E132,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,0,null,null,4770,0]
[null,0,null,null,4780,0]
[null,0,null,null,4810,0]
[null,0,null,null,4815,0]
[null,0,null,null,4850,0]
[null,0,null,null,4908,0]
[null,0,null,null,4909,0]
[null,0,null,null,4910,0]
[null,0,null,null,4911,0]
[null,0,null,null,4912,0]
[null,0,null,null,4913,0]
[null,0,null,null,4914,0]
[null,0,null,null,4915,0]
[null,0,null,null,4916,0]
[null,0,null,null,4917,0]
[null,0,null,null,4918,0]
[null,0,null,null,4919,0]
[null,0,null,null,4920,0]
[null,0,null,null,4921,0]
[null,0,null,null,4922,0]
[null,0,null,null,4923,0]
[null,0,null,null,4924,0]
[null,0,null,null,4925,0]
[null,0,null,null,4927,0]
[null,0,null,null,4928,0]
[null,0,null,null,4930,0]
[null,0,null,null,5010,0]
[null,0,null,null,5011,0]
[null,0,null,null,5020,0]
[null,0,null,null,5030,0]
[null,0,null,null,5110,0]
[null,0,null,null,5111,0]
[null,0,null,null,5112,0]
[null,0,null,null,5150,0]
[null,0,null,null,5170,0]
[null,0,null,null,5175,0]
[null,0,null,null,5310,0]
[null,0,null,null,5315,0]
[null,0,null,null,5316,0]
[null,0,null,null,5350,0]
[null,0,null,null,5400,0]
[null,0,null,null,5450,0]
[null,0,null,null,5510,0]
[null,0,null,null,5550,0]
[null,0,null,null,5551,0]
[null,0,null,null,5552,0]
[null,0,null,null,5610,0]
[null,0,null,null,5611,0]
[null,0,null,null,5700,0]
[null,0,null,null,5710,0]
[null,0,null,null,5800,0]
[null,0,null,null,5801,0]
[null,0,null,null,5802,0]
[null,0,null,null,5803,0]
[null,0,null,null,5804,0]
[null,0,null,null,5805,0]
[null,0,null,null,6010,0]
[null,0,null,null,6011,0]
[null,0,null,null,6050,0]
[null,0,null,null,6070,0]
[null,0,null,null,6100,0]
[null,0,null,null,6150,0]
[null,0,null,null,6210,0]
[null,0,null,null,6250,{"$f":"IFERROR(VLOOKUP(E196,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,0,null,null,6300,0]
[null,0,null,null,6305,0]
[null,0,null,null,6350,0]
[null,0,null,null,6355,0]
[null,0,null,null,6400,0]
[null,0,null,null,6450,0]
[null,0,null,null,6500,0]
[null,0,null,null,6600,0]
[null,0,null,null,6650,0]
[null,0,null,null,6700,0]
[null,0,null,null,6730,0]
[null,0,null,null,6731,0]
[null,0,null,null,6750,0]
[null,0,null,null,6755,0]
[null,0,null,null,6780,0]
[null,0,null,null,6800,0]
[null,0,null,null,6830,0]
[null,0,null,null,6870,0]
[null,0,null,null,6900,0]
[null,0,null,null,7300,0]
[null,0,null,null,7320,0]
[null,0,null,null,7400,0]
[null,0,null,null,7450,0]
[null,0,null,null,7500,0]
[null,0,null,null,7800,0]
[null,0,null,null,7850,0]
[null,0,null,null,8000,0]
[null,0,null,null,8020,0]
[null,0,null,null,8040,0]
[null,0,null,null,8060,0]
[null,0,null,null,8080,0]
[null,0,null,null,1400,0]
[null,0,null,null,1410,0]
[null,0,null,null,1420,0]
[null,0,null,null,1425,0]
[null,0,null,null,1430,0]
[null,0,null,null,1435,0]
[null,0,null,null,1440,0]
[null,0,null,null,1450,0]
[null,0,null,null,1460,0]
[null,0,null,null,1465,0]
[null,0,null,null,1470,0]
[null,0,null,null,1475,0]
[null,0,null,null,1480,0]
[null,0,null,null,1490,0]
[null,0,null,null,1700,0]
[null,0,null,null,1710,0]
[null,0,null,null,1720,0]
[null,0,null,null,1730,0]
[null,0,null,null,1800,0]
[null,0,null,null,1801,0]
[null,0,null,null,1802,0]
[null,0,null,null,1803,0]
[null,0,null,null,1810,0]
[null,0,null,null,1820,0]
[null,0,null,null,1850,0]
[null,0,null,null,1870,0]
[null,0,null,null,1900,0]
[null,0,null,null,1950,0]
[null,0,null,null,2100,0]
[null,0,null,null,2105,0]
[null,0,null,null,2150,0]
[null,0,null,null,2151,0]
[null,0,null,null,2152,{"$f":"IFERROR(VLOOKUP(E260,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,0,null,null,2160,0]
[null,0,null,null,2165,0]
[null,0,null,null,2166,0]
[null,0,null,null,2167,0]
[null,0,null,null,2168,0]
[null,0,null,null,2169,0]
[null,0,null,null,2170,0]
[null,0,null,null,2171,0]
[null,0,null,null,2172,0]
[null,0,null,null,2180,0]
[null,0,null,null,2181,0]
[null,0,null,null,2182,0]
[null,0,null,null,2183,0]
[null,0,null,null,2184,0]
[null,0,null,null,2185,0]
[null,0,null,null,2200,0]
[null,0,null,null,2210,0]
[null,0,null,null,2220,0]
[null,0,null,null,2230,0]
[null,0,null,null,2240,0]
[null,0,null,null,2250,0]
[null,0,null,null,2260,0]
[null,0,null,null,2270,0]
[null,0,null,null,2310,0]
[null,0,null,null,2320,0]
[null,0,null,null,2330,0]
[null,0,null,null,2440,0]
[null,0,null,null,2600,0]
[null,0,null,null,2700,0]
[null,0,null,null,2710,0]
[null,0,null,null,3900,0]
[null,0,null,null,3901,0]
[null,0,null,null,3902,0]
[null,0,null,null,3903,0]
[null,0,null,null,3904,0]
[null,0,null,null,3905,0]
[null,0,null,null,3906,0]
[null,0,null,null,3907,0]
[null,0,null,null,3920,0]
[null,0,null,null,3921,0]
[null,0,null,null,3925,0]
[null,0,null,null,3926,0]
[null,0,null,null,3940,0]
[null,0,null,null,3941,0]
[null,0,null,null,3960,0]
[null,0,null,null,3970,0]
[null,0,null,null,3990,0]
[null,0,null,null,3991,0]
[null,0,null,null,3992,0]
[null,0,null,null,3995,0]
[]
["Check",{"$f":"SUM(B4:B310)","v":0}]
[]
["Do not enter values beyond row 310"]

{"sheet":"Import Comparisons","index":20,"n_rows":311,"n_cols":3,"rows_kept":311,"cut":false,"hidden":false,"merged":[]}
["Roll No","12345G","Instructions"]
["Nominal Code"]
["Nominal Code","Final Accounts "]
[3010,0]
[3020,0]
[3030,0]
[3050,0]
[3100,0]
[3130,0]
[3140,0]
[3150,0]
[3160,0]
[3170,0]
[3190,0]
[3200,0]
[3210,0]
[3220,0]
[3225,0]
[3226,0]
[3227,0]
[3230,0]
[3240,0]
[3245,0]
[3255,0]
[3260,0]
[3270,0]
[3275,0]
[3276,0]
[3277,0]
[3280,0]
[3281,0]
[3282,0]
[3283,0]
[3284,0]
[3285,0]
[3286,0]
[3287,0]
[3290,0]
[3292,0]
[3293,0]
[3294,0]
[3295,0]
[3296,0]
[3297,0]
[3298,0]
[3299,0]
[3300,0]
[3310,0]
[3330,0]
[3335,0]
[3350,0]
[3360,0]
[3370,0]
[3375,0]
[3390,0]
[3395,0]
[3410,0]
[3420,0]
[3430,0]
[3440,0]
[3450,0]
[3460,0]
[3490,0]
[3495,0]
[3500,0]
[3510,0]
[3520,0]
[3530,0]
[3531,0]
[3535,0]
[3540,0]
[3545,0]
[3550,0]
[3570,0]
[3572,0]
[3573,0]
[3574,0]
[3575,0]
[3580,0]
[3650,0]
[3700,0]
[3770,0]
[3800,0]
[3840,0]
[3850,0]
[3851,0]
[3852,0]
[3853,0]
[4110,0]
[4111,0]
[4112,0]
[4150,0]
[4155,0]
[4170,0]
[4180,0]
[4181,0]
[4190,0]
[4191,0]
[4196,0]
[4197,0]
[4198,0]
[4199,0]
[4310,0]
[4330,0]
[4350,0]
[4370,0]
[4390,0]
[4410,0]
[4420,0]
[4430,0]
[4450,0]
[4470,0]
[4490,0]
[4550,0]
[4570,0]
[4590,0]
[4610,0]
[4620,0]
[4630,0]
[4635,0]
[4640,0]
[4650,0]
[4670,0]
[4671,0]
[4690,0]
[4710,0]
[4720,0]
[4730,0]
[4740,0]
[4741,0]
[4750,0]
[4760,0]
[4770,0]
[4780,0]
[4810,0]
[4815,0]
[4850,0]
[4908,0]
[4909,0]
[4910,0]
[4911,0]
[4912,0]
[4913,0]
[4914,0]
[4915,0]
[4916,0]
[4917,0]
[4918,0]
[4919,0]
[4920,0]
[4921,0]
[4922,0]
[4923,0]
[4924,0]
[4925,0]
[4927,0]
[4928,0]
[4930,0]
[5010,0]
[5011,0]
[5020,0]
[5030,0]
[5110,0]
[5111,0]
[5112,0]
[5150,0]
[5170,0]
[5175,0]
[5310,0]
[5315,0]
[5316,0]
[5350,0]
[5400,0]
[5450,0]
[5510,0]
[5550,0]
[5551,0]
[5552,0]
[5610,0]
[5611,0]
[5700,0]
[5710,0]
[5800,0]
[5801,0]
[5802,0]
[5803,0]
[5804,0]
[5805,0]
[6010,0]
[6011,0]
[6050,0]
[6070,0]
[6100,0]
[6150,0]
[6210,0]
[6250,0]
[6300,0]
[6305,0]
[6350,0]
[6355,0]
[6400,0]
[6450,0]
[6500,0]
[6600,0]
[6650,0]
[6700,0]
[6730,0]
[6731,0]
[6750,0]
[6755,0]
[6780,0]
[6800,0]
[6830,0]
[6870,0]
[6900,0]
[7300,0]
[7320,0]
[7400,0]
[7450,0]
[7500,0]
[7800,0]
[7850,0]
[8000,0]
[8020,0]
[8040,0]
[8060,0]
[8080,0]
[1400,0]
[1410,0]
[1420,0]
[1425,0]
[1430,0]
[1435,0]
[1440,0]
[1450,0]
[1460,0]
[1465,0]
[1470,0]
[1475,0]
[1480,0]
[1490,0]
[1700,0]
[1710,0]
[1720,0]
[1730,0]
[1800,0]
[1801,0]
[1802,0]
[1803,0]
[1810,0]
[1820,0]
[1850,0]
[1870,0]
[1900,0]
[1950,0]
[2100,0]
[2105,0]
[2150,0]
[2151,0]
[2152,0]
[2160,0]
[2165,0]
[2166,0]
[2167,0]
[2168,0]
[2169,0]
[2170,0]
[2171,0]
[2172,0]
[2180,0]
[2181,0]
[2182,0]
[2183,0]
[2184,0]
[2185,0]
[2200,0]
[2210,0]
[2220,0]
[2230,0]
[2240,0]
[2250,0]
[2260,0]
[2270,0]
[2310,0]
[2320,0]
[2330,0]
[2440,0]
[2600,0]
[2700,0]
[2710,0]
[3900,0]
[3901,0]
[3902,0]
[3903,0]
[3904,0]
[3905,0]
[3906,0]
[3907,0]
[3920,0]
[3921,0]
[3925,0]
[3926,0]
[3940,0]
[3941,0]
[3960,0]
[3970,0]
[3990,0]
[3991,0]
[3992,0]
[3995,0]
["Check",281]

{"sheet":"Import Manual Comparisons","index":21,"n_rows":314,"n_cols":7,"rows_kept":314,"cut":false,"hidden":true,"merged":[]}
["Roll No","12345G",null,null,"Instructions",null,"Do not delete"]
["Nominal Code"]
["Nominal Code","Final Accounts "]
[3010,0,null,null,3010,{"$f":"IFERROR(VLOOKUP(E4,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[3020,0,null,null,3020,0]
[3030,0,null,null,3030,0]
[3050,0,null,null,3050,0]
[3100,0,null,null,3100,0]
[3130,0,null,null,3130,0]
[3140,0,null,null,3140,0]
[3150,0,null,null,3150,0]
[3160,0,null,null,3160,0]
[3170,0,null,null,3170,0]
[3190,0,null,null,3190,0]
[3200,0,null,null,3200,0]
[3210,0,null,null,3210,0]
[3220,0,null,null,3220,0]
[3225,0,null,null,3225,0]
[3226,0,null,null,3226,0]
[3227,0,null,null,3227,0]
[3230,0,null,null,3230,0]
[3240,0,null,null,3240,0]
[3245,0,null,null,3245,0]
[3255,0,null,null,3255,0]
[3260,0,null,null,3260,0]
[3270,0,null,null,3270,0]
[3275,0,null,null,3275,0]
[3276,0,null,null,3276,0]
[3277,0,null,null,3277,0]
[3280,0,null,null,3280,0]
[3281,0,null,null,3281,0]
[3282,0,null,null,3282,0]
[3283,0,null,null,3283,0]
[3284,0,null,null,3284,0]
[3285,0,null,null,3285,0]
[3286,0,null,null,3286,0]
[3287,0,null,null,3287,0]
[3290,0,null,null,3290,0]
[3292,0,null,null,3292,0]
[3293,0,null,null,3293,0]
[3294,0,null,null,3294,0]
[3295,0,null,null,3295,0]
[3296,0,null,null,3296,0]
[3297,0,null,null,3297,0]
[3298,0,null,null,3298,0]
[3299,0,null,null,3299,0]
[3300,0,null,null,3300,0]
[3310,0,null,null,3310,0]
[3330,0,null,null,3330,0]
[3335,0,null,null,3335,0]
[3350,0,null,null,3350,0]
[3360,0,null,null,3360,0]
[3370,0,null,null,3370,0]
[3375,0,null,null,3375,0]
[3390,0,null,null,3390,0]
[3395,0,null,null,3395,0]
[3410,0,null,null,3410,0]
[3420,0,null,null,3420,0]
[3430,0,null,null,3430,0]
[3440,0,null,null,3440,0]
[3450,0,null,null,3450,0]
[3460,0,null,null,3460,0]
[3490,0,null,null,3490,0]
[3495,0,null,null,3495,0]
[3500,0,null,null,3500,0]
[3510,0,null,null,3510,0]
[3520,0,null,null,3520,0]
[3530,0,null,null,3530,{"$f":"IFERROR(VLOOKUP(E68,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[3531,0,null,null,3531,0]
[3535,0,null,null,3535,0]
[3540,0,null,null,3540,0]
[3545,0,null,null,3545,0]
[3550,0,null,null,3550,0]
[3570,0,null,null,3570,0]
[3572,0,null,null,3572,0]
[3573,0,null,null,3573,0]
[3574,0,null,null,3574,0]
[3575,0,null,null,3575,0]
[3580,0,null,null,3580,0]
[3650,0,null,null,3650,0]
[3700,0,null,null,3700,0]
[3770,0,null,null,3770,0]
[3800,0,null,null,3800,0]
[3840,0,null,null,3840,0]
[3850,0,null,null,3850,0]
[3851,0,null,null,3851,0]
[3852,0,null,null,3852,0]
[3853,0,null,null,3853,0]
[4110,0,null,null,4110,0]
[4111,0,null,null,4111,0]
[4112,0,null,null,4112,0]
[4150,0,null,null,4150,0]
[4155,0,null,null,4155,0]
[4170,0,null,null,4170,0]
[4180,0,null,null,4180,0]
[4181,0,null,null,4181,0]
[4190,0,null,null,4190,0]
[4191,0,null,null,4191,0]
[4196,0,null,null,4196,0]
[4197,0,null,null,4197,0]
[4198,0,null,null,4198,0]
[4199,0,null,null,4199,0]
[4310,0,null,null,4310,0]
[4330,0,null,null,4330,0]
[4350,0,null,null,4350,0]
[4370,0,null,null,4370,0]
[4390,0,null,null,4390,0]
[4410,0,null,null,4410,0]
[4420,0,null,null,4420,0]
[4430,0,null,null,4430,0]
[4450,0,null,null,4450,0]
[4470,0,null,null,4470,0]
[4490,0,null,null,4490,0]
[4550,0,null,null,4550,0]
[4570,0,null,null,4570,0]
[4590,0,null,null,4590,0]
[4610,0,null,null,4610,0]
[4620,0,null,null,4620,0]
[4630,0,null,null,4630,0]
[4635,0,null,null,4635,0]
[4640,0,null,null,4640,0]
[4650,0,null,null,4650,0]
[4670,0,null,null,4670,0]
[4671,0,null,null,4671,0]
[4690,0,null,null,4690,0]
[4710,0,null,null,4710,0]
[4720,0,null,null,4720,0]
[4730,0,null,null,4730,0]
[4740,0,null,null,4740,0]
[4741,0,null,null,4741,0]
[4750,0,null,null,4750,0]
[4760,0,null,null,4760,{"$f":"IFERROR(VLOOKUP(E132,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[4770,0,null,null,4770,0]
[4780,0,null,null,4780,0]
[4810,0,null,null,4810,0]
[4815,0,null,null,4815,0]
[4850,0,null,null,4850,0]
[4908,0,null,null,4908,0]
[4909,0,null,null,4909,0]
[4910,0,null,null,4910,0]
[4911,0,null,null,4911,0]
[4912,0,null,null,4912,0]
[4913,0,null,null,4913,0]
[4914,0,null,null,4914,0]
[4915,0,null,null,4915,0]
[4916,0,null,null,4916,0]
[4917,0,null,null,4917,0]
[4918,0,null,null,4918,0]
[4919,0,null,null,4919,0]
[4920,0,null,null,4920,0]
[4921,0,null,null,4921,0]
[4922,0,null,null,4922,0]
[4923,0,null,null,4923,0]
[4924,0,null,null,4924,0]
[4925,0,null,null,4925,0]
[4927,0,null,null,4927,0]
[4928,0,null,null,4928,0]
[4930,0,null,null,4930,0]
[5010,0,null,null,5010,0]
[5011,0,null,null,5011,0]
[5020,0,null,null,5020,0]
[5030,0,null,null,5030,0]
[5110,0,null,null,5110,0]
[5111,0,null,null,5111,0]
[5112,0,null,null,5112,0]
[5150,0,null,null,5150,0]
[5170,0,null,null,5170,0]
[5175,0,null,null,5175,0]
[5310,0,null,null,5310,0]
[5315,0,null,null,5315,0]
[5316,0,null,null,5316,0]
[5350,0,null,null,5350,0]
[5400,0,null,null,5400,0]
[5450,0,null,null,5450,0]
[5510,0,null,null,5510,0]
[5550,0,null,null,5550,0]
[5551,0,null,null,5551,0]
[5552,0,null,null,5552,0]
[5610,0,null,null,5610,0]
[5611,0,null,null,5611,0]
[5700,0,null,null,5700,0]
[5710,0,null,null,5710,0]
[5800,0,null,null,5800,0]
[5801,0,null,null,5801,0]
[5802,0,null,null,5802,0]
[5803,0,null,null,5803,0]
[5804,0,null,null,5804,0]
[5805,0,null,null,5805,0]
[6010,0,null,null,6010,0]
[6011,0,null,null,6011,0]
[6050,0,null,null,6050,0]
[6070,0,null,null,6070,0]
[6100,0,null,null,6100,0]
[6150,0,null,null,6150,0]
[6210,0,null,null,6210,0]
[6250,0,null,null,6250,{"$f":"IFERROR(VLOOKUP(E196,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[6300,0,null,null,6300,0]
[6305,0,null,null,6305,0]
[6350,0,null,null,6350,0]
[6355,0,null,null,6355,0]
[6400,0,null,null,6400,0]
[6450,0,null,null,6450,0]
[6500,0,null,null,6500,0]
[6600,0,null,null,6600,0]
[6650,0,null,null,6650,0]
[6700,0,null,null,6700,0]
[6730,0,null,null,6730,0]
[6731,0,null,null,6731,0]
[6750,0,null,null,6750,0]
[6755,0,null,null,6755,0]
[6780,0,null,null,6780,0]
[6800,0,null,null,6800,0]
[6830,0,null,null,6830,0]
[6870,0,null,null,6870,0]
[6900,0,null,null,6900,0]
[7300,0,null,null,7300,0]
[7320,0,null,null,7320,0]
[7400,0,null,null,7400,0]
[7450,0,null,null,7450,0]
[7500,0,null,null,7500,0]
[7800,0,null,null,7800,0]
[7850,0,null,null,7850,0]
[8000,0,null,null,8000,0]
[8020,0,null,null,8020,0]
[8040,0,null,null,8040,0]
[8060,0,null,null,8060,0]
[8080,0,null,null,8080,0]
[1400,0,null,null,1400,0]
[1410,0,null,null,1410,0]
[1420,0,null,null,1420,0]
[1425,0,null,null,1425,0]
[1430,0,null,null,1430,0]
[1435,0,null,null,1435,0]
[1440,0,null,null,1440,0]
[1450,0,null,null,1450,0]
[1460,0,null,null,1460,0]
[1465,0,null,null,1465,0]
[1470,0,null,null,1470,0]
[1475,0,null,null,1475,0]
[1480,0,null,null,1480,0]
[1490,0,null,null,1490,0]
[1700,0,null,null,1700,0]
[1710,0,null,null,1710,0]
[1720,0,null,null,1720,0]
[1730,0,null,null,1730,0]
[1800,0,null,null,1800,0]
[1801,0,null,null,1801,0]
[1802,0,null,null,1802,0]
[1803,0,null,null,1803,0]
[1810,0,null,null,1810,0]
[1820,0,null,null,1820,0]
[1850,0,null,null,1850,0]
[1870,0,null,null,1870,0]
[1900,0,null,null,1900,0]
[1950,0,null,null,1950,0]
[2100,0,null,null,2100,0]
[2105,0,null,null,2105,0]
[2150,0,null,null,2150,0]
[2151,0,null,null,2151,0]
[2152,0,null,null,2152,{"$f":"IFERROR(VLOOKUP(E260,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[2160,0,null,null,2160,0]
[2165,0,null,null,2165,0]
[2166,0,null,null,2166,0]
[2167,0,null,null,2167,0]
[2168,0,null,null,2168,0]
[2169,0,null,null,2169,0]
[2170,0,null,null,2170,0]
[2171,0,null,null,2171,0]
[2172,0,null,null,2172,0]
[2180,0,null,null,2180,0]
[2181,0,null,null,2181,0]
[2182,0,null,null,2182,0]
[2183,0,null,null,2183,0]
[2184,0,null,null,2184,0]
[2185,0,null,null,2185,0]
[2200,0,null,null,2200,0]
[2210,0,null,null,2210,0]
[2220,0,null,null,2220,0]
[2230,0,null,null,2230,0]
[2240,0,null,null,2240,0]
[2250,0,null,null,2250,0]
[2260,0,null,null,2260,0]
[2270,0,null,null,2270,0]
[2310,0,null,null,2310,0]
[2320,0,null,null,2320,0]
[2330,0,null,null,2330,0]
[2440,0,null,null,2440,0]
[2600,0,null,null,2600,0]
[2700,0,null,null,2700,0]
[2710,0,null,null,2710,0]
[3900,0,null,null,3900,0]
[3901,0,null,null,3901,0]
[3902,0,null,null,3902,0]
[3903,0,null,null,3903,0]
[3904,0,null,null,3904,0]
[3905,0,null,null,3905,0]
[3906,0,null,null,3906,0]
[3907,0,null,null,3907,0]
[3920,0,null,null,3920,0]
[3921,0,null,null,3921,0]
[3925,0,null,null,3925,0]
[3926,0,null,null,3926,0]
[3940,0,null,null,3940,0]
[3941,0,null,null,3941,0]
[3960,0,null,null,3960,0]
[3970,0,null,null,3970,0]
[3990,0,null,null,3990,0]
[3991,0,null,null,3991,0]
[3992,0,null,null,3992,0]
[3995,0,null,null,3995,0]
[]
["Check",{"$f":"SUM(B4:B310)","v":0}]
[]
["Do not enter values beyond row 310"]