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! It is really easy to use as well; basically 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 and perfected the spreadsheet for this 2013 edition just for you my dear readers. We know how much you have all enjoyed the previous years of his savings spreadsheets, and this year has some amazing features.
Features of the 2013 Coupon Savings Tracker:
- 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.
- Plus more! PS – Have I told you lately how much I LOVE Spreadsheets? I do…I really really do. (example… My recent Toilet Paper Stock up Prices post).
How Do You Use The Coupon Savings Tracker?
I have prepared a few video tutorials this year to help you understand how to get your Savings Tracker all set up. Trust me, this will help you figure it all out. 🙂
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.
Enjoy keeping track of your savings and shopping trips!
Make sure and Subscribe or follow Happymoneysaver on Facebook or Twitter as well.
If you are new to Happy Money Saver, let me show you a few of my most popular articles and series:
- So I Married A Couponer – a fun story series about an average man trying to deal with being married to an extreme coupon shopper. His story must be told.
- How to Find the Best Deals on Toilet Paper – I worked my tail off to research that question…what is the BEST VALUE on toilet paper? I think you will like this!
- The Coupon Box Method – How I Organize my Coupons – Yep, I am a coupon shopper and this is how I organize!.
- Cold Lunches in a Day – I created a simple way for me to make sure my kids get a healthy cold lunch everyday – check it out.
Thanks again for using my Coupon Savings Tracker, I hope you enjoy it!
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
Bonnie H. says
HEY LADY! I just had to drop you a line, here at the end of 2022 and say that I STILL download a copy of this spreadsheet every New Years for the following year! If you ever need a guinea pig to try an updated one (not that it needs fixing! I love it so much!) Anyway, don’t know if you still read the comments on your old blog posts, but this is my favorite blog post hands down!
Ashley says
When I try opening the file in Google docs it says I am unable not compatible
Ashley says
nvm Thank you
Katelyn says
Thank you for providing the spread sheet! I can’t wait to start using it! I can’t figure out how to save it though – every time I try it says “not saved”. Any suggestions?
Thanks
Katelyn
Jayme says
Love this spreadsheet… then again I love all spreadsheets. 🙂 I wanted to let you know that I featured you spreadsheet on my website by linking back to this post. I hope some of my readers get some use out of it. Thanks!
Pam says
Karrie~I am wondering if there is a calculator that will calculate how much I will save by using the coupon before I actually go shopping or is that what your spreadsheet does and I just do not know it already~I must say I am new to this as of the past month, but I must say I love it already~ thanks Pam
Karrie says
This spreadsheet will calculate your savings after you get home and enter your reciepts.
Tracy @ usingtimewisely.com says
Karrie ~ I am currently using your 2012 version, but I have to use two trackers as there is not enough space for all the stores and options. I was just trying to get the newer version working but it seems that only the 2012 words with Excel 2007.
Tracy @ usingtimewisely.com says
Karrie, Thanks so much for posting this again this year. I used your tracker last year without a hitch, so I linked to it from my blog: http://www.usingtimewisely.com/planning-for-success-download-a-savings-tracker-day-10/.
In setting it up this year, I’m having difficulties. I went through your video and setup everything. However, no drop boxes appear for the stores that I entered through the list or for the savings types also entered through the list. I read through the comments and did not see anyone else having issues. I have deleted the prior downloads and retried with the same results. So, I tried on another computer with the same issue. I am using Excel 2007 and saving in a macro-enabled workbook, so I wonder if that could be an issue. If I don’t find a solution soon, I will use another tracker. However, I really liked yours last year and hope to get it working soon.
AMY says
THANK YOU!!!!!! i have been trying to find a way to do this all night long. i actually hand wrote all of the same info out on a piece of paper and did it manually. thank you for making my life soooo much easier.
Candi says
Hello, I love your spreadsheets..our you going to make your 2013 for the office.
I don’t have the other on my laptop. its old but it was free.
Karrie says
Yes, the 2013 one is in this post now. 🙂 Enjoy!
Candi says
It say’s it’s only for reading use only.. I’m using the free excel lib office.
Karrie says
If you get a read only notification just “save as” and rename it whatever you like and it should be fine.
Diane says
I was lucky enough to find out about your savings tracker at the beginning of the year and I have been using it regularly since. Thank you SO MUCH!! I am hoping you will share this again for next year. There is one feature I was wondering if you could add. Would it be possible to add a line on the YTD Summary page that shows how much I am over/under my monthly spending goal amount for the year? For example, some months I have been a little over (which I feel like is okay as long as I eventually average out), but have been working on getting my spending down, and now am spending less than my budget each month. Currently I am about $300 under budget in my total YTD spending, which I feel like I can think of as an additional $300 in savings for the year. I can calculate it myself, but it would be nice to have a place where I can easily see it and thought other users may benefit from it as well.
Thanks again for all you do!!
Robin says
This is an awesome tool, thank you so much for this!!! I love being able to see my savings add up. If I had anything to “complain” about (not really complaining, just would be a nice bonus) after the “total saved” column in each month, add a column for percentage saved for each trip, then on the summary page add a column for percentage saved per store. I have one store I go to that has the percent saved on the receipt. Thanks again.
Mel says
Hi Geekymom, I was wondering how to get around this too, but I found that when I added my own types of savings I added one that just says Savings – so I could calculate just my coupon savings in one and everything else in the other. Hope that makes sense. Maybe next year happymoneysaver can add more savings types per transaction along with more lines? Thank you so much for making this as amazing as it is though. I LOVE it.
GeekyMom says
I was wondering how you enter your receipts when you have 3 – 4 types of savings on one receipt?
Karrie says
Hello Zerilda, Yes, I have told my husband about this issue, and he plans on fixing that by adding a ton more lines for next years version. (I did try to get him to do it right now..but he is slammed at work and won’t have time for a few months. Sorry…)
Maybe try to use a calculator and add up a few transactions into one perhaps so you have more lines in the meantime? I know how it is when you have a TON of receipts and just don’t want to think about it and just type them all in quickly. Sorry there is not more room.
We will add more lines for next years version!
Zerilda says
I love your spreadsheet, it is helping me so much. But I just finished entering on line 50 for January and the month is not over. How do I add more lines or a second page for a month?
Thanks,
Jenny says
What do you do when you get to bottom of worksheet and you still have receipts to enter? Can you just keep going? I know if you right click and insert a row, it will NOT track that entry. Thanks for the help!
Sandra says
Karrie – how do you calculate your savings at Fred Meyer? Their receipts don’t breakdown the savings like sale price or rewards price or coupons. Do you have to write down every regular price when you’re shopping?
Aimi says
Wow! This spreadsheet looks great! Thank you so much for sharing it with us!! I was wondering if there are any plans on making one for Google Docs? I use both a couple different computers and it would be great to be able to open it on either one, as well as on my smart phone when I am on the go. Thanks again so much!!
Tammy says
I love this spreadsheet as well! Much better than the one I used last year. But like Court, I too like to break my drugstore trips into several small transactions. It’s easier for me to keep the deals straight. Can we add more rows for each month without messing up the formulas? Thank you!
Meara says
Thank you so much for providing this tracker! I am so excited to see what I’m saving – However, when I open up the document after downloadng I do not have any of the tabs…. just the summary page. Any suggestions?
Thanks so much !!!!