New financial spreadsheets posted

by Sean on October 18, 2005

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.

{ 4 comments… read them below or add one }

Michael October 18, 2005 at 8:58 pm

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!


UncommonWay October 19, 2005 at 2:39 pm

Thanks for the heads up about the Price Book. I forgot to upload it :(


jim October 24, 2005 at 6:59 am

It’s always interesting to see how other people keep track of their finances. I’m a big fan of Excel and it simplicity.


Jesse October 29, 2005 at 12:08 pm

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!


Leave a Comment

Previous post:

Next post: