Using Excel Spreadsheets To Track Your Finances
15 September 2006I ran across a nice web page with a set of spreadsheets, pre-made, for Excel, a program that many people have through Microsoft Office. There are quite a few of them there, and they have a lot of detail - lots of instructions and explanations of what is going on, and all you really have to do is fill in the blanks. There are spreadsheets there for a number of different financial situations, such as:
The Debt Tracker Spreadsheet - For those people whose main financial goal is to become debt-free, this one’s for you. You just plug in your debts and info and it will show you some analysis of your debt-to-income ratio, keep track of how much you’re paying in interest, and summarize your situation. You have to enter in any changes, of course, but it’s a good way to keep track of everything neatly as you’re paying off your debts.
The Net Worth Calculator - A spreadsheet that helps you come up with a balance sheet for yourself - just enter in your assets.
The Autobilling Chart - This one helps you keep track of which cards are automatically paying which bills (important if you’re planning on closing down some of your credit cards over time).
Spending Plan Spreadsheet - It’s just a budget that is very easy for you to do by plugging in the numbers.
There are quite a few more on that page, so if you’ve got Excel, go take a visit, even if you don’t really know how to use it. Putting data into a spreadsheet is a lot easier than making one, and using these isn’t hard at all. They’re a great way for the organizationally impaired to keep track of financial information.
Discuss this in the Free the Drones Forums.
No comments yet