Free Expense Tracker Template for Google Sheets

By Gerard Fernandez · Updated · 2 min read

Log your expenses one per row and let the sheet do the maths. This free template totals your spending by category, shows each category's share, and keeps a running total for the current month.

Make a copy of the template

The copy goes to your own Google Drive, so only you can see it. You need to be signed in to a Google account.

The Expense Tracker template with 12 example expenses from October 2026 and drop-down categories, and a summary by category with totals and percent of spending; G4 shows =SUMIF($C$4:$C, F4, $D$4:$D)
The real template, exactly as it opens. Each category total is a SUMIF (G4 is selected). The example expenses are dated October 2026, so This month shows the full 1,361.30 during October 2026.

What's included

  • Expense log: date, description, category and amount.
  • Category drop-down: pick from Housing, Food, Transport, Bills, Health, Shopping, Leisure or Other, so every expense is spelled the same way.
  • Summary by category: total and percentage of all spending.
  • This month: spending in the current calendar month, based on today's date.
  • Number of expenses recorded.

How to use it

  1. Make a copy with the button above.
  2. Clear the example expenses (select A4:D15 and press Delete) or simply type over them. Don't delete whole rows, or you'll remove part of the summary too.
  3. Add one row per expense and choose its category from the drop-down.

The summary reads the whole column, so new rows at the bottom are included automatically.

The formulas inside

CellFormulaWhat it does
Total per category=SUMIF($C$4:$C, F4, $D$4:$D)Adds the amounts whose category matches. See SUMIF.
% of spending=IF($G$12=0, 0, G4/$G$12)Each category's share of the total. See percentages.
This month=SUMIFS(D4:D, A4:A, ">="&(EOMONTH(TODAY(), -1)+1), A4:A, "<="&EOMONTH(TODAY(), 0))Adds expenses dated from the 1st to the last day of the current month. See SUMIFS.
Number of expenses=COUNT(D4:D)Counts the amounts entered.

The category list uses a drop-down from a range: it reads the category names in F4:F11.

Customise it

  • Change the categories: edit the names in F4:F11. The drop-down updates automatically.
  • Add a category: insert a row inside the summary list and copy the formulas from the row above.
  • Totals by month: build a pivot table from the log with the month in Rows and categories in Columns.

Frequently asked questions

Why does "This month" show 0?

It only counts expenses dated in the current month. The example rows are dated October 2026, so in later months they drop out of this total; expenses you add with the current date appear straight away.

My dates aren't counted. Why?

They may be stored as text. Check that they align to the right of the cell; if not, see how to change the date format.