Reply
Established Contributor
Posts: 532
Registered: ‎11-25-2007
0

A helpful spreadsheet tool

Here is a spreadsheet I created the last couple of days to help me keep track of all of my pending payments to CC's and other ACH payments as well as Checks.  I just update the balance on my spreadsheet in my checking account and delete the payments that have cleared my bank account.  Then, if I schedule more payments, I add it to the spreadsheet.  Great tool to keep you from overdrafting because you forgot about a payment and doubled up.
 
This spreadsheet also keeps track of utilization for you and gives you FICO friendly tips and warnings.  I have 3 tabs at the bottom.  A Current, Last Statement, and Example sheet.  Yes, the example sheet actually has my CL's and pending payments, although I made up the number for my bank balance.  Nobody needs that info but me.  Just fill in the info on the Current tab, it will automatically copy to the Last Statement tab, except for the balance.  I use the Last statement tab to keep track of what balance reported at statement close.  Whatever you do, don't change the Utilizatinon field at all and only change the balance field on the At last statement tab.  Also, only print page 1 if you print.
 
Hope this helps everyone keep track of your finances.  Please give feedback if you find something I should add in or if there is an error you find.
 
FICO's: TU: 682 EX: 688 EQ: Unknown

In my wallet (strikethough are getting the axe soon): Amex Rewards Plus Gold | BECU: 10,000 | AlaskaUSA FCU: 6,900 | Citi Forward 6,500 | BOA Travel Rewards: 5,000 | US Bank Cash+: 5,000 | Merrick: 4,200 | Chase Freedom: 3,500 | Juniper: 3,100 | Household: 2,450 | Best Buy Reward Zone: 2,000 | Cap1: 1,500 | Cap1: 750 | Bailey's Furniture: 3,100 | Lowes: 4,500 | Care Credit: 2,000 | Zales: 1,400 | Kohls: 400 | Sam's: 5,200 | Walmart: 1,100 | Discover More: 1,000
Member
Posts: 7
Registered: ‎04-30-2008
0

Re: A helpful spreadsheet tool

Great job!

I do not need the spreadsheet to help me keep track of outstanding items (I write everything down in check register immediately) because I am an accountant and I used to work for bank of america as a manager for customer service my senior year of college, I am really OCD about keeping track of everything spent.

HOWEVER, I LOVE the utilization part and will utilize that in my own spreadsheet now that I use for my budgeting.

Thanks!
4/2/09 EX 696

7/16/08 EX 642

5/1/08 EX 617 EQ 620

http://ashflasunshine.blogspot.com/
Valued Member
Posts: 32
Registered: ‎03-11-2008
0

Re: A helpful spreadsheet tool

Thanks a bunch.  Just what I was praying for!  :smileywink:  I wanted a spreedsheet to better track my spending and expenses.  This will work great for me.
Established Contributor
Posts: 537
Registered: ‎04-02-2008
0

Re: A helpful spreadsheet tool

nice- I have a much more generic on! I think Im going to replace it. he he he he!
6/9/08 FICO TU 697 EX698 EQ 618uti 6% (once new accounts hit) BIZ- DUNS 80, EX 35
GOAL 2008- 700s+ new car
2010 BE a first time buyer
Valued Member
Posts: 45
Registered: ‎04-14-2008
0

Re: A helpful spreadsheet tool

Love the uti feature...thanks
Scores 9/2008: TU-720, EQ-695, EX-678
Scores 10/08/08: TU-721, EQ - 694, EX - 688
Established Contributor
Posts: 709
Registered: ‎04-20-2008
0

Re: A helpful spreadsheet tool

I like it but I have a request, could you also add an input for APR and calculate the interest being payed on it for the month, I know it often is calculated with adb, but could you calculate it with the balance entered just to give us a ball-park? 
"WTB Access Number"
Established Contributor
Posts: 532
Registered: ‎11-25-2007
0

Re: A helpful spreadsheet tool

[ Edited ]


