{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Master","Expenses"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,0,2,7],[3,0,3,7],[4,0,4,7],[0,0,0,7]]}
["REIMBURSEMENT OF FOREIGN CURRENCY EXPENSES "]
["Instructions: "]
["Complete the Expenses worksheet (click the \"Expenses\" tab below to access the Expenses worksheet) and submit a scanned copy with the receipt package for the corresponding expense report.\nNote: Maximize your window to full-screen mode so that you can see the tabs below.\n\n1. For business trips less than 7 days, the actual daily exchange rate must be used.  For business trips lasting longer than 7 days, actual daily exchange rates or the average conversion rate for the trip may be used. \n\n2. When the average conversion rate is used, similar charges (e.g. taxi, buses, etc.) can be combined as one line on the expense report.   If the expenses are combined, use the justification section in the online expense report to explain any charges.\n\n3. Conversion rate documentation is no longer required to be attached to the receipt package.  Departments may attach the conversion daily rates to the receipt package if required by the department or school/academic area.  \n\n4. *If your personal funds were exchanged for foreign currency, you may receive reimbursement for any exchange rate loss.  If you received an advance from the University, any exchange rate profit in excess of $75 on the advanced amount should be returned to the University.  This applies to Exchange rate Profit (Loss)* \n\n\n"]
["Reminders: "]
["1. When travelling outside the US, use a credit card (if possible) to pay for expenses.  A credit card provides the best exchange rate and is the simplest payment method for reimbursement.  \n\n2. When travelling outside the US, you have the option of reporting either the actual amount paid or the US Department of State lodging and meal per diems.   \n\n3. When travelling outside the US, to reduce the use of personal funds you may obtain a travel advance from the University.  The travel advance amount may include per diem and lodging expenses for all days in travel.  An additional $100 can be added to the amount of the advance. \n \n4. When travelling outside the US on a federal grant, any reasonable option to calculate exchange rate losses is permissible, and exchange rate losses are allowable.  Travelling outside the US on federal grants must receive prior approval by the awarding agency. "]

{"sheet":"Master","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":true,"merged":[[32,0,32,7],[36,0,36,6],[34,0,34,6],[3,0,3,1],[0,0,0,7],[23,0,23,1],[4,0,4,1],[4,2,4,7],[2,2,3,7]]}
["REIMBURSEMENT OF FOREIGN CURRENCY EXPENSES"]
["Date","Country Name / Expense Description","US Cash Leaving Country","Expenses in Foreign Currency","OANDA 24-Hr Average Daily Exchange Rate *","Expenses in US Dollars","Foreign Currency Balance","US Cash Return Trip"]
[]
[]
["Enter Foreign Currency used for transactions below:"]
["MO - DAY - YR","Sell USD for foreign currency",0,null,0,null,{"$f":"C6*E6","v":0}]
["MO - DAY - YR",null,null,0,0,{"$f":"D7*E7","v":0},{"$f":"G6-D7","v":0}]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR","Sell foreign currency for USD",null,{"$f":"G20","v":0},0,null,null,{"$f":"G20*E21","v":0}]
[null,null,null,{"$f":"SUM(D7:D20)","v":0},null,{"$f":"SUM(F7:F20)","v":0}]
[]
["CURRENCY EXCHANGE GAIN/LOSS"]
[]
[" DAILY RATE OPTION","Expenses in USD using daily rate",null,{"$f":"F22","v":0}]
[null,"Exchange rate Profit (Loss)*",null,{"$f":"$C$6 - $H$21-D26","v":0}]
[]
[" AVERAGE RATE OPTION","Expenses in US using average of start/end rates",null,{"$f":"$D$22 * E29","v":0},{"$f":"(E7+E21)/2","v":0}]
[null,"Exchange rate Profit (Loss)*",null,{"$f":"$C$6 - $H$21 - D29","v":0}]

{"sheet":"Expenses","index":2,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[32,0,32,7],[34,0,34,6],[36,0,36,6],[0,0,0,7],[2,2,3,7],[3,0,3,1],[4,0,4,1],[4,2,4,7],[23,0,23,1]]}
["REIMBURSEMENT OF FOREIGN CURRENCY EXPENSES"]
["Date","Country Name / Expense Description","US Cash Leaving Country","Expenses in Foreign Currency","OANDA 24-Hr Average Daily Exchange Rate ","Expenses in US Dollars","Foreign Currency Balance","US Cash Return Trip"]
[]
[]
["Enter Foreign Currency used for transactions below:"]
["MO - DAY - YR","Sell USD for foreign currency",0,null,0,null,{"$f":"C6*E6","v":0}]
["MO - DAY - YR",null,null,0,0,{"$f":"D7*E7","v":0},{"$f":"G6-D7","v":0}]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR",null,null,0,0,0,0]
["MO - DAY - YR","Sell foreign currency for USD",null,{"$f":"G20","v":0},0,null,null,{"$f":"G20*E21","v":0}]
[null,null,null,{"$f":"SUM(D7:D20)","v":0},null,{"$f":"SUM(F7:F20)","v":0}]
[]
["CURRENCY EXCHANGE GAIN/LOSS"]
[]
[" DAILY RATE OPTION","Expenses in USD using daily rate",null,{"$f":"F22","v":0}]
[null,"Exchange rate Profit (Loss)*",null,{"$f":"$C$6 - $H$21-D26","v":0}]
[]
[" AVERAGE RATE OPTION","Expenses in USD using average of start/end rates",null,{"$f":"$D$22 * E29","v":0},{"$f":"(E7+E21)/2","v":0}]
[null,"Exchange rate Profit (Loss)*",null,{"$f":"$C$6 - $H$21 - D29","v":0}]