Column Y is the date the card was closed, if any.
Fortunately, you can take advantage of card rewards, frequent flyer programs and hotel loyalty programs to make that family vacation a breeze.I prefer the aesthetic of day month (abbreviated to 3 letters but you can format this as anything you wish.Any Suggestions to Make It Better?If you prefer working in Excel, then Google provides an easy option to download it in that format: File - Download as - Microsoft Excel (.xlsx).Contents, credit Cards Sheet, this sheet is both the most complex, the best designed, and the most useful of the four sheets.He says he and his wife have 39 active cards.In my personal spreadsheet, Ive added a table for fees credits to give me a better idea of how much Ive lost or gained on the year; it works the exact same as the rest of the tables.Having a lot of credit cards for the purpose of accumulating rewards probably sounds unwieldy fashionesta coupon code to many of your family and friends.If you check back in a few weeks I will be sharing every credit card my wife and I have ever churned.Not only can you grab your own copy of the excel document, but I even included a behind the scenes look at our own credit card strategy! .Id be happy to dive into more details or explain how any of the calculation formulas work in the comments below.There is no one-size-fits-all approach, so you will likely want to change things to suit your personal aesthetic or needs: make a copy (File Make a copy) and go to town!The format M corresponds to a months number, with no leading zero.Fields include: card name, date approved, bank, minimum spend amount, deadline for completing minimum spend, annual fee, perks and date canceled.Columns H, I, J, respectively, are for whether the bonus has been met, the direct deposit amount (if any and the amount of direct deposits to the account.Cash Bonus Other Cash, any cash earned from the signup bonus (that isnt in the form of points) cash equivalents like airline and travel credits. .That information can come in handy if you want to apply for a card a second time, since some cards require waiting a couple years before they will award a second sign-up bonus.Or put them in a Ziploc bag.Not only does it provide that example, but the data included is our actual credit card stats as of December 2017.And what to do with the cards you dont regularly use the ones that have perks but that arent appropriate for everyday spending?Y is for yes, N is for no, and N/A is for not applicable.
Credit Card Name, company, business or Personal, date Opened.