Expense Liquidation Form - Excel by bpq13407

VIEWS: 6,832 PAGES: 12

Expense Liquidation Form document sample

More Info
									                                    International Partnerships Among Museums
                                                   2005-2007 Cycle

Return this form, corresponding receipts, and copy of airline ticket/receipt within two weeks of completion of travel.
The information requested on this form is for auditing and reporting purposes.
The IPAM program provides a total of $3730. All funds must be accounted for in order for the partnership to be
considered complete. Failure to submit this report means that the program requirements have not been fulfilled, and
may result in the recovery of granted funds from the institution.


Please Note:

   ▪ The grant money does not cover cost of alcohol.
   ▪ Attach receipts over $25 to each week's sheet in chronological order . If multiple expenses under $25 for one
   day total more than $25, please make note of this (e.g. Two cab trips on March 17, 2007 for $16.10 each=$32.20).
   ▪ When multiple currencies are used in one week (e.g. US Dollars and Euros), use two separate sheets for
   that week. Attach the corresponding receipts to the appropriate sheet.
   ▪ When outside of the U.S., total for the week in the local currency before converting to U.S. dollars. For
   exchange rates, please select an average of the rates while you are traveling and use it for all expenses. Total the
   expenses in the currency used and then convert the weekly total.
   ▪ Make copies of all documents and retain for your records.
   ▪ Allowable expenses can include things such as calls home, laundry, movies, dinner, groceries, books, museum
   admission to other institutions for you and your partner, clothing purchases only if they are absolutely necessary
   (e.g.it gets bitterly cold, and you forgot to bring a coat), theatre tickets and other cultural expenses, etc.


To Use This Form:
 ▪ Be sure to complete The Name, Location, Dates of Travel, and Page Number at the top of each sheet.
 ▪ Dates should be filled in across the top of each form in Excel Row 9.
 ▪ One number, the total for that section and date, should be entered in each cell. If there are multiple expenses that
 total more than $25, please use the very last worksheet, Details, to explain and use the IPAM Column and Row
 numbers typed near the cells.
 ▪ The totals for each row will automatically be calculated in IPAM Column H.
 ▪ The total for the week will automatically be calculated at the bottom of Column H.
 ▪ To convert weekly total based on an exchange rate, put an average rate in the cell to the right of Exchange Rate.
 The total should automatically be calculated.
 ▪ The Cumulative Total for weeks 2-6 are the only boxes that must be added by the participant for each week's
 worksheet.




           International                                                         1575 Eye Street NW, Suite 400
           Partnerships                                                                Washington, DC 20010
           Among                                                                        +1.202.289.6578 fax
           Museums                                                                         ipam@aam-us.org
                                               International Partnerships Among Museums
                                                         Travel Liquidation Form

                                    Name:                      Location:                                   Page 1 of
                                                          Date of Travel:
Fill in ONLY items in blue spaces. Formulas are in dark grey spaces--do not change.

                                               A        B         C         D         E      F      G          H
Date                                                                                                         Totals
Meals                                                                                                      $     -     1
Lodging                                                                                                    $     -     2
Misc. Meals & Lodging                                                                                      $     -     3
 Subtotal Meals and Lodging                    0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
Air/Rail Travel                                                                                            $     -     4
Taxi/Parking/Tolls/Public Transp.                                                                          $     -     5
Misc. Travel (tips, tel, etc.)                                                                             $     -     6
Other:                                                                                                     $     -     7
Subtotal Ground Transportation                 0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     8
                                                                                                           $     -     9
                                                                                                           $     -     10
                                                                                                           $     -     11
Subtotal Shipping/Excess Baggage               0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     12
                                                                                                           $     -     13
                                                                                                           $     -     14
                                                                                                           $     -     15
Subtotal Books/Education/Culture               0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     16
                                                                                                           $     -     17
                                                                                                           $     -     18
                                                                                                           $     -     19
Subtotal Miscellaneous                         0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Total Cost for Week One                       0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Cumulative Total




                           Total Expenses: $       -    ÷          Exchange Rate:     0.00   =              #DIV/0!

                                                               Week One
                                               International Partnerships Among Museums
                                                         Travel Liquidation Form

                                    Name:                      Location:                                   Page 2 of
                                                          Date of Travel:
Fill in ONLY items in blue spaces. Formulas are in dark grey spaces--do not change.

                                               A        B         C         D         E      F      G          H
Date                                                                                                         Totals
Meals                                                                                                      $     -     20
Lodging                                                                                                    $     -     21
Misc. Meals & Lodging                                                                                      $     -     22
 Subtotal Meals and Lodging                    0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
Air/Rail Travel                                                                                            $     -     23
Taxi/Parking/Tolls/Public Transp.                                                                          $     -     24
Misc. Travel (tips, tel, etc.)                                                                             $     -     25
Other:                                                                                                     $     -     26
Subtotal Ground Transportation                 0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     27
                                                                                                           $     -     28
                                                                                                           $     -     29
                                                                                                           $     -     30
