Excel Travel Expense Tracking Template: How to Build One

How-to basics · Updated November 22, 2026

The fastest way to track travel expenses in Excel is to build a simple table with columns for Date, Category, Description, Payment Method, and Amount, then add a SUM formula at the bottom. For a ready-made solution, Microsoft offers a free “Travel expense report” template inside Excel (File > New, search “travel expense”), which you can customize with your own categories and currency. Below, I explain how these templates work, how to tailor them to your trip, and common pitfalls to avoid.

What a Travel Expense Template Actually Does

A travel expense template is a pre-structured spreadsheet that replaces a paper log or a notes app. Its core job is to record every cost related to a trip—flights, hotels, meals, taxis, conference fees—and then total them automatically. Most templates include:

  • Date – when the expense occurred.
  • Category – a dropdown list (e.g., Airfare, Lodging, Meals, Ground Transport).
  • Description – what the expense was for (e.g., “Delta flight JFK–LAX”).
  • Payment method – cash, credit card, corporate card.
  • Amount – the cost in your chosen currency.
  • Reimbursable? – a yes/no column if you’re filing an expense report later.

Many templates also include a summary section that breaks down totals by category, which is exactly what an employer or accountant wants to see. Some even have a separate sheet for mileage if you’re driving.

How to Use a Built-In Excel Template

If you want the fastest start, use Microsoft’s own template. In Excel for Microsoft 365 on Windows, go to File > New, type “travel expense” in the search box, and choose the “Travel expense report” template. It opens with sample data you can overwrite. On a Mac, the path is the same: File > New from Template… and search there. Excel for the web also has templates under File > New.

The built-in template typically has columns for Date, Category, Description, and Amount, plus a subtotal row. It uses a simple =SUM() formula. For example, if amounts are in D5:D20, the total cell would be =SUM(D5:D20). You can add more rows by copying the formatting down, and the SUM range will expand automatically if you insert rows inside the range.

Building Your Own Template from Scratch

If you prefer full control, create a blank workbook and set up your own columns. Here’s a minimal but effective layout:

  1. In row 1, put headers: Date, Category, Description, Payment, Amount, Reimbursable.
  2. In row 2, start entering your expenses.
  3. At the bottom, use =SUM(E2:E100) to total the Amount column (adjust range to your data).
  4. Add a dropdown for Category using Data > Data Validation (on Mac: Data > Data Validation). List items like Airfare, Hotel, Meals, Taxi, Parking, Entertainment.
  5. For the Reimbursable column, use a dropdown with Yes/No, or a checkbox via Insert > Checkbox (Excel 365 only).

To make the summary automatic, use =SUMIF(). For instance, with categories in B2:B100 and amounts in E2:E100, a cell for “Meals” total would be =SUMIF(B2:B100,"Meals",E2:E100). This returns the sum of all amounts where the category equals “Meals”.

Key Features That Make a Template Useful

A good travel expense template is more than a list. These features matter most:

  • Currency conversion – if you travel abroad, add a column for the original currency and a second for your home currency using the exchange rate. You can hardcode the rate or link to a cell.
  • Per-diem tracking – if your company gives a daily meal allowance, add a column for “Per-diem rate” and a formula to calculate the allowance vs. actual spending.
  • Receipt numbers – a column to note whether you have the physical receipt (useful for audits).
  • Notes – for context like “client dinner” or “toll road”.
  • Conditional formatting – highlight amounts over a certain threshold (e.g., > $100) using Home > Conditional Formatting > Highlight Cells Rules > Greater Than. This helps spot unusual costs.

For a trip with multiple people, add a “Name” column so you can filter by person later.

Common Mistakes and How to Avoid Them

The biggest mistake people make is not separating business and personal expenses. If you’re on a business trip, keep a column for “Business/Personal” and filter it out before submitting. Another common error is forgetting to update the SUM range when you add rows below the data. To avoid that, use an Excel Table (select your data, press Ctrl+T on Windows or Cmd+T on Mac). Tables auto-expand formulas as you add rows, and the total row can be toggled from Table Design > Total Row.

A third mistake is mixing currencies without a conversion. If you enter euros and dollars in the same column, your total will be wrong. Always keep a separate column for the original amount and a formula to convert. For example, if original amount is in F2 and exchange rate is in G2, the converted amount is =F2*G2.

Finally, don’t rely on memory—enter expenses daily. A template only works if you feed it data consistently.

Comparing Excel Templates to Dedicated Apps

Excel is flexible and free (if you already have Office), but it has limits. Dedicated expense apps like Expensify or Concur automate receipt scanning and integrate with accounting software. However, they often require a subscription. Excel gives you complete control over categories and formatting, and you can share it via OneDrive or email. For a simple personal trip, a spreadsheet is often enough. For a frequent traveler who needs to submit reports, a dedicated app might save time.

If you use Excel for the web, you can collaborate in real time with others, but some features like data validation dropdowns work slightly differently. On the web, data validation is available under Data > Data validation, but you may need to type the list manually rather than selecting a range.

Cost and Safety Considerations

The built-in Excel template is free with your Office subscription. If you don’t have Excel, you can use Google Sheets, which has a similar template (search “travel expense” in the template gallery). There is no financial risk in using a spreadsheet, but be careful with sensitive data like credit card numbers—don’t store full card details in a shared file. Use password protection on the workbook if it contains personal information: File > Info > Protect Workbook > Encrypt with Password (on Mac: File > Passwords).

For tax or reimbursement purposes, keep digital copies of receipts and link them in the Notes column or a separate folder. The spreadsheet itself is just a record; the receipts are the proof.

Frequently Asked Questions

Can I use a travel expense template for a personal trip? Yes, just ignore the “Reimbursable” column or change it to “Budget” if you’re tracking against a planned spending limit.

How do I add a new expense category? If you used a dropdown, go to the cell with the dropdown, select Data > Data Validation, and edit the Source list to include the new category. If you didn’t use a dropdown, just type the new category in the cell.

What if I travel in multiple currencies? Add a column for the original currency and a column for the exchange rate. Then use a formula like =F2*G2 to get the home currency amount. Keep the exchange rate in a separate cell so you can update it daily.

Can I make the template automatically calculate per-diem? Yes. Add a column for “Per-diem days” and a cell with the daily rate. Then use =days*rate to calculate the allowance, and compare it to actual meal expenses with a simple subtraction formula.

Is there a way to track mileage? Many templates have a separate sheet for mileage. Create columns for Date, Starting location, Ending location, Miles, and Rate. Then multiply miles by rate (e.g., =D2*E2) to get the amount.

Does the template work on my phone? Yes, if you use the Excel mobile app, you can edit the same file. However, some features like data validation are limited on mobile, so it’s best to set up the template on a computer first.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.