Free Expense Report Template (2026)
A clean expense report template with the exact columns to copy, plus guidance on filling it out for reimbursement or taxes. Copy it into a spreadsheet and start tracking in minutes.
Mylo Team • July 2, 2026 • 3 min readWhat an expense report is for
An expense report is a summary of business spending, submitted to get reimbursed or to support a tax deduction. It lists each expense on its own row with enough detail that a reviewer, or you at tax time, can see what was bought, when, why, and how much. Done well, it takes minutes to approve. Done badly, it bounces back for missing receipts or fuzzy categories.
The template below is intentionally simple. It has exactly the columns a reviewer needs and nothing that slows you down.
The free expense report template
Copy these column headers into row 1 of any spreadsheet, then add one row per expense.
| Date | Merchant | Category | Description | Payment method | Amount | Receipt |
|---|---|---|---|---|---|---|
| 2026-07-01 | Delta | Travel | Flight to client site | Amex | 312.40 | receipt-01.pdf |
| 2026-07-01 | Hilton | Lodging | 1 night, conference | Amex | 189.00 | receipt-02.pdf |
| 2026-07-02 | Starbucks | Meals | Client coffee | Visa | 11.75 | receipt-03.pdf |
| 2026-07-02 | Office Depot | Supplies | Printer paper | Visa | 24.99 | receipt-04.pdf |
| Total | 538.14 |
What each column does
- Date: when the expense occurred (use one consistent format).
- Merchant: who you paid.
- Category: the spending type, used to subtotal. Keep names consistent.
- Description: the business purpose, the detail the IRS and reviewers care about most.
- Payment method: which card or account, useful for matching to statements.
- Amount: the total for that line. Sum this column at the bottom.
- Receipt: the file name or link to the proof for that row.
How to fill it out
- Paste the headers into a blank sheet.
- Add a row per receipt, filling every column.
- Reference the receipt by file name or link in the last column.
- Total and subtotal: sum the Amount column, and subtotal by Category so spending groups cleanly.
- Review and submit: confirm every row has a receipt and the math checks out, then export to PDF.
Tip: Add a one-line business purpose in the Description column even when it seems obvious. "Client lunch, Acme deal" ages far better than "lunch" when someone reviews the report months later.
Getting the categories right
Consistent categories are what make an expense report useful. If you call it "Meals" once and "Food" the next time, your subtotals fragment. Pick a short, stable list, for example travel, lodging, meals, supplies, software, and mileage, and reuse it every time. For a deeper breakdown, see how to categorize business expenses. And keep a receipt for every line: see what counts as proof of purchase.
Report vs spreadsheet vs mileage log
This template is for a report: a bounded submission for a trip or a period. If you want an ongoing running log of all spending, use the business expense spreadsheet. If you drive for work, pair it with a mileage log template so your miles are documented separately, the way the IRS expects.
The faster way: let Mylo build the report for you
The honest truth about expense report templates is that filling them in by hand is the slow, error-prone part. Mylo removes it. It auto-captures your receipts from your Gmail, Outlook, and iCloud inboxes, from connected store, loyalty, and travel accounts, and from your camera roll, then reads the merchant, date, total, tax, and line items and categorizes each one for you. It matches every receipt to the card charge through Plaid (no new card, bank-grade security), so nothing is missed.
Instead of typing rows into a spreadsheet, you review a report that is already built, itemized, and receipt-backed, then sync the approved expenses straight to QuickBooks. It replaces the manual template entirely. Free for individuals on iOS, Android, and web; teams are $9/user/mo with a 30-day free trial.
Sources: standard expense report practices and IRS recordkeeping guidance. This is general information, not tax advice; check current IRS guidance.
Frequently asked questions
What columns should an expense report have?
At minimum: date, merchant, category, description, payment method, and amount, plus a receipt reference. Categories let you subtotal by type, and the receipt reference lets a reviewer verify each line. Add a mileage or notes column if your work needs it.
Do I need to attach receipts to an expense report?
Almost always, yes. Most employers and the IRS expect a receipt for each expense, especially anything over a small threshold. A report without receipts usually gets sent back. Keep an itemized receipt or a clear digital copy for every line.
How do I categorize expenses on the report?
Group them into consistent categories like travel, meals, supplies, and software so totals roll up cleanly. Use the same category names every time. For a full guide, see how to categorize business expenses. This is general information, not tax advice.
What is the difference between an expense report and an expense spreadsheet?
An expense report is usually a single submission for reimbursement or a period, with receipts attached. An expense spreadsheet is an ongoing running log of all spending. The report is often generated from the spreadsheet. See our free business expense spreadsheet.
Related guides
Mylo Team
The Mylo Team writes practical guides on receipts, expenses, write-offs and keeping your books clean, from the people building Mylo, the app that puts receipts and expenses on autopilot.
Put your receipts on autopilot
Mylo finds every receipt across your email inboxes and accounts, matches it to your card, and files clean expenses to QuickBooks. Free to start.
