{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","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":"INSTRUCTIONS","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS FOR HMSTRUST ONE-OFF GRANT PROJECT BUDGET"]
[]
[null,"When you apply to HMSTrust for a grant, you are required to provide a budget for your project using this template."]
[]
[null,"Please save a copy of the budget template to enable you to attach it to your online application once completed. As you save it, we recommend you re-name your template with your organisation name in the title e.g. \"XY org budget\". Make sure you include your organisation name in the field at the top of the template."]
[]
[null,"Make sure that your project budget details are accurate and realistic as you will be required to report against this budget should your application be successful."]
[]
[null,"Only complete the shaded (coloured) areas in the template. Some fields will automatically calculate and fill based on your entries."]
[]
[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,"You must state whether income from other sources is confirmed (Yes) or not confirmed (No). If your budet includes income that is not confirmed (for example, an application to another funding body/foundation), you will need to update us with the results as they become available. Please note HMSTrust only pays out a grant, once all funding for a project has been confirmed. If an application to another funding body is unsuccessful, or other income becomes unavailable, you must advise HMSTrust as soon as possible. You will need to submit a revised budget. If your application is successful, you will be required to report Actuals against your Budget."]
[]
[null,"Totals: The budgeted total income MUST equal the budgeted total expenses. The template will calculate totals as you complete the budget. You will receive a warning in red next to the totals if income and expenditure do not balance.  This will disappear once your budget balances."]
[]
[null,"You will be required to enter your project budget totals into your application form. Ensure that the totals in your application form match with the totals in your completed Project Budget Template."]
[]
[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 Project Budget Template","index":1,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[[77,1,77,5],[78,1,78,5],[79,1,79,5],[80,1,80,5],[81,1,81,5],[82,1,82,5],[3,2,4,2],[72,1,75,5],[40,2,42,2],[2,2,2,4]]}
[null,"ONE-OFF GRANT PROJECT BUDGET TEMPLATE"]
[]
[null,"ORGANISATION TRADING NAME:","<enter organisation name here>"]
[null,null,null,null,null,"Confirmed  "]
[null,"INCOME",null,"Itemise detail / description","Total","(Yes/No)"]
[null,"Funding request from HMSTrust (excluding GST):",null,null,null,"No"]
[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,null,null,null,{"$f":"IF(AND(SUM(E21:E22)>0,LEN(B73)=0),\"Please complete EARNED INCOME EXPLANATION BELOW\",\"\")","v":""}]
[]
[null,"Other (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(E6:E34)","v":0},{"$f":"IF(E70<>E35,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,null,null,"SUMMARY OF TOTAL INCOME:"]
[null,null,null,"Total confirmed income",{"$f":"SUMIF(F6:F34,\"Yes\",E6:E34)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",{"$f":"SUMIF(F6:F34,\"No\",E6:E34)-E40","v":0}]
[null,null,null,"HMST funding request",{"$f":"SUM(E6)","v":0}]
[null,null,"Note #",null,{"$f":"SUM(E38:E40)","v":0},{"$f":"IF(E41<>E35,\"Warning: Please make sure Confirmed (Yes/No) is selected for each completed income line\",\"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","Total"]
[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 (specify & itemise):"]
[]
[]
[]
[]
[null,"In-kind(1) contributions from own organisation:",null,{"$f":"IF(D17=\"\",\"\",D17)","v":""},{"$f":"E17","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D18=\"\",\"\",D18)","v":""},0]
[null,null,null,{"$f":"IF(D19=\"\",\"\",D19)","v":""},0]
[null,null,null,{"$f":"IF(D20=\"\",\"\",D20)","v":""},{"$f":"E20","v":0}]
[null,"In-kind(1) contributions from project parters:",null,{"$f":"IF(D30=\"\",\"\",D30)","v":""},{"$f":"E30","v":0}]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D31=\"\",\"\",D31)","v":""},0]
[null,null,null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",D33)","v":""},0]
[null,null,null,{"$f":"IF(D34=\"\",\"\",D34)","v":""},{"$f":"E34","v":0}]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E44:E69)","v":0},{"$f":"IF(E70<>E35,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[null,"EARNED INCOME EXPLANATION"]
[null,"If your project relies on earned income, please provide brief details relating to rationale of revenue assumptions:"]
[]
[]
[]
[]
[null,"NOTES - for additional details on itemised income and expense items, if required. Please ensure corresponding 'Note #' is included."]