{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","SAMPLE Expense Report","Expense Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["407 Toll"]
["Abstract/Journal Fees"]
["Airfare - Domestic",null,null,1,"Enter Claimant's Name"]
["Airfare - International",null,null,2,"Provide dates claim covers (DD-MMM-YY)"]
["Airfare - Non-Domestic within North America",null,null,3,"Provide the Location of the Expense"]
["Airfare Ticket Tax  ",null,null,4,"In the Expense Detail section click on a blank space and select the applicable expense type from the drop down list"]
["Airport Taxes",null,null,5,"In the Expense Business Purpose Column enter the Business Purpose for the expense and relationship to grant (e.g. Meeting with Joe Smith to discuss Research proposal)"]
["Airport Taxi/Limousine",null,null,6,"If the amount paid was a Foreign Currency enter the amount in the Foreign Amount Column"]
["ATM/Bank Fees",null,null,7,"If the amount was in a Foreign Currency enter the appropriate exchange rate in the Exchange Rate Column (attach documentation to support the exchange rate).  The CDN equivalent is populates automatically in the CDN Funds Column."]
["Baggage Fees",null,null,8,"For any expenses in Canadian funds, enter the amount in the CDN Amount Column"]
["Books",null,null,9,"The total in CDN Funds is calculated automatically"]
["Business Meal (attendees)  ",null,null,10,"If HST was charged on the invoice enter the amount of HST charged into the HST Charged Column"]
["Car Rental  ",null,null,11,"If GST was charged on the invoice enter the amount of GST charged into the GST Charged Column"]
["Cellular Phone  ",null,null,12,"FOR NON-PROVINCIALLY FUNDED ACCOUNTS ONLY- For Meals Per Diem Claims in Canada enter the number of Breakfast, Lunch and Dinner that you are claiming in the appropriate boxes found near the bottom of the Expense Type Column.  For Foreign Meals Per Diem claims use the Meals Per Diem Foreign from the drop down list located in the Expense Detail Column."]
["Coach  Bus",null,null,13,"For Mileage Claims in Ontario or other HST Provinces, enter in the number of Km's into the appropriate box found on the last line of the Expense Detail Column.  For Mileage claims in other Provinces, the USA and other Foreign destinations use the Personal Car Mileage Foreign from the drop down list located in the Expense Detail Column.  When claiming Mileage that is a rate other than the current McMaster University rate use the Other Mileage expense type from the drop down box calculating the amount to be reimbursed, note the rate used and provide documentation supporting the rate."]
["Company Car - Maintenance  ",null,null,14,"In the chart field string section at the bottom of the expense report enter the Fund, select the Account from the drop down, enter the Department and Program, select the Business Unit from the drop down menu and if using the Business Unit of RFHSC or RFMAC you must enter the Project."]
["Company Car -Gasoline "]
["Conference Registration",null,null,null,"Below is a list of the Account numbers and descriptions"]
["Courier",650000,null,null,"650000   Travel - General"]
["Entertainment-Other  ",650001,null,null,"650001   Travel - Automobile"]
["Fax Charges",650002,null,null,"650002   Travel - Communication"]
["Flight Cancellation Insurance",650003,null,null,"650003   Travel - Entertainment"]
["Gasoline - Other",650004,null,null,"650004   Travel - Individual Meals"]
["GO Bus",650005,null,null,"650005   Travel - Lodging"]
["Gratuities",650006,null,null,"650006   Travel - Other"]
["Gratuitous Accommodation",650007,null,null,"650007   Travel - Transportation"]
["Hotel",650008,null,null,"650008   Travel - Supplies"]
["Immunization Shots",650009,null,null,"650009   Travel - Equipment"]
["Incidentals Per Diem",650010,null,null,"650010   Travel - Relocation"]
["Internet Services",650011,null,null,"650011   Travel - Conference Fees"]
["Lab Supplies  ",650012,null,null,"650012   Travel - Field Trips"]
["Limousine  ",650015,null,null,"650015   Travel - Parking"]
["Local Phone  ",650050,null,null,"650050   Meals and Entertainment"]
["Long Distance  ","MAC01"]
["Meals with Receipts","RFHSC"]
["Meals Per Diem (Allowance) Domestic","RFMAC"]
["Meals Per Diem (Allowance) Foreign",null,null,15,"In the chart field string section at the bottom of the report, the HST & GST rebate amounts are automatically calculated and entered into the last two lines.  You must subtract the rebate amounts for HST & GST from the Total payable and enter the amount into the column next to the account being charged."]
["Membership Dues - No taxes Charged",null,null,16,"Print the Expense Report."]
["Membership Dues - Taxes Charged",null,null,17,"Have the Claimant sign the report and attach the spreadsheet with supporting documentation to the non PO voucher."]
["Office Supplies  ",null,null,18,"Once the voucher has been approved, forward the hardcopy of spreadsheet with original receipts to Accounts Payable (Travel), DTC 403"]
["Other Car Mileage"]
["Parking  "]
["Personal Car Mileage Domestic  "]
["Personal Car Mileage Foreign"]
["Photocopying"]
["Rent - No Taxes Charged"]
["Rent - Taxes Charged"]
["Seminar Fees  "]
["Subscriptions  "]
["Taxi  "]
["Train  "]
["Travel Agency Service Fees"]
["Travel Documents"]
[]
[null,null,null,"**","Use this spreadsheet to reimburse non-employee's (eg. Retired faculty, visitors, students) for expenses they have incurred for University business"]

{"sheet":"SAMPLE Expense Report","index":1,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,0,48,20],[50,2,50,11],[45,0,45,1],[45,2,45,3],[45,4,45,8],[45,9,45,10],[45,17,45,19],[46,17,46,19],[43,2,43,3],[43,4,43,8],[43,9,43,10],[43,17,43,19],[44,0,44,1],[44,2,44,3],[44,4,44,8],[44,9,44,10],[44,17,44,19],[41,2,41,3],[41,4,41,8],[41,9,41,10],[41,17,41,19],[42,2,42,3],[42,4,42,8],[42,9,42,10],[42,17,42,19],[39,2,39,3],[39,4,39,8],[39,9,39,10],[39,17,39,19],[40,2,40,3],[40,4,40,8],[40,9,40,10],[40,17,40,19],[37,2,37,3],[37,4,37,8],[37,9,37,10],[37,17,37,19],[38,2,38,3],[38,4,38,8],[38,9,38,10],[38,17,38,19],[31,10,31,14],[35,2,35,3],[35,4,35,8],[35,17,35,19],[36,2,36,3],[36,4,36,8],[36,9,36,10],[36,17,36,19],[27,2,27,9],[28,2,28,9],[29,2,29,9],[30,8,30,9],[31,2,31,6],[31,7,31,8],[26,2,26,9],[10,15,10,16],[13,2,13,20],[16,2,16,9],[18,2,18,9],[19,2,19,9],[20,2,20,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[24,2,24,9],[25,2,25,9],[0,0,7,8],[7,11,7,13],[7,14,7,18],[7,19,10,19],[9,0,9,9],[9,11,9,17],[10,0,10,9],[10,11,10,12],[0,9,1,20],[2,9,6,20]]}
[null,null,null,null,null,null,null,null,null,"Accounts Payable, Travel"]
[]
[null,null,null,null,null,null,null,null,null,"Non-Employee Expense Reimbursement"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Date:",null,null,{"$f":"TODAY()","v":"2018-08-28"}]
[]
["Claimant's Name",null,null,null,null,null,null,null,null,null,null,"Travel Dates"]
["TOM SMITH",null,null,null,null,null,null,null,null,null,null,"From:",null,"2014-01-13",null,"To:",null,"2014-01-16"]
[]
[]
["Report Details and Location of Expense:",null,"ATTEND THE INSTITUTE OF FINANCE AND MANAGEMENT ACCOUNTS PAYABLE CONFERENCE AND EXPO IN CALGARY, ALBERTA"]
[]
[]
["Expense Detail - Click a blank space and select applicable expense type",null,"Expense Business Purpose / Relevance to Research Grant",null,null,null,null,null,null,null,null,"Foreign Amount",null,"Exchange Rate",null,"CDN Amount",null,"Total in CDN Funds",null,"HST Charged","GST Charged"]
[]
["Airfare - Domestic",null,"AIRFARE TO CALGARY",null,null,null,null,null,null,null,null,null,null,null,null,756.24,null,{"$f":"P19+(L19*N19)","v":756.24},null,null,38.590000000000003]
["Taxi  ",null,"TAXI TO AND FROM TORONTO AIRPORT",null,null,null,null,null,null,null,null,null,null,null,null,186,null,{"$f":"P20+(L20*N20)","v":186},null,9.81]
["Gratuitous Accommodation",null,"STAYED WITH RELATIVE",null,null,null,null,null,null,null,null,null,null,null,null,80,null,{"$f":"P21+(L21*N21)","v":80}]
["Meals with Receipts",null,"MEALS WHILE AT CONFERENCE",null,null,null,null,null,null,null,null,null,null,null,null,258.94,null,258.94,null,null,15.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Meals Per Diem Domestic",null,null,"B",null,"L",null,"D",null,null,null,null,null,null,null,{"$f":"(C31*17)+(E31*17)+(G31*17)","v":0},null,0,null,{"$f":"R31*13/113","v":0}]
["Car Mileage Domestic",null,null,null,null,null,null,null,null,"km ","Attach Mileage Log to support claim",null,null,null,null,{"$f":"H32*0.54","v":0},null,{"$f":"P32","v":0},null,{"$f":"R32*13/113","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals ",null,{"$f":"SUM(R19:R32)","v":1281.18},null,{"$f":"SUM(T19:T32)","v":9.81},{"$f":"SUM(U19:U30)","v":54.440000000000005}]
[]
[]
[null,null,"Fund",null,"Account",null,null,null,null,"Department",null,"Program",null,"Business Unit",null,"Project",null,"Activity",null,null,"Amount"]
[null,null,20,null,650000,null,null,null,null,12345,null,30000,null,"MAC01",null,null,null,null,null,null,{"$f":"R33-U45-U46","v":1237.4683630000002}]
[]
[]
["Chart Field String"]
[]
[]
[]
[]
["GST Rebate",null,20,null,"240210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U33*67%","v":36.474800000000002}]
["HST Rebate",null,20,null,"240200",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T33*73.77%","v":7.2368369999999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total to be Reimbursed",null,null,{"$f":"SUM(U37:U46)","v":1281.18}]
[]
["Declaration of Claimant:  I have read the University's published regulations on reimbursement of expenses and confirm that I am in compliance."]
[]
["Claimant:",null,{"$f":"A11","v":"TOM SMITH"},null,null,null,null,null,null,null,null,null,"Signature:"]

{"sheet":"Expense Report","index":2,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,0,48,20],[46,17,46,19],[50,1,50,11],[38,17,38,19],[39,17,39,19],[38,4,38,8],[39,4,39,8],[38,2,38,3],[38,9,38,10],[39,9,39,10],[39,2,39,3],[41,17,41,19],[42,17,42,19],[43,17,43,19],[43,9,43,10],[41,9,41,10],[36,17,36,19],[37,17,37,19],[40,17,40,19],[44,17,44,19],[45,17,45,19],[40,9,40,10],[44,9,44,10],[45,9,45,10],[44,0,44,1],[37,2,37,3],[40,2,40,3],[45,0,45,1],[44,2,44,3],[41,4,41,8],[43,4,43,8],[43,2,43,3],[42,2,42,3],[41,2,41,3],[42,9,42,10],[42,4,42,8],[36,2,36,3],[36,4,36,8],[35,4,35,8],[36,9,36,10],[31,10,31,14],[31,7,31,8],[31,2,31,6],[25,2,25,9],[23,2,23,9],[24,2,24,9],[22,2,22,9],[35,2,35,3],[30,8,30,9],[29,2,29,9],[7,19,10,19],[10,15,10,16],[10,0,10,9],[2,9,6,20],[0,9,1,20],[0,0,7,8],[10,11,10,12],[7,14,7,18],[7,11,7,13],[9,0,9,9],[9,11,9,17],[13,2,13,20],[45,2,45,3],[37,4,37,8],[40,4,40,8],[44,4,44,8],[45,4,45,8],[37,9,37,10],[35,17,35,19],[16,2,16,9],[18,2,18,9],[19,2,19,9],[20,2,20,9],[26,2,26,9],[27,2,27,9],[28,2,28,9],[21,2,21,9]]}
[null,null,null,null,null,null,null,null,null,"Accounts Payable, Travel"]
[]
[null,null,null,null,null,null,null,null,null,"Non-Employee Expense Reimbursement"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Date:",null,null,{"$f":"TODAY()","v":"2018-08-28"}]
[]
["Claimant's Name",null,null,null,null,null,null,null,null,null,null,"Travel Dates"]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,null,null,"To:"]
[]
[]
["Report Details and Location of Expense:"]
[]
[]
["Expense Detail - Click a blank space and select applicable expense type",null,"Expense Business Purpose / Relevance to Research Grant",null,null,null,null,null,null,null,null,"Foreign Amount",null,"Exchange Rate",null,"CDN Amount",null,"Total in CDN Funds",null,"HST Charged","GST Charged"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P19+(L19*N19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P20+(L20*N20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P21+(L21*N21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Meals Per Diem Domestic",null,null,"B",null,"L",null,"D",null,null,null,null,null,null,null,{"$f":"(C31*17)+(E31*17)+(G31*17)","v":0},null,0,null,{"$f":"R31*13/113","v":0}]
["Car Mileage Domestic",null,null,null,null,null,null,null,null,"km ","Attach Mileage Log to support claim",null,null,null,null,{"$f":"H32*0.55","v":0},null,{"$f":"P32","v":0},null,{"$f":"R32*13/113","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals ",null,{"$f":"SUM(R19:R32)","v":0},null,{"$f":"SUM(T19:T32)","v":0},{"$f":"SUM(U19:U30)","v":0}]
[]
[]
[null,null,"Fund",null,"Account",null,null,null,null,"Department",null,"Program",null,"Business Unit",null,"Project",null,"Activity",null,null,"Amount"]
[]
[]
[]
["Chart Field String"]
[]
[]
[]
[]
["GST Rebate",null,20,null,"240210",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U33*67%","v":0}]
["HST Rebate",null,20,null,"240200",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T33*73.77%","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total to be Reimbursed",null,null,{"$f":"SUM(U37:U46)","v":0}]
[]
["Declaration of Claimant:  I have read the University's published regulations on reimbursement of expenses and confirm that I am in compliance."]
[]
["Claimant:",{"$f":"A11","v":0},null,null,null,null,null,null,null,null,null,null,"Signature:"]