Here is the newest updated version of The Coupon Savings Tracker Spreadsheet!
This makes it easy for all of you super shoppers out there to keep track of how much you are saving and how much you are spending! When you get back from a shopping trip you can just go in and enter the information from your receipts. Then the program does the rest. It summarizes your total by yearly saved/spent as well as monthly! You can enter in your monthly budget on each page and it will tell you how much you have left to spend. I love it!!! The Coupon Savings Tracker Spreadsheet does all the work for you!
It’s FREE!
My amazingly wonderful accountant husband has once again updated the spreadsheet for this 2013 edition just for you my dear readers by adding more lines, more savings type options and more store items.
Features of the 2013 Coupon Savings Tracker:
- We have added more lines and more savings types and stores this year.
- You can customize your spreadsheet to reflect your VERY OWN Stores you shop at.
- You can view how much you have saved per “savings type” For example, you will be able to see exactly how much you have saved by coupons alone, or by catalina coupons. Plus you can customize the different types of savings you would like.
- Includes a Summary page which calculates your Yearly Savings, your Yearly Spending as well as breaks it down by Month. You can see how much you are spending/saving Per STORE as well.
- Features a handy drop-down list to add in your stores and savings types quickly.
- In – Page links for faster navigation.
- Budget Tracking each month to let you know how much you have left to spend.to reach your goal.
How Do You Use The Coupon Savings Tracker?
Here are my video tutorials to help you understand how to get your Savings Tracker all set up. Trust me, this will help you figure it all out. 🙂
*Very Important: make sure that the first time you set up this Coupon Savings Tracker you do it thoroughly as if you try to add stores or change things later it can mess up all your data.
Video for The Coupon Savings Tracker EXCEL Spreadsheet version
Video for The Coupon Savings Tracker OPEN OFFICE spreadsheet version.
To get this free download and start using it, download this spreadsheet to your computer. If you have Microsoft Excel – you will want to check which year you have and choose the appropriate year for your download. Choose to SAVE it to your computer. If you do not have Microsoft Excel I have also created a simple spreadsheet for Open Office that you can use. You can download the Open Office program for FREE here. The Open Office version of The Coupon Savings Tracker is a simpler spreadsheet but is still a great resource.
When you first open up the spreadsheet I would suggest you click on the “How To Start” tab and read the beginner instructions. I would also highly suggest watching the video tutorial for your version as this shows you step by step how the spreadsheet works.
Download the Coupon Savings Tracker
2013 The Coupon Savings Tracker(for Microsoft Excel 2010) *newest version!*
2012 The Coupon Savings Tracker (for Microsoft Excel 2003-2007)
2012 The Coupon Savings Tracker (for Open Office)
Also – 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 happymoneysaver.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.
About Karrie
Food is my love language. But so is saving money. So I like to combine the two a lot and make thrifty make ahead and freeze meals to save time. Because life is busy, and freezer meals can come to the rescue for all of us. And yes, they actually CAN taste good. Read more...
Comments & Reviews
Heather says
Hi. I have been using the spreadsheet, but just changed the name of the file (I think that was my mistake) and now it won’t update. Has anyone else had this problem? (it is still the macro-enabled type). I wanted to make two different spreadsheets (one for going out to eat savings). Thanks
leslie says
When you shop some place like Freddie’s, do you subtract the none grocery items (toys, clothes ext) before you put your info in the chart. I was thinking of using 1 chart for groceries and 1 for other things. If the chart can be download a second time.
What exactly do you list as groceries? Pet food, Tp, paper towels, soap etc are they totaled in the grocery bill?
Thanks for a great site.
Karrie says
Usually yes I will subtract the non-grocery household items from my totals. And yes you can download this a second time for another type of chart. I personally include toiletries like toothpaste, toilet paper and shampoos ect into my grocery budget – but not Pet Food. I am weird about my pet food (probably because I rarely get it cheap..ha ha and I don’t want it messing with my savings totals…) But I think you can do whatever you feel is best. Its up to you. Thanks for your great question!
Nancy says
I have having trouble doing the update, anyone else? I have 2007 Excel, and downloaded for this version, I entered some data, but no spending is feeding into the stores savings or Savings Type, Ugg, wanted to use this so much for my 2013 challenge with my group of couponers, its looks great even if I dont see my % on each screen. Thoughts Please, Thanks Nancy
Rebecca says
I downloaded your coupon tracker to help with my New Year’s resolution of spending less in general. I downloaded the Excel 2010 version in order to take advantage of the additional store and savings types options, but I’m using Excel 2007 to open it. Everything seems to work fine (I do have macros enabled) except that I don’t get a drop down list in the Store or Savings columns like you do in the video. It’s like it’s just a plain cell. Any thoughts?
Jess says
Thank your husband for another wonderful spreadsheet this year. I love it and loved to see my savings.
Karrie says
Thank you – so glad you like it!
Makenna says
Thank you so much, this is amazing. I love it. Last year I used this and saved $6,476 from coupon shopping. It was so fun to see thanks to this spreadsheet and your wonderful website. Thank you thank you thank you!!!!!!!
Karrie says
That is AMAZING Makenna! I am in awe at your savings!!! Congratulations for saving your family so much money. I hope you don’t mind but I am sharing this on facebook. 🙂
Melissa says
Thanks so much for this! Is there a version for 2008? Both versions I tried to download said something about macros. Maybe its a problem between mac and pc? I have a mac. Thanks!
Karrie says
Hi Melissa (and this is also for Kristin too) about the 2008 excel – looks like you two do have a mac as Microsoft Excel 2008 was for Mac.
Here is the information I found online:
Unfortunately Visual Basic for Applications (VBA) are NOT supported in Office 2008. This was by Microsoft’s design.
Why was it removed?
Microsoft says Office 2008 was built to be a universal application designed to run on the new Apple Intel processors. The Macintosh VBA compiler was originally designed to run on PPC-based Macs and will not work without serious modifications on the Intel Macs. The modifications would have pushed back the release date of Office 2008.
Options
Keep both Office 2004 and Office 2008. They can be run at the same time. Just make sure Office 2008 SP 1 has been installed first.
Stick with Office 2004, running it in Macintosh Rosetta on Intel-based Macs. However, files with the new “m” format (.docm, .xlsm, or pptm) won’t run and can’t be converted for Office 2004.
Learn AppleScript. Entourage 2004 has been working without macros since its existence. According to Microsoft, “virtually everything you can do in VBA, you can also do in AppleScript”.
Use a Windows machine.
If you have an Intel Macintosh, you can use BootCamp and open it in Windows XP.
Open it within a virtualization program like Parallels or VMWare’s Fusion. (Note: At this time, ITCS doesn’t support any of these virtual programs.)
Sorry – looks like it will not work for you unless you try some of the options listed above.
Amanda says
I really like this spreadsheet. The only suggestion that I have is that you add another set of Saving Type/Savings columns. For instance, I just bought diapers at CVS. They were on sale for $9.49 (reg. $11.99), I used a $3.00 coupon, AND I received ECB’s for $1.00. So, I really had three areas of saving, not just two. Thanks!!
Amanda
Karrie says
Thanks Amanda, I will see if my hubby can add another column the next time we do revisions. I really appreciate the feedback, there are so many ways to save it’s true.
Anne says
I was gonna suggest the same thing that Amanda did, but still wanted to let you know how greatful I am to you for sharing this spreadsheet. Thanks a bunch!!! 😉
kristin says
What do I do if I have Excel 2008. When I tried both the 2003-2007 and the 2010 it said something about macros being not supported.
Any clue?
Karrie says
Hello Kristin, I will look into this tomorrow and see what we can do.
Heather says
Thank you for creating this spreadsheet. I think it is basic enough that I will actually use it more than a month. I will share about it on my blog.
Karrie says
Thank you so very much! I am so glad you like it.