T & E Instructions
POLICY
It is the policy of Sony Pictures Entertainment (SPE) to reimburse employees for reasonable expenses incurred on Company business when in-town or traveling. The purpose of this policy is to establish equitable, consistent standards for employees and to comply with IRS guidelines.
It is inherent in this policy that moderation in frequency and expense be exercised in all areas where a reimbursement is requested by an employee.
All entertainment expenses reimbursed by the Company must have a business purpose and satisfy IRS requirements.
All expenses are required to be reported within 15 working days after returning from a trip. Each report
Employees should report their own expenses for reimbursement. When expenses are incurred as a group, the most senior employee must pay for and report the expenditure.
The policies and procedures described in this section are not intended to supersede more restrictive Divisional policies.
No charges are to be billed directly to SPE unless otherwise noted.
Expenses of all employees must be reported on the In-Town/Traveling Expense Report form. should reflect the expenses for one trip. In-town expenses should be submitted on a separate Expense Report form not exceeding one month. Do not combine expenses from a trip with In-town expenses on the same Expense Report form.
PLEASE NOTE THAT THIS IS THE ONLY PC FORM ACCEPTABLE. ALL SUBMISSIONS ON UNAPPROVED FORMS WILL BE RETURNED.
T & E Instructions
The following is a detailed explanation of how to use this template. If after reading this, you still need assistance, please "click" onto the tab titled "CONTACT LIST" and call the individual assigned to your area.
THE FILE: SET-UP The file is set up as a series of worksheets:
* Instructions (this sheet)
* Contact List: A list of individuals assigned to specific areas to handle coding questions and special issues.
* SS#: A standard form for set-up of Social Security numbers for new employees or first time users.
* T&E Week 1-4: The actual templates for requests for expense reimbursement. THE FILE: HOW IT WORKS
For convenience, this file has been created to accommodate one month's of expenses but it can be used for anywhere from one to the four weeks, as will be explained.
T&E Week 1 is the main worksheet. Input of standard information, i.e., name, address, department number onto this sheet automatically carries into the next three sheets. Please note that the entity, department, and social security number will feed to the appropriate lines below automatically. In addition, the sheet has a total column. This column sums all four weeks and provides a grand total for reimbursement.
Expenses being submitted still need to be input individually for the appropriate day(s).
address, SS#, etc.), only input your expenses, their detail, and their dates on Pages 1 and 2. All other information is linked or will calculate.
For your convenience, a macro (or short cut) for printing has been written. Once all input is complete, simply "click" the button marked "PRINT" at the top of the form. A quick check of input and agreement of detail to summary for the weeks is completed before you will be prompted for the number of weeks to print out. Simply input the numbers 1 - 4 and your file will print accordingly.
PROCEDURES General Coding Information:
Cells designated with blue typeface are input cells, ALL OTHER CELLS ARE PROTECTED AND CANNOT BE CHANGED!!!!
What do you input???
Input the following in 'T&E Week 1':
Paying Entity (Cell I3)
Walker Entity---Reporting Division (Cell F8)
Walker Department Number---or your overhead department number (Cell G8)
Social Security Number - (Cell I10) - If this is the first time you are submitting an expense report, please read information below (See 'Social Security Set up').
If more than one week is completed, all weeks will total in the Total Weeks column on 'T&E Week 1'. When inputting on week's 2 - 4, you do not have to reinput your personal information (name,
T & E Instructions
Social Security Set Up (First TIme Users):
Entering Expenses:
Before you enter any amounts, organize all your expenses by the date in which they were paid. Page 1
- If there is not a description listed for an expense incurred, list this item under Other (Lines 38, 39, and 40) and provide account coding in the General Ledger Coding section. To obtain assistance with account coding, please call the contact person listed for your appropriate entity (See worksheet entitled 'CntctLst'.) The social security field (column N) should be completed if the account
prefix is 605-xxxx or 615-xxxx.
Expenses Paid Directly by Company:
Travel Advances:
Page 2
- Enter explanations and detail of all items on Page 1 marked with an asterisk. CHECKS AND BALANCES
Make sure all appropriate totals on Page 1 agree with the corresponding detail on Page 2.
- Entertainment (Cell O29) on Page 1 should sum up to Total Entertainment (Cell P78) on Page 2.
PRINTING EXPENSE REPORTS
Note: All of these items are linked to the appropriate G/L account coding lines and will feed through this whole file.
- Since T & E expenses are charged to each individual, all expenses are processed under social security numbers so your social security must be set up on the Walker system.
- Please click on the worksheet entitled 'SS#setup', print out the memo, and send it to Judith Davis at SPP 678.
-Input the date for each day to be reimbursed in the date column (Columns F thru J) on Row 20. Enter all expenses corresponding to that specific date in the appropriate areas. Make sure that
you begin inputting in 'T&E Week 1' and proceed to 'T&E Week 2' if needed, etc. If more than one week is processed, all expenses will be totaled on 'T&E Week 1'.
- If any of the expenses included were paid by SPE (ie: airfare), enter the amount(s) in Cell O43 (ONLY in worksheet 'T&E Week 1'). Enter this amount as a negative number.
- If a travel advance was obtained for this trip, the amount of the advance must be deducted from the expense report. Enter the amount advanced in Cell O45 (ONLY in worksheet 'T&E Week 1') as a negative number.
- DO NOT TYPE ANY DOLLAR AMOUNTS IN THE TOTALS SECTIONS - THESE CELLS WILL SUM AUTOMATICALLY.
- Transportation - Mileage (Cell O26) and Weekend Work/Taxis/Mileage (Cell O27) and Tips (Cell O34) on Page 1 should sum up to Total Tips & Mileage (Cell P96) on Page 2.
- Meals/Travel (Cell O30) and Late Work/Weekend Meals (Cell O31) on Page 1 should sum up to Total Meals (Cell J96) on Page 2.
- Total Expenses paid by SPE (Cell O43) on Page 1 should sum up to Total Expenses paid by Company (Cell P57) on Page 2. Make sure both amounts are negative numbers since they are payments.
T & E Instructions
- After you click the "Print" button, a macro will be activated to check to see if all pertinent information has been completed. If all information has been provided in the correct cells, and all agreement of detail to summary for the weeks has been completed, then you will be prompted for the number of weeks to print out. Enter the number of weeks (1 - 4) you wish to print followed by the 'Enter' function and your file will print accordingly. If any other key is pressed, you will exit out of this function.
SUBMITTING YOUR EXPENSE REPORTS
After printing out your expense reports, the following steps must be completed:
Amount Due to Company:
Obtain Appropriate Signatures:
- Obtain signature from approving authority: In-Town - Managerial level and above.
Travel expense reports - Same level that approved the Travel Authorization form.
Attach Backup:
- Attach original charge card copy to all expenses. They must indicate the amount, date, place, and nature of the expenditure. Photocopies will NOT be accepted. When receipts cannot be obtained, attach a statement of explanation with any substantiation available to support the expenditures.
Send Expense Reports and Backup to Accounts Payable for processing. - Send to A/P:
Accounts Payable Fox Hills
Corporate Pointe 863
- Don't forget to attach all backup. - Don't forget to include all signatures.
TROUBLESHOOTING
Unable to Input Paying Entity, Walker Entity, Walker Department, or Social Security
Number-- 'Click' the button marked "Print" at the top of the form. PLEASE NOTE THAT THIS IS THE ONLY WAY YOU SHOULD PRINT YOUR EXPENSE REPORTS.
- Verify all information and amounts to see if they are correct. Make sure your Social Security number is correct.
- The Amount to be Reimbursed or Amount due to Company will calculate automatically in the Total Weeks section in the worksheet entitled 'T&E Week 1'.
- If money is owed to the company, attach a check payable to 'Sony Pictures Entertainment' for the amount due to your expense report when you submit it.
- Sign your name to certify that all expenditures listed on the expense report are true and correct, clearly and accurately described, and supported by receipts where necessary, and are in full accordance with Company policy.
- The supervisor and employee are jointly responsible for the propriety of the expenses reported by the employee.
- Page 1 AND Page 2 (even if blank) must be submitted to A/P or the form will be returned to the preparer/originator.
T & E Instructions
Unable to Input in a Specific Cell (Locked
Cell)-Unable to Print:
- It is recommended that you print on a Hewlett Packard III are IV printer. - Did you use the 'Print' button at the top of the expense report?
Not Enough Memory:
Totals Are Not Calculating - Hit (F9) to calculate. Any Other Questions:
- You need to input these amounts at the top section of 'T&E Week 1' ONLY. These items are linked to the other worksheets and will only allow you to enter in 'T&E Week 1'.
- Make sure you are not entering info in the General Ledger Coding section that is linked to the above cells because these cells are locked.
This cell is protected and should not be changed. This is because it contains a formula, is linked to another cell, or contains information that should not be erased.
- If you are still unable to print, then you have not completed your expense report correctly. Please read error message that appears and enter correct information. See 'Checks and Balances' section in instruction sheet.
- This T&E file uses a lot of memory. If you are currently using other Window applications, you may need to exit some of them to continue.
- Locate your contact person from the worksheet entitled 'CntctLst' and call the individual assigned to your area.
You must enable macros to complete the expense report.
Upon opening this template, you should have been prompted with a "Security Warning" dialog box (see examples below).
**************************************************************************************************************************
To enable macros:
(1) please close and reopen the template,
(2) check "Always trust macros from this source"
(3) click the "Enable Macros" button.
Upon opening this template, you should have been prompted with a "Security Warning" dialog box (see examples below).
T & E Instructions
POLICY
All entertainment expenses reimbursed by the Company must have a business purpose and satisfy IRS requirements.
The policies and procedures described in this section are not intended to supersede more restrictive divisional policies. No charges are to be billed directly to SPE unless otherwise noted.
Expenses of all employees must be reported on the In-Town/Traveling Expense Report form.
T & E Instructions
THE FILE: SET-UP The file is set up as a series of worksheets:
Instructions (this sheet)
T&E Tab 1-6: The actual templates for requests for expense reimbursement. Currency Converter: Worksheet that converts foreign currencies into US dollars.
THE FILE: HOW IT WORKS
It is the policy of Sony Pictures Entertainment (SPE) to reimburse employees for reasonable expenses incurred on Company business when in-town or travelling. The purpose of this policy is to establish equitable, consistent standards for employees and to comply with IRS guidelines and SPE Entitlement Policy.
It is inherent in this policy that moderation in frequency and expense be exercised in all areas where a reimbursement is requested by an employee.
For Non Corporate Cardholders, all expenses should be reported within 30 days afer returning from a trip. Each report should reflect the expenses for one trip. In-town expenses should be submitted on a separate Expense Report form not exceeding one month. Do not combine domestic expenses with foreign expenses on the same Expense Report form.
For Corporate Cardholders, all expenses should be reported within 30 days from the corporate card statement date. Each report should reflect the expenses for the monthly Corporate Card billing cycle. Expenses from multiple trips may be included if they occur in the same corporate card billing statement. Employees should submit only one (1) monthly expense report for all corporate card and non corporate card expenses.
Employees should report their own expenses for reimbursement. When expenses are incurred as a group, the most senior employee must pay for and report the expenditure.
PLEASE NOTE THAT THIS IS THE ONLY PC FORM ACCEPTABLE. ALL SUBMISSIONS ON UNAPPROVED FORMS WILL BE RETURNED.
The following is a detailed explanation of how to use this template. If after reading this, you still need assistance, please call the Expense Management Dept. at (310) 244-2274.
For your convenience, this file has been created to accommodate one month's worth of expenses.
Expenses being submitted still need to be input individually for the appropriate day(s).
All information included in Tabs 1-6 is linked and will calculate.
PROCEDURES General Required Information:
Blank Cells are input cells. ALL OTHER CELLS ARE PROTECTED AND CANNOT BE CHANGED!!!!
The following information is always required on an expense reimbursement form:
T&E Tab 1:
Prepared by---name of the person who prepared the expense report (Cell E6) Telephone number---preparer's telephone number (Cell I6)
Period Covered---date expenses were incurred (Cells I10 and J10)
Walker Entity Number---or your overhead entity number (Cells K23 - K42)
Walker Department Number---or your overhead department number (Cells N23 - N42) Last 6 digits of Social Security Number - (Cell I12).
Business Purpose - (Cell C18)
Approved by - Name of Approver (Cell C50)
T & E Instructions
Entering Expenses:
T&E Tab 1 is the main worksheet. Input of standard information, i.e., name, address, last 6 digits of social security number onto this sheet automatically carries onto the next five tabs of worksheets. In addition, the sheet has a total column. This column sums all six tabs and provides a grand total for reimbursement.
If more than one tab is completed, all tabs will total in the Grand Totals column on 'T&E Tab 1'. When inputting on Tabs 2 - 6, it is not necessary to put your personal information.
Once all input is complete, simply "click" the button marked "PRINT" at the top of the form. A quick check of input and agreement of detail to summary for the tabs is completed and the macro will automatically print the pages that contain data.Please note, this is the only way you can print your expense report.
Procedures for preparing and submitting an approved expense will be slightly different with regard to employees with a company sponsored corporate charge card and those who do not. Employees without a corporate charge card will be required to submit an approved expense report with original receipts and details. Before you enter any amounts, organize all your expenses by the date in which they were incurred.
Expense reports for company sponsored corporate charge cardmembers must only be submitted once a month. Other
employees that have reimbursable business related expenses must submit an expense report immediately following a business trip or at least once a month.
Note:For non-corporate cardmembers, domestic and foreign expenses must be submitted on separate expense reimbursement forms.
Before you enter any amounts, organize all your expenses by the date in which they were paid.
Instructions for company sponsored corporate charge cardholders: Verify all charges on your American Express statement.
Subtract the "Less amount paid by company on corporate card" ENTER AS A NEGATIVE AMOUNT (Cell Q46). Subtract any outstanding advances owed to the company (Cell Q45).
This will leave the amount to be reimbursed to you for any out of pocket expenses.
T & E Instructions
Expenses Paid Directly by Company for non-corporate card users:
This will leave the amount to be reimbursed to you for any out of pocket expenses Travel Advances:
-Input the date for each day to be reimbursed in the date column (Columns F thru J) on Row 22. Enter all expenses
corresponding to that specific date in the appropriate areas. Make sure that you begin inputting in 'T&E Tab 1' and proceed to 'T&E Tab 2' if needed, etc. If more than one tab is processed all expenses will be totaled on 'T&E Tab 1'.
- If there is not a description listed for an expense incurred, list this item under Other (Line 41) and provide account coding in the General Ledger Coding section. If more than one 'Other' expense is incurred, an additional line (Line 42) is provided.
Create an expense report showing the breakdown of all items on the American Express statement (airlines, rail, hotel charges, room charges, meals, laundry, entertainment meals, etc). Include any non-corporate card charges I.e. cash tips, taxis, tolls etc.
Note: Any additional receipts you have from out of pocket expenses, smaller than a half sheet of paper need to be taped down to an 8 1/2 x 11 sheet of paper on all four sides. Be sure to include any backup documentation required I.e.
receipts in accordance with policy guidelines under "Travel and Entertainment Expense Report Form (Expense Report)".
- For any unapproved charges billed to your company sponsored corporate charge card enter the amount as a negative number on (Cell Q47) the spreadsheet. This will be deducted from any out-of-pocket expenses (Cell Q49). The resulting balance (Cell Q51) is the amount that will be reimbursed to (positive balance) or deducted from (negative balance) the employee's pay period.
- If any of the expenses included were paid by SPE (ie: airfare), enter the amount(s) in Cell Q44 (ONLY in worksheet 'T&E Tab 1'). Enter this amount as a negative number.
Verify all receipts are accounted for per policy requirements Create an expense report showing the breakdown of each receipt (restaurants, airlines, rail, hotel charges, room charges, meals, laundry, entertainment meals etc.)
List any non-receipt charges I.e.cash tips, taxis, tolls etc
Subtract the "Less: Expenses paid by company for non-corporate card users" ENTER AS A NEGATIVE AMOUNT" Subtract any outstanding advances owed to the company"ENTER AS A NEGATIVE AMOUNT"
- If a travel advance was obtained for this trip, the amount of the advance must be deducted from the expense report. Enter the amount advanced in Cell Q45 (ONLY in worksheet 'T&E Tab 1') as a negative number.
- Enter explanations and detail of all items onto Page 2 for items marked on page 1 with an asterisk. CHECKS AND BALANCES
Make sure all appropriate totals on Page 1 agree with the corresponding detail on Page 2.
- Entertainment (Cell P30) on Page 1 should sum up to Total Entertainment (Cell Q86) on Page 2. - Meals/Travel (Cell P31) on Page 1 should sum up to Total Meals/Travel (Cell J105) on Page 2.
- Late Work/Weekend Meals (Cell P32) on Page 1 should sum up to Total Late Work/Weekend Meals (Cell J95) on Page 2.
T & E Instructions
PRINTING EXPENSE REPORTS
SUBMITTING YOUR EXPENSE REPORTS After printing your expense reports, the following steps must be completed: - Verify all information and amounts are correct.
Amount Due/Owed to Company
- If money is owed to the company, it will be deducted from the employee's next pay period.
- Transportation - Mileage (Cell P28) and Tolls/Parking (Cell P37) and Tips (Cell P38) on Page 1 should sum up to Total Tips, Mileage, Tolls and Parking (Cell Q105) on Page 2.
- Materials & Supplies (P39), Other (Cell P41) and Additional Other (Cell P42) on Page 1 should sum up to Total Materials & Supplies and Other (Cell Q68) on Page 2.
-Total Expenses paid by SPE for corporate card users (Cell Q46) "Less Amount Paid By Company On Corporate Card" should be entered as a negative number. This is the balance due amount from your AMEX charge card statement. If the balance due amount shows as a CREDIT from AMEX you should enter that amount as POSITIVE.
The report can be printed in three different ways ; a) by clicking the "Print" button at the top of the form, b) by choosing "File Print" on your excel menu or c) by clicking the print icon in your excel toolbar.
Once you have selected the print method, you will be asked whether or not you want to "Validate before Printing". If you select "No", the report will print even if the report is incomplete and/or missing the required fields. However, the following message will be printed on the top right hand box of the template: "Printed without validation - Only Expense Reports printed with validation will be accepted by the Expense Management Department". Please note, Expense Management Department will only accept expense reports that have been "Validated before Printing".
If you select "Yes", a macro will be activated to verify all pertinent information has been completed. If all information has been provided in the correct cells and all agreement of detail to summary for the tabs has been completed, the expense report will be printed. No message will appear on the top right hand box of the template.
The expense report will automatically print the tabs that contain data. In addition, a screen will appear that lets you choose the printer where you want the expense report to print. Your default printer is automatically highlighted unless you choose another printer.
- The Amount Reimbursed to or Deducted from Employee will calculate automatically in the Grand Totals section in the worksheet entitled 'T&E TAB 1'.
Approvals:
- Obtain approval from your immediate supervisor (VP or above) and/or any other approvals as appropriate. Attach Backup:
Do not staple any paperwork. Expense reports submitted with staples will be returned. The following receipts are always required:
All hotel folios
All original receipts for expenditures over $75 (must be taped to 8 1/2 x 11 paper on all four sides) Car rental receipts
Passenger coupons, e-tickets or boarding passes for all air and rail expenditures incurred by non-corporate card users.
All receipts (regardless of amount) for international expenditures for VAT purposes Travel Authorization Form when applicable
Car Service and Limo invoices.
T & E Instructions
- Page 1 AND Page 2 (even if blank) must be submitted to T&E Dept or the form will be returned to the preparer/originator.
Currency Conversion Worksheet Instructions
Required Fields:
Input the foreign currency amount from your AMEX statement or Hotel Folio (Cell B2). Input the US dollar amount from your AMEX statement (Cell B3).
The conversion rate is an automatic calculation (Cell B4).
Once all information is entered, verify that the check and balance formula (for corporate card charges) equals to zero (Cell G64). - Sign your name to certify all expenditures listed on the expense report are true and correct, clearly and accurately described, supported by receipts where necessary, and are in full accordance with Company policy.
- Attach original supporting documentation as required in the SPE Entitlement Policy. Photocopies will NOT be accepted. When receipts cannot be obtained, attach a statement of explanation with any substantiation available to support the expenditures.
Send approved expense reports and appropriate backup documentation to Expense Management Department at Clarington 1000 for processing;
For your convenience, an optional currency conversion worksheet is provided for easier translation of foreign currency expenditures into US Dollars.
The worksheet contains four boxes. The two upper boxes (with red borders) are your data input boxes. The left box is for corporate card charges and the right box is for non-corporate card charges (I.e. out-of-pocket). The two lower boxes (with blue borders) contain formulas that automatically converts the foreign currency amounts into US dollars.
Begin inputting all the charges from the hotel folio into each category outlined in the upper left box. Once all the charges from the hotel folio have been entered, verify that the total charges in foreign currency (Cell G33) equal your hotel folio (Cell B2).
Print the page and begin inputting all the US dollar amounts for each expense category in the main T&E template. TROUBLESHOOTING
Unable to Input in a Specific Cell (Locked
Cell)-Unable to Print:
Any Other Questions:
-Call Expense Management Dept. at (310) 244-2274.
If there are any out-of-pocket expenses (non-corporate card charges) incurred in the same trip, input the charges in the upper right box.
Any amount showing in Cell S62 represents the US dollar amount for all out-of-pocket foreign currency expenditures incurred during the trip.
The cell is protected and should not be changed. It contains a formula, is linked to another cell, or contains information that should not be erased.
- Required information is missing or you have not completed your expense report correctly. An error message should prompt you to enter the required information. Please enter the correct information as appropriate.
For Expense Management Department use only
IN-TOWN AND TRAVELING TAB 1 Revision date: February 2007
EXPENSE REPORT
APERPrepared by: Julie Meisterling Tel No: 310-244-7726
TODAY'S DATE: PERIOD COVERED
FROM TO
04/07/15 4/1/2008 4/3/2008
NAMENAME OFFICE PHONE NUMBER Last 6 digits of SS#
Julie Meisterling 310-244-7726 06-4066
STREET ADDRESSSTREET ADDRESS CITY
10985 Bluffside Dr. # 5213 Studio City
STATESTATE ZIP: TITLE: DEPT/PROD
California 91604 Assistant, Special Events 5215 5254
BUSINESS PURPOSEBUSINESS PURPOSE
CTIA Convention 2008
ITINERARY FROMITINERARY
DATES GENERAL LEDGER CODING Tab 1 One
ITEM 04/01/08 04/03/08 ENTITY ACCOUNT DEPT PRODUCT TOTALS GRAND TOTALS
TRANSPORTATION - AIR/RAIL -615-0001- $0.00 $0.00
TRANSPORTATION - CAR RENTAL -615-0010- $0.00 $0.00
TRANSPORTATION - LIMO/CAR SERVICE -615-0011- $0.00 $0.00
GAS (RESTRICTED) -615-0015- $0.00 $0.00 TRANSPORTATION - TAXIS $25.00 $20.00 1281 -615-0007- 5249 $45.00 $45.00 TRANSPORTATION - MILEAGE * -615-0012- $0.00 $0.00 HOTEL -615-0003- $0.00 $0.00 ENTERTAINMENT* -615-0002- $0.00 $0.00 MEALS/TRAVEL * -615-0004- $0.00 $0.00
LATE WORK/WEEKEND MEALS * -605-0301- $0.00 $0.00
TELEPHONE -624-0001- $0.00 $0.00
CELLPHONE (TEMPLATE REQUIRED) -624-0010- $0.00 $0.00
DSL-HOME USE -627-0004- $0.00 $0.00
INTERNET-HOTEL -624-0007- $0.00 $0.00
TOLLS, PARKING * -615-0015- $0.00 $0.00
TIPS * $7.00 $10.00 1281 -615-0015- 5249 $17.00 $42.00
Materials & Supplies*MATERIALS & SUPPLIES* -628-0000- $0.00 $0.00
BOOKS, SUBSCRIPTION, & DUES -639-0000- $0.00 $0.00
OTHER (EXPLANATION REQUIRED)* $0.00 $0.00
ADDITIONAL OTHER (EXPLAN REQ'D)* $0.00 $0.00
TOTALS $32.00 $30.00 $0.00 $0.00 $0.00 SUBTOTAL OF BUSINESS EXPENSES $62.00 $87.00
SIGNATURE OF EMPLOYEE***
Less Cash Advance (not on the Corporate Card)
SIGNATURE OF APPROVING AUTHORITY Less Amount Paid By Company On Corporate Card $0.00
Less Amount of Unapproved Charges on Corporate Card***(personal charge)
ACCOUNTING APPROVALPRINT NAME OF APPROVER Amount of Employee Out-Of-Pocket Expenses (not paid by Company) $87.00
Robert Oswaks, EVP Marketing
* EXPLANATION OF EXPENSES MUST BE COMPLETED ON PAGE TWO Net Amount Reimbursed To / (Deducted From) Employee $87.00
***I authorize the Company to deduct unapproved amounts charged on my Corporate Card from my expense reimbursement or wages Less Expenses Paid by Company for Non-Corporate Card Users 615-0001
Enter Dollar Amount in PARENTHESIS. DO NOT ITEMIZE PERSONAL CHARGES ON THE EXPENSE REPORT. Enter dollar amount in PARENTHESIS. If it is a credit from AMEX enter as POSITIVE. Remember to submit a Travel Authorization form. Remember to submit a Travel Authorization form.
Remember to submit a Travel Authorization form.
Remember to submit a Travel Authorization form.
Please provide a specific Business Purpose on Page 2.
TAB 1 PAGE TWO
BREAKDOWN OF HOTEL FOLIO Day 1 Day 2 Day 3 Day 4 Day 5 Total Amount EXPLANATION OF MATERIALS & SUPPLIES AND OTHER
OPTIONAL WORKSHEET - Data entered on this sheet must be entered on Page One. Date Amount
Room Rate plus taxes Entertainment Breakfast Lunch Dinner Telephone Internet Movies "Other" Laundry Parking
Other (Please Explain)
TOTAL HOTEL CHARGES (To Agree with Hotel Bill) $0.00 TOTAL M&S+OTHR (To Agree with TAB 1 PAGE 1) $0.00
EXPLANATION OF ENTERTAINMENT EXPENSEEXPLANATION OF ENTERTAINMENT EXPENSE
Date Name of Business Name of Person Entertained Company Title Business Purpose (Specific Explanation Required) Amount
TOTAL ENTERTAINMENT (To Agree with TAB 1 PAGE 1) $0.00
EXPLANATION OF LATE WORK/WEEKEND MEALS EXPLANATION OF TIPS, MILEAGE, TOLLS AND PARKING
Date Hrs Wrk Name of Person Breakfast Lunch Dinner Total Date Amount
04/01/08 Sky cap gratuity at Burbank $7.00
04/03/08 Gratuity for bell man for meeting suites $10.00
TOTAL LATE WORK/WEEKEND MEALS (To Agree with TAB 1 PAGE 1) $0.00
EXPLANATION OF MEALS/TRAVEL
Date Name of Person Breakfast Lunch Dinner Total
$0.00 $0.00
For Expense Management Department use only
IN-TOWN AND TRAVELING TAB 2
EXPENSE REPORT
APERPrepared by: Julie Meisterling Tel No: 310-244-7726
TODAY'S DATE: PERIOD COVERED
FROM TO
04/07/15 4/1/2008 4/3/2008
NAMENAME OFFICE PHONE NUMBER SS#
Julie Meisterling 310-244-7726 06-4066
STREET ADDRESSSTREET ADDRESS CITY
10985 Bluffside Dr. # 5213 Studio City
STATESTATE ZIP: TITLE: DEPT/PROD
California 91604 Assistant, Special Events 5215 5254
BUSINESS PURPOSEBUSINESS PURPOSE
CTIA Convention 2008
ITINERARY FROMITINERARY
DATES GENERAL LEDGER CODING Tab 2 One
ITEM 04/01/08 04/03/08 ENTITY ACCOUNT DEPT PRODUCT TOTALS
TRANSPORTATION - AIR/RAIL -615-0001- $0.00
TRANSPORTATION - CAR RENTAL -615-0010- $0.00
TRANSPORTATION - LIMO/CAR SERVICE -615-0011- $0.00
GAS (RESTRICTED) -615-0015- $0.00 TRANSPORTATION - TAXIS -615-0007- $0.00 TRANSPORTATION - MILEAGE * -615-0012- $0.00 HOTEL -615-0003- $0.00 ENTERTAINMENT* -615-0002- $0.00 MEALS/TRAVEL * -615-0004- $0.00
LATE WORK/WEEKEND MEALS * -605-0301- $0.00
TELEPHONE -624-0001- $0.00
CELLPHONE (TEMPLATE REQUIRED) -624-0010- $0.00
DSL-HOME USE -627-0004- $0.00
INTERNET-HOTEL -624-0007- $0.00
TOLLS, PARKING * -615-0015- $0.00
TIPS * $5.00 $5.00 1281 -615-0015- 5249 $10.00
MATERIALS & SUPPLIES* -628-0000- $0.00
BOOKS, SUBSCRIPTION, & DUES -639-0000- $0.00
OTHER (EXPLANATION REQUIRED)* $0.00
ADDITIONAL OTHER (EXPLAN REQ'D)* $0.00
TOTALS $5.00 $5.00 $0.00 $0.00 $0.00 SUBTOTAL OF BUSINESS EXPENSES $10.00
SIGNATURE OF EMPLOYEE***
SIGNATURE OF APPROVING AUTHORITY
ACCOUNTING APPROVAL
* EXPLANATION OF EXPENSES MUST BE COMPLETED ON PAGE TWO
TAB 2 PAGE TWO
BREAKDOWN OF HOTEL FOLIO Day 1 Day 2 Day 3 Day 4 Day 5 Total Amount EXPLANATION OF MATERIAL&SUPPLIES AND OTHER
OPTIONAL WORKSHEET - Data entered on this sheet must be entered on Page One. Date Amount
Room Rate plus taxes Entertainment Breakfast Lunch Dinner Telephone Internet Movies "Other" Laundry Parking
Other (Please Explain)
TOTAL HOTEL CHARGES (To Agree with Hotel Bill) $0.00 TOTAL M&S+OTHR (To Agree with TAB 2 PAGE 1) $0.00
EXPLANATION OF ENTERTAINMENT EXPENSEEXPLANATION OF ENTERTAINMENT EXPENSE
Date Name of Business Name of Person Entertained Company Title Business Purpose (Specific Explanation Required) Amount
TOTAL ENTERTAINMENT (To Agree with TAB 2 PAGE 1) $0.00
EXPLANATION OF LATE WORK/WEEKEND MEALS EXPLANATION OF TIPS, MILEAGE, TOLLS AND PARKING
Date Hrs Wrk Name of Person Breakfast Lunch Dinner Total Date Amount
04/01/08 Gratuity for bell man upon check in $5.00
04/03/08 Gratuity for bell man upon check out $5.00
TOTAL LATE WORK/WEEKEND MEALS (To Agree with TAB 2 PAGE 1) $0.00
EXPLANATION OF MEALS/TRAVEL
Date Name of Person Breakfast Lunch Dinner Total
$0.00 $0.00
For Expense Management Department use only
IN-TOWN AND TRAVELING TAB 3
EXPENSE REPORT
APERPrepared by: Julie Meisterling Tel No: 310-244-7726
TODAY'S DATE: PERIOD COVERED
FROM TO
04/07/15 4/1/2008 4/3/2008
NAMENAME OFFICE PHONE NUMBER SS#
Julie Meisterling 310-244-7726 06-4066
STREET ADDRESSSTREET ADDRESS CITY
10985 Bluffside Dr. # 5213 Studio City
STATESTATE ZIP: TITLE: DEPT/PROD
California 91604 Assistant, Special Events 5215 5254
BUSINESS PURPOSEBUSINESS PURPOSE
CTIA Convention 2008
ITINERARY FROMITINERARY
DATES GENERAL LEDGER CODING Tab 3 One
ITEM 04/01/08 04/03/08 ENTITY ACCOUNT DEPT PRODUCT TOTALS
TRANSPORTATION - AIR/RAIL -615-0001- $0.00
TRANSPORTATION - CAR RENTAL -615-0010- $0.00
TRANSPORTATION - LIMO/CAR SERVICE -615-0011- $0.00
GAS (RESTRICTED) -615-0015- $0.00 TRANSPORTATION - TAXIS -615-0007- $0.00 TRANSPORTATION - MILEAGE * -615-0012- $0.00 HOTEL -615-0003- $0.00 ENTERTAINMENT* -615-0002- $0.00 MEALS/TRAVEL * -615-0004- $0.00
LATE WORK/WEEKEND MEALS * -605-0301- $0.00
TELEPHONE -624-0001- $0.00
CELLPHONE (TEMPLATE REQUIRED) -624-0010- $0.00
DSL-HOME USE -627-0004- $0.00
INTERNET-HOTEL -624-0007- $0.00
TOLLS, PARKING * -615-0015- $0.00
TIPS * $5.00 $5.00 1281 -615-0015- 5249 $10.00
MATERIALS & SUPPLIES* -628-0000- $0.00
BOOKS, SUBSCRIPTION, & DUES -639-0000- $0.00
OTHER (EXPLANATION REQUIRED)* $0.00
ADDITIONAL OTHER (EXPLAN REQ'D)* $0.00
TOTALS $5.00 $5.00 $0.00 $0.00 $0.00 SUBTOTAL OF BUSINESS EXPENSES $10.00
SIGNATURE OF EMPLOYEE***
SIGNATURE OF APPROVING AUTHORITY
ACCOUNTING APPROVAL
* EXPLANATION OF EXPENSES MUST BE COMPLETED ON PAGE TWO
TAB 3 PAGE TWO
BREAKDOWN OF HOTEL FOLIO Day 1 Day 2 Day 3 Day 4 Day 5 Total Amount EXPLANATION OF MATERIAL&SUPPLIES AND OTHER
OPTIONAL WORKSHEET - Data entered on this sheet must be entered on Page One. Date Amount
Room Rate plus taxes Entertainment Breakfast Lunch Dinner Telephone Internet Movies "Other" Laundry Parking
Other (Please Explain)
TOTAL HOTEL CHARGES (To Agree with Hotel Bill) $0.00 TOTAL M&S+OTHR (To Agree with TAB 3 PAGE 1) $0.00
EXPLANATION OF ENTERTAINMENT EXPENSEEXPLANATION OF ENTERTAINMENT EXPENSE
Date Name of Business Name of Person Entertained Company Title Business Purpose (Specific Explanation Required) Amount
TOTAL ENTERTAINMENT (To Agree with TAB 3 PAGE 1) $0.00
EXPLANATION OF LATE WORK/WEEKEND MEALS EXPLANATION OF TIPS, MILEAGE, TOLLS AND PARKING
Date Hrs Wrk Name of Person Breakfast Lunch Dinner Total Date Amount
04/01/08 Gratuity for bell man delivering to room $5.00 04/03/08 Gratuity for bell man assistance with cab $5.00
TOTAL LATE WORK/WEEKEND MEALS (To Agree with TAB 3 PAGE 1) $0.00
EXPLANATION OF MEALS/TRAVEL
Date Name of Person Breakfast Lunch Dinner Total
$0.00 $0.00
For Expense Management Department use only
IN-TOWN AND TRAVELING TAB 4
EXPENSE REPORT
APERPrepared by: Julie Meisterling Tel No: 310-244-7726
TODAY'S DATE: PERIOD COVERED
FROM TO
04/07/15 4/1/2008 4/3/2008
NAMENAME OFFICE PHONE NUMBER SS#
Julie Meisterling 310-244-7726 06-4066
STREET ADDRESSSTREET ADDRESS CITY
10985 Bluffside Dr. # 5213 Studio City
STATESTATE ZIP: TITLE: DEPT/PROD
California 91604 Assistant, Special Events 5215 5254
BUSINESS PURPOSEBUSINESS PURPOSE
CTIA Convention 2008
ITINERARY FROMITINERARY
DATES GENERAL LEDGER CODING Tab 4 One
ITEM 04/03/08 ENTITY ACCOUNT DEPT PRODUCT TOTALS
TRANSPORTATION - AIR/RAIL -615-0001- $0.00
TRANSPORTATION - CAR RENTAL -615-0010- $0.00
TRANSPORTATION - LIMO/CAR SERVICE -615-0011- $0.00
GAS (RESTRICTED) -615-0015- $0.00 TRANSPORTATION - TAXIS -615-0007- $0.00 TRANSPORTATION - MILEAGE * -615-0012- $0.00 HOTEL -615-0003- $0.00 ENTERTAINMENT* -615-0002- $0.00 MEALS/TRAVEL * -615-0004- $0.00
LATE WORK/WEEKEND MEALS * -605-0301- $0.00
TELEPHONE -624-0001- $0.00
CELLPHONE (TEMPLATE REQUIRED) -624-0010- $0.00
DSL-HOME USE -627-0004- $0.00
INTERNET-HOTEL -624-0007- $0.00
TOLLS, PARKING * -615-0015- $0.00
TIPS * $5.00 1281 -615-0015- 5249 $5.00
MATERIALS & SUPPLIES* -628-0000- $0.00
BOOKS, SUBSCRIPTION, & DUES -639-0000- $0.00
OTHER (EXPLANATION REQUIRED)* $0.00
ADDITIONAL OTHER (EXPLAN REQ'D)* $0.00
TOTALS $5.00 $0.00 $0.00 $0.00 $0.00 SUBTOTAL OF BUSINESS EXPENSES $5.00
SIGNATURE OF EMPLOYEE***
SIGNATURE OF APPROVING AUTHORITY
ACCOUNTING APPROVAL
* EXPLANATION OF EXPENSES MUST BE COMPLETED ON PAGE TWO
TAB 4 PAGE TWO
BREAKDOWN OF HOTEL FOLIO Day 1 Day 2 Day 3 Day 4 Day 5 Total Amount EXPLANATION OF MATERIAL&SUPPLIES AND OTHER
OPTIONAL WORKSHEET - Data entered on this sheet must be entered on Page One. Date Amount
Room Rate plus taxes Entertainment Breakfast Lunch Dinner Telephone Internet Movies "Other" Laundry Parking
Other (Please Explain)
TOTAL HOTEL CHARGES (To Agree with Hotel Bill) $0.00 TOTAL M&S+OTHR (To Agree with TAB 4 PAGE 1) $0.00
EXPLANATION OF ENTERTAINMENT EXPENSEEXPLANATION OF ENTERTAINMENT EXPENSE
Date Name of Business Name of Person Entertained Company Title Business Purpose (Specific Explanation Required) Amount
TOTAL ENTERTAINMENT (To Agree with TAB 4 PAGE 1) $0.00
EXPLANATION OF LATE WORK/WEEKEND MEALS EXPLANATION OF TIPS, MILEAGE, TOLLS AND PARKING
Date Hrs Wrk Name of Person Breakfast Lunch Dinner Total Date Amount
04/03/08 Gratuity for sky cap at McCarron $5.00
TOTAL LATE WORK/WEEKEND MEALS (To Agree with TAB 4 PAGE 1) $0.00
EXPLANATION OF MEALS/TRAVEL
Date Name of Person Breakfast Lunch Dinner Total
$0.00 $0.00
For Expense Management Department use only
IN-TOWN AND TRAVELING TAB 5
EXPENSE REPORT
APERPrepared by: Julie Meisterling Tel No: 310-244-7726
TODAY'S DATE: PERIOD COVERED
FROM TO
04/07/15 4/1/2008 4/3/2008
NAMENAME OFFICE PHONE NUMBER SS#
Julie Meisterling 310-244-7726 06-4066
STREET ADDRESSSTREET ADDRESS CITY
10985 Bluffside Dr. # 5213 Studio City
STATESTATE ZIP: TITLE: DEPT/PROD
California 91604 Assistant, Special Events 5215 5254
BUSINESS PURPOSEBUSINESS PURPOSE
ITINERARY FROMITINERARY
DATES GENERAL LEDGER CODING Tab 5 One
ITEM ENTITY ACCOUNT DEPT PRODUCT TOTALS
TRANSPORTATION - AIR/RAIL -615-0001- $0.00
TRANSPORTATION - CAR RENTAL -615-0010- $0.00
TRANSPORTATION - LIMO/CAR SERVICE -615-0011- $0.00
GAS (RESTRICTED) -615-0015- $0.00 TRANSPORTATION - TAXIS -615-0007- $0.00 TRANSPORTATION - MILEAGE * -615-0012- $0.00 HOTEL -615-0003- $0.00 ENTERTAINMENT* -615-0002- $0.00 MEALS/TRAVEL * -615-0004- $0.00
LATE WORK/WEEKEND MEALS * -605-0301- $0.00
TELEPHONE -624-0001- $0.00
CELLPHONE (TEMPLATE REQUIRED) -624-0010- $0.00
DSL-HOME USE -627-0004- $0.00
INTERNET-HOTEL -624-0007- $0.00
TOLLS, PARKING * -615-0015- $0.00
TIPS * -615-0015- $0.00
MATERIALS & SUPPLIES* -628-0000- $0.00
BOOKS, SUBSCRIPTION, & DUES -639-0000- $0.00
OTHER (EXPLANATION REQUIRED)* $0.00
ADDITIONAL OTHER (EXPLAN REQ'D)* $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 SUBTOTAL OF BUSINESS EXPENSES $0.00
SIGNATURE OF EMPLOYEE***
SIGNATURE OF APPROVING AUTHORITY
ACCOUNTING APPROVAL
* EXPLANATION OF EXPENSES MUST BE COMPLETED ON PAGE TWO
TAB 5 PAGE TWO
BREAKDOWN OF HOTEL FOLIO Day 1 Day 2 Day 3 Day 4 Day 5 Total Amount EXPLANATION OF MATERIAL&SUPPLIES AND OTHER
OPTIONAL WORKSHEET - Data entered on this sheet must be entered on Page One. Date Amount
Room Rate plus taxes Entertainment Breakfast Lunch Dinner Telephone Internet Movies "Other" Laundry Parking
Other (Please Explain)
TOTAL HOTEL CHARGES (To Agree with Hotel Bill) $0.00 TOTAL M&S+OTHR (To Agree with TAB 5 PAGE 1) $0.00
EXPLANATION OF ENTERTAINMENT EXPENSEEXPLANATION OF ENTERTAINMENT EXPENSE
Date Name of Business Name of Person Entertained Company Title Business Purpose (Specific Explanation Required) Amount
TOTAL ENTERTAINMENT (To Agree with TAB 5 PAGE 1) $0.00
EXPLANATION OF LATE WORK/WEEKEND MEALS EXPLANATION OF TIPS, MILEAGE, TOLLS AND PARKING
Date Hrs Wrk Name of Person Breakfast Lunch Dinner Total Date Amount
TOTAL LATE WORK/WEEKEND MEALS (To Agree with TAB 5 PAGE 1) $0.00
EXPLANATION OF MEALS/TRAVEL
Date Name of Person Breakfast Lunch Dinner Total
$0.00 $0.00
For Expense Management Department use only
IN-TOWN AND TRAVELING TAB 6
EXPENSE REPORT
APERPrepared by: Julie Meisterling Tel No: 310-244-7726
TODAY'S DATE: PERIOD COVERED
FROM TO
04/07/15 4/1/2008 4/3/2008
NAMENAME OFFICE PHONE NUMBER SS#
Julie Meisterling 310-244-7726 06-4066
STREET ADDRESSSTREET ADDRESS CITY
10985 Bluffside Dr. # 5213 Studio City
STATESTATE ZIP: TITLE: DEPT/PROD
California 91604 Assistant, Special Events 5215 5254
BUSINESS PURPOSEBUSINESS PURPOSE
ITINERARY FROMITINERARY
DATES GENERAL LEDGER CODING Tab 6 One
ITEM ENTITY ACCOUNT DEPT PRODUCT TOTALS
TRANSPORTATION - AIR/RAIL -615-0001- $0.00
TRANSPORTATION - CAR RENTAL -615-0010- $0.00
TRANSPORTATION - LIMO/CAR SERVICE -615-0011- $0.00
GAS (RESTRICTED) -615-0015- $0.00 TRANSPORTATION - TAXIS -615-0007- $0.00 TRANSPORTATION - MILEAGE * -615-0012- $0.00 HOTEL -615-0003- $0.00 ENTERTAINMENT* -615-0002- $0.00 MEALS/TRAVEL * -615-0004- $0.00
LATE WORK/WEEKEND MEALS * -605-0301- $0.00
TELEPHONE -624-0001- $0.00
CELLPHONE (TEMPLATE REQUIRED) -624-0010- $0.00
DSL-HOME USE -627-0004- $0.00
INTERNET-HOTEL -624-0007- $0.00
TOLLS, PARKING * -615-0015- $0.00
TIPS * -615-0015- $0.00
MATERIALS & SUPPLIES* -628-0000- $0.00
BOOKS, SUBSCRIPTION, & DUES -639-0000- $0.00
OTHER (EXPLANATION REQUIRED)* $0.00
ADDITIONAL OTHER (EXPLAN REQ'D)* $0.00
TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 SUBTOTAL OF BUSINESS EXPENSES $0.00
SIGNATURE OF EMPLOYEE***
SIGNATURE OF APPROVING AUTHORITY
ACCOUNTING APPROVAL
* EXPLANATION OF EXPENSES MUST BE COMPLETED ON PAGE TWO
TAB 6 PAGE TWO
BREAKDOWN OF HOTEL FOLIO Day 1 Day 2 Day 3 Day 4 Day 5 Total Amount EXPLANATION OF MATERIAL&SUPPLIES AND OTHER
OPTIONAL WORKSHEET - Data entered on this sheet must be entered on Page One. Date Amount
Room Rate plus taxes Entertainment Breakfast Lunch Dinner Telephone Internet Movies "Other" Laundry Parking
Other (Please Explain)
TOTAL HOTEL CHARGES (To Agree with Hotel Bill) $0.00 TOTAL M&S+OTHR (To Agree with TAB 6 PAGE 1) $0.00
EXPLANATION OF ENTERTAINMENT EXPENSEEXPLANATION OF ENTERTAINMENT EXPENSE
Date Name of Business Name of Person Entertained Company Title Business Purpose (Specific Explanation Required) Amount
TOTAL ENTERTAINMENT (To Agree with TAB 6 PAGE 1) $0.00
EXPLANATION OF LATE WORK/WEEKEND MEALS EXPLANATION OF TIPS, MILEAGE, TOLLS AND PARKING
Date Hrs Wrk Name of Person Breakfast Lunch Dinner Total Date Amount
TOTAL LATE WORK/WEEKEND MEALS (To Agree with TAB 6 PAGE 1) $0.00
EXPLANATION OF MEALS/TRAVEL
Date Name of Person Breakfast Lunch Dinner Total
$0.00 $0.00
SUBMIT WITH EXPENSE REPORT Foreign Currency Converter WorksheetSony Pictures Entertainment
T&E 4-15-08.xls 26 04/07/2015
Foreign currency 1.00
US dollar 1.00
Conversion rate 1.00000
Instruction: Enter Data from the Hotel Folio/Statement Instruction: Enter Data from non-Corporate AMEX receipts in Foreign Currency
Foreign Currency Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Foreign Currency Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10
Room Room
Room Tax Room Tax
Entertainment Entertainment
Telephone Telephone
Movie Movie
Internet Internet
Gym Gym
Limo/Car Service Limo/Car Service
Parking/Valet Parking/Valet
Taxi Taxi
Laundry/Dry cleaning Laundry/Dry cleaning
Other Personal charges Other Personal charges
Minibar Minibar
Breakfast Breakfast
Lunch Lunch
Dinner Dinner
Total Hotel bill - in foreign currency (must tie to cell B2 above) 0.00 Total 0.00
Instruction: Enter the below amounts in the T&E template Instruction: Enter the below amounts in the T&E template
Note: The data below is the automatic calculation of your foreign charges to US dollars. Note: The data below is the automatic calculation of your foreign charges to US dollars.
USD Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 USD Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10
Room - - - - Room - - - -
Room Tax - - - - Room Tax - - - -
Total room and Tax - - - - Total room and Tax - - - -
Entertainment - - - - Entertainment - - - -
Telephone - - - - Telephone - - - -
Movie - - - - Movie - - - -
Internet - - - - Internet - - - -
Gym - - - - Gym - - - -
Limo/Car Service - - - - Limo/Car Service - - - -
Parking/Valet - - - - Parking/Valet - - - -
Taxi - - - - Taxi - - - -
Laundry/Dry cleaning - - - - Laundry/Dry cleaning - - - -
Other Personal charges - - - - Other Personal charges - - - -
Total meals - - - - Total meals - - - -
Minibar - - - - Minibar - - - -
Breakfast - - - - Breakfast - - - -
Lunch - - - - Lunch - - - -
Dinner - - - - Dinner - - - -
Total Hotel bill - in USD (must tie to cell B3 above) - Total -
Difference-should be zero (1.00)
Enter foreign currency amount from Hotel Folio or AMEX statement
Enter USD amount from AMEX statement
SUBMIT WITH EXPENSE REPORT Foreign Currency Converter WorksheetSony Pictures Entertainment
T&E 4-15-08.xls 27 04/07/2015
Enter foreign currency amount from Hotel Folio or AMEX statement
B2:
Enter USD amount from AMEX statement
B3:
This is your exchange rate which is an automatic calculation.