October 18, 2005
New financial spreadsheets posted
I've uploaded a couple new handy financial spreadsheets over the past few days. You'll find these under the "Excel Finance Spreadsheets" tab at the top of any page. Featured in this first batch of spreadsheets are:
Master Information Sheet - this is a handy, central place to keep account numbers, payment addresses, telephone numbers, etc. for your credit cards, bank accounts, and monthly bills. Once you've put the info in here, you'll save time down the road when you have to report a card lost or stolen, or contact Customer Service.
Grocery Savings Spreadsheet - also known as a pricebook. Keep track of what you pay for groceries (or practically anything you buy on a regular basis), so you can determine the best price and best time to buy for each item. It allows you to input lists of categories for use in drop-down menus. Also, when you click on "Category", it automatically inserts the current date, which is a big help when you input a whole grocery receipt. Feel free to delete the "Sample" sheet when you learn how to use it.
Anyhow, these are free for download. Note that the Grocery Savings Spreadsheet needs macros enabled for full functionality (date insertion). If you don't enable macros, it will still have drop-down menu functionality.
Filed under Free Excel Templates, Personal Finance Tools by Sean

Comments on New financial spreadsheets posted »
I'm unable to access the Price Book spreadsheet. 404 error.
Your Master Info sheet will be useful for people smart enough to put it to use!
Thanks for the heads up about the Price Book. I forgot to upload it
It's always interesting to see how other people keep track of their finances. I'm a big fan of Excel and it simplicity.
Jim,
I'm a fan of Excel as well. The end-all goal for me w/ my Excel stuff is to make it easier, and easier, and easier - taking less and less time. I've seen far too many spreadsheets that leave me dizzy!
Thanks for these great tools, by the way!