{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["1. Instructions","2. Budget Grant Calculation","3. Income & Expenditure Budget","4. Capital Project","Free Book Scheme","Import Budget (delete 25-26)","Import YtoD","Import Inc&Exp"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"1. Instructions","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,3],[14,1,14,10],[18,1,18,10],[7,1,7,4],[9,1,9,4],[11,1,11,4],[13,1,13,11],[16,1,17,10],[19,1,19,10],[35,0,35,12],[36,0,36,12],[25,1,25,10],[31,1,31,10],[33,1,34,10],[29,2,29,4],[22,0,22,10],[23,0,23,10],[26,2,26,4],[27,2,27,4],[28,2,28,4]]}
["INSTRUCTIONS:"]
["How to use Budget Templates"]
[]
["STEP 1:","Click on Enable Editing when prompted "]
[]
["STEP 2:","Save the file to your desktop or to a folder"]
[]
["STEP 3:","Input your School Name: ",null,null,null,"Scoil"]
[]
["STEP 4:","Input School Roll No: ",null,null,null,"12345G"]
[]
["STEP 5:","School Budget Year: ",null,null,null,"24/25"]
[]
["STEP 6:       ","In the open Budget Template click on sheet 2 - Budget Grant Calculation. "]
["STEP 7: ","Fill in your schools’ student numbers in the spaces allocated, this will calculate your school’s grants. The figures entered will link automatically from the Grant Calculation worksheet to sheet 3 - Income and Expenditure, Department and Education Income section.  "]
[]
["STEP 8:    ","Click on Sheet 3 - Income & Expenditure Budget. Corresponding expenses for ringfenced grants are are populated from the matching income amounts "]
[]
["STEP 9:     ","Enter estimates of income and expenditure based on previous years making necessary adjustments of where definite spending or costs have been confirmed, such as inflation, wage increases etc. "]
["STEP 10:","Unspent Brought In - you may want to use a portion of unspent balances. The unspent can be shown by inputting the amount into column E.  The unspent amount will automatically add to the total budget amount in column F "]
["Note as per Governance Manual: Boards' expenditure should not exceed their annual income."]
[]
["Capital expenditure"]
["Capital expenditure is expenditure of a once off nature rather than recurring. The purpose is to acquire an asset or advantage of a lasting nature for the enduring benefit of the school. "]
[]
["STEP 1:"," Identify capital receipts which may be available to finance capital expenditure"]
[null,null,"State grants"]
[null,null,"Fundraising "]
[null,null,"Parents’ contributions"]
[null,null,"Donations"]
[]
["STEP 2:"," Submit proposals to the Board of Management for approval"]
[]
["STEP 3:","All capital expenditure plans must be submitted to the Trustees for final approval or otherwise, in accordance with procedures laid down by them."]
[]
["IF YOU NEED ANY FURTHER ASSISTANCE, PLEASE GO TO WWW.FSSU.IE/TEMPLATES "]
["FOR DETAILED INSTRUCTIONS OR CONTACT US ON 01-9104020"]

{"sheet":"2. Budget Grant Calculation","index":1,"n_rows":102,"n_cols":8,"rows_kept":102,"cut":false,"hidden":false,"merged":[[92,2,92,3],[49,6,49,7],[50,6,50,7],[52,1,52,7],[9,6,9,7],[32,6,32,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[17,6,17,7],[16,6,16,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[48,6,48,7],[36,6,36,7],[37,6,37,7],[40,6,40,7],[42,6,42,7],[43,6,43,7],[39,6,39,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[21,6,21,7],[3,2,3,3],[7,6,7,7],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[6,6,6,7],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[16,1,16,2],[17,1,17,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[26,1,26,2],[38,1,39,1],[28,1,28,2],[34,2,34,3],[29,1,29,2],[32,1,32,2],[27,1,27,2]]}
[null,"Budget Grant Calculation","School Budget Year: ",{"$f":"'1. Instructions'!F12","v":"24/25"}]
[null,null,"School Name: ",{"$f":"'1. Instructions'!F8","v":"Scoil"}]
[null,null,"Roll Number:",{"$f":"'1. Instructions'!F10","v":"12345G"}]
[null,"PLEASE FILL IN THE GREEN BOXES:",null,null,"Defaults","No. of Students","Notes"]
[null,"Overall Pupils Enrolled",null,null,{"$f":"IF(F5=0,0,IF(F5<=60,60,F5))","v":0},0]
[]
[null,"Check 'Enhanced Rates'  to input number of pupils enrolled for Special Schools or approved special classes attached to mainstream schools",null,null,null,null,"Enhanced capitation rates are payable in respect of pupils attending special schools and special classes attached to mainstream schools to assist with the extra costs associated with the running costs of classrooms."]
[]
[null,"Overall Pupils subject to Mainstream Grants Only",null,null,{"$f":"IF(F9<=60,60,F5)-F10","v":60},{"$f":"IF(F5=F10,0,E5-F10)","v":0}]
[null,"Number of Pupils entitled to enhanced rates as per Circular 0038/2020",null,null,null,0,{"$f":"IF(SUM($F$12:$F$33)<>$F$10,\"False\",\"\")","v":""}]
[]
[null,"Visual Impairment Grant",null,null,null,0]
[null,"Hearing Impairment Grant",null,null,null,0]
[null,"Profoundly Deaf Grant",null,null,null,0]
[null,"Mild General Learning Disability Mainstream Schools ",null,null,null,0]
[null,"Mild General Learning Disability Mainstream Schools - 12 years plus",null,null,null,0]
[null,"Mild General Learning Disability Special Schools",null,null,null,0]
[null,"Mild General Learning Disability Special Schools - 12 years plus",null,null,null,0]
[null,"Moderate General Learning Disability ",null,null,null,0]
[null,"Severe / Profound Learning Disability ",null,null,null,0]
[null,"Specific Learning Disability Mainstream",null,null,null,0]
[null,"Specific Learning Disability Mainstream Schools - 12 years plus",null,null,null,0]
[null,"Specific Learning Disability Special Schools",null,null,null,0]
[null,"Specific Learning Disability Special Schools - 12 years plus",null,null,null,0]
[null,"Emotional Disturbance",null,null,null,0]
[null,"Severe Emotional Disturbance",null,null,null,0]
[null,"Physical Disability",null,null,null,0]
[null,"Autism Spectrum Disorder",null,null,null,0]
[null,"Specific Speech & Language Disorder",null,null,null,0]
[null,"Multiple Disabilities",null,null,null,0]
[null,"Traveller Children",null,null,null,0]
[null,"Out of Control",null,null,null,0]
[null,"ASD Early Intervention ",null,null,null,0]
[]
[null,"OTHER DEPARTMENT OF EDUCATION GRANTS","SELECT FROM THE DROP DOWN"]
[null,"DEIS Funding (€ Amount) (Based on Prior Year)",null,null,null,0,"Enter Monetary Amount"]
[null,"Mainstream Schools Ancillary Services Full grant/Reduced grant ","Full Grant Secretary paid by board",null,{"$f":"IF(F5=0,0,IF(F38>0,0,IF(F5<=60,60,IF(F5>500,500,IF(F5>60,F5,IF(F5<500,F5))))))","v":0},{"$f":"IF(F38=0,E37,IF(F38>0,0))","v":0},"minimum enrolment 60, maximum of 500"]
[null,"Special School Ancillary Grant Full Grant/Reduced Grant","Full Grant Secretary paid by board",null,{"$f":"IF(F38>16,16,IF(F38<=16,F38))","v":0},null,"Enter number of teachers, ceiling of 16"]
[null,"Enter Annual salary including Employer PRSI of grant-funded secretary in 21/22. Any queries in relation to the value of grant-funded salary used in the calculation can be sent to secretaryarrears@education.gov.ie"]
[null,null,null,null,null,{"$f":"H93","v":0},"Balance of Ancillary Grant. For queries in respect of ancillary grant funding, contact sdfinfo@education.gov.ie "]
[null,"Free Schoolbook Grant",null,null,{"$f":"IF(F5=0,0,IF(F5<=60,60,IF(F5>60,F5)))","v":0},{"$f":"H81","v":0}]
[null,"Free Schoolbook Admin Grant",null,null,null,{"$f":"H82","v":535.10553000000004}]
[null,"ICT Grant (0039/2024)","Non DEIS",null,{"$f":"F5-F10","v":0},{"$f":"G96+G97","v":2000}]
[null,"Minor Works Grant ",null,null,null,{"$f":"SUM(F5-F10)*18.5+(F10*74)+5500","v":5500}]
[null,"Other Non Capital DE Grants (€ Amount)",null,null,null,0,"Enter Monetary Amount"]
[null,"Standardised Testing Grant ",null,null,null,{"$f":"MAX(140,F5*6)","v":140}]
[null,null,null,null,"DEIS"]
[null,"PROGRAMME GRANTS ",null,null,"Non DEIS"]
[null,"JCSP Pupils",null,null,"Full Grant Secretary paid by board",null,"JCSP Enrolment "]
[null,"Transition Year Pupils",null,null,"Full Grant Secretary moved to DE",null,"TY Enrolment "]
[null,"Leaving Certificate Applied Pupils ",null,null,"Reduced Grant",null,"LCA Enrolment "]
[]
[null,"GREY CELLS CONTAIN FORMULA PLEASE DO NOT OVERTYPE "]
[]
[null,"Capitation",null,null,null,"Rate per student","€","€"]
[null,"Overall Pupils subject to Mainstream Grants Only ",null,null,null,200,{"$f":"MAX(0,F56*F9)","v":0}]
[null,"Visual Impairment Grant",null,null,null,962,{"$f":"F57*F12","v":0}]
[null,"Hearing Impairment Grant",null,null,null,962,0]
[null,"Profoundly Deaf Grant",null,null,null,986,0]
[null,"Mild General Learning Disability Mainstream Schools ",null,null,null,512,0]
[null,"Mild General Learning Disability Mainstream Schools - 12 years plus",null,null,null,763,0]
[null,"Mild General Learning Disability Special Schools",null,null,null,639,0]
[null,"Mild General Learning Disability Special Schools - 12 years plus",null,null,null,962,0]
[null,"Moderate General Learning Disability ",null,null,null,962,0]
[null,"Severe / Profound Learning Disability ",null,null,null,986,0]
[null,"Specific Learning Disability Mainstream",null,null,null,512,0]
[null,"Specific Learning Disability Mainstream Schools - 12 years plus",null,null,null,763,0]
[null,"Specific Learning Disability Special Schools",null,null,null,639,0]
[null,"Specific Learning Disability Special Schools - 12 years plus",null,null,null,962,0]
[null,"Emotional Disturbance",null,null,null,962,0]
[null,"Severe Emotional Disturbance",null,null,null,986,0]
[null,"Physical Disability",null,null,null,962,0]
[null,"Autism Spectrum Disorder",null,null,null,986,0]
[null,"Specific Speech & Language Disorder",null,null,null,962,0]
[null,"Multiple Disabilities",null,null,null,986,0]
[null,"Traveller Children",null,null,null,282,0]
[null,"Out of Control",null,null,null,986,0]
[null,"ASD Early Intervention",null,null,null,986,0]
[null,null,null,null,null,null,null,{"$f":"SUM(G56:G78)","v":0}]
[null,null,null,null,535.10553000000004]
[null,"Free Schoolbook Grant",null,null,713.47,80,{"$f":"SUM(F5*F81)","v":0},{"$f":"G81","v":0}]
[null,"Free Schoolbook Admin Grant (Total Cost inc. ER PRSI @ 11.05%)",null,null,1070.2110600000001,{"$f":"IF(F5<101,E80,IF(F5<301,E81,IF(F5<=600,E82,IF(F5>600,E83))))","v":535.10553000000004},{"$f":"F82","v":535.10553000000004},{"$f":"G82","v":535.10553000000004}]
[null,null,null,null,1248.5795700000001]
[null,"JCSP Grant",null,null,null,60,{"$f":"F84*F49","v":0},{"$f":"G84","v":0}]
[null,"Transition Year Grant ",null,null,null,95,{"$f":"F85*F50","v":0},{"$f":"G85","v":0}]
[null,"Leaving Certificate Applied Grant",null,null,null,151,{"$f":"F86*F51","v":0},{"$f":"G86","v":0}]
[]
[null,"Ancillary Service"]
[null,"Mainstream Schools Full grant (Minimum €10,380, Maximum €86,500)",null,null,{"$f":"IF(OR(C37=\"Full Grant Secretary moved to DE\",C37=\"Full Grant Secretary paid by board\",C38=\"Full Grant Secretary moved to DE\",C38=\"Full Grant Secretary paid by board\"),(E92-C40))","v":0},173,{"$f":"IF(OR(C37=\"Full Grant Secretary moved to DE\",C37=\"Full Grant Secretary paid by board\"),(F89*E37),0)","v":0}]
[null,"Mainstream Schools Reduced grant (Minimum €5,370, Maximum €44,750)",null,null,0,89.5,{"$f":"IF(C37=\"Reduced Grant\",(F90*E37),0)","v":0}]
[null,"Special School Ancillary Grant Full grant (Maximum grant is paid based on a ceiling of 16 teachers)",null,null,null,null,{"$f":"IF(OR(C38=\"Full Grant Secretary moved to DE\",C38=\"Full Grant Secretary paid by board\"),SUMIF(No_of_Teachers,E38,SpecSch_Full_Grant),0)","v":0}]
[null,"Special School Ancillary Grant Reduced grant (Maximum grant is paid based on a ceiling of 16 teachers)",null,null,{"$f":"SUM(G89:G92)","v":0},null,{"$f":"IF(C38=\"Reduced Grant\",SUMIF(No_of_Teachers,E38,SpecSch_Reduced_Grant),0)","v":0}]
[null,null,"(final adjusted ancillary services grant)",null,null,null,null,{"$f":"IF(E89>=0,G89+G90+G91+G92-C40,E90)","v":0}]
[]
[null,"DEIS Funding (€ Amount) (Based on Prior Year)",null,null,null,null,{"$f":"F36","v":0},{"$f":"G95","v":0}]
[null,"ICT Grant Non Deis (€2000 + €39.73 mainstream pupil and €47.67 special classes)",null,null,null,39.729999999999997,{"$f":"IF(C43=\"Non DEIS\",E43*39.73+(F10*47.67)+2000,0)","v":2000},2000]
[null,"ICT Grant Deis  (€2000 + €43.70 mainstream pupil and €47.67 special classes)",null,null,null,43.7,{"$f":"IF(C43=\"DEIS\",E43*43.7+(F10*47.67)+2000,0)","v":0},0]
[null,"Minor Works Grant - Non Capital (€5500 + €18.50 mainstream pupil and €74.00 special classes)",null,null,null,null,{"$f":"F44","v":5500},5500]
[null,"Other Non Capital DE Grants (€ Amount)",null,null,null,null,{"$f":"F45","v":0},0]
[null,"Standardised Testing Grant (€6.00 per pupil minimum €140 per school)",null,null,null,null,{"$f":"F46","v":140},140]
[]
[null,"TOTAL GRANTS",null,null,null,null,null,{"$f":"SUM(H79:H101)","v":8175.1055299999998}]

{"sheet":"3. Income & Expenditure Budget","index":2,"n_rows":211,"n_cols":500,"rows_kept":211,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[1,1,1,5],[2,5,5,5],[2,4,5,4]]}
[null,null,null,null,null,null,"Import from FSSU Monthly Template Year to Date 23-24- >>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Income & Expenditure Budget"]
[null,"School Budget ",null,{"$f":"'1. Instructions'!F12","v":"24/25"},"Unspent Income and Ringfenced grants brought forward from prior year","Total Budget (including balance unspent brought forward) "]
[null,{"$f":"'1. Instructions'!F8","v":"Scoil"},null,{"$f":"'1. Instructions'!F10","v":"12345G"}]
[null,null,"INCOME",null,"Unspent "]
[null,null,"DEPARTMENT OF EDUCATION INCOME","Notes","Brought In ",null,"Import ","Guide"]
[null,3010,"Capitation/Non Pay Budget",null,null,{"$f":"'2. Budget Grant Calculation'!H79","v":0},null,"Grant calculated based on formula","f",{"$f":"IF(AND(F7=0,G7=0),\"N\",\"Y\")","v":"N"}]
[null,3020,"DEIS Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H95+E8","v":0},null,"Grant calculated based on formula (DEIS school only)","f",{"$f":"IF(AND(F8=0,G8=0),\"N\",\"Y\")","v":"N"}]
[null,3021,"Early Start Programme Mat/Equip/Par Inv Grant",null,null,null,null,"Applies to schools with the Early Start pre-school programme",null,"N"]
[null,3022,"Early Start Programme Capitation",null,null,null,null,"Applies to schools with the Early Start pre-school programme","f","N"]
[null,3050,"Ancillary/School Support Services Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H93","v":0},null,"Grant calculated based on formula","f","N"]
[null,3140,"Special Education Equipment Grant",null,null,null,null,"If applicable provide for grant requested for equipment for a specific pupil e.g. assitive technology grant, special table/chair for pupil with special needs",null,"N"]
[null,3151,"Free Schoolbook Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H81+E13","v":0},null,"Grant calculated based on formula","f","N"]
[null,3152,"Free Schoolbook Admin Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H82+E14","v":535.10553000000004},null,"Grant calculated based on formula","f","Y"]
[null,3155,"School Library/Literacy Resource Grant ",null,null,null,null,"Provide for unspent grant balance here, if plan is to spend it in this year",null,"N"]
[null,3170,"Special Subject Grant",null,null,null,null,null,"f","N"]
[null,3171,"Irish & Bilingual School Grant",null,null,null,null,null,"f","N"]
[null,3190,"JCSP Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H84","v":0},null,"Grant calculated based on formula","f","N"]
[null,3200,"Transition Year Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H85","v":0},null,"Grant calculated based on formula","f","N"]
[null,3210,"Leaving Certificate Applied Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H86","v":0},null,"Grant calculated based on formula","f","N"]
[null,3230,"ICT Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H96+'2. Budget Grant Calculation'!H97+E21","v":2000},null,"Grant calculated based on formula","f","Y"]
[null,3260,"School Excellence Fund Income",null,null,null,null,"Only applies to school's in school excellence programme",null,"N"]
[null,3275,"Minor Works Grant-Non Capital",null,null,{"$f":"'2. Budget Grant Calculation'!H98+E23","v":5500},null,"Grant calculated based on formula","f","Y"]
[null,3276,"Temporary Accommodation Grant Income",null,null,null,null,"Only applies to school in receipt of a temporary accommodation grant for prefab/temporary accommodation",null,"N"]
[null,3289,"Once-Off Cost of Living Grant",null,null,null,null,"Do not provide for cost of living grant as this was only paid in 2023 & 2024 due to cost of living crisis ","f","N"]
[null,3290,"Other Non Capital DE Grant Income",null,null,{"$f":"'2. Budget Grant Calculation'!H99+E26","v":0},null,"Other DE grants not listed in Chart of Accounts (COA)","f","N"]
[null,3292,"Standardised Testing Grant",null,null,{"$f":"'2. Budget Grant Calculation'!H100+E27","v":140},null,"Grant calculated based on formula","f","Y"]
[null,3293,"Summer Provision Grant",null,null,null,null,"Applies to school's that intend to run the summer provision programme. Base grant amount of what was receive in prior year","f","N"]
[null,3294,"Bus Escort Grant",null,null,null,null,"Enter estimate of grant to employee a bus escort. Based on bus escort gross wages plus ER PRSI.",null,"N"]
[null,null,"TOTAL DEPARTMENT OF INCOME",null,null,{"$f":"SUM(F7:F29)","v":8175.1055299999998},null,null,"f"]
[null,null,"OTHER STATE INCOME",null," ",null,null,null,"f"]
[null,3295,"Department of Children and Youth Affairs Income",null,null,null,null,"If applicable, enter grant amount based on previous year if it is a recurring grant",null,{"$f":"IF(AND(F32=0,G32=0),\"N\",\"Y\")","v":"N"}]
[null,3296,"DSP School Meals Grant",null,null,null,null,"If applicable, enter grant amount based on previous year if it is a recurring grant",null,{"$f":"IF(AND(F33=0,G33=0),\"N\",\"Y\")","v":"N"}]
[null,3297,"Erasmus Income",null,null,null,null,"If applicable, enter grant amount based on previous year if it is a recurring grant",null,"N"]
[null,3298,"HSE Funding",null,null,null,null,"If applicable, enter grant amount based on previous year if it is a recurring grant",null,"N"]
[null,3299,"Other State Funding",null,null,null,null,"If applicable, enter grant amount based on previous year if it is a recurring grant (includes funding from PPLI, County Council, Art Council)",null,"N"]
[null,null,"TOTAL OTHER STATE INCOME",null,null,{"$f":"SUM(F32:F36)","v":0},null,null,"f"]
[null,null,"SCHOOL GENERATED INCOME",null," ",null,null,null,"f"]
[null,3300,"Education Fees (Fee paying schools)",null,null,null,null,"Education Fee charge by Private Fee paying school only","f",{"$f":"IF(AND(F39=0,G39=0),\"N\",\"Y\")","v":"N"}]
[null,3310,"Transition Year Income",null,null,null,null,"Enter budget amount: based on TY charge for the year times estimated number of TY pupils","f",{"$f":"IF(AND(F40=0,G40=0),\"N\",\"Y\")","v":"N"}]
[null,3335,"Classroom Books/Resources Income",null,null,null,null,"Monies collected by teachers from students for classroom books/resources. Money out accounted for in code 4741","f","N"]
[null,3350,"Hire of Facilities Rental Income",null,null,null,null,"Estimate based on previous year income for rental of school facilities. Include income received from a canteen provider","f","N"]
[null,3370,"Locker Income",null,null,null,null,"Enter budget amount: based on locker charge for the year times estimated number of pupils","f","N"]
[null,3375,"Journals and Year Book Income",null,null,null,null,"Enter budget amount: based on journals charge for the year times estimated number of pupils","f","N"]
[null,3380,"Student Photocopying Income",null,null,null,null,"Enter budget amount: based on student photocopying charge for the year times estimated number of pupils","f","N"]
[null,3390,"School Administration Charges",null,null,null,null,"Enter budget amount: based on school administration charge for the year times estimated number of pupils","f","N"]
[null,3410,"Adult Education Income",null,null,null,null,"If the school runs an adult education programme, enter the esimtated income ","f","N"]
[null,3420,"Canteen Income",null,null,null,null,"Estimated income generated from a school ran canteen. If a canteen is outsourced the rental income should be posted to code 3350","f","N"]
[null,3430,"Tuck Shop Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3440,"Uniforms Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3450,"Religion/Ethos Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3490,"After School Study/Club Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3500,"Games Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3510,"Bus Hire for Games Income",null,null,null,null,"Estimate income collected based on prior year. Corresponding expense code is 4671","f","N"]
[null,3511,"Bus Hire Other Income",null,null,null,null,"Estimate income collected based on prior year. Corresponding expense code is 4690","f","N"]
[null,3520,"School Musical/Drama Income",null,null,null,null,"Estimate income generated from a school musical/drama ","f","N"]
[null,3530,"School Tours Income",null,null,null,null,"Estimate income collected based on prior year (this should not include income for a foreign school tour)","f","N"]
[null,3531,"School Swimming Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3535,"Student Insurance Income",null,null,null,null,"Enter budget amount: based on student insurance charge for the year times estimated number of pupils","f","N"]
[null,3540,"Pre-School Income",null,null,null,null,"If applicable, pre-school income only","f","N"]
[null,3545,"Summer Camps Income",null,null,null,null,"Estimate based on prior year, if school runs a summer camp","f","N"]
[null,3550,"Reimbursable Income",null,null,null,null,"Estimate income collected based on prior year. This is money that is collected by the school and paid on directly in a short period of time. This should exactly match your reimbursable expense.","f","N"]
[null,3570,"Other School Generated Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3572,"School Arts and Crafts Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3573,"School Dance Income",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3574,"Restricted School Fundraising (Non Capital)",null,null,null,null,"Enter budget amount for planned restricted school fundraising for non capital purposes",null,"N"]
[null,3575,"Unrestricted School Fundraising (Non Capital)",null,null,null,null,"Enter budget amount for planned unrestricted school fundraising for non capital purposes","f","N"]
[null,3580,"Discounts Given",null,null,null,null,"Estimate based on previous year   ","f","N"]
[null,null,"TOTAL SCHOOL GENERATED INCOME",null,null,{"$f":"SUM(F39:F68)","v":0},null,null,"f","N"]
[null,null,"OTHER INCOME",null," ",null,null,null,"f","N"]
[null,3650,"Voluntary Contributions",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3700,"Income from Parents Association",null,null,null,null,"Estimate income collected based on prior year","f","N"]
[null,3770,"Insurance Claim Income",null,null,null,null,"If applicable and amount is known of insurance claim","f","N"]
[null,3800,"Bank Interest Received",null,null,null,null,"Estimate based on prior year","f","N"]
[null,3850,"Other Income",null,null,null,null,"Estimate based on prior year","f","N"]
[null,3851,"Designated Income (Non Capital)",null,null,null,null,"Donations received or surplus funds set aside for non-capital specific purposes",null,"N"]
[null,3852,"Restricted External Fundraising (Non Capital)",null,null,null,null,"Enter budget amount for planned restricted external fundraising for non capital purposes",null,"N"]
[null,3853,"Unrestricted External Fundraising (Non Capital)",null,null,null,null,"Enter budget amount for planned unrestricted external fundraising for non capital purposes",null,"N"]
[null,null,"TOTAL OTHER INCOME",null,null,{"$f":"SUM(F71:F78)","v":0},null,null,"f"]
[null,null,"TOTAL INCOME",null,null,{"$f":"F79+F37+F69+F30","v":8175.1055299999998},null,null,"f"]
[null,null,"",null," ",null,null,null,"f"]
[null,null,"EXPENDITURE",null," "]
[null,null,"EDUCATION SALARIES",null," "]
[null,4110,"Substitute Teachers Expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI where the board privately pays sub teachers",null,{"$f":"IF(AND(F84=0,G84=0),\"N\",\"Y\")","v":"N"}]
[null,4111,"Privately Paid Teachers Expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI where the board privately pays teachers",null,{"$f":"IF(AND(F85=0,G85=0),\"N\",\"Y\")","v":"N"}]
[null,4113,"Free Schoolbook Admin Salaries Expense",null,{"$f":"E14","v":0},{"$f":"F14","v":535.10553000000004},null,"Expenditure must match income in code 3152",null,"Y"]
[null,4150,"Supervision and Substitution Salaries Expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI ",null,"N"]
[null,4170,"Adult Education Salaries Expense",null,null,null,null,"Estimate amount based on gross wages plus ER PRSI ",null,"N"]
[null,4181,"Canteen Salaries Expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI ",null,"N"]
[null,4190,"After School Study/Club Salaries Expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI ",null,"N"]
[null,4191,"Summer Camps Salaries Expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI ",null,"N"]
[null,4196,"Bus Escort Salary Expense",null,{"$f":"E29","v":0},{"$f":"SUM(F29)","v":0},null,"Expenditure must match income in code 3294",null,"N"]
[null,4198,"Other Educational salaries expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI ",null,"N"]
[null,4199,"HSE Funded Salaries Expense",null," ",null,null,"Estimate amount based on gross wages plus ER PRSI ",null,"N"]
[null,null,"TOTAL EDUCATION SALARIES COSTS",null,null,{"$f":"SUM(F84:F94)","v":535.10553000000004}]
[null,null,"EDUCATION OTHER",null," "]
[null,4310,"Teaching Aids Expense",null,null,null,null,"Estimate amount based on previous year excluding once off purchases. Example of expenses under this heading is posters, diagrams or maps for the classroom wall, educational videos, puzzles, special tools that teachers use to enhance learning and teaching.",null,{"$f":"IF(AND(F97=0,G97=0),\"N\",\"Y\")","v":"N"}]
[null,4311,"Early Start Programme Mat/Equip/Par Inv Expenses",null,{"$f":"E9","v":0},{"$f":"F9","v":0},null,"Expenditure must match income in code 3021",null,{"$f":"IF(AND(F98=0,G98=0),\"N\",\"Y\")","v":"N"}]
[null,4315,"Student Photocopying Expenses",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4330,"Religion/Ethos Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4410,"ICT Grant Expense",null,{"$f":"E21","v":0},{"$f":"F21","v":2000},null,"Expenditure must match income in code 3230",null,"Y"]
[null,4420,"Computer Maintenance & Support Expense",null,null,null,null,"Estimate based on previous year. Expense not covered under the ICT grant for e.g. maintenance and support contract, website costs",null,"N"]
[null,4490,"Other Subjects Expense",null,null,null,null,"Estimate based on previous year. Other subject includes expenses incurred by Maths, Irish, History, Geography etc.",null,"N"]
[null,4550,"Leaving Cert Applied Expense",null,null,null,null,"Expenditure must match income in code 3210",null,"N"]
[null,4570,"LCVP Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4590,"Transition Year Expense",null,null,null,null,"Expenditure must match income in code 3200 & income in code 3310",null,"N"]
[null,4610,"Learning Support Expense",null,null,null,null,"Estimate based on previous year. Example of expenses under this heading is items purchased by the SEN department, literacy aids, fine and gross motor skills aids",null,"N"]
[null,4620,"Teacher Inservice and Training Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4635,"Student Wellbeing Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4640,"Library Non-Grant Funded Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4641,"School Library/Literacy Resource Grant Expense",null,{"$f":"E15","v":0},{"$f":"F15","v":0},null,"Expenditure must match income in code 3155",null,"N"]
[null,4650,"Physical Education Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4670,"Games (excl. travel) Expense",null,null,null,null,"Estimate based on previous year. Example of expenses under this heading are referee payments, sports membership/affiliation fees.",null,"N"]
[null,4671,"Travel Games Expense",null,null,null,null,"Estimate based on previous year expense. Corresponding income code is 3510",null,"N"]
[null,4690,"Bus Hire Expense",null,null,null,null,"Estimate based on previous year expense. Corresponding income code is 3511",null,"N"]
[null,4710,"School Tours Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4720,"School Musical/Drama Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4731,"Free Book Grant Expense",null,{"$f":"E13","v":0},{"$f":"F13","v":0},null,"Expenditure must match income in code 3151",null,"N"]
[null,4741,"Classroom Books/Resources Expense",null,null,null,null,"Estimate based on previous year expense. Corresponding income code is 3335",null,"N"]
[null,4760,"School Yearbook/Journal Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4770,"Trophies and Prizes Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4780,"Uniform Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4810,"Home School Liaison Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4815,"School Excellence Fund Expense",null,{"$f":"E22","v":0},{"$f":"F22","v":0},null,"Expenditure must match income in code 3260",null,"N"]
[null,4908,"Other Summer Camps Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4909,"Other Summer Provision Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4910,"Other Educational Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4911,"Department of Children and Youth Affairs Activities Expense",null,{"$f":"E32","v":0},0,null,"Expenditure must match income in code 3295",null,"N"]
[null,4912,"DSP School Meals Food Costs",null,0,0,null,"Expenditure must match income in code 3296",null,"N"]
[null,4913,"Erasmus Expense",null,0,0,null,"Expenditure must match income in code 3297",null,"N"]
[null,4914,"Other Non Capital DE Grants Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4915,"Other Canteen Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4916,"Student Insurance Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4917,"Standardised Testing Expense",null,{"$f":"E27","v":0},{"$f":"F27","v":140},null,"Matched to grant receipt in 3292",null,"Y"]
[null,4918,"Designated Expenditure (Non Capital)",null,{"$f":"E76","v":0},{"$f":"F76","v":0},null,"Expenditure must match income in code 3851",null,"N"]
[null,4919,"Special Educational Equipment (Non Capital) Expense",null,{"$f":"E12","v":0},{"$f":"F12","v":0},null,"Expenditure must match income in code 3140",null,"N"]
[null,4920,"School Dance Expense",null,null,null,null,"Estimate based on previous year - primarily used by primary schools",null,"N"]
[null,4921,"School Swimming Expense",null,null,null,null,"Estimate based on previous year - primarily used by primary schools",null,"N"]
[null,4922,"Restricted School Fundraising Expenses (Non Capital)",null,{"$f":"E66","v":0},{"$f":"F66","v":0},null,"Expenditure must match income in code 3574",null,"N"]
[null,4923,"Restricted External Fundraising Expenses (Non Capital)",null,{"$f":"E77","v":0},{"$f":"F77","v":0},null,"Expenditure must match income in code 3852",null,"N"]
[null,4924,"Unrestricted External Fundraising Expenses (Non Capital)",null,{"$f":"E78","v":0},{"$f":"F78","v":0},null,"Expenditure must match income in code 3853",null,"N"]
[null,4925,"Unrestricted School Fundraising Expenses (Non Capital)",null,null,null,null,"Estimate based on previous year expense. Corresponding income code is 3575",null,"N"]
[null,4927,"School Arts and Crafts Expense",null,null,null,null,"Estimate based on previous year ",null,"N"]
[null,4928,"Other HSE Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,4929,"Other State Funding Expense",null,{"$f":"E36","v":0},{"$f":"F36","v":0},null,"Expenditure must match income in code 3299",null,"N"]
[null,4930,"Pre-School Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,null,"TOTAL EDUCATION OTHER COSTS",null,null,{"$f":"SUM(F97:F146)","v":2140}]
[null,null,"REPAIRS, MAINTENANCE & ESTABLISHMENT",null," "]
[null,5010,"Caretaker Wages Expense",null,null,null,null,"Gross wage plus employers PRSI",null,{"$f":"IF(AND(F149=0,G149=0),\"N\",\"Y\")","v":"N"}]
[null,5030,"Caretaker Pension Expense",null,null,null,null,"Enter amount where the board approved the payment of a private employer pension contribution",null,{"$f":"IF(AND(F150=0,G150=0),\"N\",\"Y\")","v":"N"}]
[null,5110,"Cleaners Wages Expense",null,null,null,null,"Gross wage plus employers PRSI",null,"N"]
[null,5112,"Cleaners' Pension Expense",null,null,null,null,"Enter amount where the board approved the payment of a private employer pension contribution",null,"N"]
[null,5150,"Contract Cleaners Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5170,"Cleaning Materials Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5175,"Other Cleaning and Sanitation Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5310,"Repairs to Buildings and Grounds Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5315,"Minor Works Grant (Non Capital) Expense",null,{"$f":"E23","v":0},{"$f":"F23","v":5500},null,"Expenditure must match income in code 3275",null,"Y"]
[null,5350,"Repairs to Furniture, Fittings and Equipment Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5400,"Routine Security Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5450,"General Insurance Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5510,"Heating Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5550,"Light and Power Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5551,"Rent of Temporary Accommodation Expense",null,{"$f":"E24","v":0},{"$f":"F24","v":0},null,"Expenditure must match income in code 3276",null,"N"]
[null,5552,"Other Rental Costs Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5610,"Refuse Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5611,"Water Rates Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5700,"Licence Fee to Patron/Trustee Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,5800,"Other Repairs and Maintenance Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,null,"TOTAL REPAIRS, MAINTENANCE & ESTABLISHMENT COSTS",null,null,{"$f":"SUM(F149:F168)","v":5500}]
[null,null,"ADMINISTRATION",null," "]
[null,6010,"Clerical Officers/Secretarial Wages Expense",null,null,null,null,"Gross wages plus employers PRSI",null,{"$f":"IF(AND(F171=0,G171=0),\"N\",\"Y\")","v":"N"}]
[null,6050,"Clerical Officers/Secretarial Pension Expense",null,null,null,null,"Enter amount where the board approved the payment of a private employer pension contribution",null,"N"]
[null,6100,"Recruitment Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6150,"Advertising / Public Relations Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6210,"Postage Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6250,"Telephone Expense / SMS Text",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6300,"Printing and Stationery Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6350,"Office Equipment (Non Capital) Expense",null,null,null,null,"Estimate based on previous year. Example of expenses under this heading are, small office printer, shredder, laminator etc (< agreed capital materiality level)",null,"N"]
[null,6355,"Non-ICT Grant Funded Office Computers Expense",null,null,null,null,"Estimate based on previous year. Examples of expenses under this heading are, ink cartidges, keyboard, mouse, external hard drive (< agreed capital materiality level)",null,"N"]
[null,6400,"Accounting / Auditing Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6450,"Other Professional Fees Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6500,"Travel and Subsistence Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6600,"Principals Expenses",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6650,"Board of Management Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6700,"Annual Subscriptions Expense",null,null,null,null,"Estimate based on previous year. Example of expenses under this heading are Management body subscriptions, TV license etc ",null,"N"]
[null,6730,"InSchool Administration System Expense",null,null,null,null,"Estimate based on previous year. Example of expenses under this heading are VS Ware, Compass, Capterra, MIS, Aladdin",null,"N"]
[null,6731,"Accounting Software/Payroll Software Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6750,"Donations to Charity",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6755,"Medical and First Aid Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6780,"Staff Room Expenses",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6800,"Hospitality Expense",null,null,null,null,"Estimate based on previous year. Example catering expense for open night.",null,"N"]
[null,6830,"Tuck Shop Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,6900,"Other Administration Expenses",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,null,"TOTAL ADMINISTRATION COSTS",null,null,{"$f":"SUM(F171:F193)","v":0}]
[null,null,"FINANCIAL",null," "]
[null,7300,"Leasing Expenses",null,null,null,null,"Estimate based on previous year - photocopier leasing charge.",null,{"$f":"IF(AND(F196=0,G196=0),\"N\",\"Y\")","v":"N"}]
[null,7320,"Loan Charges Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,7400,"Bank Interest Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,7450,"Bank Charges Expense",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,7800,"Reimbursable Expenses",null,null,0,null,"Expenditure must match income in code 3550",null,"N"]
[null,7850,"Discounts Received",null,null,null,null,"Estimate based on previous year",null,"N"]
[null,null,"TOTAL FINANCE COSTS",null,null,{"$f":"SUM(F196:F201)","v":0}]
[null,null,"CONTINGENCY SPEND 5%",null,null,{"$f":"(F202+F194+F169+F147+F95)*0.05","v":408.75527650000004},null,"This is set at 5% of overall expenditure"]
[null,null,"TOTAL  EXPENDITURE",null,null,{"$f":"F202+F194+F169+F147+F95+F203","v":8583.8608065000008}]
[null,null,"SURPLUS/ (DEFICIT)",null,null,{"$f":"F80-F204","v":-408.75527650000095},null,"School's are not premitted to have a deficit"]
[]
[null,null,0,0,0]
[null,null,"Reviewed By Treasurer of the Board of Management:","Reviewed By Chairperson of the Board of Management:"]
[null,null,"Date:  ____________________________________","Date:  ____________________________________"]
[null,null,"Signed: ___________________________________","Signed: ___________________________________"]
[null,null,0]

{"sheet":"4. Capital Project","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Capital Project (where applicable, e.g. Building Project, IT)"]
[null,{"$f":"'2. Budget Grant Calculation'!C1","v":"School Budget Year: "},{"$f":"'1. Instructions'!F12","v":"24/25"}]
[null,{"$f":"'1. Instructions'!F8","v":"Scoil"},{"$f":"'1. Instructions'!F10","v":"12345G"}]
[]
[null,"Capital Project  ","Estimated Cost"]
["A","Proposed Capital Expenditure:"]
[]
[null,"  New buildings, extensions, major refurbishment  (Specify)",0]
[]
[null,"  Furniture, Fittings and Equipment  (Specify)",0]
[null,null," "]
[null,"  Computer Equipment  (Specify)",0]
[]
[null,"Total Capital Expenditure                                                 A",{"$f":"SUM(C8:C13)","v":0}]
[]
["B."]
[null,"Funding to finance Capital Expenditure:"]
[]
[null,"Department of Education",0]
[null," ",null,null,null,"                                                                                                                                                                                                                     "]
[null,"School Contribution",0]
[]
[null,"Parents’ Contribution.",0]
[]
[null,"Patron/(Trustees where applicable) Contribution",0]
[]
[null,"Fundraising",0]
[]
[null,"Other",0]
[]
[null,"Total Capital Funding                                                        B",{"$f":"SUM(C19:C30)","v":0}]
[]
[null,"Surplus (Deficit)   B-A",{"$f":"C31-C14","v":0}]

{"sheet":"Free Book Scheme","index":4,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,1,1,4],[4,1,4,2],[14,1,14,3],[8,1,8,4],[11,1,11,4]]}
[]
[null,"Free Book Scheme "]
[null,"The per capita funding to be provided is as follows; "]
[null,"Rate per capita €80 (all primary schools and special schools)"]
[null,"Rate per capita"]
[null,"Mainstream",80]
[null,"Special Class",80]
[]
[null,"Payment of Grant\nThe book grant will be paid to schools in April 2024 so that schools will have the necessary funding in place to implement the scheme in advance of the commencement of the 2024/24 school year.The grant will be calculated based on validated September 2023 enrolment figures. \n\nDeveloping Schools\nWhen developing schools have provided the Department with projected September 2024 enrolment data, and where this enrolment projection shows an increase from the validated enrolment of September 2023, a “top up” book grant payment will issue\n\nExceptional Circumstances \nIn certain circumstances where a school enrolsa number of new pupils after 30thSeptember 2024 and where funding was not originally allocated to take account of these pupils,the school may contact the Department to make an application for additional funding. \n"]
[]
[]
[null,"Administration Support Grant\nThis grant can be used to employ an individual to work for a specified number of days from April through to August 2024 to carry out administrative work on the scheme. The daily rate sanctioned by the Department for this work is €160.62 which includes holiday pay.The Department will provide an additional 11.05% to cover the employer PRSI cost. The payment must be dealt with by the school as payment of an individual(s)/employee(s).\n\nAlthough the rate is based on a daily rate, schools have the autonomy to use the equivalent hours (as shown below) over the course of the months leading up to the start of the school year as they consider most suitable for their needs."]
[]
[null,"The number of days allocated are based on the enrolment size of the school and are as follows"]
[]
[null,"Size of School (enrolment September 2022)","No. of days","Total Cost inc. ER PRSI @ 11.05%"]
[null,"0-100",3,{"$f":"SUM(160.62*1.1105)*C17","v":535.10553000000004}]
[null,"101-300",4,{"$f":"SUM(160.62*1.1105)*C18","v":713.47404000000006}]
[null,"301-599",6,{"$f":"SUM(160.62*1.1105)*C19","v":1070.2110600000001}]
[null,">600",7,{"$f":"SUM(160.62*1.1105)*C20","v":1248.5795700000001}]

{"sheet":"Import Budget (delete 25-26)","index":5,"n_rows":175,"n_cols":11,"rows_kept":175,"cut":false,"hidden":true,"merged":[[1,7,2,14],[1,1,1,5],[2,1,2,2],[3,1,3,2]]}
[]
[null,"Import into Monthly Reporting Template",null,null,null,null,null,"Special schools are paid the Ancillary Services Grant based on the number of\nauthorised fulltime teaching staff approved by the Department for the school as\noutlined below. "]
[null,"School Budget ",null,{"$f":"'1. Instructions'!F12","v":"24/25"}]
[null,{"$f":"'1. Instructions'!F8","v":"Scoil"},null,null,{"$f":"'1. Instructions'!F10","v":"12345G"}]
[null,null,"INCOME",null,null,"NOTE:",null,null,"No of Teachers","SpecSch_Full Grant ","SpecSch_Reduced Grant"]
[null,null,"DEPARTMENTOF EDUCATION AND SKILLS INCOME",null,null,null,null,null,1,12660,6510]
[null,3010,"Capitation/Non Pay Budget",null,null,{"$f":"'3. Income & Expenditure Budget'!F7","v":0},null,null,2,13082,6727]
[null,3020,"DEIS Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F8","v":0},null,null,3,20256,10416]
[null,3021,"Early Start Scheme Mat/Equip/Par Dev Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F9","v":0},null,null,4,27430,14105]
[null,3022,"Early Start Scheme Capitation",null,null,{"$f":"'3. Income & Expenditure Budget'!F10","v":0},null,null,5,34604,17794]
[null,3050,"Ancillary/School Support Services Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F11","v":0},null,null,6,41567,21374.5]
[null,3140,"Special Education Equipment Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F12","v":0},null,null,7,48108,24738]
[null,3151,"Free Book Scheme Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F13","v":0},null,null,8,54438,27993]
[null,3155,"School Library Books Capital Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F15","v":0},null,null,9,57392,29512]
[null,3170,"Special Subject Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F16","v":0},null,null,10,64355,33092.5]
[null,3171,"Irish & Bilingual School Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F17","v":0},null,null,11,71318,36673]
[null,3190,"JCSP Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F18","v":0},null,null,12,78281,40253.5]
[null,3200,"Transition Year Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F19","v":0},null,null,13,85244,43834]
[null,3210,"Leaving Certificate Applied Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F20","v":0},null,null,14,92207,47414.5]
[null,3230,"ICT Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F21","v":2000},null,null,15,99170,50995]
[null,3260,"School Excellence Fund Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F22","v":0},null,null,16,105500,54250]
[null,3275,"Minor Works Grant-Non Capital",null,null,{"$f":"'3. Income & Expenditure Budget'!F23","v":5500}]
[null,3276,"Temporary Accommodation Grant Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F24","v":0}]
[null,3290,"Other Non Capital DE Grant Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F26","v":0}]
[null,3292,"Standardised Testing Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F27","v":140}]
[null,3293,"Summer Provision Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F28","v":0}]
[null,3294,"Bus Escort Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F29","v":0}]
[null,3295,"Department of Children and Youth Affairs Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F32","v":0}]
[null,3296,"DSP School Meals Grant",null,null,{"$f":"'3. Income & Expenditure Budget'!F33","v":0}]
[null,3297,"Erasmus Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F34","v":0}]
[null,3298,"HSE Funding",null,null,{"$f":"'3. Income & Expenditure Budget'!F35","v":0}]
[null,3299,"Other State Funding",null,null,{"$f":"'3. Income & Expenditure Budget'!F36","v":0}]
[null,3300,"Education Fees (Fee paying schools)",null,null,{"$f":"'3. Income & Expenditure Budget'!F39","v":0}]
[null,3310,"Transition Year Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F40","v":0}]
[null,3350,"Hire of Facilities Rental Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F42","v":0}]
[null,3370,"Locker Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F43","v":0}]
[null,3375,"Journals and Year Book Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F44","v":0}]
[null,3380,"Student Photocopying Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F45","v":0}]
[null,3390,"School Administration Charges",null,null,{"$f":"'3. Income & Expenditure Budget'!F46","v":0}]
[null,3410,"Adult Education Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F47","v":0}]
[null,3420,"Canteen Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F48","v":0}]
[null,3430,"Tuck Shop Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F49","v":0}]
[null,3440,"Uniforms Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F50","v":0}]
[null,3450,"Religion/Ethos Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F51","v":0}]
[null,3490,"After School Study/Club Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F52","v":0}]
[null,3500,"Games Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F53","v":0}]
[null,3510,"Bus Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F54","v":0}]
[null,3520,"School Musical/Drama Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F56","v":0}]
[null,3530,"School Tours Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F57","v":0}]
[null,3531,"School Swimming Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F58","v":0}]
[null,3535,"Student Insurance Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F59","v":0}]
[null,3540,"Pre-School Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F60","v":0}]
[null,3545,"Summer Camps Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F61","v":0}]
[null,3550,"Reimbursable Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F62","v":0}]
[null,3570,"Other School Generated Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F63","v":0}]
[null,3572,"School Arts and Crafts Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F64","v":0}]
[null,3573,"School Dance Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F65","v":0}]
[null,3574,"Restricted School Fundraising (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F66","v":0}]
[null,3575,"Unrestricted School Fundraising (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F67","v":0}]
[null,3580,"Discounts Given",null,null,{"$f":"'3. Income & Expenditure Budget'!F68","v":0}]
[null,3650,"Voluntary Contributions",null,null,{"$f":"'3. Income & Expenditure Budget'!F71","v":0}]
[null,3700,"Income from Parents Association",null,null,{"$f":"'3. Income & Expenditure Budget'!F72","v":0}]
[null,3770,"Insurance Claim Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F73","v":0}]
[null,3800,"Bank Interest Received",null,null,{"$f":"'3. Income & Expenditure Budget'!F74","v":0}]
[null,3850,"Other Income",null,null,{"$f":"'3. Income & Expenditure Budget'!F75","v":0}]
[null,3851,"Designated Income (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F76","v":0}]
[null,3852,"Restricted External Fundraising (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F77","v":0}]
[null,3853,"Unrestricted External Fundraising (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F78","v":0}]
[null,4110,"Substitute Teachers Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F84","v":0}]
[null,4111,"Privately Paid Teachers Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F85","v":0}]
[null,4150,"Supervision and Substitution Salaries Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F87","v":0}]
[null,4170,"Adult Education Salaries Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F88","v":0}]
[null,4181,"Canteen Salaries Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F89","v":0}]
[null,4190,"After School Study/Club Salaries Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F90","v":0}]
[null,4191,"Summer Camps Salaries Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F91","v":0}]
[null,4196,"Bus Escort Salary Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F92","v":0}]
[null,4198,"Other Educational Salaries Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F93","v":0}]
[null,4199,"HSE Funded Salaries Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F94","v":0}]
[null,4310,"Teaching Aids Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F97","v":0}]
[null,4311,"Early Start Scheme Mat/Equip/Par Dev Expenses",null,null,{"$f":"'3. Income & Expenditure Budget'!F98","v":0}]
[null,4315,"Student Photocopying Expenses",null,null,{"$f":"'3. Income & Expenditure Budget'!F99","v":0}]
[null,4330,"Religion/Ethos Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F100","v":0}]
[null,4410,"ICT Grant Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F101","v":2000}]
[null,4420,"Computer Maintenance & Support Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F102","v":0}]
[null,4490,"Other Subjects Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F103","v":0}]
[null,4550,"Leaving Cert Applied Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F104","v":0}]
[null,4570,"LCVP Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F105","v":0}]
[null,4590,"Transition Year Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F106","v":0}]
[null,4610,"Learning Support Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F107","v":0}]
[null,4620,"Teacher Inservice and Training Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F108","v":0}]
[null,4635,"Student Wellbeing Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F109","v":0}]
[null,4640,"Library Non Grant Funded Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F110","v":0}]
[null,4641,"School Library Books Capital Grant Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F111","v":0}]
[null,4650,"Physical Education Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F112","v":0}]
[null,4670,"Games (excl. travel) Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F113","v":0}]
[null,4671,"Travel Games Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F114","v":0}]
[null,4690,"Bus Hire Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F115","v":0}]
[null,4710,"School Tours Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F116","v":0}]
[null,4720,"School Musical/Drama Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F117","v":0}]
[null,4731,"Free Book Scheme Grant Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F118","v":0}]
[null,4760,"School Yearbook/Journal Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F120","v":0}]
[null,4770,"Trophies and Prizes Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F121","v":0}]
[null,4780,"Uniform Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F122","v":0}]
[null,4810,"Home School Liaison Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F123","v":0}]
[null,4815,"School Excellence Fund Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F124","v":0}]
[null,4908,"Other Summer Camps Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F125","v":0}]
[null,4909,"Other Summer Provision Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F126","v":0}]
[null,4910,"Other Educational Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F127","v":0}]
[null,4911,"Department of Children and Youth Affairs Activities Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F128","v":0}]
[null,4912,"DSP School Meals Food Costs",null,null,{"$f":"'3. Income & Expenditure Budget'!F129","v":0}]
[null,4913,"Erasmus Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F130","v":0}]
[null,4914,"Other Non Capital DE Grants Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F131","v":0}]
[null,4915,"Other Canteen Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F132","v":0}]
[null,4916,"Student Insurance Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F133","v":0}]
[null,4917,"Standardised Testing Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F134","v":140}]
[null,4918,"Designated Expenditure (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F135","v":0}]
[null,4919,"Special Educational Equipment (Non Capital) Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F136","v":0}]
[null,4920,"School Dance Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F137","v":0}]
[null,4921,"School Swimming Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F138","v":0}]
[null,4922,"Restricted School Fundraising Expenses (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F139","v":0}]
[null,4923,"Restricted External Fundraising Expenses (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F140","v":0}]
[null,4924,"Unrestricted External Fundraising Expenses (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F141","v":0}]
[null,4925,"Unrestricted School Fundraising Expenses (Non Capital)",null,null,{"$f":"'3. Income & Expenditure Budget'!F142","v":0}]
[null,4927,"School Arts and Crafts Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F143","v":0}]
[null,4928,"Other HSE Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F144","v":0}]
[null,4930,"Pre-School Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F146","v":0}]
[null,5010,"Caretaker Wages Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F149","v":0}]
[null,5030,"Caretaker Pension Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F150","v":0}]
[null,5110,"Cleaners Wages Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F151","v":0}]
[null,5112,"Cleaners' Pension Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F152","v":0}]
[null,5150,"Contract Cleaners Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F153","v":0}]
[null,5170,"Cleaning Materials Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F154","v":0}]
[null,5175,"Other Cleaning and Sanitation Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F155","v":0}]
[null,5310,"Repairs to Buildings and Grounds Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F156","v":0}]
[null,5315,"Minor Works Grant (Non Capital) Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F157","v":5500}]
[null,5350,"Repairs to Furniture, Fittings and Equipment Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F158","v":0}]
[null,5400,"Routine Security Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F159","v":0}]
[null,5450,"General Insurance Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F160","v":0}]
[null,5510,"Heating Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F161","v":0}]
[null,5550,"Light and Power Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F162","v":0}]
[null,5551,"Rent of Temporary Accommodation Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F163","v":0}]
[null,5552,"Other Rental Costs Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F164","v":0}]
[null,5610,"Refuse Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F165","v":0}]
[null,5611,"Water Rates Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F166","v":0}]
[null,5700,"Licence Fee to Patron/Trustee Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F167","v":0}]
[null,5800,"Other Repairs and Maintenance Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F168","v":0}]
[null,6010,"Clerical Officers/Secretarial Wages Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F171","v":0}]
[null,6050,"Clerical Officers/Secretarial Pension Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F172","v":0}]
[null,6100,"Recruitment Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F173","v":0}]
[null,6150,"Advertising / Public Relations Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F174","v":0}]
[null,6210,"Postage Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F175","v":0}]
[null,6250,"Telephone Expense / SMS Text",null,null,{"$f":"'3. Income & Expenditure Budget'!F176","v":0}]
[null,6300,"Printing and Stationery Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F177","v":0}]
[null,6350,"Office Equipment (Non Capital) Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F178","v":0}]
[null,6355,"Non-ICT_Grant Funded Office Computers Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F179","v":0}]
[null,6400,"Accounting / Auditing Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F180","v":0}]
[null,6450,"Other Professional Fees Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F181","v":0}]
[null,6500,"Travel and Subsistence Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F182","v":0}]
[null,6600,"Principals Expenses",null,null,{"$f":"'3. Income & Expenditure Budget'!F183","v":0}]
[null,6650,"Board of Management Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F184","v":0}]
[null,6700,"Annual Subscriptions Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F185","v":0}]
[null,6730,"InSchool Administration System Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F186","v":0}]
[null,6731,"Accounting Software/Payroll Software Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F187","v":0}]
[null,6750,"Donations to Charity",null,null,{"$f":"'3. Income & Expenditure Budget'!F188","v":0}]
[null,6755,"Medical and First Aid Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F189","v":0}]
[null,6780,"Staff Room Expenses",null,null,{"$f":"'3. Income & Expenditure Budget'!F190","v":0}]
[null,6800,"Hospitality Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F191","v":0}]
[null,6830,"Tuck Shop Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F192","v":0}]
[null,6900,"Other Administration Expenses",null,null,{"$f":"'3. Income & Expenditure Budget'!F193","v":0}]
[null,7300,"Leasing Expenses",null,null,{"$f":"'3. Income & Expenditure Budget'!F196","v":0}]
[null,7320,"Loan Charges Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F197","v":0}]
[null,7400,"Bank Interest Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F198","v":0}]
[null,7450,"Bank Charges Expense",null,null,{"$f":"'3. Income & Expenditure Budget'!F199","v":0}]
[null,7800,"Reimbursable Expenses",null,null,{"$f":"'3. Income & Expenditure Budget'!F200","v":0}]
[null,7850,"Discounts Received",null,null,{"$f":"'3. Income & Expenditure Budget'!F201","v":0}]

