Home›Templates›Expense Report
Preview of the Expense Report template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

Expense Report Template (Excel & PDF)

Claim business expenses with category drop-downs, automatic totals and the amount due after any advance.

✓ A4✓ Category drop-downs✓ Auto totals✓ Excel & PDF

Opens in your browser. No Excel needed, no signup.

Free for personal and commercial use · No watermark · Updated October 2026

Guide

About this expense report template

Employees use an expense report to claim back money spent on company business: travel, hotels, meals, fuel, supplies and client meetings. This sheet has a category drop-down on each line, totals each category automatically, subtracts any cash advance, and shows the amount due to the employee (or to be returned). It has signature lines for the employee, manager and accounts.

How to fill in an expense report

  1. 1

    Click "Edit online" to open it in your browser, or download the Excel file.

  2. 2

    Fill in your name, ID, department, manager, and the purpose and period of the expenses.

  3. 3

    Add one line per expense: date, category from the drop-down, description, payment method, receipt Yes/No, and amount.

  4. 4

    Type any advance you received in the yellow cell; the amount due updates automatically.

  5. 5

    Attach receipts, sign it and send it as PDF to your manager for approval.

Tips for faster reimbursement

Keep every receipt

Photograph receipts the day you get them. Merge them into one PDF with the JPG to PDF tool and attach it.

Describe the business reason

"Lunch with [client] to discuss renewal" gets approved faster than "lunch".

Submit monthly

Most companies set a deadline (often 30 or 60 days). Old claims may be refused.

Check the policy limits

Hotels, meals and mileage usually have daily caps. Stay inside them to avoid queries.

Frequently Asked Questions

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

Each category total uses SUMIF to add every line with that category, so the summary updates as you add or change lines.

The amount due shows as a negative number in red, which is what you return to the company.

Yes. Edit the names in the summary list and in the drop-down (Data > Data validation) so they match.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
🔄

JPG to PDF

Convert one or multiple JPG images into a PDF file

Use Tool→
🔗

Merge PDF

Combine multiple PDF files into one document

Use Tool→
💱

Currency Converter

Convert between 150+ world currencies with live rates

Use Tool→

More accounting & small business spreadsheets

Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF