Skip to content
Spending Tracker by Category cover: a sample sheet with total spent, transactions and average purchase and a doughnut chart, beside the Dashboard tab

Spending Tracker by Category

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This tracker helps people who want to know where their money goes without building a full budget. The Transactions tab records each purchase with its date, merchant, category, payment method and amount, and works out its week number. The Dashboard gives the grand total, the average purchase and two charts, one split by category and one by card, cash or other payment method.

The Weeks tab adds up each week, counts the purchases and gives an average, so you can compare one week with the next. Use the same category names as the list on the Transactions tab, because a new name will not appear in the breakdown. Review the top categories every weekend and pick one to cut back on.

Useful for

  • Finding which category takes the biggest share
  • Seeing whether this week ran higher than last week
  • Checking which payment method you use most

What's included

  • 4 tabs: Dashboard, Transactions, Weeks, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Transactions: a table
  • Weeks: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Transactions tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Why does the week number look wrong?

The week number uses WEEKNUM, which counts weeks from the start of the year and begins each week on a Sunday. A purchase dated on a Sunday starts a new week. Add the week numbers you need to the Weeks tab so the totals pick them up.

Can I add a category?

Yes. Put the new category in the list that feeds the Transactions tab plus one more line in the Dashboard breakdown. Spell it identically in both places, or its spending will not be counted.

How do I track spending for a full year?

Log the purchases as they happen and add a row to the Weeks tab for each new week number. Fill the formulas down from the row above. Totals on the Dashboard refresh as you go, so the busiest week and the category shares stay current.

  • #expense-tracker
  • #spending-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…