SpreadsheetReceipts and Expense ClaimsFree
Travel Expense Report with Per Diem
A business trip claim with per diem meals by city, 75% first and last days, lodging capped at the local rate, mileage and the amount due back to you.
Shown with sample data
Travel Expense Report with Per Diem
A business trip claim with per diem meals by city, 75% first and last days, lodging capped at the local rate, mileage and the amount due back to you.
- M&IE allowance
- $462
- Lodging claimable
- $1,100
- Lodging over policy
- $39
- Not reimbursed unless pre-approved
- Travel days
- 6
- Other expenses
- $1,420
- Paid by company card
- $1,181
- Missing receipts
- 1
- Amount due to employee
- $1,500
- Feb 8, 2027$69
- Feb 9, 2027$73
- Feb 10, 2027$92
- Feb 11, 2027$92
- Feb 12, 2027$67
- Feb 13, 2027$69
- Conference fees$695
- Airfare$486.40
- Parking and tolls$108
- Taxi or rideshare$87.40
- Mileage$32.20
- Rail$10.50
How to use it
- 1Fill in Trip details and check the mileage rate, partial-day percentage and any advance on Policy.
- 2Check the Per diem rates for each city you visit (update them from your policy or the official rate tables for your travel dates).
- 3On Per diem days, add one row per day with the city, whether it is a first or last travel day, the value of any meals provided and the lodging you paid.
- 4Add airfare, taxis, car hire, mileage, parking and conference fees on Other expenses and mark who paid.
- 5Read the Summary for the amount due to you, attach receipts and send for approval.
In this workbook
About this template
Per diem claims go wrong on the details: partial days, provided meals and lodging over the local limit. Enter each travel day with its city; the report looks up the meals and incidentals (M&IE) and lodging rates for that city, pays 75% on the first and last travel days, deducts meals that were provided, caps lodging at the policy rate, adds transport, mileage and other costs, and works out the amount due to the traveller after any advance.
Who it’s for
- Employees claiming per diem under a company or GSA-style policy
- Multi-city trips with different rates
- Approvers checking claims against policy
What’s included
- Per diem days sheet: One row per travel day with the meals allowance and lodging against the local rate.
- Other expenses sheet: Transport, mileage, fees and other costs.
- Summary sheet: The claim total and what is due back to the traveller.
- Per diem rates sheet: Maximum lodging and daily M&IE for each city.
- Policy sheet: Mileage rate, partial-day rule and any advance.
- Trip sheet: Who travelled, why and who approves.
How to use it
- 1Fill in Trip details and check the mileage rate, partial-day percentage and any advance on Policy.
- 2Check the Per diem rates for each city you visit (update them from your policy or the official rate tables for your travel dates).
- 3On Per diem days, add one row per day with the city, whether it is a first or last travel day, the value of any meals provided and the lodging you paid.
- 4Add airfare, taxis, car hire, mileage, parking and conference fees on Other expenses and mark who paid.
- 5Read the Summary for the amount due to you, attach receipts and send for approval.
Tips
- Per diem meals usually need no receipts, but lodging, airfare and most other costs do. Keep every hotel folio.
- Deduct meals provided at conferences or by clients from that day’s M&IE; most policies require it.
- Lodging over the local rate is usually not reimbursed unless pre-approved. Ask before booking.
Questions
What is per diem?
A fixed daily allowance for meals and incidental expenses (M&IE) and a maximum for lodging, set by location. Employees claim the allowance instead of itemising every meal.
Why is the first and last day 75%?
Under US federal travel rules (and many company policies), travellers receive 75% of the M&IE rate on the days they travel out and back, because they are away for only part of the day.
Where do I find per diem rates?
In the US, the General Services Administration (GSA) publishes rates for each city and month. Other countries and many companies publish their own. The rates included here are samples; replace them with the rates for your dates.
Is per diem taxable?
Under an accountable plan, per diem up to the official rate is generally not taxable to the employee. Amounts above it may be. This is not tax advice.
Details
- Format
- Spreadsheet
- Category
- Receipts and Expense Claims
- Sheets
- 6
- Setup
- 10 min
- Level
- Intermediate
- Price
- Free
Download a copy
Downloads need a free account.