{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Budget Reporting"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":2,"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":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"How to complete the budget reporting  template:"]
[]
[null,"There are four columns that the Research Project Lead is required to fill out in the budget spreadsheet.\nThese are the unshaded columns E, H and I.",null,null,"Financial reporting checklist"]
[]
[null,"Expenditure",null,null,"1)      Have you entered information into ALL the boxes in ALL the unshaded columns?"]
[null,null,null,null," "]
[null,"1)      Column C shows you the total amount of money that is budgeted for each item for the duration of your project as per your approved Project Plan. You cannot change these figures.",null,null,"2)      Have you compared the current budget report to your previous budget report?  Total expenditure for each item should not reduce from one report to the next."]
[]
[null,"2)      Column D shows how much money in total you have spent prior to the current reporting period. This amount should be what you have reported in the last reporting period. ",null,null,"3)      Have you included an explanation for any item where the anticipated expenditure is different to the remaining budget set aside for this purpose?"]
[]
[null,"If this is your first budget report, this column will be left blank or $0.  ",null,null,"4)      Have you included an explanation for any anticipated income that has not yet been received?"]
[]
[null,"3)      In Column E, please enter how much money you have spent on each item during the current reporting period.",null,null,"5)      Are all the figures that you have entered exclusive of GST?"]
[]
[null,"If this is your first budget report, this will be the total amount of money that you have spent on each item since commencing the project, the same figure should be appear in Column F automatically.  "]
[]
[null,"4)      Column F will automatically calculate the total amount of money spent on each item since you started the project. "]
[]
[null,"5)      Column G will automatically calculate how much money you have left to spend on each budget item for the duration of your project. This is calculated by subtracting the amount you have spent from the amount that is budgeted. "]
[]
[null,"6)     In Column H, please enter the amount of money that you think you will need for each item in order to complete the project. The figure in Column H should be the same as the corresponding figure in Column G if nothing has changed in your budget. If Column G does not equal Column H, please provide an explanation in Column I the comments section."]
[]
[null,"Income"]
[]
[null,"1)      The total amount of money budgeted for your project (from ISCRR and from other sources) as per your approved Project Plan is shown in Column C. These figures can not be changed."]
[]
[null,"2)      In Column D, please enter the amount of money that you have received prior to the current reporting period."]
[]
[null,"If this is your first budget report, you may leave this column blank or enter 0.  "]
[]
[null,"3)      In Column E, please enter the amount of money that you have received during the current reporting period from each source. "]
[]
[null,"4)      Column F will automatically calculate the total amount of money that you have received to date for this project. If this is your first progress report, Column F will equal Column G. "]
[]
[null,"5)      Column G will automatically calculate the amount of income for the project that you have not yet received from each source."]
[]
[null,"6)      Most of the time, the figure in Column H will be the same as the corresponding figure in Column G. However, if you have been awarded any more funding for this project or will not receive as much as originally anticipated, you will need to adjust this figure to incorporate the additional or missing funds.  If Column G does not equal Column H, please provide an explanation in Column I the comments section."]

