Budgeting

How to Budget for Thanksgiving Without the Stress

Set a Thanksgiving budget in Google Sheets: a cost per dish and per guest, a shopping order, a fair family split and a 20-minute review after dinner.

By Waseem Gul8 min read

In short

A Thanksgiving budget starts with a cost per guest, multiplied by your guest count. Give each dish a share of that total, log every purchase with who paid, and let one Google Sheet show the cost per guest and who owes whom. It takes about 15 minutes to build and removes the guesswork.

To budget for Thanksgiving, pick a cost per guest, multiply it by your guest count and give every dish a share of that total. Then log each purchase with who paid. In one Google Sheet, that shows what each dish really cost, what you're spending per guest and who owes whom once dinner is over.

For a benchmark, the American Farm Bureau's 2025 survey priced a classic dinner for 10 at $55.18, about $5.52 a person. Regional averages ran from $50.01 in the South to $61.75 in the West. That basket has no drinks, appetizers or foil pans, so treat it as the floor for your own table.

How do I budget for Thanksgiving?

Seven steps, and most of the stress goes with them:

  1. Count guests. Write down names, not a rough number, and count children separately.
  2. Pick a cost per guest. Start with what you'd be comfortable spending, such as $15 or $20.
  3. Multiply and check. Guests times cost per guest is your total. Make sure this month can pay for it.
  4. Give every dish a budget. Include drinks, table extras and a last-minute line.
  5. Agree on the split. Settle who's covering what before anyone goes to the store.
  6. Log each purchase with the dish and who paid, on the day you buy it.
  7. Review it after dinner. Twenty minutes gives you next year's numbers.

Plan: cost every dish and every guest

One Google Sheet with three tabs holds the whole Thanksgiving budget:

TabOne row perWhat it answers
MenuDishWhat should this dish cost, and what did it cost?
LogPurchaseWhat did we buy, and who paid?
HouseholdsFamily groupWho's paid what, and who owes whom?

Set up the sheet

  1. Create the three tabs in a new sheet called "Thanksgiving".
  2. Add the Log headers: Date (A), Dish (B), Item (C), Amount (D), Paid by (E).
  3. Add the Menu headers: Dish (A), Budget (B), Who's on it (C), Spent (D), Left (E), Per guest (F).
  4. Add the Households headers: Household (A), People (B), Paid (C), Share (D), Balance (E).
  5. Make Dish and Paid by dropdowns that read from Menu!A2:A13 and Households!A2:A5. Our guide to dropdown categories in Google Sheets shows how.

Give each dish a budget

Here's a sample Menu tab for 10 guests at $18 each. The numbers are examples, so swap in prices from your own store.

DishBudgetPer guestWho's on it
Turkey$32$3.20Host
Stuffing and gravy$14$1.40Host
Mashed potatoes$10$1.00Mom & Dad
Sweet potatoes$9$0.90Host
Green beans$8$0.80Mom & Dad
Cranberry sauce$4$0.40Host
Rolls and butter$7$0.70Host
Pies and cream$18$1.80Jo & Ben
Appetizers$15$1.50Host
Drinks$30$3.00Jo & Ben
Table extras$18$1.80Host
Last-minute$15$1.50Anyone
Total$180$18.00

Those dishes fill rows 2 to 13, with the total in row 14. Table extras covers foil pans, napkins and ice. Last-minute is for the forgotten can of broth, and it's the row that stops a small surprise from breaking the plan.

Add these formulas in row 2 of the Menu tab and fill them down.

Spent, in D2:

=SUMIFS(Log!D:D, Log!B:B, A2)

Left, in E2:

=B2-D2

Per guest, in F2, once the Households tab has its head count in B6:

=D2/Households!$B$6

Before shopping, check that $180 fits your month. If you use the budget dashboard in Voice Sheet's free Personal Finances template, your groceries line shows what's left. And if Thanksgiving is the start of a bigger season, this sheet feeds the Food & hosting line in a holiday budget spreadsheet.

If the total is too high, cut a whole dish instead of trimming everything by a dollar. One fewer side is easy to stick to. Promising yourself cheaper butter isn't.

Shop: buy in the right order and log as you go

Most of the savings come from what you buy and when. Spread the shopping across the week so you aren't paying full price for everything on Wednesday night.

WhenWhat to buyWhy
Two weeks out to the weekend beforeFrozen turkey, canned goods, baking supplies, drinksThey keep, and you can compare store ads
Monday or TuesdayPotatoes, butter, cream, green beansFresh enough, and shelves are still full
WednesdayRolls, herbs, iceOnly what has to be fresh

Allow for thawing if you buy frozen. USDA's rule is 24 hours in the fridge for every 4 to 5 pounds, so a 16-pound turkey goes in by Sunday.

  • Compare price per pound. The Farm Bureau's 16-pound frozen turkey averaged $1.34 a pound in 2025, a useful yardstick against store ads.
  • Check the pantry first. Cross off what you already have before the list leaves the house.
  • Hand off whole dishes. "Can you bring the drinks?" is easier to ask, and easier to track, than sharing small costs.

Log it before you leave the store

A Thanksgiving budget only works if the Log stays current. One row per dish per trip is enough. If a single receipt covers five dishes, don't itemize every onion. Put the turkey on its own row, then group the rest into two or three lines. Log cash on the spot too, since cash spending won't show up anywhere else.

Typing into a five-column sheet on a phone beside a full cart is the slow part. Voice Sheet connects to your own sheet through Google Sheets sync and turns the Log tab into a phone form, with Dish and Paid by as pick lists. You can also say the whole row:

