Don't Miss a Single Deal!

Sign up to receive updates in your email!

June 30th, 2011
This post may contain affiliate links, see my disclosure

Coupon Savings Calculator

Update: You can get the NEW 2014 Coupon Savings Calculator here.

We are so lucky! Kelley Redmond created a coupon savings calculator just for Coupon Closet readers. If you have been curious how you are doing on your grocery bill, you don’t have to anymore. You will now know! It is a very simple calculator which will allow you to enter your shopping trips from up to 4 stores. On the main page, it will automatically give you all your totals from your 4 stores so you will always know how you are doing on your budget.

Go here to download the Coupon Closet’s Savings Calculator. You will need Microsoft Excel to use the program. If you are good at excel then you are ready to get started. I

would go ahead and get it downloaded. Save your receipts and stay tuned. Over this weekend, I make a video to help you use your new calculator. Once again, thank you Kelley for creating this awesome feature for Coupon Closet readers.



  • Amber M - June 30, 2011 @ 8:31 pm

    I just opened the calculator and it is AMAZING!!!!! Thanks Kelley for putting that together!!!

  • Liz - June 30, 2011 @ 9:19 pm

    THIS IS SO AWESOME! Much better system than me saving all my receipts in an overstuffed folder in my box. My favorite part is it does all my math for me. Thank you so much Kelly!

  • David - June 30, 2011 @ 9:56 pm

    Pretty cool spreadsheet. I put my receipts from last week in and it shows I had an 88% savings. Can’t wait to get a full months worth of data into it. How do you get rid of the picture in cell B13 on the store1 tab. It doesn’t affect anything but I can’t delete it.

  • Lauren - June 30, 2011 @ 10:04 pm

    Im having a hard time with this. When I click the link a window opens up that wants me to open or save the file. I have tried both and neither will let me pull it up. I cant even find it on the computer anywhere. What am I doing wrong? I have Microsoft Exel, so why cant I find this?! lol

  • Lauren - June 30, 2011 @ 10:07 pm

    Its saying that its a “zipped folder”, what does that mean?

  • Kerry - June 30, 2011 @ 10:32 pm

    I having trouble, too….lots of files with XML extention, but no excel files

  • Angie - July 01, 2011 @ 12:59 am

    I’m having trouble as well. I have Excel, I tried both saving the zipped file and just opening it rather than saving it. I can find it saved on my computer but everything I go to open takes me to an internet page full of codes and it doesn’t open to excel :(

    • Liz - July 01, 2011 @ 8:27 am

      What version of Excel do you have? Is it one of the older programs? I have 2010 and it downloaded it fine.

      • Lauren - July 01, 2011 @ 9:52 am

        I have im guessing the 2010 version. I bought my lap top from Best Buy last fall so im guessing its the 2010 version. I think I have Windows 7, but im not sure if that makes any difference.

  • Angie - July 01, 2011 @ 1:03 am

    I extracted the files…still not working. :(

  • John - July 01, 2011 @ 7:35 am

    The excel spreadsheet is in Excel 2007/2010 XLSX format. If you have Excel 2003 you will not be able open the file unless it is saved as an XLS file and reposted. BTW, Great Spreadsheet.

  • Lauren - July 01, 2011 @ 10:28 am

    Okay, I figured it out. The file is saved under the Desktop. Open your Exel program. Then go to “open” and select the “all files” from the drop down box on the bottom right hand corner. Then click on the desktop file on the left and inside there you will see the “zipped” file. Click on it to open it, then the warning will come up asking you to verify that the file isnt corrupt. Select “yes” and then it should open :) Hope that helps you! I didnt realise it was saving the actual zipped file under the desktop lol

    • Janette - July 01, 2011 @ 11:13 am

      This worked for me. Im not a computer whiz but i am pretty familar with excel and downloading and this was puzzling to me. Thanks for the help! :)

    • Rachel - August 14, 2011 @ 7:05 pm

      Thanks. I was not able to find it but with your help I figured it out. Thanks for the post. It was very helpful!!!!

    • Jayme - August 18, 2011 @ 2:54 pm

      You are a genius!! Thank you!Very helpful!!!

  • Angie - July 01, 2011 @ 11:42 am

    I have Office 07… Thanks Lauren! That worked by opening Excel first and doing it that way! Thanks so much!

  • Michelle - July 01, 2011 @ 12:55 pm

    Since there wasn’t enough sheets for all the stores I used, I tried to copy and paste one of the sheets to make a new one and it won’t let me. Is this possible or am I only stuck with using 4 stores on the excel file?

    Thanks so much!

  • Lyndsey - July 01, 2011 @ 9:57 pm


    Because of the way the spreadsheet is set up you won’t be able to add another store without a lot of hassle. The main page reflects totals for all your stores and adding another store would mess that up.

  • Kristen - July 05, 2011 @ 10:55 pm

    I just downloaded a second calculator to have more stores.

  • jessi - July 06, 2011 @ 5:09 pm

    I aslo just made a misc store tab….for store I don’t go to much. And I combined sams and aldi since either one of them don’t coupons. But my question is since its password protected is there any way to add a column, I would like to put misc info in it…But I do love it!!

  • Sarah - August 02, 2011 @ 7:02 pm

    When you total up your savings, do you put the total before or after taxes?? Always wondered about that.

  • Kimberly - August 11, 2011 @ 4:27 pm

    I have Excel 2003. Will I not be able to use this?

  • lindsay - August 14, 2011 @ 6:52 pm

    I have excel 2003 and it will not open on my computer:(

  • Stacy - August 15, 2011 @ 2:05 am

    Love Love Love It!!!!!!!!!!!!!

  • Melody - August 17, 2011 @ 11:20 pm

    Well, I tried opening Excel first and it didn’t recognize the file and imported junk like all over the screen. Is it possible for someone to covert the file from an .xlsx to a .xls file and repost it? If you have a later version of Excel, it would be super easy to convert it. I’d do iyt if I could. :-(

  • Kimberly Pennala - September 07, 2011 @ 9:39 pm

    I just downloaded the coupon calculator, but I’m confused on how the system works. Well the main one I’m having trouble with is the Homeland reciept I have. On the receipt here’s what it look likes:

    Fisher Bou Fish Fipc——4.49 B
    SC 7310 One Card Saving——2.24 -B

    So have do I know have much I actually paid for the product.

    They were also BOGO and I had a $0.75 coupon on top if it.

  • Nicole - September 12, 2011 @ 3:59 pm

    I downloaded the Zip file but it does not contain an excel document. I have excel on my computer and I use it everyday for work, but I can’t seem to get the calculator to open. I have a windows 7 operating system. Any suggestions?

  • SUSAN - October 17, 2011 @ 3:40 pm

    What can we do if we do not have excell? I have works.

  • Tamara Willis - November 03, 2011 @ 10:28 am

    Is it possible to have this e-mailed to me because I am not able to open it either :-(


  • Susan - November 28, 2011 @ 10:03 pm

    I can’t use it and I am an Excel user. It is protected so therefore I can not enter any information other than in three columns.
    And it looks like a wonderful sheet, but not useful to me at this time

  • tina - January 01, 2012 @ 12:23 am

    The coupon calculator is FABULOUS!!! Can you please post a 2012 calculator….:)

    • Carrie - January 01, 2012 @ 4:44 pm

      that is actually my plan to do today! ;) Well… tonight.

  • Zena Sue - January 29, 2012 @ 9:31 pm

    The Savings Calculator won’t calculate 2012 entries.

  • Priscila - February 02, 2012 @ 4:14 pm

    I had to use google chrome to download the file and then it work for me.

  • Amy - February 02, 2012 @ 9:04 pm

    Has the 2012 savings calculator been posted yet? I can’t seem to find it…

    • Betty - March 01, 2013 @ 7:53 am

      Yes I am interested in the 2012 calculator.

  • Sarah - December 16, 2013 @ 6:55 pm

    Is there anyway to change to year to 2014 so I can start using this again. I loved it when I used it in 2011 but I can’t change to date from year to year so I have stopped using it.

Leave a Comment

 Subscribe to My Newsletter