Free Expense Report Template
For employees who pay out of pocket for parts or fuel and need a clean report the owner can approve and pay back.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Reports, Expenses and Employees, no typing needed. |
| Expense Report | Totals and views built from Reports, Expenses and Employees, no typing needed. |
| Reports | Columns Report number, Employee ID, Period start, Period end, Business purpose, Advance received, Mileage rate, Mileage rate override (optional), Approval status and 2 more. |
| Expenses | Columns Line ID, Report number, Date, Type, Vendor or trip route, Category, Job or client, Payment method, Cash amount and 3 more. |
| Employees | Columns Employee ID, Name, Email and Role. |
| Settings | Your own dropdown lists (fuel and cash), so the choices match how you work. |
How to fill it in
- Add employees on Employees.
- Start a report on Reports with the period, the purpose and any advance.
- Add each cost or trip on Expenses with a receipt link or the miles.
- Print the Expense Report tab for approval, then record the paid date.
A tip from the field
Mileage lines use the rate set on the report, so set it once per period instead of once per trip.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
Related templates
- Free Google Sheets Expense Tracker
- Free Google Sheets Mileage Log
- Free Google Sheets Payroll Template
When you outgrow it
Smarfle records job costs as they happen and shows what each job really earned. See how it works on smarfle.com.