Friday, January 01, 2010

2010 Savings Tracker

Many of you have asked for a way to track your savings in 2010.  I use a spreadsheet that I found on a coupon site that is no longer maintained.  It is very overwhelming at first to look at, but it is very simple.  All you need to do is plug in how much spent and how much you saved for the week and it does everything else for you.  (Just mess with the boxes that are green).

Click here to download. (It’s in an Excel spreadsheet, you can also open it in OpenOffice).



For those of you that aren’t spread sheet or math folks here’s how to quickly calculate your savings each week:
1.  Add together the amount that you spent for all receipts
2.  Add together the total amount saved (usually at the bottom of all receipts)
3.  Add Total Spent and Total Saved together to get the total Value
4.  Divide Total Saved by the Total Value, multiply that by 100.
You have the percentage saved for the week!

No comments: