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
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Description | Category | Amount |
| 2 | 2026-10-01 | Weekly groceries | Food | 86.4 |
| 3 | 2026-10-02 | Bus pass | Transport | 45 |
| 4 | 2026-10-04 | Dinner with friends | Food | 52.75 |
| 5 | 2026-10-07 | Electricity bill | Bills | 64.1 |
| 6 | 2026-10-09 | Movie tickets | Fun | 24 |
| 7 | 2026-10-12 | Weekly groceries | Food | 91.2 |
| 8 | Total — Food | 230.35 | ||
| 9 | Total — Transport | 45 | ||
| 10 | Total — Bills | 64.1 | ||
| 11 | Total — Fun | 24 | ||
| 12 | Total spent | 363.45 |
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.Download the CSV and import it into Google Sheets.
- 2.Add new expenses above the totals and extend the C2:C7 / D2:D7 ranges.
- 3.Turn the Category column into a dropdown (Data → Data validation) so totals never miss a typo.
- 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
Budget Template
A free monthly budget for Google Sheets that compares what you planned with what you actually spent.
Get the templateInvoice Template
A clean Google Sheets invoice with line items, subtotal, tax and total due calculated for you.
Get the templateHabit Tracker
A weekly habit tracker for Google Sheets with checkboxes and a completion rate for each habit.
Get the template