All templates
Business
Expense Tracker
Log spending by category and see where the money goes.
Expenses3 rows
| # | ADate | BSupplier | CCategory | DAmount | EVAT | FTotal | GReceipt |
|---|---|---|---|---|---|---|---|
| 1 | 03 Sep | Fuel Stop | Travel | 62.00 | 12.40 | 74.40 | Yes |
| 2 | 07 Sep | Toolshed | Materials | 184.00 | 36.80 | 220.80 | Yes |
| 3 | 11 Sep | CloudDesk | Software | 29.00 | 5.80 | 34.80 | No |
What it tracks
- Spending by category
- Monthly totals
- Receipts logged
Included sheets
ExpensesCategoriesSummary
Key calculations
- VAT
- =Amount*0.2
- Category total
- =SUMIFS(F:F,C:C,$A$12)