Mommysavers

Frugal Moms Living Well for Less

  • Facebook
  • Instagram
  • Food
    • Recipes
      • 5 Ingredients or Less
      • 30 Minute Meals
      • Freezer Meals
      • Appetizers
      • Breakfast
      • Lunch
      • Dinner
      • Dessert
      • Snacks
    • Cooking Techniques
    • Leftovers and Preservation
  • Home
    • Cleaning
    • Decor and Design
    • DIY Projects
    • Money
      • Couponing
      • Personal Finance
      • Shopping Tips
    • Simple Living
  • Family
    • Fun
    • Parenting
    • Travel
  • A Better You
    • Health and Fitness
    • Lifehacks
    • Fashion
    • Motivation and Productivity
    • Entrepreneurialism
  • Holidays
    • Thanksgiving
    • Christmas
    • New Year’s Eve
    • Valentine’s Day
    • St. Patrick’s Day
    • Easter
    • Mother’s Day
    • Father’s Day
    • Halloween
  • Special Deals

How to Create a Grocery Price Book

October 4, 2010 by Kimberly Danger 20 Comments

how to create a grocery price book
Kim Danger – Grocery Tips Featured in All You Magazine

 

Create a Price Book to Track Grocery Prices

What exactly is a price book? It’s a tool used to track prices of things you commonly purchase (typically groceries – but this can extend to clothing or other things as well) at various stores and different times and places.  An informed shopper is a savvy shopper.  If you’ve never considered keeping a price book before, here’s why you should: you’ll be arming yourself with the knowledge you need to make informed buying decisions – avoiding the confusing marketing tactics.  Being aware of price shifts and at which stores you’ll find the best deals on certain things can really help you save money over time.

Before you begin, it helps to save your grocery receipts for a month or so. That way, you’re already in possession of the itemized records of exactly what my family had purchased when, where, and how much we paid. You can also grab the store circulars from recent weeks and record that data as well.

how to create a grocery price book

Grocery Price Book Method One: The Notebook

The “old school” method, the notebook method, is often what people think of when they think of a price book. A spiral bound notebook small enough to keep in your purse.   Some people say that if you actually manually WRITE something vs. type it, you’re more likely to retain the information.  If that describes you, this may be your method of choice.  It’s also great for those that dislike working with spreadsheets (more on that below). There are a number of ways of setting up your price book.

Alphabetically by Item

For most people, it works best to label the top of each page alphabetically.   The first page of your notebook is “A”, the second is “B” and so on.  Include canned tomatoes on your “T” page, cereal on your “C” page and so on.   On the lines of each page, record the store, the date of your purchase, the price, as well as the unit size of each package so you can calculate the price per ounce.

Top 50 Items Strategy

If the thought of recording all of your grocery purchases makes you start to sweat, there is a shortcut that still will help you save money.  Start with the 50 items you buy most frequently.   You’ll likely end up with things like this on your list:

  • Milk
  • Eggs
  • Cheese
  • Ground Beef
  • Strawberries
  • Bananas
  • Broccoli
  • Frozen Peas
  • Canned Corn
  • Tortillas
  • Yogurt
  • Spaghetti Noodles

After saving your receipts for a while, you’ll notice which items are common purchases.  List them in your book alphabetically by item, and again – record store, price, unit size, and date.

If you start getting the hang of this method, you can then decide whether or not to move on to things you buy only occasionally.  It’s best to avoid recording items you rarely buy unless you really want to make this more of a project than it has to be.   However, in today’s day and age, I find the next method a lot easier as well as more convenient:

Price Book Method Two: The Spreadsheet

price book price book

I think the most efficient way for you to log your prices is using Google Docs and the Google Drive app.  I created my spreadsheet in a couple hours one afternoon.  Here’s how you create your Price Book:  In the rows across, record the names of the stores where you shop most often. On the left column, write the name of the food items you purchase along with the unit size. In the cells where the store and the product intersect, record the price.  What I like about this method is I can make changes on my computer at home simply by looking at my receipts.   Because my Google Docs app syncs my computer and my phone, always have the spreadsheet handy while I’m shopping.

After you keep your price book for awhile, your outlook on grocery shopping begins to change.  Sometimes you will realize that advertised sales aren’t necessarily all they’re cracked up to be, and sometimes they’re not bargains at all.   You’ll be able to spot rock-bottom prices on favorite grocery items and add them to your stockpile without hesitation – knowing exactly how much to buy.

 

Share
Tweet
Pin2K
2K Shares