{"sheet":"Import YtoD","index":6,"n_rows":198,"n_cols":6,"rows_kept":198,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[3010,0,null,null,3010,{"$f":"IFERROR(VLOOKUP(E4,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3020,0,null,null,3020,{"$f":"IFERROR(VLOOKUP(E5,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3021,0,null,null,3021,0]
[3022,0,null,null,3022,0]
[3050,0,null,null,3050,0]
[3140,0,null,null,3140,0]
[3150,0,null,null,3151,0]
[3155,0,null,null,3152,0]
[3160,0,null,null,3155,0]
[3170,0,null,null,3170,0]
[3171,0,null,null,3171,0]
[3190,0,null,null,3190,0]
[3200,0,null,null,3200,0]
[3210,0,null,null,3210,{"$f":"IFERROR(VLOOKUP(E17,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3225,0,null,null,3230,{"$f":"IFERROR(VLOOKUP(E18,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3226,0,null,null,3260,{"$f":"IFERROR(VLOOKUP(E19,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3227,0,null,null,3275,{"$f":"IFERROR(VLOOKUP(E20,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3230,0,null,null,3276,0]
[3260,0,null,null,3289,0]
[3275,0,null,null,3290,0]
[3276,0,null,null,3292,0]
[3277,0,null,null,3293,0]
[3280,0,null,null,3294,{"$f":"IFERROR(VLOOKUP(E26,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3282,0]
[3284,0]
[3285,0,null,null,3295,{"$f":"IFERROR(VLOOKUP(E29,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3286,0,null,null,3296,{"$f":"IFERROR(VLOOKUP(E30,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3287,0,null,null,3297,{"$f":"IFERROR(VLOOKUP(E31,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3288,0,null,null,3298,{"$f":"IFERROR(VLOOKUP(E32,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3290,0,null,null,3299,{"$f":"IFERROR(VLOOKUP(E33,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3292,0]
[3293,0]
[3294,0,null,null,3300,{"$f":"IFERROR(VLOOKUP(E36,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3295,0,null,null,3310,0]
[3296,0,null,null,3335,0]
[3297,0,null,null,3350,0]
[3298,0,null,null,3370,0]
[3299,0,null,null,3375,0]
[3300,0,null,null,3380,0]
[3310,0,null,null,3390,0]
[3330,0,null,null,3410,0]
[3335,0,null,null,3420,0]
[3350,0,null,null,3430,0]
[3370,0,null,null,3440,0]
[3375,0,null,null,3450,0]
[3380,0,null,null,3490,0]
[3390,0,null,null,3500,0]
[3410,0,null,null,3510,0]
[3420,0,null,null,3511,0]
[3430,0,null,null,3520,0]
[3440,0,null,null,3530,0]
[3450,0,null,null,3531,0]
[3490,0,null,null,3535,0]
[3500,0,null,null,3540,0]
[3510,0,null,null,3545,0]
[3520,0,null,null,3550,0]
[3530,0,null,null,3570,0]
[3531,0,null,null,3572,0]
[3535,0,null,null,3573,0]
[3540,0,null,null,3574,0]
[3545,0,null,null,3575,0]
[3550,0,null,null,3580,0]
[3570,0]
[3572,0]
[3573,0,null,null,3650,{"$f":"IFERROR(VLOOKUP(E68,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[3574,0,null,null,3700,0]
[3575,0,null,null,3770,0]
[3580,0,null,null,3800,0]
[3650,0,null,null,3850,0]
[3700,0,null,null,3851,0]
[3770,0,null,null,3852,0]
[3800,0,null,null,3853,0]
[3840,0]
[3850,0]
[3851,0]
[3852,0]
[3853,0]
[4110,0,null,null,4110,{"$f":"IFERROR(VLOOKUP(E81,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[4111,0,null,null,4111,0]
[4150,0,null,null,4113,0]
[4170,0,null,null,4150,0]
[4181,0,null,null,4170,0]
[4190,0,null,null,4181,0]
[4191,0,null,null,4190,0]
[4196,0,null,null,4191,0]
[4197,0,null,null,4196,0]
[4198,0,null,null,4198,0]
[4199,0,null,null,4199,0]
[4310,0]
[4311,0]
[4315,0,null,null,4310,{"$f":"IFERROR(VLOOKUP(E94,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[4330,0,null,null,4311,0]
[4410,0,null,null,4315,0]
[4420,0,null,null,4330,0]
[4490,0,null,null,4410,0]
[4550,0,null,null,4420,0]
[4570,0,null,null,4490,0]
[4590,0,null,null,4550,0]
[4610,0,null,null,4570,0]
[4620,0,null,null,4590,0]
[4635,0,null,null,4610,0]
[4640,0,null,null,4620,0]
[4641,0,null,null,4635,0]
[4650,0,null,null,4640,0]
[4670,0,null,null,4641,0]
[4671,0,null,null,4650,0]
[4690,0,null,null,4670,0]
[4710,0,null,null,4671,0]
[4720,0,null,null,4690,0]
[4730,0,null,null,4710,0]
[4740,0,null,null,4720,0]
[4741,0,null,null,4731,0]
[4760,0,null,null,4741,0]
[4770,0,null,null,4760,0]
[4780,0,null,null,4770,0]
[4810,0,null,null,4780,0]
[4815,0,null,null,4810,0]
[4908,0,null,null,4815,0]
[4909,0,null,null,4908,0]
[4910,0,null,null,4909,0]
[4911,0,null,null,4910,0]
[4912,0,null,null,4911,0]
[4913,0,null,null,4912,0]
[4914,0,null,null,4913,0]
[4915,0,null,null,4914,0]
[4916,0,null,null,4915,0]
[4917,0,null,null,4916,0]
[4918,0,null,null,4917,0]
[4919,0,null,null,4918,0]
[4920,0,null,null,4919,0]
[4921,0,null,null,4920,0]
[4922,0,null,null,4921,0]
[4923,0,null,null,4922,0]
[4924,0,null,null,4923,0]
[4925,0,null,null,4924,0]
[4927,0,null,null,4925,0]
[4928,0,null,null,4927,0]
[4930,0,null,null,4928,0]
[5010,0,null,null,4929,0]
[5011,0,null,null,4930,0]
[5030,0]
[5110,0]
[5111,0,null,null,5010,{"$f":"IFERROR(VLOOKUP(E146,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[5112,0,null,null,5030,{"$f":"IFERROR(VLOOKUP(E147,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[5150,0,null,null,5110,0]
[5170,0,null,null,5112,0]
[5175,0,null,null,5150,0]
[5310,0,null,null,5170,0]
[5315,0,null,null,5175,0]
[5316,0,null,null,5310,0]
[5350,0,null,null,5315,0]
[5400,0,null,null,5350,0]
[5450,0,null,null,5400,0]
[5510,0,null,null,5450,0]
[5550,0,null,null,5510,0]
[5551,0,null,null,5550,0]
[5552,0,null,null,5551,0]
[5610,0,null,null,5552,0]
[5611,0,null,null,5610,{"$f":"IFERROR(VLOOKUP(E162,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[5700,0,null,null,5611,0]
[5800,0,null,null,5700,0]
[5801,0,null,null,5800,{"$f":"IFERROR(VLOOKUP(E165,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[5803,0]
[5804,0]
[5806,0,null,null,6010,{"$f":"IFERROR(VLOOKUP(E168,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[6010,0,null,null,6050,{"$f":"IFERROR(VLOOKUP(E169,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[6011,0,null,null,6100,0]
[6050,0,null,null,6150,0]
[6100,0,null,null,6210,0]
[6150,0,null,null,6250,0]
[6210,0,null,null,6300,0]
[6250,0,null,null,6350,0]
[6300,0,null,null,6355,0]
[6350,0,null,null,6400,0]
[6355,0,null,null,6450,0]
[6400,0,null,null,6500,0]
[6450,0,null,null,6600,0]
[6500,0,null,null,6650,0]
[6600,0,null,null,6700,0]
[6650,0,null,null,6730,0]
[6700,0,null,null,6731,0]
[6730,0,null,null,6750,0]
[6731,0,null,null,6755,0]
[6750,0,null,null,6780,0]
[6755,0,null,null,6800,0]
[6780,0,null,null,6830,0]
[6800,0,null,null,6900,0]
[6830,0]
[6900,0]
[7300,0,null,null,7300,{"$f":"IFERROR(VLOOKUP(E193,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[7320,0,null,null,7320,{"$f":"IFERROR(VLOOKUP(E194,Inport_Manual_MRT,2,FALSE),0)","v":0}]
[7400,0,null,null,7400,0]
[7450,0,null,null,7450,0]
[7800,0,null,null,7800,0]
[7850,0,null,null,7850,{"$f":"IFERROR(VLOOKUP(E198,Inport_Manual_MRT,2,FALSE),0)","v":0}]

{"sheet":"Import Inc&Exp","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}