April 17, 2014

FREE Grocery Spending and Coupon Savings Spreadsheet

Jan 4, 2014

FREE spreadsheet to track coupon savings and grocery spending! So easy to use and it's exactly what I've been looking for!

One very important part of couponing is tracking how much you are spending and saving. Hopefully you have a general idea of how much you spent on groceries pre-couponing, but even if you don’t, tracking your spending can be extremely beneficial. Right now is always the best time to start keeping track!

I have created this awesome and SIMPLE spreadsheet to use to track your grocery spending and savings! All you have to enter is how much you spend and save each week (most stores will calculate your savings for you at the bottom of the receipt!) and the spreadsheet will calculate the percentages for you!

How to use the Grocery Savings Spreadsheet:

First of all, in order to be able to use the spreadsheet, you need to download it to your computer or save to your Google Docs account.

Save to your computer:

1.  Open the spreadsheet in Google Docs

2.  Click on “File”

3.  Go to “Download As”

4.  Choose the program you would like to download it to.

Save to your Google Docs (Google Drive) account: (I personally like Google Docs because I don’t have to worry about losing my data if my computer crashes.)

1.  Sign in to Google Docs (it is very easy to register)

2.  Open the spreadsheet in Google Docs

3.  Click on “File”

4.  Click on “Make a Copy” (this is a VERY important step)

5.  Name and Save it

FREE spreadsheet to track coupon savings and grocery spending! So easy to use and it's exactly what I've been looking for!

Now that you have your copy of the spreadsheet, here is how you use it.

You need to save your receipts every time you buy groceries. Either input them in the spreadsheet as soon as you get home, or put them somewhere you will remember and input them at the end of the week.

The only fields you need to fill out are the light green shaded boxes. That’s it!! Everything else is automatically calculated for you. At the top in the yellow fields you can see your average weekly spending as well as your year to date (YTD) totals. This spreadsheet is made for 2014, but it is easy to update it for next year. Just create a new copy and update the week ending dates. I also hope to have a new version prepared every year.

Week Ending - Each row should include the totals for all purchases prior to and including the date entered. So, for the week ending 1/4, include all totals from 12/29 through 1/4 (Sunday – Saturday).

Spending – Input the total spent on groceries. You need to define this for yourself. For me, that includes all food, toiletries, paper goods, pet food, diapers, etc.

Savings - Input how much you saved. You need to define this for yourself as well. Will it include all savings or just coupon savings? I include all savings: coupons, sales, and clearance. Most stores calculate your savings for you and include it at the bottom of the receipt.

Stores – Input the stores you visited. This field is not necessary to fill out, but it can be helpful. I like to include this to see which stores I tend to spend more at or get the most savings from.

This spreadsheet is very simple.  You really only have to fill in the spending and savings fields and everything else is done for you!  Now you can have visual evidence of how much you are truly spending and saving.

I truly hope some of you will be able to benefit from this spreadsheet!  I know spreadsheets can seem daunting to some, but don’t be afraid! Inputting your totals will become habit after a while. I’ve been using this spreadsheet for years and I love looking back and seeing all my savings.

Do you track your grocery spending and savings?


Comments

  1. Thank you so much for this post. Last year I started using this. It really helps you see where you need to save at. It keeps you on track with your budget and always makes me strive to do better and less. Thanks again

  2. Thank you soooo much! This will be so helpful for me and my family!

  3. Thank you Meagan.

  4. How do you record a moneymaker. Particularly with Ibotta, I think we are going to have more transactions like that. For example, today at Meijer I purchased:

    Reach Floss $1
    Dove Conditioner $3.49
    Dove Hair spray $4.09
    Lady Speedstick $2
    Special K cereal $2.50
    Frosted Flakes $2.50
    Eggo Waffles $2
    Total = $17.58 + .18 Michigan sales tax = $17.76

    Instant discount for purchasing 2 Dove products = – $2
    Brings total to $15.76

    Paper manuf. coupons I had:
    $.70 off Special K
    $1 off Reach floss
    $.50 off Frosted Flakes (doubled at Meijer to equal $1 off)
    Total in paper coupons (including doublers) = -$2.70

    Brings total to $13.06

    I additionally had a Meijer mperks digital coupon for $10 off grocery/health/beauty purchases
    Brings total to $3.06 OOP

    I can enter all of this information but now with Ibotta, I had the following:

    1.25 off Lady Speedstick
    1.75 off Dove conditioner
    1.75 off Dove hairspray
    1.00 off Special K
    1.00 off Frosted Flakes
    1.00 Eggo Waffles
    Total in Ibotta rewards = $7.75

    So, since I only paid $3.06 OOP and made $7.75 from Ibotta, this was a $4.69 moneymaker for me. The way the online tool and spreadsheet is set up, it doesn’t really allow for moneymakers in this way. Would it calculate it correctly if I entered the transaction without the Ibotta rewards and then entered another transaction of $0 oop and $7.75 savings? I don’t know. Any suggestions would be appreciated. Thanks!

    • I record money-makers when I spend them. You’ll eventually spend the money you earn from Ibotta, so when you do spend it, record it as a savings for that purchase. I do the same thing for rebates, ECBs, Register Rewards, etc.

  5. Thank you! I used the spreadsheet last year and it helped me a TON!!! I shared this with my friends from church and hope it helps them just as much it helped me! thanks again!

  6. Wow I just found this through a google search. Just what I was looking for. This will save me a lot of time. thanks.

  7. Wendy Pence says:

    Thank you so much for this. I have been wanting a spreadsheet to use to track how much savings I am able to accumulate throughout the year. :0)

  8. Thanks so much for all this info! This spreadsheet is perfect!

  9. Hi! I love your spreadsheet! I am curious- do you include tax in your totals? I can’t decide if I want to include it or not.

Speak Your Mind

*

Google+