Skip to content
The title slide and first slides of the Credit Card Rewards Tracker template

Credit Card Rewards Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Rewards cards look generous until the annual fee and the effort are counted. This credit card rewards tracker values your points in dollars so you can compare a cash back card with a travel card on equal terms. Cards holds one line per card: reward type, annual fee and what one point is worth to you in cents. The Rewards tab takes the spend, the earn rate and the card, and works out the points or percent earned and their dollar worth. The Annual Value tab compares worth against fees by card and by spending category.

The sample year holds twenty entries across four cards: a flat cash back card, a travel card with a fee, a grocery card and a miles card. The result is a plain answer to a common question: did this card earn more than it cost? Use your own point value, since a point is worth what you can redeem it for. Never enter card numbers in the file; the card name is enough.

Useful for

  • Decide whether a card with an annual fee is worth keeping
  • Find the spending category where rewards are strongest
  • Compare cash back with travel points in one table

What's included

  • 4 tabs: Cards, Rewards, Annual Value, How to use
  • Cards: a table
  • Rewards: a table
  • Annual Value: a dashboard with 5 summary figures
  • 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 Cards 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

Is a card's annual fee worth paying?

Add up the rewards you earned in the year, value them in dollars and subtract the annual fee. If the result is positive, the card paid for itself. The Annual Value tab shows this per card.

How do I value points or miles in dollars?

Divide the dollar value you get when you redeem by the number of points used, then multiply by 100 for cents per point. Use the figure you really get, not the best case.

How do I track rewards across several cards?

Give each purchase a row with the card, the spend and the earn rate. A SUMIFS formula then adds up the points and dollars for each card, and the Annual Value tab shows the totals.

  • #tracker
  • #credit-card-rewards-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…