{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["HMST Project Budget Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HMST Project Budget Template","index":0,"n_rows":74,"n_cols":14,"rows_kept":74,"cut":false,"hidden":false,"merged":[[11,2,12,2],[43,2,44,2],[9,2,9,6],[74,1,80,12]]}
[null,"MULTI-YEAR GRANT PROJECT ACTUAL TEMPLATE"]
[null,"Only complete the shaded areas below. The Budget columns should be identical to that submitted in your original grant application. If income is confirmed in some years, but not in subsequent years please mark as 'not confirmed' and add a note to explain."]
[null,"Please note this template is locked so headings cannot be altered and you cannot copy and paste. Lines cannot be inserted but cell text will wrap."]
[null,"\"Year\" equals project year based on your project's start date, not neccesarily calendar or financial year. "]
[null,"You may provide additional narrative notes for particular line items if required by putting a number in the 'Note #' column, and include corresponding narrative detail in the Notes section below."]
[null,"If your project ran for more than 3 years please contact HMSTrust for an alternate version of this budget form."]
[null,"(1) In-kind are non-cash contributions of time, services, equipment, materials etc. The in-kind Income line item must match the in-kind Expense line item.  Only enter the in-kind details in the Income section and it will auto populate in the Expense section."]
[null,"(2) Earned income is income that is expected to be generated from the project (e.g. ticket sales, fee-for-service etc.)"]
[]
[null,"ORGANISATION TRADING NAME:"]
[]
[null,null,"Note #",null,"<enter period>","<enter period>","<enter period>"]
[null,"INCOME",null,"Itemise detail / description","Budget \nYear 1","Budget \nYear 2","Budget \nYear 3","Budget Total","Confirmed (Yes/No)","Actual\nYear 1","Actual\nYear 2","Actual\nYear 3","Actual Total","Explanation of variance between actual and budget"]
[null,"Funding from HMSTrust (excluding GST):",null,null,null,null,null,{"$f":"SUM(E14:G14)","v":0},"Yes",null,null,null,{"$f":"SUM(J14:L14)","v":0}]
[null,"Government funding (itemise):",null,null,null,null,null,{"$f":"SUM(E15:G15)","v":0},null,null,null,null,{"$f":"SUM(J15:L15)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E16:G16)","v":0},null,null,null,null,{"$f":"SUM(J16:L16)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Other philanthropic sources (itemise):",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E22:G22)","v":0},null,null,null,null,{"$f":"SUM(J22:L22)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Cash contribution from own organisation (itemise):",null,null,null,null,null,0,null,null,null,null,0]
[null,"In-kind(1) contribution from own organisation:",null,null,null,null,null,0,null,null,null,null,0]
[null,"(itemise)",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E27:G27)","v":0},null,null,null,null,{"$f":"SUM(J27:L27)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Earned income(2) (itemise): ",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Other income (specify & itemise):",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Cash contribution from project partners:",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E36:G36)","v":0},null,null,null,null,{"$f":"SUM(J36:L36)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"In-kind(1) contributions from project partners:",null,null,null,null,null,0,null,null,null,null,0]
[null,"(itemise and name project partners)",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E40:G40)","v":0},null,null,null,null,{"$f":"SUM(J40:L40)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E41:G41)","v":0},null,null,null,null,{"$f":"SUM(J41:L41)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E14:E42)","v":0},{"$f":"SUM(F14:F42)","v":0},{"$f":"SUM(G14:G42)","v":0},{"$f":"SUM(H14:H42)","v":0},null,{"$f":"SUM(J14:J42)","v":0},{"$f":"SUM(K14:K42)","v":0},{"$f":"SUM(L14:L42)","v":0},{"$f":"SUM(M14:M42)","v":0}]
[null,null,"Note #",null,null,null,null,{"$f":"IF(H72<>H43,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[null,"EXPENSES",null,"Itemise detail / description (Provide detailed information such as hours, rates, quantities, position descriptions, contractor/evaluator name etc)\n","Budget \nYear 1","Budget \nYear 2","Budget \nYear 3","Budget Total",null,"Actual\nYear 1","Actual\nYear 2","Actual\nYear 3","Actual \nTotal","Explanation of variance between actual and budget"]
[null,"Salaries (including super, payroll tax etc):",null,null,null,null,null,{"$f":"SUM(E46:G46)","v":0},null,null,null,null,{"$f":"SUM(J46:L46)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E48:G48)","v":0},null,null,null,null,{"$f":"SUM(J48:L48)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Consultant fees specific to this project:",null,null,null,null,null,0,null,null,null,null,0]
[null,"Capital, fit-out, equipment costs (itemise):",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Administration and consumable costs:",null,null,null,null,null,0,null,null,null,null,0]
[null,"Travel and accommodation:",null,null,null,null,null,0,null,null,null,null,0]
[null,"Marketing/advertising/promotion:",null,null,null,null,null,0,null,null,null,null,0]
[null,"Evaluation (specify who conducts):",null,null,null,null,null,0,null,null,null,null,0]
[null,"Other expenses (specify & itemise):",null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"In-kind(1) contributions from own organisation:",null,{"$f":"IF(D25=\"\",\"\",D25)","v":""},{"$f":"E25","v":0},0,0,{"$f":"SUM(E63:G63)","v":0},null,{"$f":"J25","v":0},0,0,{"$f":"SUM(J63:L63)","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D26=\"\",\"\",D26)","v":""},0,0,0,{"$f":"SUM(E64:G64)","v":0},null,0,0,0,0]
[null,null,null,{"$f":"IF(D27=\"\",\"\",D27)","v":""},0,0,0,{"$f":"SUM(E65:G65)","v":0},null,0,0,0,{"$f":"SUM(J65:L65)","v":0}]
[null,null,null,{"$f":"IF(D28=\"\",\"\",D28)","v":""},{"$f":"E28","v":0},0,0,{"$f":"SUM(E66:G66)","v":0},null,{"$f":"J28","v":0},0,0,0]
[null,"In-kind(1) contributions from project parters:",null,{"$f":"IF(D38=\"\",\"\",D38)","v":""},{"$f":"E38","v":0},0,0,0,null,{"$f":"J38","v":0},0,0,0]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D39=\"\",\"\",D39)","v":""},0,0,0,0,null,0,0,0,0]
[null,null,null,{"$f":"IF(D40=\"\",\"\",D40)","v":""},0,0,0,{"$f":"SUM(E69:G69)","v":0},null,0,0,0,{"$f":"SUM(J69:L69)","v":0}]
[null,null,null,{"$f":"IF(D41=\"\",\"\",D41)","v":""},0,0,0,{"$f":"SUM(E70:G70)","v":0},null,0,0,0,{"$f":"SUM(J70:L70)","v":0}]
[null,null,null,{"$f":"IF(D42=\"\",\"\",D42)","v":""},{"$f":"E42","v":0},0,0,0,null,{"$f":"J42","v":0},0,0,0]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E46:E71)","v":0},0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(H72<>H43,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[null,"NOTES - for additional general notes, or further details on specific income and expense items if required. Please ensure corresponding 'Note #' is included."]