Free Google Sheets Expense Tracker

Add one row per purchase. The summary at the bottom totals spending by category with SUMIF, so you can see where the money went this month.

What it looks like

ABCD
1DateDescriptionCategoryAmount
22026-10-01Weekly groceriesFood86.4
32026-10-02Bus passTransport45
42026-10-04Dinner with friendsFood52.75
52026-10-07Electricity billBills64.1
62026-10-09Movie ticketsFun24
72026-10-12Weekly groceriesFood91.2
8Total — Food230.35
9Total — Transport45
10Total — Bills64.1
11Total — Fun24
12Total spent363.45
Tab: Expenses. Teal cells are live formulas; hover one to see it.

What's included

  • Date, description, category and amount for every purchase
  • Category totals with SUMIF
  • Works with a Google Form for logging expenses from your phone

How to set up the expense tracker

  1. 1.Download the CSV and import it into Google Sheets.
  2. 2.Add new expenses above the totals and extend the C2:C7 / D2:D7 ranges.
  3. 3.Turn the Category column into a dropdown (Data → Data validation) so totals never miss a typo.
  4. 4.Insert → Chart on the totals to get a spending pie chart.

Questions

Can I log expenses from my phone?
Yes. Create a Google Form with Date, Description, Category and Amount and link it to this sheet (Responses → Link to Sheets).

More templates