# Free Personal Finance Excel Spreadsheets

I use Excel spreadsheets extensively in managing my personal finances. Here’s a list of personal finance Excel spreadsheets available for download, as well as a description of each one. Go ahead and modify these as you see fit, so they work best for you. And remember, you can download, use, and distribute these personal finance spreadsheets, as long as they are distributed in their original form, and attributed to An Uncommon Way to Wealth.

- Biweekly Mortgage Calculator
- Mortgage Comparison Calculator
- Home Mortgage Refinance Calculator
- Mortgage Loan Calculator
- Grocery Price Book Spreadsheet
- Inventory spreadsheet
- Master Information Sheet
- Dead On Last Payment Calculator spreadsheet
- Debt Repayment Calculator
- Net Worth Wealth Spreadsheet
- Cup o’ Joe Factor calculator
- Millionaire Calculator
- Checkbook Balancer spreadsheet
- Car Maintenance Schedule Spreadsheet
- Home Maintenance Schedule Spreadsheet

If you have any suggestions for a spreadsheet you’d like to see, or if you’ve seen another useful spreadsheet somewhere else that you’d like to see with improved functionality (meaning more bells and whistles), please contact me.

{ 32 comments… read them below or add one }

I was looking for the downloadable grocery spread sheets – have they moved???

Just checking in to see how your coming on your Rule #1 investing spreadsheet?

Thanks

I am really impressed by this website and I am sure this website will get me through with my mastering microsoft excel.i will also learn alot other things that are really essential in putting microsoft excel in everyday use.i did manage using numsum zohosheet and Editgrid and now i will be trying my hand on this one.i have not yet tried some other microsoft excel online spreadsheet websites.i have been working on numsum for about a month and a half and about 6 months on zohosheet websites.I have also used the online spreadsheet Editgrid since april 2007 its been about 4 months using this website and now i have become really acquainted with this one also not just that i have submitted my daily spreadsheets from microsoft excel uploading to the website wasnt easy need to know the right path where the file is placed and then try uploading the same and then submitting it on online spreadsheet and then use share as public.now i will be using this to download spreadsheets and then mastering some more skills in excel.i have used some other excel websites as Numbler numsum zohosheet google spreadsheet and now even yahoo spreadsheet the company is sponsoring the entry into very complex spreadsheets and now more and more companies are putting their bit and then coming out with such ideas as online spreadsheets on the web.my company is Editgrid now days the office is in HK Hong Kong which is the best today and now they have started recognizing my work and displaying it as well.I will use this website to the fullest as much as I can and then get the grip of things as fast as I can in Excel.using such online spreadsheets I really can used to making my own spreadsheets really very fast and with no problems.I will be using the online method as a platform to reach the best I can.I want see me using Excel to its fullest potential.I want to see where all Excel has spread and where all its yet to be really understood.What better way is http://www.uncommonwaytowealth.com this website is the real platform to understand the true potential of Excel.This really has all those ingredients which a online spreadsheet website ought to have.I will use this more often now and use Editgrid.com the least as I have submitted them with all the spreadsheets I can.

BHAJAN PARTAP SINGH SEKHON

Thank you very much for sharing your spreadsheets. I truly appreciate it. I use the car maintenance one extensively!

hi i found really usefull the pricebook sheet. a suggestion i live in europe and if possible would it be possible to poduce a sheet with euro currency as it would be easier and more convient for europeans

thanks a lot for sharing your spreadsheets

I am really impressed wth the mastery of excel depicted in this site.I pray for more development in site.

Hello,

I’m trying to add the number from one cell in one column onto several cells in another column. The problem is the both numbers generate to the next cell. Exmp; Cell B5 is #5 and I want to add B5 to a series of Cells in another column. When I perform the drop down, the #5 adds up to the next number (#6, #7…) How would I elimanate the generation of the initial cell but allow the generation of the cells in the next colmn.

Thank you.

Alex.

Alex,

I’m having trouble picturing what you’re talking about. If you want to email me at (uncommon at uncommonwaytowealth dot com) with your spreadsheet, I’ll be glad to look at it – maybe it will make more sense then, and I can help you out.

