{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Instructions","Accountants' Report","General Information","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)","Notes to the accounts (4)","Notes to the accounts (5)","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":2,"macros":1,"external_links":0,"defined_names":36,"comments":4,"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":39,"n_cols":4,"rows_kept":39,"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 - >>"]
[]
[]
[2,"Import Comparisons - >>"]
[]
[]
["3a","Print Accountants' Report Standard ->>"]
[]
[null,"or"]
[]
["3b","Print Accountants' Report With Cashflow ->>"]
[]
[4,"Create Portal Import File ->>"]
[]
[]
[]
[null,"Admin"]
[]
[]
[]
[]
[]
["Note: "," Accounting Treatments for School Accounts are available on our website"]
[null,"Cells in yellow must be manually updated"]
[]
[]
[]
[]
[]
["v3"]

{"sheet":"Accountants' Report","index":1,"n_rows":25,"n_cols":13,"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,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,","2023","TO ","August 31, ","2024"]

{"sheet":"General Information","index":2,"n_rows":32,"n_cols":13,"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,null,null,null,null,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":"Contents","index":3,"n_rows":22,"n_cols":13,"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,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]
[]
[null,"Accountant’s/Audit Report",null,null,null,null,null,2]
[]
[null,"Income and Expenditure Account",null,null,null,null,null,3]
[]
[null,"Balance Sheet",null,null,null,null,null,4]
[]
[null,"Notes to the Accounts   ",null,null,null,null,null,"5-9"]
[]
[null,"Detailed Income and Expenditure Account",null,null,null,null,null,"10-12"]
[]
[null,"Detailed Balance Sheet",null,null,null,null,null,13]
[]
[null,"Financial Report to Parents",null,null,null,null,null,"14-15"]
[]
[null,"Cash Flow Statement (Optional)",null,null,null,null,null,16]

{"sheet":"Board of Management Report","index":4,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[26,0,26,8],[30,0,32,8],[36,0,37,7],[51,0,53,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 2024"]
[null,null,null,null,"SAMPLE"]
["The Boards presents its report and financial statements for the year ended 31st August 2024"]
[]
["•","Objectives and Activities;"]
["The principal activity of the school was to provide education in the context of the ethos of a Primary/Post 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 2023-2027 (Primary), relevant govering documents (Post-Primary) 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 Governance Manual 2023-2027 (Primary), relevant governing documents (Post-Primary) 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,"Treasurer/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":[[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],[21,5,21,7],[22,5,22,7],[8,0,8,5],[9,0,12,7],[20,5,20,7],[16,0,16,3]]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,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]]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,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":"2024"}]
[]
[]
[null,null,null,null,null,"   Actual                    ",null,"Actual"]
[null,null,null,null,null,"2023/2024",null,"2022/2023"]
[]
[null,"Total Income ",null,null,null,{"$f":"SUM('Income Account'!F105)","v":0},null,{"$f":"'Income Account'!H105","v":0}]
[]
[null,"Total Expenditure",null,null,null,{"$f":"'Expenditure Account (2)'!F79","v":0},null,{"$f":"'Expenditure Account (2)'!H79","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'!F107","v":0},null,{"$f":"'Detailed Balance Sheet'!H107","v":0}]
[]
[null,"Closing Balance",null,null,null,{"$f":"F14+F16","v":0},null,{"$f":"H14+H16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"On behalf of the board;"]
[]
[]
[]
[]
[null,"Chairperson",null,null,null,"Treasurer/Board Member"]
[]
[]
[null,"Date   "]

{"sheet":"Balance Sheet","index":7,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[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],[5,1,5,2],[7,1,7,3],[12,1,12,2],[14,1,14,3],[8,1,8,3],[10,1,10,3],[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]]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,null,"Instructions"]
[]
[null,"Balance Sheet as at ",null,null,"August 31, ",{"$f":"'Accountants'' Report'!H25","v":"2024"}]
[null,null,null,null,null,"Actual ",null,"Actual"]
[null,null,null,null,null,"2023/2024",null,"2022/2023"]
[null,"1.  Fixed Assets",null,null,"Note 2"]
[]
[null,"Fixtures and Fittings ",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F12:F23)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H12:H23)","v":0}]
[null,"ICT Infrastructure ",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F30:F41)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H30:H41)","v":0}]
[null,"Capital Other",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F42:F47)+SUM('Detailed Balance Sheet'!F6:F11)+SUM('Detailed Balance Sheet'!F24:F29)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H42:H47)+SUM('Detailed Balance Sheet'!H6:H11)+SUM('Detailed Balance Sheet'!H24:H29)","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,"Debtors and prepaid expenses ",null,null,"Note 3",{"$f":"SUM('Detailed Balance Sheet'!F50:F54)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H50:H54)","v":0}]
[null,"Cash at bank and in hand",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F55:F64)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H55:H64)","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'!F67:F102)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H67:H102)","v":0}]
[]
[null,"4. Long Term Liabilities",null,null,null,{"$f":"SUM('Detailed Balance Sheet'!F103)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H103)","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",{"$f":"SUM('Detailed Balance Sheet'!F108:F127)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H108:H127)","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'!F107)","v":0},null,{"$f":"SUM('Detailed Balance Sheet'!H107)","v":0}]
[]
[null,"Total Capital and Reserves",null,null,null,{"$f":"F30+F32+F34","v":0},null,{"$f":"H30+H32+H34","v":0}]
[]
[null,"On behalf of the board;"]
[]
[]
[null,"Chairperson",null,null,null,"Treasurer/Board Member"]
[]
[]
[null,"Date   "]

{"sheet":"Notes to the accounts (1)","index":8,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,11,5],[11,6,11,8],[11,9,11,10],[12,1,12,5],[12,6,12,8],[12,9,12,10],[8,1,8,5],[8,6,8,8],[8,9,8,10],[9,1,9,5],[10,1,10,5],[10,6,10,8],[10,9,10,10],[6,1,6,5],[6,6,6,8],[6,9,6,10],[7,1,7,5],[7,6,7,8],[7,9,7,10],[1,3,2,3],[1,4,2,4],[1,10,2,10],[3,1,3,6],[5,1,5,5],[5,6,5,8],[5,9,5,10]]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,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,"Motor Vehicles are depreciated over a five 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."]

