Credit Cards Center Credit cards from our partners
Reply
Senior Contributor
Posts: 4,301
Registered: ‎05-01-2008

Excel template for CC balances, payments, bla bla bla?

Greetings out there!

 

Has anyone posted an Excel template for listing your CC's, keeping track of due dates, statement cut dates & the like?

 

I'd love to use one, but building the template is not my forte'.

 

It would be great if anyone out there made one we can use!!  Smiley Tongue



Starting Score: 02/2015 TU 709 - EQ 676 - EX 729
Current Score: 07/2015 TU 730 - EQ 699 - EX 724
Goal Score: 850

Bury me in the garden...last app 08.09.15

Regular Contributor
Posts: 203
Registered: ‎11-24-2013

Re: Excel template for CC balances, payments, bla bla bla?

I have a basic one that lists the card, balance, limit, util, and online login info. but it's not really a template it just has all my info in it and a basic formula to do the util and totals, I have a similar one for my bills just to keep all the dates and login info in one place! it makes it a lot easier to keep track of it all!

Discover It $1k | Chase Freedom $1.2k | Barclay Apple $1.7k | Target $1k |TJX Rewards $1k | Walmart $900 | Macy's $800 | American Eagle $750 | VS $750 | LOFT $500 | Express $350 | Cap1 Sec. $200 |

AU: Amex BCP $5k | Barclaycard Arrival $3k | Amazon Visa $2k | Chase Freedom $2k | Discover It $1.5k

Gardening as of 02/04/14
Current TU FICO 701 | Goal 1: 700✓ met on 2/18/14 | Goal 2: 720


Valued Contributor
Posts: 1,066
Registered: ‎04-03-2014

Re: Excel template for CC balances, payments, bla bla bla?

I use Google's version of Excel, "Spreadshet" under their "Drive feature. This allows me to access the sheet and update it anywhere in the world I have an Internet connection and need not carry around a flash drive or be limited to a PC having MS Excel on it. The sheet has a Summry Sheet which summarizes each account, which is on separate tabs. The separate tabs have the date, description, amount spent, amount credit, and final balance in columns. The Summary sheet also has the details of each account, telephone numbers, account numbers, PIN numbers, credit limits, expiration dates, 3 digit codes, etc (certain digits of account numbers and PINS etc are reversed, for example, every 2nd digit is reversed for example, so if someone hacks in and tries the account and PIN numbers, they do not know which numbers and how many to reverse, so it is my own security feature). I also have separate tabs to track FICO, and even created a list of my recurrent expenses so I know how much I committed to spending each year (these are expenses that always occur such as car insurance, etc).

Credit Cards: AmEx Platinum (NPSL), Citi Prestige ($17.5K), Simmons ($5.5K), IberiaBank ($14K)
Personal Lines of Credit: U.S. Bank ($5K), Wells Fargo ($11.2K), Citibank ($9K), PenFed CU ($25K), LA Financial CU ($20K)
myFICO 3B Report (as of 4/30/16): Experian: Score 8: 786; Mortgage Score 2: 809 Equifax: Score 8: 801; Mortgage Score 5: 809 Transunion: Score 8: 796; Mortgage Score 4: 796
Utilization: 1%-2% (PIF monthly)
Last Hard Inquiries: 5 mortgage inquiries 5/3/16 through 5/24/16. 8/17/16 for PenFed PLOC CLI
Senior Contributor
Posts: 4,301
Registered: ‎05-01-2008

Re: Excel template for CC balances, payments, bla bla bla?

Thanks everyone! 

 

@youdon'tkillmoney...I'm liking the sound of the google drive.  I wanted something that I can save previous info, like balances, paid last month, old limits & update current limits.  Something I can update monthly withoug losing previous info.  Other Excel sheets I saw didn't really have ongoing info as part of the template.

 

But...of course...I'm at work & google drive is blocked.

 

I'm even IT admin & can't remedy this....Smiley Frustrated



Starting Score: 02/2015 TU 709 - EQ 676 - EX 729
Current Score: 07/2015 TU 730 - EQ 699 - EX 724
Goal Score: 850

Bury me in the garden...last app 08.09.15

Regular Contributor
Posts: 202
Registered: ‎11-02-2012

Re: Excel template for CC balances, payments, bla bla bla?

How do I post it? I have a very detailed one I made from raw and perfected over the past 3 yrs.

Valued Contributor
Posts: 1,066
Registered: ‎04-03-2014

Re: Excel template for CC balances, payments, bla bla bla?

[ Edited ]

