When you’re new to Super-Couponing, many people enjoy keeping track of just how much money they’ve saved with coupons. I did this my first year — and not counting the sales cycles lows (the differences in price between regular and sale) – ONLY counting coupon savings — I saved over $5400 the first year! I’ve since stopped keeping track in such a detailed form, but I’ll never forget how exciting it was to note that kind of savings in a year’s time.
Many of my blog readers want to keep track of their coupon savings too. Forum member Prea posted this Spreadsheet of Savings. It’s an Excel spredsheet that allows you to enter the coupons and prices of what you’ve purchased to calculate your total savings.
Here’s a note from Prea on how to use the spreadsheet:
This is the spreadsheet I use to track my savings. The first four rows have been filled in. Do not clear these rows — simply type your figures over the top of mine. (Others have told me there is a calculation problem if you clear the sheet before starting.)
I did not originally create this sheet, and I do not recall which web site I originally found it on; therefore I am unable to give credit where it is due. I have made many changes to it though, and it’s what works for me. I hope it works for you as well.
For my savings, I created 5 sheets from the template sheet, one for each store I shop at. Other couponers have found it more beneficial to keep all the stores on one sheet.
Enjoy, & a big thanks to Prea for sharing this!
Stars says
Awesome…..Thanks for sharing this with all of us. It will become a very handy tool.
couponvanalek says
I’ve adapted this spreadsheet to work for me. My husband made me a deal that I get to “keep what I save” – I don’t think he or I had any idea how much that could be!! I needed to put in a column for “subtractions” where I spend my savings…
ohanlon2 says
Everytime I enter the date into the spreadsheet and tab over to next column to put in spent $’s and tab over the spent @$’s comes out: 01/01/09 ( something like that) and column 24 does not continue the addition from line 22. I hope that makes sence.
brianna928 says
so, i just found this spreadsheet today and am so glad because i’ve been so curious to see how much i’ve been spending and saving and on average what we’re spending a month. took me quite a while to input each receipt but well worth the wait for the excitement of knowing what my totals now are.
i started couponing last november and i know i don’t have every single receipt from then til now but i entered 174 receipts starting from mid november up til today (9/10/09)and here were my #’s:
$5978.28 =total value
$4964.34 =total saved
$1013.94 =total OOP
total 83% saved
I’m very pleased and like I said these were all the receipts that I had but even if I spent an extra $1000 OOP from my missing receipts that would =$2000 OOP that only averages out to $200 a month over the last 10 months……when once upon a time our budget was around $600 a month for groceries!!
the most amazing thing about all of this tho is that not only am I able to provide for my family but am also able to give to our church’s food pantry give to my neighbors and to my other family members…..i’ve never been able to do that and here I am with over flow to give to others yet spending tons less than ever before!!!
God is good!
hoppmom says
I am EXCITED to say I bought the DVD about two months ago and was amazed as everyone else has stated at the amount of money I have been giving away. My co-workers and I had a coupon DVD party to start our couponing experience off in a wonderful way. We share coupons and help each other find deals for each family.
I started to use the spreadsheet 7 weeks ago and although I know by looking at the reciept and the HUGE amount of food overflowing from my cabinets and freezer that I am saving money. When I plug my purchases into the spreadsheet I am happy NO that is not the word but anyway I am now saving 44%. Not bad for a two month rookie. I am looking forward to learning more tricks and getting up to the 80% mark or better in the next year.
My co-workers and I share our endevors and encourage the process.
THANK YOU !!!! I spent about the same in the two months YET got about 2-3 times more food and household supplies and beauty products. It is also nice to have my oldest child, who just moved out to “shop”at Mom’s when he comes for a visit…
crayola5 says
OMG, I am so excited I found this excel spreadsheet on your website. I have not even seen one of your talks yet, I plan to in December. I use to coupon 10 years ago and I was pretty good, but it took soooo much time, that I slowly just stopped. My girlfriend told me about your site and it is like night and day, from the way I use to do it. You and the other sites pretty much do all the work. This week alone, remember without even seeing your talk. I spent $132.22 and saved $96.44 just this week alone. I cannot even image what will happen after I listen to you in the next couple of weeks. I went to Walgreens, Jewel and Meijers to save this money. I told my husband I wanted to track it and I didn’t know how I would do that. Thank’s to this spreedsheet, I am now set.
soapboxtray says
I put in my first 6 receipts for the year and excited with the savings I have already. Started in October of 09 but it has taken me from that point to learn the process and just making lots of mistakes and learning. Very grateful for this blog, the people that post on here are so very helpful and now finding this spreadsheet so I can prove to my family that my new obsession is really a good thing :-) and not just a closet full of shaving cream he he he. Like the other poster said, I too am giving so much more to charities, my church and food pantry it is very helpful and it is fun and rewarding too!
twiceblessedchinamom says
When I began, I kept reading experienced Super Couponers say that we shouldn’t expect their percentages of savings, and I thought, “Why not?” I was frustrated that my savings were absolutely not the same amount as the Coupon Queens. Through time, and especially when I began helping friends, recently, I explained there is a very big reason that their percentages saved can’t be as high as mine are at this time. I’ve accumulated our stockpile. We have everything that we need, and I only go to the store for promotions where I can save an incredible amount of money. I stop in for fresh fruit and milk, but only purchase other items when it is free or almost free. So, while you accumulate your stockpile, know that you’re doing a great job of savings, and once your stockpile is established, your savings will be even greater.
Love the new blog, Jill! Thanks so much for all the ways that you help my family!
Jeana
jenjen348 says
I know this has been answered before…I swear I read it somewhere and after 30 minutes of searching I cannot find it. Do you enter in your RRs into the savings column as you receive them or as you spend them? Example, I did the Dove deal today (twice =) ) and I used $1 coupon on the first transaction. So shouldn’t somehow the spreadsheet show OOP= 5.14 (4.99 + tax), Savings=$7…but then how does it show you that you got an item as a money maker?
Like I said, I am sorry this is a repeat…I KNOW I saw this somewhere. Let me know what you guys tend to do :)
Thanks!
lisapatrone says
So.. does anyone have a link to the free program to open this?
jaz60014 says
Can anyone walk me thru how to open this spreadsheet. I have Microsoft Excel.
Thanks!
rascal says
Where can I find your monthly items in the 12 week schedule?
suzq37 says
Thank you very much!