Grocery List on a Budget: Staples, Quantities and a Price Book

A grocery list on a budget starts from the week’s meal plan, not from the store: list what each meal needs, cross off what you already have, and check the rest against a price book of what you normally pay. Add a short staples list so the pantry never runs dry, and set the week’s grocery amount before you write a single item.

Below you will find the steps, a cheap staples list, how to get quantities right, how to start a price book in Google Sheets or Excel, and a worked family example that uses clearly labeled example prices.

How to Make a Grocery List on a Budget

1. Set the week’s amount first. Take it from the grocery line in your family budget, so the list has a limit before it has items.
2. Start from the meal plan. Every item should trace back to a meal or a snack. Writing the list in the same sitting as your weekly planning session keeps the two in step. No plan yet? Our meal planning for beginners guide builds one in six steps.
3. Shop your kitchen. Check the fridge, freezer and pantry and cross off anything you already have. Check the staples list at the same time.
4. Write a quantity on every line. “Onions” is a guess; “onions, 4” is a plan. The quantities section below shows how.
5. Group items by store section. Produce, meat, dairy, pantry, frozen. You pass each aisle once and see the whole list for each section.
6. Price the list and trim it. Estimate each line from your price book, total it, and cut or swap until it fits the amount. The worked example below does exactly this.
7. Shop from the list, then log the receipt. Back home, update the price book with anything that changed. It takes about five minutes.

A Cheap Grocery List of Budget Staples

Staples are the ingredients you keep on hand every week, so a plain dinner is always possible without a special trip. These are the building blocks that tend to stretch furthest; your own price book will tell you which ones are actually cheap where you shop.

Section	Staples	Restock when
Pantry	Rice, rolled oats, dried lentils, canned or dried beans, pasta, canned tomatoes, peanut butter, flour, cooking oil	The spare is opened
Fridge	Eggs, milk, butter, a block of cheese, a large tub of plain yogurt	Half is gone
Freezer	Frozen vegetables, frozen fruit, a loaf of bread, chicken thighs	The last bag is opened
Produce that keeps	Onions, potatoes, carrots, cabbage, apples, bananas	You are down to two or three
Flavor	Garlic, stock cubes, salt, pepper and the two or three spices you use weekly	The jar is a quarter full

The rule for pantry items is “one open, one spare”. When you open the spare, the item goes on the list. That way you restock before you run out, and you never buy a third jar of something you already have two of.

Keep the staples list short. If an item has not been used in a month, it is not a staple, and it should come off the list.

Quantities: Buy for the Plan, Not the Package

On a careful list, quantities are where money slips away quietly. Two habits keep them in check.

Add up the item across the week. Say onions appear in Monday’s chili (1), Wednesday’s curry (2) and Saturday’s fried rice (1). That is one line, “onions, 4”, not three separate lines that each say “onion”. Our meal planner template with grocery list keeps the week’s meals and the list with quantities on the same page, which makes this addition quick.

Then decide how to buy it. Four onions can be four loose ones or a 3 lb bag. The bag is only a saving if onions are a staple and you will use the rest before they sprout. The same goes for a large bag of spinach bought for one pasta dinner: either plan a second meal that uses it, such as a frittata, or buy the small bag.

How to Start a Grocery Price Book

A price book is a record of what you pay for the 20 to 30 items you buy most, at each store you use, converted to a price per unit. After a few weeks it tells you what a good price looks like, which store is cheaper for which item, and whether the big pack really saves money.

Here is a small price book. The prices are made-up examples for illustration, not quotes from any store. Use your own receipts and shelf tags.

Item	Store	Size	Example price	Unit price
Rolled oats	Store A	42 oz	$4.29	10.2¢ per oz
Rolled oats	Store B	18 oz	$2.49	13.8¢ per oz
Long-grain rice	Store A	5 lb (80 oz)	$4.99	6.2¢ per oz
Long-grain rice	Store B	2 lb (32 oz)	$2.29	7.2¢ per oz
Peanut butter	Store A	40 oz	$6.49	16.2¢ per oz
Peanut butter	Store B, on sale	16 oz	$1.99	12.4¢ per oz
Frozen broccoli	Store A	12 oz	$1.49	12.4¢ per oz
Frozen broccoli	Store B	32 oz	$3.79	11.8¢ per oz

What the book shows, even with example numbers:

