Business template
Expense report
Log business expenses and mileage for a period and see exactly what is owed back. Company card spending is tracked but not reimbursed.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Expense report
72 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 186 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Named ranges
- Frozen headers
- 1 chart
A look at the Expense report sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Expense report | |||||||
| 2 | Add one row per receipt. For mileage, choose Mileage and enter miles instead of an amount. | |||||||
| 3 | Employee | Jordan Reyes | Period start | 10/1/2026 | Total spent | $2,028.54 | ||
| 4 | Department | Field Sales | Period end | 10/31/2026 | Reimbursable | $1,428.24 | ||
| 5 | Purpose | Client visits, Pacific Northwest | Mileage rate | $0.700 | Less advance | -$300.00 | ||
| 6 | Cash advance | $300.00 | Owed to employee | $1,128.24 | ||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | Date | Description | Category | Paid with | Amount | Miles | Mileage | Line total |
| 10 | 10/2/2026 | Flight PDX to SEA, round trip | Airfare | Personal card | $318.40 | $318.40 | ||
| 11 | 10/2/2026 | Hotel, 2 nights, Seattle | Lodging | Personal card | $412.00 | $412.00 | ||
| 12 | 10/3/2026 | Client lunch, Quillon Robotics | Client entertainment | Personal card | $86.75 | $86.75 | ||
- expenses
- reimbursement
- mileage
- travel
More business templates
BusinessInvoiceA clean, printable invoice with line items, discount, tax and a due date worked out from your payment terms. The balance due updates as you type.
BusinessPurchase orderCreate a purchase order by picking a vendor from your list; their contact details and payment terms fill in automatically. Track received and open quantities per line.
BusinessInventory trackerKeep stock levels, values and reorder points in one place. Items at or below their reorder point are highlighted and collected on a ready to send reorder list.
BusinessRecipe cost calculatorCost out a recipe from your ingredient price list, including trim and cooking loss. See the cost per serving, food cost percentage and a suggested menu price.
Start your expense report now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.