Apollo's Templates
HomeBusinessExpense Report TemplatesTravel
One trip, one page

Travel Expense Report Template

The classic trip grid: one row per travel day, one column per expense type — airfare and transit, lodging, meals and tips, fuel or mileage, parking and tolls, other. In the Excel version the day rows date themselves from your trip dates, every day totals across, every category totals down, and the total reimbursement subtracts whatever was advanced before you left. The PDF prints clean for the folks who do trips on paper.

Three formats

The travel sheet, however you work.

Worth knowing

Do the report during the trip, not after it.

The five minutes at the hotel each evening — filling in today’s row while the receipts are still in your jacket pocket — beats an hour of archaeology the week after. It’s also what the IRS means by a “timely-kept record”: notes made at or near the time of the expense carry more weight than reconstructions, because memory of the business purpose fades faster than the receipt does.

Two receipts people lose on every trip: the hotel folio (ask at checkout — the emailed version routinely lands in spam) and airport parking. Lodging receipts are the one category the IRS requires at any amount, so the folio is the single most important piece of paper the trip produces.

Driving your own car
Mileage Log
Track the trip's miles at the IRS standard rate, then claim the total under Fuel / mileage here.
Open
Not trip-shaped
Expense Report
The standard one-row-per-expense sheet for reimbursements that aren't tied to a single trip.
Open
All formats
Excel Expense Templates
Every sheet in the library as an .xlsx with working totals.
Browse

Frequently asked questions

How do the self-dating day rows work?
Enter the trip's start and end dates in the header of the Excel or Google Sheets version and the Date column fills itself — one row per day, stopping at the trip end so a three-day trip shows exactly three dated rows. The sheet holds ten day rows, which covers most business trips; for anything longer, either use two sheets (one per week, which many approvers prefer anyway) or switch to the monthly report and tag the trip in the description column.
Should I report actual expenses or per diem?
That's your employer's call, not the template's. Per diem substitutes a flat daily allowance — the federal GSA rate or a company rate — for actual lodging and meal receipts. If your company runs on per diem, you generally only itemize the categories per diem doesn't cover: airfare, ground transport, parking. If it reimburses actual expenses, every category on this sheet applies and the receipts back it up. When in doubt, ask before the trip; the answer changes what you need to save.
Where do miles in my own car go on this report?
Under Fuel / mileage — as a dollar amount, not a mile count. Track the trip's miles on the mileage log (linked below), multiply by the IRS standard rate — 76¢ per mile for miles driven in the second half of 2026 — and enter the product here. Don't claim both mileage and gas receipts for the same drive: the standard rate already includes fuel, so doubling up is the classic expense-report mistake.
What travel expenses can a business actually deduct?
For travel away from home overnight on business, the IRS list is broad: transportation (flights, trains, car rental, your own car at the standard rate), lodging, 50% of meal costs, taxis and rideshares, parking and tolls, baggage fees, tips on any of the above, even laundry on longer trips. What never qualifies: the personal side of a mixed trip, your family's costs, and commuting to your regular workplace. The authority is IRS Publication 463 — worth a skim before a big trip.
Updated through August 2026