"Two pumpkin pies from the bakery, 18 dollars, Jo and Ben paid."

DateDishItemAmountPaid by
TodayPies and creamTwo pumpkin pies, bakery$18.00Jo & Ben

Voice expense logging puts each part in its column and shows you the filled-in form to check before saving. You can try it in the app before creating an account, and the free plan includes 3 voice entries a day. Voice Sheet doesn't scan receipts or read card transactions, so the sheet holds only what someone logs. Nobody else has to install anything, either: relatives can type into the shared sheet or text you the amount.

Split: share the cost without the awkward text

Agree on one of these before the first shopping trip. Each one changes what goes in the Households tab.

MethodHow it worksBest when
Host covers itSkip the split and keep the Log for your own numbersThe host offers, or guests bring wine
PotluckEach household pays for its own dishDishes cost about the same
Shared potEveryone logs, then the total is split fairlyCosts are uneven, as with one family buying the turkey

For a shared pot, list each household in rows 2 to 5 and put the head count total in row 6, with =SUM(B2:B5) in B6. Then add these in row 2 and fill them down:

Paid, in C2:

=SUMIFS(Log!D:D, Log!E:E, A2)

Share, in D2:

=SUM(Log!D:D)*B2/B$6

Balance, in E2:

=C2-D2

A positive balance means the household is owed money. A negative balance means it owes. In a sample dinner that came to $190, the sheet looks like this:

HouseholdPeoplePaidShareBalance
Host4$120$76+$44
Jo & Ben2$40$38+$2
Mom & Dad2$30$38−$8
Alex & Kim2$0$38−$38

Three payments settle it: Alex & Kim send the host $38, Mom & Dad send the host $6, and Mom & Dad send Jo & Ben $2.

Two small adjustments cover most family disagreements. Enter 0.5 under People for each child if that feels fairer, or enter 1 for every household to split per household instead of per head. Add =SUM(E2:E5) in E6 as a check, too. It should read 0, and anything else means a Log row is missing its Paid by name.

Share the sheet with one person per household so they can see the numbers themselves. The shared budget spreadsheet for couples guide covers sharing settings and settling up in more detail.

Review: 20 minutes that make next year easier

Do this the weekend after, while you still remember which pie went untouched.

  1. Add anything missing. Check card statements against the Log and add stragglers.
  2. Settle up. Send the Households tab to the group and clear the balances.
  3. Compare per guest. The sample dinner came in at $19 a guest against $18 planned.
  4. Mark the waste. Write "half left over" next to any dish that didn't earn its budget, then cut it next year.
  5. Copy the sheet. Use File > Make a copy, delete the Log rows and keep the Menu and Households tabs.
  6. Start saving. Divide the total by 10 or 12 and set that aside each month. A sinking funds spreadsheet keeps it separate from everyday money.

If the meal ran well over, look at the rest of the month as well. A 30-minute spending audit finds out whether Thanksgiving was the cause or just the moment you noticed.

Set your Thanksgiving budget today: count the guests, pick a number per person and give every dish its line. When the leftovers are gone, you'll know what dinner cost and nobody will have to ask who owes what.

Frequently asked questions

How much does Thanksgiving dinner cost?

The American Farm Bureau's 2025 survey priced a classic dinner for 10 at $55.18, or about $5.52 per person, with regional averages from $50.01 in the South to $61.75 in the West. Real menus usually cost more, because the survey's basket doesn't include drinks, appetizers or disposable pans.

How much should I budget per person for Thanksgiving?

Start from your own menu, not a national average. Price each dish for your guest count, add drinks and a last-minute line, then divide by the number of guests. The sample dinner for 10 in this guide comes to $18 a guest. If the total doesn't fit, drop a dish first.

How do you split Thanksgiving costs with family?

Agree on the split before anyone shops. Each household logs what it spends, the total is divided by head count or by household, and each share is subtracted from what that household paid. A positive balance means it's owed money. A negative balance means it pays the difference. One Google Sheet handles it.

How can I make Thanksgiving dinner cheaper?

Compare turkeys by price per pound, check store ads in the week before, and use what's already in your pantry. Then look at your cost per dish. Dropping a side nobody finishes, or asking a guest to bring the drinks, usually saves more than hunting for coupons on every small ingredient.

Should guests pay for Thanksgiving dinner?

Guests don't have to, and many hosts prefer to cover the meal. If you need help, ask early and be specific: bring a dish, bring the drinks or chip in a set amount. Asking before anyone shops feels like planning. Asking after dinner feels like a bill, and that's where the awkwardness starts.

  • thanksgiving budget
  • thanksgiving dinner cost
  • holiday budget
  • split costs
  • google sheets
  • seasonal spending
New to Voice Sheet?

Say it, and it's in your Google Sheet.

Voice Sheet adds rows to your Google Sheets by voice, from a pasted list, a home screen widget or a form built from your columns. It works offline and never connects to your bank.

See everything Voice Sheet does →
Voice Sheet — say it, and it's in your Google Sheet

Keep reading

Budgeting

How to Do a Spending Audit in 30 Minutes

Do a spending audit in 30 minutes in Google Sheets: gather a month of spending, categorize it, flag leaks with filter views and pick three changes.

· 7 min read

Say what you spent. The sheet does the math.

Log each Thanksgiving purchase to your own Google Sheet by voice. The free plan includes 3 voice entries a day.

Download on the App StoreGet it on Google Play