Subtotal Shipping/Excess Baggage               0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     31
                                                                                                           $     -     32
                                                                                                           $     -     33
                                                                                                           $     -     34
Subtotal Books/Education/Culture               0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     35
                                                                                                           $     -     36
                                                                                                           $     -     37
                                                                                                           $     -     38
Subtotal Miscellaneous                         0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Total Cost for Week Two                       0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Cumulative Total




                           Total Expenses: $       -    ÷          Exchange Rate:     0.00   =              #DIV/0!

                                                               Week Two
                                              International Partnerships Among Museums
                                                        Travel Liquidation Form

                                    Name:                      Location:                                   Page 3 of
                                                          Date of Travel:
Fill in ONLY items in blue spaces. Formulas are in dark grey spaces--do not change.

                                              A        B          C         D         E      F      G          H
Date                                                                                                         Totals
Meals                                                                                                      $     -     39
Lodging                                                                                                    $     -     40
Misc. Meals & Lodging                                                                                      $     -     41
 Subtotal Meals and Lodging                   0.00      0.00       0.00      0.00     0.00   0.00   0.00   $     -
Air/Rail Travel                                                                                            $     -     42
Taxi/Parking/Tolls/Public Transp.                                                                          $     -     43
Misc. Travel (tips, tel, etc.)                                                                             $     -     44
Other:                                                                                                     $     -     45
Subtotal Ground Transportation                0.00      0.00       0.00      0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     46
                                                                                                           $     -     47
                                                                                                           $     -     48
                                                                                                           $     -     49
Subtotal Shipping/Excess Baggage              0.00      0.00       0.00      0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     50
                                                                                                           $     -     51
                                                                                                           $     -     52
                                                                                                           $     -     53
Subtotal Books/Education/Culture              0.00      0.00       0.00      0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     54
                                                                                                           $     -     55
                                                                                                           $     -     56
                                                                                                           $     -     57
Subtotal Miscellaneous                        0.00      0.00       0.00      0.00     0.00   0.00   0.00   $     -
 Total Cost for Week Three                    0.00      0.00       0.00      0.00     0.00   0.00   0.00   $     -
 Cumulative Total                                                                                          $     -




                          Total Expenses: $       -    ÷            Exchange Rate:    0.00   =              #DIV/0!

                                                               Week Three
                                              International Partnerships Among Museums
                                                        Travel Liquidation Form

                                    Name:                      Location:                                   Page 4 of
                                                          Date of Travel:
Fill in ONLY items in blue spaces. Formulas are in dark grey spaces--do not change.

                                              A        B          C         D         E      F      G          H
Date                                                                                                         Totals
Meals                                                                                                      $     -     58
Lodging                                                                                                    $     -     59
Misc. Meals & Lodging                                                                                      $     -     60
 Subtotal Meals and Lodging                   0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
Air/Rail Travel                                                                                            $     -     61
Taxi/Parking/Tolls/Public Transp.                                                                          $     -     62
Misc. Travel (tips, tel, etc.)                                                                             $     -     63
Other:                                                                                                     $     -     64
Subtotal Ground Transportation                0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     65
                                                                                                           $     -     66
                                                                                                           $     -     67
                                                                                                           $     -     68
Subtotal Shipping/Excess Baggage              0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     69
                                                                                                           $     -     70
                                                                                                           $     -     71
                                                                                                           $     -     72
Subtotal Books/Education/Culture              0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     73
                                                                                                           $     -     74
                                                                                                           $     -     75
                                                                                                           $     -     76
Subtotal Miscellaneous                        0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Total Cost for Week Four                     0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Cumulative Total                                                                                          $     -




                          Total Expenses: $       -    ÷           Exchange Rate:     0.00   =              #DIV/0!

                                                               Week Four
                                                International Partnerships Among Museums
                                                          Travel Liquidation Form

                                    Name:                      Location:                                    Page 5 of
                                                          Date of Travel:
Fill in ONLY items in blue spaces. Formulas are in dark grey spaces--do not change.

                                                A        B         C        D         E       F      G          H
Date                                                                                                          Totals
Meals                                                                                                       $     -     77
Lodging                                                                                                     $     -     78
Misc. Meals & Lodging                                                                                       $     -     79
 Subtotal Meals and Lodging                     0.00     0.00      0.00      0.00     0.00    0.00   0.00   $     -
Air/Rail Travel                                                                                             $     -     80
Taxi/Parking/Tolls/Public Transp.                                                                           $     -     81
Misc. Travel (tips, tel, etc.)                                                                              $     -     82
Other:                                                                                                      $     -     83
Subtotal Ground Transportation                  0.00     0.00      0.00      0.00     0.00    0.00   0.00   $     -
                                                                                                            $     -     84
                                                                                                            $     -     85
                                                                                                            $     -     86
                                                                                                            $     -     87
Subtotal Shipping/Excess Baggage                0.00     0.00      0.00      0.00     0.00    0.00   0.00   $     -
                                                                                                            $     -     88
                                                                                                            $     -     89
                                                                                                            $     -     90
                                                                                                            $     -     91
