Skip to content
The title slide and first slides of the Tax Return Comparison template

Tax Return Comparison

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Anyone who files every year and wonders why the result changed can use this comparison. The Lines tab holds one row per line item with a figure for each of three years, the change between the two latest years, the change as a percent and a Look flag when the move is large. The Questions tab records what to ask about each flagged line. The Dashboard totals each section for all three years in a column chart.

Start by copying figures from the returns you already filed, using your own labels for the lines. Group them into sections so income, deductions, tax and payments stay apart. When a row turns amber, write a question on the Questions tab and fill in the answer once you know it. A short written reason for each change makes next year's filing calmer.

Useful for

  • Explain why a refund shrank or an amount owed grew
  • Check that a new income source reached the return
  • Prepare questions for a tax professional

What's included

  • 4 tabs: Dashboard, Lines, Questions, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Lines: a table
  • Questions: 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 Lines 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 my tax returns from different years?

Put the same line items in rows and each year in its own column, as the Lines tab does. Then read the change columns. Use your own labels, since form line numbers can move between years.

Why did my refund change from last year?

Common causes are different income, withholding that no longer matches earnings, or a credit that changed. Compare the Income, Payments and Tax and credits sections here, and raise anything unclear with your tax professional.

How many years should I keep?

Keep filed returns for as long as current IRS guidance says you may be asked about them. Three years of side-by-side figures is a handy working view, yet it cannot stand in for the saved returns.

  • #tax-tracker
  • #tax-return-comparison
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…