Expense Report Example: Fields, Template and Card Lines

Quick Answer: An expense report is a table of business spending for a set period: one line per expense with date, merchant, business purpose, category, amount, payment method and receipt reference, plus a header naming the employee, the period and the approver. Start from your card statement lines instead of retyping receipts, then add the purpose and receipt for each line.

An expense report is the record a business uses to approve, reimburse and categorise spending that an employee or owner made on its behalf. A good example shows each expense on its own line with the date, who was paid, why, its category, the amount, how it was paid and a receipt reference, with totals at the bottom split between company-paid and out-of-pocket.

Below is a filled-in example, then a way to build the same report from card statement lines in a fraction of the time.

What does an expense report look like?

Here is a short example for one employee's trip and a few local costs. The figures are invented for illustration.

Header: Employee: J. Rivera · Department: Sales · Period: 1–31 October 2026 · Approver: Finance manager · Project/client: Northwind renewal

Totals: Company card 898.00 · Out of pocket 111.24 (personal card 93.24, cash 18.00) · Report total 1,009.24

Three things make this example work. Every line has a purpose that a reviewer who wasn't there can understand. The "Paid with" column splits what the company already paid from what it owes the employee. And each line carries a receipt number that matches a file name, so the receipt for R-03 is easy to find.

Which fields does every expense report need?

Whatever template you start with, check it has these:

• Who and when: employee name, department or cost centre, report period, submission date.
• Line detail: date, merchant, amount, currency if not your home currency.
• Why: business purpose, and the client or project if you bill costs onward.
• Where it goes: category or expense account, using your chart of accounts names.
• How it was paid: company card, personal card, cash, mileage.
• Proof: receipt reference, or a note explaining a missing receipt.
• Approval: approver name, date and signature or sign-off.

For travel, the IRS sets out what records support the deduction. Publication 463 says you need to document the amount and the time, place and business purpose of travel, and its sample record expects receipts for all lodging and for other expenses of $75 or more. Your company's policy may be stricter. This guide describes record-keeping, not tax treatment; your accountant decides what's deductible.

How do you build an expense report from card statement lines?

Retyping receipts is where most of the time goes, and where typos creep in. The card statement already has the date, merchant and exact amount for every company-card and personal-card purchase. Start there:

1. Get the statement lines. Download the card's transaction export for the period, or if the issuer only gives a PDF, convert it. QuickBankConvert turns a card statement PDF into rows of date, description and amount (charges shown as negative numbers), which you can paste straight into the report.
2. Delete what isn't business. On a personal card, remove personal purchases. On a company card, keep everything; anything personal still needs to be flagged and repaid.
3. Add the columns the statement doesn't have: business purpose, category, project and receipt reference.
4. Clean the merchant names. "SQ *DOWNTOWN PRKG 4471" becomes "Parking garage".
5. Add lines that never hit a card: cash, mileage, per diems.
6. Match receipts. Number each receipt file to match its line.
7. Total by payment method so finance can see what's reimbursable.

This approach also means the report reconciles with the card statement automatically, because the amounts came from it. For ongoing tracking between reports, see our guide on business credit card expense tracking.

Travel expense reports and per diems

A travel report adds a trip header (destination, dates, purpose) and usually separates lodging, transport, meals and incidentals. Many employers pay meals at a fixed daily rate instead of reimbursing each receipt. Publication 463 explains the federal per diem system and notes that per diem rates are listed by the federal government's fiscal year, which runs from October 1 to September 30, so a trip in late September and one in October can fall under different tables.

If your company uses per diems, the report needs the days and locations rather than meal receipts. If it reimburses actual costs, it needs the receipts.

What makes a reimbursement form different?

An employee expense reimbursement form is the request for money back. It usually summarises the out-of-pocket lines from the report (the 111.24 in the example above) and adds the employee's payment details and a declaration that the expenses were business-related.

Publication 463 describes an "accountable plan", a reimbursement arrangement that meets three rules: the expenses have a business connection, the employee adequately accounts for them to the employer, and any excess is returned within a reasonable period. Reimbursements that fail those rules are generally treated as paid under a nonaccountable plan, which changes how they're reported. A clear expense report with purposes and receipts is how employees do the "accounting" part. Whether your company's arrangement qualifies is a question for its accountant.

Monthly expense reports in Excel or Google Sheets

For a monthly expense report across a whole small team, keep one long table of every line from everyone, with a Month column and an Employee column. Then summarise:

• PivotTable: Microsoft's guide to creating a PivotTable covers putting Category in rows, Month in columns and Amount in values. That's a monthly report by category in a few clicks.
• SUMIFS: for a fixed layout, Microsoft's SUMIFS reference shows how to add up values that meet several criteria, such as category "Travel: lodging" and month "October".

The same approach works in Google Sheets, which has pivot tables and SUMIFS too. If your team is spread out and shares one file, Sheets is often easier. Our guide to tracking business expenses from bank statements shows how to keep that master table fed month after month.

Common reasons expense reports get sent back

• A purpose that only makes sense to the person who wrote it ("meeting", "supplies").
• A missing receipt with no explanation.
• A personal charge on the company card left unflagged.
• Amounts that don't match the card statement because they were typed from a receipt that included a tip added later.
• The report period overlapping the last one, so a line is claimed twice.

Building from the statement fixes the last two outright.

Related guides

• Business credit card expense tracking
• Track business expenses from bank statements
• Credit card statement to Excel
• Bookkeepers using statement conversion