I love to see how much smart shopping and a fistful of coupons saves me! Here is what I use to keep track of everything. My Savings & Shopping Tracker program was created by my amazingly wonderful accountant husband and I love it!! His excel skills never cease to amaze me.
I wanted this Savings & Shopping Tracker to be easy to use. Basically when you get back from a shopping trip you can just go in and enter the info from your reciepts. Then the program does the rest. It summarizes your total by yearly saved/spent as well as monthly! You can enter in a budget on each page and it will tell you how much you have left to spend. I love it!!! The program does all the work for you!
To get this free download and get to using it, download and save a copy of this spreadsheet to your computer. Then, open the Summary tab at the bottom of the program. This is where you can see all your year-to-date savings and spending totals! The only thing you will need to change on there is your monthly spending goal. Click on the $200 I have in there now and put your own monthly spending goal in.
Next, click on the current months tab at the bottom of the program (example January) and it will take you to the page where you can enter your reciepts information every time you shop. Once again you can change your monthly spending goal by clicking on that area at the top and changing the amount.
The information you will need to enter every time you get back from shopping is :
Date: just type it in the empty space under date column.This is optional of course.
Your savings: Look at your reciepts and enter in coupon savings, any club card or sale price savings and any rebates that you will be submitting for.
Total Spent: Enter how much you spent
And thats it! The program will calculate everything else! Do not enter the amount saved as the program will not allow you to. It totals how much you saved by adding up your savings from your receipt. (if you accidently click it and see strange numbers just hit escape.)
Enjoy keeping track of your savings and shopping! Each of those stores on there are easy to change. If you dont have one of those stores in your area just click on the little picture and delete it. Then change the store name for every month and on the summary page.
Note about this My Savings & Shopping Tracker: this spreadsheet download is for personal use only. It is not intended to be used for monetary gain in any way and is copyright by fistfulofcoupons.com. If you are a blogger and want to share it with your readers that is wonderful (thank you!)..but I would prefer that you link to this post directly and not place my Savings & Shopper Tracker on your websites/blogs for download.
Thanks so much and enjoy!