Filed Under: Shopping Tips, Food Tagged With: groceries, grocery shopping, saving money, money

« Saving Money at the Grocery Store: Buy Meat Reduced for Quick Sale
Savvy Shopping Tip: Fight Takeout Temptation »

Comments

  1. Julie says

    January 20, 2011 at 2:57 pm

    I use a spreadsheet, and I keep all my receipts by the computer….when the kids are napping or not fighting (like that ever happens 😉 I quickly update my spreadsheet….although, I did actually format mine to calculate the price per unit (per ounce, per diaper, per slice….) so that I can keep better track of Costco vs Save-A-Lot pricing…..

    Reply
    • Jennifer says

      March 1, 2011 at 6:02 pm

      Would you be willing to share your spreadsheet?

      Reply
      • Kimberly Danger says

        March 2, 2011 at 9:16 am

        My pricing information is in my book, Instant Bargains: 600+ Ways to Shrink Your Grocery Bills and Eat Well for Less.

        Reply
  2. Cindy says

    January 20, 2011 at 4:11 pm

    I do this just with a small notebook but need to be more organized with it. I also like to note what store has what price so I know when a sale comes if it is a good sale or not. I wish there was an app for the smart phone or ipod that I could use. I do use my ipod for my shopping list as I don’t have a smart phone as yet.

    Reply
    • Heather says

      January 21, 2011 at 2:55 pm

      I totally agree with Cindy that there should be a smart phone app for keeping a price book that also allows you to compare prices between stores. Who do we talk to so we can make that happen?

      Reply
  3. Andrea says

    February 4, 2011 at 8:34 pm

    The app “Smart Shopper” does this. You hold the iphone/pod up to it, and it will scan the bar code and tell you if it’s on sale, the usual price, and if it is cheaper in a 50 mile radius (or ever how many miles you set it to.) Amazon has one of these also.

    Reply
    • Andrea says

      February 4, 2011 at 8:35 pm

      *if it’s cheap at another store in a ___ mile radius.

      Reply
  4. katherine says

    March 22, 2011 at 11:54 pm

    I think the iphone app you’re referring to is called shop savvy. Smart Shopper only calculates what you would pay when you input the % discount.

    Reply
  5. James says

    February 17, 2012 at 11:30 am

    The PriceMouse digital price book app for iPhone automatically compares prices and unit prices across stores.

    Reply
  6. Betty819 says

    January 16, 2015 at 2:36 am

    With the cost of gas now days, I don’t see how it is cost effective to drive from one store to another to save a few pennies or dollars. Our nearest Target is about 9 or 10 miles, the nearest Walmart is 15 miles, We have many food chain stores close by, as well as CVS, Rite-Aid and Walgreens. I can’t drive from place to place and deal with getting my handicapped husband with walker in/out of the car umteem times. It’s too hard on him and myself.

    I wonder if the store that you frequent the most can pull a list of all the items you have purchased, say in last 3 months..along with price paid? It would sure help making a price list..even though prices are subject to change..

    Reply
    • Carole says

      January 20, 2016 at 11:33 pm

      Last I heard Walmart would meet other stores lower advertised price. Now not sure exactly how it works and if it’s only for sale items or not, but take your ads with you if you go to Walmart, it might be worth investigating.

      Reply

Trackbacks

  1. Be a Proactive Shopper and SAVE | Mommysavers.com says:
    January 21, 2011 at 2:45 pm

    […] than when you run out of something and have to buy it at full price.  If you’re using a Price Book , you’re already in the mode of being a proactive grocery shopper.  Take that same principle […]

    Reply
  2. Target vs. Walmart: Which has better grocery prices? I put it to the test! | Mommysavers.com says:
    March 18, 2011 at 9:50 am

    […] Instant Bargains: 600+ Ways to Shrink Your Grocery Bills and Eat Well for Less.  When you keep a grocery price book, you’ll be arming yourself with the knowledge you need to make informed buying decisions – […]

    Reply
  3. Target’s Grocery Prices Come Out on Top « Target Savers says:
    March 20, 2011 at 6:21 am

    […] Instant Bargains: 600+ Ways to Shrink Your Grocery Bills and Eat Well for Less. When you keep a grocery price book, you’ll be arming yourself with the knowledge you need to make informed buying decisions – […]

    Reply
  4. Sam’s Club Shopping Tips | Mommysavers.com says:
    April 28, 2011 at 12:15 pm

    […] often not the case.  Often you’ll save more by shopping at your regular grocery store.  Keeping a price book with information on the 50-100 products you buy most often will help you determine whether […]

    Reply
  5. The Frugal Kitchen: Organize Grocery Shopping and Menu Planning - Mommysavers.com | Online Coupons & Savings says:
    February 9, 2012 at 5:51 pm

    […] Mommysavers, we’ve recommended keeping a Price Book for many years.  It’s a tool used to track prices of the groceries you buy most often at […]

    Reply
  6. Grocery Store Price Comparison: ALDI, Target, Walmart and Cub Foods - Mommysavers.com | Online Coupons & Savings says:
    April 10, 2013 at 12:35 pm

    […] you do your own grocery store price comparison, I recommend keeping a price book.  Not only will price differences become more apparent, you’ll be able to easily identify […]

    Reply
  7. How to Cut Your Grocery Bill in Half - Mommysavers.com | Online Coupons & Savings says:
    June 9, 2013 at 8:37 am

    […] a Use a price book to keep track of various prices at different stores. so you know if you can get an item cheaper […]

    Reply
  8. Homemade Chili - Frugal Bites says:
    September 29, 2013 at 7:45 am

    […] Tips:  Keep a grocery price book so you know when pantry-staples like tomato soup and beans are at their lowest price – then […]

    Reply
  9. How to Save Money Grocery Shopping for Healthy Whole Foods | Natural Mama Cafe says:
    August 30, 2017 at 12:27 pm

    […] Compare prices by weight. A price diary is one way to keep track of the best prices you have found. There are some nice examples here. […]

    Reply

Leave a Reply Cancel reply

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

Recipe Rating




About Mommysavers

Kimberly Danger established Mommysavers.com in March 2000 as a way to channel her creative energy while raising her kids. Initially an online discussion board, the website evolved into a comprehensive platform offering money-saving tips, deals and budget-friendly recipes and tips for frugal moms. Read More…

View My Blog Posts
Kimberly Danger

mommysavers

Helping families live well for less 💰money saving tips 🥘 budget-friendly recipes 💵 frugal living 🛍️ deals

😍✨ Unlock the Secrets of Decorating with Thri 😍✨ Unlock the Secrets of Decorating with Thrifted Bohemian Maximalist Decor 🌿💸 

Dive into our latest article filled with thrifted treasures and hidden gems. You won't believe how easy and affordable it is to transform your home into a boho paradise! 🏡✨ Eight tips that will have you looking at thrift store goodies in an entirely new way!  https://mommysavers.com/bohemian-maximalist-decor-on-a-budget/

Also, check out this page for thrifted Boho Inspo: @Boho Design Dreams

#bohoonabudget #budgetdecor #thriftedfinds
#momlife #momlife
🎉 Calling all Savvy Shoppers💰 🔥 This wee 🎉 Calling all Savvy Shoppers💰

🔥 This week in our Deals Group we shared info on Lululemon discounts, and how to get this Nature's Bounty protein shake mix for under $10 per canister! 📦💯

We also share unbeatable Amazon deals, irresistible clothing discounts, and mind-blowing super savings! 🛍️✨

Join HERE --> https://www.facebook.com/groups/mommysaversdeals
🍞🍍🥥 Copycat Hawaiian Sweet Bread😋 🌴 🍞🍍🥥 Copycat Hawaiian Sweet Bread😋 🌴

Follow our step-by-step instructions to create a delicious, tropical-flavored loaf right in your own kitchen.

Check out the recipe here: https://mommysavers.com/copycat-hawaiian-sweet-bread-a-step-by-step-guide/

#copycatrecipes #breadrecipes
📸🌿 Planning the Perfect Photo Safari for Kid 📸🌿 Planning the Perfect Photo Safari for Kids 🦋 🌺

Spark your child's creativity and curiosity with a neighborhood photo safari! It's a fun-filled activity that combines exploration, nature, and photography, teaching kids to observe their surroundings, focus on details, and capture beautiful moments.🐕🚚

From planning the safari and selecting the right equipment to the joy of reviewing their photos and discussing their experiences, our guide offers a step-by-step walkthrough that's sure to inspire. 👣🌳📝

Check out our free downloadable safari checklist to kickstart your journey! 🗒️✔️

👉 https://mommysavers.com/photo-safari-for-kids-a-fun-neighborhood-adventure/

🌍💼🎉 #PhotoSafari #KidsActivities #photographyforkids #staycation #summerfunforkids
🌱🍌 Banana Peels = Your Gardening Secret! 💚

Don't throw those banana peels away!  Instead, discover the hidden nutrient potential of banana peels and how they can invigorate your plants with essential elements like potassium, phosphorus, and calcium. We've revealed three easy methods for transforming your banana peels into a potent, organic fertilizer that your plants will love!

https://mommysavers.com/banana-peel-fertilizer/

#bananas #plantlove #greenthumb #gardeningtips #gardening101
🎉 Calling all Savvy Amazon Shoppers💰 Get re 🎉 Calling all Savvy Amazon Shoppers💰

Get ready for unbeatable Amazon Prime Day deals, irresistible clothing discounts, and mind-blowing super savings! 🛍️✨

🔥 We'll be posting them all day in our Deals Group!  As a member of our group, you'll be the first to know about the hottest deals on Amazon. From must-have essentials to exciting finds, we bring you the best prices on all the products you love! 📦💯

Join HERE --> https://www.facebook.com/groups/mommysaversdeals
💁‍♀️Calling All Budget-Savvy Moms👗 Wa 💁‍♀️Calling All Budget-Savvy Moms👗

Want to unlock incredible style without breaking the bank? Check out our new blog post: '12 Ways to Level Up Your Style without Draining Your Wallet'. We've compiled some practical yet creative tips for you, from thrifting tricks to building a smart capsule wardrobe. So, how many of these tips are you following? Share your thoughts in the comments. 🛍️👠 

https://mommysavers.com/frugal-fashion-ideas-for-women-money-saving-tips-for-moms/

#frugalfashion #budgetfashion #fashiontips #budgetwardrobe #capsulewardrobe
🌟 Who's on Threads? 🧵 Let's get together f 🌟 Who's on Threads? 🧵 

Let's get together for some frugal fun and conversation! 🎉 We don't quite know what we're doing yet, but we don't want to miss out on the action! ⚡️ Here's our link: https://www.threads.net/@mommysavers 

Drop your link below, and we will be sure to follow you back. Let's bring the frugal fun to threads! 🌱  #frugalliving #threads #frugalmom #mommysavers
👚 Ready to revamp your family's wardrobe in a s 👚 Ready to revamp your family's wardrobe in a sustainable, budget-friendly, and fun way? 👕 

In our latest blog post, we show you how to organize a clothing swap. From gathering your fashion-forward friends, setting the right guidelines to choosing a fair and fun swapping method, we've covered all bases. Plus, we delve into how you can turn your swap into a memorable social event and wrap it up by giving back to the community!

It's more than just a clothing swap—it's about sustainability, community, and of course, great style! Start planning your swap today! #clothingswap #sustainablefashion #frugalfashion 

🔗 https://mommysavers.com/how-to-organize-a-clothing-swap/
Instagram post 18000104272794052 Instagram post 18000104272794052
🎉 Are you ready to turn your passion for fashio 🎉 Are you ready to turn your passion for fashion into cash? Whether you're a Poshmark newbie or a seasoned pro, our Ultimate Guide to Poshmark Success is here to help you step up your selling game! 💸

Learn the secrets to sourcing high-demand items, discover the best brands to sell, get the scoop on staying ahead of seasonal trends, and unlock the power of Posh Parties. From thrift store hunting tips to mastering the art of selling high-end items, we've got it all covered. 🛍️👗👠

Jumpstart your Poshmark journey today with our savvy strategies! 💖🌟

Check out the guide now: https://mommysavers.com/a-comprehensive-guide-to-selling-on-poshmark/

#resale #poshmark #poshmarkcloset #fashionresale
🌿🚫🦟 Want to reclaim your yard from pesky 🌿🚫🦟 Want to reclaim your yard from pesky mosquitoes? 🌿🚫🦟

We've got 8 practical tips to transform your outdoor space into a (nearly) mosquito-free zone. From eliminating breeding grounds to introducing natural predators, we've got it all covered. Say goodbye to itchy bites and hello to peaceful summer evenings. 👋🌛 Read now and make your yard a no-fly zone for mosquitoes! 👉 https://mommysavers.com/8-ways-to-keep-mosquitoes-away-from-your-yard/

#bugrepellent #mosquitoes #mosquitofree
🎆 Prepping for your 4th of July celebration? Ad 🎆 Prepping for your 4th of July celebration? Add a splash of red to your blue and white with our deliciously patriotic Red Velvet Cheesecake Bars! 🇺🇸🍰

🎉 These tasty treats are not just festive, they're velvety, creamy, and an absolute crowd-pleaser. The perfect way to sweeten up your Independence Day celebrations!

https://mommysavers.com/red-velvet-cheesecake-bars/
🍹 Calling all cocktail enthusiasts! After a mar 🍹 Calling all cocktail enthusiasts! After a marathon of mixology and countless taste-tests, we've discovered the secret to the PERFECT Beerita! 😎

⚙️ Several recipes and countless taste tests later, we're proud to present our definitive Beerita Recipe, a symphony of flavors balanced to perfection. And the best part? They're a breeze to whip up!

📝 Here's the golden recipe:
12-oz. limeade
Two 12-oz. beers 🍻
12 oz. tequila 🥃
12 oz. Sprite 🍾
1 C. ice ❄️

🗣️ From the Mixologists: We tried a version with one beer - good, but two beers? Even better. Worried about a 'beery' taste? Don't be! The beer merely offsets the tartness of the limeade, while the Sprite adds a refreshing fizz.

The full scoop is here: https://mommysavers.com/the-perfect-beerita-recipe/
"🍵Unleashing the Secret Powers of Your Tea Bags "🍵Unleashing the Secret Powers of Your Tea Bags: Discover 35+ Amazing Uses 🚀 

Ever wondered how to extend the life of your tea bags beyond the teapot? Did you know that you can polish furniture, tenderize meat, and even prevent rust with used tea bags? Click the link to unveil these unique, cost-saving hacks and the secret powers of the everyday tea bag! https://mommysavers.com/uses-for-tea-bags-leaves/

#frugalliving #householdhacks #frugalhacks #teabags
Garage Sale Shopping at the cabin is a fun way to Garage Sale Shopping at the cabin is a fun way to spend a couple of hours… did anyone else have the Fisher-Price medical kit as a kid? I love seeing #vintage toys. We ended up finding a $10 bike in EUC for our niece #bargainfinds #garagesales
🍪 Got a sweet tooth? Craving a cookie that stay 🍪 Got a sweet tooth? Craving a cookie that stays soft and moist for days? 🤔 We've got just the thing! It's time to level up your cookie game with our secret ingredient - pudding! 😍

🍽️ Our community is raving about these cookies 🥳 Join the 47,000+ baking enthusiasts who've already pinned, baked, and fallen in love with these cookies! https://mommysavers.com/chocolate-chip-pudding-cookies/

#cookierecipes #easytreats #cookies
🕑 The Secret to Time-Saving, Budget-Savvy, Deli 🕑 The Secret to Time-Saving, Budget-Savvy, Delicious Meals! 🍽️

📌 With over 62,000 pins on Pinterest, this life-hack is a game changer for those looking to save time and money in the kitchen!

🕑 Picture this: just a couple of hours in the kitchen, and voila, you have 8 scrumptious meals at your fingertips, ready for the crockpot whenever you need them!

🍖 On our irresistible menu, we have everything from the succulent Ham with Pineapple 🍍 (thanks to Allergy Free Cooking), to the hearty Carolina Style Pulled Pork Sandwiches 🥪, not to mention our flavor-packed Mediterranean Pork Chops 🌿. And, if you're craving BBQ, our Barbecued Hamburgers 🍔 and Tangy BBQ Chicken 🍗 will not disappoint!

👉 Click through to find these enticing recipes and start transforming your meal prep game today! Bon Appétit! 🍽️💕https://mommysavers.com/crock-pot-freezer-meals/

 #MealPrep #CrockPotRecipes #freezermeals #crockpot #budgetrecipes
A thrifters paradise… the #goodwillbins! Come wi A thrifters paradise… the #goodwillbins! Come with us as we shop and discover hidden treasure 💎 💰 #thrifting #goodwilloutlet #goodwillhunting
Load More Follow on Instagram

Tags

21 Day Fix recipes activewear Advent amazon prime christmas treat christmas treat ideas clean eating fix clean eating recipe clean eating recipes crock pot recipes copycat recipes Costco deals crafts crock pot meals date night ideas declutter decor ideas free printables frugal activities frugal recipe furniture gifts for men gratitude gymboree halloween cupcakes halloween party halloween treats healthy healthy menu plan heathy recipes holiday toys homemade christmas Instant Pot kids celebration Michael's deals oatmeal old navy deals oreos organize Shakeology starbucks stocking stuffer ideas teacher gifts turkey cupcakes walmart deals zulily

Copyright © 2025 · Delightful theme by Restored 316

Copyright © 2025 · Delightful Pro Theme on Genesis Framework · WordPress · Log in