How to Use the Couponista Planning Spreadsheet – Video Included!

169 Flares Twitter 0 Facebook 30 Pin It Share 136 Google+ 3 StumbleUpon 0 169 Flares ×


Using the Couponista Planning Spreadsheet to help you plan your shopping trip can be a real time saver! Here’s a short tutorial on how to use this amazing tool. (Note: The Microsoft Excel spreadsheet download requires that you have Microsoft Excel 2007 or newer installed on to the device you are using.)

Screen Shot 2013-06-10 at 3.11.14 PM

  1. Enter the product name in the “Item” column.
  2. Enter the amount you would like to purchase in the “Qty” column.
  3. Enter the cost of the item in the “Sale Price” column.
  4. Enter the amount of coupons you will be using for the items(s) in the “MQ Qty” column.
  5. Enter the value of the coupon being used in the “MQ Value” column.
  6. If you are doubling the coupon, Enter a “Y” in the “Doubled?” column.
  7. If you will not be doubling the coupon, Enter an “N” in the “Doubled?” column.

Repeat these steps for each item you would like to purchase. The spreadsheet has built in formulas that will automatically calculate the “Sale Price” and the price “You Pay.” This is very helpful if your store requires you to have a minimum purchase before coupons.

Another feature in the spreadsheet is the ability to calculate your “Savings %.” This is done when you enter the “Shelf Price” value in the appropriate column.

Please check out this quick screencast on how easy it is to use the Couponista Planning Spreadsheet.


*This post may contain affiliate links. Please see my disclosure policy for more information.*

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

CommentLuv badge