• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Start Here
  • Work with David
  • Our Services
  • Contact
Young Adult Money

Make more. Save more. Live better.

  • Blog
  • Credit Cards
    • Rewards
    • Cash Back
    • Travel
    • Airlines
    • Hotels
    • Balance Transfer
    • Student
    • Business
  • FREE Budget Spreadsheet
  • FREE Student Loan Spreadsheet
This Just In... Check out the latest travel rewards credit card offers

Spreadsheet to Track Credit Card Rewards

By David Carlson / Last updated: April 27, 2024 / Credit Cards, Download, Spreadsheets, Travel

We may receive compensation from companies mentioned within this post via affiliate links. Read our full advertiser disclosure. Opinions, reviews, analyses & recommendations are the author’s alone, and have not been reviewed, endorsed or approved by any of these entities.
Pin376
Share33
Tweet3
Email
Buffer20
Share
432 Shares


If you use credit cards for rewards, you likely have multiple credit cards. Our credit card rewards tracking spreadsheet can keep you organize.d

For many years I used a 1% cash back credit card for all my purchases.

While this wasn’t a bad move – 1% is better than nothing, which is what you get from a debit card – it’s not ideal.

There are credit cards that offer 2% cash back on every purchase, which is double what I was getting. There are also many cards that have lucrative sign-up offers that I was completely missing out on.

If you start utilizing credit card rewards to make your vacations free or cheap, or to collect free cash back rewards, you are likely going to have a number of cards open. Some of these cards inevitably will come with an annual fee, or with a sign-up bonus that you must achieve within a certain amount of time (e.g. spend $2,000 within the first 4 months of card opening to earn 50,000 points that can be redeemed for a $500 statement credit, for example).

Compare Cash Back Rewards Credit Cards - including a great card that offers 50,000 bonus points

Between cash back credit cards, airline credit cards, and “point” credit cards, my wife and I have multiple credit cards.

It can be difficult to keep everything straight when you have multiple cards open, so I asked myself recently: why don’t I just take a few minutes when I open a card to record information in a spreadsheet?.

I create spreadsheets all the time. I work in spreadsheets all day at work and spreadsheet consulting is one of my side hustles. Many times it’s a no-brainer to me that setting up a spreadsheet is a good idea.

So I created a credit card rewards tracking spreadsheet in Excel.

 

The Credit Card Rewards Tracking Spreadsheet in Excel

 
The spreadsheet I created is simple yet effective. It can help you avoid forgetting about a card and having it renew, and it will help you keep a history of the rewards that you’ve gained so far.

 

Credit Card Rewards Spreadsheet

 
This spreadsheet has a variety of columns to capture everything you would want to know about the card you signed up for, including when you would want to cancel it by to avoid the annual fee. The columns include:

  • Number
  • Credit Card Name
  • Company
  • Business or Personal
  • Date Opened
  • Date Annual Fee Hits
  • Closed?
  • Annual Fee
  • Annual Fee Waived First Year?
  • Bonus: Spend Required
  • Bonus: Spend Timeline
  • Bonus Complete By Date
  • Bonus Description
  • Bonus Program
  • Who Signed Up?
  • Notes

When you download the file you’ll see an example credit card I added in the first row. This example can serve as a guide to populate your credit cards. You can also add or delete columns as you see fit.

I’ve been using this spreadsheet for over five years and it’s one that I keep going back to. I have yet to see a better system for managing all your credit cards and tracking rewards and annual fees.

If you want the free credit card rewards tracking spreadsheet fill in the form below and it will be sent to your email.

Join our Online Community to Receive your FREE Credit Card Rewards Tracking File

Hidden Content
Explore The Latest Credit Card Offers
Pin376
Share33
Tweet3
Email
Buffer20
Share
432 Shares

David Carlson

David Carlson is the founder of Young Adult Money. He is a nationally recognized speaker and the author of Student Loan Solution (2019) and Hustle Away Debt (2016). His opinions have been featured on such media outlets as The New York Times, The Washington Post, Cheddar, NBC's KARE11, and more.
Connect:

Comments Policy

Comments, responses, and other user-generated content is not provided or commissioned by this site or our advertisers. Responses have not been reviewed, approved, or otherwise endorsed by this website or its advertisers. It is not the responsibility of advertisers or this website to ensure that all comments and/or questions are answered. With all that being said, please comment away!

Reader Interactions

