Most people track travel expenses in one of two ways: a folder of crumpled receipts, or a credit card statement they sort through three weeks later.
This free travel expense log template for Google Sheets gives you a cleaner option. One row per expense. Auto-calculated USD totals. A summary tab that breaks everything down by category and payment method.
Copy it to your Google Drive, fill in your trip details, and you have a reimbursement-ready report in minutes.
Click here to copy the template to your Google Drive.
What’s Included in the Template
The template has three tabs: Expense Log, Summary, and Instructions.
Expense Log
This is where you do the actual work. Fill in one row for each expense. The columns cover everything you need for reimbursement submissions and tax documentation:
- Date
- Trip / Destination
- Category (dropdown: Flight, Hotel/Lodging, Meals, Ground Transport, Car Rental, Fuel, Parking, Conference/Event, Visa/Entry Fee, Baggage, Tips, Other)
- Vendor / Description
- Amount Paid and Currency (dropdown with 13 common currencies)
- Exchange Rate and Amount (USD) (auto-calculated)
- Payment Method (dropdown: Credit Card, Debit Card, Cash, Company Card, and more)
- Receipt Number
- Reimbursable? (Yes / No / Partial)
- Reimbursable Amount (USD) (auto-fills based on the column above)
- Status (Pending, Submitted, Approved, Reimbursed, Personal)
- Notes
The totals row at the bottom calculates your full trip spend and total reimbursable amount automatically.
Summary Tab
The Summary tab pulls directly from your Expense Log. No copy-pasting required.
It shows total expenses, total reimbursable amount, total personal spend, and number of entries. Below that, it breaks down spending by category and by payment method, each with a count and a percentage of total.
Print it or screenshot it when you submit your expenses.
Instructions Tab
Eight short steps covering how to fill in the template, how the currency conversion works, and what to log for tax purposes. Worth a read on your first use.
How to Use It for Reimbursement
Fill in the trip info bar at the top of the Expense Log before you start logging. Traveler name, department, date range, purpose. That information typically goes on a formal expense report, so having it at the top saves a step later.
Log each expense as close to real time as you can. The temptation is to batch everything at the end of a trip. The problem is that “airport coffee, $6, Tuesday” is hard to reconstruct from memory four days later.
For each row, mark whether the expense is reimbursable. Select Yes and the reimbursable amount fills in automatically. Select Partial and you can overwrite the cell with the correct figure. Select No and it zeros out.
When you’re ready to submit, check the Summary tab. It gives your approver a clear breakdown without scrolling through 40 rows of data.
Use the Status column to track where each expense is in the approval process. Over a long trip or multiple submissions, this prevents confusion about what’s already been paid out.
How to Use It for Tax Purposes
Business travel expenses can be deductible, but the IRS expects documentation. Date, amount, business purpose, and who was involved for meals.
The Notes column is where that information goes. For a client dinner, log who attended and what was discussed. For a conference registration, note the event name and its connection to your work. The Fuel and Car Rental categories keep rental car costs separate from other spending, which makes reporting cleaner.
If you drove your personal vehicle, that’s tracked separately. Our mileage log template for Google Sheets handles that calculation and keeps it out of this log.
The Receipt Number column ties each row to a physical or digital receipt. A consistent naming system, like a trip code plus a sequential number, makes retrieval straightforward if you’re ever audited.
For freelancers and self-employed travelers, this log pairs well with our Google Sheets accounting template, which handles income and expenses across the full year.
Tips for Multi-Currency Trips
The Exchange Rate column uses a live GOOGLEFINANCE formula that pulls the current rate to USD based on whatever currency you select in column F. Set the dropdown to EUR, JPY, GBP, or any of the 13 options, and the rate updates automatically.
The formula pulls the current rate, not the rate at the time of your transaction. To lock in the exact rate you were charged, replace the formula in that cell with the actual figure from your credit card statement or bank app. That gives you the most accurate USD total for reimbursement and tax purposes.
The Category breakdown on the Summary tab makes it easy to see total hotel spend or total meal spend across a full trip, regardless of which currency each charge was billed in.
Planning the Trip Before Expenses Start
Our Google Sheets itinerary template maps out your day-by-day schedule alongside estimated costs for each activity. Build a budget before you leave and compare it against actual spend in this log when you return.
The Google Docs itinerary template covers the same ground in a document format, which some people find easier to share with travel companions.
Frequently Asked Questions
Can I use this template in Microsoft Excel?
Partially. You can open the .xlsx file in Excel and most of the template works as expected. The Exchange Rate column uses a GOOGLEFINANCE formula that only functions in Google Sheets, so you would need to enter exchange rates manually in Excel. Everything else, including formulas, dropdowns, and the Summary tab, is Excel-compatible.
How do I add more rows to the Expense Log?
The template includes 50 rows by default. To add more, select the last data row, right-click, and insert rows below it. Copy the row above it, then right-click the new row and choose Paste Special and then Paste format only. Enter the H and L column formulas manually for each new row.
What should I put in the Notes column for meals?
For IRS documentation, include who was present and the business purpose. For example: “Lunch with [Client Name], discussed Q2 contract renewal.” That level of detail is what you need if the deduction is ever questioned.
Can I track multiple trips in one file?
The cleanest approach is one file per trip. The Summary tab is designed to reflect a single trip’s totals. For multiple trips, duplicate the file for each one and keep them organized in a shared folder.
Where does the reimbursable amount come from if I select Partial?
When you select Partial, the Reimbursable Amount cell displays “Enter Amount” as a prompt. Click into that cell and type the dollar figure your company will reimburse. The Summary tab picks it up automatically.
Does this template work for personal travel or just business travel?
It works for both. For personal trips, ignore the Reimbursable and Status columns and use it as a straight expense tracker. The Summary tab still gives you a useful breakdown of where your money went.
How do I handle a per diem instead of logging individual meals?
Log per diem as a single row per day. Set the Category to Meals, the Vendor/Description to “Per diem,” and enter the daily rate in the Amount Paid column. Note the applicable rate in the Notes column. Federal per diem rates by city are available on the GSA website.