Skip to content
The title slide and first slides of the Year Over Year Spending Comparison template

Year Over Year Spending Comparison

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

At year end most people know the total they spent and little else. This comparison lines up two years by category. One tab holds this year, one tab holds last year, and the Differences tab shows the change in dollars and percent for each category, with the biggest increase marked in red and the biggest drop in green.

The Summary adds up both years, shows the change and charts the categories side by side. Notes on each row record the reason, such as a rent increase or a long trip, so the numbers still make sense next January. Sample figures describe a household with rising groceries and dining costs and falling health spending. Replace them with your own totals from bank or card statements.

Useful for

  • Review the year before setting next year's budget
  • Find the category that grew the most
  • Explain a change in spending to a partner or advisor

What's included

  • 5 tabs: Summary, This Year, Last Year, Differences, How to use
  • Summary: a dashboard with 5 summary figures
  • This Year: a table
  • Last Year: a table
  • Differences: a table
  • 1 chart 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 This Year 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 compare spending year over year?

Total each category for both years, then subtract. This sheet does that and also shows the percent change, so a small category with a big jump stands out.

Can I use year-to-date figures for this year?

Yes, but compare against the same months of last year. Otherwise every category looks lower simply because the year is not over.

What does the flag column mean?

Biggest increase and Biggest drop mark the categories with the largest dollar change up or down. Other rows show Up, Down or Same.

  • #expense-tracker
  • #year-over-year-spending-comparison
  • #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…