Free Expense Report Template for Excel (2026)
A ready-to-use expense report with 13 pre-loaded categories, IRS mileage auto-calc, a 6-employee roster, and a reimbursement rollup that summarizes billable vs. non-billable spend across any date range. Built in Excel with 246 formulas across 6 sheets — accountable-plan ready, works offline, edit anything.
Download the Expense Report Template
Free .xlsx download — no email required. Opens in Microsoft Excel, Excel Online, Google Sheets, and LibreOffice Calc.
Download expense-report-2026.xlsxExcel 2007+ compatible · Also works in Google Sheets & LibreOffice
Expense Report — the showpiece
The Expense Report is a print-ready single-page form. Pick a Report ID and Employee from the dropdowns at the top; department, role, and manager auto-fill via VLOOKUP. Line items total automatically, and every category rolls up on the fly.
Expense Report
| Date | Category | Description | Merchant | Amount | Bill? |
|---|---|---|---|---|---|
| Jan 6 | Travel — Airfare | SFO ⇄ NYC round trip | United Airlines | $582.40 | Yes |
| Jan 6 | Travel — Lodging | Hotel, 2 nights, Manhattan | Hyatt Grand Central | $478.00 | Yes |
| Jan 6 | Travel — Ground | Uber SFO airport | Uber | $42.15 | Yes |
| Jan 7 | Meals | Team dinner with Acme execs | Balthazar | $248.90 | Yes |
| Jan 7 | Travel — Ground | Taxi Times Sq → hotel | NYC Taxi | $28.50 | Yes |
| Jan 8 | Meals | Client lunch, roadmap review | The Modern | $186.00 | Yes |
| Jan 8 | Travel — Ground | Uber JFK | Uber | $64.80 | Yes |
| Total | $1,630.75 | ||||
Category breakdown = =SUMIFS(Amount,Category,"Travel — Airfare")+SUMIFS(Amount,Category,"Travel — Lodging"). Billable-to-client filter = =SUMIFS(Amount,Billable,"Yes"). Change the Report ID at the top to view any other report; all line items and totals refresh instantly.
Reimbursement Summary — one row per person, any date range
Set a start and end date; the Reimbursement Summary uses SUMIFS + COUNTIFS to count entries and roll up Billable vs. Non-billable per person. Below is the full Jan 2026 view across all 6 sample employees.
| Employee | Department | Entries | Billable | Non-billable | Total Reimbursable |
|---|---|---|---|---|---|
| Emma Thompson | Operations | 9 | $1,630.75 | $359.30 | $1,990.05 |
| David Kim | Engineering | 8 | $0.00 | $2,423.05 | $2,423.05 |
| Sofia Rodriguez | Design | 6 | $320.00 | $440.69 | $760.69 |
| Michael Chen | Marketing | 6 | $1,295.00 | $2,173.90 | $3,468.90 |
| Aisha Patel | Support | 5 | $24.80 | $432.50 | $457.30 |
| James Wilson | Analytics | 6 | $101.65 | $884.80 | $986.45 |
| January Total | 40 | $3,372.20 | $6,714.24 | $10,086.44 | |
Expense Log — every entry, one row
The Expense Log is the raw feed — one row per expense with employee, date, category, merchant, amount, billable flag, project, and Report ID. Pre-filled with 40 sample entries across Jan 6–23, 2026. The Reimbursable column auto-flags via VLOOKUP against the Categories & Rates master.
| Date | Employee | Category | Merchant | Amount | Billable | Reimb. |
|---|---|---|---|---|---|---|
| Jan 12 | David Kim | Training & Conferences | AWS | $1,250.00 | No | Yes |
| Jan 13 | Michael Chen | Client Entertainment | Boulevard | $420.00 | Yes | Yes |
| Jan 13 | Michael Chen | Marketing & Ads | $875.00 | Yes | Yes | |
| Jan 8 | James Wilson | Mileage | Personal vehicle | $54.60 | Yes | Yes |
| Jan 21 | Michael Chen | Training & Conferences | SaaStr | $1,495.00 | No | Yes |
| Jan 9 | Sofia Rodriguez | Software & Subscriptions | Figma | $180.00 | No | Yes |
| … 34 more rows across Jan 6–23, 2026 | ||||||
Grab the free Expense Report — no strings.
Ready-to-use .xlsx · 6 sheets · 246 formulas · IRS-compliant categories · Reimbursement rollup built in.
What's inside — 6 sheets
Six sheets, one clean flow: log expenses, generate reports, roll up reimbursements.
01Setup Guide
Welcome sheet with quick-start steps, a legend of every colored cell, and a 60-second orientation to the workbook. Read this first.
02Expense Report
The showpiece. Pick a Report ID + Employee; department, role, and manager auto-fill via VLOOKUP. 20 line items with category breakdown and billable vs. non-billable totals.
03Expense Log
The raw feed — one row per business expense. 40 sample entries across Jan 6–23, 2026 with 3 dropdown validations (Employee, Category, Billable).
04Categories & Rates
13 pre-loaded expense categories + IRS mileage rate ($0.70/mi 2026 default), meal per diem ($75/day), and lodging per diem ($150/night).
05Employee Roster
Master employee list with name, department, role, manager, and ID. All other sheets read from here via VLOOKUP — add rows as your team grows.
06Reimbursement Summary
Set a start and end date, and SUMIFS + COUNTIFS pulls entries, Billable, Non-billable, and Total Reimbursable per person — with a green data bar for scale.
Features
Everything that separates this template from a blank spreadsheet.
IRS mileage auto-calc
Enter miles driven, the workbook multiplies by the IRS standard rate (2026 default $0.70). One cell on Categories & Rates updates every mileage row.
13 categories pre-loaded
Meals, Airfare, Lodging, Ground, Mileage, Entertainment, Supplies, SaaS, Training, Comms, Marketing, Other, Personal — with a Reimbursable flag on each.
Per-employee rollup
Six people pre-loaded across 6 departments. Add or edit rows in Employee Roster and every dropdown + rollup picks them up automatically.
Date-range summary
Set start/end dates on Reimbursement Summary — SUMIFS handles weekly, bi-weekly, semi-monthly, or monthly cycles equally well.
Billable vs. internal
Flag each expense as billable to a specific client. Filter or total by billable status to invoice back or absorb internally.
Works everywhere
Excel 365, 2021, 2019, 2016, 2013, 2010, 2007. Google Sheets. Excel Online. LibreOffice Calc. Zero add-ins required.
Who this is for
Built for teams too small to justify Expensify or Concur — but too structured to run on email chains and photos of receipts.
Small business owners
Your team of 3–20 submits expenses monthly and you don't want to pay $10/user/month for a SaaS. Log entries, generate reports, hand the rollup to your bookkeeper.
Accountants & bookkeepers
You need a clean audit trail — one row per expense, IRS category tagging, mileage documented at the standard rate. Import the Log into QuickBooks or Xero without cleanup.
Consultants & agencies
You bill clients for reimbursable expenses across multiple projects. Tag each expense as billable + client/project — filter and invoice cleanly at month end.
IRS standard mileage rate — how it works
The IRS updates the standard mileage rate every year around December. Using it correctly is the difference between a fully deductible business expense and a bookkeeping headache at tax time.
What the standard mileage rate covers
The IRS standard mileage rate is a per-mile figure that lets employees and self-employed workers deduct the cost of using a personal vehicle for business — without tracking gas, oil, maintenance, insurance, and depreciation separately. Multiply business miles by the rate and you're done.
Example (this template, 2026 default):
78 mi × $0.70 = $54.60
The rate is set annually by the IRS in Notice XX-XX (released each December for the following year). It applies to business use only — commuting from home to a regular workplace is not deductible business mileage.
- Business rate: Used in this template. For travel to clients, offsite meetings, temporary work locations, and errands during the workday.
- Medical & moving rate: Lower rate for qualifying medical travel and certain military moves.
- Charitable rate: Fixed by statute at $0.14/mile — has not changed in decades.
To update the rate: open Categories & Rates in the workbook, find the "IRS Standard Mileage" row, and edit the value. Every mileage entry that uses the named range MileageRate updates automatically. Check irs.gov for the current-year figure before submitting reports.
Standard mileage vs. actual-expense method
Employees and businesses can pick one of two methods to deduct vehicle use:
- Standard mileage method (this template): multiply miles × IRS rate. Simple, no receipts for gas or maintenance. Best for owner-employees, sales reps, and consultants driving less than ~15,000 business miles/year.
- Actual-expense method: track every gas receipt, oil change, insurance premium, depreciation, and repair. Multiply by the business-use percentage. More accurate for high-mileage or high-cost vehicles, but far more paperwork.
Once you pick a method for a vehicle in year one, you can generally only switch to standard in later years — not the other way around. Consult a CPA before switching methods.
Accountable vs. non-accountable reimbursement plans
This is the single most important compliance concept for small-business expense reimbursement. Get it right and reimbursements are tax-free; get it wrong and they become taxable wages.
What the IRS requires (Treas. Reg. §1.62-2)
Reimbursements to employees can be structured as an accountable plan (tax-free to the employee, deductible to the employer) or a non-accountable plan (taxable wages, subject to payroll taxes). To qualify as an accountable plan, three tests must all be met:
- Business connection: Every expense must have a clear business purpose — client meeting, business travel, work-related supplies, etc. Personal expenses fail this test.
- Substantiation: Employee must document each expense with amount, date, place, and business purpose — plus a receipt for anything $75 or more (and any lodging expense of any amount).
- Return of excess: If the employee received an advance, they must return any unspent amount within a reasonable period — typically 60 days after the expense was paid or incurred.
Fail any one of the three, and the entire reimbursement becomes a non-accountable plan payment — added to the employee's W-2 as taxable wages. Costly for both sides.
How this template supports accountable plan compliance
- Business connection: Every row on the Expense Log has a Description and Client/Project field. Fill them out; that's your business-purpose documentation.
- Substantiation: The Log captures date, amount, category, merchant, and purpose. Attach receipts to the printed report or store them in a shared folder named by Report ID (EXP-2026-001, etc.).
- Return of excess: Not needed if you reimburse against actual submitted expenses (as this template does). If you issue travel advances, subtract the advance from the report total and require return of any excess.
Print the Expense Report sheet, sign it, get the manager signature (auto-filled from Employee Roster), and file it with the receipts. That's a compliant accountable-plan record.
Per diem method vs. actual receipts
For travel meals, lodging, and incidentals, businesses can reimburse actual receipts or use flat per-diem rates published by the GSA. Both are IRS-compliant when done right.
The two options
Under an accountable plan, employers can either (a) require actual receipts for every expense, or (b) reimburse a flat daily amount using federal per-diem rates. The template supports both.
| Method | What employee submits | Best for |
|---|---|---|
| Actual receipts | Every receipt over $75, plus every lodging receipt regardless of amount | Executive travel, high-cost cities, when actual spend is above per diem |
| Federal per diem | Trip destination + dates only — no meal receipts required | Frequent low-cost domestic travel; simpler bookkeeping |
| Hybrid (this template) | Actuals for lodging + airfare; per diem for meals + incidentals | Most small businesses — receipts for big items, flat per diem for meals |
2026 federal per-diem defaults (GSA CONUS)
The General Services Administration publishes per-diem rates for every US city. The template ships with the standard CONUS (Continental US) averages you can override on the Categories & Rates sheet:
- Meals + incidentals: $75/day standard, up to $92/day in high-cost cities (NYC, SF, Boston, DC, LA, Seattle).
- Lodging: $150/night standard, up to $300+/night in top-tier cities and $500+/night in Manhattan / SF peak season.
- Incidentals only: $5/day (tips for hotel staff, personal phone calls, etc.).
Check gsa.gov/travel/plan-book/per-diem-rates for the specific city + fiscal year. Federal rates update every October 1st.
13 expense categories — deductibility at a glance
Every category shipped in the template with what the IRS typically allows. Consult your CPA on edge cases — this is a starting point, not tax advice.
Meals
50% deductible for business meals with clients or during travel (2026 default). Full receipts required if over $75.
50% DEDUCT.Travel — Airfare
100% deductible for business travel. Save boarding passes and itineraries.
100% DEDUCT.Travel — Lodging
100% deductible. Receipt required for any lodging expense, regardless of amount.
100% DEDUCT.Travel — Ground
Taxi, Uber, rental car, parking — 100% deductible for business trips.
100% DEDUCT.Mileage
Personal vehicle × IRS rate. Log dates, destinations, and business purpose per trip.
100% DEDUCT.Client Entertainment
Since 2018 tax reform, entertainment (concerts, sports tickets) is not deductible. Meals separately purchased at events remain 50% deductible.
NOT DEDUCT.Office Supplies
Small office equipment, stationery, printing — 100% deductible in year of purchase.
100% DEDUCT.Software & Subs
SaaS licenses, tools, monthly subscriptions — 100% deductible if business-purpose.
100% DEDUCT.Training & Conferences
Course fees, conference tickets, workshops — 100% deductible for maintaining or improving job skills.
100% DEDUCT.Communications
Business-use portion of phone/internet. Prorate personal vs. business use for documentation.
100% BUS.Marketing & Ads
Ad spend, sponsorships, promotional materials — 100% deductible ordinary business expense.
100% DEDUCT.Other
Miscellaneous business expenses. Add a clear description — auditors scrutinize catch-all rows.
CASE-BY-CASEPersonal (Non-reimb.)
Accidental personal charges on the company card. Flagged as non-reimbursable — deducted from any payout.
NOT REIMB.How to use the template in 5 steps
Zero setup — open the file and start on the Setup Guide sheet. Everything below assumes you've downloaded the .xlsx.
Update the Employee Roster
Open the Employee Roster sheet. Replace the 6 sample employees with your own — name, department, role, manager, ID. Every other sheet reads from here.
Verify Categories & Rates
Confirm the IRS mileage rate (default $0.70/mi for 2026) is current at irs.gov. Add or remove categories to match your chart of accounts.
Log expenses in the Expense Log
One row per expense. Date, Employee (dropdown), Category (dropdown), Description, Merchant, Amount, Billable (Yes/No), Client/Project, Report ID.
Generate the Expense Report
Open the Expense Report sheet. Change the Report ID and Employee at top — line items, category breakdown, and totals refresh instantly. Print or export as PDF.
Run the Reimbursement Summary
Set the start/end dates. SUMIFS + COUNTIFS roll up Billable, Non-billable, and Total per person. Hand off to your bookkeeper or payroll processor.
Customize it your way
Every formula and layout is open — nothing is protected. Here are the six most common edits.
Add a new category
On Categories & Rates, add a row with name, notes, and Reimbursable (Yes/No). It appears immediately in the Expense Log dropdown thanks to the referenced list.
Update the IRS mileage rate
Edit one cell on Categories & Rates — the "IRS Standard Mileage" value. Every mileage entry that references MileageRate recalculates automatically.
Add a receipt column
On the Expense Log, insert a "Receipt Attached" column between Amount and Billable. Use Yes/No or a hyperlink to a shared drive folder named by Report ID.
Switch to your currency
Select cells formatted as $, then Home ▸ Number ▸ More Number Formats ▸ Currency. Pick £, €, ¥, ₹, or your local symbol. All formulas stay identical — only display changes.
Add a Project Total sheet
Create a new sheet. Use SUMIFS(LogAmount, Log!H:H, "Acme Corp") to total all expenses by client. Handy for billing back or profitability tracking.
Grow the team roster
Add rows to the Employee Roster sheet. The VLOOKUP and SUMIFS references use fixed named ranges through row 204, so new employees are picked up automatically.
Stop chasing receipts by email.
Free download · Excel + Google Sheets + LibreOffice · No email · No account · No watermark.
Frequently asked questions
Fourteen questions covering the practical, the tax-compliance, and the "why isn't my SUMIFS working" — answered.
Is this expense report template really free?
Yes. Free for personal and commercial use. Download the .xlsx, use it for as many employees and reports as you need, and modify it however you want. No email required, no watermark, no attribution needed.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open with Google Sheets. All 246 formulas convert cleanly because we intentionally use only Excel 2007-compatible functions (SUM, SUMIF, SUMIFS, COUNTIFS, VLOOKUP, IF, IFERROR, INDEX/MATCH) — no XLOOKUP, FILTER, or dynamic arrays that would break in older Excel or Sheets.
What is the current IRS mileage rate?
The template defaults to $0.70/mile as a 2026 estimate — this is the standard business rate. The IRS publishes the official annual rate in Notice XX-XX each December. Before submitting reports, verify the current rate at irs.gov and update the "IRS Standard Mileage" cell on the Categories & Rates sheet if needed.
Does this template comply with IRS accountable plan rules?
It captures the documentation you need: business purpose (Description + Client/Project), substantiation (date, amount, category, merchant), and reimbursement against actual expenses (no advances = no return-of-excess needed). Print each Expense Report, attach receipts for anything $75+ or any lodging expense, get the manager signature, and file — that's a compliant accountable-plan record.
Can I add more than 6 employees?
Yes. Add rows to the Employee Roster sheet — name, department, role, manager, ID. Because the log and rollup use fixed named ranges through row 204 on the Log (and the employee dropdown reads the Roster range directly), new employees appear automatically in every dropdown and rollup.
How do I handle billable client expenses?
Flag each expense as Billable = Yes in the Expense Log and enter the Client/Project. The Expense Report and Reimbursement Summary both split totals into Billable vs. Non-billable using SUMIFS. At month-end, filter the Log by Billable = Yes and Client = X, and add the total to your invoice.
How do I filter for a single client's expenses?
Open the Expense Log, select the header row, then Data ▸ Filter. Click the filter arrow on the Client/Project column and pick your client. The visible rows will match — copy them into a new sheet or add the amount column to your client invoice.
Are client entertainment expenses deductible?
Since the 2017 Tax Cuts and Jobs Act, entertainment expenses are generally no longer deductible — concerts, sports tickets, golf outings, etc. Business meals separately purchased at these events remain 50% deductible. The template's "Client Entertainment" category is flagged as Reimbursable = Yes (employees still get paid back) but you should tag it as non-deductible when transferring to your books.
What's the difference between reimbursable and deductible?
Two different concepts. Reimbursable = employee gets paid back by the company. Deductible = company can reduce its taxable income by the amount. Most expenses are both, but entertainment (post-2018) is reimbursable-but-not-deductible, and personal charges are neither. This template tracks reimbursable; your accountant handles deductibility at tax time.
Do I need to attach digital receipts?
Not in this workbook directly, but yes for compliance. Store receipt PDFs or photos in a shared folder named by Report ID (EXP-2026-001, etc.). IRS requires receipts for any expense $75 or more, and for any lodging expense regardless of amount. Some auditors expect receipts for everything.
Can I track cash advances or corporate card charges?
Not out of the box, but easy to add. Insert a "Paid by" column in the Expense Log with values like Personal (owed to employee), Corp Card (no reimbursement due), or Advance (deduct from advance balance). Update the Reimbursement Summary's SUMIFS to add LogPaidBy = "Personal" as an extra criterion so only Personal-paid expenses are reimbursed.
Why did my Reimbursement Summary total change when I added a row?
Almost always because a new expense was added and it's included in the date range. If a summary that used to show $5,000 now shows $5,247, check the Expense Log for entries added within the range. To lock a prior period, either narrow the end date or export the summary as a value snapshot.
Can I convert this to a PDF I can email?
Yes. On the Expense Report sheet: File ▸ Export ▸ Create PDF/XPS ▸ pick the sheet only. Attach the receipt PDF(s) and email to your manager or bookkeeper. For a snapshot of the Reimbursement Summary, do the same on that sheet — export just the visible range.
Do I need Microsoft 365 to open this?
No. This template is deliberately built with Excel 2007+ compatibility, which means it opens in Excel 2007, 2010, 2013, 2016, 2019, 2021, 365, Excel for Mac, Excel Online, Google Sheets, and LibreOffice Calc. No subscription required.
Related templates
More free downloads that pair well with the Expense Report — most already live, a couple coming soon.
Skip the manual coding — try the AI Add-in
The Sheets & Cells Add-in categorizes expenses automatically from receipt photos, updates IRS mileage rates on release, and flags accountable-plan compliance issues — inside Excel, powered by Claude.
Get the AI Add-in →