2013 Coupon Savings Tracker Spreadsheet

 

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:

Thanks again for using my Coupon Savings Tracker, I hope you enjoy it!67 Comments

Subscribe and never miss a thing!

Receive free email updates

PAID ENDORSEMENT DISCLOSURE: In order for me to support my blogging activities, I may receive monetary compensation or other types of remuneration for my endorsement, recommendation, testimonial and/or link to any products or services from this blog.

Comments

  1. I used the savings tracker religiously after every trip from January 1st until now. It has helped me keep track of my budget so much! I love it as I too love spreadsheets. So far this year I’ve saved $6800 combining coupons and sales. Thank you so much!

    • Mandi, that is so awesome! $6800 – wow, that is a lot of savings. So happy you like this tracker.

      • I just saw that you replied! I was going to tell you that I wish I would’ve had some sort of tracker in years past. I could’ve added up all the savings from every one of my 12 years (I started when I was 18) of couponing! That would’ve been impressive.

  2. Thank you so much for providing this! I was laid off from my teaching position and we are are now on a much stricter budget-this is perfect for helping me track my expenses. Thanks!

  3. AWESOME! Thank you!

  4. Great job on the tracker. We are spending about $200 dollars a month to feed 5 people 3 meals a day without eating out. With spending $200 a month we have created a stockpile of toiletries and paper products and some canned goods. Thanks.

  5. Thanks for posting and sharing this, I will pass it along!!

  6. Thank you for the spread sheet. I download open office and it only will let me do it in read me–so I am unablle to change any anything. I have never used a spread sheet. Can you offer any help? Thanks

  7. Thanks so much for making a version for Open Office! I have a Linux box right now and sometimes have issues with other freebies because they are most often only for Microsoft compatible products.

  8. you are welcome! Have fun keeping track of all your savings :)

  9. Thank you so much for this! I made my own last year but it was not nearly as great as yuors! Is there a way to ad more store names and savings types? I already reached my limit and can’t seem to add more :(

    • Hi Chrissy, So glad you like the tracker. Unfortunately there are just the 15 stores you can add, and the 5 savings types. You could maybe combine certain ones into one like *Restaurants* ore *Retail Stores* if you were including those. When the next year edition comes out I will see if my hubby can add more stores to the list. :)

  10. I would also like to add more stores.

  11. The Store Savings and Spending part of the spreadsheet under the YTD tab does not work. I have downloaded several times to see if that was the problem, and it is not calculating my savings. The Savings by Type is also not working.

  12. Hi Ashlee, did you hit CTRL + U to update it? Make sure and do that, it is working for me fine.

  13. Also, if you havent already, make sure you watched my video tutorial to learn how to use it. :)

  14. I love this! I shared this on my website http://www.stretchingmydollar.com/ for my readers to use. I hope you don’t mind. Please thank your husband for me!

  15. im sorry.. but none of the percentages or totals are making any sense when i enter them.. Am i reading this chart wrong? I have another excel that is similar and everything is adding up correctly.

    i added in 2 stores and what i paid at them under january.. in every month from then on to dec of 2012, the excel sheet is stating money SPENT. how is this possible, when i clearly have not entered ANY information into those months?

    also – spending $50 and saving $50 does not equal a percentage saved of 83% as the excel sheet is calculating. It should most def. be a 50% savings.

    • Hi Michelle,

      The percentages on the summary page are referring to the percentage you spent per store. It is not calculating the amount of money you saved. The reason for this is people wanted to see WHERE and which store they were spending their money.
      The point of the percentages is to track WHERE you are spending the money, not the percentage of actual savings.

      Perhaps in the next version I will have my husband include a percentage of savings for each shopping trip if you want it, just let me know. I always like feedback to improve.

      As per the Average Monthly Savings and Average Monthly Spent totals, there are numbers in each month because it is accumulative average. Basically if you were to stop shopping today it shows you your average for the entire year for 2012 . So once you finish up the first two months it will show you how much you are averaging over the first two months as well as the entire year.

      Hope this helps!

  16. Hi Karrie ,
    Thank you so Much for the spread sheet. I am a newbie couponer and I love the spreadsheet.

    I am trying to change to store names from store1 to Babies r us in the summary tab and it is letting me rename it . (But it won’t work because I am seeing N/A) next to it.
    Is there a way I can rename the store names ? I hit Control U and did n’t worked.

    Thank you,
    Sherry

    • Make sure and not hit delete in that spot, and just select it and backspace. If you deleted it might delete the formula as well, which means you would need to redownload the program to your computer and start over if you wanted to use that one. Good luck!

  17. I started couponing last week and my very first shopping trip was yesterday. Your spread sheet is an amazing tool that is a great way for me to track my savings so i can prove to my husband that this hobby is absolutely worth while especially since we have a 3 month old. in my first trip i already saved $48.71 and i figured that our from your spread sheet :-) I also shared it with two of my couponing co workers. This tool is GREAT! thanks so much!

  18. LOVE IT !!!! You and your hubby ROCK!!! I started couponing this past summer. I knew I was saving money but didn’t really have a tool to track it. I’m such an excel tracking geek :) This just made my day. We started our Dave Ramsey budget January 1st and this is another great tool to track our spending and also see the REWARD in using coupons. Plus I have a good friends husband always tease me about my couponing. I’m going to LOVE showing him what I save each month or all year with this handy spreadsheet. :)
    THANKS SO MUCH.

    One question…how do you track when you get a store gift card for buying a certain item? Ex. I went to Target bought 3 kids vitamins. I used $3.00 in Manufacturing coupons and when I bought 3 I got a $5.00 gift card to Target. Do you track the $5.00 on this purchase or when I use the gift card? I hope I didn’t confuse you…but since CVS and Target run these type of deals I would love to track how many gift cards we get and how much it saves us.

  19. If you want you could add a savings type that says “Gift Cards” if you have room to. Then when you actually redeem them you will count that as the savings then. But really its up to you to do it however you want to! :) But I personally like to track RR, +UP Rewards and Gift Cards when they are being redeemed as a savings type.

  20. Thanks for this tracker. I was wondering if there is any way too add more than 50 lines ? Currently it only allows for 50 and I’m already up to 29 for the month. I’m not spending as lot but I break my drugstore transactions up and tend to have a lot to track

  21. 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 !!!!

  22. 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!

  23. 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!!

  24. 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?

  25. 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!

  26. 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,

  27. 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!

  28. I was wondering how you enter your receipts when you have 3 – 4 types of savings on one receipt?

  29. 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.

  30. 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.

  31. 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!!

  32. Love this tool, thanks. One addition/modification I would make is allowing more than two savings types per transaction on the monthly pages. As I just went to enter my first receipt from Rite Aid I had sale savings, manufacturer coupons, and Up Rewards that I wanted to enter. I can couple the coupons/UPR or omit the save savings, but thought it would be good to see all three, especially on the yearly summary. While I can enter another column, I am not sure that is the only step required, and, unfortunately, I am not excel saavy enough to figure it out. It’s a great start, though, thanks again.

  33. 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.

  34. 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.

  35. 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.

  36. 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.

  37. 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

  38. 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!

  39. 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

Speak Your Mind

*

Follow me over to the blog for more homemade goodness . . .