I've been working on this today... wanted to find a way to easily see all the relevant bits of credit report data in on place. Once I've perfected it, I want to make an excel template for other to use, so that people who are looking to improve their credit can easily collect all of the info that they (and everyone helping them) will need to know in order to come up with the best plan.
Hopefully this image posts okay:
That's a beautiful spreadsheet! (You may want to redact some more of it though!)
My spreadsheet doesn't include as much about accounts as they appear on my CR, but I do keep a history of scores to make a line graph! Seeing the drops keeps -- well, is supposed to keep! -- me in the garden.
@GrasshopperStudentif your going to stay in the Garden, you may want to be careful about what weed killers you use ... also that it doesn't attack Grasshoppers (hey, lived in farm country).
*chirp chirp* (kudo) *chirp*
I use an Excel file, but the key page is one for a different purpose.
I list all the open / active accounts, limits, STATEMENT DATE, amount I expect to pay, and color code that column with what I expect to pay. As the STATEMENT DATE comes along, I know to go log in to that bank, and look for the STATEMENT. I reconcile the activity / balance in my Microsoft Money program on my PC. I check the STATEMENT to see when the AUTOMATIC PAYMENT is scheduled to be made. In cases on the spreadsheet where there is no AUTOMATIC PAYMENT, I schedule the Pull payment in in the CC website, for 3 weeks out / the DUE DATE. I then take off the color code for the cell in that month's payments column, so I know that card is set up for the next payment. This color coding makes it easier to see, as the calendar month progresses, which cards I have NOT looked for the statement yet.
On another sheet I keep track of useless info like date opened, dreams of creditlimits, which I might close or app for next, still another sheet lists points / cashback amounts, free nights, travel credits, to look for on the multitude of programs.
The main thing any CC spreadsheet should do is ensure you ALWAYS make at least the minimum payment on time. If it does not support you in this task, the spreadsheet is a failure waiting to happen.
This is a good idea. I should make a Google Sheet because that would be easy to access from my phone.