{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Guide","Report","Background "],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Guide","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,2,10],[3,1,3,10],[5,1,5,10],[6,1,6,2],[6,3,6,10],[9,1,9,2],[9,3,9,10],[7,1,7,2],[7,3,7,10],[8,1,8,2],[8,3,8,10],[11,1,11,10],[19,7,19,8],[12,1,12,10],[14,1,15,10],[16,2,16,4],[16,7,16,8],[17,2,17,4],[17,7,17,8],[18,2,18,4],[18,7,18,8],[13,1,13,10],[26,1,26,2],[26,3,26,5],[24,11,27,16],[21,1,21,13],[22,1,23,13],[24,3,24,5],[25,1,25,2],[25,3,25,5],[25,7,25,8]]}
[null,"Child Care Rapid Renovation Fund"]
[null,"Itemized Expense Report Guide"]
[]
[null,"Refer to this guide when completing the Itemized Expense Report (located on the second tab at the bottom of this spreadsheet).\nSave a copy of this file and click 'Enable Content' from the message bar to activate the functionality of the sheet.\nYou must have the Report prepared and signed by a treasurer, Chief Financial Officer (CFO) or accountant using the Excel signature function. \nPlease submit your completed report to the Ministry in Excel format. \nNote: Making changes after the signature is captured will delete the signature. "]
[]
[null,"Project Information"]
[null,"Organization Name:",null,"As indicated on your Grant Letter"]
[null,"Project ID #:",null,"As indicated on your Grant Letter"]
[null,"Funding Agreement Effective Date:",null,"As indicated on your Grant Letter"]
[null,"Total Funding Received:",null,"As indicated on your Grant Letter"]
[]
[null,"To create or subtract rows in the table below, please use the addition and subtraction buttons on the upper right-hand side of the table. \nEnsure you click 'Enable Content' from the message bar to activate this function."]
[null,"Project Costs"]
[null,"A list of eligible Project Costs can be found in the Funding Details section of the website."]
[null,"Provide an itemized list of all eligible Project Costs up to the date of project completion. \nInclude a description of the cost (e.g., \"perimeter fencing and gate\"), identify the corresponding proof of payment, the invoice number (if applicable), the name of the company or individual from which the items/services were purchased, the date of purchase, and the amount paid to date.  "]
[]
[null,"Ref. #","Description of Cost\nInclude a detailed, accurate description of the cost. ",null,null,"Proof of Payment (select one)","Invoice Number \n(if applicable)","Company/Individual Name",null,"Date of Purchase\nDate of purchase or payment date.","Amount Paid\n(including applicable taxes)\nAmounts should not include any tax exempt portions. "]
[null,1,"5 x Interior Doors",null,null,"Invoice",123123,"ABC Contractor",null,"2021-01-01",1000]
[null,2,"6 x Exit Signs",null,null,"Transaction Receipt","N/A","123 Appliance Store",null,"2021-01-02",300]
[null,null,null,null,null,null,null,null,null,"Total Project Costs:",{"$f":"SUM(INDIRECT(\"$K$14:K\"&ROW(J20)-1))","v":1300}]
[]
[null,"LICENSED CHARTERED  PROFESSIONAL ACCOUNTANT DECLARATION"]
[null,"I hereby certify, I am an independent and a Licensed Public Practice CPA within British Columbia. I certify the Itemized Expense Report has been prepared in accordance with financial record keeping requirements as outlined in Ministry Funding Guidelines and related Generally Accepted Accounting Principles. As a result of my review, the Itemized Expense Report is accurate in accordance with the Ministry Funding Guidelines and there are no material misstatements."]
[]
[null,null,"Name: ",null,null,null,null,null,"Signature: ",null,null,"Your treasurer, CFO or accountant must prepare and sign your Report using the Excel signature function. To do this, right-click on the signature block and select 'Sign'. \nNote: Making changes after the signature is captured will delete the signature. "]
[null,"Company:"]
[null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"Report","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,1,5,10],[10,1,10,10],[22,2,22,4],[22,7,22,8],[23,2,23,4],[23,7,23,8],[15,7,15,8],[14,2,14,4],[14,7,14,8],[24,7,24,8],[19,7,19,8],[18,2,18,4],[31,1,31,2],[32,1,32,2],[31,7,31,8],[32,7,32,8],[31,3,31,5],[32,3,32,5],[27,1,27,13],[28,1,29,13],[25,7,25,8],[12,12,13,13],[16,2,16,4],[17,2,17,4],[17,7,17,8],[19,2,19,4],[16,7,16,8],[20,2,20,4],[20,7,20,8],[21,2,21,4],[21,7,21,8],[18,7,18,8],[24,2,24,4],[15,2,15,4],[30,3,30,5],[32,9,32,10],[1,1,2,10],[0,1,0,10],[3,1,3,10],[12,1,13,10],[11,1,11,10],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[6,3,6,10],[7,3,7,10],[8,3,8,10],[9,3,9,10],[4,1,4,10]]}
[null,"Child Care Rapid Renovation Fund"]
[null,"Itemized Expense Report"]
[]
[null,"REPORT TO BE SUBMITTED TO THE MINISTRY IN EXCEL FORMAT."]
[]
[null,"Project Information"]
[null,"Organization Name:"]
[null,"Project ID #:"]
[null,"Funding Agreement Effective Date:"]
[null,"Total Funding Received:"]
[null,"To create or subtract rows in the table below, please use the addition and subtraction buttons on the upper right-hand side of the table. "]
[null,"Project Costs"]
[null,"Provide an itemized list of all eligible Project Costs up to the date of project completion. \nInclude a description of the cost (e.g., \"perimeter fencing and gate\"), identify the corresponding proof of payment, the invoice number (if applicable), the name of the company or individual from which the items/services were purchased, the date of purchase, and the amount paid to date.  ",null,null,null,null,null,null,null,null,null,null,"TO BE COMPLETED BY MINISTRY STAFF ONLY"]
[]
[null,"Ref. #","Description of Cost",null,null,"Proof of Payment\n (select one)","Invoice Number \n(if applicable)","Company/Individual Name",null,"Date of Purchase","Amount Paid\n(including applicable taxes)",null,"Eligible Expense (Y/N)","Eligible Amount Paid to Date"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,null,null,null,null,null,null,null,null,"Total Project Costs:",{"$f":"SUM(INDIRECT(\"$K$14:K\"&ROW(J26)-1))","v":0},null,"Total Project Costs:",{"$f":"SUM(INDIRECT(\"$N$14:N\"&ROW(M26)-1))","v":0}]
[]
[null,"DECLARATION"]
[null," I certify the Itemized Expense Report has been prepared in accordance with financial record keeping requirements as outlined in Ministry Funding Guidelines and related Generally Accepted Accounting Principles. As a result of my review, the Itemized Expense Report is accurate in accordance with the Ministry Funding Guidelines and there are no material misstatements."]
[]
[null,null,"Name: ",null,null,null,null,null,"Signature: "]
[null,"Company:"]
[null,null,null,null,null,null,null,"Date:"]

{"sheet":"Background ","index":2,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Drop Down for POP Type"]
[]
["Bank Statement "]
["Copy of Cheque"]
["Credit Card Statement"]
["Invoice"]
["Transaction Receipt"]
["Other "]