Posted: March 15, 2017
29

Part of the ABC’s of Couponing Guide

How to KeepTrack of Your

 

ABC’s of Couponing “K” is for “Keeping Track of Savings”

Have you ever had problems keeping track of how much you save and spend with coupons?  I just got this spreadsheet from a reader and I thought I’d pass it on to you; here’s what she had to say:

Hi Deidre, I am new to couponing and was a little confused on how everyone kept deals, Wag coupons, RR’s, Manf coupons, rebates, savings, etc straight so I came up with a spreadsheet that breaks everything down in a simple and easy to understand excel spreadsheet, it even has a total of amount saved at the bottom. The 1st tab shows a list of deals I found, the 2nd shows how I entered in everything, and the last is a blank form to use. On mine I just keep adding more tabs at the bottom for each week I shop, that way I can go back and look thru if I have a ? or problem. I would love to send it to you so you might be able to post for other newbie’s. I might not be good at couponing (still learning) but I am good with spreadsheets. All I know is it really helped me understand how everyone came up with them.

Thanks Beth for this spreadsheet! Download the Sample Coupon Calculator here for free. It works in excel.

Also, Jessica emailed me yet another grocery-savings-tracker Saving Tracker for free, also works in excel.
Here’s the info Jessica passed onto me on how she uses her grocery savings tracker:

  1. Add the amount spent for all receipts
  2. Add the total amount saved (usually at the bottom of all receipts)
  3. Add Total Spent and Total Saved together to get the total Value
  4. Divide Total Saved by the Total Value, X (multiply) that by 100 = percentage saved each week!

Please leave a comment letting me know how you keep track of your savings.  If you are new to couponing, please read my coupon training guide!

Tags: , , , ,
Sponsored Links
  • Jessica

    Deidre, I have another one I use that is completely different, do you want to add it to your list? It’s free as well. let me know! jessica345@gmail.com

    • deidre

      Yes that’s great! I just emailed you…

  • Trisha

    Going to do three spreadsheets- one for retail stores and one for drugstores and one for grocery stores. Thanks!

  • Damien B

    I actually very quickly made a separate page for each store I shop at – just copied and pasted into a new tab.

    • Cory

      I’m thinking of doing that, it just might be too overwhelming!

    • Shar

      That is a good idea.

  • Mommy B

    Thank you for this! One of my goals for 2011 is to write down EVERYTHING!!!!

  • Oanh B

    Thank you…this is such a great tool!

  • Shar

    I did this for awhile but didn’t keep it up. Seeing how much money I saved was fun.

  • Renee

    Thanks!! These will come in handy. I’ve had the same questions.

  • Tonya James

    Thanks for all the info and your hard work! I love CCD!

  • Nicole

    I made an excel sheet and love seeing how much i save every month

  • Danielle

    I will have to try this. I am also new to couponing and get the number side of thing easier thanks for the posting.

  • Shanna Bailes

    I will try this…..Thanks!

  • Marisol

    I don’t have Excel … have you tried making them on Google Spreadsheets?
    This way those that don’t use Windows or just have older PC’s might benefit from your wisdom and creativity?
    😀

  • Debbie

    I couldn’t get either of these spreadsheet samples to open, am i doing something wrong? it says that it needs to know what program created the xls file? don’t know what that means but i would soooooo love to have these samples to help me learn how to “track” my savings, i am not good with the math lol any one who can help me?

    • deidre

      do you have excell? I think you have to have it to open it

      • Debbie

        i don’t have excel, would it be possible for some one to scan a blank page and email it to me so i can make copies of it? I really could use that spreadsheet, but really really can’t afford to buy excel for my computer. lol I can’t even by food right now, which is why I am beginning to learn the coupon method of saving, so i can at least provide a little food for my husband and I

        • Jay

          Debbie, download excel from office.org it is free,, you maybe able to pull it up that way… worth a shot. good luck!!

        • Audrey Stewart

          office.org is free works on windows and my older comp works for me do there and download

  • Catrina

    Thank you :)

  • Beverly

    You can download excel for free, just type in free spreadsheets and look for openoffice.org and you can install it for free. Hope this helps everyone.

  • Shyla Conrad

    Has anyone ever tried aislebyaisle.com I just came across the website today and was going to explore it further. It seems like it’s a great tracking and shopping tool.

  • Tracy

    Very new to this and want to “Thank you” for all your tips. I’m overwhelmed, however I’m going to try.

  • p90x pull up bar

    Great post. I used to be checking constantly this weblog and I am impressed! Very useful information particularly the remaining section :) I maintain such information a lot. I used to be seeking this particular information for a long time. Thank you and good luck.

  • free stuff by mail

    I feel this is one of the most significant information for me. And i’m happy studying your article. But wanna statement on few basic issues, The web site style is great, the articles is actually nice : D. Excellent activity, cheers

  • J.

    Does anyone know if there is an app for the iphone that you can transfer your excel file to and have a working copy on the iphone? I have found one that will transfer the file, but you cannot edit it on the iphone. Thank you!

    • Elizarae

      You can use Google Drive. Just set it so that when it uploads Excel files, it will convert it to a Google Spreadsheet that you can edit on your phone and on your computer.

    • T.V

      I use Kingsoft

Recent Comments
Recent Comments