Get documents about "Oanda Fx - Download as Excel
Description
Oanda Fx document sample
Document Sample
BARNARD COLLEGE
FOREIGN TRAVEL & EXPENSE REPORT INSTRUCTIONS
Office of the Controller - 15 Milbank Hall
NOTE: Each trip must be submitted on a separate travel & expense report
Please see colored tabs for all related forms and instructions
SECTION 1: PAYEE INFORMATION
Steps 1 Enter the Employee (Payee) Name
2 Enter the Payee's Home Address (P.O. boxes, campus, office or temporary addresses are not
allowed).
3 Check the address change box to indicate that your address has changed.
SECTION 2: BUSINESS PURPOSES & ITEMIZED EXPENSES
Steps 4 Enter the Overall Business Reason for incurring either Travel or Business expenses on behalf of the
College (please be specific).
5 Select the check pick-up box if you want the check held at the Bursar's office for pick up
6 For US Dollar expenditures, enter itemized expenses. List each expense in detail and include the
date, amount and circumstances (Business Reasons) that demonstrate why the expense was
necessary and reasonable in order to conduct College business.
7 Use the Personal Vehicle Mileage section to calculate personal vehicle mileage reimbursement
amounts (the College does not reimburse for gas on private vehicle usage because it is in
the Federal Mileage Reimbursement Rate).
8 For Foreign currency expenditures, please complete the Foreign Currency worksheet (s) (see
separate instructions)
SECTION 3: ACCOUNTING
Steps 9 Enter any travel advance amounts in the bottom right-hand tally section.
10 Verify the total expense for each account and object code to be charged. Be sure that the account
distributions total the total amount of the expense report. Travel and entertainment will be
automatically allocated; other will need to be assigned the associated object code
SECTION 4: OPTIONAL WORKSHEETS
Step 11 Use the Extra Page for more itemized expense entries
SECTION 5: CERTIFICATION & COMPLIANCE
Each expense must conform to Barnard College policy, and the rules of the IRS, Federal Government or any
Granting Agency.
Steps 12 The employee must sign and date the report, certifying the legitimate, reasonable and necessary
business nature of all expenses being reimbursed.
13 Enter the Approver's Name
14 Authorized Approver must sign and date the Report, certifying the legitimate, reasonable and
necessary business nature of all expenses being reimbursed.
15 Enter the Dept. Name
16 Enter the Dept. Contact Name and Phone Number
FINAL STEPS
Steps 17 Save and print the report (print entire workbook if used)
18 Attach all supporting documentation including event flyers, flight information, all itemized hotel bills
and receipts taped to 8 1/2 x 11 sized paper and reference to itemized expense #.
19 Copy the report and all receipts to keep a record on file.
20 Forward to the Accounts Payable Department - 15 Milbank Hall for processing
Revised Jan. 14, 2008 FOREIGN TRAVEL & EXPENSE REPORT
Barnard College VOUCHER #
Office of the Controller - 15 Milbank Hall
EMPLOYEE (PAYEE) NAME CHECK PICK-UP
(OPTIONAL) Check box to
request check pick-up at
PAYEE'S HOME ADDRESS STREET APT # Bursar's Office (6)
CITY STATE STATE ZIP
Please check box if your
home address has changed
(3)
OVERALL BUSINESS PURPOSE (for conference, attach flyer or forms)
Admissions recruitment at international and domestic high schools
ITEMIZED EXPENSE DESCRIPTIONS
Amounts in US $
EXPENSE DATE OF BUSINESS Total Expense
NO. EXPENSE PURPOSES In the space below, describe each expense, including the business purpose. Travel Entertainment Other Amount
4306 4305 4XXX
Mileage rate/
# miles 0 $0.550 $0.00 $0.00
1 (10) mile
2 $0.00
3 $0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Subtotal in US $ $0.00 $0.00 $0.00 $0.00
Totals from Extra Page 0.00 0.00 0.00 0.00
Subtotal Expenses US$ $0.00 $0.00 $0.00 $0.00
Totals from Foreign Currency Worksheet (page 1) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 2) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 3) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 4) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 5) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 6) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 7) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 8) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 9) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 10) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 11) 0.00 0.00 0.00 0.00
Totals from Foreign Currency Worksheet (page 12) 0.00 0.00 0.00 0.00
Grand Total Expenses $0.00 $0.00 $0.00 $0.00
ACCOUNT NUMBER (15) OBJECT CODE AMOUNT SUMMARY OF BALANCE DUE
1-XXXXXX 4306 $0.00
4305 0.00 TOTAL EXPENSES $0.00
4XXX 0.00 ENTER TRAVEL ADVANCE (IF ANY) $0.00
Travel Advance 0.00 SUBTOTAL $0.00
AMOUNT DUE BARNARD COLLEGE $0.00
ACCOUNT DISTRIBUTION TOTAL $0.00 AMOUNT DUE EMPLOYEE $0.00
PAYEE'S SIGNATURE (4) DATE
X
I certify that these expenses were actual and reasonable and incurred in accordance with policy for the official business of Barnard College.
I certify that no portion of this claim was free of charge, previously reimbursed from any other source, or will be paid from any resource in the future.
APPROVERS'S NAME DEPT. NAME (15)
DEPARTMENT CONTACT (16)
APPROVERS'S SIGNATURE DATE
NAME
X
I certify that I have reviewed all claims associated with this reimbursement. I have found them to be in accordance with both Barnard College PHONE
policies and procedures and the policies of any sponsoring agencies funding these activities and I hereby authorize payment.
BARNARD COLLEGE
Revised Jan. 14, 2008 FOREIGN TRAVEL & EXPENSE REPORT - EXTRA PAGE PAYEE NAME
ITEMIZED EXPENSE DESCRIPTIONS (13)
Amounts in US $ Total
EXPENSE DATE OF BUSINESS In the space below, describe each expense, including the business
NO.
Travel Entertainment Other Expense
EXPENSE PURPOSES purpose.
4306 4305 4XXX Amount
Mileage
# miles rate/mile $0.550 $0.00 $0.00
1 (10)
$0.00
2
$0.00
3
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Subtotal in US $ $0.00 $0.00 $0.00 $0.00
BARNARD COLLEGE
FOREIGN CURRENCY WORKSHEET INSTRUCTIONS
Office of the Controller - 15 Milbank Hall
WORKSHEET NOTES
* This worksheet is designed to help organize and perform currency conversions. The total of these expenditures converted into U.S. Dollars
will be included in the foreign travel & expense report.
* Follow the instructions below on how to obtain the average rate of exchange. This calculation is done on the worksheet so that one
may enter itemized expenses in the foreign currency and it will automatically convert and show amounts and totals in U.S. dollars.
SECTION 1:
1) Enter Payee Name
2) Calculate average exchange rate (see section below)
3) Itemize expenses
4) Enter the Expense No. and reference on the actual receipt/documenation
5) Enter the Date of each expense item
6) Describe each expense including the job related business purpose
7) First enter the full amount on the receipt into the Total Foreign Currency Amount column
8) The worksheet will automatically perform the conversion into U.S. dollars based on the average rate calculated in the
Average Exchange Rate Calculator.
9) Enter the converted US$ amount into the correct object code assignment
OBTAINING EXCHANGE RATES TO BE USED ON THE WORKSHEET
1) Accounts Payable uses Oanda.com as its exchange rate resource.
2) Go to Oanda.com and select the "FXCONVERTER" on the left-hand menu under "Currency Tools".
3) Keep the "convert amount" selection at "1" and enter the FIRST DATE OF EXPENSE.
4) Convert FROM the foreign currency TO U.S. dollars.
5) Obtain the exchange rate from the first day of expense and the last date of expense following the instructions above.
6) Enter the First Date of expense Exchange Rate into the Average Exchange Rate Calculator
7) Print this page to be used as supporting documentation attached to the expense report.
8) Go back to the "FXCONVERTER" and repeat the conversion using the LAST DATE OF EXPENSE.
9) Enter the Last Date of expense Exchange Rate into the Average Exchange Rate Calculator which is on the Foreign
Currency Worksheet (Avg Rate tab)
10) Print this page to be used as supporting documentation attached to the expense report.
11) Enter the U.S. dollar amount results (with 4 decimal points) into the "First Date of Exchange Rate" field in the Average Exchange
Rate Calculator provided on the worksheet.
12) Enter the U.S. dollar amount results (with 4 decimal points) into the "Last Date of Expense Rate" field in the Average Exchange
Rate Calculator.
13) The Average Exchange Rate Calculator will automatically provide the average exchange rate to be used for each trip, or portion
of a trip (depending upon locations/currency being used).
14) The Worksheet will automatically reference the average exchange rate when converting foreign dollar amounts.
15) The Worksheet will automatically convert the amounts into U.S. dollars and carry the totals to the Expense Report.
16) If you are unable to locate a rarely used currency on Oanda.com go to http://fxtop.com/. This site will perform currency conversions
using the daily rate as a default. For historic rates go to the menu on the bottom of the main page and click: "converter in the past".
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 1)
Barnard College PAYEE NAME
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 2)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 3)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 4)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 5)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 6)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 7)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 8)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 9)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 10)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 11)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Revised Jan 14, 2008 FOREIGN CURRENCY WORKSHEET (PAGE 12)
Barnard College PAYEE NAME (4)
Office of the Controller
AVERAGE EXCHANGE RATE CALCULATOR
COUNTRY NAME:
CURRENCY BEING CONVERTED INTO US DOLLARS:
Link to Oanda - FX conversion website (1)
ENTER FIRST (DATE OF EXPENSE) EXCHANGE RATE (2) http://www.oanda.com/convert/classic
ENTER LAST (DATE OF EXPENSE) EXCHANGE RATE (3)
AVERAGE EXCHANGE RATE FOR US DOLLARS: 0.0000
Object Code Assignment (10)
ITEMIZED EXPENSE DESCRIPTIONS TOTAL FOREIGN Travel Entertainment Other Total
EXPENSE DATE OF CURRENCY Converted US$ Amount (9)
NO. (5) EXPENSE (6) BUSINESS PURPOSE (7) AMOUNT (8) 4306 4305 4XXX
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Please note: For grant accounts "UNALLOWABLE" expenses such as alcohol MUST BE charged to a Non-Government account
Related docs
