I’ve mentioned a few times that if you are getting involved with churning credit cards you will need to keep a spreadsheet to get a handle on your spend, the bonuses, when to cancel, etc.
A number of readers have asked me for a spreadsheet they can use to just that. A reader who is taking advantage of my free credit card churn planning service (plug) sent me all of his credit card data in a fantastic spreadsheet.
The spreadsheet includes space for you to fill in all of the info you need — credit card name, annual fees, bonus miles, spend required, opening date, and more. It automatically calculates the date when the annual fee kicks in, as well as the date you should cancel (11 months out) if you choose to do so.
You can download the credit card management spreadsheet here.
If you have suggestions for improvements or changes, let me know and I’ll update the spreadsheet.