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 been tracking my grocery spending and savings since I very first started couponing. I found a simple spreadsheet online that did most of the work for me, so that made it really easy. Not to mention, I kind of have a *thing* for spreadsheets. I have taken my original spreadsheet and modified it to make it even easier to use. Now, I am going to share my spreadsheet with all of 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 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
5. Name and Save it
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!! Every thing 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 2010, 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 2011 version prepared for next 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/16, include all totals from 1/10 through 1/16.
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 every thing else is done for you! Now you can have visual evidence of how much you are truly spending and saving (great to show the unconvinced husbands, right?).
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! Inputing 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?
***UPDATE*** – There was a minor error in the original spreadsheet. If you have downloaded the spreadsheet prior to 2/18/2010, then please follow these instructions to fix it.
1. Go to your spreadsheet and click on H9
2. Press Ctrl + C to copy it
3. Select H10 – H58 by clicking H10 and dragging your mouse down to H58
4. Press Ctrl + V to paste
Now it’s fixed! Sorry about that!!
Fall means cooler weather, changing leaves, pumpkin spice, and my most favorite, Halloween. Halloween is… Read More
Ghosts may give you goosebumps. Monsters may give you nightmares. But if you're on a… Read More
This time of year, you can buy cute baby costumes at a huge array of… Read More
With many restaurants shuttered and others offering only takeout and delivery, a lot of families… Read More
You might not be able to jet off on an around-the-world adventure, but that doesn't… Read More
When you're on the go, you may get hungry. If you've had a bad day,… Read More
View Comments
I downloaded this spreadsheet but it won't let me type anything.What did I do wrong?
@Lisa, Make sure you download the current 2011 spreadsheet: https://www.couponing101.com/2010/12/free-2011-grocery-and-coupon-savings-spreadsheet.html
I am doing this for sure for 2011! Can someone give me a week example using CVS/Wags/Rite Aid with their ECB RR UP program so I can not skew or duplicate my savings? I know one post hinted on it, but I didn't get it, and need an example to understand better!
Blessings!!! A
@amanda, Hi Amanda, here is the 2011 spreadsheet: https://www.couponing101.com/2010/12/free-2011-grocery-and-coupon-savings-spreadsheet.html
For ECBs, RRs, etc, I don't calculate them until they're spent.
For instance, if I spend $1 at Walgreens and earn $2 in register rewards, the RRs are not entered. But when I spend those RRs the next week then they are part of that week's savings. That is why I don't have a column specifically for the rewards, because they're just too hard to keep track of. They are just another form of coupon so they are not calculated until they are used.
Thank you for the Spreadsheet. It saves me a lot of time, and lets me know how quickly my savings are adding up. Sometimes i am challenged with a set of stores that do not offer double coupons, that i wonder if my time is worth it. I have a very busy demanding full time position. However, i am finding by using your sheet that is certainly adding up.
I am able to donate more cash and more to the food pantry , knowing how much i am saving from my budget.
Best Regards
Cindy
Thanks soooo much. I've been wanting to do this, just never had the time. Now you saved me time, so I can do this.
I really want to use this, but I don't have the same options under the File tab as you. I don't see "make a copy" or "download as." HELP!!
Jennifer,
Make sure are logged in. If you still don't see it, look for "upload."
I saved the document in my google account but dont have any idea on how to locate it. Help!!!
Alicia,
Go to docs.google.com and search for it under "all items"
I love this. I hope to use this for my couponing and my regular shopping.
hi everyone i was wondering if someone can help me when i downloaded it opens in read mode only and i don't know if i did it wrong or if i need to change something can someone tell me what it is? thank you
Laura,
You are not doing anything wrong. You will not be able to edit it until you save a copy following the directions in the post.
Thank You Stephanie i got it :)
Thanks so much for this! I was creating one this morning, but didn't get a chance to finish it. I'm new to couponing; at least to seriously couponing.
Ooo, I have a *thing* for spreadsheets, too :) I can't wait to look at this some more and hopefully start using it! So great to have this at the BEGINNING of the year!!!! Thanks for sharing!