{"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":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[9,2,10,2],[41,2,42,2],[7,2,7,4],[72,1,78,6]]}
[null,"ONE-OFF 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. "]
[null,"Please not 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,"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,"(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,"INCOME",null,"Itemise detail / description","Budget Total","Actual\nTotal","Explanation of variance between actual and budget"]
[null,"Funding from HMSTrust (excluding GST):"]
[null,"Government funding (itemise):"]
[]
[]
[]
[null,"Other philanthropic sources (itemise):"]
[]
[]
[]
[]
[null,"Cash contribution from own organisation (itemise):"]
[null,"In-kind(1) contribution from own organisation:"]
[null,"(itemise)"]
[]
[]
[null,"Earned income(2) (itemise): "]
[]
[null,"Other income (specify & itemise):"]
[]
[]
[null,"Cash contribution from project partners:"]
[]
[]
[]
[null,"In-kind(1) contributions from project partners:"]
[null,"(itemise and name project partners)"]
[]
[]
[]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E12:E40)","v":0},{"$f":"SUM(F12:F40)","v":0}]
[null,null,"Note #",null,{"$f":"IF(E70<>E41,\"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 Total","Actual\nTotal","Explanation of variance between actual and budget"]
[null,"Salaries (including super, payroll tax etc):"]
[]
[]
[]
[null,"Consultant fees specific to this project:"]
[null,"Capital, fit-out, equipment costs (itemise):"]
[]
[]
[null,"Administration and consumable costs:"]
[null,"Travel and accommodation:"]
[null,"Marketing/advertising/promotion:"]
[null,"Evaluation (specify who conducts):"]
[null,"Other expenses (specify & itemise):"]
[]
[]
[]
[]
[null,"In-kind(1) contributions from own organisation:",null,{"$f":"IF(D23=\"\",\"\",D23)","v":""},{"$f":"E23","v":0},{"$f":"F23","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D24=\"\",\"\",D24)","v":""},0,0]
[null,null,null,{"$f":"IF(D25=\"\",\"\",D25)","v":""},0,0]
[null,null,null,{"$f":"IF(D26=\"\",\"\",D26)","v":""},{"$f":"E26","v":0},{"$f":"F26","v":0}]
[null,"In-kind(1) contributions from project parters:",null,{"$f":"IF(D36=\"\",\"\",D36)","v":""},{"$f":"E36","v":0},{"$f":"F36","v":0}]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D37=\"\",\"\",D37)","v":""},0,0]
[null,null,null,{"$f":"IF(D38=\"\",\"\",D38)","v":""},0,0]
[null,null,null,{"$f":"IF(D39=\"\",\"\",D39)","v":""},0,0]
[null,null,null,{"$f":"IF(D40=\"\",\"\",D40)","v":""},{"$f":"E40","v":0},{"$f":"F40","v":0}]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E44:E69)","v":0},0]
[null,null,null,null,{"$f":"IF(E70<>E41,\"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."]