Skip to content
The title slide and first slides of the Category Spending Tracker template

Category Spending Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

This category spending tracker suits people who write purchases down instead of linking a bank. The Transactions tab takes a date, the place you paid, a category and an amount; the month is read from the date. The By Category tab totals each of nine categories, shows its share of everything spent and counts the purchases behind it, and draws a doughnut chart of the shares. The Chart tab turns the same rows into a column chart for January through December.

Twenty-seven sample purchases from January to November show how it looks with real use, so swap them for your own. Pick a category from the dropdown each time, because a category typed another way will not reach its total. Keep adding rows beneath the table through the year, because the summary figures read the whole column.

Useful for

  • Find which category grew since spring
  • Keep a hand-written spending diary for one year
  • Compare month totals before setting next year's budget

What's included

  • 4 tabs: Transactions, By Category, Chart, How to use
  • Transactions: a table
  • By Category: a dashboard with 4 summary figures
  • Chart: a dashboard
  • 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

How do I track spending by category in a spreadsheet?

Give every purchase one row with a date, an amount and a category from a fixed list. A SUMIFS formula then adds each category. This tracker does that for you and draws a doughnut chart.

How many spending categories should I use?

Between six and ten is enough for most households. Too many categories make logging a chore, and too few hide where money goes. This sheet starts with nine, and you can rename them.

Can I see spending by month as well as by category?

Yes. The month column fills in from each purchase date, and the Chart tab adds up every month from January to December in a column chart.

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

More expense tracker templates

See all 18

Also in Finance

All finance templates
Get this template

Preparing your template…