Weekly Meal Plan & Grocery List That Stays Under Budget (Worked Example)

You get to the register, the total comes up $25 higher than you expected, and you can’t say where it went. By Sunday half of what you bought is in the trash or the back of the fridge. The fix is rarely coupons or willpower. It is that you decided what to buy while standing in the store, and you found out the total only when it was too late to change it.

This guide gives you the whole system with real numbers: one full week of meals for a family of four, the consolidated grocery list built from it, the pantry check, the cap check, and the spreadsheet formulas to copy. You can run it on paper or in any spreadsheet today. At the end, if you’d rather not build the sheet yourself, there is a ready-made one.

A note on the numbers. Every price and budget below is an illustrative assumption I chose so the math is easy to follow, not a store quote or a national average. Swap in your own prices and your own cap; the method is what matters.

The Setup: Cap First, Then Plan

Most people plan meals and then see what it costs. Reverse that. Decide the number first, because a cap turns “did I overspend?” into “does this list fit?”, which you can answer at your kitchen table.

Meal Grocery spreadsheet template - what's inside
Meal Grocery spreadsheet template - what's inside

Our worked household:

The 4.33 is the average number of weeks in a month (52 ÷ 12). Here is the same conversion for other budgets:

Monthly grocery budget Weekly cap (÷ 4.33) Exact (× 12 ÷ 52)
$300 $69.28 $69.23
$350 $80.83 $80.77
$400 $92.38 $92.31
$500 $115.47 $115.38
$600 $138.57 $138.46

Step 1: Plan the Week Around Shared Ingredients

Start with dinners, since they are the meals most likely to be replaced by takeout when there is no plan. Then fill in breakfasts and lunches. The trick that makes a budget plan cheap is overlap: choose meals that share ingredients so every pack you buy gets used up.

Day Breakfast Lunch Dinner
Mon Overnight oats Chicken wraps Chicken stir fry over rice
Tue Eggs and banana Leftover stir fry Black bean tacos
Wed Overnight oats Chicken wraps Spaghetti with turkey meat sauce
Thu Eggs and banana Leftover spaghetti Sausage and potato sheet pan
Fri Overnight oats Chicken wraps Chicken fried rice
Sat Pancakes and fruit Leftover fried rice Veggie bean chili
Sun Overnight oats Leftover chili Breakfast for dinner (eggs, pancakes)

Count the overlap: chicken thighs appear in three meals, rice in three, tortillas in tacos and wraps, black beans in tacos and chili, onions and peppers in five dinners, and one carton of eggs covers fried rice, breakfasts and the Sunday dinner. Six ingredients doing double or triple duty is what keeps the list short.

Step 2: Build One Consolidated Grocery List

Now go meal by meal and write every ingredient with its quantity. The key is to consolidate: four recipes that each need onions become one line, bought in the pack size the store actually sells. You buy packages, not recipe fractions, so the list should be in packages.

Here is the consolidated list for the week above, with the pantry check built in (a “Yes” in the Pantry column means you already own it, so the cost to buy is $0):

Meal Grocery spreadsheet template - overview
Meal Grocery spreadsheet template - overview

