Reply
Frequent Contributor
Meltdownblitz
Posts: 374
Registered: ‎06-01-2011

Re: How many of you have an excel sheet for your CC's???

Thank you, definitely a great idea! I just used some of your ideas and built my own for my situation which was PIF so I didn't need the balance and APR and all that. Thanks for the great idea and spreadsheet attachment!

 
Regular Contributor
Stiga9
Posts: 167
Registered: ‎03-20-2013

Re: How many of you have an excel sheet for your CC's???

I would assume everyone of us here has a spreadsheet for our cards :smileywink:
Valued Member
k0csi
Posts: 34
Registered: ‎09-15-2013

Re: How many of you have an excel sheet for your CC's???

I have a Google Docs spreadsheet that lists all my cards, their approx statement dates, current balance, statement balances, credit limit, etc and then it calculates my usage and what not so I can just keep track of how much my utilization is.  I find it actually has motivated me to pay things off that I was carrying balances on even faster once I could actually see how much money was just sitting there as debt.  I think I can export to Excel or share the Google one if you use Google Docs at all.

9-11-13 FICO EQ: 726 - Current EQ FICO: 735 - Goal: 800

------$5900-----------$3800-----------$5500-----------$8000-----------$1100---------$13000----------$4000-----------$7000------
Goodyear Service - $2000, Ford Service $2000, Discovery Furniture $8000
Senior Contributor
yudeology101
Posts: 4,584
Registered: ‎06-21-2012

Re: How many of you have an excel sheet for your CC's???


essexjet wrote:

Here is a screenshot of what I use.  I like it because I can put at util % and it tells me how much I need to pay.

 

(please dont judge balances....I'm working on it )

 


This is awesome!!  I just downloaded it, thanks for sharing!

JPM Ritz Carlton $8k I UMP Club $8k I CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k I Citi AA $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | TJX $1.55k | +6more
Scores: EQ:660 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *6-20-14*
Overall UTIL: 14% *Gardening Since: 5/10/14*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 as of 12-12-13)
Regular Contributor
James82
Posts: 191
Registered: ‎08-23-2013

Re: How many of you have an excel sheet for your CC's???

No excel sheets for me. I use HomeBudget on my iPhone and track EVERY single purchase made. It has all my accounts, all my bills, everything we purchase day to day, etc etc. All purchases under categories so I can see where our budget is good/bad. It works really well. I've used it for about 3-4 years now and it's crazy to look back through history and look at utility averages, food costs, gas cost, vehicle repairs. Everything.

Starting Score: EQ 574 - 08.28.13
High Score: EQ 714 (10/18/13) EX 686 (1/6/14) TU 664 (1/6/14)
Current Score: EQ 686 - EX ____- TU ____

            
Senior Contributor
yudeology101
Posts: 4,584
Registered: ‎06-21-2012

Re: How many of you have an excel sheet for your CC's???



essexjet wrote:

Here is a screenshot of what I use.  I like it because I can put at util % and it tells me how much I need to pay.

 

(please dont judge balances....I'm working on it )

 


 


Man, I've just downloaded, filled it, it is near PERFECT, exactly what I was looking for!  Thanks again.

JPM Ritz Carlton $8k I UMP Club $8k I CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k I Citi AA $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | TJX $1.55k | +6more
Scores: EQ:660 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *6-20-14*
Overall UTIL: 14% *Gardening Since: 5/10/14*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 as of 12-12-13)
New Contributor
essexjet
Posts: 70
Registered: ‎05-27-2013

Re: How many of you have an excel sheet for your CC's???


yudeology101 wrote:


essexjet wrote:

Here is a screenshot of what I use.  I like it because I can put at util % and it tells me how much I need to pay.

 

(please dont judge balances....I'm working on it )

 


 


Man, I've just downloaded, filled it, it is near PERFECT, exactly what I was looking for!  Thanks again.


Anytime, glad it helps out.  Helps alot with your UTIL

AMEX Platinum: NPSL / DCU $3000 / Barclaycard Apple Visa $2700 / Firestone $1200 / Credit One Bank $1100 / Walmart $700 / Capital One $500 / Chase United Explorer $5000 / Discover IT $1500
Senior Contributor
yudeology101
Posts: 4,584
Registered: ‎06-21-2012

Re: How many of you have an excel sheet for your CC's???


essexjet wrote:

yudeology101 wrote:


essexjet wrote:

Here is a screenshot of what I use.  I like it because I can put at util % and it tells me how much I need to pay.

 

(please dont judge balances....I'm working on it )

 


 


Man, I've just downloaded, filled it, it is near PERFECT, exactly what I was looking for!  Thanks again.


Anytime, glad it helps out.  Helps alot with your UTIL


Absolutely!  Question:  This is something that you've made right? If so, do you have any other excel sheet(s) that you use for other things...like bills & stuff? 

JPM Ritz Carlton $8k I UMP Club $8k I CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k I Citi AA $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | TJX $1.55k | +6more
Scores: EQ:660 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *6-20-14*
Overall UTIL: 14% *Gardening Since: 5/10/14*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 as of 12-12-13)
Frequent Contributor
Roarmeister
Posts: 311
Registered: ‎04-21-2012

Re: How many of you have an excel sheet for your CC's???

[ Edited ]

Spreadsheet as in "singular"???

 

Actually, I use several spreadsheets and several tabs within them to track not only my CCs but my investments, net worth, bank accounts, mortgage, budgets, retirement plans, credit scores, history, graphs, important dates. You won't see me post any screen shots but trust me it would be a lot of work to do so!  :smileyhappy:

 

I password lock them just to keep prying eyes away.

AMEX_PlatinumBMOWorldMCCapOnePlatinumMBNA_Platinum+ScotiaMomentum
___$18.5k______$20k_______$20k_______$25k______$25k____
Starting Score: 676 Feb 2008; Current Score: 775 EQ, 814 TU, July 2014; Goal Score: 785 by end of year
Oldest Account reported by EQ: 12.0 years; EQ AAoA: 5.3 years; EQ Credit Utilization: 2.7%
Senior Contributor
yudeology101
Posts: 4,584
Registered: ‎06-21-2012

Re: How many of you have an excel sheet for your CC's???


Roarmeister wrote:

Spreadsheet as in "singular"???

 

Actually, I use several spreadsheets and several tabs within them to track not only my CCs but my investments, net worth, bank accounts, mortgage, budgets, retirement plans, credit scores, history, graphs, important dates. You won't see me post any screen shots but trust me it would be a lot of work to do so!  :smileyhappy:

 

I password lock them just to keep prying eyes away.


Wow, this would be something interesting to get my hands on, too.  Did you make it your own or did you get it from somewhere? 

JPM Ritz Carlton $8k I UMP Club $8k I CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k I Citi AA $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | TJX $1.55k | +6more
Scores: EQ:660 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *6-20-14*
Overall UTIL: 14% *Gardening Since: 5/10/14*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 as of 12-12-13)

myFICO is the consumer division of FICO. Since its introduction 20 years ago, the FICO® Score has become a global standard for measuring credit risk in the banking, mortgage, credit card, auto and retail industries. 90 of the top 100 largest U.S. financial institutions use the FICO Score to make consumer credit decisions.

>> About myFICO
FICO Score - The Score that matters
Fair Isaac Corporation is a BBB Accredited Financial Service in San Rafael, CA
FOLLOW US Social Media Facebook Twitter Pinterest Google+