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.
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:
- Count guests. Write down names, not a rough number, and count children separately.
- Pick a cost per guest. Start with what you'd be comfortable spending, such as $15 or $20.
- Multiply and check. Guests times cost per guest is your total. Make sure this month can pay for it.
- Give every dish a budget. Include drinks, table extras and a last-minute line.
- Agree on the split. Settle who's covering what before anyone goes to the store.
- Log each purchase with the dish and who paid, on the day you buy it.
- 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:
| Tab | One row per | What it answers |
|---|---|---|
| Menu | Dish | What should this dish cost, and what did it cost? |
| Log | Purchase | What did we buy, and who paid? |
| Households | Family group | Who's paid what, and who owes whom? |
Set up the sheet
- Create the three tabs in a new sheet called "Thanksgiving".
- Add the Log headers: Date (A), Dish (B), Item (C), Amount (D), Paid by (E).
- Add the Menu headers: Dish (A), Budget (B), Who's on it (C), Spent (D), Left (E), Per guest (F).
- Add the Households headers: Household (A), People (B), Paid (C), Share (D), Balance (E).
- Make Dish and Paid by dropdowns that read from
Menu!A2:A13andHouseholds!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.
| Dish | Budget | Per guest | Who's on it |
|---|---|---|---|
| Turkey | $32 | $3.20 | Host |
| Stuffing and gravy | $14 | $1.40 | Host |
| Mashed potatoes | $10 | $1.00 | Mom & Dad |
| Sweet potatoes | $9 | $0.90 | Host |
| Green beans | $8 | $0.80 | Mom & Dad |
| Cranberry sauce | $4 | $0.40 | Host |
| Rolls and butter | $7 | $0.70 | Host |
| Pies and cream | $18 | $1.80 | Jo & Ben |
| Appetizers | $15 | $1.50 | Host |
| Drinks | $30 | $3.00 | Jo & Ben |
| Table extras | $18 | $1.80 | Host |
| Last-minute | $15 | $1.50 | Anyone |
| 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.
| When | What to buy | Why |
|---|---|---|
| Two weeks out to the weekend before | Frozen turkey, canned goods, baking supplies, drinks | They keep, and you can compare store ads |
| Monday or Tuesday | Potatoes, butter, cream, green beans | Fresh enough, and shelves are still full |
| Wednesday | Rolls, herbs, ice | Only 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."
| Date | Dish | Item | Amount | Paid by |
|---|---|---|---|---|
| Today | Pies and cream | Two pumpkin pies, bakery | $18.00 | Jo & 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.
| Method | How it works | Best when |
|---|---|---|
| Host covers it | Skip the split and keep the Log for your own numbers | The host offers, or guests bring wine |
| Potluck | Each household pays for its own dish | Dishes cost about the same |
| Shared pot | Everyone logs, then the total is split fairly | Costs 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:
| Household | People | Paid | Share | Balance |
|---|---|---|---|---|
| Host | 4 | $120 | $76 | +$44 |
| Jo & Ben | 2 | $40 | $38 | +$2 |
| Mom & Dad | 2 | $30 | $38 | −$8 |
| Alex & Kim | 2 | $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.
- Add anything missing. Check card statements against the Log and add stragglers.
- Settle up. Send the Households tab to the group and clear the balances.
- Compare per guest. The sample dinner came in at $19 a guest against $18 planned.
- Mark the waste. Write "half left over" next to any dish that didn't earn its budget, then cut it next year.
- Copy the sheet. Use File > Make a copy, delete the Log rows and keep the Menu and Households tabs.
- 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.
