Grocery Budget Worksheet: Build Your Number Person by Person

You wrote a grocery number on your budget, and a week before the month ends it’s gone. Maybe the number was a guess. Maybe half of that “grocery” receipt was paper towels and shampoo. Either way, the page couldn’t tell you, because a single number with no trips under it isn’t a worksheet. It’s a wish.

A good grocery budget worksheet fixes both problems with a few minutes after each trip. You get a number that’s based on the actual people you feed, a place to log each store run, and a line that shows how much is left before Saturday’s trip, not after it. Let’s build one.

What Goes on a Grocery Budget Worksheet?

A grocery budget worksheet has five parts: a weekly food target, the matching monthly target, a trip log with the date and store, separate columns for food and household items, and a running “left this week” balance. The first two tell you what you planned. The last three tell you where the money went while there’s still time to adjust.

That last column matters more than it looks. Plenty of free grocery printables give you a monthly box and a list of items with prices. Useful for a shopping list, not so useful for a budget, because you only find out you’re over when the month is basically done. A running balance turns the third trip of the week into a small decision: the balance is low, so the salmon waits.

How Much Should Your Grocery Number Be?

Start with the USDA food plans instead of a guess. The USDA publishes a weekly and monthly food cost for each age and sex group, at four price levels, and updates them every month using Consumer Price Index data. Add up the people in your house, apply the household-size adjustment, and you have a starting number grounded in real prices.

Here are the adult rows from the USDA Thrifty Food Plan for July 2026 and the USDA low-cost and moderate-cost plans for July 2026, both issued in August 2026. The thrifty table groups adults as 20 to 50; the other two use 19 to 50.

Adult, weekly cost (July 2026)	Thrifty	Low-cost	Moderate-cost
Female, 20 to 50 (19 to 50)	$58.60	$63.70	$77.80
Male, 20 to 50 (19 to 50)	$73.70	$73.30	$92.00

Kids have their own rows in the same PDFs, so look up each child by age. Then use the USDA’s adjustment for household size, because these costs assume a four-person household:

• 1 person: add 20 percent
• 2 people: add 10 percent
• 3 people: add 5 percent
• 4 people: no adjustment
• 5 or 6 people: subtract 5 percent
• 7 or more: subtract 10 percent

Here’s a quick example. A couple, one woman and one man, both in the 20 to 50 group, on the thrifty plan: $58.60 plus $73.70 is $132.30. Add 10 percent for a two-person household and the weekly target is $145.53, call it $146. That goes in the top box of the worksheet.

What that adjustment is really saying: in the USDA’s own math, a smaller household pays more per person than a household of four. So if you live alone and your grocery bill feels high for “just me,” the table says you’re not imagining it.

Pick the plan that matches how you actually shop. If you already cook most meals from basic ingredients, thrifty or low-cost is a fair target. If the cart has a lot of ready-made stuff, start at moderate and trim from there. A target you can hit beats a heroic one you abandon fast.

The Receipt Problem Many Worksheets Skip

Split every grocery receipt into food and household lines before you log it. The USDA food plans price a basket of food, like eggs and vegetables, so comparing that number to a receipt full of dish soap and toilet paper makes your food budget look blown when it isn’t. Two columns, one trip, and the worksheet finally tells the truth.

This is the gap in a lot of grocery budget printables: one “amount spent” column per trip. But a big-box run is rarely just food. If you pour laundry detergent and trash bags into your grocery total, you’ll cut back on produce to “fix” a problem that has nothing to do with food.

For scale, federal spending data counts food on its own lines. In the BLS Consumer Expenditures release for 2024, published December 19, 2025, the average consumer unit spent $6,224 on food at home, a separate line from the $3,945 spent on food away from home. Your food column deserves the same precision: food you bring home, and nothing else.

When I set up the Expense Log in the Fillable Budget Planner, I gave it a Category column instead of a separate grocery page for exactly this reason. One store run becomes two short lines, “groceries” and “household,” so at the end of the month you can add up the grocery lines on their own.

How Do You Fill It In Each Week?

Filling in a grocery budget worksheet is a short weekly routine: write the weekly target at the top, log each trip the day it happens, split the receipt, subtract the food line from the target, and check the balance before the next trip. At the end of the month, compare the total with your plan and change one thing.

1. Write the weekly target. Use your USDA-based number from above, in pencil.
2. Log the trip the same day. Date, store, food amount, household amount. Receipts left in a pocket for days turn into guesses.
3. Subtract only the food line from the weekly target and write what’s left.
4. Check the balance before you shop again. This is the step that does the saving, because it happens while you can still change the list.
5. Carry nothing forward. A few leftover dollars don’t make next week bigger. Move it to savings or let it cushion the month.
6. Close the month. Add the food column, compare it with the monthly target, and adjust one habit at a time.

If you’d rather see every category on one sheet, the same logging habit works with an expense tracker printable. And for the shopping side, like store brands and cutting food waste, our guide on how to save money on groceries picks up where this worksheet stops.

Weekly Math, Monthly Math

To turn a weekly grocery target into a monthly one, multiply by 4.333, not 4. The USDA calculates its own monthly food costs by multiplying weekly costs by 4.333, which is 52 weeks spread over 12 months. Multiplying by 4 quietly shorts your budget in every month longer than 28 days.

Using the couple from earlier, $145.53 a week times 4.333 is about $631 a month. Times 4, it would be about $582, roughly $48 less every month. If you plan your whole budget week by week, our weekly budget planner guide covers the same trap for every category.

Write the dollar amounts in pencil for a reason. Prices move, and the USDA updates these plan costs every month. The BLS August 2026 CPI release showed the food at home index up 2.2 percent over the 12 months ending in August, while it was unchanged from July. So the structure of your worksheet can stay the same for a year, and the target should get a quick check every few months.

Printable, Fillable, or Spreadsheet: Which Worksheet Should You Use?

Choose the format you’ll open at the moment you walk in with groceries. A printable on the fridge works if you log at the kitchen counter. A fillable PDF on your phone or tablet works if receipts live in your bag. A spreadsheet works if you already review money at a laptop once a week. The best format is the one that gets filled in the same day.

Honestly, people overthink this part. Paper has one real advantage: it’s visible. A sheet on the fridge with a “left this week” line is hard to ignore while you’re making a shopping list. A fillable PDF gives you the same page without printing a new one each month, and you can still print a copy when you want it on the fridge.

The Fillable Budget Planner also has a Things I Didn’t Buy page, and I put it in on purpose: a skipped impulse item is real progress, and without somewhere to write it down, that progress leaves no trace on paper. It’s oddly satisfying to see the bakery cookies you walked past add up.

If you like cash for groceries, the cash envelope system pairs nicely with this worksheet. The envelope enforces the limit, and the worksheet records where it went.

This article is for general educational purposes and is not financial advice. Food costs vary by location, diet, and household; check the latest USDA and BLS releases for current figures.