Business Tools

Expense Report Template

Build a complete expense report in seconds. Add rows, auto-calculate mileage reimbursement, see category totals, then export to CSV or print as a PDF — no sign-up needed.

Report Header
Mileage Settings

For "Mileage" rows, enter miles and the rate is applied automatically.

2026 rate: 72.5¢/mile (IRS Notice 2026-10, effective Jan 1, 2026).

Rate applied: $0.725/mile (IRS Notice 2026-10)

Category Totals
Meals$0.00
Grand Total$0.00
Expense Rows
Expense #1

Business meals are generally 50% deductible (IRC §274(n)).

Row total: $0.00

Grand Total

1 expense

$0.00

How This Works

1

Fill in the Header

Enter your name (or contractor name), the company being billed, the business purpose, and the date range. These appear on the printed report and in the CSV export.

2

Add Expense Rows

Click 'Add Row' for each expense. Select a category, enter a description of the business purpose, and add the amount. For mileage, enter miles — the IRS rate is applied automatically.

3

Export or Print

Download a CSV for accounting software, or click 'Print / Save as PDF' to produce a printer-ready document. Category totals and the grand total are always visible.

What Is an Expense Report and Why Do Businesses Need One?

An expense report is a structured document that records business-related costs an employee or contractor paid out of pocket, submitted to their employer or client for reimbursement. At its core it answers four questions the IRS also cares about: Who spent the money, what was bought, when, and for what business purpose.

Businesses need expense reports for three reasons:

  • Reimbursement. Employees expect to be paid back for legitimate costs. Without a formal record, amounts are easily disputed.
  • Bookkeeping. Expense reports feed directly into accounts payable and general ledger entries, ensuring the right cost center is charged.
  • Tax substantiation. The IRS requires written records to support deductions for travel, meals, lodging, and vehicle use under IRC §274(d). An accountable plan — where employees submit reports within a reasonable time (typically 60 days) and return excess advances — keeps reimbursements out of taxable wages entirely.

IRS Publication 463 ("Travel, Gift, and Car Expenses") spells out exactly what documentation is required: the amount, date, place, business purpose, and business relationship for each expense. A well-designed expense report captures all of this in one place.

Required Fields and Recordkeeping Rules

For expenses subject to the strict substantiation rules of IRC §274(d) — which covers most business travel, lodging, meals, and vehicle costs — the IRS requires:

  • Amount of each separate expenditure
  • Date of the expense or use
  • Place of travel or entertainment (city and name of establishment for meals)
  • Business purpose (the benefit expected from the expense)
  • Business relationship (for meals — names and titles of the people entertained)

For vehicle/mileage expenses, you must also record the business destination, starting odometer, ending odometer, and total miles driven for business vs. personal use.

Keep receipts, credit card statements, and the expense report itself for at least 3 yearsfrom the date you file (6 years if you underreport income by more than 25%). For assets with depreciation, keep records until the statute of limitations expires for the year in which you dispose of the asset.

Two related tools can help with ongoing tracking: Mileage Log Template for detailed vehicle records, and the Profit & Loss Template to see how reimbursable expenses affect your business financials. For travel-specific guidance, see our blog post on Business Travel Deductions 2026.

Who Uses Expense Reports?

Any situation where business costs need to be tracked, reimbursed, or deducted

Small Business Owners

Track owner and employee spending across trips, projects, and departments to feed accurate bookkeeping.

Freelancers & Contractors

Submit expense reports to clients for reimbursement of project-related costs — from software to travel.

Sales Teams

Capture client entertainment, airfare, and hotel costs with the business purpose and client name required by the IRS.

Remote Employees

Report home-office supplies, equipment, and occasional travel under an employer's accountable plan.

What's Included

8 Expense Categories

Airfare, Lodging, Meals, Ground Transport, Mileage, Supplies, Software, and Other — covering the most common business expenses.

Auto Mileage Calc

Enter miles for any Mileage row and the IRS standard rate (70¢ for 2025, 72.5¢ for 2026) is applied automatically.

CSV Export

Download a structured CSV with the header, all expense rows, category subtotals, and grand total — ready for QuickBooks, Excel, or your accountant.

Print to PDF

One click opens the browser's print dialog. Save as PDF for a clean, professional paper record suitable for expense claims.

Why Use This Template

IRS-Aligned Fields

Every field maps to IRS §274(d) substantiation requirements — date, amount, business purpose, and category — so your reports hold up if audited.

No Account Required

Works entirely in your browser. Nothing is stored or sent to a server. Export your data any time as CSV or PDF.

Accountable Plan Ready

Reports include all the data your employer's accountable plan needs: employee name, company, purpose, date range, and itemized expenses with business justification.

Frequently Asked Questions

Official References

Mileage rates: 72.5¢/mile (2026, IRS Notice 2026-10); 70¢/mile (2025, IRS Notice 2025-5). This tool provides estimates. Consult a tax professional for advice on your specific situation.

Automate Your Expense Tracking

Jupid connects to your bank and automatically categorizes every business expense — so your expense reports write themselves.