GSA Per Diem Expense Report Excel - Free Template

1. Open the Expense Report tab and enter the employee name, department, report period, and travel authorization number. Keep the information tied to one trip so the totals stay clean.
2. Fill in the travel dates and daily expense lines using the amounts from your receipts or approved per diem rate. If you have a 5-day trip at $74 per day for meals, the base allowance is $370 before other costs.
3. Review the Summary tab to confirm the subtotal, any deductions, and the final reimbursable amount. This is the quickest place to spot a missing day or a duplicated entry.
4. Use the Instructions tab if you need to confirm what belongs in each field before submitting the report. That saves you from rework after the supervisor review.
5. Check the numbers against your travel authorization and company policy before you submit. A $28 lodging overage or a missing receipt can change the approved total.
6. Print or save the workbook as your backup file after reimbursement is approved. That gives you one record for payroll, accounting, and year-end support.

This spreadsheet fits the person who has to turn a business trip into a clean reimbursement request: a sole proprietor on a federal contract, a bookkeeper at an LLC, a field supervisor at a construction company, or a nonprofit employee who travels to conferences. If you are tracking a 4-day trip with $74 meals, $189 lodging, and $32 in incidentals, you need the totals in one place before you submit the packet.

The most common use case is a month-end or trip-end close. A travel coordinator who processes 12 reports a week can see the difference immediately when each report has dates, purpose, and authorization number at the top instead of scattered across emails.

Travelers, Approvers, And Accounting

Employees use the form to request reimbursement. Approvers use it to compare the claim against the travel order and avoid paying a wrong day or duplicate hotel bill.

When The Report Usually Gets Filled Out

You usually finish it right after the trip, before the receipts get buried. If you wait until the next payroll run or the next monthly close, you lose time and the totals get harder to verify.

The IRS expects business travel records to support the deduction: date, place, business purpose, and amount. Keep the supporting records for at least 3 years after the return is filed, and longer when the file connects to asset records or a disputed item.

For federal travel, the per diem framework comes from the GSA. That matters because a per diem report should show the approved rate by day instead of relying on a vague estimate; if the trip covers 6 days at $68 per day for meals and incidentals, your base allowance is $408 before any lodging or reductions.

Per Diem Versus Actual Receipts

Per diem is cleaner when the company allows it because you can avoid stapling a pile of small meal receipts to the report. Actual-expense reporting works better when lodging or transportation runs outside the standard allowance and you need line-by-line backup.

Why The Paper Trail Matters

A report with dates, purpose, and amounts makes later review much easier for accounting, the supervisor, and the tax file. A missing business purpose on a $215 hotel stay can turn a valid expense into a cleanup job at year-end.

The biggest problem is not math; it is incomplete support. A traveler who skips one travel day, enters the wrong hotel amount, or forgets to mark a personal meal can force accounting to send the report back, which delays payment by days or even a full pay cycle.

Another common failure is mixing reimbursable travel costs with non-travel spending. If a 3-day report includes $96 of meals, $214 of lodging, and $58 of personal items, only the eligible portion should hit the reimbursement total; otherwise the approver has to split the claim by hand.

What The Mistakes Cost

A missing receipt for a $147 taxi ride is not just annoying. It can mean the expense is disallowed, the traveler absorbs the cost, or the bookkeeper spends 20 minutes chasing proof instead of closing the books.

Where The Spreadsheet Prevents Trouble

When the report keeps the trip dates, purpose, and total visible, you catch a mismatch before submission. That is faster than fixing a rejected claim after payroll has already posted reimbursements.

The best routine is simple: enter the trip on the same day you return, then review it with receipts before the next accounting cutoff. If you handle travel every week, a standing Friday check takes less time than rebuilding the report from memory two weeks later.

Make It Harder To Drift

• Use the same report period format every time, such as 06/01/2026–06/30/2026.
• Copy the prior month’s file and overwrite only the trip-specific fields.
• Keep the summary tab in view so you catch an overage before submission.

Know When To Move Beyond A Spreadsheet

If your team is processing dozens of trips, or if approvals, receipts, and reimbursements keep crossing in email, you have outgrown a file. At that point a travel management system or accounting platform such as QuickBooks is the cleaner move.