I recently created a spreadsheet of all my credit card and loan debts. It's really helped me put into perspective how much I was paying each month. So far, the spreadsheet keeps track of my creditors, credit limits, amount owed, min monthly payments, APR, any annual fees, and utilization. I also have it set up to hightlight the utilization field so if its under 30% it'll turn green, from 31%-49% it'll turn yellow, and anything above 50% it'll turn red.
For those of you who have created such spreadsheets, do you have anything else that you track with it?
Starting Score: EQ667/TU681/EX654
@Thomas_Thumb wrote:I don't have such a spreadsheet. Nonetheless, I would suggest tracking individual card utilizations as listed (except change yellow to 29.0% - 49.9%). Then add aggregate utilization with green for under 9.0%, yellow for 9.0% to 28.9% and red for 29.0% and above. Set rounding to the nearest 0.1%.
Not sure how many card you have but you could also highlight # or % of accounts with balances. If you do %, keep it simple. I'd personally go with LE 50% green and over 50% yellow. Otherwise do it on a count basis. If you have 7 cards then LE 3 or is green and otherwise yellow.
I do have utilization for each card and then the aggregate utilization. I'll adjust the color scheme per the recommendation. I do like the idea on tracking the number of cards with balances. Currently I have 11 cards with 7 having balances (currently working on AZEO). Appreciate the suggestions.
@RSX wrote:i have additional sheet that i track the following on
Age of Accounts Date Opened Credit Limit Orig loan 2 yr + Status Limit increase date APR Cap1MC Aug 20 2010 16750 OPEN Mar 23 2020 13.5->16.75 29.15
on this same sheet i track all my Saving Accts and their respective Balances
That's an excellent idea on tracking the limit increase dates. I've often forgotten on when my last CLI requests were. Thanks for the suggestions.
@ozzman469 wrote:I recently created a spreadsheet of all my credit card and loan debts. It's really helped me put into perspective how much I was paying each month. So far, the spreadsheet keeps track of my creditors, credit limits, amount owed, min monthly payments, APR, any annual fees, and utilization. I also have it set up to highlight the utilization field so if its under 30% it'll turn green, from 31%-49% it'll turn yellow, and anything above 50% it'll turn red.
For those of you who have created such spreadsheets, do you have anything else that you track with it?
I also keep track of my net worth that rolls as I change the amount owed and value of the asset along with growth in short and long-term savings/investment accounts. It's addictive playing around with it. It's changed immensely in the 10 or so years I've used it.
I PIF in full every month. Don't care about CL's or APR's. But while on the subject of "financial" spreadsheets:
I spreadsheet, track, and calculate mine & my wife's income. We are both W2's, but I adjust for any 1099's (bonuses, dividends, stocks, gains, etc), as well as any deductions. I monitor federal, state, local, SS, & Medicare taxes like a hawk. By the end of the last quarter, I can come really close to breaking even. We owed $75 to federal, & $20 to state for 2022. I NEVER aim for a refund, as I do not like to give the govt an interest-free loan, and slightly owing means that I am in no rush to file my taxes, like all the idiots that panic because they "need" their refund yesterday. My spreadsheet also includes growths in our 401k's, 403b's, IRA's, etc.
I can't tell you how many of my co-workers spreasheet their fantasy football, baseball, ncaa brackets, etc, down to knowing and memoriziing multiple players' stats, yet have no idea about their own paycheck-to-paycheck finances. Yet they are suprised when they have a $5,000 tax bill. Every.single.time. And to make it worse, they will have an extra $20 taken out of each paycheck, thinking that they will break even the following year. Really? Many are on IRS payment plans.
But they can tell you how many points Lebron averages per game. Baffling.
I am so terrible with spreadsheets, but would definitely be eternally grateful if someone could post one of theirs to share with the group? 
@derboesekoenig wrote:I am so terrible with spreadsheets, but would definitely be eternally grateful if someone could post one of theirs to share with the group?
Here's a nice one by @ccquest -- Account Aging Metrics / Utilization spreadsheet
