jagomart
digital resources
picture1_Spreadsheet For Expenses 40720 | Expense Report Form En Us 5226776


 219x       Filetype XLSX       File size 0.04 MB       Source: www.emerson.com


File: Spreadsheet For Expenses 40720 | Expense Report Form En Us 5226776
sheet 1 expense form this expense report is designed to be used with microsoft excel version 70 date calculation formulas enter requested information in the white boxes at the top ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: EXPENSE FORM
This expense report is designed to be used with Microsoft Excel Version 7.0











DATE CALCULATION FORMULAS


Enter requested information in the white boxes at the top and in the expense form
























1900 1900

Cells with blue text are for data entry and are unprotected.
























5213 5213.42857142857 3
Hold the mouse cursor over any cell with a red dot for additional help




























































































REFUND PAID BY: CASH:
FOR CASH, ERASE 'X' BY CHECK

























OR--CHECK : Enter a "X" if you would like a check instead of cash. Delete the "X" if you would prefer cash. x
REFUND WILL BE PAID BY CHECK
























































ENTER WEEK ENDING DATE: MONTH DAY YEAR

























MUST BE INTEGER 1-12-->
The date should be a Saturday. Expense reports are for the week ending date.

























'MUST BE A SATURDAY'-->

#N/A

























































DEPARTMENT NUMBER : Enter your department number.



































Expenses this report: $-




















TRAVEL ADVANCE RECEIVED: Enter the amount of money received in advance for this travel expense report





Company owes me:













































EMERSON ELECTRIC CO.











Rev F















8000 W. FLORISSANT AVE.




























ST. LOUIS, MO 63136































Name


Badge
Station Week Ending



















Enter your name.




Enter your employee identification number. If you do not have one, enter N/A

Enter your work telephone extension number. If you do not have one, enter N/A

#N/A




















Subsidiary/Division

Headquarters

Department



















WHITE-RODGERS
ST. LOUIS

Enter the name of your department.






















Business purpose of trip


























Enter a brief description of the purpose of the trip.
































































DAILY TRAVEL EXPENSES


























Day: Sun Mon Tues Wed Thurs Fri Sat

















EXPENSE ITEMS


Date: 24 25 26 27 28 29 30 TOTAL




















MEALS: Breakfast:(Incl tip)



























Lunch: "



























Dinner: "



























*Business /Entertainment























SUBTOTAL "A"




















**Transportation:



























Auto Mileage: detail below




















Lodging:



























Other Expense:





























Taxi Fares



























Laundry & valet



























Telephone & telegrams



























Parking



























Gasoline



























Auto rental



























Tips



























Airport Tax



























Mexico-Work Visa
























































SUBTOTAL "B"




















TOTALS

#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! -















* Supply details on back of standard expense form




























**Commercial transportation ticket(s) acquired by:







Signature




















Enter "X" if you paid cash for your tickets. Enter the amount in the transportation row above.

CASH


























Enter "X" if you purchased your tickets with your credit card. Enter the amount in the transportation row above.

CREDIT CARD




Approved by




















Enter "X" if the company purchased your tickets.

COMPANY PURCHASED

























Mode(s) of transportation utilized:








ACCOUNT CHARGED

AMOUNT


















AIR
COMPANY CAR



00170



















COMPANY PLANE
Enter "X" if you rented a car. Enter the amount of the rental expense above.
CAR RENTAL



-600




















RAIL
Enter "X" if you used your personal car in conjunction with this travel expense report. Enter the miles driven in the auto mileage report below.
PERSONAL CAR



-606




















BUS






-610




























-602

















AUTO MILEAGE REPORT




Miles Total
























Sunday

0
























Monday

0
























Tuesday

0



Total



















Wednesday

0

CASH FUND SUMMARY





















Thursday

0
I owe Company-Last Report


If you owe the company money from a previous travel expense report, enter it here. $0.00


















Friday

0
(Co. owes me)-last report


If the company owes you money from a previous travel expense report, enter it here as a negative number. Example: Company owes you $100.75, enter -100.75 $0.00


















Saturday

0
Received From Company


$-


















TOTAL

$0.00
TOTAL TO ACCOUNT FOR:


$0.00




















Rate/Mile Enter the amount that the company is reimbursing mileage in $/mile i.e. $0.56 $0.540

Expenses this report


$0.00















The following receipts must be attached: Airline, Rail, Bus, Car Rental







I owe Company



















and other non-local transportation paid by cash or charged to the company --







(Company owes Me) pay by:



















Lodging -- Laundry and valet -- All other expenditures of $25.00 or more.









CHECK






































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































NMONTH MONTH
DAY

























1 JANUARY
0 SATURDAY
























2 FEBRUARY
1 SUNDAY
























3 MARCH
2 MONDAY
























4 APRIL
3 TUESDAY
























5 MAY
4 WEDNESDAY
























6 JUNE
5 THURSDAY
























7 JULY
6 FRIDAY
























8 AUGUST



























9 SEPTEMBER



























10 OCTOBER



























11 NOVEMBER



























12 DECEMBER

























The words contained in this file might help you see if this file matches what you are looking for:

...Sheet expense form this report is designed to be used with microsoft excel version date calculation formulas enter requested information in the white boxes at top and cells blue text are for data entry unprotected hold mouse cursor over any cell a red dot additional help refund paid by cash erase x check orcheck quot if you would like instead of delete prefer will week ending month day year must integer gt should saturday reports na department number your expenses travel advance received amount money company owes me emerson electric co rev f w florissant ave st louis mo name badge station employee identification do not have one work telephone extension subsidiarydivision headquarters whiterodgers business purpose trip brief description daily sun mon tues wed thurs fri sat items total meals breakfast incl tip lunch dinner entertainment subtotal transportation auto mileage detail below lodging other taxi fares laundry amp valet telegrams parking gasoline rental tips airport tax mexicowor...

no reviews yet
Please Login to review.