Templates › Expense Tracker
Expense Tracker Excel Template
Write every expense in one place. Pick a category from the list and see the total for each category at once.
⬇ Download free (.xlsx)Free · No sign-up · 13 KB · Works in Excel and Google Sheets
See it filled with data
The file has two sheets: a blank one for your own data, and this filled Example so you can see how it works.
What is inside
- Category and Paid By drop-down lists
- Total for each category on the right (SUMIF)
- Total spent, highest and average expense on top
- Ready for 100 entries
How to use it
- Add one row for each expense.
- Pick the Category and Paid By from the drop-down.
- Look at the By Category table to see where the money goes.
- Start a new copy every month.
Formulas used: SUM SUMIF MAX AVERAGE COUNT
⬇ Download the Expense Tracker template
More free templates
InvoiceQuotationPayment TrackerMonthly BudgetSales TrackerStock InventorySalary SheetAttendance SheetTask TrackerLead TrackerLoan EMI Calculator