Reply
Senior Contributor
Posts: 4,267
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!!  :smileytongue:



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

Bury me in the garden...last app 12.19.14

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


Frequent Contributor
Posts: 494
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).

Senior Contributor
Posts: 4,267
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....:smileyfrustrated:



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

Bury me in the garden...last app 12.19.14

Regular Contributor
Posts: 179
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.

JCP Platinum 6.5K. I Barclaycard UPromise MC 5K. I Discover IT 6.5K. I Sears MC 4.6K. I USAA Amex 11K. I USAA PLatinum MC 11K. I Chase Sapphire Preferred 10K I Lowes 8.5K. I Paypal MC 6K. I Dell Preferred 2.5K. I Citi HHonors Reserve 3.2K. I CarCareOne 2.4K. I Best Buy 6.5K. I Care Credit 10K. I Capital One (Credit Steps) Platinum 3.7K. I Roamans $1700 I Chevron Visa 2300 I Capitalone Venture 10K.

BK 7 July 2005.
Frequent Contributor
Posts: 494
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!?

Frequent Contributor
Posts: 494
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)

Senior Contributor
Posts: 4,654
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 | +13more
Scores: EQ:671 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *8-5-14*
Overall UTIL: 14% *Gardening Since: 9/12/14*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 as of 12-12-13)
Established Contributor
Posts: 760
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

>Starting Score: 480 (CK - 5/11)Current Score: (EQ)739 (EX)745 (TU)747 Per MyFico(3/18/15) Goal Score: 830 (Last app 7/14) Perpetual Gardener Cards: Macys Store (1,200) My BestBuy (3,000) Chase Freedom Visa (3,000) Chase Slate (3,500) Home Depot (4,500) Citi Simp.Visa (5,100) Barclays World Arrival (5,400) Belk (5,500) Chase Sapphire (6,000) Macys Amex (6,000) Discover iT (7,100) JCP Gold Mastercard (10,000) Amex BCE (10,000) Amex EDP(15,000)
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.

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.