On my iPhone i save the Google spreadsheet as a bookmark and can access it on my iphone. There is even a google drive app to access the file from your smartphone in the palm of your hands!

 

I use it because if I want to enter a charge for a gas pump bill, I can do it right away on the iphone bookmarked website and your work cannot block your phone web access can they!?

Credit Cards: AmEx Platinum (NPSL), Citi Prestige ($17.5K), Simmons ($5.5K), IberiaBank ($14K)
Personal Lines of Credit: U.S. Bank ($5K), Wells Fargo ($11.2K), Citibank ($9K), PenFed CU ($25K), LA Financial CU ($20K)
myFICO 3B Report (as of 4/30/16): Experian: Score 8: 786; Mortgage Score 2: 809 Equifax: Score 8: 801; Mortgage Score 5: 809 Transunion: Score 8: 796; Mortgage Score 4: 796
Utilization: 1%-2% (PIF monthly)
Last Hard Inquiries: 5 mortgage inquiries 5/3/16 through 5/24/16. 8/17/16 for PenFed PLOC CLI
Valued Contributor
Posts: 1,066
Registered: ‎04-03-2014

Re: Excel template for CC balances, payments, bla bla bla?


capitalkid wrote:

How do I post it? I have a very detailed one I made from raw and perfected over the past 3 yrs.


^^^

Maybe you can upload it to some free website and then in this box where you write the message you can insert a link (the icon looks like a chain link)

Credit Cards: AmEx Platinum (NPSL), Citi Prestige ($17.5K), Simmons ($5.5K), IberiaBank ($14K)
Personal Lines of Credit: U.S. Bank ($5K), Wells Fargo ($11.2K), Citibank ($9K), PenFed CU ($25K), LA Financial CU ($20K)
myFICO 3B Report (as of 4/30/16): Experian: Score 8: 786; Mortgage Score 2: 809 Equifax: Score 8: 801; Mortgage Score 5: 809 Transunion: Score 8: 796; Mortgage Score 4: 796
Utilization: 1%-2% (PIF monthly)
Last Hard Inquiries: 5 mortgage inquiries 5/3/16 through 5/24/16. 8/17/16 for PenFed PLOC CLI
Senior Contributor
Posts: 4,669
Registered: ‎06-21-2012

Re: Excel template for CC balances, payments, bla bla bla?

I have one which looks like this one here:

 

Screen Shot 2014-03-18 at 8.40.45 PM.png

 

 

Let me know if needed.

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)
Highlighted
Valued Contributor
Posts: 2,541
Registered: ‎05-31-2013

Re: Excel template for CC balances, payments, bla bla bla?

[ Edited ]

http://ficoforums.myfico.com/t5/General-Credit-Topics/How-many-of-you-have-an-excel-sheet-for-your-C...

I found this one searching - How many of you have an excel sheet for your CC is by a user essexjet

I have been using it for over a year and it's great for me.

Hope this helps

*never posted a link b4...lol


Forums posts are not provided or commissioned by FICO. Forums posts have not been reviewed, approved or otherwise endorsed by FICO. It is not FICO's responsibility to ensure all posts and/or questions are answered.

Advertiser Disclosure: The listings that appear on myFICO are from companies from which myFICO receives compensation, which may impact how and where products appear on myFICO (including, for example, the order in which they appear). myFICO does not review or include all companies or all available products.
† Credit cards for FICO Score ranges: The score ranges are guidelines based on internal myFICO analysis of actual applicant approvals, and having a FICO Score in a particular range does not guarantee you will be approved for credit cards recommended in that range. These ranges were not provided by any card issuer.

Copyright ©2001-2015 Fair Isaac Corporation. All rights reserved.   | Terms of Use | Privacy Policy | Sitemap

IMPORTANT INFORMATION: All FICO® Score products made available on myFICO.com include a FICO® Score 8, along with additional FICO® Score versions. Your lender or insurer may use a different FICO® Score than the versions you receive from myFICO, or another type of credit score altogether. Learn more

FICO, myFICO, Score Watch, The score lenders use, and The Score That Matters are trademarks or registered trademarks of Fair Isaac Corporation. Equifax Credit Report is a trademark of Equifax, Inc. and its affiliated companies. Many factors affect your FICO Score and the interest rates you may receive. Fair Isaac is not a credit repair organization as defined under federal or state law, including the Credit Repair Organizations Act. Fair Isaac does not provide "credit repair" services or advice or assistance regarding "rebuilding" or "improving" your credit record, credit history or credit rating. FTC's website on credit.