cancel
Showing results for 
Search instead for 
Did you mean: 

Anyone willing to share their spreadsheet?

tag
MrProsperity
Established Member

Anyone willing to share their spreadsheet?

Many of you have posted about how helpful a spreadsheet has been in organizing your payments and progress - I am not very familiar with Excel and while I have the program, I don't know how to set something like this up. If anyone is comfortable PM-ing me and sharing something that they have developed, without any personal info, of course, I'd really appreciate it.
Message 1 of 7
6 REPLIES 6
Anonymous
Not applicable

Re: Anyone willing to share their spreadsheet?

Easiest way is to go into Excel and click on File, New. It opens up a new workbook window and there is an option for templates online. It will take you to the URL below then you can begin modifying the template to suit your needs. click on "download" and it will open up the template.
 
The Personal budget template is a good start.
 
Click on link below to go there directly
Message 2 of 7
Anonymous
Not applicable

Re: Anyone willing to share their spreadsheet?

There are also good programs available that you can download.  Quicken for example is really good and it will itemize everything for you etc,  I think it's like $30.   
Message 3 of 7
Anonymous
Not applicable

Re: Anyone willing to share their spreadsheet?

Ok so I'm at work and don't have access to a server where I can upload files so I used mediafire:
 
 
Download works, I tried it. I didn't use templates or any other programs because I like to mess around with Excel and this is the what has evolved over the last 6 months.  Here's is an explanation because my stuff is really convoluted.
 
I include the Company name because you never know how long down the line you're gonna look back and this and say "Who was my insurance company in 2007?" I include phone numbers and addresses because it keeps me from having to look at old bills to find this info when I know I normally need it.
 
I include Statement Date and Payment Due date. This is important to me because I try to almost PIF right before the statement date so that a low balance is reported. Also I had a bad experience with my auto loan where I paid my bill on May 20th even though it was due on May 31st. Well they said, any payments made before May 23rd apply just as if I had given a heftier payment in the previous month so guess what I had to do 7 days later. Pay my autoloan payment again. Not bad in the long run but not cool when its unexpected (hence the need for the sheet).
 
Typical Amount Due / Minimum Payment:
My water bill is usually $40 but it might be more or less so I have this field to at least acount for the fact that if nothing changed, I have to pay about $40 to the Water company. Same goes for credit cards, electrical, cell phones, CABLE! ... The total of this field gives me an idea of all the money that has to leave my wallet at the end of the month.
 
Once I find actual minimum payments, I fill that into the Minimum Payment / Amount Due field. All items that are red, remain that way until a statement tells me otherwise. Some times the electrical bill is due on the 27th and sometimes its due on the 23rd! Smiley Mad
 
And my favorite TOTAL PAID!
 
Notes are always fun and self explanatory.
 
My recent addition: CC repayment schedule
Pretty much allows you to look at all of your credit cards together and choose how much to pay to each based on rates, balances, utilization, etc. The key is to add up all of your bills minus the Revolving credit and see how much you have left over that can go to CCs and don't fill in the Total Pay Cell, it will add up all of your recommended CC payments (last column). Sort of to give you an idea of how much is going out in CCs so you don't go over your income.
 
The the "Total Paid toward revolving credit" adds up what you actually paid towards your cards. Last is notes...cause notes are fun...Smiley Very Happy
 
I KNOW THERE IS AN EASIER WAY TO DO THIS. But this is my way and I like it. All the info I'll ever need. I'm an engineer so simple is not in my vocabulary.
 
 
 
Message 4 of 7
MrProsperity
Established Member

Re: Anyone willing to share their spreadsheet?

Great, thank you so much to all of you, I appreciate your help and wisdom. I am learning so much here and am blown away by everyone's generosity. I definitely have enough information to figure out something that will make sense for us. Thanks again.
Message 5 of 7
MrProsperity
Established Member

Re: Anyone willing to share their spreadsheet?

Berraco58, just checked out your spreadsheet. You rule. Thanks again.
Message 6 of 7
Anonymous
Not applicable

Re: Anyone willing to share their spreadsheet?

Thank you. I tell my girlfriend, the only way I can miss a payment on any bill is if I meant to do it.
Message 7 of 7
Advertiser Disclosure: The offers that appear on this site are from third party advertisers from whom FICO receives compensation.