Business Insider may receive a commission from The Points Guy Affiliate Network if you apply for a credit card, but our reporting and recommendations are always independent and objective.
- The author, Holly Johnson, has 26 credit cards. This number of cards requires some organisation and planning, she says.
- She tracks her credit cards with a simple spreadsheet to monitor sign-up bonuses, annual fees, and other important details.
- Don’t rely on your memory to know which credit cards you’ve had in the past, she says. It may be harder to keep track than you think – especially when you sign up for new credit cards frequently.
Call me crazy if you want, but my husband and I have 26 different credit cards across our personal and business profiles.
We have credit cards specifically for the travel perks they offer, but most of them earned a spot in our wallets because they help us earn valuable travel rewards, flexible travel credit, or cash back.
With so many credit cards, you may be wondering if we ever get confused, use the wrong card for the wrong purchase – or worse – forget to pay our credit card bills. So far, so good. We don’t endure a lot of hiccups with our system, mostly because I am uber-organised and keep a close eye on what I’m doing.
We organise our credit cards with a simple spreadsheet
There are several different categories to keep track of when you’re actively pursuing credit card rewards. Not only do you need to keep a running list of credit cards you have now, but you also have to keep track of cards you’ve had in the past.
This is important since card issuers each have their own rules that dictate how often you can earn sign-up or welcome bonuses on their cards (e.g. the American Express once-per-lifetime rule). Knowing when you’ve had a card in the past – and when you earned a signup bonus – can prevent you from signing up for one again too soon. This is important if, let’s say, you’re waiting out Citi’s 24-month rule before trying to earn a signup bonus on a rewards credit card within the same family as one you had before.
Either way, I keep an ongoing spreadsheet that includes details on every credit card I’ve ever had. Categories I track include:
- The credit card’s name
- Who signed up (myself, my husband, or one of our businesses)
- Signup bonus and the date I earned it
- Signup date
- Annual fee
- Date annual fee is charged (or when it will be charged)
- When to cancel if I want to avoid paying an annual fee (or a second annual fee if I paid one the first year)
- Date of cancellation
Each time I sign up for a new credit card, I fill out any details I can right away. Then I continue adding information as I can. For example, when a sign-up bonus is earned, I head to my spreadsheet and write down the date in the appropriate column before I forget. I also check my spreadsheet regularly to see if I need to cancel any credit cards before their annual fees come due. Once I cancel, I write down the cancellation date on my tracking form.
Why does tracking your credit cards matter?
One of the key tenets of pursuing credit card rewards is keeping close track of your cards – and your spending – so you never get in over your head. I’ve already gone over how I keep so many credit cards and still avoid credit card debt like the plague, but my credit card tracking spreadsheet helps me track a different component of my rewards game.
Not only does it help me remain aware of which credit cards I’ve had (which is surprisingly difficult to remember over the years!), but it helps me keep track of annual fees and when they’re coming due. All I have to do is look at my spreadsheet every few weeks to know if a card is coming up on its one-year anniversary or not. From there, I can determine whether it’s worth keeping another year or not. If not, I call and cancel.
But there’s another reason tracking your credit cards is important. You never want to wind up in a situation where you no longer remember which cards you have or why you have them. Keeping a spreadsheet to track all the details in one place makes it easy to take a holistic look at your whole rewards game as a whole. It also helps you stay on top of how many annual fees you’re paying.
The bottom line: Don’t jump into credit card rewards without some sort of plan, whether that means planning to avoid debt or having a system in place to keep track of your cards and their rewards. Keeping a simple credit card spreadsheet doesn’t take a lot of time, but it preserves peace of mind, prevents stress, and saves money in the end.
Curious which credit cards I use the most and why? Here are some of my favourites:
- Chase Sapphire Reserve, because I earn 3x points on travel and dining.
- Ink Business Preferred Credit Card, because I earn 3x points on the first $US150,000 each anniversary year in business categories such as social-media advertising and shipping.
- Hilton Honours Aspire Card from American Express, mostly for the Hilton Diamond status and travel perks.
- Discover it® Miles, because Discover matches all the miles you earn the first year.
- Blue Cash Preferred® Card from American Express, because I earn 6% cash back on up to $US6,000 at US supermarkets each year; then 1%.
- Gold Delta SkyMiles® Credit Card from American Express, because I prefer flying Delta when I can.
- The Blue Business℠ Plus Credit Card from American Express, because I earn 2x American Express Membership Rewards points, up to $US50,000 per year; then 1 times with no annual fee.
- Barclaycard Arrival Plus World Elite Mastercard, because I earn 2x miles on every dollar I spend.
- Chase Freedom, because I always max out the quarterly 5x bonus categories (up to $US1,500; activation is required).
- Citi AAdvantage Platinum World Elite Mastercard, because I’ve been beefing up my stash of AA miles.
- CitiBusiness AAdvantage Platinum Select World Mastercard, so I can earn American AAdvantage miles on my business purchases.
- AAdvantage Aviator Red World Elite Mastercard, because I earned the sign-up bonus with a single purchase.
- Citi Premier Card, because I love the flexibility of Citi ThankYou Rewards.
Business Insider Emails & Alerts
Site highlights each day to your inbox.