CC Management / Utilzation Help
- yoyo11
-
- Offline
- Finance Leader
-
- Posts: 307
Replied by yoyo11 on topic Re: CC Management / Utilzation Help
Hi Everyone]http://www.innovativepolitics.com/CC_Matrix.xls[/URL]
It is in Excel format, so you will need Microsoft Excel to use it. I also included a few examples so you can get started.
I hope it helps somebody!
James
Wow...boy do i need a spreadsheet...tried that ones that came with my computer...but it wasn't this helpful...thanks a bunch!!

16 years 10 months ago
#31
- Meya
-
- Offline
- Finance Commander
-
- Posts: 4522
Replied by Meya on topic Re: CC Management / Utilzation Help
i like this one, it is similiar to the one i use except for I tally across and down to try and make it lesser for next year. does anyone here tally misc items (ie. gifts, hand out change, tickets, extras that are not included)? I do, so that at the end of the year, if I am lower than last year, I give the extra to my installment loans.
16 years 10 months ago
#32
- shark6
-
- Offline
- Junior Member
-
- Posts: 208
Replied by shark6 on topic Re: CC Management / Utilzation Help
Thanks. I just copied the spreadsheet. I've added the following columns:
1. Credit Limit Increase
2. CLI Date
3. Balance at 35%
4. Fico Scores
1. Credit Limit Increase
2. CLI Date
3. Balance at 35%
4. Fico Scores
16 years 10 months ago
#33
- RivasGlo
-
- Offline
- Finance Leader
-
- Posts: 391
Replied by RivasGlo on topic Re: CC Management / Utilzation Help
I am excel and onenote crazy. Im am a VERY organized person and at my job when I first started there ppl use to call me OfficeDepot/Staples... BC everything you needed or wanted, I had it!
I have made a spreedsheet aswell that ive used ever since I started building credit.. As I get more cc's and utilities/bills, I slowly add them. It doesnt generate any percentages... Its just basic statement & pymt info. I just print it and write the info as it comes in.
Heres a screenshot....
S: Stmt // Y: Yes I do get stmts by mail; N: No stmts by mail
Closing Date: To keep track on when stmts usually print
I the have payment info to keep track of the pymts ive made during that billing cycle, of when, how much and method used when I pd and if it already cleared or posted... (I just put a check in that box once the pymt posted)... Some boxes are black bc that info is not needed... so that I dont accidently write something bc im a freak when it comes to doing and redoing stuff!
Or ill just bust my whiteout out!
I have made a spreedsheet aswell that ive used ever since I started building credit.. As I get more cc's and utilities/bills, I slowly add them. It doesnt generate any percentages... Its just basic statement & pymt info. I just print it and write the info as it comes in.
Heres a screenshot....
S: Stmt // Y: Yes I do get stmts by mail; N: No stmts by mail
Closing Date: To keep track on when stmts usually print
I the have payment info to keep track of the pymts ive made during that billing cycle, of when, how much and method used when I pd and if it already cleared or posted... (I just put a check in that box once the pymt posted)... Some boxes are black bc that info is not needed... so that I dont accidently write something bc im a freak when it comes to doing and redoing stuff!

16 years 10 months ago
#34
- hjm331
-
- Offline
- Finance Commander
-
- Posts: 3479
Replied by hjm331 on topic Re: CC Management / Utilzation Help
That's a really good spreadsheet. It will keep everything nice and organized.
16 years 10 months ago
#35
- wildrage2
-
Topic Author
- Offline
- Junior Member
-
- Posts: 60
Replied by wildrage2 on topic Re: CC Management / Utilzation Help
No problem! I was going crazy with all the different due dates, etc. I thought it would be an added bonus to throw in the utilization formula's as well. Let me know if there are any ways it can be improved.
16 years 10 months ago
#36
- rwmtd
-
- Offline
- User is blocked
-
- Posts: 130
Replied by rwmtd on topic Re: CC Management / Utilzation Help
Wildrage2, this spreadsheet is awsome. I've been looking on line for a piece of software that would do what this spread sheet does. Thanks so much for sharing. 
RWMTD

RWMTD
16 years 10 months ago
#37
- KMoney
-
- Offline
- Finance Leader
-
- Posts: 661
Replied by KMoney on topic Re: CC Management / Utilzation Help
Great Spreadsheet
16 years 10 months ago
#38
- wildrage2
-
Topic Author
- Offline
- Junior Member
-
- Posts: 60
was created by wildrage2
Hi Everyone:
Since I recently opened up so many credit cards (like 10 in the past year), I created a spreadsheet for myself to calculate my utilizations, minimum payments, due dates, and target payments each month. It's nothing too amazing - just a way of seeing what your current utilization is and what payment is necessary to get to the target utilization (which you define).
I thought it might be useful for others, so I posted it to my webspace:
http://www.innovativepolitics.com/CC_Matrix.xls
It is in Excel format, so you will need Microsoft Excel to use it. I also included a few examples so you can get started.
I hope it helps somebody!
James
Since I recently opened up so many credit cards (like 10 in the past year), I created a spreadsheet for myself to calculate my utilizations, minimum payments, due dates, and target payments each month. It's nothing too amazing - just a way of seeing what your current utilization is and what payment is necessary to get to the target utilization (which you define).
I thought it might be useful for others, so I posted it to my webspace:
http://www.innovativepolitics.com/CC_Matrix.xls
It is in Excel format, so you will need Microsoft Excel to use it. I also included a few examples so you can get started.
I hope it helps somebody!
James
16 years 10 months ago
#39