How to Make an Expense Report from Receipts

An expense report has one job: let someone who was not there understand what was spent, why, and how much should be paid back. When reports come back with questions, it is almost always because one of those three things was unclear. A missing receipt, a vague description, or a total that does not add up is enough to stall a reimbursement for weeks.

This guide covers who needs expense reports, what fields to include, a worked example you can copy, and the formulas that make the totals reliable.

Who needs an expense report?

• Employees who paid for business costs out of pocket or on a personal card and need to be reimbursed.
• Owners of an LLC or corporation who paid company expenses personally. Documenting and reimbursing them through a report keeps business and personal funds separate.
• Freelancers and consultants who rebill travel or materials to a client and need to show what they are passing through.
• Bookkeepers closing out a period who need a clean summary of card or petty cash spending for review.

Why the structure matters: accountable plans

For employers, how reimbursements are handled has tax consequences. Under what the IRS calls an accountable plan (explained in IRS Publication 463 and in the employer guidance in Publication 15), reimbursements are generally not treated as taxable wages if three conditions are met: the expenses have a business connection, the employee substantiates them within a reasonable period, and the employee returns any excess advance within a reasonable period. Reimbursements that do not meet these rules are generally treated as wages.

In plain terms: a reimbursement policy with proper expense reports, submitted promptly and with receipts, is what keeps reimbursements from becoming taxable income. Publication 463 also describes what counts as adequate records for travel, meals, and gifts, including documentary evidence such as receipts for lodging and for other expenses of $75 or more.

Note: this is general information, not tax advice. Your accountant can help you set up a reimbursement policy that fits your business.

The fields every expense report needs

Header (once per report)

• Employee or submitter name
• Report period or trip dates
• Purpose of the trip or project (for example, Trade show, Chicago, March 9 to 12)
• Client or project code if expenses will be rebilled
• Total requested, less any cash advance already received
• Submitter signature and date, approver signature and date

Line items (one row per receipt)

A worked example

Here is a three-day sales trip, entered as a table starting in cell A1, with Category in column C, Payment method in E, and Amount in F:

Two totals matter: the trip's total cost, and the amount actually owed to the employee, which excludes items paid on the company card. A small summary block next to the table handles both:

Total trip cost:
=SUM(F2:F8)

Reimbursable (exclude company card):
=SUMIFS(F2:F8, E2:E8, "<>Company card")

Subtotal by category (put category names in H2:H7):
=SUMIFS($F$2:$F$8, $C$2:$C$8, H2)

Amount due after a $200 cash advance (advance in cell J2):
=SUMIFS(F2:F8, E2:E8, "<>Company card") - J2

For this trip, the total cost is $1,459.95, of which $1,073.55 is reimbursable, because the $386.40 airfare went on the company card. After a $200 advance, $873.55 is owed to the employee. A category subtotal block also makes policy checks quick: if your policy caps meals per day, you can see the Meals total at a glance.

Adding mileage

If the employee drove their own car, mileage is typically reimbursed at a per-mile rate instead of with fuel receipts. Many businesses use the IRS standard mileage rate, which the IRS publishes each year. Record date, starting point, destination, business purpose, and miles for each trip, then calculate:

Mileage amount (miles in column G, rate in cell K1):
=G2*$K$1

Keep the rate in a single cell and reference it, so updating the rate for a new year does not mean editing every formula.

Building it faster from a pile of receipts

The slow part of any expense report is reading each receipt and typing the date, vendor, and total. The expense report from receipts converter does that for you: upload the trip's receipt photos and PDFs, choose the expense report layout, and download a spreadsheet with one row per receipt and category subtotals. You then add the business purpose and payment method, which only you know, and the report is ready for approval.

If you need the line items, for example to separate alcohol from food on a client dinner or to show what was bought on a supply run, use the standard layout from the receipt to Excel converter, which keeps each item line on its own sheet. For a shared report that several people add to, the receipt to Google Sheets export drops into a shared sheet easily.

Submission and approval checklist

1. Every row has a receipt attached or referenced, and receipts are legible.
2. Every meal lists who attended and the business purpose.
3. Company card charges are marked so they are not reimbursed twice.
4. Totals and category subtotals tie out, with the mismatch check showing OK.
5. The report is submitted promptly after the trip or period, in line with your policy.
6. Any unused cash advance is returned or deducted.
7. The approver signs and dates it, and the approved report plus receipts are filed together.

Expense reports for freelancers rebilling clients

If you are a freelancer passing costs through to a client, the expense report doubles as backup for your invoice. A few differences from an employee reimbursement report are worth noting:

• Filter to billable items only. Use the Billable column and total only those rows: =SUMIFS(F:F, G:G, "Yes") with Billable in column G.
• Check your contract for markup terms. Some agreements allow a handling fee on materials; others require costs at exactly what you paid. Show the markup as its own line rather than inflating individual receipts.
• Attach the receipts. Clients who reimburse costs usually want copies. A single PDF of receipt images, in the same order as the report rows, makes approval easy.
• Keep your own copy. The receipts still support your own deductions and income, since the reimbursement you receive is part of your business records.

Sending a clean, totaled report with receipts attached tends to get paid faster than a bare invoice line that says Travel expenses with no detail.

Common reasons reports get sent back

• A card statement instead of a receipt. It shows the amount but not what was purchased.
• Vague descriptions. Meeting or Supplies with no context will draw questions.
• Personal items mixed in. A hotel folio with a movie rental or minibar charges needs those items removed.
• Duplicates. The same dinner submitted from both the itemized receipt and the card slip.
• Late submission. The longer a report waits, the harder it is to remember purposes and find missing receipts.

Expense reports do not have to be a chore. For the supplies side of things, if your team regularly buys consumables, tracking them in the free office supplies inventory template helps you spot when a repeat purchase is actually needed. And once reports are approved, the next step is usually getting them into your books, which our guide on importing receipts into QuickBooks Online covers.