Item Aisle Qty × unit Price Line cost In pantry? To buy
Chicken thighs, bone-in/skinless Meat 4 × lb $2.49 $9.96 No $9.96
Ground turkey Meat 1 × lb $5.49 $5.49 No $5.49
Smoked sausage Meat 1 × 14 oz $4.29 $4.29 No $4.29
Deli turkey Deli 1 × lb $7.99 $7.99 No $7.99
Eggs Dairy 1 × 18 ct $4.99 $4.99 No $4.99
Milk Dairy 1 × gallon $3.79 $3.79 No $3.79
Shredded cheese Dairy 2 × 8 oz $2.49 $4.98 No $4.98
Long-grain rice Pantry 1 × 5 lb $4.49 $4.49 Yes $0.00
Spaghetti Pantry 1 × 1 lb $1.49 $1.49 No $1.49
Rolled oats Pantry 1 × 18 oz $3.49 $3.49 Yes $0.00
Black beans Pantry 4 × can $0.99 $3.96 No $3.96
Diced tomatoes Pantry 2 × can $1.19 $2.38 No $2.38
Pasta sauce Pantry 1 × jar $1.99 $1.99 No $1.99
Pancake mix Pantry 1 × box $2.99 $2.99 No $2.99
Flour tortillas Pantry 2 × 10 ct $2.49 $4.98 No $4.98
Salsa Pantry 1 × jar $2.49 $2.49 No $2.49
Soy sauce Pantry 1 × bottle $2.79 $2.79 Yes $0.00
Onions Produce 1 × 3 lb bag $3.49 $3.49 No $3.49
Potatoes Produce 1 × 5 lb bag $4.99 $4.99 No $4.99
Bell peppers Produce 3 × each $1.00 $3.00 No $3.00
Bananas Produce 3 × lb $0.59 $1.77 No $1.77
Romaine lettuce Produce 1 × head $1.99 $1.99 No $1.99
Apples Produce 3 × lb $1.49 $4.47 No $4.47
Frozen stir-fry vegetables Frozen 2 × bag $2.29 $4.58 No $4.58
Frozen peas Frozen 1 × bag $1.69 $1.69 No $1.69

Totals: the full list is $98.52, but the pantry check removes $10.77 (rice, oats and soy sauce are already in the cupboard), so you actually need to buy $87.75.

That pantry pass is worth doing every single week. Most kitchens hold usable food that gets re-bought only because nobody checked.

Step 3: Check the List Against the Cap Before You Leave

Here is the step that separates staying under budget from hoping you will:

At this point it is only a number on a screen, so fixing it is painless. Look for the biggest, most substitutable lines:

Swap Change to list New total
Drop the 1 lb deli turkey ($7.99); use 1 extra lb of chicken thighs ($2.49) for the wraps -$5.50 $82.25
Buy one bag of shredded cheese instead of two (tacos and wraps share it) -$2.49 $79.76

The final list comes to $79.76, which is $1.07 under the cap, or $2.85 per person per day across 4 people and 7 days. Nothing about the week’s meals changed except the lunch protein.

The same swaps at the register would have meant putting items back with a full cart and a line behind you, which almost nobody does. That is why the check happens at home.

Step 4: Shop the List, Then Log Estimate vs Actual

With a planned, priced, pantry-checked list, the trip is almost boring. You are executing a decision you already made calmly. After the trip, record what you actually spent in each category next to the estimate. Here is what that log looks like if prices in the produce aisle came in higher than assumed (hypothetical receipt):

Category Estimated Actual Variance
Meat $22.23 $23.10 +$0.87
Dairy $11.27 $11.27 $0.00
Pantry $20.28 $21.40 +$1.12
Produce $19.71 $22.05 +$2.34
Frozen $6.27 $6.27 $0.00
Total $79.76 $84.09 +$4.33

Two things this tells you. First, you finished $3.26 over the cap even though you planned under it, so the estimate needs more headroom (or a produce-price update). Second, almost all the miss is in one category, produce (+$2.34), which is the easiest one to fix: price it from last week’s receipt next time. Track this for three or four weeks and your estimates stop being guesses.

Copy-Ready Layout and Formulas

If you are building this yourself, here is the minimum sheet. Put these headers in row 5 of a tab called Grocery:

A: Item | B: Aisle | C: Qty | D: Unit | E: Price | F: In pantry? (Yes/No) | G: To buy

And these formulas (rows 6 to 30 hold items):

Weekly cap in B3 (B2 = monthly budget):  =B2/4.33
To buy, per line (G6):                   =IF(F6="Yes",0,C6*E6)
Total to buy (G31):                      =SUM(G6:G30)
Over / under cap:                        =B3-G31      (negative = over)
Subtotal by aisle:                       =SUMIF($B$6:$B$30,"Produce",$G$6:$G$30)
Status flag:                             =IF(G31>B3,"OVER CAP","UNDER CAP")

To consolidate duplicate ingredients across recipes, keep a second tab with one row per recipe ingredient (recipe, ingredient, quantity) and total each ingredient on the Grocery tab with =SUMIF(Ingredients!$B:$B,A6,Ingredients!$C:$C). Add a data-validation dropdown to the Yes/No column and conditional formatting on the status cell, and you have a working planner.