Sean

hi,

im lookig for a spread sheet for cars service for a big company please help.

Thanks.

Mohd

allmedo_909@hotmail.com

0097339444128

Thank you for sharing your spreadsheets. I’m using the Checkbook Balancer one and it works nicely. One question though; why doesn’t it have a place to annotate what the check was for? I’ve been writing the information like the date and what the check was for in the checks portion and that works; so I guess it’s a cosmetic thing. Still, it’s a handy spreadsheet, thank you.

Dan

Hi,

I’m just getting started on your site but I must say it looks great! Wanted to let you know, though, that the link to ‘You Need A Budget’ links elsewhere with an error message.

Thanks so much for the time and effort put into these. Excellent!!

nice work, thanks alot

Hello:

I just downloaded the checkbook balancing software and the net-worth software.

I have reveiwed both. I think they are great.

I just wanted to thank you for offering these software downloads for free.

Thanks,

Bob

Having problems opening your spreadsheets. I keep getting a 4.04 error saying they cannot be found. Is there a problem?

I am just starting to use the grocery spreadsheet and am wondering if there is a way for me to sort the price sheet? It would make it a lot easier to shop for a product if I could see them together. Thanks for a great spreadsheet!!

ALEX:

I think i know what you are trying to accomplish. .

Try surrounding the number you want to calculate with “$” signs. . e.g. $B$4 instead of B4

This tells excel not to logically calculate the next avalible cell, but to keep this value fixed.

I hope I explained that well enough. Presuming you are asking what i think you were.

Anyways hope that helps

Hey I finishing up the Rule 1 book. I was just wondering if you were ever successful making the spreadsheet for rule one investing.

Hi this is what I’ve been looking for. I have always tried creating one myself but couldn’t or more like I am not IT-Savvy enough. lol. Thanks for the share!

I don’t think the Bi-Weekly calculator is correct. If I enter a $50,000 down payment on a $100,000 30 year mortgage at 6% it shows that I end up paying -$4,713.20 in interest.

Thanks, I also like using Excel Spreadsheets, first of all I do not have to buy a software which needs to be configured before using that takes almost the same time you will have to configure excel by writing formulas.

I think the use of spreadsheets can be very beneficial. Sometimes it helps to see the numbers in front of you. It makes your goals for saving or debt relief more tangible. It also makes you look at other angles to achieve the same result. You can see the big picture of your personal finances.

Have no suggestions, but want to thank you for Millionaire Calculator, it really helps me reduce my extra-payments.

http://www.uncommonwaytowealth.com/excel-finance-spreadsheets/

Thanks for the spreadsheets! I’m sure they will save a lot of time in the long run.

Definately would be interested in an Excel template for Rule #1 investing formulas.

Looks like Uncommon Way still doesn’t have a Rule #1 spreadsheet. I decided to make my own. I have both an Excel and Google version. Check it out: http://catholicinvestor.blogspot.com/2011/02/rule-1-analysis-spreadsheet-updated.html

Excel is a very powerful tool and I will be sharing your spreadsheets with our readers

If you work with sales reps or affiliates, following are several spreadsheets to help you calculate commissions – copy and paste into your browser to download (instructions on the third tab):

http://www.oneclickcommissions.com/commission-templates/sales-commission-template-revenue.xls

http://www.oneclickcommissions.com/commission-templates/sales-commission-template-fixed.xls

http://www.oneclickcommissions.com/commission-templates/sales-commission-template-margin.xls

These were designed to work with my company’s OneClick Commissions ( see website at http://www.oneclickcommissions.com/xd.html ) but can be used standalone as well.

OneClick Commissions takes commissions spreadsheets for all your reps or affiliates and quickly creates and emails out pdf commissions statements for each earner with just one click (after setup). Please check out service and templates. We will be posting more free templates over the next few months.

How can you change the currency to your local one? Thanks

How can you change the currency tab???

Just used the debt repayment calculator and it was exactly what I needed. I am definitely going to give the others a try, thanks for sharing these

{ 2 trackbacks }