Coupons 101: Keeping track of it all-coupons

So I hope you are all enjoying the world of coupons so far. Are you keeping track of how much you are saving? You should! It is so fun to watch how much you save go up and up as you coupon more. When I first started I saved about 34%, but now I regularly save 50-60%(or more) every time I shop. How do I keep track of this? My husband helped me create some great forms in excel and I am going to share them with you. This lesson I will share my coupon sorter. In my next lesson I will share my budget/coupon savings sheet.

My Coupon Sorter
To understand how to use this sorter, watch the video on this lesson here.

• #-the acutal number I put on the coupon
• Product-what the coupon is, I like to put the product name and then what it is specifically, example Colgate-toothbrush or I might have Colgate-toothpaste
• Expiration Date-date coupon expires
  
• Amount-if it is off 1 item, I just put the amount, off of two, I put .50/2 for example
• No Doubling-I just make a x in this column if it says do not double
• Store-I write the name of the store in this column if it is a store specific coupon, like Target
• Quantity-how many I have of that EXACT coupon
  

I love this sorter because of all the great features my husband put in. If you click on any of the arrows at the top of the column, example shown below, you can sort your entire chart how you would like.

Here is the window that pops up if you pick Custom Filter from the arrow. I then pick the less than or equal to and put in a date, this time 5/31/9. After saying OK; my spreadsheet will then show me all of the coupons that expire on or before 5/31. I can then take them out of my coupon box and after I am done with that, I then delete those entries from my spread sheet.

This sorting is also great with the product, as a pull down list will appear so I can show just my coupons that have the word Pillsbury for example.

You can also do multiple filters at a time, I could pick a expiration date filter and then pick a certain product. If you have questions about how to use this please leave a comment and I will do my best to help you out.

If you would like this sheet you can download it here.

DOWNLOAD FILE

All of the extras are set up, all you have to do is start entering your coupons and enjoy!