fender wrote:
I like it but I have a request, could you also add an input for APR and calculate the interest being payed on it for the month, I know it often is calculated with adb, but could you calculate it with the balance entered just to give us a ball-park? 


Thanks for the feedback.  I hope to get more of it.  Yeah, APR and interest paid is one thing I didn't include because I didn't think it was relevent to tracking payments and balances.  And like you said, because most interest is calculated with ADB, it would not be accurate.  Excel is limited on what it can do as well, mainly because you can only have up to 7 nested functions and the total length allowed doesn't give me much room to do everything I want.  I think I am going to make another version, but a version that is based on your web browser, using an ActiveX controls and Javascript to store the data.  Everything will be done client-side, so nobody will see your information but you, just like the excel sheet.  So, everyone wanting a program to keep track of their payments and utilization in a neat, organized, informative, and FICO-friendly manner, look at the spreadsheet and tell me what you think and what else you think would be useful and I will attempt over the next few weeks to come up with a nice way to keep everything organized.
 
Fender, when I get home tonight, I will look into adding that column for you.  Because I wanted everything to fit on one printable page, I also omitted the APR information.


Message Edited by heirophant on 05-08-2008 02:42 PM
FICO's: TU: 682 EX: 688 EQ: Unknown

In my wallet (strikethough are getting the axe soon): Amex Rewards Plus Gold | BECU: 10,000 | AlaskaUSA FCU: 6,900 | Citi Forward 6,500 | BOA Travel Rewards: 5,000 | US Bank Cash+: 5,000 | Merrick: 4,200 | Chase Freedom: 3,500 | Juniper: 3,100 | Household: 2,450 | Best Buy Reward Zone: 2,000 | Cap1: 1,500 | Cap1: 750 | Bailey's Furniture: 3,100 | Lowes: 4,500 | Care Credit: 2,000 | Zales: 1,400 | Kohls: 400 | Sam's: 5,200 | Walmart: 1,100 | Discover More: 1,000
Established Contributor
Posts: 709
Registered: ‎04-20-2008
0

Re: A helpful spreadsheet tool

[ Edited ]
Im glad you appreciate feedback =P 
 
Also, showing the min. payment based off the normal 3% would be cool.. but not everyone will have 3% min. payment i suppose =/
 
I love the spreadsheet, expecially the If statements for your cards with balances, and uti %! Have you made any spreadsheets for budgets and such?


Message Edited by fender on 05-08-2008 02:50 PM
"WTB Access Number"
Established Contributor
Posts: 532
Registered: ‎11-25-2007
0

Re: A helpful spreadsheet tool

No, haven't got that organized yet.
FICO's: TU: 682 EX: 688 EQ: Unknown

In my wallet (strikethough are getting the axe soon): Amex Rewards Plus Gold | BECU: 10,000 | AlaskaUSA FCU: 6,900 | Citi Forward 6,500 | BOA Travel Rewards: 5,000 | US Bank Cash+: 5,000 | Merrick: 4,200 | Chase Freedom: 3,500 | Juniper: 3,100 | Household: 2,450 | Best Buy Reward Zone: 2,000 | Cap1: 1,500 | Cap1: 750 | Bailey's Furniture: 3,100 | Lowes: 4,500 | Care Credit: 2,000 | Zales: 1,400 | Kohls: 400 | Sam's: 5,200 | Walmart: 1,100 | Discover More: 1,000
Regular Contributor
Posts: 175
Registered: ‎04-01-2008
0

Re: A helpful spreadsheet tool

very well done... hmm  I'm going to use this but in the Pending Payment section im going to use company name as hyperlink to ebill site so i can click and pay :smileywink:
 
This is very useful tool and thanks :smileywink:
 
4/29/08 TU: 635 (2/1) EQ: 663 (1/1) EX: 652 (1/1)
6/07/08 TU: 688 (2/1) EQ: 672 (1/1) EX: 679 (1/1)
CA/CO
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.