Oanda Fx - Download as Excel by sqw40376

VIEWS: 93 PAGES: 16

More Info
									                                   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

								
To top