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

Expense Tracker Excel template filled with sample 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

  1. Add one row for each expense.
  2. Pick the Category and Paid By from the drop-down.
  3. Look at the By Category table to see where the money goes.
  4. 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

← All templates