{"sheet":"Notes to the accounts (2)","index":9,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,null,"Instructions"]
[]
["2. Fixed Assets:"]
[]
[]
[null,"Land & Buildings","Fixtures, Fittings and  Equipment","Covid Minor Works Fixtures, Fittings and  Equipment","Motor Vehicles","ICT","Covid Minor Works ICT","Other Capital","Total"]
[]
["Opening Balance ",{"$f":"'Detailed Balance Sheet'!F6","v":0},{"$f":"'Detailed Balance Sheet'!F12","v":0},{"$f":"'Detailed Balance Sheet'!F15","v":0},{"$f":"'Detailed Balance Sheet'!F24","v":0},{"$f":"'Detailed Balance Sheet'!F30","v":0},{"$f":"'Detailed Balance Sheet'!F33","v":0},{"$f":"'Detailed Balance Sheet'!F42","v":0},{"$f":"SUM(B8:H8)","v":0}]
["Additions ",{"$f":"'Detailed Balance Sheet'!F7","v":0},{"$f":"'Detailed Balance Sheet'!F13","v":0},{"$f":"'Detailed Balance Sheet'!F16","v":0},{"$f":"'Detailed Balance Sheet'!F25","v":0},{"$f":"'Detailed Balance Sheet'!F31","v":0},{"$f":"'Detailed Balance Sheet'!F34","v":0},{"$f":"'Detailed Balance Sheet'!F43","v":0},{"$f":"SUM(B9:H9)","v":0}]
["Disposals ",{"$f":"'Detailed Balance Sheet'!F8","v":0},{"$f":"'Detailed Balance Sheet'!F14","v":0},{"$f":"'Detailed Balance Sheet'!F17","v":0},{"$f":"'Detailed Balance Sheet'!F26","v":0},{"$f":"'Detailed Balance Sheet'!F32","v":0},{"$f":"'Detailed Balance Sheet'!F35","v":0},{"$f":"'Detailed Balance Sheet'!F44","v":0},{"$f":"SUM(B10:H10)","v":0}]
["Closing Balance ",{"$f":"SUM(B8:B10)","v":0},0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(AND(O11=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"I11-SUM(Nts_Fixed_AssetsOB)","v":0}]
[]
["Accumulated Depreciation"]
["Opening Balance ",{"$f":"'Detailed Balance Sheet'!F9","v":0},{"$f":"'Detailed Balance Sheet'!F18","v":0},{"$f":"'Detailed Balance Sheet'!F21","v":0},{"$f":"'Detailed Balance Sheet'!F27","v":0},{"$f":"'Detailed Balance Sheet'!F36","v":0},{"$f":"'Detailed Balance Sheet'!F39","v":0},{"$f":"'Detailed Balance Sheet'!F45","v":0},{"$f":"SUM(B14:H14)","v":0}]
["Current Year Depreciation",{"$f":"'Detailed Balance Sheet'!F10","v":0},{"$f":"'Detailed Balance Sheet'!F19","v":0},{"$f":"'Detailed Balance Sheet'!F22","v":0},{"$f":"'Detailed Balance Sheet'!F28","v":0},{"$f":"'Detailed Balance Sheet'!F37","v":0},{"$f":"'Detailed Balance Sheet'!F40","v":0},{"$f":"'Detailed Balance Sheet'!F46","v":0},{"$f":"SUM(B15:H15)","v":0}]
["Depreciation on Disposal",{"$f":"'Detailed Balance Sheet'!F11","v":0},{"$f":"'Detailed Balance Sheet'!F20","v":0},{"$f":"'Detailed Balance Sheet'!F23","v":0},{"$f":"'Detailed Balance Sheet'!F29","v":0},{"$f":"'Detailed Balance Sheet'!F38","v":0},{"$f":"'Detailed Balance Sheet'!F41","v":0},{"$f":"'Detailed Balance Sheet'!F47","v":0},{"$f":"SUM(B16:H16)","v":0}]
["Closing Balance Depreciation",{"$f":"SUM(B14:B16)","v":0},0,0,0,0,0,0,{"$f":"SUM(B17:H17)","v":0},null,null,null,null,{"$f":"IF(AND(O17=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"I17-SUM(Nts_Acc_Dprn)","v":0}]
[]
["Net Book Value",{"$f":"B11+B17","v":0},0,0,0,0,0,0,0]

{"sheet":"Notes to the accounts (3)","index":10,"n_rows":69,"n_cols":18,"rows_kept":69,"cut":false,"hidden":false,"merged":[[32,11,33,11],[54,1,54,2],[32,1,33,2],[32,3,33,3],[32,4,33,4],[32,5,33,5],[32,6,33,6],[32,8,33,8],[32,9,33,9],[32,10,33,10],[21,11,22,11],[1,10,2,10],[21,1,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[9,6,9,8],[9,9,9,10],[10,1,10,2],[21,8,22,8],[21,9,22,9],[21,10,22,10],[56,11,57,11],[56,3,57,3],[56,4,57,4],[56,5,57,5],[56,6,57,6],[56,8,57,8],[56,7,57,7],[56,9,57,9],[56,10,57,10]]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,null,null,null,"Instructions",null,null,null,"ⓘ"]
[]
[null,"3. Debtors and Prepaid Expenses"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2023/2024"},null,{"$f":"'Balance Sheet'!H5","v":"2022/2023"}]
[]
[null,"Grants due",null,null,null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F54","v":0},null,{"$f":"'Detailed Balance Sheet'!H54","v":0},null,"ⓘ"]
[null,"Prepayments and accrued income",null,null,null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F50+'Detailed Balance Sheet'!F51+'Detailed Balance Sheet'!F52+'Detailed Balance Sheet'!F53","v":0},null,{"$f":"'Detailed Balance Sheet'!H50+'Detailed Balance Sheet'!H51+'Detailed Balance Sheet'!H52+'Detailed Balance Sheet'!H53","v":0},null,"ⓘ"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J7)","v":0},null,{"$f":"SUM(L6:L7)","v":0},null,null,{"$f":"IF(AND(P8=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"J8-'Balance Sheet'!F15","v":0},{"$f":"IF(AND(R8=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"L8-'Balance Sheet'!H15","v":0}]
[]
[null,"4. Creditors and Accrued Expenses"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2023/2024"},null,{"$f":"'Balance Sheet'!H5","v":"2022/2023"}]
[]
[null,"Income Received in Advance",null,null,null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F68+'Detailed Balance Sheet'!F69+'Detailed Balance Sheet'!F70+'Detailed Balance Sheet'!F71","v":0},null,{"$f":"'Detailed Balance Sheet'!H68+'Detailed Balance Sheet'!H69+'Detailed Balance Sheet'!H70+'Detailed Balance Sheet'!H71","v":0},null,"ⓘ",{"$f":"IF(AND(P13=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"J13-SUM('Detailed Balance Sheet'!F68:F71)","v":0},{"$f":"IF(AND(R13=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"L13-SUM('Detailed Balance Sheet'!H68:H71)","v":0}]
[null,"Unspent Income/Grants",null,null,null,null,null,null,null,{"$f":"('Detailed Balance Sheet'!F72+'Detailed Balance Sheet'!F73+'Detailed Balance Sheet'!F74+'Detailed Balance Sheet'!F75+'Detailed Balance Sheet'!F76+'Detailed Balance Sheet'!F77+'Detailed Balance Sheet'!F78+'Detailed Balance Sheet'!F79+'Detailed Balance Sheet'!F80+'Detailed Balance Sheet'!F81+'Detailed Balance Sheet'!F82+'Detailed Balance Sheet'!F83+'Detailed Balance Sheet'!F84+'Detailed Balance Sheet'!F85+'Detailed Balance Sheet'!F86+'Detailed Balance Sheet'!F87+'Detailed Balance Sheet'!F88+'Detailed Balance Sheet'!F89+'Detailed Balance Sheet'!F90)","v":0},null,{"$f":"('Detailed Balance Sheet'!H72+'Detailed Balance Sheet'!H73+'Detailed Balance Sheet'!H74+'Detailed Balance Sheet'!H75+'Detailed Balance Sheet'!H76+'Detailed Balance Sheet'!H77+'Detailed Balance Sheet'!H78+'Detailed Balance Sheet'!H79+'Detailed Balance Sheet'!H80+'Detailed Balance Sheet'!H81+'Detailed Balance Sheet'!H82+'Detailed Balance Sheet'!H83+'Detailed Balance Sheet'!H84+'Detailed Balance Sheet'!H85+'Detailed Balance Sheet'!H86+'Detailed Balance Sheet'!H87+'Detailed Balance Sheet'!H88+'Detailed Balance Sheet'!H89+'Detailed Balance Sheet'!H90)","v":0},null,"ⓘ","ü",{"$f":"J14-SUM('Detailed Balance Sheet'!F72:F90)","v":0},"ü",{"$f":"L14-SUM('Detailed Balance Sheet'!H72:H90)","v":0}]
[null,"Control Accounts",null,null,null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F91+'Detailed Balance Sheet'!F92+'Detailed Balance Sheet'!F93+'Detailed Balance Sheet'!F94+'Detailed Balance Sheet'!F95+'Detailed Balance Sheet'!F96+'Detailed Balance Sheet'!F97+'Detailed Balance Sheet'!F98+'Detailed Balance Sheet'!F67","v":0},null,{"$f":"'Detailed Balance Sheet'!H91+'Detailed Balance Sheet'!H92+'Detailed Balance Sheet'!H93+'Detailed Balance Sheet'!H94+'Detailed Balance Sheet'!H95+'Detailed Balance Sheet'!H96+'Detailed Balance Sheet'!H97+'Detailed Balance Sheet'!H98+'Detailed Balance Sheet'!H67","v":0},null,"ⓘ","ü",{"$f":"J15-((SUM('Detailed Balance Sheet'!F91:F98)+'Detailed Balance Sheet'!F67))","v":0},"ü",{"$f":"L15-((SUM('Detailed Balance Sheet'!H91:H98)+'Detailed Balance Sheet'!H67))","v":0}]
[null,"Bank Loans",null,null,null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F99+'Detailed Balance Sheet'!F100","v":0},null,{"$f":"'Detailed Balance Sheet'!H99+'Detailed Balance Sheet'!H100","v":0},null,"ⓘ","ü",{"$f":"J16-('Detailed Balance Sheet'!F99+'Detailed Balance Sheet'!F100+'Detailed Balance Sheet'!F103)","v":0},"ü",{"$f":"L16-('Detailed Balance Sheet'!H99+'Detailed Balance Sheet'!H100+'Detailed Balance Sheet'!H103)","v":0}]
[null,"Leases",null,null,null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F101","v":0},null,{"$f":"'Detailed Balance Sheet'!H101","v":0},null,"ⓘ","ü",{"$f":"J17-('Detailed Balance Sheet'!F101)","v":0},"ü",{"$f":"L17-('Detailed Balance Sheet'!H100+'Detailed Balance Sheet'!H99+'Detailed Balance Sheet'!H103)","v":0}]
[null,"Accruals",null,null,null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F102","v":0},null,{"$f":"'Detailed Balance Sheet'!H102","v":0},null,"ⓘ","ü",{"$f":"J18-'Detailed Balance Sheet'!F102","v":0},"ü",{"$f":"L18-'Detailed Balance Sheet'!H102","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J13:J18)","v":0},null,{"$f":"SUM(L13:L18)","v":0},null,null,"ü",{"$f":"J19-'Balance Sheet'!F21","v":0},"ü",{"$f":"L19-'Balance Sheet'!H21","v":0}]
[]
[null,"4.1 Breakdown of Income Received in Advance"]
[null,null,null,{"$f":"CONCATENATE('Accountants'' Report'!D25,\" \",'Accountants'' Report'!E25)","v":"September 1, 2023"},null,"Government Grants Received in Advance",null,"Recognised in I & E Account",null,"Transfer to Current Liabilities (Unspent)/ Capital Reserves",null,{"$f":"CONCATENATE('Accountants'' Report'!G25,'Accountants'' Report'!H25)","v":"August 31, 2024"}]
[]
[]
[null,"School Income Received in Advance",null,{"$f":"'Detailed Balance Sheet'!H68","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F68","v":0},null,"ⓘ",{"$f":"IF(AND(P25=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"D25+F25-H25-J25-L25","v":0}]
[null,"Grants Received in Advance",null,{"$f":"'Detailed Balance Sheet'!H69","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F69","v":0},null,"ⓘ",{"$f":"IF(AND(P26=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"D26+F26-H26-J26-L26","v":0}]
[null,"DEIS Grant Received in Advance",null,{"$f":"'Detailed Balance Sheet'!H71","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F71","v":0},null,"ⓘ",{"$f":"IF(AND(P27=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"D27+F27-H27-J27-L27","v":0}]
[null,"Book Grant Received in Advance",null,{"$f":"'Detailed Balance Sheet'!H70","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F70","v":0},null,"ⓘ","ü",{"$f":"D28+F28-H28-J28-L28","v":0}]
[null,null,null,{"$f":"SUM(D25:D28)","v":0},null,{"$f":"SUM(F25:F28)","v":0},null,{"$f":"SUM(H25:H28)","v":0},null,{"$f":"SUM(J25:J28)","v":0},null,{"$f":"SUM(L25:L28)","v":0},null,null,{"$f":"IF(AND(P29=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"L29-J13","v":0}]
[]
[]
[]
[null,"4.2 Breakdown of Unspent Income/Grants",null,{"$f":"CONCATENATE('Accountants'' Report'!D25,\" \",'Accountants'' Report'!E25)","v":"September 1, 2023"},null,"Government Grants Received",null,"Recognised in I & E Account",null,"Transfer from Current Liabilities (Advances)/ to Capital Reserves",null,{"$f":"CONCATENATE('Accountants'' Report'!G25,'Accountants'' Report'!H25)","v":"August 31, 2024"}]
[]
[]
[null,"Book Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H72","v":0},null,0,null,0,null,{"$f":"J28","v":0},null,{"$f":"'Detailed Balance Sheet'!F72","v":0},null,"ⓘ",{"$f":"IF(AND(P36=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"D36+F36-H36+J36-L36","v":0}]
[null,"School Library Books Capital Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H73","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F73","v":0},null,"ⓘ","ü",{"$f":"D37+F37-H37-J37-L37","v":0}]
[null,"Early Start Scheme Materials/Equipment/Parental Development Unspent ",null,{"$f":"'Detailed Balance Sheet'!H74","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F74","v":0},null,"ⓘ","ü",0]
[null,"ICT Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H75","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F75","v":0},null,"ⓘ","ü",{"$f":"D39+F39-H39-J39-L39","v":0}]
[null,"Minor Works Grant Unspent ",null,{"$f":"'Detailed Balance Sheet'!H76","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F76","v":0},null,"ⓘ","ü",{"$f":"D40+F40-H40-J40-L40","v":0}]
[null,"JCSP Grant Unspent ",null,{"$f":"'Detailed Balance Sheet'!H77","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F77","v":0},null,"ⓘ","ü",0]
[null,"Non Teachers Pay Budget Grant Unspent ",null,{"$f":"'Detailed Balance Sheet'!H78","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F78","v":0},null,"ⓘ","ü",0]
[null,"COVID Minor Works Grant Unspent ",null,{"$f":"'Detailed Balance Sheet'!H79","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F79","v":0},null,"ⓘ","ü",0]
[null,"Supervision and Substitution Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H80","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F80","v":0},null,"ⓘ","ü",0]
[null,"Other Ringfenced Grants Unspent*",null,{"$f":"'Detailed Balance Sheet'!H81","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F81","v":0},null,"ⓘ","ü",{"$f":"D45+F45-H45-J45-L45","v":0}]
[null,"Other Ringfenced Income Unspent",null,{"$f":"'Detailed Balance Sheet'!H82","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F82","v":0},null,"ⓘ","ü",{"$f":"D46+F46-H46-J46-L46","v":0}]
[null,"Digital Divide Grant Unspent ",null,{"$f":"'Detailed Balance Sheet'!H83","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F83","v":0},null,"ⓘ","ü",0]
[null,"School Excellence Fund Unspent",null,{"$f":"'Detailed Balance Sheet'!H84","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F84","v":0},null,"ⓘ","ü",0]
[null,"COVID Aide Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H85","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F85","v":0},null,"ⓘ","ü",0]
[null,"COVID Capitation for PPE Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H86","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F86","v":0},null,"ⓘ","ü",0]
[null,"COVID Enhanced Supervision Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H87","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F87","v":0},null,"ⓘ","ü",0]
[null,"COVID Capitation for Additional Cleaning Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H88","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F88","v":0},null,"ⓘ","ü",{"$f":"D52+F52-H52-J52-L52","v":0}]
[null,"COVID Replacement Hours Unspent",null,{"$f":"'Detailed Balance Sheet'!H89","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F89","v":0},null,"ⓘ","ü",0]
[null,"COVID Capitation for Cleaning and PPE Grant Unspent",null,{"$f":"'Detailed Balance Sheet'!H90","v":0},null,0,null,0,null,0,null,{"$f":"'Detailed Balance Sheet'!F90","v":0},null,"ⓘ","ü",0]
[null,null,null,{"$f":"SUM(D36:D54)","v":0},null,{"$f":"SUM(F36:F54)","v":0},null,{"$f":"SUM(H36:H54)","v":0},null,{"$f":"SUM(J36:J54)","v":0},null,{"$f":"SUM(L36:L54)","v":0},null,null,{"$f":"IF(AND(P55=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"L55-J14","v":0}]
[]
[null,"4.3 *Other Ringfenced Grants Unspent",null,{"$f":"CONCATENATE('Accountants'' Report'!D25,\" \",'Accountants'' Report'!E25)","v":"September 1, 2023"},null,"Government Grants Received",null,"Recognised in I & E Account",null,"Transfer to Capital Reserves",null,{"$f":"CONCATENATE('Accountants'' Report'!G25,'Accountants'' Report'!H25)","v":"August 31, 2024"},null,"ⓘ"]
[]
[]
[null,"Bus Escort Grant ",null,0,null,0,null,0,null,0,null,{"$f":"D60+F60-H60-J60","v":0}]
[null,"Home School Liaison",null,0,null,0,null,0,null,0,null,{"$f":"D61+F61-H61-J61","v":0}]
[null,"Other State Funding ",null,0,null,0,null,0,null,0,null,0]
[null,"School Meals Grant",null,0,null,0,null,0,null,0,null,0]
[null,"Special Education Equipment Grant",null,0,null,0,null,0,null,0,null,0]
[null,"Standardised Testing  Grant",null,0,null,0,null,0,null,0,null,0]
[null,"Summer Programmes",null,0,null,0,null,0,null,0,null,0]
[null,"Temporary Rental Accommodation Grant",null,0,null,0,null,0,null,0,null,0]
[null,"Capital Works Grant",null,0,null,0,null,0,null,0,null,0]
[null,null,null,{"$f":"SUM(D60:D68)","v":0},null,{"$f":"SUM(F60:F68)","v":0},null,{"$f":"SUM(H60:H68)","v":0},null,{"$f":"SUM(J60:J68)","v":0},null,{"$f":"SUM(L60:L68)","v":0},null,null,{"$f":"IF(AND(P69=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"L45-L69","v":0}]

{"sheet":"Notes to the accounts (4)","index":11,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,41,10],[6,14,6,17],[6,2,6,10],[26,2,26,10],[13,14,15,14],[13,15,15,15],[13,16,15,16],[13,17,15,17],[16,14,17,14],[16,15,17,15],[16,16,17,16],[16,17,17,17]]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,null,null,null,null,null,null,"ⓘ"]
[null,null,null,null,null,null,null,null,null,null,null,null,true]
["5. Contribution Towards the Cost of Fixed Assets"]
[]
[]
["5.1 Contribution towards the cost of Building"]
[null,null,"Capital Buildings",null,null,null,null,null,null,null,null,null,null,null,"ⓘ Information"]
[null,null,"DE Grant Contribution","Fundraising Contribution","Parents Contribution ","Patron/Trustee Contribution","Other State Capital Contribution","Covid Minor Works Contribution","Capital Donations Contribution",null,"Total",null,null,null,null,"Income","Expenditure","Note"]
["Income",null,null,null,null,null,null,null,null,null,null,null,null,null,"DE Grant Contribution","3900 DE Capital Building Grant Income                                         ","3940 DE Capital Building Grant Expense                                         "]
["Opening Balance",null,{"$f":"'Detailed Balance Sheet'!H108","v":0},{"$f":"'Detailed Balance Sheet'!H109","v":0},{"$f":"'Detailed Balance Sheet'!H110","v":0},{"$f":"'Detailed Balance Sheet'!H111","v":0},{"$f":"'Detailed Balance Sheet'!H112","v":0},0,0,null,{"$f":"SUM(C10:I10)","v":0},null,null,null,"Fundraising Contribution","3901 Capital Projects Fundraising Income                                        ","3960 Capital Land/Building Fundraising Expense                         "]
["Received during the year",null,0,0,0,0,0,0,0,null,{"$f":"SUM(C11:I11)","v":0},null,null,null,"Parents Contribution","3902 Parents Contribution to Capital Projects Income","3970 Parents Contribution to Capital Land/Building Expense       "]
["Transferred to Building Fund Account during the year",null,0,0,0,0,0,0,0,null,{"$f":"SUM(C12:I12)","v":0},null,null,null,"Patron/Trustee Contribution","3903 Patron/Trustee Contribution to Capital Projects Income    ","3990 Patron/Trustee Contribution to Capital Building Expense  "]
["Closing Balance ",null,{"$f":"'Detailed Balance Sheet'!F108","v":0},{"$f":"'Detailed Balance Sheet'!F109","v":0},{"$f":"'Detailed Balance Sheet'!F110","v":0},{"$f":"'Detailed Balance Sheet'!F111","v":0},{"$f":"'Detailed Balance Sheet'!F112","v":0},0,0,null,{"$f":"SUM(C13:I13)","v":0},null,{"$f":"IF(AND(N13=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"SUM(C10:I10)+SUM(C11:I11)-SUM(C12:I12)-SUM(C13:I13)","v":0},"Other state capital Contribution","3904 Other State Capital Projects Income                                           ","3991  Other State Capital Land/Building Expense        "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Covid Minor Works Contribution","3905 Covid Minor Works Capital Grant Income","3941 Covid Minor Works Building Expense","The income account may contain building income as well as equipment income. Income needs to be split and only building income included in this note. (see accounting treatment \"Use of the Covid Minor Works Grant for capital building expenses and capital equipment\")"]
["Expenditure"]
["Opening Balance",null,{"$f":"'Detailed Balance Sheet'!H120","v":0},{"$f":"'Detailed Balance Sheet'!H122","v":0},{"$f":"'Detailed Balance Sheet'!H123","v":0},{"$f":"'Detailed Balance Sheet'!H124","v":0},{"$f":"'Detailed Balance Sheet'!H125","v":0},{"$f":"'Detailed Balance Sheet'!H121","v":0},{"$f":"'Detailed Balance Sheet'!H126","v":0},null,{"$f":"SUM(C16:I16)","v":0}]
["Expended during the year",null,0,0,0,0,0,0,0,null,{"$f":"SUM(C17:I17)","v":0},null,null,null,"Capital Donations Contribution","3907 Capital Donations Income","3992 Capital Donations Land/Building Expense","The income account ,may contain building income as well as equipment income. Income needs to be split and only building income included in this note. (see accounting treatment \"Donations for Capital Projects\")"]
["Transferred to Building Fund Account during the year",null,0,0,0,0,0,0,0,null,{"$f":"SUM(C18:I18)","v":0}]
["Closing Balance ",null,{"$f":"'Detailed Balance Sheet'!F120","v":0},{"$f":"'Detailed Balance Sheet'!F122","v":0},{"$f":"'Detailed Balance Sheet'!F123","v":0},{"$f":"'Detailed Balance Sheet'!F124","v":0},{"$f":"'Detailed Balance Sheet'!F125","v":0},{"$f":"'Detailed Balance Sheet'!F121","v":0},{"$f":"'Detailed Balance Sheet'!F126","v":0},null,{"$f":"SUM(C19:I19)","v":0}]
[]
["Net contribution Building",null,{"$f":"C13+C19","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C21:I21)","v":0},null,{"$f":"IF(AND(N21=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"SUM(C16:I16)+SUM(C17:I17)-SUM(C18:I18)-SUM(C19:I19)","v":0}]
[]
[]
[]
[]
["5.2 Building Fund Account"]
[null,null,"Capital Buildings"]
[null,null,"DE Grant Contribution","Fundraising Contribution","Parents Contribution ","Patron/Trustee Contribution","Other State Capital Contribution","Covid Minor Works Contribution","Capital Donations Contribution",null,"Total"]
["Income"]
["Opening Balance",null,0,0,0,0,0,0,0,null,{"$f":"SUM(C30:I30)","v":0}]
["Transferred from Contribution towards the cost of Building",null,{"$f":"C12","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C31:I31)","v":0}]
["Closing Balance",null,{"$f":"SUM(C30:C31)","v":0},{"$f":"SUM(D30:D31)","v":0},0,0,{"$f":"SUM(G30:G31)","v":0},{"$f":"SUM(H30:H31)","v":0},0,null,{"$f":"SUM(C32:I32)","v":0}]
[]
["Expenditure"]
["Opening Balance",null,0,0,0,0,0,0,0,null,{"$f":"SUM(C35:I35)","v":0}]
["Transferred from Contribution towards the cost of Building",null,{"$f":"C18","v":0},{"$f":"D18","v":0},0,0,0,0,{"$f":"I18","v":0},null,{"$f":"SUM(C36:I36)","v":0}]
["Closing Balance",null,{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},0,0,0,0,{"$f":"SUM(I35:I36)","v":0},null,{"$f":"SUM(C37:I37)","v":0}]
[]
["Net Building Fund Account",null,{"$f":"C32-C37","v":0},{"$f":"D32-D37","v":0},0,0,0,0,{"$f":"I32-I37","v":0},null,0,null,{"$f":"IF(AND(O39=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"K39-'Detailed Balance Sheet'!F127","v":0},{"$f":"ROUND(N39,2)","v":0}]
[]
[]
["In the year following completion of capital building works, the balance in Contribution towards the cost of Capital Buildings codes : DE Capital Grants, Fund-raising, Donations, Patron/Trustee Contributions, etc is to be transferred to the Building Fund account. "]

{"sheet":"Notes to the accounts (5)","index":12,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,4,3,7],[4,16,4,19],[6,18,8,18],[9,16,10,16],[9,17,10,17],[9,18,10,18],[9,19,10,19]]}
[{"$f":"'General Information'!E4","v":"Sample School"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ⓘ"]
[]
[null,"5.3 Non-building Capital Grants"]
[null,null,null,null,"FF&E",null,null,null,null,"ICT"]
[null,"Fixtures,Fittings and Equipment and ICT Capital",null,null,"DE Fixtures, Fittings and Equipment (FF&E)","                               DE Covid Minor Works (FF&E)","                    Donations Contribution (FF&E)","Total FF&E",null,"DE ICT Equipment",null,"Total",null,null,null,null,"ⓘ Information"]
[null,"Grants received   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income","Amortisation","Note"]
[null,"Opening Balance ",null,null,{"$f":"'Detailed Balance Sheet'!H116","v":0},0,0,{"$f":"SUM(E7:G7)","v":0},null,{"$f":"'Detailed Balance Sheet'!H117","v":0},null,{"$f":"SUM(H7:J7)","v":0},null,null,null,null,"DE FF&E","3920 DE Fixtures, Fittings & Equipment Grant Income                                     ","3925 Accumulated Amortisation of Capital Equipment Income"]
[null,"Received during the year",null,null,0,0,0,{"$f":"SUM(E8:G8)","v":0},null,0,null,{"$f":"SUM(H8:J8)","v":0},null,null,null,null,"DE Covid Minor Works (FF&E)","3905 Covid Minor Works Capital Grant Income",null,"The income account may contain building income as well as equipment income. Income needs to be split and only FF&E income included in this note. (see accounting treatment \"Use of the Covid Minor Works Grant for capital building expenses and capital equipment\")"]
[null,"Expensed during the year",null,null,0,0,0,{"$f":"SUM(E9:G9)","v":0},null,0,null,{"$f":"SUM(H9:J9)","v":0},null,null,null,null,"Donations Contribution (FF&E)","3907 Capital Donations Income",null,"The income account may contain building income as well as equipment income. Income needs to be split and only FF&E income included in this note. (see accounting treatment \"Donations for Capital Projects\")"]
[null,"Closing Balance ",null,null,{"$f":"SUM(E7:E9)","v":0},0,0,{"$f":"SUM(E10:G10)","v":0},null,{"$f":"SUM(J7:J9)","v":0},null,{"$f":"SUM(H10:J10)","v":0},null,null,null,null,"ICT Equipment","3921 DE ICT Grant Capital Income    ","3926 Accumulated Amortisation of ICT Grant Capital Income"]
[]
[null,"Amortisation "]
[null,"Opening Balance ",null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!H118","v":0},null,{"$f":"'Detailed Balance Sheet'!H119","v":0},null,{"$f":"SUM(H13:J13)","v":0}]
[null,"Amortisation for the year  ",null,null,null,null,null,{"$f":"-'Income Account'!F26","v":0},null,{"$f":"-'Income Account'!F27","v":0},null,{"$f":"SUM(H14:J14)","v":0}]
[null,"Closing Balance",null,null,null,null,null,{"$f":"SUM(H13:H14)","v":0},null,{"$f":"SUM(J13:J14)","v":0},null,{"$f":"SUM(H15:J15)","v":0}]
[]
[null,"Net Contribution    ",null,null,null,null,null,{"$f":"H10+H15","v":0},null,{"$f":"J10+J15","v":0},null,{"$f":"SUM(H17:J17)","v":0}]
[]
[]
[null,"5.4 Summary"]
[null,"Contribution towards the cost of Fixed Assets"]
[null,null,null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2023/2024"},null,{"$f":"'Balance Sheet'!H5","v":"2022/2023"}]
[5.0999999999999996,"Contribution towards the cost of Building",null,null,null,null,null,{"$f":"'Notes to the accounts (4)'!K21","v":0},null,0]
[5.2,"Building Fund Account",null,null,null,null,null,{"$f":"'Notes to the accounts (4)'!K39","v":0},null,0]
[5.3,"Non Building Capital Grants",null,null,null,null,null,{"$f":"L17","v":0},null,0]
[null,"Accumulated Amortisation of Capital Building Income",null,null,null,null,null,{"$f":"'Detailed Balance Sheet'!F114","v":0},null,{"$f":"'Detailed Balance Sheet'!H114","v":0},null,null,null,null,null,"ⓘ"]
[null,"Total Contribution towards the Cost of Fixed Assets",null,null,null,null,null,{"$f":"SUM(H23:H26)","v":0},null,{"$f":"SUM(J23:J26)","v":0},null,null,null,null,null,{"$f":"IF(AND(R27=0),CHAR(252),CHAR(251))","v":"ü"},{"$f":"H27-'Balance Sheet'!F30","v":0},{"$f":"ROUND(Q27,2)","v":0}]

{"sheet":"Income Account","index":13,"n_rows":105,"n_cols":10,"rows_kept":105,"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":"2024"}]
[null,"Income",null,null,null,"Current Actual                    ",null,"Last Year Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2023/2024"},null,{"$f":"'Balance Sheet'!H5","v":"2022/2023"}]
[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"}]
[3021,"Early Start Programme Mat/Equip/Par Inv Grant",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"]
[3022,"Early Start Programme Capitation ",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"]
[3030,"Non Teachers Pay Budget",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"]
[3050,"Ancillary/School Support Services 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"]
[3100,"Secretarial 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"]
[3130,"Caretaker Grant",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"]
[3140,"Special Education Equipment 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"]
[3150,"Book Grant Income",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"]
[3151,"Primary Free Schoolbook 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,{"$f":"IF(AND(F16=0,H16=0),\"N\",\"Y\")","v":"N"}]
[3152,"Primary Free Schoolbook Admin 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"]
[3155,"School Library Books Capital 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"]
[3160,"Book Rental Scheme Grant",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,{"$f":"IF(AND(F19=0,H19=0),\"N\",\"Y\")","v":"N"}]
[3170,"Special Subject Grant",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"]
[3171,"Irish and Bilingual School Grant",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,{"$f":"IF(AND(F21=0,H21=0),\"N\",\"Y\")","v":"N"}]
[3190,"JCSP Grant",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"]
[3200,"Transition Year Grant",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"]
[3210,"Leaving Certificate Applied 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"]
[3220,"Grant for Traveller Students",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"]
[3225,"Amortisation of  DE Equipment Grants",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"]
[3226,"Amortisation of  DE ICT Grants",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"]
[3227,"Amortisation of Other DE Grants",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"]
[3230,"ICT 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"]
[3240,"Supervision and Substitution Grant",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"]
[3245,"Physics/Chemistry 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"]
[3255,"State Exam Income",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"]
[3260,"School Excellence Fund Income",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"]
[3270,"Sports Complex 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"]
[3275,"Minor Works Grant-Non Capital",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"]
[3276,"Temporary Accommodation Grant Income",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"]
[3277,"COVID Minor Works Grant           ",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"]
[3280,"COVID Aide Grant",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"]
[3282,"COVID Enhanced Supervision Grant",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"]
[3284,"COVID Funding for Replacement Caretaker Hours",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"]
[3285,"COVID Funding for Replacement Secretarial Hours",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"]
[3286,"COVID Funding for Replacement Cleaner Hours",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"]
[3287,"COVID Funding for Replacement Bus Escort Hours",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"]
[3288,"COVID Capitation for Cleaning and PPE Grant",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"]
[3289,"Once-Off Cost of Living Grant",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"]
[3290,"Other Non Capital DE Grant 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,"N"]
[3292,"Standardised Testing 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"]
[3293,"Summer Provision Grant                         ",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"]
[3294,"Bus Escort Grant",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"]
[null,"Total Department of Education Income       ",null,null,null,{"$f":"SUM(F6:F49)","v":0},null,{"$f":"SUM(H6:H49)","v":0}]
[null,"2. Other State Income                                                                     "]
[3295,"Department of Children and Youth Affairs Income",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"]
[3296,"DEASP School Meals Grant",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"]
[3297,"Erasmus 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"]
[3298,"HSE Funding",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"]
[3299,"Other State Funding",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"]
[null,"Total Other State Income",null,null,null,{"$f":"SUM(F52:F56)","v":0},null,{"$f":"SUM(H52:H56)","v":0}]
[null,"3. School Generated Income                                                   "]
[3300,"Education Fees (Fee paying schools)",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"]
[3310,"Transition Year 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"]
[3330,"Book Rental Scheme Income",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"]
[3335,"Classroom Books 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"]
[3350,"Hire of Facilities Rental 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"]
[3370,"Locker 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"]
[3375,"Journals and Year Book 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"]
[3380,"Student Photocopying 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"]
[3390,"School Administration Charges",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"]
[3395,"Practical Subjects 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"]
[3410,"Adult Education 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"]
[3420,"Canteen 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"]
[3430,"Tuck Shop 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"]
[3440,"Uniforms 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"]
[3460,"Career Guidance 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,{"$f":"IF(AND(F73=0,H73=0),\"N\",\"Y\")","v":"N"}]
[3450,"Religion/Ethos 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"]
[3490,"After School Study/Club 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"]
[3495,"Mock Exam 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"]
[3500,"Games 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"]
[3510,"Bus 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"]
[3520,"School Musical/Drama 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"]
[3530,"School Tours 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"]
[3531,"School Swimming 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"]
[3535,"Student Insurance 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"]
[3540,"Pre-School 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"]
[3545,"Summer Camps 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"]
[3550,"Reimbursable 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"]
[3570,"Other School Generated 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"]
[3572,"School Arts and Crafts Income",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"]
[3573,"School Dance Income                                                                ",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"]
[3574,"Restricted School Fundraising (Non Capital)",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"]
[3575,"Unrestricted School Fundraising  (Non Capital)",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"]
[3580,"Discounts Given",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"]
[null,"Total School Generated Income",null,null,null,{"$f":"SUM(F59:F91)","v":0},null,{"$f":"SUM(H59:H91)","v":0}]
[null,"4. Other Income                                                            "]
[3650,"Voluntary Contributions",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"]
[3700,"Income from Parents Association",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"]
[3770,"Insurance Claim Income",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"]
[3800,"Bank Interest Received",null,null,null,{"$f":"-IFERROR(VLOOKUP(A97,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A97,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3840,"Amortisation of Non DE funding                                             ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A98,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A98,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3850,"Other Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A99,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A99,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3851,"Designated Income (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A100,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A100,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3852,"Restricted External Fundraising  (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A101,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A101,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3853,"Unrestricted External Fundraising  (Non Capital)",null,null,null,{"$f":"-IFERROR(VLOOKUP(A102,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A102,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,"Total Other Income",null,null,null,{"$f":"SUM(F94:F102)","v":0},null,{"$f":"SUM(H94:H102)","v":0}]
[]
[null,"TOTAL INCOME",null,null,null,{"$f":"F50+F57+F92+F103","v":0},null,{"$f":"H50+H57+H92+H103","v":0}]

{"sheet":"Expenditure Account (1)","index":14,"n_rows":83,"n_cols":10,"rows_kept":83,"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":"2024"}]
[null,"Expenditure",null,null,null,"Actual                    ",null,"Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2023/2024"},null,{"$f":"'Balance Sheet'!H5","v":"2022/2023"}]
[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"]
[4113,"Primary Free Schoolbook Admin 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,{"$f":"IF(AND(F9=0,H9=0),\"N\",\"Y\")","v":"N"}]
[4150,"Supervision and Substitution 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"]
[4155,"State Exam 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"]
[4170,"Adult Education 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"]
[4180,"Sport Coach 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"]
[4181,"Canteen 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"]
[4190,"After School Study/Club 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"]
[4191,"Summer Camps Salaries 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"]
[4196,"Bus Escort Salary 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"]
[4197,"COVID Replacement Bus Escort Hours 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"]
[4198,"Other Educational 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,{"$f":"IF(AND(F19=0,H19=0),\"N\",\"Y\")","v":"N"}]
[4199,"HSE Funded Salaries 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"]
[null,"Total Education Salary",null,null,null,{"$f":"SUM(F5:F20)","v":0},null,{"$f":"SUM(H5:H20)","v":0}]
[null,"6. Education Other Expenditure"]
[4310,"Teaching Aids 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"]
[4311,"Early Start Programme Mat/Equip/Par Inv Expenses",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"]
[4315,"Student Photocopying Expenses",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"]
[4330,"Religion/Ethos 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"]
[4350,"Art 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"]
[4370,"Home Economics 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"]
[4390,"Science 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"]
[4410,"ICT Grant Non - Capital 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"]
[4420,"Computer Maintenance & Support 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"]
[4430,"Woodwork / Building Construction 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"]
[4450,"Metalwork / Engineering 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"]
[4470,"Technology 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"]
[4490,"Other Subjects 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"]
[4550,"Leaving Cert Applied 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"]
[4570,"LCVP 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"]
[4590,"Transition Year 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"]
[4610,"Learning Support 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"]
[4620,"Teacher Inservice and Training 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"]
[4630,"Career Guidance 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"]
[4635,"Student Wellbeing 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"]
[4640,"Library Non Grant Funded 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"]
[4641,"School Library Books Capital Grant 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"]
[4650,"Physical Education 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"]
[4670,"Games (excl. travel) 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"]
[4671,"Travel Games 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"]
[4690,"Bus Hire 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"]
[4710,"School Tours 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"]
[4720,"School Musical/Drama 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"]
[4730,"Book Grant 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"]
[4731,"Primary Free Schoolbook Grant 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,{"$f":"IF(AND(F52=0,H52=0),\"N\",\"Y\")","v":"N"}]
[4740,"Book Rental Scheme 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"]
[4741,"Classroom Book 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"]
[4750,"Mock Examinations 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"]
[4760,"School Yearbook/Journal 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"]
[4770,"Trophies and Prizes 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"]
[4780,"Uniform 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"]
[4810,"Home School Liaison 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"]
[4815,"School Excellence Fund 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"]
[4850,"Student Council 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"]
[4908,"Other Summer Camps 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"]
[4909,"Other Summer Provision 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"]
[4910,"Other Educational 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"]
[4911,"Department of Children and Youth Affairs Activities 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"]
[4912,"DSP School Meals Food Costs                       ",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"]
[4913,"Erasmus Expense",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"]
[4914,"Other Non Capital DE Grants 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"]
[4915,"Other Canteen 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"]
[4916,"Student Insurance 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"]
[4917,"Standardised Testing 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"]
[4918,"Designated Expenditure (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"]
[4919,"Special Educational Equipment (Non Capital) Expense",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,{"$f":"IF(AND(F73=0,H73=0),\"N\",\"Y\")","v":"N"}]
[4920,"School Dance Expense                                               ",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"]
[4921,"School Swimming 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"]
[4922,"Restricted School Fundraising Expenses  (Non Capital)",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"]
[4923,"Restricted External Fundraising Expenses  (Non Capital)",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"]
[4924,"Unrestricted External Fundraising Expenses (Non Capital)",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"]
[4925,"Unrestricted School Fundraising Expenses (Non Capital)",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"]
[4927,"School Arts and Crafts Expense",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"]
[4928,"Other HSE Expense",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"]
[4930,"Pre-School Expense",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"]
[null,"Total Education Other Expenditure",null,null,null,{"$f":"SUM(F23:F82)","v":0},null,{"$f":"SUM(H23:H82)","v":0}]

{"sheet":"Expenditure Account (2)","index":15,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[[1,0,1,5],[34,1,34,3],[61,1,61,2],[70,1,70,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":"2024"}]
[null,"Expenditure",null,null,null,"Actual                    ",null,"Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2023/2024"},null,{"$f":"'Balance Sheet'!H5","v":"2022/2023"}]
[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"}]
[5030,"Caretaker Pension 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"]
[5110,"Cleaners Wages 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"]
[5111,"COVID Replacement Cleaner Hours 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"]
[5112,"Cleaners' Pension 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"]
[5150,"Contract Cleaners 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"]
[5170,"Cleaning Materials 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"]
[5175,"Other Cleaning and Sanitation 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"]
[5310,"Repairs to Buildings and Grounds 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"]
[5315,"Minor Works Grant (Non Capital) 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"]
[5316,"COVID Minor Works Grant 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"]
[5350,"Repairs to Furniture, Fittings and Equipment 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"]
[5400,"Routine Security 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"]
[5450,"General Insurance 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"]
[5510,"Heating 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"]
[5550,"Light and Power 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"]
[5551,"Rent of Temporary Accommodation 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"]
[5552,"Other Rental Costs 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"]
[5553,"Rent of DE Funded Sports Hall Expenses (C&C only)",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"]
[5800,"Other Repairs and Maintenance 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"]
[5801,"COVID Aide Grant Wages 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"]
[5803,"COVID Enhanced Supervision 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"]
[5804,"COVID Capitation for Cleaning Wages 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"]
[5806,"COVID Capitation for Cleaning (Non Wages) and PPE Grant 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"]
[null,"Total Repairs, Maintenance & Establishment",null,null,null,{"$f":"SUM(F6:F33)","v":0},null,{"$f":"SUM(H6:H33)","v":0}]
[null,"8. Administration"]
[6010,"Clerical Officers/Secretarial Wages 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"]
[6011,"COVID Replacement Secretary Hours 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"]
[6050,"Clerical Officers/Secretarial Pension 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"]
[6100,"Recruitment 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"]
[6150,"Advertising / Public Relations 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"]
[6210,"Postage 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"]
[6250,"Telephone Expense / SMS Text",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"]
[6300,"Printing and Stationery 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"]
[6350,"Office Equipment (Non Capital) 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"]
[6355,"Non-ICT Grant Funded Office Computers 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"]
[6400,"Accounting / Auditing 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"]
[6450,"Other Professional Fees 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"]
[6500,"Travel and Subsistence 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"]
[6600,"Principals Expenses",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"]
[6650,"Board of Management 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"]
[6700,"Annual Subscriptions 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"]
[6730,"InSchool Administration System 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"]
[6731,"Accounting Software / Payroll Software 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"]
[6750,"Donations to Charity",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"]
[6755,"Medical and First Aid 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"]
[6780,"Staff Room Expenses",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"]
[6800,"Hospitality 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"]
[6830,"Tuck Shop 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"]
[6870,"Sports Complex DE Grant Transfer",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"]
[6900,"Other Administration 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"]
[null,"Total Administration Expenditure",null,null,null,{"$f":"SUM(F36:F60)","v":0},null,{"$f":"SUM(H36:H60)","v":0}]
[null,"9. Financial"]
[7300,"Leasing 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"]
[7320,"Loan Charges 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"]
[7400,"Bank Interest 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"]
[7450,"Bank Charges 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"]
[7500,"Pensioners Payroll Expense",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"]
[7800,"Reimbursable Expenses",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"]
[7850,"Discounts Received",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"]
[null,"Total Financial Expenses",null,null,null,{"$f":"SUM(F63:F69)","v":0},null,{"$f":"SUM(H63:H69)","v":0}]
[null,"10. Depreciation"]
[8000,"Annual Depreciation: Buildings",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,{"$f":"IF(AND(F72=0,H72=0),\"N\",\"Y\")","v":"N"}]
[8020,"Annual Depreciation: Fixtures, Fittings and Equipment",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"]
[8040,"Annual Depreciation: Motor Vehicles",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"]
[8060,"Annual Depreciation: ICT",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"]
[8080,"Annual Depreciation: Other",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"]
[null,"Total Depreciation",null,null,null,{"$f":"SUM(F72:F76)","v":0},null,{"$f":"SUM(H72:H76)","v":0}]
[]
[null,"TOTAL EXPENDITURE   ",null,null,null,{"$f":"SUM('Expenditure Account (1)'!F21+'Expenditure Account (1)'!F83+F34+F61+F70+F77)","v":0},null,{"$f":"SUM('Expenditure Account (1)'!H21+'Expenditure Account (1)'!H83+H34+H61+H70+H77)","v":0}]
[]
[null,"SURPLUS / DEFICIT     ",null,null,null,{"$f":"SUM('Income Account'!F105)-('Expenditure Account (2)'!F79)","v":0},null,{"$f":"SUM('Income Account'!H105-'Expenditure Account (2)'!H79)","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":16,"n_rows":128,"n_cols":10,"rows_kept":128,"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":"2024"}]
[null,null,null,null,null,"Actual                    ",null,"Actual"]
[null,null,null,null,null,{"$f":"'Balance Sheet'!F5","v":"2023/2024"},null,{"$f":"'Balance Sheet'!H5","v":"2022/2023"}]
[null,"Fixed Asset"]
[1400,"Capital: Land and Buildings Cost B/Fwd",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"}]
[1401,"Capital: Land and Buildings Additions",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"}]
[1402,"Capital: Land and Buildings Disposals",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"]
[1410,"Accumulated Depreciation : Land and Buildings B/Fwd",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"]
[1411,"Depreciation: Land and Buildings Current Year",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"]
[1412,"Depreciation: Land and Buildings on Disposal",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"]
[1420,"Capital: Fixtures, Fittings and Equipment Cost B/Fwd",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"]
[1421,"Capital: Fixtures, Fittings and Equipment Additions",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"]
[1422,"Capital: Fixtures, Fittings and Equipment Disposals",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"]
[1425,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Cost B/Fwd",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"]
[1426,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Additions",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"]
[1427,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Disposals",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"]
[1430,"Accumulated Depreciation: Fixtures, Fittings and Equipment B/Fwd",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"]
[1431,"Depreciation: Fixtures, Fittings and Equipment Current Year",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"]
[1432,"Depreciation: Fixtures, Fittings and Equipment Disposal",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"]
[1435,"Accumulated Depreciation: Covid Minor Works Fixtures, Fittings and Equipment B/Fwd",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"]
[1436,"Depreciation: Covid Minor Works Fixtures, Fittings and Equipment Current Year",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"]
[1437,"Depreciation: Covid Minor Works Fixtures, Fittings and Equipment Disposal",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"]
[1440,"Capital: Motor Vehicles Cost B/Fwd",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"]
[1441,"Capital: Motor Vehicles Additions",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"]
[1442,"Capital: Motor Vehicles Disposals",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"]
[1450,"Accumulated Depreciation: Motor Vehicles B/Fwd",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"]
[1451,"Depreciation: Motor Vehicles Current Year",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"]
[1452,"Depreciation: Motor Vehicles Disposal",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"]
[1460,"Capital: ICT Cost B/Fwd",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"]
[1461,"Capital: ICT Additions",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"]
[1462,"Capital: ICT Disposals",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"]
[1465,"Capital: Covid Minor Works ICT Cost B/Fwd",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"]
[1466,"Capital: Covid Minor Works ICT Additions",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"]
[1467,"Capital: Covid Minor Works ICT Disposals",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"]
[1470,"Accumulated Depreciation: ICT Cost B/Fwd",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"]
[1471,"Depreciation: ICT Current Year",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"]
[1472,"Depreciation: ICT Disposal",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"]
[1475,"Accumulated Depreciation: Covid Minor Works ICT B/Fwd",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"]
[1476,"Depreciation: Covid Minor Works ICT Current Year",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"]
[1477,"Depreciation: Covid Minor Works ICT Disposals",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"]
[1480,"Capital: Other Cost B/Fwd",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"]
[1481,"Capital: Other Additions",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"]
[1482,"Capital: Other Disposals",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"]
[1490,"Accumulated Depreciation Other Cost B/Fwd",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"]
[1491,"Accumulated Depreciation Other Current Year",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"]
[1492,"Accumulated Depreciation Other Disposals",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"]
[]
[null,"Current Asset"]
[1700,"Sales Ledger Control",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"]
[1710,"Stock",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"]
[1705,"Debtors",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"]
[1720,"Prepayments",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"]
[1730,"Grants Due",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"]
[1800,"Current Account 1",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"]
[1801,"Current Account 2",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"]
[1802,"Current Account 3",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"]
[1803,"DEASP School Meal Bank 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"]
[1810,"Deposit 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"]
[1820,"Parents Council/Association Bank 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"]
[1850,"Credit Card 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"]
[1870,"Online Payment Solution Clearing 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"]
[1900,"Petty Cash 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"]
[1950,"Cash 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,{"$f":"IF(AND(F64=0,H64=0),\"N\",\"Y\")","v":"N"}]
[]
[null,"Current Liability"]
[2100,"Creditors Control Account",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"]
[2105,"School Income Received in Advance",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"]
[2150,"Grants Received in Advance",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"]
[2151,"Book Grant Received in Advance",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"]
[2152,"DEIS Grant Received in Advance",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,{"$f":"IF(AND(F71=0,H71=0),\"N\",\"Y\")","v":"N"}]
[2160,"Book Grant Unspent",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"]
[2161,"School Library Books Capital Grant Unspent",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"]
[2162,"Early Start Programme Mat/Equip/Parental Involvement Grant Unspent ",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"]
[2165,"ICT Grant Unspent",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"]
[2166,"Minor Works Grant Unspent ",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"]
[2167,"JCSP Grant Unspent ",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"]
[2168,"Non Teachers Pay Budget Grant Unspent ",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"]
[2169,"COVID Minor Works Grant Unspent ",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"]
[2170,"Supervision and Substitution Grant Unspent",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"]
[2171,"Other Ringfenced Grants Unspent",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"]
[2172,"Other Ringfenced Income Unspent",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"]
[2179,"Digital Divide Grant Unspent",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"]
[2180,"School Excellence Fund Unspent",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"]
[2181,"COVID Aide Grant Unspent",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"]
[2182,"COVID Capitation for PPE Grant Unspent",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"]
[2183,"COVID Enhanced Supervision Grant Unspent",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"]
[2184,"COVID Capitation for Additional Cleaning Grant Unspent",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"]
[2185,"COVID Replacement Hours Unspent",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"]
[2186,"COVID Capitation for Cleaning and PPE Grant Unspent",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"]
[2200,"Net Wages Control Account",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"]
[2210,"Union Fees Control Account",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"]
[2220,"Single Public Service Pension Scheme Control Account",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"]
[2230,"ASC Control 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"]
[2240,"PRSA Control Account",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"]
[2250,"PAYE/PRSI/USC/LPT Control Account",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"]
[2260,"Reverse VAT Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A97,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A97,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2270,"RCT Control Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A98,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A98,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2310,"Bank Loans",null,null,null,{"$f":"-IFERROR(VLOOKUP(A99,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A99,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2320,"Other Loan",null,null,null,{"$f":"-IFERROR(VLOOKUP(A100,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A100,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2330,"Leasing",null,null,null,{"$f":"-IFERROR(VLOOKUP(A101,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A101,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2440,"Accruals",null,null,null,{"$f":"-IFERROR(VLOOKUP(A102,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A102,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[2600,"Long Term Loan ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A103,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A103,Nominal_Code_LT[],2,FALSE),0)","v":0},null,{"$f":"IF(AND(F103=0,H103=0),\"N\",\"Y\")","v":"N"}]
[null,null,null,null,null,{"$f":"SUM(F6:F45,F50:F64)-SUM(F67:F103)","v":0},null,{"$f":"SUM(H6:H45,H50:H64)-SUM(H67:M103)","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(F106=0,H106=0),\"N\",\"Y\")","v":"N"}]
[2710,"Surplus Brought Forward",null,null,null,{"$f":"-IFERROR(VLOOKUP(A107,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A107,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3900,"DE Capital Building Grant Income                                         ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A108,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A108,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3901,"Capital Projects Fundraising Income                                        ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A109,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A109,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3902,"Parents Contribution to Capital Projects Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A110,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A110,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3903,"Patron/Trustee Contribution to Capital Projects Income    ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A111,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A111,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3904,"Other State Capital Projects Income                                           ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A112,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A112,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3905,"Covid Minor Works Capital Grant Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A113,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A113,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3906,"Accumulated Amortisation of Capital Building Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A114,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A114,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3907,"Capital Donations Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A115,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A115,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3920,"DE Fixtures, Fittings & Equipment Grant Income                                     ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A116,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A116,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3921,"DE ICT Grant Capital Income                                                                   ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A117,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A117,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3925,"Accumulated Amortisation of Capital Equipment Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A118,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A118,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3926,"Accumulated Amortisation of ICT Grant Capital Income",null,null,null,{"$f":"-IFERROR(VLOOKUP(A119,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A119,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3940,"DE Capital Building Grant Expense                                         ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A120,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A120,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3941,"Covid Minor Works Building Expense",null,null,null,{"$f":"-IFERROR(VLOOKUP(A121,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A121,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3960,"Capital Land/Building Fundraising Expense                            ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A122,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A122,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3970,"Parents Contribution to Capital Land/Building Expense            ",null,null,null,{"$f":"-IFERROR(VLOOKUP(A123,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A123,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3990,"Patron/Trustee Contribution to Capital Building Expense",null,null,null,{"$f":"-IFERROR(VLOOKUP(A124,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A124,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3991,"Other State Capital Land/Building Expense",null,null,null,{"$f":"-IFERROR(VLOOKUP(A125,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A125,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3992,"Capital Donations Land/Building Expense",null,null,null,{"$f":"-IFERROR(VLOOKUP(A126,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A126,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[3995,"Land/Building Fund Account",null,null,null,{"$f":"-IFERROR(VLOOKUP(A127,Nominal_Code_LT3[],2,FALSE),0)","v":0},null,{"$f":"-IFERROR(VLOOKUP(A127,Nominal_Code_LT[],2,FALSE),0)","v":0},null,"N"]
[null,null,null,null,null,{"$f":"SUM(F106:F127)","v":0},null,{"$f":"SUM(H106:H127)","v":0}]

{"sheet":"Financial Report Parents (1)","index":17,"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":"2023/2024"}]
[]
[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'!F94)","v":0}]
[null,null,null,null,"Rental School Property",null,null,{"$f":"SUM('Income Account'!F63)","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'!F95)","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)'!F21:F22)","v":0}]
[null,null,null,null,"Insurance",null,null,{"$f":"'Expenditure Account (2)'!F20","v":0}]
[null,null,null,null,"Cleaning and waste disposal",null,null,{"$f":"SUM('Expenditure Account (2)'!F12:F14)+'Expenditure Account (2)'!F33","v":0}]
[null,null,null,null,"Rent, Rates and Local Charges",null,null,{"$f":"SUM('Expenditure Account (2)'!F23: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)'!F41+'Expenditure Account (2)'!F43)","v":0}]
[null,null,null,null,"In-School Administration Systems",null,null,{"$f":"SUM('Expenditure Account (2)'!F52:F53)","v":0}]
[null,null,null,null,"Telephone/SMS",null,null,{"$f":"'Expenditure Account (2)'!F42","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)'!F63:F69)","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":18,"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":"2023/2024"}]
[]
[]
[null,"Capital Building Projects"]
[]
[]
[null,"Income ",null,null,"Department Capital Grants Income",null,null,{"$f":"SUM('Detailed Balance Sheet'!F108)","v":0}]
[null,null,null,null,"Other Capital Income",null,null,{"$f":"SUM('Detailed Balance Sheet'!F109+'Detailed Balance Sheet'!F110+'Detailed Balance Sheet'!F111)","v":0}]
[null,null,null,null,"Other State Capital Income",null,null,{"$f":"'Detailed Balance Sheet'!F112","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'!F120","v":0}]
[null,null,null,null,"Other Capital Expenditure",null,null,{"$f":"-SUM('Detailed Balance Sheet'!F122+'Detailed Balance Sheet'!F123+'Detailed Balance Sheet'!F124)","v":0}]
[null,null,null,null,"Other State Capital Expenditure",null,null,{"$f":"-'Detailed Balance Sheet'!F125","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":19,"n_rows":35,"n_cols":13,"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,null,null,null,null,null,null,"Instructions"]
[]
[null,"Cash Flow Statement for the year ended (Optional)",null,null,"August 31, ",{"$f":"'Accountants'' Report'!H25","v":"2024"}]
[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,"Treasurer/Board Member"]
[]
[]
[null,"Date   "]

{"sheet":"Import","index":20,"n_rows":350,"n_cols":6,"rows_kept":350,"cut":false,"hidden":false,"merged":[]}
["Roll No","12345G","Instructions"]
["Nominal Code"]
["Nominal Code","Final Accounts ","Description",null,"TB Check",{"$f":"SUM(Nominal_Code_LT3[[Final Accounts ]])","v":0}]
[3010,0,"Capitation/Non Pay Budget"]
[3020,0,"DEIS Grant"]
[3021,0,"Early Start Programme Materials/Equipment/Parental Involvement Grant Income"]
[3022,0,"Early Start Programme Capitation "]
[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"]
[3151,0,"Primary Free Schoolbook Grant"]
[3152,0,"Primary Free Schoolbook Admin Grant"]
[3155,0,"School Library Books Capital Grant "]
[3160,0,"Book Rental Scheme Grant"]
[3170,0,"Special Subject Grant"]
[3171,0,"Irish and Bilingual School 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"]
[3282,0,"COVID Enhanced Supervision 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"]
[3288,0,"COVID Capitation for Cleaning and PPE Grant"]
[3289,0,"Once-Off Cost of Living Grant"]
[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"]
[3370,0,"Locker Income"]
[3375,0,"Journals and Year Book Income"]
[3380,0,"Student Photocopying 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"]
[4113,0,"Primary Free Schoolbook Admin 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"]
[4311,0,"Early Start Programme Materials/Equipment/Parental Involvement Expenses"]
[4315,0,"Student Photocopying Expenses"]
[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 Non Grant Funded Expense                                                                                                           "]
[4641,0,"School Library Books Capital Grant 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"]
[4731,0,"Primary Free Schoolbook 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"]
[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"]
[5553,0,"Rent of DE Funded Sports Hall Expenses (C&C only)"]
[5610,0,"Refuse Expense                          "]
[5611,0,"Water Rates Expense"]
[5700,0,"Licence Fee to Patron/Trustee Expense"]
[5800,0,"Other Repairs and Maintenance Expense"]
[5801,0,"COVID Aide Grant Wages Expense"]
[5803,0,"COVID Enhanced Supervision Grant Wages Expense"]
[5804,0,"COVID Capitation for Cleaning Wages Expense"]
[5806,0,"COVID Capitation for Cleaning (Non Wages) and PPE Grant Expense"]
[6010,0,"Clerical Officers/Secretarial Wages Expense"]
[6011,0,"COVID Replacement Secretary Hours Expense"]
[6050,0,"Clerical Officers/Secretarial Pension 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"]
[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 DE Grant Transfer                                                     "]
[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 Cost B/Fwd                                                                                                                      "]
[1401,0,"Capital: Land and Buildings Additions"]
[1402,0,"Capital: Land and Buildings Disposals"]
[1410,0,"Accumulated Depreciation : Land and Buildings B/Fwd                                                    "]
[1411,0,"Depreciation: Land and Buildings Current Year"]
[1412,0,"Depreciation: Land and Buildings on Disposal"]
[1420,0,"Capital: Fixtures, Fittings and Equipment Cost B/Fwd                                                       "]
[1421,0,"Capital: Fixtures, Fittings and Equipment Additions"]
[1422,0,"Capital: Fixtures, Fittings and Equipment Disposals "]
[1425,0,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Cost B/Fwd           "]
[1426,0,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Additions"]
[1427,0,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Disposals"]
[1430,0,"Accumulated Depreciation: Fixtures, Fittings and Equipment B/Fwd                         "]
[1431,0,"Depreciation: Fixtures, Fittings and Equipment Current Year       "]
[1432,0,"Depreciation: Fixtures, Fittings and Equipment Disposal             "]
[1435,0,"Accumulated Depreciation: Covid Minor Works Fixtures, Fittings and Equipment B/Fwd           "]
[1436,0,"Depreciation: Covid Minor Works Fixtures, Fittings and Equipment Current Year "]
[1437,0,"Depreciation: Covid Minor Works Fixtures, Fittings and Equipment Disposal"]
[1440,0,"Capital: Motor Vehicles Cost B/Fwd                                                                                                                                                          "]
[1441,0,"Capital: Motor Vehicles Additions"]
[1442,0,"Capital: Motor Vehicles Disposals"]
[1450,0,"Accumulated Depreciation: Motor Vehicles B/Fwd                                                                                          "]
[1451,0,"Depreciation: Motor Vehicles Current Year "]
[1452,0,"Depreciation: Motor Vehicles Disposal"]
[1460,0,"Capital: ICT Cost B/Fwd                                                                                                                                                                                    "]
[1461,0,"Capital: ICT Additions"]
[1462,0,"Capital: ICT Disposals"]
[1465,0,"Capital: Covid Minor Works ICT Cost B/Fwd                                                                                                        "]
[1466,0,"Capital: Covid Minor Works ICT Additions"]
[1467,0,"Capital: Covid Minor Works ICT Disposals"]
[1470,0,"Accumulated Depreciation: ICT Cost B/Fwd                                                                                                                 "]
[1471,0,"Depreciation: ICT Current Year "]
[1472,0,"Depreciation: ICT Disposal "]
[1475,0,"Accumulated Depreciation: Covid Minor Works ICT B/Fwd                                                               "]
[1476,0,"Depreciation: Covid Minor Works ICT Current Year "]
[1477,0,"Depreciation: Covid Minor Works ICT Disposals"]
[1480,0,"Capital: Other Cost B/Fwd                                                                                                                                                    "]
[1481,0,"Capital: Other Additions"]
[1482,0,"Capital: Other Disposals"]
[1490,0,"Accumulated Depreciation Other Cost B/Fwd                                                                                            "]
[1491,0,"Accumulated Depreciation Other Current Year "]
[1492,0,"Accumulated Depreciation Other Disposals"]
[1700,0,"Sales Ledger Control"]
[1705,0,"Debtors"]
[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"]
[2161,0,"School Library Books Capital Grant Unspent"]
[2162,0,"Early Start Programme Materials/Equipment/Parental Involvement 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"]
[2179,0,"Digital Divide Grant 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"]
[2186,0,"COVID Capitation for Cleaning and PPE Grant 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 Land/Building Fundraising Expense                         "]
[3970,0,"Parents Contribution to Capital Land/Building Expense       "]
[3990,0,"Patron/Trustee Contribution to Capital Building Expense  "]
[3991,0,"Other State Capital Land/Building Expense        "]
[3992,0,"Capital Donations Land/Building Expense   "]
[3995,0,"Land/Building Fund Account          "]

{"sheet":"Import From Manual","index":21,"n_rows":353,"n_cols":7,"rows_kept":353,"cut":false,"hidden":true,"merged":[]}
["Roll No","12345G",null,null,"Instructions",null,"Do not delete"]
["Nominal Code"]
["Nominal Code","Final Accounts "]
[1400,8387,null,null,3010,{"$f":"IFERROR(VLOOKUP(E4,Import_From_Manual_LT,2,FALSE),0)","v":-16470}]
[1420,17879,null,null,3020,{"$f":"IFERROR(VLOOKUP(E5,Import_From_Manual_LT,2,FALSE),0)","v":-5647}]
[1421,8158,null,null,3021,0]
[1430,-9698,null,null,3022,0]
[1431,-4890,null,null,3030,0]
[1460,14618,null,null,3050,-10380]
[1470,-13836,null,null,3100,0]
[1471,-511,null,null,3130,0]
[1720,2246,null,null,3140,0]
[1800,166037,null,null,3150,-9157]
[1801,177,null,null,3151,0]
[1802,1109,null,null,3152,0]
[1803,3293,null,null,3155,-1806]
[1820,6734,null,null,3160,0]
[2150,-10265,null,null,3170,0]
[2152,-5910,null,null,3171,0]
[2171,-93653,null,null,3190,0]
[2172,-2500,null,null,3200,0]
[2179,-4920,null,null,3210,0]
[2250,-1743,null,null,3220,0]
[2260,-18969,null,null,3225,0]
[2270,-16397,null,null,3226,0]
[2440,-1845,null,null,3227,0]
[2710,-26800,null,null,3230,-1117]
[3010,-16470,null,null,3240,0]
[3020,-5647,null,null,3245,0]
[3050,-10380,null,null,3255,0]
[3150,-9157,null,null,3260,0]
[3155,-1806,null,null,3270,0]
[3230,-1117,null,null,3275,-4345]
[3275,-4345,null,null,3276,0]
[3288,-6622,null,null,3277,0]
[3289,-6450,null,null,3280,0]
[3292,-459,null,null,3282,0]
[3294,-1968,null,null,3284,0]
[3296,-51928,null,null,3285,0]
[3380,-4155,null,null,3286,0]
[3530,-2668,null,null,3287,0]
[3531,-1200,null,null,3288,-6622]
[3545,-1620,null,null,3289,-6450]
[3575,-4778,null,null,3290,0]
[3700,-6350,null,null,3292,-459]
[3840,-5038,null,null,3293,0]
[3850,-4457,null,null,3294,-1968]
[3900,-22899,null,null,3295,0]
[3904,-176297,null,null,3296,-51928]
[3906,11338,null,null,3297,0]
[3921,-11263,null,null,3298,0]
[3926,6928,null,null,3299,0]
[3991,176297,null,null,3300,0]
[4110,600,null,null,3310,0]
[4196,2461,null,null,3330,0]
[4410,2249,null,null,3335,0]
[4635,414,null,null,3350,0]
[4670,1905,null,null,3370,0]
[4710,5717,null,null,3375,0]
[4730,7991,null,null,3380,-4155]
[4910,3321,null,null,3390,0]
[4912,50817,null,null,3395,0]
[4917,183,null,null,3410,0]
[4921,1008,null,null,3420,0]
[4925,875,null,null,3430,0]
[5010,3264,null,null,3440,0]
[5110,10844,null,null,3450,0]
[5310,3552,null,null,3460,{"$f":"IFERROR(VLOOKUP(E68,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[5315,279,null,null,3490,0]
[5450,3752,null,null,3495,0]
[5510,6034,null,null,3500,0]
[5550,2455,null,null,3510,0]
[5610,922,null,null,3520,0]
[5800,1137,null,null,3530,-2668]
[5806,3583,null,null,3531,-1200]
[6010,19769,null,null,3535,0]
[6150,369,null,null,3540,0]
[6250,1365,null,null,3545,-1620]
[6300,2573,null,null,3550,0]
[6400,923,null,null,3570,0]
[6700,1387,null,null,3572,0]
[6731,150,null,null,3573,0]
[6800,90,null,null,3574,0]
[7400,420,null,null,3575,-4778]
[8020,4890,null,null,3580,0]
[8060,511,null,null,3650,0]
[null,null,null,null,3700,-6350]
[null,null,null,null,3770,0]
[null,null,null,null,3800,0]
[null,null,null,null,3840,-5038]
[null,null,null,null,3850,-4457]
[null,null,null,null,3851,0]
[null,null,null,null,3852,0]
[null,null,null,null,3853,0]
[null,null,null,null,4110,600]
[null,null,null,null,4111,0]
[null,null,null,null,4112,0]
[null,null,null,null,4113,0]
[null,null,null,null,4150,0]
[null,null,null,null,4155,0]
[null,null,null,null,4170,0]
[null,null,null,null,4180,0]
[null,null,null,null,4181,0]
[null,null,null,null,4190,0]
[null,null,null,null,4191,0]
[null,null,null,null,4196,2461]
[null,null,null,null,4197,0]
[null,null,null,null,4198,0]
[null,null,null,null,4199,0]
[null,null,null,null,4310,0]
[null,null,null,null,4311,0]
[null,null,null,null,4315,0]
[null,null,null,null,4330,0]
[null,null,null,null,4350,0]
[null,null,null,null,4370,0]
[null,null,null,null,4390,0]
[null,null,null,null,4410,2249]
[null,null,null,null,4420,0]
[null,null,null,null,4430,0]
[null,null,null,null,4450,0]
[null,null,null,null,4470,0]
[null,null,null,null,4490,0]
[null,null,null,null,4550,0]
[null,null,null,null,4570,0]
[null,null,null,null,4590,0]
[null,null,null,null,4610,0]
[null,null,null,null,4620,0]
[null,null,null,null,4630,0]
[null,null,null,null,4635,414]
[null,null,null,null,4640,0]
[null,null,null,null,4641,0]
[null,null,null,null,4650,{"$f":"IFERROR(VLOOKUP(E132,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,4670,1905]
[null,null,null,null,4671,0]
[null,null,null,null,4690,0]
[null,null,null,null,4710,5717]
[null,null,null,null,4720,0]
[null,null,null,null,4730,7991]
[null,null,null,null,4731,0]
[null,null,null,null,4740,0]
[null,null,null,null,4741,0]
[null,null,null,null,4750,0]
[null,null,null,null,4760,0]
[null,null,null,null,4770,0]
[null,null,null,null,4780,0]
[null,null,null,null,4810,0]
[null,null,null,null,4815,0]
[null,null,null,null,4850,0]
[null,null,null,null,4908,0]
[null,null,null,null,4909,0]
[null,null,null,null,4910,3321]
[null,null,null,null,4911,0]
[null,null,null,null,4912,50817]
[null,null,null,null,4913,0]
[null,null,null,null,4914,0]
[null,null,null,null,4915,0]
[null,null,null,null,4916,0]
[null,null,null,null,4917,183]
[null,null,null,null,4918,0]
[null,null,null,null,4919,0]
[null,null,null,null,4920,0]
[null,null,null,null,4921,1008]
[null,null,null,null,4922,0]
[null,null,null,null,4923,0]
[null,null,null,null,4924,0]
[null,null,null,null,4925,875]
[null,null,null,null,4927,0]
[null,null,null,null,4928,0]
[null,null,null,null,4930,0]
[null,null,null,null,5010,3264]
[null,null,null,null,5011,0]
[null,null,null,null,5030,0]
[null,null,null,null,5110,10844]
[null,null,null,null,5111,0]
[null,null,null,null,5112,0]
[null,null,null,null,5150,0]
[null,null,null,null,5170,0]
[null,null,null,null,5175,0]
[null,null,null,null,5310,3552]
[null,null,null,null,5315,279]
[null,null,null,null,5316,0]
[null,null,null,null,5350,0]
[null,null,null,null,5400,0]
[null,null,null,null,5450,3752]
[null,null,null,null,5510,6034]
[null,null,null,null,5550,2455]
[null,null,null,null,5551,0]
[null,null,null,null,5552,0]
[null,null,null,null,5553,0]
[null,null,null,null,5610,922]
[null,null,null,null,5611,0]
[null,null,null,null,5700,0]
[null,null,null,null,5800,1137]
[null,null,null,null,5801,0]
[null,null,null,null,5803,0]
[null,null,null,null,5804,{"$f":"IFERROR(VLOOKUP(E196,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,5806,3583]
[null,null,null,null,6010,19769]
[null,null,null,null,6011,0]
[null,null,null,null,6050,0]
[null,null,null,null,6100,0]
[null,null,null,null,6150,369]
[null,null,null,null,6210,0]
[null,null,null,null,6250,1365]
[null,null,null,null,6300,2573]
[null,null,null,null,6350,0]
[null,null,null,null,6355,0]
[null,null,null,null,6400,923]
[null,null,null,null,6450,0]
[null,null,null,null,6500,0]
[null,null,null,null,6600,0]
[null,null,null,null,6650,0]
[null,null,null,null,6700,1387]
[null,null,null,null,6730,0]
[null,null,null,null,6731,150]
[null,null,null,null,6750,0]
[null,null,null,null,6755,0]
[null,null,null,null,6780,0]
[null,null,null,null,6800,90]
[null,null,null,null,6830,0]
[null,null,null,null,6870,0]
[null,null,null,null,6900,0]
[null,null,null,null,7300,0]
[null,null,null,null,7320,0]
[null,null,null,null,7400,420]
[null,null,null,null,7450,0]
[null,null,null,null,7500,0]
[null,null,null,null,7800,0]
[null,null,null,null,7850,0]
[null,null,null,null,8000,0]
[null,null,null,null,8020,4890]
[null,null,null,null,8040,0]
[null,null,null,null,8060,511]
[null,null,null,null,8080,0]
[null,null,null,null,1400,8387]
[null,null,null,null,1401,0]
[null,null,null,null,1402,0]
[null,null,null,null,1410,0]
[null,null,null,null,1411,0]
[null,null,null,null,1412,0]
[null,null,null,null,1420,17879]
[null,null,null,null,1421,8158]
[null,null,null,null,1422,0]
[null,null,null,null,1425,0]
[null,null,null,null,1426,0]
[null,null,null,null,1427,0]
[null,null,null,null,1430,-9698]
[null,null,null,null,1431,-4890]
[null,null,null,null,1432,0]
[null,null,null,null,1435,0]
[null,null,null,null,1436,0]
[null,null,null,null,1437,0]
[null,null,null,null,1440,0]
[null,null,null,null,1441,0]
[null,null,null,null,1442,0]
[null,null,null,null,1450,0]
[null,null,null,null,1451,0]
[null,null,null,null,1452,0]
[null,null,null,null,1460,14618]
[null,null,null,null,1461,{"$f":"IFERROR(VLOOKUP(E260,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,1462,0]
[null,null,null,null,1465,0]
[null,null,null,null,1466,0]
[null,null,null,null,1467,0]
[null,null,null,null,1470,-13836]
[null,null,null,null,1471,-511]
[null,null,null,null,1472,0]
[null,null,null,null,1475,0]
[null,null,null,null,1476,0]
[null,null,null,null,1477,0]
[null,null,null,null,1480,0]
[null,null,null,null,1481,0]
[null,null,null,null,1482,0]
[null,null,null,null,1490,0]
[null,null,null,null,1491,0]
[null,null,null,null,1492,0]
[null,null,null,null,1700,0]
[null,null,null,null,1705,0]
[null,null,null,null,1710,0]
[null,null,null,null,1720,2246]
[null,null,null,null,1730,0]
[null,null,null,null,1800,166037]
[null,null,null,null,1801,177]
[null,null,null,null,1802,1109]
[null,null,null,null,1803,3293]
[null,null,null,null,1810,0]
[null,null,null,null,1820,6734]
[null,null,null,null,1850,0]
[null,null,null,null,1870,0]
[null,null,null,null,1900,0]
[null,null,null,null,1950,0]
[null,null,null,null,2100,0]
[null,null,null,null,2105,0]
[null,null,null,null,2150,-10265]
[null,null,null,null,2151,0]
[null,null,null,null,2152,-5910]
[null,null,null,null,2160,0]
[null,null,null,null,2161,0]
[null,null,null,null,2162,0]
[null,null,null,null,2165,0]
[null,null,null,null,2166,0]
[null,null,null,null,2167,0]
[null,null,null,null,2168,0]
[null,null,null,null,2169,0]
[null,null,null,null,2170,0]
[null,null,null,null,2171,-93653]
[null,null,null,null,2172,-2500]
[null,null,null,null,2179,-4920]
[null,null,null,null,2180,0]
[null,null,null,null,2181,{"$f":"IFERROR(VLOOKUP(E310,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,2182,0]
[null,null,null,null,2183,0]
[null,null,null,null,2184,0]
[null,null,null,null,2185,0]
[null,null,null,null,2186,0]
[null,null,null,null,2200,0]
[null,null,null,null,2210,0]
[null,null,null,null,2220,0]
[null,null,null,null,2230,0]
[null,null,null,null,2240,0]
[null,null,null,null,2250,-1743]
[null,null,null,null,2260,-18969]
[null,null,null,null,2270,-16397]
[null,null,null,null,2310,0]
[null,null,null,null,2320,0]
[null,null,null,null,2330,0]
[null,null,null,null,2440,-1845]
[null,null,null,null,2600,0]
[null,null,null,null,2700,0]
[null,null,null,null,2710,-26800]
[null,null,null,null,3900,-22899]
[null,null,null,null,3901,0]
[null,null,null,null,3902,0]
[null,null,null,null,3903,0]
[null,null,null,null,3904,-176297]
[null,null,null,null,3905,0]
[null,null,null,null,3906,11338]
[null,null,null,null,3907,0]
[null,null,null,null,3920,0]
[null,null,null,null,3921,-11263]
[null,null,null,null,3925,0]
[null,null,null,null,3926,6928]
[null,null,null,null,3940,0]
[null,null,null,null,3941,0]
[null,null,null,null,3960,0]
[null,null,null,null,3970,{"$f":"IFERROR(VLOOKUP(E346,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,3990,{"$f":"IFERROR(VLOOKUP(E347,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,3991,{"$f":"IFERROR(VLOOKUP(E348,Import_From_Manual_LT,2,FALSE),0)","v":176297}]
[null,null,null,null,3992,{"$f":"IFERROR(VLOOKUP(E349,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,3995,{"$f":"IFERROR(VLOOKUP(E350,Import_From_Manual_LT,2,FALSE),0)","v":0}]
["Check",{"$f":"SUM(B4:B350)","v":0}]
[]
["Do not enter values beyond row 350"]

{"sheet":"Import Comparisons","index":22,"n_rows":350,"n_cols":6,"rows_kept":350,"cut":false,"hidden":false,"merged":[[1,4,1,18]]}
["Roll No","12345G","Instructions",null,"TB Check",{"$f":"SUM(B4:B350)","v":0}]
["Nominal Code",null,"COMPARISONS ===> See changes to the Chart of Accounts ",null,"Changes to the Chart of Accounts Applicable from September 1st 2022 for the 2023/2024 school accounts"]
["Nominal Code","Final Accounts ","Description"]
[3010,0,"Capitation/Non Pay Budget"]
[3020,0,"DEIS Grant"]
[3021,0,"Early Start Programme Materials/Equipment/Parental Involvement Grant Income"]
[3022,0,"Early Start Programme Capitation "]
[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"]
[3151,0,"Primary Free Schoolbook Grant"]
[3152,0,"Primary Free Schoolbook Admin Grant"]
[3155,0,"School Library Books Capital Grant "]
[3160,0,"Book Rental Scheme Grant"]
[3170,0,"Special Subject Grant"]
[3171,0,"Irish and Bilingual School 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"]
[3282,0,"COVID Enhanced Supervision 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"]
[3288,0,"COVID Capitation for Cleaning and PPE Grant"]
[3289,0,"Once-Off Cost of Living Grant"]
[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"]
[3370,0,"Locker Income"]
[3375,0,"Journals and Year Book Income"]
[3380,0,"Student Photocopying 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"]
[4113,0,"Primary Free Schoolbook Admin 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"]
[4311,0,"Early Start Programme Materials/Equipment/Parental Involvement Expenses"]
[4315,0,"Student Photocopying Expenses"]
[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 Non Grant Funded Expense                                                                                                           "]
[4641,0,"School Library Books Capital Grant 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"]
[4731,0,"Primary Free Schoolbook 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"]
[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"]
[5553,0,"Rent of DE Funded Sports Hall Expenses (C&C only)"]
[5610,0,"Refuse Expense                          "]
[5611,0,"Water Rates Expense"]
[5700,0,"Licence Fee to Patron/Trustee Expense"]
[5800,0,"Other Repairs and Maintenance Expense"]
[5801,0,"COVID Aide Grant Wages Expense"]
[5803,0,"COVID Enhanced Supervision Grant Wages Expense"]
[5804,0,"COVID Capitation for Cleaning Wages Expense"]
[5806,0,"COVID Capitation for Cleaning (Non Wages) and PPE Grant Expense"]
[6010,0,"Clerical Officers/Secretarial Wages Expense"]
[6011,0,"COVID Replacement Secretary Hours Expense"]
[6050,0,"Clerical Officers/Secretarial Pension 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"]
[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 DE Grant Transfer                                                     "]
[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 Cost B/Fwd                                                                                                                      "]
[1401,0,"Capital: Land and Buildings Additions"]
[1402,0,"Capital: Land and Buildings Disposals"]
[1410,0,"Accumulated Depreciation : Land and Buildings B/Fwd                                                    "]
[1411,0,"Depreciation: Land and Buildings Current Year"]
[1412,0,"Depreciation: Land and Buildings on Disposal"]
[1420,0,"Capital: Fixtures, Fittings and Equipment Cost B/Fwd                                                       "]
[1421,0,"Capital: Fixtures, Fittings and Equipment Additions"]
[1422,0,"Capital: Fixtures, Fittings and Equipment Disposals "]
[1425,0,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Cost B/Fwd           "]
[1426,0,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Additions"]
[1427,0,"Capital: Covid Minor Works Fixtures, Fittings and Equipment Disposals"]
[1430,0,"Accumulated Depreciation: Fixtures, Fittings and Equipment B/Fwd                         "]
[1431,0,"Depreciation: Fixtures, Fittings and Equipment Current Year       "]
[1432,0,"Depreciation: Fixtures, Fittings and Equipment Disposal             "]
[1435,0,"Accumulated Depreciation: Covid Minor Works Fixtures, Fittings and Equipment B/Fwd           "]
[1436,0,"Depreciation: Covid Minor Works Fixtures, Fittings and Equipment Current Year "]
[1437,0,"Depreciation: Covid Minor Works Fixtures, Fittings and Equipment Disposal"]
[1440,0,"Capital: Motor Vehicles Cost B/Fwd                                                                                                                                                          "]
[1441,0,"Capital: Motor Vehicles Additions"]
[1442,0,"Capital: Motor Vehicles Disposals"]
[1450,0,"Accumulated Depreciation: Motor Vehicles B/Fwd                                                                                          "]
[1451,0,"Depreciation: Motor Vehicles Current Year "]
[1452,0,"Depreciation: Motor Vehicles Disposal"]
[1460,0,"Capital: ICT Cost B/Fwd                                                                                                                                                                                    "]
[1461,0,"Capital: ICT Additions"]
[1462,0,"Capital: ICT Disposals"]
[1465,0,"Capital: Covid Minor Works ICT Cost B/Fwd                                                                                                        "]
[1466,0,"Capital: Covid Minor Works ICT Additions"]
[1467,0,"Capital: Covid Minor Works ICT Disposals"]
[1470,0,"Accumulated Depreciation: ICT Cost B/Fwd                                                                                                                 "]
[1471,0,"Depreciation: ICT Current Year "]
[1472,0,"Depreciation: ICT Disposal "]
[1475,0,"Accumulated Depreciation: Covid Minor Works ICT B/Fwd                                                               "]
[1476,0,"Depreciation: Covid Minor Works ICT Current Year "]
[1477,0,"Depreciation: Covid Minor Works ICT Disposals"]
[1480,0,"Capital: Other Cost B/Fwd                                                                                                                                                    "]
[1481,0,"Capital: Other Additions"]
[1482,0,"Capital: Other Disposals"]
[1490,0,"Accumulated Depreciation Other Cost B/Fwd                                                                                            "]
[1491,0,"Accumulated Depreciation Other Current Year "]
[1492,0,"Accumulated Depreciation Other Disposals"]
[1700,0,"Sales Ledger Control"]
[1705,0,"Debtors"]
[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"]
[2161,0,"School Library Books Capital Grant Unspent"]
[2162,0,"Early Start Programme Materials/Equipment/Parental Involvement 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"]
[2179,0,"Digital Divide Grant 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"]
[2186,0,"COVID Capitation for Cleaning and PPE Grant 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 Land/Building Fundraising Expense                         "]
[3970,0,"Parents Contribution to Capital Land/Building Expense       "]
[3990,0,"Patron/Trustee Contribution to Capital Building Expense  "]
[3991,0,"Other State Capital Land/Building Expense        "]
[3992,0,"Capital Donations Land/Building Expense   "]
[3995,0,"Land/Building Fund Account          "]

{"sheet":"Import Manual Comparisons","index":23,"n_rows":353,"n_cols":7,"rows_kept":353,"cut":false,"hidden":true,"merged":[]}
["Roll No","01867W",null,null,"Instructions",null,"Do not delete"]
["Nominal Code"]
["Nominal Code","Final Accounts "]
[1400,3121,null,null,3010,{"$f":"IFERROR(VLOOKUP(E4,Import_From_Manual_LT,2,FALSE),0)","v":-15738}]
[1401,5266,null,null,3020,{"$f":"IFERROR(VLOOKUP(E5,Import_From_Manual_LT,2,FALSE),0)","v":-4859}]
[1420,15283,null,null,3021,0]
[1421,2596,null,null,3022,0]
[1430,-6122,null,null,3030,0]
[1431,-3576,null,null,3050,-14878]
[1460,13803,null,null,3100,0]
[1461,815,null,null,3130,0]
[1470,-13019,null,null,3140,0]
[1471,-817,null,null,3150,-1806]
[1720,2363,null,null,3151,0]
[1800,33860,null,null,3152,0]
[1801,2948,null,null,3155,0]
[1802,4293,null,null,3160,0]
[1803,2216,null,null,3170,0]
[1820,2605,null,null,3171,0]
[2150,-7453,null,null,3190,0]
[2165,-1117,null,null,3200,0]
[2166,-4345,null,null,3210,0]
[2171,-10000,null,null,3220,0]
[2250,-1520,null,null,3225,0]
[2440,-923,null,null,3226,0]
[2710,-37691,null,null,3227,0]
[3010,-15738,null,null,3230,-3414]
[3020,-4859,null,null,3240,0]
[3050,-14878,null,null,3245,0]
[3150,-1806,null,null,3255,0]
[3230,-3414,null,null,3260,0]
[3275,-12437,null,null,3270,0]
[3292,-439,null,null,3275,-12437]
[3296,-50793,null,null,3276,0]
[3299,-1476,null,null,3277,0]
[3330,-860,null,null,3280,0]
[3530,-1465,null,null,3282,0]
[3545,-720,null,null,3284,0]
[3550,-607,null,null,3285,0]
[3700,-2075,null,null,3286,0]
[3840,-4762,null,null,3287,0]
[3850,-4488,null,null,3288,0]
[3900,-20520,null,null,3289,0]
[3906,7811,null,null,3290,0]
[3921,-6183,null,null,3292,-439]
[3926,5416,null,null,3293,0]
[4110,760,null,null,3294,0]
[4410,4005,null,null,3295,0]
[4635,290,null,null,3296,-50793]
[4670,365,null,null,3297,0]
[4690,180,null,null,3298,0]
[4710,2497,null,null,3299,-1476]
[4730,1089,null,null,3300,0]
[4910,3554,null,null,3310,0]
[4912,50985,null,null,3330,-860]
[4917,154,null,null,3335,0]
[5010,6988,null,null,3350,0]
[5110,9407,null,null,3370,0]
[5310,3134,null,null,3375,0]
[5315,941,null,null,3380,0]
[5400,180,null,null,3390,0]
[5450,3310,null,null,3395,0]
[5510,3230,null,null,3410,0]
[5550,3014,null,null,3420,0]
[5610,670,null,null,3430,0]
[5800,6321,null,null,3440,0]
[6010,13707,null,null,3450,0]
[6100,700,null,null,3460,{"$f":"IFERROR(VLOOKUP(E68,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[6250,970,null,null,3490,0]
[6300,2126,null,null,3495,0]
[6400,3255,null,null,3500,0]
[6450,1184,null,null,3510,0]
[6700,1130,null,null,3520,0]
[6731,121,null,null,3530,-1465]
[6780,370,null,null,3531,0]
[6800,1555,null,null,3535,0]
[7450,483,null,null,3540,0]
[7800,640,null,null,3545,-720]
[8020,3576,null,null,3550,-607]
[8060,816,null,null,3570,0]
[null,null,null,null,3572,0]
[null,null,null,null,3573,0]
[null,null,null,null,3574,0]
[null,null,null,null,3575,0]
[null,null,null,null,3580,0]
[null,null,null,null,3650,0]
[null,null,null,null,3700,-2075]
[null,null,null,null,3770,0]
[null,null,null,null,3800,0]
[null,null,null,null,3840,-4762]
[null,null,null,null,3850,-4488]
[null,null,null,null,3851,0]
[null,null,null,null,3852,0]
[null,null,null,null,3853,0]
[null,null,null,null,4110,760]
[null,null,null,null,4111,0]
[null,null,null,null,4112,0]
[null,null,null,null,4113,0]
[null,null,null,null,4150,0]
[null,null,null,null,4155,0]
[null,null,null,null,4170,0]
[null,null,null,null,4180,0]
[null,null,null,null,4181,0]
[null,null,null,null,4190,0]
[null,null,null,null,4191,0]
[null,null,null,null,4196,0]
[null,null,null,null,4197,0]
[null,null,null,null,4198,0]
[null,null,null,null,4199,0]
[null,null,null,null,4310,0]
[null,null,null,null,4311,0]
[null,null,null,null,4315,0]
[null,null,null,null,4330,0]
[null,null,null,null,4350,0]
[null,null,null,null,4370,0]
[null,null,null,null,4390,0]
[null,null,null,null,4410,4005]
[null,null,null,null,4420,0]
[null,null,null,null,4430,0]
[null,null,null,null,4450,0]
[null,null,null,null,4470,0]
[null,null,null,null,4490,0]
[null,null,null,null,4550,0]
[null,null,null,null,4570,0]
[null,null,null,null,4590,0]
[null,null,null,null,4610,0]
[null,null,null,null,4620,0]
[null,null,null,null,4630,0]
[null,null,null,null,4635,290]
[null,null,null,null,4640,0]
[null,null,null,null,4641,0]
[null,null,null,null,4650,{"$f":"IFERROR(VLOOKUP(E132,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,4670,365]
[null,null,null,null,4671,0]
[null,null,null,null,4690,180]
[null,null,null,null,4710,2497]
[null,null,null,null,4720,0]
[null,null,null,null,4730,1089]
[null,null,null,null,4731,0]
[null,null,null,null,4740,0]
[null,null,null,null,4741,0]
[null,null,null,null,4750,0]
[null,null,null,null,4760,0]
[null,null,null,null,4770,0]
[null,null,null,null,4780,0]
[null,null,null,null,4810,0]
[null,null,null,null,4815,0]
[null,null,null,null,4850,0]
[null,null,null,null,4908,0]
[null,null,null,null,4909,0]
[null,null,null,null,4910,3554]
[null,null,null,null,4911,0]
[null,null,null,null,4912,50985]
[null,null,null,null,4913,0]
[null,null,null,null,4914,0]
[null,null,null,null,4915,0]
[null,null,null,null,4916,0]
[null,null,null,null,4917,154]
[null,null,null,null,4918,0]
[null,null,null,null,4919,0]
[null,null,null,null,4920,0]
[null,null,null,null,4921,0]
[null,null,null,null,4922,0]
[null,null,null,null,4923,0]
[null,null,null,null,4924,0]
[null,null,null,null,4925,0]
[null,null,null,null,4927,0]
[null,null,null,null,4928,0]
[null,null,null,null,4930,0]
[null,null,null,null,5010,6988]
[null,null,null,null,5011,0]
[null,null,null,null,5030,0]
[null,null,null,null,5110,9407]
[null,null,null,null,5111,0]
[null,null,null,null,5112,0]
[null,null,null,null,5150,0]
[null,null,null,null,5170,0]
[null,null,null,null,5175,0]
[null,null,null,null,5310,3134]
[null,null,null,null,5315,941]
[null,null,null,null,5316,0]
[null,null,null,null,5350,0]
[null,null,null,null,5400,180]
[null,null,null,null,5450,3310]
[null,null,null,null,5510,3230]
[null,null,null,null,5550,3014]
[null,null,null,null,5551,0]
[null,null,null,null,5552,0]
[null,null,null,null,5553,0]
[null,null,null,null,5610,670]
[null,null,null,null,5611,0]
[null,null,null,null,5700,0]
[null,null,null,null,5800,6321]
[null,null,null,null,5801,0]
[null,null,null,null,5803,0]
[null,null,null,null,5804,{"$f":"IFERROR(VLOOKUP(E196,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,5806,0]
[null,null,null,null,6010,13707]
[null,null,null,null,6011,0]
[null,null,null,null,6050,0]
[null,null,null,null,6100,700]
[null,null,null,null,6150,0]
[null,null,null,null,6210,0]
[null,null,null,null,6250,970]
[null,null,null,null,6300,2126]
[null,null,null,null,6350,0]
[null,null,null,null,6355,0]
[null,null,null,null,6400,3255]
[null,null,null,null,6450,1184]
[null,null,null,null,6500,0]
[null,null,null,null,6600,0]
[null,null,null,null,6650,0]
[null,null,null,null,6700,1130]
[null,null,null,null,6730,0]
[null,null,null,null,6731,121]
[null,null,null,null,6750,0]
[null,null,null,null,6755,0]
[null,null,null,null,6780,370]
[null,null,null,null,6800,1555]
[null,null,null,null,6830,0]
[null,null,null,null,6870,0]
[null,null,null,null,6900,0]
[null,null,null,null,7300,0]
[null,null,null,null,7320,0]
[null,null,null,null,7400,0]
[null,null,null,null,7450,483]
[null,null,null,null,7500,0]
[null,null,null,null,7800,640]
[null,null,null,null,7850,0]
[null,null,null,null,8000,0]
[null,null,null,null,8020,3576]
[null,null,null,null,8040,0]
[null,null,null,null,8060,816]
[null,null,null,null,8080,0]
[null,null,null,null,1400,3121]
[null,null,null,null,1401,5266]
[null,null,null,null,1402,0]
[null,null,null,null,1410,0]
[null,null,null,null,1411,0]
[null,null,null,null,1412,0]
[null,null,null,null,1420,15283]
[null,null,null,null,1421,2596]
[null,null,null,null,1422,0]
[null,null,null,null,1425,0]
[null,null,null,null,1426,0]
[null,null,null,null,1427,0]
[null,null,null,null,1430,-6122]
[null,null,null,null,1431,-3576]
[null,null,null,null,1432,0]
[null,null,null,null,1435,0]
[null,null,null,null,1436,0]
[null,null,null,null,1437,0]
[null,null,null,null,1440,0]
[null,null,null,null,1441,0]
[null,null,null,null,1442,0]
[null,null,null,null,1450,0]
[null,null,null,null,1451,0]
[null,null,null,null,1452,0]
[null,null,null,null,1460,13803]
[null,null,null,null,1461,{"$f":"IFERROR(VLOOKUP(E260,Import_From_Manual_LT,2,FALSE),0)","v":815}]
[null,null,null,null,1462,0]
[null,null,null,null,1465,0]
[null,null,null,null,1466,0]
[null,null,null,null,1467,0]
[null,null,null,null,1470,-13019]
[null,null,null,null,1471,-817]
[null,null,null,null,1472,0]
[null,null,null,null,1475,0]
[null,null,null,null,1476,0]
[null,null,null,null,1477,0]
[null,null,null,null,1480,0]
[null,null,null,null,1481,0]
[null,null,null,null,1482,0]
[null,null,null,null,1490,0]
[null,null,null,null,1491,0]
[null,null,null,null,1492,0]
[null,null,null,null,1700,0]
[null,null,null,null,1705,0]
[null,null,null,null,1710,0]
[null,null,null,null,1720,2363]
[null,null,null,null,1730,0]
[null,null,null,null,1800,33860]
[null,null,null,null,1801,2948]
[null,null,null,null,1802,4293]
[null,null,null,null,1803,2216]
[null,null,null,null,1810,0]
[null,null,null,null,1820,2605]
[null,null,null,null,1850,0]
[null,null,null,null,1870,0]
[null,null,null,null,1900,0]
[null,null,null,null,1950,0]
[null,null,null,null,2100,0]
[null,null,null,null,2105,0]
[null,null,null,null,2150,-7453]
[null,null,null,null,2151,0]
[null,null,null,null,2152,0]
[null,null,null,null,2160,0]
[null,null,null,null,2161,0]
[null,null,null,null,2162,0]
[null,null,null,null,2165,-1117]
[null,null,null,null,2166,-4345]
[null,null,null,null,2167,0]
[null,null,null,null,2168,0]
[null,null,null,null,2169,0]
[null,null,null,null,2170,0]
[null,null,null,null,2171,-10000]
[null,null,null,null,2172,0]
[null,null,null,null,2179,0]
[null,null,null,null,2180,0]
[null,null,null,null,2181,{"$f":"IFERROR(VLOOKUP(E310,Import_From_Manual_LT,2,FALSE),0)","v":0}]
[null,null,null,null,2182,0]
[null,null,null,null,2183,0]
[null,null,null,null,2184,0]
[null,null,null,null,2185,0]
[null,null,null,null,2186,0]
[null,null,null,null,2200,0]
[null,null,null,null,2210,0]
[null,null,null,null,2220,0]
[null,null,null,null,2230,0]
[null,null,null,null,2240,0]
[null,null,null,null,2250,-1520]
[null,null,null,null,2260,0]
[null,null,null,null,2270,0]
[null,null,null,null,2310,0]
[null,null,null,null,2320,0]
[null,null,null,null,2330,0]
[null,null,null,null,2440,-923]
[null,null,null,null,2600,0]
[null,null,null,null,2700,0]
[null,null,null,null,2710,-37691]
[null,null,null,null,3900,-20520]
[null,null,null,null,3901,0]
[null,null,null,null,3902,0]
[null,null,null,null,3903,0]
[null,null,null,null,3904,0]
[null,null,null,null,3905,0]
[null,null,null,null,3906,7811]
[null,null,null,null,3907,0]
[null,null,null,null,3920,0]
[null,null,null,null,3921,-6183]
[null,null,null,null,3925,0]
[null,null,null,null,3926,5416]
[null,null,null,null,3940,0]
[null,null,null,null,3941,0]
[null,null,null,null,3960,0]
[null,null,null,null,3970,0]
[null,null,null,null,3990,0]
[null,null,null,null,3991,0]
[null,null,null,null,3992,0]
[null,null,null,null,3995,{"$f":"IFERROR(VLOOKUP(E350,Import_From_Manual_LT,2,FALSE),0)","v":0}]
["Check",{"$f":"SUM(B4:B350)","v":0}]
[]
["Do not enter values beyond row 350"]