| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||
2 | EXPENSE REPORT TEMPLATE | https://goo.gl/llbWzi | |||||||||
3 | |||||||||||
4 | EMPLOYEE | MANAGER | DATE SUBMITTED | ||||||||
5 | EMPLOYEE ID | MILEAGE RATE | AS OF JAN 2017 | $0.535 | REPORT BEGINS | ||||||
6 | PURPOSE OF EXPENSE | REPORT ENDS | |||||||||
7 | |||||||||||
8 | EXPENSE REPORT | ||||||||||
9 | EXPENSE CATEGORY | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | Totals | ||
10 | 7/29/18 | 7/30/18 | 7/31/18 | 8/1/18 | 8/2/18 | 8/3/18 | 8/4/18 | ||||
11 | TRANSPORTATION | ||||||||||
12 | Air | $600.00 | $600.00 | ||||||||
13 | Car Rental | $120.00 | $120.00 | ||||||||
14 | Taxi/Uber/Lyft | $11.00 | $11.00 | $22.00 | |||||||
15 | Parking | $25.00 | $25.00 | ||||||||
16 | Tolls | $5.35 | $5.35 | $10.70 | |||||||
17 | Train | $0.00 | |||||||||
18 | Mileage *enter number of miles, only | 50 | 50 | ||||||||
19 | $0.535 | $0.535 | $0.535 | $0.535 | $0.535 | $0.535 | $0.535 | ||||
20 | $26.75 | $0.00 | $0.00 | $0.00 | $26.75 | $0.00 | $0.00 | $53.50 | |||
21 | Other (describe) | $0.00 | |||||||||
22 | TRANSPORTATION TOTAL | $788.10 | $0.00 | $0.00 | $0.00 | $43.10 | $0.00 | $0.00 | $831.20 | ||
23 | MEALS | ||||||||||
24 | Breakfast | $0.00 | |||||||||
25 | Lunch | $0.00 | |||||||||
26 | Dinner | $0.00 | |||||||||
27 | Other (describe) | $0.00 | |||||||||
28 | MEALS TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
29 | ACCOMMODATIONS | ||||||||||
30 | Hotel | $0.00 | |||||||||
31 | Airbnb | $0.00 | |||||||||
32 | Other (describe) | $0.00 | |||||||||
33 | ACCOMMODATIONS TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
34 | PERSONAL ENTERTAINMENT | ||||||||||
35 | Event Tickets/Admission | $0.00 | |||||||||
36 | Other (describe) | $0.00 | |||||||||
37 | PERSONAL ENTERTAINMENT TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
38 | PROMO | ||||||||||
39 | Misc. Promotional Expense | $0.00 | |||||||||
40 | Trade Shows | $0.00 | |||||||||
41 | Printing | $0.00 | |||||||||
42 | Postage | $0.00 | |||||||||
43 | PROMO TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
44 | INCIDENTALS | ||||||||||
45 | Tips | $0.00 | |||||||||
46 | Office Supplies | $0.00 | |||||||||
47 | Materials | $0.00 | |||||||||
48 | Passport/Visa Fees | $0.00 | |||||||||
49 | Medical/Immunization Fees | $0.00 | |||||||||
50 | Laundry | $0.00 | |||||||||
51 | Other (describe) | $0.00 | |||||||||
52 | Other (describe) | $0.00 | |||||||||
53 | INCIDENTALS TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
54 | COMMUNICATIONS | ||||||||||
55 | Misc. Promotional Expense | $0.00 | |||||||||
56 | Trade Shows | $0.00 | |||||||||
57 | Printing | $0.00 | |||||||||
58 | Postage | $0.00 | |||||||||
59 | COMMUNICATIONS TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
60 | OTHER | ||||||||||
61 | Training/Seminar Fees | $0.00 | |||||||||
62 | Other (describe) | $0.00 | |||||||||
63 | Other (describe) | $0.00 | |||||||||
64 | Other (describe) | $0.00 | |||||||||
65 | OTHER TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
66 | TOTAL PER DAY | $788.10 | $0.00 | $0.00 | $0.00 | $43.10 | $0.00 | $0.00 | $831.20 | ||
67 | |||||||||||
68 | BUSINESS ENTERTAINMENT DETAIL REPORT | ||||||||||
69 | PERSONS ENTERTAINED | COMPANY REPRESENTED | PURPOSE | EVENT LOCATION | DATE | EXPENSE | |||||
70 | $250.00 | ||||||||||
71 | |||||||||||
72 | |||||||||||
73 | |||||||||||
74 | BUSINESS ENTERTAINMENT TOTAL | $250.00 | |||||||||
75 | |||||||||||
76 | EXPENSE REPORT TOTAL | ||||||||||
77 | ADDITIONAL COMMENTS | TOTAL EXPENSES | $1,081.20 | ||||||||
78 | LESS CASH ADVANCE | ||||||||||
79 | LESS COMPANY CARD CHARGES | ||||||||||
80 | TOTAL AMOUNT DUE EMPLOYEE | $1,081.20 | |||||||||
81 | |||||||||||
82 | APPROVAL & PAYMENT | ||||||||||
83 | APPROVED BY | REPORT NUMBER | ISSUED BY | METHOD OF PAYMENT | DATE OF PAYMENT | ||||||
84 | |||||||||||
85 | |||||||||||
86 | CLICK HERE TO CREATE EXPENSE REPORT TEMPLATES IN SMARTSHEET | ||||||||||
87 | |||||||||||
88 | |||||||||||
89 | |||||||||||
90 | |||||||||||
91 | |||||||||||
92 | |||||||||||
93 | |||||||||||
94 | |||||||||||
95 | |||||||||||
96 | |||||||||||
97 | |||||||||||
98 | |||||||||||
99 | |||||||||||
100 | |||||||||||