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


Established Contributor
Posts: 560
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: 185
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 7.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 Double Cash 3.2K. I CarCareOne 2.4K. I Best Buy 8.5K. I Care Credit 10K. I Capital One (Credit Steps) Platinum 3.7K. I Roamans $2100 I Chevron Visa 2300 I Capitalone Venture 10K I Citi ThankYou 2100 I Macys 1000.

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

Established Contributor
Posts: 560
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: 901
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

Current Score:EQ-748 TU-762 EX-754 Cards:Lowes-25,000 AmexEDP-15,000 Discover iT-11,600 AmexBCE-10,000 JCP Mastercard-10,000 Macys Amex-8,000 Sapphire-6,000 Belk-5,500 Barclay World Arrival-5,400 Simplicity-5,100 Home Depot-4,500 Slate-3,500 Freedom-3,000 BestBuy-3,000 Macys-2,500
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 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.

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.