How To Create a Price Book

How To Create a Price Book

Do you have a price book to keep track of the best prices or average sales prices?
Do you have any idea why you would keep a price book?

I will attempt to explain my reasons for keeping a price book, and why I can’t create one for you.

A price book is a very important tool if you want to learn to save the most and be organized and not waste.
If you keep a price book of the best prices, or the price you are willing to pay for items, it gives you a starting point. Then you can watch for sales and coupons to match with those sales, and you will know when you have a great deal or not.

REMEMBER, a great deal to me could be very different than a great deal to you. Never try to compare what your savings are to someone else’s savings. Especially when you start out couponing, you will find it hard to get the “best” deals you see others posting. It is certainly a great way to learn, and you should check out other people’s shopping posts, but do not get discouraged by them. For example, last week you may have paid $2.99 for Deodorant and thought it was a great sale, and this week it is still on sale for $2.99 but you found a coupon for $1, making it $1.99. Just because you see someone post they would never pay more than $1 for deodorant, it does not mean YOU didn’t get a deal at $1.99. You saved $1 more than you would have the week before, that’s just the start and is money in your pocket!

Your Price Book will be a very personalized thing, so I can only show you some ideas and examples. It will take some time to set up, but I assure you, it is well worth the time.

In order to plan to save the most, you should create a Price Book to keep track of the regular sale prices of items YOU purchase on a regular basis.

Here are a few steps to help you get started:

  1. Start with making a list of items you buy every month (include toiletries, cleaners, food, and paper products)
  2. List the price you are currently willing to pay for each of these items (again, this will be different for each person, and will change as you learn to save more using other strategies)
  3. Add an extra column to mark the lowest price you remember ever seeing this product for
  4. Include the Per Unit price. One brand’s double roll of bathroom tissue can be much smaller than another brand.
  5. Write down how often you go through 1 of each product (item or package), this will help you determine how many to purchase to get you to the next sale.

Sales on items repeat every 4-6 weeks. Most brands that are on sale this week, will be on sale for the same, or close to the same price in another month or so.

Keeping a certain amount of each item on hand to get you through to the next sale, or longer is a great way to save as well. Stockpiling gets a bad rap because everyone pictures the Extreme cases. This is not what I am promoting. It is a personal thing depending on the size of your family, and the amount of space you have. Everyone is different.

Here are some examples of what I have in my price book. These are items we used to buy regularly, but now we only buy on sale and hopefully with a coupon or other saving method (cashback apps or points). I try to get these items for this price or less. Most can be close to free or free at times, and by having a price book and logging how long each takes us to go through, I can decide how many to buy when I do get one of the Free or almost free offers.

A few items in my Price book include: 

This is very different from what I was willing to pay 3 years ago. You will change and tweak your list as you go. My veggie and meat prices are often higher than you will see on some lists. We try to buy local as much as possible and often pay more for some of these items. I also buy all my soap from a local producer and pay more for the quality.

These are examples of prices you CAN get with coupons or cashback offers these days. Combining these with great sales and points offers for the stock up prices below.
  • Deodorant (Women’s)  $1.25 or less
  • Deodorant (Men’s) $1.00 or less 
  • Body Wash $1
  • Shampoo (favourite brand) $2.00 or less
  • Shampoo (any brand) $1.25 or less
  • Kiwi $0.33 or less per
  • Bananas $0.65/lb
  • Lettuce $1.25 (per bunch, head)
  • Baby Spinach $2.99 (large bag)
  • Avacado $0.80 each (inividual large) Or cheaper if a bag of 4-6
  • Broccoli $1.99
  • Cauliflower $2.99
  • Cheese Large block $3.99
  • Yogurt Tub $1.50 or less
  • Bread $1.50 / loaf
  • Eggs $2 / dozen
  • Lean Gr Beef $3.99/lb (beef prices have risen in recent years, this may be higher)
  • BL/SL Chicken $3.99/lb
  • Diapers $0.10/diaper (smaller sizes) (NOT SURE THE GOING PRICE NOW, this was from 5 years ago)
  • Diapers $0.18/diaper (larger sizes) (NOT SURE THE GOING PRICE NOW, this was from 5 years ago)
  • Baby Wipes $1.25 pkg or less
  • Snack foods (for school lunches) $1.50/6pk ($0.25/snack)
  • 2L Pop $1.00 or less
  • Bathroom tissue (Royale 12 dbl roll) $2.99 or less
  • Paper Towel (Royale Tiger Towels, 6 roll) $2.99 or less

I do purchase Bathroom Tissue at Costco or through Amazon most of the time.  I worked out the PER SHEET price, yes, I know, a bit obsessive!! It makes a huge difference when comparing the sizes of rolls of Bathroom tissue.

2 thoughts on “How To Create a Price Book”

  1. This is a great idea! I have a price book but it's in my head 😉 I'm going to make on of these this weekend 🙂

  2. Brilliant! Would you mind sharing your max price for tissues, toilet paper, and paper towel?

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.