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: 165
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,270
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 CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k | BCE $1k I Citi AA WMC $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Sony $1k | Bloomingdales $1.5k | TJX $1.55k | +4more
Scores: EQ:641 (FICO 6) EX:686 (FICO 10pt) TU:686 (FICO 1) *2-20-14*
Overall UTIL: 14% *Gardening Since: 3/27/14*
------------------------------------------------------------
EQ/EX/TU currently on vacation at the North Pole, enjoying the freezing weather!
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,270
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 CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k | BCE $1k I Citi AA WMC $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Sony $1k | Bloomingdales $1.5k | TJX $1.55k | +4more
Scores: EQ:641 (FICO 6) EX:686 (FICO 10pt) TU:686 (FICO 1) *2-20-14*
Overall UTIL: 14% *Gardening Since: 3/27/14*
------------------------------------------------------------
EQ/EX/TU currently on vacation at the North Pole, enjoying the freezing weather!
New Contributor
essexjet
Posts: 67
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 Green: 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,270
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 CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k | BCE $1k I Citi AA WMC $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Sony $1k | Bloomingdales $1.5k | TJX $1.55k | +4more
Scores: EQ:641 (FICO 6) EX:686 (FICO 10pt) TU:686 (FICO 1) *2-20-14*
Overall UTIL: 14% *Gardening Since: 3/27/14*
------------------------------------------------------------
EQ/EX/TU currently on vacation at the North Pole, enjoying the freezing weather!
Frequent Contributor
Roarmeister
Posts: 286
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.

AmexGoldBMOWorldMCCapOnePlatinumMBNA_Platinum+ScotiaMomentum
___$18.5k______$20k_______$20k_______$25k_______$20k____
Starting Score: 676 Feb 2008; Current Score: 771 EQ, April 2014; Goal Score: 780 by end of year
Oldest Account: 32.0 years; Current AAoA: 15.1 years; Current Credit Utilization: 1.4%
Senior Contributor
yudeology101
Posts: 4,270
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 CSP $5k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k | BCE $1k I Citi AA WMC $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $3.5k I IT $1.5k | Sony $1k | Bloomingdales $1.5k | TJX $1.55k | +4more
Scores: EQ:641 (FICO 6) EX:686 (FICO 10pt) TU:686 (FICO 1) *2-20-14*
Overall UTIL: 14% *Gardening Since: 3/27/14*
------------------------------------------------------------
EQ/EX/TU currently on vacation at the North Pole, enjoying the freezing weather!

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
Click to Verify - This site chose VeriSign SSL for secure e-commerce and confidential communications.
Fair Isaac Corporation is a BBB Accredited Financial Service in San Rafael, CA
FOLLOW US Social Media Facebook Twitter Pinterest Google+