cancel
Showing results for 
Search instead for 
Did you mean: 

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

tag
Meltdownblitz
Frequent Contributor

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!



Barclays Uber - 4% Restaurants, 2% Online Purchases/Everyday Card || PenFed Cash - 5% Gas || Amazon Visa Signature - 5% Amazon || U.S. Bank Cash+ - 5% Utilities, 5% Cable/Internet || AMEX BCP - 6% Groceries || WF Cash - Cell Insurance || Rotating 5% Categories - Chase Freedom, Discover It, Citi Dividend || AMEX Zync - For Fun!

Message 21 of 34
Stiga9
Regular Contributor

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 Smiley Wink
Message 22 of 34
k0csi
Valued Member

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
Message 23 of 34
yudeology101
Senior Contributor

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 $8k | 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 $6.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | Apple $2k | +23more
Scores: EQ:671 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *8-5-14*
Overall UTIL: 14% *Gardening Since: 1/20/16*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 since 12-12-13)
Message 24 of 34
James82
Regular Contributor

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 ____

            
Message 25 of 34
yudeology101
Senior Contributor

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 $8k | 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 $6.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | Apple $2k | +23more
Scores: EQ:671 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *8-5-14*
Overall UTIL: 14% *Gardening Since: 1/20/16*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 since 12-12-13)
Message 26 of 34
essexjet
Contributor

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

2/21/19 Fico's: EQ 651 - TU 666 - EXP 670
4/4/19 Fico's: EQ 744 - TU 763 - EXP 758

AMEX Platinum: NPSL / DCU $3000 / Barclaycard Apple Visa $2700 / Firestone $1200 / Credit One Bank $1100 / Walmart $8000 / Capital One $500 / Chase United Explorer $5000 / Discover IT $1500 / NFCU $1500 / Sams Club $7500
Message 27 of 34
yudeology101
Senior Contributor

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 $8k | 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 $6.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | Apple $2k | +23more
Scores: EQ:671 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *8-5-14*
Overall UTIL: 14% *Gardening Since: 1/20/16*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 since 12-12-13)
Message 28 of 34
Roarmeister
Frequent Contributor

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

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!  Smiley Happy

 

I password lock them just to keep prying eyes away.

Starting Score: EQ 732 October 2007; Current Score: EQ 839; TU 865, July 2022;
Oldest Reporting EQ Account: 20.4 years; EQ AAoA: 9.9 years;
ACTUAL Oldest account 40.1 years; ACTUAL AAoA 19.3 years.





Message 29 of 34
yudeology101
Senior Contributor

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!  Smiley Happy

 

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 $8k | 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 $6.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | Apple $2k | +23more
Scores: EQ:671 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *8-5-14*
Overall UTIL: 14% *Gardening Since: 1/20/16*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 since 12-12-13)
Message 30 of 34
Advertiser Disclosure: The offers that appear on this site are from third party advertisers from whom FICO receives compensation.