Expense report template for small business, with a filled-in sample

The short answer: an expense report template for a small business is a one-page form listing each work cost an employee paid out of pocket: date, vendor, category, business purpose, amount and receipt.

• At the bottom: mileage, any advance, totals and signature lines
• Fill it out: one line per expense in date order, one category per line, a real business purpose
• Mileage: use the right 2026 rate
• Filled-in sample below
• Next step: Plan it with the Annual Budget Spreadsheet ($6.99).

An expense report template for a small business is a one-page form. It lists each work cost an employee paid out of pocket: date, vendor, category, business purpose, amount and receipt. Mileage, any advance and the totals go at the bottom, with signature lines for the employee and the approver. Copy the layout below into a spreadsheet or document. Fill in one line per expense, attach the receipts and submit it by your deadline to get paid back.

This guide covers the report itself: the blank template, how to fill it in line by line, a filled-in sample and how to submit it so it's approved the first time. If you're the owner writing the rules behind it, start with our guide to a small business expense reimbursement policy. This is general education, not tax, legal or payroll advice. Follow your employer's policy where it differs.

What an expense report is for

An expense report is how an employee asks to be paid back, and how the business proves the payment was for real business costs. IRS Publication 463 explains that to account adequately to an employer, an employee gives an expense statement, log or similar record made at or near the time of the expense, along with documentary evidence such as receipts. A tidy report does both jobs at once.

When the employer's plan follows the IRS accountable plan rules, Publication 15 (2026) says reimbursements aren't wages. No income tax, Social Security or Medicare comes out of them. The expense report is the record that keeps it that way.

Expense report, expense tracker or reimbursement policy?

These three get mixed up, but each does a different job:

A small business usually needs all three. The policy sets the rules, employees submit reports under it, and approved reports are logged in the tracker.

The expense report template (copy this layout)

Here's a small business expense report template you can copy. Set up a short header, then a table with one row per expense.

Header

Expense lines

Totals and sign-off

Common categories are mileage, parking and tolls, airfare and train, lodging, meals, supplies, postage and shipping, software, and training. Use the same list your bookkeeper uses so each line drops straight into the books.

How to fill out an expense report in 6 steps

1. Gather every receipt for the period. Photos are fine. Number them 1, 2, 3 in the order you'll list them, and write the number on each image name.
2. Enter one line per expense, in date order. Use the date on the receipt. For mileage, use the date you drove, because 2026 has two mileage rates (more on that below).
3. Pick one category per line. If a receipt mixes business and personal items, list only the business part and note it, like "printer paper only."
4. Write a real business purpose. "Lunch" won't pass. "Lunch with Dana Lee, Lee Gifts, to plan holiday wholesale order" will. Pub 463 says a written statement of business purpose is generally required.
5. Add meal attendees and trip details. Pub 463 says a restaurant receipt should show the restaurant's name and location, the number of people served, and the date and amount. For each car trip, record the start and end points, miles and purpose.
6. Total it, subtract any advance and sign. Double-check that every amount matches its receipt, then submit the report with the receipts attached.

Sample expense report for a small business

Here's a filled-in sample small business expense report for a two-person shop. The names and numbers are made up for illustration.

Employee: Jordan Price · Period: March 1–31, 2026 · Approver: owner

The mileage line is 120 miles at 72.5 cents, which is $87.00. Notice what makes this sample easy to approve. Every line has a date, a vendor, a category and a specific purpose. The meal names who attended and why. The mileage line points to a trip log instead of a receipt.

Three versions of the template

The same layout works for most small teams. Here's when to tweak it:

If your employer pays per diem for meals and lodging on trips, list the per diem days instead of individual meal receipts. You still record the dates, place and business purpose of the trip.

How an advance shows up on the report

Sometimes the business hands out money before a trip. The report then settles up in either direction. Say Jordan received a $300 advance for a two-day trade show in August, and the receipts and mileage add up to $262.50. The bottom of the report reads:

Jordan returns the $37.50 with the report. If expenses had come to $340.00 instead, the company would owe Jordan $40.00.

Building the template in Excel or Google Sheets

A spreadsheet version does the math for you. In a simple layout with amounts in column G and miles in column F:

The same skills carry over to the household books: here's how to create a budget spreadsheet for home, or start from our ready-made google sheets budget template.

• Mileage amount: multiply miles by the rate, for example =F5*0.725 for a trip in the first half of 2026 or =F5*0.76 for one after July 1.
• Report total: =SUM(G5:G30) under the amount column.
• Amount due: total minus the advance, so a negative number means money goes back to the company.
• Category totals (optional): =SUMIF(C5:C30,"Meals",G5:G30) gives the meal total, which helps the bookkeeper.

Lock the header cells and save a blank copy as the master. Then use "Save as" or "Make a copy" for each new report so the formulas never get overwritten.

Mileage lines: use the right 2026 rate

Most small team expense reports include driving, and 2026 has two business rates. According to the IRS standard mileage rates page, it's 72.5 cents per mile from January 1 through June 30, 2026, and 76 cents per mile from July 1 through December 31, 2026.

If a report covers late June and early July, split the mileage into two lines. Your employer may pay less than the IRS rate, so use the rate in your policy. Leave out your daily commute between home and your regular workplace. That's personal driving, not business mileage.

Receipts: what to attach

• Itemized receipts, not just card slips. A card statement shows that you paid, but not what you bought or why.
• Lodging always needs a receipt. Pub 463 says documentary evidence generally isn't required for expenses under $75, except lodging, or for transportation when a receipt isn't readily available. You still record the amount, date, place and business purpose. Many employers ask for every receipt anyway, so follow your policy.
• Lost receipt? Write a short note with the date, vendor, amount and purpose, and attach any proof you have, like an emailed order confirmation. Ask your approver how they want it handled.

Expense categories and what to attach

Keep one line per expense with the date, vendor, amount, category and business reason. For drives, see our mileage log for taxes, and for the wider routine see how to track business expenses.

How to submit your report so it's approved fast

Why expense reports get sent back

• Vague purposes like "meeting," "supplies" or "travel" with no detail
• Personal items mixed in, like snacks or a family member's meal
• Wrong mileage rate or commuting miles included
• Math that doesn't match the receipts, or tax and tip missing from the total
• Late submission, past the deadline in your policy
• No signature from the employee or the approver

For owners: log approved reports in one place

Once a report is approved and paid, the business needs to record each line in the right category. A Pub 463 note matters here: employees who account to the employer and get reimbursed generally don't need to keep their own copies, so the business holds the record. Our Business Income & Expense Tracker ($7.99) is a spreadsheet for Excel and Google Sheets. You log each reimbursed line in the transactions tab with a category dropdown. The "paid via / account" column shows who was paid back, and the "receipt / notes" column points to the report. A mileage log and monthly profit and loss roll it all up. It isn't a payroll system, and its totals are estimates for your records, not tax advice. Its mileage log uses one rate, so enter 2026 trips at the rate for each half of the year.

Prefer to start free? Our free small business expense spreadsheet is a basic log for the business's own spending. Add an employee column and use it to track which reports you've paid. You can also browse every budget and business sheet we make in Spreadsheets.

Keep a copy and stay consistent

Use the same template every month so approvers know where to look. Save each signed report with its receipts by month. Our guide on how long to keep documents covers how long to hold business records.

Keeping business and household money apart is easier when the home side has its own plan, and our family budgeting guide covers that side step by step.

Before HomeBase, I worked as an executive assistant and as an HR associate, jobs where paperwork either flows or piles up. A good expense report is one form, filled in the same way every time, with nothing left for the approver to guess. Copy the layout, keep your receipts numbered and send it in on time.