THE BRIEF
Our sales rep sent in three months of expenses at once: a shoebox of receipts photographed on his phone and a messy spreadsheet. Clean it up so I can reimburse him.
Scenario: Office manager at an industrial equipment supplier
Package: Expense report cleanup · $25 · 2 hrs
All matched except 4. One of them is a $300 lunch, dear.
THE TOTALS
| Amount | |
|---|---|
| Submitted | $4,862.17 |
| Matched to a receipt | $4,191.40 |
| Not reimbursable (personal) | $96.15 |
| Still needs a receipt | $574.62 |
- Submitted
- Amount
- $4,862.17
- Matched to a receipt
- Amount
- $4,191.40
- Not reimbursable (personal)
- Amount
- $96.15
- Still needs a receipt
- Amount
- $574.62
BY CATEGORY
| Category | Amount |
|---|---|
| Mileage (2,140 miles at your $0.67 rate) | $1,433.80 |
| Hotels | $1,284.00 |
| Meals with clients | $812.40 |
| Meals while traveling alone | $331.20 |
| Parking and tolls | $188.00 |
| Trade show booth supplies | $142.00 |
- Category
- Mileage (2,140 miles at your $0.67 rate)
- Amount
- $1,433.80
- Category
- Hotels
- Amount
- $1,284.00
- Category
- Meals with clients
- Amount
- $812.40
- Category
- Meals while traveling alone
- Amount
- $331.20
- Category
- Parking and tolls
- Amount
- $188.00
- Category
- Trade show booth supplies
- Amount
- $142.00
No "miscellaneous." Everything has a home.
THE 4 I COULDN'T EXPLAIN
- $300.00 lunch, Bellamy's Steakhouse, Feb 12. No receipt, no client name. Round number. Ask him.
- $184.62 hotel, Feb 28. Card charge shows, but there's no folio. Ask for the hotel's emailed receipt.
- $60.00 "parking," Mar 4. Round number again. Parking is never exactly $60.
- $30.00 cash, Mar 19. No note at all.
NOT REIMBURSABLE
- $58.40 at a pharmacy. Shampoo and allergy pills. Personal.
- $37.75 in-room movie and minibar. Your policy says no.
I took those out of the total. You can tell him, or I can write the note.
OTHER THINGS
- 3 receipts were in the pile twice. Counted once.
- His mileage log had two trips on the same day to the same customer, going different distances. I used the shorter one. He may want to check.
Reimburse $4,191.40 now. The other $574.62 once he sends what's missing.
Books are tidy. — Dolores