Comments

  1. Latoya @ Life and Budget says

    I want to start using credit cards for travel rewards. My daughter wants to go to Disney (I don’t know if I should cry or be happy that I’ll get another chance to go). I already use one to order our household supplies from Amazon every month and I’ve become disciplined to pay it off in full each month. I’m considering one that will help offset those Disney costs:/

    I’m sure this worksheet will come in handy when I’m ready to take on the challenge! Thanks for sharing it with us!

    • David Carlson says

      Haha yes Disney can cause conflicting feelings once you are an adult ;) I think your daughter would remember the trip forever, though, so I’m sure it’s worth going!

  2. John @ Frugal Rules says

    I do something similar to keep track of our cards as well. We’ve got too many cards not to have something to help me keep track of what we’re doing. We haven’t opened a card in the past year or so since we knew we’d be buying a house, but now that our buying process is over we’ll be opening a few new ones very soon.

  3. Rachel @ The Latte Budget says

    I had the biggest fear of credit cards for the longest time, but I finally got my first travel rewards card, and I will likely get another rewards card in the future. I actually can’t believe how much I have already earned in rewards just by doing my normal spending. Thanks for the spreadsheet!

    • David Carlson says

      I can totally relate to you being surprised how much you can earn with your regular spending. We’ve been tracking our spending for four years now so we have a good idea of what our regular costs are and even plan our bigger purchases around cards.

      Your welcome for the spreadsheet! Feel free to share with others : )

  4. Brian @ Debt Discipline says

    We use credit card reward for travel. Chase Sapphire was the last card we opened. The key is paying the bill in full monthly and only use it for everyday purchases. Thanks for the spreadsheet!

    • David Carlson says

      Nice, Chase Sapphire is definitely my top pick right now. No problem on the spreadsheet, hope you and others find it useful!

  5. Andrew@LivingRichCheaply says

    Wow you are very organized…I need to be more like you! I’m a big fan of credit card rewards. I don’t churn them like some people do so my lack of organization hasn’t hurt me so far. I have a friend who has a spreadsheet or some document that he gives his wife so that she knows what credit card to use depending on where she’s shopping so she will optimize cash back rewards!

    • David Carlson says

      Oh! You just gave me an idea for version 2 of the file ;) Haha

  6. Syed says

    We’ve been churning credit cards for a few years now, but it was only 6 months ago I started using a spreadsheet and it has changed everything! Luckily I didn’t make any big mistakes handling all the cards (have about 15 open at any time between me and my wife). But with the spreadsheet it makes it so much easier. No more fishing through old emails or statements to see when the annual fee will come due.

    • David Carlson says

      Definitely and that’s why I created this spreadsheet for my wife and I. Makes it so much easier, even if you only have a few cards open.

  7. dave Larson says

    looking forward to travel savings

Primary Sidebar

Credit Cards

  • Best Travel Rewards Cards
  • Best Balance Transfer Cards
  • Best Cash Back Credit Cards
  • Best Business And Side Hustle Credit Cards
  • Best Student Credit Cards

Start a Blog:

How to Start a Blog that Makes Money
 

Top Posts

  • 15 Ways You Can Make Money From Your Computer Right Now
  • When You Should and Shouldn’t Refinance Student Loans
  • How Much Money You Will Need to Make $1,000 in Dividends

Free Spreadsheets & Downloads

  • Free Automated Budget Spreadsheet
  • Student Loan Repayment Spreadsheet
  • The Ultimate Personal Finance Checklist
  • 401k Spreadsheet to Analyze your Options
  • Wedding Budget Spreadsheet
  • 52 Week Money Challenge Spreadsheet and Printable

First Chapter Free!

Join our online community and receive the first chapter of Student Loan Solution absolutely FREE.

If you don't see the email in your inbox, please check your spam folder.

Connect:

Categories:

Search:

Get the New Book!

Student Loan Solution: 5 Steps to Take Control of Your Student Loans and Financial Life is available on Amazon by clicking here, or by clicking on the graphic below.

Make more. Save more. Live better.

Site Directory:

  • About
  • Contact
  • Advertise
  • Recommendations
  • Finance Tools
  • Credit Cards
  • Insurance
  • Banking
  • Investing

Disclaimer | Privacy Policy

Feedback? Questions?
Contact us and let us know what you think.

Connect:

Search This Site:

Copyright © 2012–2024 Young Adult Money, LLC / All Rights Reserved
Designed by LizTheresa.com / Developed by Nuts and Bolts Media

Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Statistics

Marketing

Features
Always active

Always active
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}
Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}