{"sheet":"Budget Reporting","index":1,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,1,0,6],[4,0,4,1],[40,0,40,1],[47,0,47,2],[5,0,5,8],[31,0,31,8],[14,0,14,8]]}
[null,"Project No and details, etc (cut and paste from the first section of the first page of the project management report)"]
[]
[null,"Please fill in the unshaded columns. Instructions are on the first tab."]
[]
["EXPENDITURE",null,"Original Budgeted Amount","Expenditure to (Date)","Expenditure in Reporting Period \n(Date to Date)","Total Expenditure to Date","Budget Remaining ","Anticipated Future Expenditure to Complete Project","Comment to explain under or over spend or inclusion of additional item","Note"]
["STAFFING EXPENDITURE",null,null,null,null,null,null,null,null,"1,5"]
[null,"Position title, staff name (if available)",0,null,null,{"$f":"E7+D7","v":0},{"$f":"C7-F7","v":0}]
[null,null,0,null,null,0,0]
[null,null,0,null,null,0,0]
[null,null,0,null,null,0,0]
[null,null,0,null,null,0,0]
[null,"Overheads",0,null,null,0,0]
["SUBTOTAL (STAFF EXPENDITURE)",null,{"$f":"SUM(C7:C12)","v":0},0,0,{"$f":"SUM(D13+E13)","v":0},{"$f":"SUM(C13-F13)","v":0},0]
[]
["OPERATING EXPENDITURE",null,null,null,null,null,null,null,null,"2, 3"]
[null,"Travel & related expenses",0,null,null,{"$f":"D16+E16","v":0},{"$f":"C16-F16","v":0}]
[null,"Student-related expenses",0,null,null,0,0]
[null,"Staff-related expenses",0,null,null,0,0]
[null,"Printing, stationery & media expenses",0,null,null,0,0]
[null,"Other expenses",0,null,null,0,0]
[null,"Motor vehicle-related expenses",0,null,null,0,0]
[null,"Laboratory expenses",0,null,null,0,0]
[null,"Finance & administrative services expenses",0,null,null,0,0]
[null,"Computer-related expenses",0,null,null,0,0]
[null,"Equipment-related expenses",0,null,null,0,0]
[null,"Communications expenses",0,null,null,0,0]
[null,"Building & property expenses",0,null,null,0,0]
[null,"Book & library expenses",0,null,null,0,0]
[null,null,0,null,null,0,0]
["SUBTOTAL (OPERATING EXPENDITURE)",null,{"$f":"SUM(C16:C29)","v":0},0,0,{"$f":"SUM(D30+E30)","v":0},{"$f":"SUM(C30-F30)","v":0},0]
[]
["CAPITAL EXPENDITURE",null,null,null,null,null,null,null,null,"3, 4"]
[null,"Capital Item 1",0,null,null,{"$f":"D33+E33","v":0},{"$f":"C33-F33","v":0}]
[null,"Capital Item 2",0,null,null,{"$f":"D34+E34","v":0},{"$f":"C34-F34","v":0}]
[null,null,0,null,null,{"$f":"D35+E35","v":0},{"$f":"C35-F35","v":0}]
["SUBTOTAL (CAPITAL EXPENDITURE)",null,{"$f":"SUM(C33:C35)","v":0},{"$f":"SUM(D33:D35)","v":0},{"$f":"SUM(E33:E35)","v":0},{"$f":"SUM(D36+E36)","v":0},{"$f":"SUM(C36-F36)","v":0},0]
[]
["TOTAL EXPENDITURE ",null,{"$f":"SUM(C13+C30+C36)","v":0},{"$f":"SUM(D13+D30+D36)","v":0},{"$f":"SUM(E13+E30+E36)","v":0},{"$f":"SUM(F13+F30+F36)","v":0},{"$f":"C38-F38","v":0},{"$f":"H13+H30+H36","v":0}]
[]
[]
["FUNDING INCOME FROM ALL SOURCES",null," Original Budgeted Amount ","Received as of (Date)","Received in Reporting Period (Date to Date) \n","Total Received to Date","Income not yet received"," Anticipated Future Income  ","Comment","Note"]
[null,"ISCRR",0,null,null,{"$f":"D42+E42","v":0},{"$f":"C42-F42","v":0}]
[null,"Source 1",0,null,null,{"$f":"D43+E43","v":0},{"$f":"C43-F43","v":0}]
[null,"Source 2",0,null,null,{"$f":"D44+E44","v":0},{"$f":"C44-F44","v":0}]
["TOTAL INCOME ",null,{"$f":"SUM(C42:C44)","v":0},null,{"$f":"SUM(E42:E44)","v":0},{"$f":"SUM(D45+E45)","v":0},{"$f":"SUM(C45-F45)","v":0},{"$f":"SUM(H42:H44)","v":0}]
[]
[null,null,null,null,null,"NOTES"]
["OTHER INFORMATION for this reporting period",null,null,null,1,"Include staff name, position title, FTE per year of project including on costs."]
[null,"Total FTE on project ",null,null,2,"Only complete required rows."]
[null,"Total number of staff working on project",null,null,3,"Items of equipment greater than $5000 should be included under capital expenditure"]
[null,null,null,null,4,"Provide detailed justification for capital items "]
[null,null,null,null,5,"Include details of In-Kind members of research team but with $0 in the amount column"]