{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","HMST Financial Acquittal"],"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":"INSTRUCTIONS","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS FOR HMSTRUST GRANT FINANCIAL ACQUITTAL"]
[]
[null,"As part of your final reporting back to HMSTrust, recipients of grants are required to provide a financial acquittal using this template. "]
[]
[null,"Please save a copy of the template to enable you to attach it to your online progress or final report once completed. Make sure you include your organisation name in the field at the top of the template."]
[]
[null,"Only complete the shaded (coloured) areas. The Budget columns should be identical to that submitted in your original grant application. In the Actual columns, please provide details on what income you actually received and spent compared to what you had budgetted. Include any additional income that was secured since the project commenced and provide explanation of what it was directed towards. If funding sources have changed from those in the original budget, please provide details."]
[]
[null,"Variation between Budget and Actual: Use the right-hand column to explain any significant variation between your original project budget and the actual income or expenses."]
[]
[null,"Please note this template is locked so headings cannot be altered. Extra lines may not be inserted, however cell text will wrap."]
[]
[null,"GST: Note that grants made by HMSTrust are regarded as gifts and are not subject to GST. If you are registered for GST you must not include GST in your income and expenditure figures. If you are not registered for GST you should include GST in your expenditure figures, where applicable."]
[]
[null,"Notes: 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 at the end."]
[]
[null,"DEFINITIONS"]
[]
[null," In-kind is 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,"Earned income is income that is expected to be generated from the project (e.g. ticket sales, fee-for-service etc.)"]
[]
[null,"CONTACT US"]
[null,"If you have any questions or issues, please call HMSTrust on 03 9999 3000 or email applications@hmstrust.org.au and we will assist you."]

{"sheet":"HMST Financial Acquittal","index":1,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[4,2,5,2],[36,2,37,2],[2,2,2,4],[67,1,73,6]]}
[null,"ONE-OFF GRANT PROJECT ACTUAL TEMPLATE"]
[]
[null,"ORGANISATION TRADING NAME:","<enter organisation 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(E7:E35)","v":0},{"$f":"SUM(F7:F35)","v":0}]
[null,null,"Note #",null,{"$f":"IF(E65<>E36,\"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(D18=\"\",\"\",D18)","v":""},{"$f":"E18","v":0},{"$f":"F18","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D19=\"\",\"\",D19)","v":""},0,0]
[null,null,null,{"$f":"IF(D20=\"\",\"\",D20)","v":""},0,0]
[null,null,null,{"$f":"IF(D21=\"\",\"\",D21)","v":""},{"$f":"E21","v":0},{"$f":"F21","v":0}]
[null,"In-kind(1) contributions from project parters:",null,{"$f":"IF(D31=\"\",\"\",D31)","v":""},{"$f":"E31","v":0},{"$f":"F31","v":0}]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},0,0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",D33)","v":""},0,0]
[null,null,null,{"$f":"IF(D34=\"\",\"\",D34)","v":""},0,0]
[null,null,null,{"$f":"IF(D35=\"\",\"\",D35)","v":""},{"$f":"E35","v":0},{"$f":"F35","v":0}]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E39:E64)","v":0},0]
[null,null,null,null,{"$f":"IF(E65<>E36,\"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."]