{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Reimbursement Form - Dashboard","Summary","Canada (1)","Canada (2)","Other Countries (1)","Other Countries (2)","Checklist","Commonly used Accounts","Expense Type Glossary","Per Diem & Allowances","Lost Receipt Form","Advance Repayment Form","Wire Transfer Request","Prize Hospitality Log","Working Tab"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":110,"comments":4,"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":"Reimbursement Form - Dashboard","index":0,"n_rows":30,"n_cols":24,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,28],[22,3,24,7],[5,20,5,28],[6,23,8,27],[10,23,12,27],[14,23,16,27],[18,23,20,27],[22,23,24,27],[6,3,8,7],[5,0,5,8],[2,0,2,28],[10,3,12,7],[14,3,16,7],[18,3,20,7],[6,13,8,17],[10,13,12,17],[14,13,16,17],[18,13,20,17],[5,10,5,18],[3,0,3,28],[4,0,4,28]]}
["Reimbursement Form Dashboard\n\nIf you incur business related expenditures, such as travel costs, mileage, hospitality, supplies, etc., you may request reimbursement by completing this Reimbursement form and attaching the original receipts, along with the supporting documentation."]
[]
["To navigate the Reimbursement workbook, click on the buttons below to move to the corresponding tab.\n\nNew to the Reimbursement Form process? \nWe recommended you begin by reviewing the Checklist and the Reimbursement Form Quick Reference Guide. \nThe Checklist outlines the necessary steps required to complete the Reimbursement form. From the Supplementary Support area below, click on the Checklist button.\nThe Quick Reference Guide (QRG), provides an overview based on the policies and procedures of the University. \n\n"]
["Click here to be redirected to the downloadable QRG."]
["Returning User?\nClick on the Summary button below to be redirected to the Summary tab to begin completing your reimbursement form. "]
["Forms to Complete and Print",null,null,null,null,null,null,null,null,null,"Supporting Documentation",null,null,null,null,null,null,null,null,null,"Supplementary Support"]
[null,null,null,"Enter the \"Claimant\" name, Banner A# ID, Date of travel/ expense, FOAP and Authorization Signature(s) etc. ",null,null,null,null,null,null,null,null,null,"Complete this form if you are missing an original receipt to support your claim. ",null,null,null,null,null,null,null,null,null,"View the Checklist to ensure you have completed and included the necessary information for reimbursement."]
[]
[]
[]
[null,null,null,"Enter expenses incurred within Canada or Travel Expenses paid in Canadian currency.",null,null,null,null,null,null,null,null,null,"Complete this form if you were advanced more money than the expense that you incurred.",null,null,null,null,null,null,null,null,null,"View a list of Commonly Used Accounts to help you choose the correct Fund, Org, Account, Program (FOAP)."]
[]
[]
[]
[null,null,null,"Enter expenses incurred within Canada or Travel Expenses paid in Canadian currency.",null,null,null,null,null,null,null,null,null,"Complete this form if you require reimbursement in a currency other than that of Canadian or US.",null,null,null,null,null,null,null,null,null,"View the Expense Type definitions to help you select the appropriate drop-down selection when completing your reimbursement form."]
[]
[]
[]
[null,null,null,"Enter expenses incurred in other currencies including US currency.",null,null,null,null,null,null,null,null,null,"Complete this form if you have purchased gift cards, prizes or used to log hospitality expenses.",null,null,null,null,null,null,null,null,null,"View the per diems and allowance rates."]
[]
[]
[]
[null,null,null,"Enter expenses incurred in other currencies including US currency.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this tab if you want to use the features of excel to calculate your expenditures."]
[]
[]
[]
["Need help? ",null,null,null,null,"Need Training?",null,null,null,null,"Need Excel Support?"]
["Contact Procure to Pay at:",null,null,null,null,"Contact Procure to Pay at:",null,null,null,null,"Contact Software & Application Support Centre:"]
["902.420.5054",null,null,null,null,"902.420.5054",null,null,null,null,"sas@smu.ca"]
["procuretopay@smu.ca",null,null,null,null,"procuretopay@smu.ca"]

