{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1 ExpenseReport","2 Receipt Itemization","3 Missing Receipts Form","4 Per Diem Form","5 Kilometerage Form","GTFM excerpts notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":71,"comments":5,"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":"1 ExpenseReport","index":0,"n_rows":57,"n_cols":30,"rows_kept":57,"cut":false,"hidden":false,"merged":[[51,7,51,11],[49,16,49,21],[51,16,51,21],[50,16,50,21],[41,16,41,21],[43,16,43,21],[44,16,44,21],[45,16,45,21],[43,8,43,11],[44,7,44,11],[45,7,45,11],[46,7,46,11],[47,7,47,11],[48,7,48,11],[49,7,49,11],[50,7,50,11],[50,0,50,1],[50,3,50,5],[48,3,49,5],[48,0,49,1],[48,2,49,2],[41,3,41,5],[38,0,38,5],[39,3,40,5],[47,0,47,5],[41,0,41,1],[39,2,40,2],[39,0,40,1],[6,2,6,5],[9,10,9,12],[25,2,25,5],[12,1,12,5],[18,0,19,5],[25,0,25,1],[11,2,11,5],[21,0,21,5],[22,0,23,5],[24,0,24,5],[13,7,13,11],[15,0,16,5],[13,0,14,5],[32,0,35,5],[1,5,1,13],[2,6,2,13],[10,2,10,5],[11,0,11,1],[10,0,10,1],[4,0,4,4],[8,2,8,5],[5,0,5,1],[7,0,7,1],[6,7,7,13],[7,2,7,5],[9,2,9,5],[3,0,3,13],[6,0,6,1],[5,2,5,5],[28,0,28,5],[26,2,26,5],[17,0,17,5],[25,7,25,8],[20,0,20,5],[26,0,26,1],[27,0,27,5],[1,26,2,29],[13,27,14,27],[13,29,14,29],[42,16,42,21],[48,16,48,21],[4,16,8,22],[46,16,46,21],[47,16,47,21],[13,25,14,25],[13,26,14,26],[13,23,14,23],[39,16,39,21],[40,16,40,21],[38,16,38,21],[14,16,14,21]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOCUMENT #"]
[null,null,null,null,null,"EXPENSE REPORT/ACCOUNTABLE ADVANCE SETTLEMENT",null,null,null,null,null,null,null,null,null,null,"ACCOUNTING INFORMATION",null,null,null,null,null,null,null,null,null,"Emp. Reimb: (s/b 235xxxx series) KE\nAMEX Payment: (s/b 19xxxxx series) KN"]
[null,null,null,null,null,null,"TO BE COMPLETED BY CLAIMANT",null,null,null,null,null,null,null,null,null,"TO BE COMPLETED BY BUSINESS OFFICER"]
["NOTE: For Direct Deposit (Full-Time Faculty/Staff), FIS FUNCTION:  SELECT EMPLOYEE EXPENSE REIMBURSEMENT D.D.\n   Document type is KE to get a 23xx document #; vendor 99xx to issue CHQ for EXP REIMB. KN to get a 19xx document #. Vendor 103050 to issue CHQ to AMEX."]
[{"$f":"IF(A8=\"amex payment\",\"DOCUMENT TYPE:    KN (default)\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purpose: Select purpose. Enter code, below, to complete G/L account. If G/L account is not listed, enter appropriate G/L account on \"OTHER\" line.",null,null,null,null,null,null,null,0,"EMPLOYEE FIELD TRIP"]
[{"$f":"IF(A8=\"amex payment\",\"DOCUMENT DATE:\",\"\")","v":""},null,{"$f":"IF(A8=\"amex payment\",amexDate,\"\")","v":""},null,null,null," NOTE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"EMPLOYEE CONFERENCE/MEETINGS"]
[{"$f":"IF(A8<>\"AMEX payment\",\"\",\"REFERENCE (AMEX card)#:\")","v":""},null,{"$f":"IF(A8=\"amex payment\",AMEXaccount,\"\")","v":""},null,null,null,"1.","For expense reimbursements in a currency other than CAD, \nDO NOT convert expenses to CAD value. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"STUDENT FIELD TRIP"]
[{"$f":"IF(reimbt=\"\",\"\",IF(reimbt=\"AMEX\",\"AMEX PAYMENT\",IF(reimbt<>\"AMEX\",\"\")))","v":""},null,{"$f":"IF(reimbt=\"\",\"\",IF(reimbt=\"dd\",\"DIRECT DEPOSIT\",IF(reimbt=\"chq\",\"REIMBURSE BY CHEQUE\",IF(reimbt<>\"\",\"\"))))","v":"DIRECT DEPOSIT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"STUDENT CONFERENCE"]
["*VENDOR#",{"$f":"IF(A8<>\"AMEX PAYMENT\",\"PERSONNEL#\",\"103050\")","v":"PERSONNEL#"},"PERIOD OF EXPENDITURE:",null,null,null,null,"Indicate reimbursement currency: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"VISITOR"]
[null,{"$f":"IF(A8=\"AMEX PAYMENT\",\" \",empl_no)","v":0},{"$f":"IF(time_period=\" \",\"\",time_period)","v":""}]
["LAST NAME:",null,"FIRST NAME:",null,null,null,"2.","ORIGINAL RECEIPTS ARE REQUIRED "]
[{"$f":"IF(surname=\" \",\"\",surname)","v":""},null,{"$f":"IF(firstname=\" \",\"\",firstname)","v":""}]
["ADDRESS:",null,null,null,null,null,null,null,"EXPENSE CATEGORIES",null,null,null,null,null,null,null,null,"GENERAL LEDGER"]
[null,null,null,null,null,null,null,"Summary of non-refundable items",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax \nCode",null,"Cost \nCentre","         Internal\nor      Order","Fund \nCentre",null,"Commitment\nItem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AMOUNT",null,null,"G/L ACCT. NUMBER",null,null,null,null,null,null,null,null,null,null,null,"Fund"]
[{"$f":"IF(reimbt=\"dd\",\"N/A - DIRECT DEPOSIT TO BANK\",IF(reimbt=\"chq\",\"\",IF(reimbt=\"amex\",\"PO Box 2000\nWest Hill, ON  M1E 5H4\")))","v":"N/A - DIRECT DEPOSIT TO BANK"},null,null,null,null,null,null,"AIRFARE:","Travel within Canada",null,null,null,null,{"$f":"fare1","v":0},null,null,8,4,null,0,1,0,null,"ER"]
[null,null,null,null,null,null,null,null,"Travel to USA from Ontario",null,null,null,null,{"$f":"fare1b","v":0},null,null,8,4,null,0,1,0,null,"EE"]
["BRIEF DESCRIPTION OF EXPENDITURES:",null,null,null,null,null,null,null,"All other Airfare",null,null,null,null,{"$f":"fare2","v":0},null,null,8,4,null,0,1,0,null,"E0"]
[{"$f":"IF(location_desc=\" \",\"\",location_desc)","v":""},null,null,null,null,null,null,"ACCOMMODATION:","ON, NF, NB (13% HST)",null,null,null,null,{"$f":"accom1","v":0},null,null,8,4,null,0,2,0,null,"ER"]
[null,null,null,null,null,null,null,null,"PEI (14% HST)",null,null,null,null,{"$f":"accomPEI","v":0},null,null,8,4,null,0,2,0,null,"EP"]
["DEPARTMENTAL CONTACT & DEPARTMENT (incl. address):",null,null,null,null,null,null,null,"NS (15% HST)",null,null,null,null,{"$f":"accomNS","v":0},null,null,8,4,null,0,2,0,null,"EN"]
[{"$f":"IF(contact=\" \",\"\",contact)","v":"Lynn Gole       lynn.gole@utoronto.ca"},null,null,null,null,null,null,null,"All other provinces / territories",null,null,null,null,{"$f":"accom1b","v":0},null,null,8,4,null,0,2,0,null,"EE"]
[{"$f":"IF(division=\" \",\"\",division)","v":"Cell and Systems Biology"},null,null,null,null,null,null,null,"USA / International",null,null,null,null,{"$f":"accom2","v":0},null,null,8,4,null,0,2,0,null,"E0"]
[null,null,null,null,null,null,null,"ALLOWANCES:",null,"PER DIEM: in Canada",null,null,null,{"$f":"IF(diemCDNorUS,,ttlperdiem)","v":0},null,null,8,4,null,0,3,0,null,"EA"]
[{"$f":"IF(pickup<>\"NO\",\"CALL / EMAIL FOR PICK UP\",\" \")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"PER DIEM: USA/International",null,null,null,{"$f":"IF(diemCDNorUS,ttlperdiem)","v":false},null,null,8,4,null,0,3,0,null,"E0"]
["TELEPHONE:",null,null,null,null,null,null,{"$f":"KM","v":0},null,"KMS X 0.54/km",null,null,null,{"$f":"KMclaimed","v":0},null,null,8,4,null,0,4,0,null,"EA"]
[{"$f":"IF(contact_phone=\" \",\"\",contact_phone)","v":"416-946-8171"},null,null,null,null,null,null,"RAILWAY/BUS:","WITHIN CANADA ",null,null,null,null,{"$f":"railway1","v":0},null,null,8,4,null,0,5,0,null,"ER"]
["DATE PREPARED:",null,null,null,null,null,null,null,"OUTSIDE CANADA",null,null,null,null,{"$f":"railway2","v":0},null,null,8,4,null,0,5,0,null,"E0"]
[{"$f":"TODAY()","v":"2017-06-06"},null,null,null,null,null,null,"CAR RENTAL:","ON, NF, NB (13% HST)",null,null,null,null,{"$f":"carrental1","v":0},null,null,8,4,null,0,6,0,null,"ER"]
[null,null,null,null,null,null,null,null,"PEI (14% HST)",null,null,null,null,{"$f":"carrentalPEI","v":0},null,null,8,4,null,0,6,0,null,"EP"]
[null,null,null,null,null,null,null,null,"NS (15% HST)",null,null,null,null,{"$f":"carrentalNS","v":0},null,null,8,4,null,0,6,0,null,"EN"]
["DECLARATION BY CLAIMANT:",null,null,null,null,null,null,null,"All other provinces / territories",null,null,null,null,{"$f":"carrental1b","v":0},null,null,8,4,null,0,6,0,null,"EE"]
["I HAVE READ THE UNIVERSITY'S REGULATION ON REIMBURSEMENT OF EXPENSES AND CONFIRM THAT I AM IN COMPLIANCE.",null,null,null,null,null,null,null,"USA / International",null,null,null,null,{"$f":"carrental2","v":0},null,null,8,4,null,0,6,0,null,"E0"]
[null,null,null,null,null,null,null,"MEALS:","ON, NF, NB (13% HST)",null,null,null,null,{"$f":"meals1","v":0},null,null,8,4,null,0,7,0,null,"ER"]
[null,null,null,null,null,null,null,null,"PEI (14% HST)",null,null,null,null,{"$f":"mealsPEI","v":0},null,null,8,4,null,0,7,0,null,"EP"]
[null,null,null,null,null,null,null,null,"NS (15% HST)",null,null,null,null,{"$f":"mealsNS","v":0},null,null,8,4,null,0,7,0,null,"EN"]
[null,null,null,null,null,null,null,null,"All other provinces / territories",null,null,null,null,{"$f":"meals1b","v":0},null,null,8,4,null,0,7,0,null,"EE"]
[null,null,null,null,null,null,null,null,"USA / International",null,null,null,null,{"$f":"meals2","v":0},null,null,8,4,null,0,7,0,null,"E0"]
["Signature of Claimant",null,null,null,null,null,null,"TAXI:","ON, NF, NB (13% HST)",null,null,null,null,{"$f":"taxi1","v":0},null,null,845000,null,null,null,null,null,null,"ER"]
[{"$f":"IF(firstname=\"\",\"\",CONCATENATE(firstname,\" \",surname))","v":""},null,null,{"$f":"IF(title = \" \",\"\",title)","v":""},null,null,null,null,"PEI (14% HST)",null,null,null,null,{"$f":"taxiPEI","v":0},null,null,845000,null,null,null,null,null,null,"EP"]
[null,null,null,null,null,null,null,null,"NS (15% HST)",null,null,null,null,{"$f":"taxiNS","v":0},null,null,845000,null,null,null,null,null,null,"EN"]
["Name",null,null,"Title",null,null,null,null,"All other provinces / territories",null,null,null,null,{"$f":"taxi1b","v":0},null,null,845000,null,null,null,null,null,null,"EE"]
[null,null,null,null,null,null,null,null,"USA / International",null,null,null,null,{"$f":"taxi2","v":0},null,null,845000,null,null,null,null,null,null,"E0"]
["AUTHORIZED APPROVAL",null,null,null,null,null,null,"OTHER COSTS:","PARKING",null,null,null,null,{"$f":"parking","v":0},null,null,"835780 parking"]
[null,null,null,null,null,null,null,"HOSPITALITY - meals in Toronto",null,null,null,null,null,{"$f":"hospitality","v":0},null,null,"836400 hospitality"]
[null,null,null,null,null,null,null,{"$f":"cost_title1","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"other1","v":0}]
[null,null,null,null,null,null,null,{"$f":"cost_title2","v":0},null,null,null,null,null,{"$f":"other2","v":0}]
["Signature of Approver",null,null,null,null,null,null,{"$f":"cost_title3","v":0},null,null,null,null,null,{"$f":"other3","v":0}]
[{"$f":"approver","v":0},null,null,{"$f":"approver_title","v":0},null,null,null,{"$f":"cost_title4","v":0},null,null,null,null,null,{"$f":"other4","v":0}]
[null,null,null,null,null,null,null,{"$f":"cost_title5","v":0},null,null,null,null,null,{"$f":"other5","v":0}]
["Name",null,null,"Title",null,null,null,{"$f":"cost_title6","v":0},null,null,null,null,null,{"$f":"other6","v":0}]
[null,null,null,null,null,null,null,{"$f":"cost_title7","v":0},null,null,null,null,null,{"$f":"other7","v":0}]
["For Accountable Advance Settlements:"]
["Financial Services (Original/authorized copy)",null,null,null,null,null,null,null,null,null,"TOTAL EXPENSES",null,null,{"$f":"SUM(N16:N52)","v":0}]
["Originating Department (Photocopy)",null,null,null,null,null,null,null,"(LESS ACCOUNTABLE ADVANCE)"]
[]
[null,null,null,null,null,null,null,null,null,null,"REIMBURSEMENT REQUESTED OR REPAYMENT",null,null,{"$f":"SUM(N54:N56)","v":0}]

{"sheet":"2 Receipt Itemization","index":1,"n_rows":75,"n_cols":39,"rows_kept":75,"cut":false,"hidden":false,"merged":[[73,0,73,3],[74,0,74,3],[75,0,75,3],[76,0,76,3],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3],[72,0,72,3]]}
["The business purpose for each expenditure must be clearly documented such that the purpose could be reasonably understood by an outside party. Please review notes on the tab \"GTFM notes\"."]
[null,null,"Last name",null,{"$f":"IF(surname=0,\"!! Required\",\" \")","v":"!! Required"}]
[null,null,"First name",null,{"$f":"IF(firstname=0,\"!! Required\",\" \")","v":"!! Required"}]
[null,null,"Title",null,{"$f":"IF(title=0,\"!! Required\",\" \")","v":"!! Required"}]
[null,null,"Personnel#",null,{"$f":"IF(empl_no=0,\"!! Required\",\" \")","v":"!! Required"}]
[null,null,"Division or Department & address","Cell and Systems Biology",{"$f":"IF(division=0,\"!! Required\",\" \")","v":" "}]
[null,null,"Contact Name (i.e. EA or Bus.Offcr)","Lynn Gole       lynn.gole@utoronto.ca",{"$f":"IF(contact=0,\"!! Required\",\" \")","v":" "}]
[null,null,"Tel#","416-946-8171",{"$f":"IF(contact_phone=0,\"!! Required\",\" \")","v":" "}]
[null,null,"Approver's Name"]
[null,null,"Approver's Title",null,null,"TO PRINT THIS PAGE & HIDE COLUMNS TOTALING $0.00,  PRESS …."]
[null,null,"Expense type (enter DD or AMEX)","DD",null,"CTRL+T  "]
[null,null,"AMEX#"]
[null,null,"AMEX statement date",null,{"$f":"IF(reimbt=\"amex\",\"!! Required\",\" \")","v":" "}]
["All expense claims should be submitted for reimbursement on a timely basis, and it would be unreasonable to expect reimbursement after more than 1 year."]
[null,null,"Period of expenditures ",null,{"$f":"IF(time_period=0,\"!! Required: enter date range of expenditures (i.e. Feb 1 - 25, 2016)\",\" \")","v":"!! Required: enter date range of expenditures (i.e. Feb 1 - 25, 2016)"}]
[null,null,"Brief description of expenditures ",null,{"$f":"IF(location_desc=0,\"!! Required\",\" \")","v":"!! Required"}]
[]
[null,"TOTAL",{"$f":"SUM(F21:AM21)","v":0}]
[null,"pier diem allowance",{"$f":"ttlperdiem","v":0},null,null,null,null,null,null,"Luxury accommodation will not be reimbursed"]
[null,"km allowance",{"$f":"KMclaimed","v":0},null,null,null,"air travel",null,null,null,null,"accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cell"]
[null,"subtotal",{"$f":"SUM(F21:AM21)","v":0},null,null,{"$f":"SUM(F23:F62)","v":0},{"$f":"SUM(G23:G62)","v":0},{"$f":"SUM(H23:H62)","v":0},{"$f":"SUM(I23:I62)","v":0},{"$f":"SUM(J23:J62)","v":0},0,0,0,0,0,0,{"$f":"SUM(Q23:Q62)","v":0},0,0,0,0,{"$f":"SUM(V23:V62)","v":0},{"$f":"SUM(W23:W62)","v":0},0,0,0,0,{"$f":"SUM(AB23:AB62)","v":0},0,0,0,0,0,{"$f":"SUM(AG23:AG62)","v":0},{"$f":"SUM(AH23:AH62)","v":0},{"$f":"SUM(AI23:AI62)","v":0},{"$f":"SUM(AJ23:AJ62)","v":0},{"$f":"SUM(AK23:AK62)","v":0},{"$f":"SUM(AL23:AL62)","v":0}]
["Missing Receipt?","Receipt \nNo.","Date","Description of Cost: Business Purpose, Location, Attendees  (provide clear details as to the business purpose of the expenditure)","Name of Vendor/Store","Airfare (within Canada)","Airfare \n(Ontario to USA)","Airfare \n(all other airfare)","Accommodation\nOntario, NF, NB\n13% HST","Accommodation\nPEI 14% HST","Accommodation\nNS 15% HST","Accommodation\nother prov & territories","Accommodation\nUSA / International ","Railway/Bus","Railway/Bus\n(o.s. Canada)","Car Rental:\nOn, NF, NB\n13% HST","Car Rental:\nPEI \n14% HST","Car Rental:\nNS\n15% HST","Car Rental:\nother prov & territories","Car Rental:\nUSA / Int'l ","Hospitality - meals in Toronto\n(836400)","Travel Meals:\nOn, NF, NB\n13% HST","Travel Meals:\nPEI 14% HST","Travel Meals:\nNS 15% HST","Travel Meals:\nother prov & territories","Travel Meals:\nUSA / Int'l ","Taxi:\nOn, NF, NB\n13% HST","Taxi:\nPEI 14% HST","Taxi:\nNS 15% HST","Taxi:\nother prov & territories","Taxi:\nUSA / Int'l ","Parking\n(835780)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[]
[]
[]
[]
["Receipts"]
["• Organize receipts/proof of payment in the order of presentation of the item as listed above."]
["• In the case of a large number of receipts, review of the claim can be completed more efficiently if the receipts are numbered."]
["• The receipt/proof of payment must be original and clearly identify the item(s) or service(s) purchased. Where the receipt does not provide this information, the claimant should do so (e.g. titles of publications, types of supplies)."]
["• Original restaurant receipts are required for reimbursement of actual expenses (i.e. detailed restaurant bill). Please note that the credit card receipt may be used to substantiate the restaurant gratuity. "]
[]
[]
["• If the accommodation is booked through a third party booking site (like Expedia), then the order confirmation from the third party booking site showing credit card payment and travel dates, including a statement of guest charges or hotel bill with travel dates from the host establishment for other charges (or a hotel bill with travel dates where there were no other charges, if provided) should accompany the reimbursement request."]
["If your hotel invoice includes charges for meals/refreshments, the detailed restaurant receipt is also required to be attached."]

{"sheet":"3 Missing Receipts Form","index":2,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,5],[28,1,28,3],[31,1,31,3],[26,0,26,5],[27,0,27,5],[2,0,2,5],[1,0,1,5]]}
["MISSING RECEIPTS - Reimbursable Expenses For Which There Is No Original Receipt "]
["This form is used when detailed restaurant bills, boarding passes, documents, and receipts are not available. \nSubmit this form with your (i) Expense Report Claim and/or (ii) request for payment of AMEX Statements."]
["The following is a detailed list of expenses incurred while conducting business or carrying out related duties on behalf of the University and for which there are no original receipts. Furthermore, I will not be seeking reimbursement from any other source, nor, if the missing receipts are subsequently found, will they be \nre-submitted for reimbursement."]
[]
["Receipt#","Date","Description of Cost","Vendor / Location","Reason for no receipt","Amount $CAD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TOTAL - Missing Receipts",null,{"$f":"SUM(F6:F25)","v":0}]
["I acknowledge that original detailed receipts are necessary for reimbursement per University policy, and will endeavour to adhere to this requirement on future expense claims. I also understand and acknowledge that Canada Revenue Agency may consider all amounts paid to individuals without receipts to be taxable income to the individual. "]
["Please approve the total amount of expenses incurred without original detailed receipts for reimbursement as noted above.  "]
[null,null,null,null,"   Date:",{"$f":"NOW()","v":"2017-06-06T11:01:54.200"}]
["Name/Title of Claimant:",null,{"$f":"CONCATENATE(firstname &\" \",surname &\", \",title)","v":" , "}]
[]
[null,null,null,null,"   Date:"]
["Name/Title of Approver:",null,{"$f":"CONCATENATE(approver &\", \",approver_title)","v":", "}]

{"sheet":"4 Per Diem Form","index":3,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,0,10,4],[2,0,2,4],[11,0,11,4]]}
["Per Diem Allowance",null,null,null,{"$f":"CONCATENATE(firstname &\" \",surname)","v":" "}]
["[Attach to expense report]"]
["A fixed allowance covering meals and incidental expenses (e.g. gratuities for housekeeping services and bellhops, etc.) may be claimed, without receipts, in lieu of specific expense reimbursement, in Canadian dollars, as follows:\n\nPlease note that it is not permitted to claim a full day per diem when at a conference if the conference fees include a meal component, or if travel begins in the middle of the day.\n\nEffective Jan 2012: The University is no longer permitted to provide meal per diems for travel claims that will be expensed in any operating fund accounts.  Per diems may be expensed in all other funds (e.g. ancillaries, trust, and research) as long as they are not funded by any agency or ministry of the Ontario Government."]
[null,null,"In Canada \n$CAD","USA or International \n$CAD"]
["Breakfast",null,11,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prior to 1-Oct-2008","2008-10-01"]
["Lunch",null,17,22.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In Canada \n$CAD","In Canada \n$CAD"]
["Dinner",null,27,37.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,11]
["Total Daily Allowance",null,{"$f":"SUM(C5:C7)","v":55},{"$f":"SUM(D5:D7)","v":75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,17]
[null,"2008-10-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"SUM(T7:T9)","v":50},{"$f":"SUM(U7:U9)","v":55}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[" [ENTER SOURCE OF FUNDING HERE ….]"]
["Date","Breakfast","Lunch","Dinner","Location & Description",null,null,null,null,null,null,null,null,null,null,null,false,false,false,"prior to 1-Oct-2008","brkfst","lnch","dnr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,{"$f":"IF(A14>=$B$9,0,TRUE)","v":true},{"$f":"IF(Q14=$T14,11-10,0)","v":0},{"$f":"IF(R14=$T14,17-15,0)","v":0},{"$f":"IF(S14=$T14,27-25,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,{"$f":"IF(A15>=$B$9,0,TRUE)","v":true},{"$f":"IF(Q15=$T15,11-10,0)","v":0},{"$f":"IF(R15=$T15,17-15,0)","v":0},{"$f":"IF(S15=$T15,27-25,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,{"$f":"IF(A16>=$B$9,0,TRUE)","v":true},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,true,0,0,0]
["No. Days",{"$f":"COUNTIF(Q14:Q33,TRUE)","v":0},{"$f":"COUNTIF(R14:R33,TRUE)","v":0},{"$f":"COUNTIF(S14:S33,TRUE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U14:U33)","v":0},{"$f":"SUM(V14:V33)","v":0},{"$f":"SUM(W14:W33)","v":0}]
["Per Diem - Subtotal",{"$f":"IF(diemCDNorUS,B34*$D$5,B34*$C$5)","v":0},{"$f":"IF(diemCDNorUS,C34*$D$6,C34*$C$6)","v":0},{"$f":"IF(diemCDNorUS,D34*$D$7,D34*$C$7)","v":0}]
[]
[null,null,"Per Diem - Total",{"$f":"SUM(B35:D35)","v":0}]

{"sheet":"5 Kilometerage Form","index":4,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,0,3,3],[28,0,28,3],[2,0,2,3],[0,0,0,1]]}
["Kilometerage Allowance",null,null,{"$f":"CONCATENATE(firstname &\" \",surname)","v":" "}]
["[Attach to expense report]"]
["Click here to view additional details/guidelines on Use of Employee Owned Vehicle."]
["All car expenses are covered by the kilometrage rate including maintenance, repair, towing and fuel cost. Additional charges for parking, bridge, ferry and highway tolls while on University business are eligible expenses.  (Note that the reimbursement rates of the granting agency guidelines, or a specific research award, will apply if they are lower than the University rates.)\n\nThe rate allowed for use of a personally owned automobile while on approved University business is 54 cents per kilometre (effective rate from Sep 2006 to Mar 31, 2016 is 0.47 / km).\n\nConversion: Multiply miles by 1.609 to convert to kilometres."]
["CALCULATOR:\nmiles to kms",1,{"$f":"B5*1.609","v":1.609}]
["2016-03-31",null,"2006-09-01"]
["Date","Km claimed",0.54,"Address From/To: Purpose of Trip"]
[null,null,{"$f":"IF(A8>$A$6,B8*0.54,B8*0.47)","v":0}]
[null,null,{"$f":"IF(A9>$A$6,B9*0.54,B9*0.47)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["Total  ",{"$f":"SUM(B8:B27)","v":0},{"$f":"SUM(C8:C27)","v":0}]
["Limitation: The standard is that a personally owned vehicle may be used for trips up to 500 km in round trip length. For longer trips a traveller may elect to use his or her own vehicle, but reimbursement for kilometerage will be limited to the equivalent least expensive mode of transportation to and from that destination.  (See GTFM for additional information).   \n\nIf the total round trip exceed 500 km, ensure to include a quote showing the equivalent least expensive mode of transportation for the actual dates of travel (i.e. quote for airfare, train, or car rental)."]

{"sheet":"GTFM excerpts notes","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,2],[3,0,3,3],[2,0,2,3],[4,0,4,3],[5,0,5,3],[1,0,1,3]]}
[null,"Click to review the Guide to Financial Management:  \nTravel and Other Reimbursable Expenses – Policies and Guidelines"]
[]
["The business purpose for each expenditure must be clearly documented such that the purpose could be reasonably understood by an outside party."]
["All expense claims should be submitted for reimbursement on a timely basis, and it would be unreasonable to expect reimbursement after more than one year after the related expenses have been incurred.\n"]
["Original detailed receipts and proof of payment must accompany the expense report.  If you are missing reciepts, please complete the Missing Receipts Form."]
["Please note that receipts are very important for income tax purposes. The Canada Revenue Agency considers all amounts paid to individuals without receipts to be income to the individual and, therefore, taxable."]
[]
[null,"goto BOC rates","Foreign Currency:  If expenditures are in another currency, and is charged to a credit card, attach a copy of the credit card summary showing the conversion.  For cash payments, use the rate paid when the foreign currency was purchased. If this is not provided, use FIS or Bank of Canada rates. Ensure a copy of the conversion rate is printed and attached to the expense report.      www.bankofcanada.ca/rates/exchange/10-year-converter "]
[]
["Below are excerpts from the GTFM, click on the links below to view the full details in the GTFM"]
[null,"Airfare:","For domestic and international flights, the standard class of service is the least expensive economy class fare. \n\nPrior Approval is required for all business class and premium economy travel  Ensure to include a copy of the pre-approval with your expense report.\n\nThe lack of availability of economy seats due to late travel arrangements which could reasonably have been avoided through better planning would generally not be viewed as adequate justification for Business Class or Premium Economy travel.\n\nRequests for long flight segments (i.e. greater than 6 hours in duration) are to be submitted in writing to the one-up approver (head of the unit, principal, dean, director, chair or senior executive) who will provide written approval prior to booking travel. \n\nExamples of circumstances that may justify travelling in Business Class or Premium Economy could include:\n• physical constraints on a long flight segment (in excess of 6 hours), or\n• medical reasons which preclude travelling in economy.\n\nCaution: Some granting agencies, such as the Tri-Agencies, specifically limit air and rail travel reimbursement to the lowest available fare."]
[]
[null,"Hotel:","The standard for accommodation is a single room with a private bath in a business class hotel. Use of luxury accommodation will not be reimbursed.\n\nReceipt requirement: If the accommodation is booked through a third party booking site (like Expedia), then the order confirmation from the third party booking site showing credit card payment and travel dates, including a statement of guest charges or hotel bill with travel dates from the host establishment for other charges (or a hotel bill with travel dates where there were no other charges, if provided) should accompany the reimbursement request.\n\nMeals/refreshments charged to hotel bill: if meals are charged to the hotel room, include the detailed restaurant invoice along with the hotel invoice."]