Price Each Recipe Per Serving

Once the plan works, price your recipes individually so you can swap meals by cost. Take the black bean tacos (4 servings): 2 cans of beans ($1.98), 8 of the 20 tortillas ($1.99), one bag of cheese ($2.49), salsa ($2.49) and a head of lettuce ($1.99) comes to $10.94, or $2.74 per serving. The sausage-and-potato sheet pan costs more per serving than the bean chili, so on a tight week you can swap one for the other and see the effect on the total immediately.

Five Mistakes That Break a Grocery Budget

  1. Planning without a cap. A plan that has no number attached can cost anything.
  2. Listing recipe fractions instead of packs. You can’t buy a quarter of a 3 lb bag of onions, so the list must show what you will actually pay.
  3. Skipping the pantry pass. It is the cheapest saving available: $10.77 off a $98.52 list in the example, for two minutes of checking.
  4. Pricing from memory. Prices drift. Update your price column from the last receipt, not from what things used to cost.
  5. Never logging actuals. Without estimate-vs-actual, your estimates never improve and the same category leaks every week.

Doing This Without Rebuilding It Every Week

The weakness of the DIY version is upkeep. Re-typing the ingredient list, re-pricing, and re-checking the pantry every week is the point where most people quit. That is the part worth automating. For a quicker route into the topic, see the walk-through of a meal planning spreadsheet that auto-generates the grocery list by aisle, the guide to setting a grocery budget for a family of 4, a step-by-step on making a grocery budget spreadsheet that actually works, and how a pantry inventory sheet stops you wasting food money.


Frequently Asked Questions

How do I make a weekly meal plan that stays under budget?

Set the cap first, then plan. Divide your monthly food budget by 4.33 to get a weekly number, fill in the week's meals, build one consolidated grocery list from them, subtract what is already in your pantry, and price every line before you shop. If the total is over the cap, swap items on the list (not at the register) until it fits. In the worked example on this page, the first draft was $6.92 over a $80.83 cap and two swaps brought it under.

How do I work out a weekly grocery budget from a monthly one?

Divide the monthly amount by 4.33, because a month averages about 4.33 weeks (52 weeks / 12 months). A $350 monthly budget is $80.83 a week; $500 is $115.47. If you shop every week, some months contain a fifth shopping trip, so many people hold back one week's cushion or set the weekly cap slightly lower than the division gives.

Why do I always go over budget at the grocery store?

Usually three leaks at once: buying ingredients for meals you never decided to cook, re-buying staples you already own, and having no running total while you shop. Planning the meals first, subtracting the pantry, and pricing the list before you leave closes all three. The worked example shows the pantry check alone removing $10.77 from a $98.52 list.

How much should a family of four spend on groceries per week?

There is no single right number, because it depends on your region, the ages in the household and how much you cook from scratch. Rather than copying an average, set your own cap from your actual take-home pay and past receipts, then check it against the USDA's current monthly Food Plans cost report if you want an outside reference point. The example on this page uses an assumed $350 a month for four people, which works out to $2.85 per person per day.

Is it better to meal plan in a spreadsheet or an app?

A spreadsheet gives you the whole week, the editable list and a live budget total on one screen, with no subscription or login. Apps can be handier in the aisle, but many hide the math or put budgeting behind a paywall. A meal planner spreadsheet works in Excel and Google Sheets and syncs to your phone through Google Drive.

How do I meal plan on a budget when I only cook for one or two people?

Plan around pack sizes, not recipes. A 3 lb bag of onions or a 5 lb bag of potatoes costs less per pound but only saves money if you use it, so build two or three meals that share each perishable and freeze the surplus. Set servings per recipe to the real number of people and let the list scale; the main risk for small households is buying a full pack for a one-meal use.

Does the meal planner spreadsheet work in Google Sheets?

Yes. The ReadySheetGo Meal Planner & Grocery Budget uses ordinary formulas with no macros, so it opens in Excel and in Google Sheets, where you can use it on your phone through the Sheets app.

Eat Better, Spend Less

The Meal Planner & Grocery Budget — Plan weekly meals, auto-generate grocery lists, track food spending. Save money and reduce waste.

View on Etsy — $9.99