Credit Tracking Spreadsheet

[jnw]

Copied my personal spreadsheet I use for tracking my credit, over to my google drive.  (I changed account names, dates and figures to protect my privacy).

Here it is:
https://docs.google.com/spreadsheets/d/1Me6QyJBiUy0j2Gyxqm-PpgA1pqySihc1QIpfB-Zz9s8/edit?usp=sharing

I type in the credit card / loan name and open date and it calculates the average age for me.  Also I enter in credit limits + overall balances and it calculates overall credit limit as well as credit utilization for me.   This allows me to fiddle around with the numbers to, e.g.,  see how closing a credit card will affect both overall average credit age as well as credit utilization.  Or seeing how utilization is affected by increasing/decreasing overall balance.

I also use it to track my hard inquiries as well chase 5/24 rule.

[GilesMM]

I use Credit Karma for most of that.  It is automatic.

[jnw]

I use Credit Karma for most of that.  It is automatic.

I use credit karma all the time.  I must not know of all the "automatic" features you speaking of.  I pull data from Experian as well.

I don't need Credit Karma to tell me my average credit age and utilization because it's as simple as entering the date the card was opened, the credit limit and the overall balances of the cards.   When I get an increase in credit limit on a card, I just update my spreadsheet and see the resulting utilization.  Or when I pay down cards I immediately see the resulting utilization.  I don't have to wait for credit karma to tell me what it will be many days later.  Also I can type in various values for balance to simulate what the resulting utilizaton would be.  I can also easily add or remove a credit card line from the spreadsheet to see what my new average credit age will be.    Threw in other stuff like foreign transaction fee, 0% APR until, and Use fields.   Also I keep track of which credit bureaus each bank hits when inquiring.  Also I track my current 5/24 status with oldest date so I immediately can recall when the next card in the 2 year history will removed, improving my status.

If none of this matters to you then I understand that credit karma could be good enough for your needs. I just thought I'd share.  But credit karma doesn't do everything my spreadsheet does.  Not that I've seen anyways -- but feel free to enlighten me :)

EDIT: My spreadsheet is really useful for when I want to churn the next card.  From one page I can see which credit bureuas will be inquiried, my current number of hard inquiries, my current 5/24 status.  When my HI and 5/24 will improve next.  What the new credit age and utilization will be etc.   It also reminds me of everything I need to keep updated in the spreadsheet each time I churn a card, so that info is there for handy reference for future churns.

[Must_ache]

Track credit?  Unless you are terrible with debt is there anything worth tracking?  My credit score has pretty much always been 800+ and I typically open and close 3+ credit cards each year for the rewards.
I do keep track of the cards I open - the date, what is required to get the rewards.  I don't want to pay annual fees so I need to close the accounts within a year.