{"sheet":"Summary","index":1,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[20,2,21,7],[14,3,14,7],[11,2,11,3],[16,3,16,7],[15,3,15,7],[13,6,13,7],[13,2,13,5],[0,0,3,1],[4,1,11,1],[4,0,11,0],[0,5,1,10],[9,2,9,3],[8,2,8,3],[10,2,10,3],[4,2,4,3],[0,2,1,4],[5,6,5,8],[4,9,4,14],[5,9,5,14],[0,11,0,14],[1,11,1,14],[6,2,7,3],[5,4,5,5],[31,8,32,13],[2,9,2,12],[3,9,3,12],[2,13,2,14],[3,13,3,14],[31,14,32,14],[18,14,19,14],[27,9,27,13],[29,8,30,13],[28,9,28,13],[18,10,19,13],[18,8,19,9],[6,9,7,14],[8,9,11,14],[26,8,26,13],[12,8,12,14],[26,1,32,1],[26,0,32,0],[12,1,19,1],[12,0,19,0],[20,1,25,1],[20,0,25,0],[26,2,26,3],[25,6,25,7],[30,6,30,7],[31,4,31,5],[30,4,30,5],[46,2,46,3],[45,2,45,3],[17,3,17,7],[18,3,18,7],[31,6,31,7],[31,2,31,3],[30,2,30,3],[26,6,26,7],[25,2,25,3],[22,2,22,7],[27,2,29,7],[25,4,26,5],[23,2,24,7],[32,2,32,3],[32,4,32,5],[32,6,32,7],[5,2,5,3],[4,4,4,5],[2,6,2,8],[3,6,3,8],[2,2,2,5],[3,2,3,5],[4,6,4,8]]}
["For P2P Only",null,null,null,null,"Reimbursement Form",null,null,null,null,null,"Reference # E (MMMDDYY)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"E\",$M$65)","v":"EJan0000"}]
[null,null,"Claimant Name: ",null,null,null,"Banner ID (A Number) Ex.A12345678",null,null,"Department",null,null,null,"Phone / Ext #"]
[]
[null,"Processed by","From (dd-mmm-yy)",null,"To (dd-mmm-yy)",null,"Email",null,null,"Address & Postal Code (For external mailing only)"]
[]
[null,null,"Claim Log Summary",null,"Canada (1)","Canada (2)","Other Countries (1)","Other Countries (2)","Total claim","Description of Expense / Destination (City & Country)"]
[null,null,null,null," CAD $"," CAD $"," CAD $"," CAD $"," CAD $"]
[null,null,"Travel",null,{"$f":"SUMIF('Canada (1)'!P:P,Summary!$C9,'Canada (1)'!T:T)","v":0},{"$f":"SUMIF('Canada (2)'!P:P,Summary!$C9,'Canada (2)'!T:T)","v":0},{"$f":"SUMIF('Other Countries (1)'!R:R,Summary!$C9,'Other Countries (1)'!T:T)","v":0},{"$f":"SUMIF('Other Countries (2)'!R:R,Summary!$C9,'Other Countries (2)'!T:T)","v":0},{"$f":"SUM(E9:H9)","v":0}]
[null,null,"Hospitality",null,{"$f":"SUMIF('Canada (1)'!P:P,Summary!$C10,'Canada (1)'!T:T)","v":0},{"$f":"SUMIF('Canada (2)'!P:P,Summary!$C10,'Canada (2)'!T:T)","v":0},{"$f":"SUMIF('Other Countries (1)'!R:R,Summary!$C10,'Other Countries (1)'!T:T)","v":0},{"$f":"SUMIF('Other Countries (2)'!R:R,Summary!$C10,'Other Countries (2)'!T:T)","v":0},{"$f":"SUM(E10:H10)","v":0}]
[null,null,"Other",null,{"$f":"SUMIF('Canada (1)'!P:P,Summary!$C11,'Canada (1)'!T:T)","v":0},{"$f":"SUMIF('Canada (2)'!P:P,Summary!$C11,'Canada (2)'!T:T)","v":0},{"$f":"SUMIF('Other Countries (1)'!R:R,Summary!$C11,'Other Countries (1)'!T:T)","v":0},{"$f":"SUMIF('Other Countries (2)'!R:R,Summary!$C11,'Other Countries (2)'!T:T)","v":0},{"$f":"SUM(E11:H11)","v":0}]
[null,null,"Total",null,{"$f":"ROUND(SUM(E9:E11),2)","v":0},{"$f":"ROUND(SUM(F9:F11),2)","v":0},{"$f":"ROUND(SUM(G9:G11),2)","v":0},{"$f":"ROUND(SUM(H9:H11),2)","v":0},{"$f":"ROUND(SUM(I9:I11),2)","v":0}]
[null,"Posted by","Do these expenses relate to a NSERC / SSHRC /CIHR grant? (Choose below)",null,null,null,null,null,"Accounting Information (See Tab Commonly used Accounts for details)"]
[null,null,null,null,null,null,"If yes answer questions below.",null,"Fund (6)","Org (4)  "," Acct (5)","Prog (4)","Pre-Tax","Tax","$ Total"]
[null,null,null,"Participation in Conference (attach invitation showing dates of event, registration receipt and copy of the first page of the program).",null,null,null,null,null,null,null,null,{"$f":"+O15-N15","v":{"$error":"#DIV/0!"}},{"$f":"+O15*$O$32/$O$19","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K15=78699,\"Error! Incorrect Account\",IF(K15=73550,\"Error! Incorrect Account\",IF($K15>49999,IF($K15<60000,\"Error! Incorrect Account\",IF($K15>59999,IF($K15<70000,\"Error! Incorrect Account\",IF($K15>79999,IF($K15<99999,\"Error! Incorrect Account\",\"Good\"))))))))","v":false}]
[null,null,null,"Field Trip (provide details on activities, dates etc.).",null,null,null,null,null,null,null,null,{"$f":"+O16-N16","v":{"$error":"#DIV/0!"}},{"$f":"+O16*$O$32/$O$19","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K16=78699,\"Error! Incorrect Account\",IF(K16=73550,\"Error! Incorrect Account\",IF($K16>49999,IF($K16<60000,\"Error! Incorrect Account\",IF($K16>59999,IF($K16<70000,\"Error! Incorrect Account\",IF($K16>79999,IF($K16<99999,\"Error! Incorrect Account\",\"Good\"))))))))","v":false}]
[null,null,null,"Consultation with Colleagues (provide the name or organization, and dates).",null,null,null,null,null,null,null,null,{"$f":"+O17-N17","v":{"$error":"#DIV/0!"}},{"$f":"+O17*$O$32/$O$19","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K17=78699,\"Error! Incorrect Account\",IF(K17=73550,\"Error! Incorrect Account\",IF($K17>49999,IF($K17<60000,\"Error! Incorrect Account\",IF($K17>59999,IF($K17<70000,\"Error! Incorrect Account\",IF($K17>79999,IF($K17<99999,\"Error! Incorrect Account\",\"Good\"))))))))","v":false}]
[null,null,null,"Other (provide the purpose and on how the expenses relate to the research).",null,null,null,null,null,null,null,null,{"$f":"+O18-N18","v":{"$error":"#DIV/0!"}},{"$f":"+O18*$O$32/$O$19","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K18=78699,\"Error! Incorrect Account\",IF(K18=73550,\"Error! Incorrect Account\",IF($K18>49999,IF($K18<60000,\"Error! Incorrect Account\",IF($K18>59999,IF($K18<70000,\"Error! Incorrect Account\",IF($K18>79999,IF($K18<99999,\"Error! Incorrect Account\",\"Good\"))))))))","v":false}]
[null,null,null,"If claimant other than grantee provide affiliation with the grantees research.",null,null,null,null,"Total Reimbursable Expense",null,{"$f":"IF(O19=I12,\" \",\"Out of Balance\")","v":" "},null,null,null,{"$f":"SUM(O15:O18)","v":0}]
[null,null,"Field Trip / Consultation / Conference (Please provide details)"]
[null,"Posting Date",null,null,null,null,null,null,"Less Advance: Either 78699 (Travel Advances Others) or 73550 (Travel Advances Faculty)"]
[null,null,null,null,null,null,null,null,"Fund (6)","Org (4)  "," Acct (5)","Prog (4)",null,null,"$ Total"]
[null,null,"Claimant Certification"]
[null,null,"I certify that I have personally incurred and paid for the expenses, that all supporting receipts and documents are attached, that expenses comply with University and Granting Agency policies, and that the amounts claimed have not previously been, nor will be, claimed or reimbursed by Saint Mary’s University or any other party."]
[]
[null,null,"Date (dd-mmm-yy)",null,"Claimant (Signature)",null,"Claimant Name (Print)"]
[null,"Document No",{"$f":"TODAY()","v":"2022-09-21"},null,null,null,{"$f":"+Name","v":0},null,"Total Advance",null,null,null,null,null,{"$f":"SUM(O23:O26)","v":0}]
[null,null,"Authorization (I certify that I have reviewed and approved this claim and expenses are appropriate, reasonable and in accordance with University and Granting Agency policies.)",null,null,null,null,null,"Due Claimant","Currency other than CAD or USD, fill out a Wire Transfer Form",null,null,null,null,{"$f":"IF(O19<O27,0,O19-O27)","v":0}]
[null,null,null,null,null,null,null,null,"Due University","For amount due to University, fill out an Advance Repayment Form",null,null,null,null,{"$f":"IF(O19<O27, O27-O19, 0)","v":0}]
[null,null,null,null,null,null,null,null,"Notes section for Claimant / Approver: "]
[null,null,"Date (dd-mmm-yy)",null,"Approver (Signature)",null,"Approver Name (Print)",null,null,null,null,null,null,null,"Tax"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Canada (1)'!G41+'Canada (2)'!G41","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TEXT($C$6,\"MMM\")","v":"Jan"},{"$f":"TEXT($C$6,\"DD\")","v":"00"},{"$f":"TEXT($C$6,\"YY\")","v":"00"},{"$f":"CONCATENATE(J65,K65,L65)","v":"Jan0000"}]

{"sheet":"Canada (1)","index":2,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,8,8,10],[41,2,41,6],[3,4,3,6],[4,0,4,2],[0,0,0,6],[40,1,40,4],[6,4,8,4],[6,5,7,6],[1,1,1,6],[3,1,3,2],[5,4,5,6],[4,4,4,6],[7,3,8,3]]}
["Saint Mary's University - Expenditure Log Canada"]
[]
["Banner ID","Name",null,"Department","Phone"]
[{"$f":"+Summary!G4","v":0},{"$f":"+Name","v":0},null,{"$f":"+Summary!J4","v":0},{"$f":"+Summary!N4","v":0}]
["Country",null,null,"Currency","Lost Receipt Form Link"]
["Canada (1)",null,null,"CAD Dollar","Google Maps Link",null,null,null,"To clear contents of sheet, please click on Fix Formulas."]
["#","Date","Expense","Description","Province","Cost Including Tax",null,null,"Per Diem Link"]
["Receipt","(DD-MMM-YY)","Type","(provide detailed expense information, including: mileage and per diem details, if applicable)",null,null,null,null,"Gift Card / Prize Log"]
["Number",null,"(Please use drop down)",null,null,"Total Cost","Tax",null,"Error Message",null,null,null,null,null,null,"Type","Expense Type","NS","Other Province"]
["Main",null,null,null,null,null,{"$f":"+IF(C10=0,0,SUMIF($R$9:$S$9,$E10,INDEX($R$10:$S$41,MATCH($C10,$Q$10:$Q$41,0),0))*F10)","v":0},null,{"$f":"IF(F10>0,IF(B10=0,\"Provide Date\"))","v":false},null,null,null,null,null,null,"Travel","Accommodation",0.12280701754385964,3.8461538461538464E-2,{"$f":"SUMIF($C$11:$C$40,Q10,$F$11:$F$40)","v":0}]
["C.1.1",null,null,null,null,null,{"$f":"+IF(C11=0,0,SUMIF($R$9:$S$9,$E11,INDEX($R$10:$S$41,MATCH($C11,$Q$10:$Q$41,0),0))*F11)","v":0},null,{"$f":"IF(F11>0,IF(B11=0,\"Provide Date\"))","v":false},{"$f":"IF(L11=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(M11=FALSE,\"Provide Province\",0)","v":0},{"$f":"IF($F11>0,ISTEXT(C11),0)","v":0},{"$f":"IF($F11>0,ISTEXT(E11),0)","v":0},null,null,"Other","Advertisement Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.2",null,null,null,null,null,0,null,{"$f":"IF(F12>0,IF(B12=0,\"Provide Date\"))","v":false},{"$f":"IF(L12=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(M12=FALSE,\"Provide Province\",0)","v":0},{"$f":"IF($F12>0,ISTEXT(C12),0)","v":0},{"$f":"IF($F12>0,ISTEXT(E12),0)","v":0},null,null,"Travel","Airfare - Canada to US",3.8461538461538464E-2,3.8461538461538464E-2,0]
["C.1.3",null,null,null,null,null,0,null,{"$f":"IF(F13>0,IF(B13=0,\"Provide Date\"))","v":false},{"$f":"IF(L13=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(M13=FALSE,\"Provide Province\",0)","v":0},0,0,null,null,"Travel","Airfare - to/from location outside Canada & US",0,0,0]
["C.1.4",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Airfare within Canada departing NS",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.5",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Airfare within Canada departing outside NS",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.6",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Baggage Fee",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.7",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Event Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.8",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Faculty Recruitment Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.9",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Gas Charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.10",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Gift Cards / Prizes",0,0,0]
["C.1.11",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Hospitality","Hospitality Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.12",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Membership Cost - Taxable",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.13",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Membership Cost - Non Taxable",0,0,0]
["C.1.14",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Medical Insurance",0,0,0]
["C.1.15",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Mileage",0.13043478260869565,4.7619047619047616E-2,0]
["C.1.16",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Minor Equipment",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.17",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Mobile charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.18",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Others - Non Taxable",0,0,0]
["C.1.19",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Others - Taxable",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.20",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Parking",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.21",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Per Diem",0.13043478260869565,4.7619047619047616E-2,0]
["C.1.22",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Per Diem (Varsity Athlete - Game Day)",0.13043478260869565,4.7619047619047616E-2,0]
["C.1.23",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Professional Development Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.24",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Registration fees",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.25",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Relocation Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.26",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Software Charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.27",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Subscription Charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.28",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Supplies or Services",0.12280701754385964,3.8461538461538464E-2,0]
["C.1.29",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Toll Charges",0,0,0]
["C.1.30",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Transportation Other Than Airfare",0.12280701754385964,3.8461538461538464E-2,0]
[null,"Grand Total   CAD $",null,null,null,{"$f":"ROUND(SUM(F11:F40),2)","v":0},{"$f":"ROUND(SUM(G11:G40),2)","v":0},null,null,null,null,null,null,null,null,"Travel","Varsity Athlete - Game Day Meal",0.12280701754385964,3.8461538461538464E-2,0]
[null,"Notes:"]

{"sheet":"Canada (2)","index":3,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,2,41,6],[0,0,0,6],[1,1,1,6],[3,1,3,2],[3,4,3,6],[4,0,4,2],[4,4,4,6],[7,3,8,3],[8,8,8,10],[5,4,5,6],[6,4,8,4],[6,5,7,6],[40,1,40,4]]}
["Saint Mary's University - Expenditure Log Canada"]
[]
["Banner ID","Name",null,"Department","Phone"]
[{"$f":"+Summary!G4","v":0},{"$f":"+Name","v":0},null,{"$f":"+Summary!J4","v":0},{"$f":"+Summary!N4","v":0}]
["Country",null,null,"Currency","Lost Receipt Form Link"]
["Canada (2)",null,null,"CAD Dollar","Google Maps Link",null,null,null,"To clear contents of sheet, please click on Fix Formulas."]
["#","Date","Expense","Description","Province","Cost Including Tax",null,null,"Per Diem Link"]
["Receipt","(DD-MMM-YY)","Type","(provide detailed expense information, including: mileage and per diem details, if applicable)",null,null,null,null,"Gift card / Prize Log"]
["Number",null,"(Please use drop down)",null,null,"Total Cost","Tax",null,"Error Message",null,null,null,null,null,null,"Type","Expense Type","NS","Other Province"]
["Main",null,null,null,null,null,{"$f":"+IF(C10=0,0,SUMIF($R$9:$S$9,$E10,INDEX($R$10:$S$41,MATCH($C10,$Q$10:$Q$41,0),0))*F10)","v":0},null,{"$f":"IF(F10>0,IF(B10=0,\"Provide Date\"))","v":false},null,null,null,null,null,null,"Travel","Accommodation",0.12280701754385964,3.8461538461538464E-2,{"$f":"SUMIF($C$11:$C$40,Q10,$F$11:$F$40)","v":0}]
["C.2.1",null,null,null,null,null,{"$f":"+IF(C11=0,0,SUMIF($R$9:$S$9,$E11,INDEX($R$10:$S$41,MATCH($C11,$Q$10:$Q$41,0),0))*F11)","v":0},null,false,{"$f":"IF(L11=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(M11=FALSE,\"Provide Province\",0)","v":0},{"$f":"IF($F11>0,ISTEXT(C11),0)","v":0},{"$f":"IF($F11>0,ISTEXT(E11),0)","v":0},null,null,"Other","Advertisement Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.2",null,null,null,null,null,0,null,false,0,0,{"$f":"IF($F12>0,ISTEXT(C12),0)","v":0},{"$f":"IF($F12>0,ISTEXT(E12),0)","v":0},null,null,"Travel","Airfare - Canada to US",3.8461538461538464E-2,3.8461538461538464E-2,0]
["C.2.3",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Airfare - to/from location outside Canada & US",0,0,0]
["C.2.4",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Airfare within Canada departing NS",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.5",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Airfare within Canada departing outside NS",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.6",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Baggage Fee",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.7",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Event Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.8",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Faculty Recruitment Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.9",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Gas Charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.10",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Gift Cards / Prizes",0,0,0]
["C.2.11",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Hospitality","Hospitality Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.12",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Membership Cost - Taxable",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.13",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Membership Cost - Non Taxable",0,0,0]
["C.2.14",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Medical Insurance",0,0,0]
["C.2.15",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Mileage",0.13043478260869565,4.7619047619047616E-2,0]
["C.2.16",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Minor Equipment",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.17",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Mobile charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.18",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Others - Non Taxable",0,0,0]
["C.2.19",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Others - Taxable",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.20",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Parking",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.21",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Per Diem",0.13043478260869565,4.7619047619047616E-2,0]
["C.2.22",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Per Diem (Varsity Athlete - Game Day)",0.13043478260869565,4.7619047619047616E-2,0]
["C.2.23",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Professional Development Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.24",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Registration fees",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.25",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Relocation Expenses",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.26",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Software Charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.27",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Subscription Charges",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.28",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Other","Supplies or Services",0.12280701754385964,3.8461538461538464E-2,0]
["C.2.29",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Toll Charges",0,0,0]
["C.2.30",null,null,null,null,null,0,null,false,0,0,0,0,null,null,"Travel","Transportation Other Than Airfare",0.12280701754385964,3.8461538461538464E-2,0]
[null,"Grand Total   CAD $",null,null,null,{"$f":"ROUND(SUM(F11:F40),2)","v":0},{"$f":"ROUND(SUM(G11:G40),2)","v":0},null,null,null,null,null,null,null,null,"Travel","Varsity Athlete - Game Day Meal",0.12280701754385964,3.8461538461538464E-2,0]
[null,"Notes:"]

{"sheet":"Other Countries (1)","index":4,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,2,41,7],[7,8,7,11],[6,4,7,4],[40,1,40,4],[0,0,0,7],[5,5,6,7],[3,1,3,3],[4,6,4,7],[4,3,4,4],[4,0,4,2]]}
["Saint Mary's University - Expenditure Log Other Countries "]
[]
["Banner ID","Name",null,null,"Department","Phone",null,null,null,"To clear contents of sheet, please click on Fix Formulas."]
[{"$f":"+Summary!G4","v":0},{"$f":"+Summary!C4","v":0},null,null,{"$f":"+Summary!J4","v":0},{"$f":"+Summary!N4","v":0}]
["International Per Diem Rate Link",null,null,"Oanda Website Link Conversion Rate",null,"US Per Diem Link","Google Maps Link"]
["#","Date","Country","Expense","Description","Converted Amount"]
["Receipt","(DD-MMM-YY)","of travel","Type","(provide detailed expense information, including: mileage and per diem details, if applicable)"]
["Number",null,null,"(Please use drop down)",null,"Cost (Local Curr)","Conversion Rate","Cost (CAD)","Error Message"]
[]
["Main",null,null,null,null,null,null,{"$f":"+F10*G10","v":0},null,{"$f":"IF($F10>0,IF(B10=0,\"Provide Date\"))","v":false},{"$f":"IF(M10=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(N10=FALSE,\"Provide Conversion Rate\",0)","v":0},{"$f":"IF($F10>0,ISTEXT(D10),0)","v":0},{"$f":"IF($F10>0,ISNUMBER(G10),0)","v":0}]
["O.1.1",null,null,null,null,null,null,{"$f":"+F11*G11","v":0},{"$f":"IF($F11>0,IF(C11=0,\"Provide Country\"))","v":false},{"$f":"IF($F11>0,IF(B11=0,\"Provide Date\"))","v":false},{"$f":"IF(M11=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(N11=FALSE,\"Provide Conversion Rate\",0)","v":0},{"$f":"IF($F11>0,ISTEXT(D11),0)","v":0},{"$f":"IF($F11>0,ISNUMBER(G11),0)","v":0},null,null,null,"Type","Expense Type"]
["O.1.2",null,null,null,null,null,null,0,{"$f":"IF($F12>0,IF(C12=0,\"Provide Country\"))","v":false},false,0,0,{"$f":"IF($F12>0,ISTEXT(D12),0)","v":0},{"$f":"IF($F12>0,ISNUMBER(G12),0)","v":0},null,null,null,"Travel","Accommodation",{"$f":"SUMIF($D$11:$D$40,S12,$H$11:$H$40)","v":0}]
["O.1.3",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Advertisement Expenses",{"$f":"SUMIF($D$11:$D$40,S13,$H$11:$H$40)","v":0}]
["O.1.4",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare - Canada to US",0]
["O.1.5",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare - to/from location outside Canada & US",0]
["O.1.6",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare within Canada departing NS",0]
["O.1.7",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare within Canada departing outside NS",0]
["O.1.8",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Baggage Fee",0]
["O.1.9",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Event Expenses",0]
["O.1.10",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Faculty Recruitment Expenses",0]
["O.1.11",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Gas Charges",0]
["O.1.12",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Gift Cards / Prizes",0]
["O.1.13",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Hospitality","Hospitality Expenses",0]
["O.1.14",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Membership Cost - Taxable",0]
["O.1.15",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Membership Cost - Non Taxable",0]
["O.1.16",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Medical Insurance",0]
["O.1.17",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Mileage",0]
["O.1.18",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Minor Equipment",0]
["O.1.19",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Mobile charges",0]
["O.1.20",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Others - Non Taxable",0]
["O.1.21",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Others - Taxable",0]
["O.1.22",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Parking",0]
["O.1.23",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Per Diem",0]
["O.1.24",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Per Diem (Varsity Athlete - Game Day)",0]
["O.1.25",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Professional Development Expenses",0]
["O.1.26",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Registration fees",0]
["O.1.27",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Relocation Expenses",0]
["O.1.28",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Software Charges",0]
["O.1.29",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Subscription Charges",0]
["O.1.30",null,null,null,null,null,null,0,false,false,null,null,0,0,null,null,null,"Other","Supplies or Services",0]
[null,"Grand Total CAD$",null,null,null,null,null,{"$f":"SUM(H11:H40)","v":0},null,null,null,null,null,null,null,null,null,"Travel","Toll Charges",0]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel","Transportation Other Than Airfare",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel","Varsity Athlete - Game Day Meal",0]

{"sheet":"Other Countries (2)","index":5,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,8,7,11],[6,4,7,4],[41,2,41,7],[0,0,0,7],[3,1,3,3],[4,6,4,7],[5,5,6,7],[40,1,40,4],[4,0,4,2],[4,3,4,4]]}
["Saint Mary's University - Expenditure Log Other Countries "]
[]
["Banner ID","Name",null,null,"Department","Phone",null,null,null,"To clear contents of sheet, please click on Fix Formulas."]
[{"$f":"+Summary!G4","v":0},{"$f":"+Summary!C4","v":0},null,null,{"$f":"+Summary!J4","v":0},{"$f":"+Summary!N4","v":0}]
["International Per Diem Rate Link",null,null,"Oanda Website Link Conversion Rate",null,"US Per Diem Link","Google Maps Link"]
["#","Date","Country","Expense","Description","Converted Amount"]
["Receipt","(DD-MMM-YY)","of travel","Type","(provide detailed expense information, including: mileage and per diem details, if applicable)"]
["Number",null,null,"(Please use drop down)",null,"Cost (Local Curr)","Conversion Rate","Cost (CAD)","Error Message"]
[]
["Main",null,null,null,null,null,null,{"$f":"+F10*G10","v":0},null,null,null,null,{"$f":"IF($F10>0,ISTEXT(D10),0)","v":0},{"$f":"IF($F10>0,ISNUMBER(G10),0)","v":0}]
["O.2.1",null,null,null,null,null,null,{"$f":"+F11*G11","v":0},{"$f":"IF($F11>0,IF(C11=0,\"Provide Country\"))","v":false},{"$f":"IF($F11>0,IF(B11=0,\"Provide Date\"))","v":false},{"$f":"IF(M11=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(N11=FALSE,\"Provide Conversion Rate\",0)","v":0},{"$f":"IF($F11>0,ISTEXT(D11),0)","v":0},{"$f":"IF($F11>0,ISNUMBER(G11),0)","v":0}]
["O.2.2",null,null,null,null,null,null,0,{"$f":"IF($F12>0,IF(C12=0,\"Provide Country\"))","v":false},{"$f":"IF($F12>0,IF(B12=0,\"Provide Date\"))","v":false},{"$f":"IF(M12=FALSE,\"Provide Expense Type\",0)","v":0},{"$f":"IF(N12=FALSE,\"Provide Conversion Rate\",0)","v":0},{"$f":"IF($F12>0,ISTEXT(D12),0)","v":0},{"$f":"IF($F12>0,ISNUMBER(G12),0)","v":0},null,null,null,"Type","Expense Type"]
["O.2.3",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Accommodation",{"$f":"SUMIF($D$11:$D$40,S13,$H$11:$H$40)","v":0}]
["O.2.4",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Advertisement Expenses",{"$f":"SUMIF($D$11:$D$40,S14,$H$11:$H$40)","v":0}]
["O.2.5",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare - Canada to US",0]
["O.2.6",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare - to/from location outside Canada & US",0]
["O.2.7",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare within Canada departing NS",0]
["O.2.8",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Airfare within Canada departing outside NS",0]
["O.2.9",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Baggage Fee",0]
["O.2.10",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Event Expenses",0]
["O.2.11",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Faculty Recruitment Expenses",0]
["O.2.12",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Gas Charges",0]
["O.2.13",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Gift Cards / Prizes",0]
["O.2.14",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Hospitality","Hospitality Expenses",0]
["O.2.15",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Membership Cost - Taxable",0]
["O.2.16",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Membership Cost - Non Taxable",0]
["O.2.17",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Medical Insurance",0]
["O.2.18",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Mileage",0]
["O.2.19",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Minor Equipment",0]
["O.2.20",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Mobile charges",0]
["O.2.21",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Others - Non Taxable",0]
["O.2.22",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Others - Taxable",0]
["O.2.23",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Parking",0]
["O.2.24",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Per Diem",0]
["O.2.25",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Travel","Per Diem (Varsity Athlete - Game Day)",0]
["O.2.26",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Professional Development Expenses",0]
["O.2.27",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Registration fees",0]
["O.2.28",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Relocation Expenses",0]
["O.2.29",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Software Charges",0]
["O.2.30",null,null,null,null,null,null,0,false,false,0,0,0,0,null,null,null,"Other","Subscription Charges",0]
[null,"Grand Total   CAD $",null,null,null,null,null,{"$f":"ROUND(SUM(H11:H40),2)","v":0},null,null,null,null,null,null,null,null,null,"Other","Supplies or Services",0]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel","Toll Charges",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel","Transportation Other Than Airfare",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel","Varsity Athlete - Game Day Meal",0]

{"sheet":"Checklist","index":6,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,2,25,11],[12,0,12,11],[7,0,11,11],[6,0,6,11],[24,2,24,11],[21,2,21,11],[22,2,22,11],[23,2,23,11],[20,2,20,11],[15,2,15,11],[13,2,13,11],[14,2,14,11],[16,2,16,11],[18,2,18,11],[19,2,19,11],[17,2,17,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
["Guidelines"]
["It is both the Claimant and Approver’s responsibility to ensure that the expenses have been incurred for legitimate university business purposes, as well as reasonable and appropriate.\n\nThe claim meets the terms and conditions imposed by the funding source from which they are paid; Granting Agency Policy/Guidelines, University's policy or Divisional/Departmental policy whichever imposes the greater restrictions.\n\nThe claim is supported by original itemized receipts. Exceptions: mileage, per diems. If you do not have the original receipt complete the lost receipt form. Ensure receipts in foreign languages are translated, with any necessary clarifications. If proof of payment is not indicated on the original receipt, a copy of credit card statement may be required (e.g., Airfare, Conference Registration fees).\n\nReimbursement forms that are incomplete, or require additional information will be returned to the Approver for clarification, explanations, and/or additional supporting documentation. Therefore the Claimant should ensure that a complete, accurate and dully supported reimbursement form is submitted for approval."]
[]
[]
[]
[]
["Checklist for Claimant / Approver",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[1,null,"Complete Summary Form (including Date, Claimant Banner A#, FOAP, Advance, Signature, Granting Agency Questions etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[2,null,"Complete Canada tab(s) for expenses / travel incurred within Canada"]
[3,null,"Complete Other Countries tab(s) for international travel / expenses incurred for travel to all other countries outside of Canada, regardless of currency being used."]
[4,null,"Attach all original supporting documentation including proof of payment (Lost/Missing Receipt Form required when original documents cannot be provided)"]
[5,null,"Attach copy of Google Maps if claiming Mileage and detailed description of places visited and purpose of trip(s)"]
[6,null,"Provide Per Diem details and attach supporting document if International per diem"]
[7,null,"Attach copy of exchange rates documentation"]
[8,null,"Sign Summary Form"]
[9,null,"Attach approved copy of the Lost Receipt Form if applicable"]
[10,null,"Attach cheque payable to Saint Mary's University with completed Advance Repayment Form, if applicable"]
[11,null,"Attach completed Wire Transfer Request Form for reimbursement in currency other than CAD / USD, if applicable"]
[12,null,"Keep an electronic copy of this report until reimbursed / payment to University processed"]
[13,null,"APPROVER TO DO:"]

{"sheet":"Commonly used Accounts","index":7,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":false,"merged":[[39,0,39,3],[41,0,41,3],[45,0,45,3],[53,0,53,3],[13,0,13,3],[16,0,16,3],[18,0,18,3],[24,0,24,3],[27,0,27,3],[0,0,0,3],[1,0,1,3],[4,0,4,3],[6,0,6,3],[10,0,10,3]]}
["Saint Mary's University"]
["Commonly Used Account Codes"]
[]
["Budget Classification","Account","Description","Definition/examples of items to be charged to this account"]
["Advertising and Promotions"]
[null,75000,"Advertising and promotion ","Marketing, advertising or promotion costs"]
["Communications"]
[null,75150,"Telephone ","Long distance calls / cell phone charges"]
[null,75110,"Postage ","Postage charges even if not specifically for communications"]
[null,75100,"Courier ","Courier charges even if not specifically for communications"]
["Hospitality"]
[null,76750,"Hospitality and Catering ","Meetings, visiting speakers (excluding honoraria, accommodations and travel), tickets for non charitable events, gifts etc."]
[null,76760,"Reception","A reception would not include a business meeting event."]
["Memberships"]
[null,76240,"Memberships ","Institutional and society memberships"]
[null,76241,"Individual Membership","Professional or trade memberships required to carry out assigned job responsibilities"]
["Student Orientation"]
[null,76555,"Student Orientation","Expenses incurred on Student Orientation activity"]
["Minor Equipment, Furniture and Software"]
[null,77150,"Computer Supplies Other ","Small dollar value computer specific supplies (power cords, Ink etc.)"]
[null,77155,"Telecom Supplies Other","Small dollar value telephone specific supplies (wireless headsets, cords, etc.)"]
[null,77807,"Minor Computer Hardware","Mounting, keyboards, mouse, stands, ergonomics where each item is less than $3,000"]
[null,77810,"Minor Equipment and Furniture ","Small equipment and furniture purchases where each item is under $3,000"]
[null,77820,"Minor Software and Licenses ","Low value software and licenses where the each item is under $3,000"]
["Office Supplies"]
[null,77380,"Material and Supplies Other ","Teaching or other supplies (other than office supplies - see below)"]
[null,77900,"Office Supplies ","Office supplies, stationary and expenses "]
["Other"]
[null,76200,"Storage Costs","Iron mountain, digital media storage"]
[null,76050,"Cultural Activities ","Activities undertaken with students for knowledge enrichment about culture"]
[null,76160,"Prizes ","Prizes purchased for participants in conferences or other University sponsored events."]
[null,76752,"Student Activities","Events specifically for students"]
[null,76163,"Professional Development ","Registration for workshops, online courses or other events attended for professional development"]
[null,76180,"Publications and Subscriptions ","Trade or society journals, research publications, subscriptions or databases"]
[null,76205,"Donations and Sponsorships ","Sponsorships for societies or events, tickets to charitable events and donations in memoriam"]
[null,76230,"General Expenses Other ","Miscellaneous items that are not classified elsewhere - For significant or recurring items consult with Financial Services for more specific accounts"]
[null,76250,"Short Term Rentals","Rental costs of space etc. for events"]
[null,76260,"Technical Services","Fees for services obtained in respect of software, dissemination, analysis, editing etc."]
[null,76270,"Translation Costs","Fees for services relating to translation of documents in other languages"]
["Printing and Duplicating"]
[null,77950,"Copying and Printing External ","External vendor charges for copying and printing"]
["Teaching and Lab Supplies"]
[null,77620,"Teaching and Lab Materials ","Supplies used for teaching either in classrooms or labs "]
[null,77100,"Audio Visual Supplies ","Audio Visual teaching supplies - Cd's etc."]
[null,77700,"Training Videos and Supplies","Videos and supplies related to student / faculty / staff training"]
["Travel and Staff training"]
[null,73555,"Travel and Development Faculty","Use for travel covered by SMUFU agreement - See below for items to be charged"]
[null,79100,"Travel and Development Admin ","Covers conferences, workshops, meetings and other travel. Include all transportation including local taxi and travelling taxi fares, airline, accommodation, registration and per diem costs.  "]
[null,78910,"Travel and Development Dean "]
[null,79260,"Travel and Development Other "]
[null,79265,"Professional Development Courses","Costs associated with courses where no travel is taken."]
[null,79210,"Travel and Development Students ","Covers conferences, workshops, meetings and other travel for students. Include all transportation including local taxi and travelling taxi fares, airline, accommodation, registration and per diem costs. Memberships must not be included."]
[null,78761,"Grant Travel General","Travel related to research grants and contracts"]
["Advance Accounts"]
[null,73550,"Travel Advances Faculty","Use for advances only where travel will be charged to Faculty Travel"]
[null,78699,"Advances Travel and Recruiting","Use for advances only where travel will be charged to Administrative or Grant Travel"]

{"sheet":"Expense Type Glossary","index":8,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Expense Type","Brief Description (For detailed description, please refer to respective policies)"]
["Accommodation","Stay / Cost of business meeting in Airbnb / Hotel / Inn / Lodge"]
["Advertisement Expenses","Costs incurred for promotional purposes. Such cost may include marketing expenses, digital, publications, periodicals, newspaper or magazine advertisement"]
["Airfare - Canada to US","The departure takes place from any province within Canada to United States of America including return ticket"]
["Airfare within Canada departing NS","The departure takes place from Nova Scotia in Canada and Arrival in any other Province of Canada including return ticket"]
["Airfare within Canada departing outside NS","The departure takes place from any province other than Nova Scotia in Canada and Arrival in any other Province (including Nova Scotia) of Canada including return ticket"]
["Airfare - to/from Outside Canada and US","The departure takes place from any Country other than Canada and United States of America to any Country in the World including return ticket"]
["Baggage Fee","Cost of baggage which is not included in flight ticket cost"]
["Event Expenses","Cost associated with speakers, rental of venues, audio visual and printed material"]
["Faculty Recruitment Expenses","Costs associated with the process of attracting, shortlisting, selection and hiring of new faculty"]
["Gas Charges","Fuel expenses for vehicle"]
["Gift Cards / Prizes","Purchase of VISA / Other Gift cards from retail stores or Prizes"]
["Hospitality Expenses","Entertainment of guests or visitors. Include Meals or Beverages purchased as a part of hospitality"]
["Medical Insurance","The cost of Medical insurance. There is no HST/ GST. Refer to policy 4-3008"]
["Membership Fee - Taxable","Membership fees for Instituitions or Society. If there is HST/GST on the invoice, choose expense type: Membership Fee - Taxable"]
["Membership Fee - Non Taxable","Membership fees for Instituitions or Society. If there is no HST/GST on the invoice, choose expense type: Membership Fee - Non Taxable"]
["Mileage","KM rate provided for use of personal vehicle for University purposes"]
["Minor Equipment","Purchase of equipment valued less than CAD $3000"]
["Mobile charges","Cost of business calls for cellular or telephone expenses"]
["Others - Non Taxable","Non Taxable expenses not falling in any other expense type"]
["Others - Taxable","Taxable expenses not falling in any other expense type"]
["Parking","Parking charges for vehicle. Does not cover Saint Mary's Parking Passes"]
["Per Diem","Institutional / Granting Agency daily allowance for meals per day. No receipts are required"]
["Per Diem (Varsity Athlete - Game Day)","Institutional Athlete daily allowance for meals per day. No receipts are required"]
["Professional Development Expenses","Cost associated with employees to pursue professional development activities in order to update or maintain existing qualifications or continuance of employee development"]
["Registration fees","Fees associated with registration for Conferences, workshops etc."]
["Relocation Expenses","Relocation expenses including movement of household or office items and hiring cost for movers. Does not include airfare / bus / train fare / vehicle rental. Please refer to Policy 4-3007"]
["Software Charges","Cost associated with purchase of software, data or program"]
["Subscription Charges","Cost associated with subscription of periodicals, magazine, newspapers etc."]
["Supplies or Services","Purchase of tangible items or availing services. Include service fees for purchase of travel tickets, Travel Visa Expenses etc."]
["Toll Charges","Fee (or toll) charged for road, tunnels or bridges. No HST / GST on Toll Charges"]
["Transportation other than Airfare","Taxi / Uber / Ride share / Bus / Train / Ferry / Travel by means other than Airplane. Bill including tips paid. For rental of vehicle for university purposes refer policy 4-3012"]
["Varsity Athlete - Game Day Meal","Institutional Athlete Game Day Meals for a group. List of team players required, receipt required"]

{"sheet":"Per Diem & Allowances","index":9,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Meal Per Diems (As of April 1, 2019) - CAD$ for Canada and US$ for US"]
[]
["Breakfast - $10.00"]
["Lunch - $15.00"]
["Dinner - $25.00"]
["Overnight Incidentals - $7.00"]
["Daily Total - $57.00 (US $ if travel in USA)"]
[]
["Per Diem (Varsity Athlete - Game Day) - Policy 4-3016"]
["$25 per day per Athlete"]
[]
["Alternate Accommodation Per Diem"]
[]
["Where an employee arranges alternate accommodation with relatives or friends, a $25.00 per night allowance may be claimed."]
[]
["Mileage Rate - $0.51 per Kilometer (Canada & USA)"]
[]
["Treasury Board Rates will continue to be used for international travel or where granting agencies allow it."]
["https://www.njc-cnm.gc.ca/directive/app_d/en"]
["Should you need additional support, please contact Procure to Pay Services at 902-420-5054."]

{"sheet":"Lost Receipt Form","index":10,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,0,6,2],[7,0,7,2],[8,0,8,2],[0,0,0,2],[2,0,2,2],[4,0,4,2],[11,0,11,1],[12,0,12,1],[13,0,13,1],[16,0,16,1],[17,0,17,1],[20,0,20,1],[14,0,15,1],[14,2,15,2],[18,0,19,1],[21,0,22,1],[18,2,19,2],[21,2,22,2]]}
["LOST RECEIPT DECLARATION FORM"]
[]
["Where a duplicate receipt cannot be obtained, the claimant must submit this form"]
[]
["RE: Original Receipt"]
[]
["I, hereby declare that I have lost or never received an original receipt and all attempts to obtain duplicate receipt have failed. "]
["I further declare that I have not, and will not use the receipt (if found) to claim reimbursement from any source, "]
["or to support any claim for income tax deductions in the future."]
[]
["A detailed list of the goods and / or services purchased is as follows:"]
["Vendor Name: "]
["Date of Purchase (DD-MMM-YY Format): "]
["Amount of Purchase (CAD$): "]
["Description of Goods / Services purchased: "]
[]
["Name of Claimant: "]
["Department: "]
["Claimant Signature with Date: "]
[]
["Name of Approver:"]
["Approver Signature with Date: "]

{"sheet":"Advance Repayment Form","index":11,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,1,27,4],[3,1,7,10],[8,4,8,5],[9,1,9,3],[9,4,9,5],[11,1,11,4],[11,5,11,10],[13,5,13,10],[16,1,17,4],[18,1,18,4],[23,1,23,4],[39,9,39,10],[28,1,28,4],[33,1,33,4],[34,1,34,4],[35,1,35,10],[38,1,38,4],[38,5,38,8],[38,9,38,10]]}
[null,null,null,null,"Advance Repayment Form"]
[]
[]
[null,"Instructions\nRepayment of unused advance funds must be received at the time of submission of your Reimbursement Form,\nas outlined in Policy 4-3002 Expense Reporting & Reimbursement Procedure. Section 1 pertains to unused travel advance repayment and Section 2 pertains to repayment of entire travel advance in case of cancellation or postponement of travel."]
[]
[]
[]
[]
[]
[null,"Date: (DD/MMM/YY)"]
[]
[null,"Name and Department:"]
[]
[null,"The enclosed funds are for:",null,null,null,"Repayment of travel advance"]
[]
[null,"Section 1:  Repayment of unused portion of travel advance"]
[null,"Payee Name",null,null,null,"Cash","Cheque","VISA","MCard","AMEX","Total"]
[null,null,null,null,null,"$ Amount","$ Amount","$ Amount","$ Amount","$ Amount","$ Amount"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F19:J19)","v":0}]
[null,"Total funds enclosed",null,null,null,{"$f":"SUM(F19:F19)","v":0},0,0,0,0,0]
[null,"Accounting Information"]
[null,null,null,null,null,"Fund","Org","Account","Prog","Debit","Amount"]
[null,"FOAP Description",null,null,null,"(6 digits)","(4 digits)","(5 digits)","(4 digits)","Credit","($)"]
[null,"Repayment of travel advance",null,null,null,100000,"XXXX",12160,"XXXX","Credit"]
[]
[null,"Section 2:  Repayment in full / travel cancelled"]
[null,"Payee Name",null,null,null,"Cash","Cheque","VISA","MCard","AMEX","Total"]
[null,null,null,null,null,"$ Amount","$ Amount","$ Amount","$ Amount","$ Amount","$ Amount"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F29:J29)","v":0}]
[null,"Total funds enclosed",null,null,null,{"$f":"SUM(F29:F29)","v":0},0,0,0,0,0]
[null,"Accounting Information"]
[null,null,null,null,null,"Fund","Org","Account","Prog","Debit","Amount"]
[null,"FOAP Description",null,null,null,"(6 digits)","(4 digits)","(5 digits)","(4 digits)","Credit","($)"]
[null,"Return of travel advance (Grants)",null,null,null,null,null,78699,null,"Credit"]
[null,"Return of travel advance (Operating)",null,null,null,100000,null,73550,null,"Credit"]
[]
[null,"Authorization"]
[null,"Prepared by (print)",null,null,null,"Prepared by (signature)",null,null,null,"Date:"]
[]
[null,"Received by:",null,null,null,"Notes:",null,null,null,"Date Received:"]

{"sheet":"Wire Transfer Request","index":12,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[45,4,45,5],[47,4,47,5],[19,2,19,7],[4,6,4,7],[10,1,10,4],[10,5,10,7],[12,1,12,7],[6,1,6,7],[4,2,4,4],[7,2,7,7],[15,2,15,3],[15,4,15,5],[14,6,14,7],[16,2,16,7],[18,2,18,4],[23,2,23,7],[21,1,21,7],[14,2,14,4],[13,5,13,6],[8,2,8,7],[9,2,9,4],[9,5,9,6],[18,5,18,6],[17,2,17,7],[43,4,43,5],[27,1,27,7],[28,1,28,2],[29,1,29,2],[35,1,35,6],[41,4,41,5],[37,3,37,7],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[22,2,22,7],[39,4,39,5],[37,1,37,2],[25,2,25,7],[24,5,24,6],[24,2,24,4]]}
[]
[null,null,"International Wire Transfer Request Form"]
[null,null,"Financial Services"]
[]
[null,"To:   ","Procure to Pay, Financial Services",null,null,"From:"]
[]
[null,"Beneficiary:"]
[null,"Beneficiary Name:"]
[null,"Address:"]
[null,"City, Province",null,null,null,"Country"]
[null,"Payment Details: (up to 12 characters, ex: \"Agent Fee\"): "]
[]
[null,"Transfer Details:"]
[null,"Transfer Amount:",null,"Currency:",null,"Date to be transferred: "]
[null,"Bank Account #: ",null,null,null,"SWIFT/BIC"]
[null,"Bank account currency:","Canadian",null,"US",null,"Other"]
[null,"Bank Name:"]
[null,"Branch Address:"]
[null,"City, Province/State",null,null,null,"Country"]
[null,"Other Information:"]
[]
[null,"Intermediary/Correspondent Bank Details (If Applicable)"]
[null,"Bank Name:"]
[null,"Branch Address:"]
[null,"City, Province/State",null,null,null,"Country"]
[null,"Other Information: (Ex.: Swift Code, Account Number, etc.):"]
[]
[null,"Accounting Details:"]
[null,null,null,null,null,null,null,"Amount"]
[null,"Description",null,"Fund","Org","Account","Program","Debit (Credit)"]
[]
[]
[]
[]
[]
[null,"Grand Total",null,null,null,null,null,{"$f":"SUM(H31:H35)","v":0}]
[]
[null,"Other comments/instructions:"]
[]
[]
[null,"Requested by:",null,null,"Title",null,null,"Date"]
[]
[null,"Departmental Authorization by:",null,null,"Title",null,null,"Date"]
[]
[null,"Financial Services Authorization by:",null,null,"Title",null,null,"Date"]
[]
[null,"Input into RBC Express",null,null,"Title",null,null,"Date"]
[]
[null,"Approved in RBC Express",null,null,"Title",null,null,"Date"]

{"sheet":"Prize Hospitality Log","index":13,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,22,5],[2,3,2,5],[3,3,3,5],[4,3,4,5]]}
[]
[]
[null,null,"Department:"]
[null,null,"Claimant:"]
["   Reimbursement Form",null,"Approver:"]
["   Prize, Gift/Gift Card/Hospitality Log"]
["   To be submitted as part of a completed Reimbursement Form"]
["Claim Reference Number","Recipient(s) Name","Event/Purpose of the Prize, Gift Card or Hospitality","Prize/Gift Card Description\n (ex: Sobeys gift card)","Prize/Gift Card Amount","Contact Information/Signature of Recipient"]
[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,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,null,null,"$"]
[null,null,null,null,"$"]
["Note: The total of prize/gift cards issued must equal amount requested on Reimbursement Form. Any part of a reimbursement for a receipted amount \nwill not be made until all gift cards/prizes are distributed and accounted for from that total. Do not submit original receipts until all names/signatures are obtained."]

{"sheet":"Working Tab","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}