Travel receipts to an expense report

Do it the day you get back

Expense reports drag on because the receipts are spread across cities, days and jacket pockets. Add all of the trip's photos here the day you get back, while you still remember what each one was for, and you'll have a dated list in a few minutes.

Files download as travel-expenses_date_time.xlsx with a sheet called Travel. If you travel often, add the destination to the file name when you save it.

Match your company's categories

Expense report forms differ, but most ask for the same things. Add these columns next to the downloaded table, fill them in, then copy the lines into your company's form or attach the file.

Use SUMIF for totals per category. To see what you're owed, filter Paid with for personal card and cash and add up those rows. If you're building a report layout from scratch, see How to make an expense report template in Excel.

Expenses without a paper receipt

Rideshares, e-tickets and parking apps usually send receipts by email or keep them in the app. For these, use "Add row" and type the date, merchant and amount. You can add a screenshot of an app receipt as an image, but its layout differs from a printed receipt, so check the values carefully.

Receipts in several currencies

The table keeps two decimal places and no currency symbol, so add a Currency column next to Total for trips abroad. Companies usually reimburse based on the amount charged to your card or a set exchange rate, so follow your expense policy for the conversion.

Frequently asked questions

Can it read hotel folios?

A folio is longer than a typical receipt and lists nightly charges, taxes and payments. The reader looks for lines such as Balance Due or Total, but folios often need a check, so photograph the part of the page with the final amount and compare it with the photo.

What if a receipt date falls outside my trip?

Faded receipts or receipts with more than one date printed can be misread. If a date doesn't match your trip, click the thumbnail to see the photo larger and fix it.

Will it fill in my company's expense report form?

No. ReceiptMoa produces a table with No., Date, Store and Total. Copy the columns you need into your company's form or expense system.