Many of you have been asking me for some time now how I organized my store transactions when I started “Extreme Couponing.” Well I have finally uploaded the Excel spreadsheet called the Transaction Calculator that I used.

• Enter detailed information for each product:
  • Store Promos such as BOGOs
  • Manufacturer Coupons
  • Double or Triple Coupon calculations
  • Store Coupons
  • Catalinas
  • Rebates
• Calculate total Out of Pocket Expenses.
• Calculate the cost per item.
• Calculate the % of Savings per transaction.

Here are some directions:

• All areas in light orange are editable fields.
• You can simple copy & paste the Total column into the following rows.
• To calculate % of store savings add the total Catalina + Rebate offers to your receipts total savings amount and enter in the Store Savings field.
• COST is the final cost of the transaction after all discounts including Catalinas & Rebates.

When I started “Extreme Couponing”, I would complete and print this worksheet, then gather all the coupons needed and take it all with me to the store and it made it much easier to checkout! I have put in an example transaction that I actually did last week at Meijer, see the receipt below. (For some reason I got and additional $0.50 coupon added to the receipt so I just entered it in the Store Coupon column on the Iams dog food row.)