Expense Report Template, Expense Report Form, and a Filled-In Example
A copy-ready expense report template you can rebuild in Excel, Google Sheets or Word in about five minutes, the fields an accountable plan actually requires, a worked example, and the approval and receipt rules that keep reimbursements clean at tax time.
In one answer
An expense report is the form an employee submits to be reimbursed for money they spent on the company's behalf. Every expense report needs the employee name, the reporting period, and one line per expense showing the date, vendor, business purpose, category, amount and payment method, plus a receipt for anything over $75. Totals, the employee signature and an approver signature close it out. Copy the template below and adapt the categories to your chart of accounts.
Human approval on every send · 14-day money-back guarantee
Try it on a real task
Routing slip · Officeagent
Status: Ready
Action requested
Pick a task above and press RUN IT. Officeagent handles it end to end; you approve the send.
Reading page /
☐ Approve · nothing sends without you
In the product you edit the draft right here; the agent learns your correction.
Officeagent drafted, you approved, it executed.
Sample data · Officeagent always waits for your approval before anything is sent
What an expense report is, and what it has to prove
An expense report is the document an employee uses to claim back money they spent on company business: the client lunch, the flight, the mileage, the software they put on a personal card because procurement takes a week. That last category is worth noticing, because a steady stream of personal-card purchases is usually a symptom of slow vendor onboarding rather than undisciplined staff. On the other side of it, the report is what your bookkeeping uses to code the spend to the right account and what your accountant relies on if the deduction is ever questioned.
That second job is the one most templates get wrong. A reimbursement is only tax-free to the employee if it runs under what the IRS calls an accountable plan, and an accountable plan has three tests: the expense has a business connection, the employee substantiates it within a reasonable period, and any excess advance comes back. If a reimbursement fails those tests, it stops being a reimbursement and becomes taxable wages, which means payroll tax on both sides and a correction nobody wants to make in February.
What that means in practice is simple: every line on the report needs a business purpose in words, not just a category, and it needs a receipt behind it. "Client dinner, $180" is a category. "Dinner with M. Ortiz and two colleagues from Redline, discussing the Q3 renewal, $180" is a business purpose. The second one survives a question three years later; the first one does not. Once the report is complete, it and its receipts belong in the same place every month, which is the point at which most small offices switch from a shared drive full of screenshots to something that files each report where it belongs automatically.
The expense report template
Copy this into Excel, Google Sheets or Word. The header block identifies the claim, the line table carries the detail, and the footer block handles totals and sign-off. Nothing here is optional if you want the report to hold up.
EXPENSE REPORT
Employee: [name] · Employee ID / dept: [id]
Reporting period: [start date] to [end date]
Report number: [id] · Date submitted: [date]
Manager / approver: [name]
EXPENSE LINES
Date · Vendor · Business purpose · Category · Amount · Paid by (personal / company card) · Receipt attached (Y/N)
[one row per expense, in date order]
MILEAGE (if claimed)
Date · From · To · Business purpose · Miles · Rate · Amount
TOTALS
Subtotal, personal funds (reimbursable): $[ ]
Subtotal, company card (not reimbursable, coding only): $[ ]
Less cash advance received: $[ ]
Total due to employee: $[ ]
SIGN-OFF
Employee: "I certify these expenses were incurred for business purposes and are supported by the attached receipts." [signature] [date]
Approved by: [signature] [title] [date]
Coded and posted by: [initials] [date]
Two design notes that save real arguments later. Keep company-card spend on the same report but in a separate subtotal, because it still needs coding and a business purpose even though nobody is being paid back for it; mixing it into the reimbursable total is the single most common cause of an employee being overpaid. And keep mileage in its own block with the rate stated, because mileage is calculated, not receipted, and it changes every January when the IRS publishes the new standard rate.
A filled-in expense report example
Here is the template completed for a typical two-day client trip, so the level of detail is concrete rather than theoretical.
Employee: J. Marsh, Sales · Period: Jun 3 to Jun 4, 2026 · Report #: 2026-0117
Jun 3 · Delta · Round trip DFW to ORD for Redline renewal meeting · Airfare · $412.30 · Personal · Y
Jun 3 · Hyatt Place · One night, Redline renewal trip · Lodging · $189.00 · Personal · Y
Jun 3 · Gibsons · Dinner with M. Ortiz and two Redline colleagues, Q3 renewal discussion · Meals · $184.62 · Personal · Y
Jun 4 · Uber · Hotel to Redline office and return · Ground transport · $41.15 · Personal · Y
Jun 4 · Starbucks · Coffee for client meeting, 4 people · Meals · $23.80 · Company card · Y
Mileage: Jun 3 · Office to DFW and return · Redline trip · 48 miles · [current IRS rate] · $[calculated]
Subtotal personal funds: $827.07 · Company card: $23.80 · Advance: $0.00
Total due to employee: $827.07 plus mileage
Notice that every business purpose names something specific: the client, the meeting, the reason for the trip. Notice too that the coffee on the company card sits on the report but outside the reimbursable subtotal. That is the discipline the template enforces. Building the lines is the tedious part, and it is exactly the sort of transcription from receipts into rows that an assistant can handle as routine data entry with a person approving the finished report.
Receipts, the $75 rule, and how long to keep them
The rule most people half-remember is real but narrower than they think. IRS Publication 463 allows a written record instead of a receipt for expenses under $75, and for transportation expenses where a receipt is not readily available. It does not apply to lodging: hotel bills need a receipt at any amount. And the exception is a floor, not a policy. Plenty of companies require receipts on everything anyway, because a single consistent rule is easier to enforce than a threshold people have to remember.
The written record, when you use it, still has to carry the same four elements a receipt would: the amount, the date, the place, and the business purpose. A calendar entry with those details is a written record. A line on a credit card statement is not, because it proves you paid someone but says nothing about why.
On retention, keep expense documentation for at least three years from the date the return was filed, which is the general period during which the IRS can assess additional tax. Many accountants tell small businesses to keep seven years and stop thinking about it, because the exceptions that extend the window are exactly the situations where you would most want the paperwork. Digital copies are acceptable, which is why scanning receipts on the day beats a shoebox in every respect except nostalgia.
The approval workflow that stops disputes
Most expense friction is not fraud, it is ambiguity: the employee did not know a $300 dinner needed pre-approval, and the manager did not know it happened until the report landed. Writing three rules down removes almost all of it.
First, set a pre-approval threshold and say it out loud: anything over $X, or any travel at all, gets approved before it is booked, not after it is spent. Second, set a submission deadline. Monthly is standard, and it keeps you inside the accountable plan's reasonable-period test. Third, name the approver and a backup, so a report does not sit for two weeks because one person is on vacation.
Then close the loop on the back end. An approved report should be paid on a known schedule (with the next payroll run is the simplest answer for most small businesses), coded to the right accounts, and filed with its receipts. When the same person is chasing late submissions, checking every line against a receipt, and re-keying the approved totals into accounting, you have a recurring monthly grind that never gets better on its own. That is the case for turning the whole cycle into tracked tasks with owners and due dates rather than a reminder somebody sets themselves.
- Set a pre-approval threshold and say the number out loud
- One submission deadline for everyone, monthly is standard
- Name an approver and a named backup
- Pay approved reports on a fixed schedule, not when someone gets to it
- File the report and its receipts together, the same way every month
Excel, Google Sheets, or something that runs itself
A spreadsheet is genuinely fine at low volume. If you process a handful of reports a month, an Excel or Google Sheets version of the template above, with the subtotals as formulas and receipts dropped into a dated folder, will serve you for years. Do not buy software to solve a problem you do not have yet.
The point where a spreadsheet stops working is volume and chasing. Somewhere around a dozen reports a month, or the first time you have people submitting in three different formats, the cost stops being the form and starts being the follow-up: who has not submitted, which line is missing a receipt, which report is waiting on which approver, and what got coded where. That is administrative work, and it repeats forever.
Officeagent takes that layer. It reads the submitted reports and receipts, builds the lines, chases the people who are late, routes each report to its approver, and files everything where your bookkeeper expects it. Nothing is paid, sent or filed until a human clicks approve, which is the right control on anything touching money. If you want to see the mechanics, look at how it handles routine data entry and document filing, or read the breakdown of what belongs on an expense report. Prefer to stay manual? The template on this page is yours to copy.
Expense report fields and why each one is there
| Field | Why it is required | Common mistake |
|---|---|---|
| Date of expense | Ties the expense to the period and the trip | Using the submission date instead of the spend date |
| Vendor / merchant | Matches the line to the receipt and the card statement | Writing the category ("meals") instead of the vendor |
| Business purpose | The accountable plan test the IRS actually applies | Restating the category rather than naming the client or reason |
| Category / GL account | Codes the spend to your chart of accounts | Free-text categories that differ on every report |
| Amount and currency | The reimbursable figure | Including tips or tax inconsistently across lines |
| Paid by (personal / company card) | Separates reimbursable from coding-only spend | Mixing both into one total and overpaying the employee |
| Receipt attached | Substantiation, required over $75 and for all lodging | A card statement line treated as a receipt |
| Employee and approver signature | Certification and authorization | Approving in email with no record on the report itself |
Pricing
Assistant $149/mo · Office $399/mo · Enterprise from $1,500/mo
Office covers the whole team, up to 10 people, with the follow-up engine and CRM sync. Full limits on the AI assistant pricing page.
Questions on this
What is an expense report?
An expense report is a form an employee submits to be reimbursed for money they spent on the company's behalf, and to document that spending for the books. It lists each expense with its date, vendor, business purpose, category and amount, with receipts attached, then totals what the company owes the employee and carries an approval signature.
What should be included in an expense report?
Include the employee name and reporting period, then one line per expense showing the date, vendor, business purpose, category, amount and whether it was paid personally or on a company card, with a receipt attached. Add a separate mileage block if mileage is claimed, then subtotals, any advance deducted, the total due, and both the employee and approver signatures.
How do I create an expense report in Excel?
Put the employee name, period and approver in the top rows, then build a table with one column each for date, vendor, business purpose, category, amount, payment method and receipt. Add a SUM formula for the reimbursable column, a second subtotal for company card spend, and a row that subtracts any advance. Save it as a template file so every report comes back in the same shape.
Do you need receipts for every expense?
Not strictly. IRS Publication 463 allows a written record instead of a receipt for expenses under $75 and for transportation where a receipt is not readily available, but lodging always needs a receipt regardless of amount. The written record still has to show the amount, date, place and business purpose. Many companies require receipts on everything anyway because one rule is easier to enforce than a threshold.
How long should you keep expense reports?
Keep expense reports and their receipts for at least three years from the date you filed the return that used them, which covers the normal IRS assessment period. Many accountants advise seven years for small businesses because the situations that extend the window are the ones where you would most want the documentation. Digital scans are acceptable, so scanning on the day is the practical approach.
What is an accountable plan?
An accountable plan is an IRS-recognized reimbursement arrangement with three tests: the expense has a business connection, the employee substantiates it within a reasonable period, and any excess advance is returned. Meet all three and the reimbursement is not taxable income to the employee and not subject to payroll tax. Fail them and the payment is treated as wages, with tax owed on both sides.
How often should employees submit expense reports?
Monthly is the common standard, and it fits comfortably inside the accountable plan's reasonable-period safe harbor of substantiating within 60 days of the expense. Weekly works for high-travel roles. Whatever you pick, publish one deadline for everyone and pay approved reports on a fixed schedule, because unpredictable reimbursement timing is the single biggest driver of complaints.
Also on the routing slip
Your office admin, off your plate by Monday
Connect your calendar, inbox and drive. Officeagent drafts the work, you hit approve, and the busywork leaves your desk for good.
14-day money-back guarantee · Cancel anytime