Using a grocery price book spreadsheet to save money

Shopping Lady

I have been researching grocery price book spreadsheets here recently as a way to help us save money on our groceries.  I thought this might be a better way for me instead of trying to clip coupons.  I do try to use coupons every now and then, but I am not an insane coupon clipper by any means.

There is a lot of information out there that this really works.  I have found that you need to get a good base of about 12 weeks or a little more documented, but once you have that you can really see the times that the prices will drop on all the items that you buy.
Check out this great read ->>The Art of Saving: Save Money on Groceries

Once you know the cycle of the lowest prices on the items that you buy, you simply only buy those items at the time.  So, for example if you see that every 6 weeks the peanut butter you purchase goes to its lowest price, then every 6 weeks when that happens you buy enough peanut butter to last you at least 6 weeks.  Or, you can buy more if you have the funds and are trying to build yourself a stock pile.

This is another great read on cutting your grocery costs ->> The Coupon Mom’s Guide to Cutting Your Grocery Bills in Half: The Strategic Shopping Method Proven to Slash Food and Drugstore Costs

I have started a spreadsheet to track the prices of the items I buy, so I will post updates on here periodically to share the price drop findings that I see and, to let you know how it works for me.  The columns I put in my spreadsheet are pretty basic.  They are listed below:






Unit Price ( I chose to include this in my price book, because if you compare the unit prices of items when available, this can help you save money in itself.)


Price Book Pic

There are many good templates out there as well that you can use, if you don’t want to create your own.  Or, if you would like a sheet that you can print out and take to the store with you to write on.  I prefer to jot all the prices down in a small notebook while shopping, and then transfer them to my spreadsheet when I am done with my shopping trip.  🙂

Here is my excel template for you to use with the basic columns I have listed above and a few examples to get you started.  Price Book Template

And, this is a great template from Organized Home if you would like a printable version to take with you.

Make sure to check back for my updates on this topic!  Leave me any comments or suggestions!

Shopping Lady

Leave a Reply

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