Subtotal Books/Education/Culture                0.00     0.00      0.00      0.00     0.00    0.00   0.00   $     -
                                                                                                            $     -     92
                                                                                                            $     -     93
                                                                                                            $     -     94
                                                                                                            $     -     95
Subtotal Miscellaneous                          0.00     0.00      0.00      0.00     0.00    0.00   0.00   $     -
 Total Cost for Week Five                       0.00     0.00      0.00      0.00     0.00    0.00   0.00   $     -
 Cumulative Total                                                                                           $     -




                            Total Expenses: $       -    ÷          Exchange Rate:     0.00   =              #DIV/0!

                                                                Week Five
                                               International Partnerships Among Museums
                                                         Travel Liquidation Form

                                    Name:                      Location:                                   Page 6 of
                                                          Date of Travel:
Fill in ONLY items in blue spaces. Formulas are in dark grey spaces--do not change.

                                               A        B         C         D         E      F      G          H
Date                                                                                                         Totals
Meals                                                                                                      $     -     96
Lodging                                                                                                    $     -     97
Misc. Meals & Lodging                                                                                      $     -     98
 Subtotal Meals and Lodging                    0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
Air/Rail Travel                                                                                            $     -     99
Taxi/Parking/Tolls/Public Transp.                                                                          $     -     100
Misc. Travel (tips, tel, etc.)                                                                             $     -     101
Other:                                                                                                     $     -     102
Subtotal Ground Transportation                 0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     103
                                                                                                           $     -     104
                                                                                                           $     -     105
                                                                                                           $     -     106
Subtotal Shipping/Excess Baggage               0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     107
                                                                                                           $     -     108
                                                                                                           $     -     109
                                                                                                           $     -     110
Subtotal Books/Education/Culture               0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     111
                                                                                                           $     -     112
                                                                                                           $     -     113
                                                                                                           $     -     114
Subtotal Miscellaneous                         0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Total Cost for Week Six                       0.00     0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Cumulative Total                                                                                          $     -




                           Total Expenses: $       -    ÷          Exchange Rate:     0.00   =              #DIV/0!

                                                               Week Six
                                              International Partnerships Among Museums
                                                        Travel Liquidation Form

                                    Name:                      Location:                                   Page 7 of
                                                          Date of Travel:
Fill in ONLY items in blue spaces. Formulas are in dark grey spaces--do not change.

                                              A        B          C         D         E      F      G          H
Date                                                                                                         Totals
Meals                                                                                                      $     -     115
Lodging                                                                                                    $     -     116
Misc. Meals & Lodging                                                                                      $     -     117
 Subtotal Meals and Lodging                   0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
Air/Rail Travel                                                                                            $     -     118
Taxi/Parking/Tolls/Public Transp.                                                                          $     -     119
Misc. Travel (tips, tel, etc.)                                                                             $     -     120
Other:                                                                                                     $     -     121
Subtotal Ground Transportation                0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     122
                                                                                                           $     -     123
                                                                                                           $     -     124
                                                                                                           $     -     125
Subtotal Shipping/Excess Baggage              0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     126
                                                                                                           $     -     127
                                                                                                           $     -     128
                                                                                                           $     -     129
Subtotal Books/Education/Culture              0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
                                                                                                           $     -     130
                                                                                                           $     -     131
                                                                                                           $     -     132
                                                                                                           $     -     133
Subtotal Miscellaneous                        0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Total Cost Other Expenses/Currancies         0.00      0.00      0.00       0.00     0.00   0.00   0.00   $     -
 Cumulative Total                                                                                          $     -




                          Total Expenses: $       -    ÷           Exchange Rate:     0.00   =              #DIV/0!

                                                      Other Expenses & Currency
                                Travel Expense Detail

Line #   Date   Comments including name of person(s) entertained, nature, & purpose   Amount
    1
    2
    3
    4
    5
    6
    7
    8
    9
   10
   11
   12
   13
   14
   15
   16
   17
   18
   19
   20
   21
   22
   23
   24
   25
   26
   27
   28
   29
   30
   31
   32
   33
   34
   35
   36
   37
   38
   39
   40
   41
   42
   43
   44

                                               Detail
Line #   Date   Comments including name of person(s) entertained, nature, & purpose   Amount
   45
   46
   47
   48
   49
   50
   51
   52
   53
   54
   55
   56
   57
   58
   59
   60
   61
   62
   63
   64
   65
   66
   67
   68
   69
   70
   71
   72
   73
   74
   75
   76
   77
   78
   79
   80
   81
   82
   83
   84
   85
   86
   87
   88
   89
   90
   91
   92
   93

                                               Detail
Line #    Date   Comments including name of person(s) entertained, nature, & purpose   Amount
   94
   95
   96
   97
   98
   99
  100
  101
  102
  103
  104
  105
  106
  107
  108
  109
  110
  111
  112
  113
  114
  115
  116
  117
  118
  119
  120
  121
  122
  123
  124
  125
  126
  127
  128
  129
  130
  131
  132
  133
 Notes:




                                                Detail

								
To top