Planning the year ahead

How I keep on top of my credit cards
credit card spreadsheet


The Daily Navigator strives to help you make the best personal finance decisions. While we produce content according with strict editorial integrity this post may contain references to partner products. Here’s a full explanation for how our team makes money.

You must stay organized if you’re serious about building your points and miles. Opening several cards can get complicated, and with some cards now requiring substantial annual fees, you could easily find yourself in debt on a card you’ve only used once.

I strongly advise building a spreadsheet to keep tabs on all your cards. This way, you can anticipate when fees are due, the benefits they offer, and your earned points. I’d recommend including the following details similar to the picture above.

What to put in your travel hacking spreadsheet

  • The card name

  • Date opened

  • The annual fee and when it’s due

  • The intro bonus and whether you’ve earned it

  • Its earning rate

  • Its most notable perks

  • If you have debt on the card

As you can see from the snapshot above, the Amex Platinum is very expensive. But it offers $200 in hotel credits, which I’ll use strategically to save even more. It also provides Hilton Gold status, negating the Hilton Surpass’ biggest perk. That’s an argument for closing the Surpass, which costs $95 a year. While the Delta Gold card offers me free checked bags, the Platinum comes with a $200 airline credit statement that I can use for the same thing. 

All in all, the Platinum’s high $695 annual fee is reduced to $305 if I want to keep the benefits. Whether I will keep it is another story, but the spreadsheet helps me see all that clearly and stay organized throughout the year.

Editorial Disclaimer: Opinions expressed here are the author’s alone. This post contains references to products from one or more of our partners and we may receive compensation when you click on links to those products.

Stay in the know

Get expert insight into credit cards, loyalty programs, financial tips, and more delivered right to your inbox.

Related Stories

No more posts to show
Smart Points Logo

Stay in the know with
Smart Points Newsletter

Get expert insight into travel credit cards, loyalty programs, points tips, and more. Recent edition →

Get expert insight into travel credit cards, loyalty programs, points tips, and more. Recent edition →

Advertiser Disclosure

This article contains references to products from one or more of our advertisers. We may receive compensation when you click on links to those products. The relationship may impact how an offer is being presented. Our site doesn’t include all the offers available. Terms apply to the offers listed on this page. For an explanation of our Advertising Policy, visit this page.

DFC Partner Perks App Link Image
Special Discounts for Our Members

Save Big with Perks

Get $5,000+ in immediate travel savings with Perks. Unlock next level travel benefits, for life. Get discounts from the world’s best travel brands you won’t find anywhere else. No credit required.

DFC Concierge App Link Image
Special Discount for Our Members

93% off lifetime access

Save $1,200 and 10 hours of your time on every vacation. With Lifetime access to DFC Concierge, get fully customized trip itineraries to make every vacation unforgettable.

Dollar Flight Club App Link Image
Special Discount for Our Members

50% Off PREMIUM

You can save up to $500 on your next adventure without lifting a finger get email alerts when we find flights up to 90% off leaving your home airport. Just let us know your departure airport and we’ll do the rest.

The Daily Navigator Commitment

The Daily Navigator is an integral part of the larger DFC Media family. Through each of our brands, we’re dedicated to helping our readers travel, spend, and live smarter.

With products dedicated to affordable travel, educational content, and personal finance, we deliver the day’s essential content with none of the filler — all in a way that’s fast, easy, and fun to read. Every day million of audience members trust us to deliver educational content so that they can make informed decisions faster. We hope you’ll join them.

We’re happy to have you here!