Skip to content
The title slide and first slides of the Tax Refund and Payment Tracker template

Tax Refund and Payment Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Anyone who files returns every year can use this tax refund and payment tracker to keep the history in one place. The Returns tab gives each agency and year its own row, with the outcome, amount, filing date, status and the date the money arrived or left. The Payments tab lists estimated, extension and balance due payments with confirmation numbers. The Dashboard totals refunds, balances due and payments, and compares years in a chart.

The days-to-settle column makes slow years easy to spot, so you know when a refund is later than usual. Write the confirmation number for every payment, since it is the quickest way to prove a payment when an agency's records differ from yours. Update the status the day you hear something from the agency.

Useful for

  • Find out how long a refund took in past years
  • Keep proof of every estimated payment in one list
  • See at a glance whether you owed or were owed over several years

What's included

  • 4 tabs: Dashboard, Returns, Payments, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Returns: a table
  • Payments: 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 Returns 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 a tax refund?

Add a row on the Returns tab with the filing date, the amount you expect and the status Filed. Update the status when the agency accepts the return, and type the settle date when the money arrives. The days column then shows the wait.

How can I follow my estimated tax payments?

Add each payment to the Payments tab with its date, tax year, agency, amount and confirmation number. The Dashboard adds payments by year, and your bank statement can be matched to the same list.

Why does my refund differ from year to year?

Many things change it, such as income, withholding, family changes and credits. Use the Returns tab to see the pattern and consult a tax professional on any large swing.

  • #tax-tracker
  • #tax-refund-and-payment-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…