• Bigger is often cheaper per ounce, but not always. The large oats and rice win. The sale jar of peanut butter beats the big jar: two sale jars give you 32 oz for $3.98, while 32 oz at the big jar’s unit price would cost $5.19.
• Some differences are too small to chase. The big bag of broccoli saves 0.6¢ per ounce. That is worth it only if you have the freezer space and were going to that store anyway.
• Compare like with like. Shelf tags mix per ounce, per pound and per count. Convert everything to one unit, as the Size column does for rice, before you compare.

Price Book Formulas for Google Sheets and Excel

Set up columns A Item, B Store, C Date, D Price, E Size (in ounces or your chosen unit) and F Unit price.

• Unit price, in F2 and filled down: =D2/E2. Format it as currency with three decimals. It works the same in both apps.
• Lowest unit price you have recorded for the item typed in H2: =MINIFS(F2:F200,A2:A200,H2). This works in Google Sheets and in Excel 2019, Excel 2021 and Microsoft 365. In Excel 2016 or earlier, use =MIN(IF(A2:A200=H2,F2:F200)) and confirm it with Ctrl+Shift+Enter.
• Is today’s shelf price a stock-up price? With today’s unit price in I2: =IF(I2<=MINIFS(F2:F200,A2:A200,H2),"Stock up","Normal price").

On the list itself, put quantities in B2:B40 and each item’s expected price per pack in C2:C40. The estimated total is =SUMPRODUCT(B2:B40,C2:C40) and, with the week’s amount in F1, the money left is =F1-SUMPRODUCT(B2:B40,C2:C40). Both formulas are identical in Google Sheets and Excel.

Budget Grocery List for a Family: A Worked Estimate

Say your weekly grocery amount is $95 and you are shopping for a family of four. Here is the main list for the week, priced with example prices (again, not real quotes). Anything still stocked in the pantry is left off.

Item	Qty	Example price	Line total
Chicken thighs, 3 lb pack	2	$7.49	$14.98
Ground beef, 1 lb	2	$5.99	$11.98
Salmon, 1 lb	1	$10.99	$10.99
Eggs, dozen	2	$3.29	$6.58
Milk, gallon	2	$3.59	$7.18
Bread, loaf	2	$2.99	$5.98
Yogurt, 32 oz tub	2	$3.49	$6.98
Rice, 5 lb	1	$4.99	$4.99
Pasta, 1 lb	2	$1.49	$2.98
Black beans, 15 oz can	4	$1.09	$4.36
Frozen broccoli, 32 oz	1	$3.79	$3.79
Apples, 3 lb bag	1	$4.49	$4.49
Carrots, 2 lb bag	1	$1.99	$1.99
Onions, 3 lb bag	1	$2.99	$2.99
Crackers, box	2	$3.99	$7.98
Juice boxes, 10 pack	1	$4.49	$4.49
Estimated total			$102.73

The first pass comes to about $103, roughly $8 over. Two changes bring it back:

Change	Effect	New total	Against $95
Swap salmon night for bean burrito night (2 more cans of beans)	minus $10.99, plus $2.18	$93.92	$1.08 under
Drop the juice boxes, send water bottles	minus $4.49	$89.43	$5.57 under

The first swap does most of the work, because it replaces the priciest single item on the list with two cans of beans. The second leaves about $6 of room for a price that went up since you last shopped or the item someone forgot to add. Notice that the list was never cut at random: neither change takes a meal off the plan.

If the whole family eats from this list, agree on the dinners together first. Our family weekly planner guide covers a 15-minute Sunday meeting that settles meals, rides and chores in one go.

More Ways to Save Money on Groceries

• Read the unit price on the shelf tag, not the big number, and compare it with your price book before you grab the larger pack.
• Plan one dinner around a sale. Check the store flyer before you plan, and build a meal around a staple that is at or below your price-book low.
• Compare whole and pre-cut produce. A whole cabbage or a bag of carrots often costs less per ounce than the washed and chopped version. Your price book settles it for your store.
• Eat down the pantry. Once a month, plan most of a week from what you already have and buy only fresh items. A no-spend challenge takes the same idea further, with rules for what counts as an essential.
• Write leftovers into the plan. Food that gets eaten twice is food you do not buy twice.

Your next step: before your next shop, start a price book with the ten items you buy every week, then add the unit price of each one straight from this week’s receipt.