Budgeting

Holiday Budget Planner: Track Christmas Spending in Sheets

Build a holiday budget spreadsheet in Google Sheets: a gift budget per person, planned vs actual by category, logging as you shop and a January review.

By Waseem Gul8 min read

In short

A holiday budget spreadsheet sets one total for the season, splits the gift money into a budget per person, and records every purchase as you make it. In Google Sheets that's three tabs: People, Budget and Log. SUMIFS formulas compare planned against actual for each person and category, so you know what's left before you buy the next gift.

A holiday budget spreadsheet gives the season one total, splits the gift money into a budget per person, and logs every purchase as you make it. In Google Sheets that's three tabs, People, Budget and Log, joined by a few SUMIFS formulas. Before you buy the next gift, you can see what you planned for that person, what you've spent and what's left.

Mid-November is when holiday spending starts, so it's the right time to set the plan. This guide builds the sheet, sets per-person budgets, shows how to log purchases at the checkout and ends with a January review, which is how next year gets cheaper.

What should a holiday budget spreadsheet include?

Three tabs in one Google Sheet, named something like "Holidays 2026":

TabOne row perWhat it answers
PeoplePerson you're buying forHow much did I plan for Mom, and how much is left?
BudgetSpending categoryAre food, travel and decorations on track?
LogPurchaseWhat did I buy, for whom, and for how much?

The Log is the only tab you type into while shopping. People and Budget are formulas that add it up, the same way a monthly budget dashboard in Google Sheets reads from an expenses tab.

Set it up in 15 minutes

  1. Create the sheet and add three tabs: People, Budget and Log.
  2. Add the Log headers in row 1: Date (A), Category (B), For (C), Item (D), Amount (E), Paid with (F).
  3. Make Category a dropdown with Gifts, Food & hosting, Travel, Decorations, Cards & postage, Wrapping, Clothes, Donations & tips and Other.
  4. Make For a dropdown that reads from People!A2:A, so each gift is assigned to a name that exists. Our guide to dropdown categories in Google Sheets covers both dropdowns.
  5. Fill in People and Budget with the names, amounts and formulas below.
  6. Format Amount as currency and freeze row 1 on every tab.

Per-person gift budgets: planned vs actual

Gifts are usually the biggest line in a holiday budget, and the easiest one to let drift. Per-person budgets keep it in check because every purchase has a name next to it.

Set budgets by tier

Start from the total you can spend on gifts and work down, not the other way round. Group people into tiers and give each tier a fixed amount:

PersonBudgetGift ideas
Partner$150Weekend away voucher
Mom$100Cookbook, scarf
Dad$100Headphones
Sister$60Candle set
Nephew$40Lego
Niece$40Art kit
Friends (4)$80$20 each
Extras$30Teachers, neighbors, host gifts
Total$600

The Extras row is the one most budgets leave out. Teacher gifts, a bottle for a party host and the office gift exchange are small one by one, but together they're often the reason the gift budget runs over.

The People tab formulas

Lay the People tab out with these columns: Person (A), Budget (B), Gift ideas (C), Spent (D), Left (E), Progress (F), Done (G) and Status (H). Fill A to C yourself and make G a checkbox. Then add these formulas in row 2 and fill them down.

Spent, the actual total for that person, in D2:

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

Left, what's still available, in E2:

=B2-D2

Progress bar, in F2:

=SPARKLINE(MIN(1, D2/MAX(B2, 1)), {"charttype","bar"; "max",1; "color1","#2e7d32"})

Status, in H2:

=IF(D2>B2, "Over", IF(G2, "Done", IF(D2=0, "Not started", "Shopping")))

Tick Done when you've finished buying for someone, so a few dollars left in their row doesn't tempt you into one more stocking filler. Add conditional formatting so Over turns red, and you can scan the list in a second.

Worked example. You bought a $38 cookbook and a $54 scarf for Mom. Spent shows $92, Left shows $8 and Status shows Shopping. When you tick Done, Status changes to Done and the $8 stays unspent. If you then add a $15 candle for her, Spent becomes $107 and Status flips to Over, even though Done is ticked.

Catch gifts with no name

Add one check cell under the People list:

=SUMIFS(Log!E:E, Log!B:B, "Gifts", Log!C:C, "")

It totals every gift logged without a person. If it isn't zero, a purchase is missing from someone's row and your per-person numbers look better than they are.

Food, travel and the other holiday costs

Gifts are only part of the season. Food for hosting, train tickets home, a new tree stand and the stamps for cards all come out of the same December paycheck. The Budget tab gives each its own line.

Lay it out as Category (A), Budget (B), Spent (C) and Left (D):

CategoryBudgetSpent formula
Gifts=SUM(People!B2:B)=SUMIFS(Log!E:E, Log!B:B, A2)
Food & hosting$250Same formula, filled down
Travel$200
Decorations$60
Cards & postage$40
Wrapping$25
Clothes$75
Donations & tips$50
Total$1,300=SUM(C2:C9)

The Gifts budget reads from the People tab, so changing one person's amount updates the whole plan. Left is =B2-C2, filled down.

With the categories in rows 2 to 9 and the total in row 10, put Money available in B12: what you saved plus what you can spare from November and December income. In B13, =B12-B10 shows whether the plan fits before you spend anything. If it's negative, cut a tier or a category now. In mid-December you won't have much room to change the plan.

If you share the holidays with a partner, both of you can log into the same sheet. Our guide to a shared budget spreadsheet for couples covers sharing settings and who-paid-what columns, if you're splitting the costs.

How do I track holiday spending while I shop?

Log each purchase at the checkout, before you leave the store. The holiday budget fails in the gap between buying and recording. Receipts pile up in a bag, card charges take days to post, and cash never shows up in the bank feed at all. By the time a statement arrives in January, the money has been spent.

A row takes four things: category, who it's for, the item and the amount. The date can default to today. That's about ten seconds at the till, or in the parking lot before you start the car.

  • Online orders: log when the order confirmation arrives, not when the parcel does.
  • Returns: add a row with a negative amount and the same person, so their Spent figure drops back.
  • Cash: log it the moment you pay, because nothing else will record it. Our guide to tracking cash spending explains why.
  • Gift cards: log what you paid, under the person it's for.

Logging from your phone with Voice Sheet

Opening a spreadsheet on a phone in a busy shop is slow. Voice Sheet connects to your Holidays 2026 sheet and builds a mobile form from the Log tab's columns, with your Category and For dropdowns as pick lists. The form is free. If a mall basement has no signal, offline expense tracking saves the entry on the phone and adds it to the sheet when you're back online.

You can also say the purchase instead (3 voice entries a day free, unlimited with Premium): "Scarf for Mom, 54 dollars, card." Voice expense logging puts each part in the right column, including the For dropdown, and opens it as a filled-in form for you to check before it's saved. After a long shopping trip, you can also paste a list from your notes into Quick Capture, and each line becomes its own row.

Voice Sheet doesn't scan receipts or read your card transactions, so the sheet holds only what you log. Logging the total before you leave the till is the habit that keeps it complete.

The January follow-up

The holiday budget isn't finished on 25 December. A 30-minute review in the first week of January is what makes next year's plan more accurate than this one.

  1. Match your statements. Go through December's card and bank statements and check each holiday charge against the Log. Add anything missing.
  2. Log returns and refunds as negative rows, so the final numbers are what you actually spent.
  3. Compare planned vs actual. Sort the People tab by Left and the Budget tab by Left. Note which people and categories ran over, and why.
  4. Write next year's budgets in a new column while you still remember the reasons. "Food ran $90 over because we hosted twice" is useful in November 2027. A bare number isn't.
  5. Make a copy for next year. Use File > Make a copy, name it "Holidays 2027", delete the Log rows and keep the People and Budget tabs.
  6. Start saving now. Divide next year's total by 12. A $1,300 season is about $108 a month, which a sinking funds spreadsheet can track alongside insurance and vacations.

If holiday spending ran well past the plan, use the same review for the rest of your budget. A spending audit looks at a full month and turns what you find into three changes.

Fit it into your monthly budget

If you use Voice Sheet's free Personal Finances template, you can keep holiday spending in the same spreadsheet. Add a People tab, add a For column to the Expenses tab and point the People formulas at it. Then add Gifts and Holidays as categories on the Monthly Budget tab. December's purchases then show on the budget dashboard next to rent and groceries, and you still see the season by person on the People tab.

Set up your holiday budget spreadsheet this week, give every person a number, and log each gift as you buy it. In January, the review takes 30 minutes because the numbers are already in the sheet.

Frequently asked questions

How much should I budget for Christmas?

Budget what you can pay in full by January without borrowing: money you saved for the holidays, plus whatever your November and December income can spare after regular bills. Then add 5–10% for the costs people forget, like wrapping, postage and host gifts. Last year's actual spending is the best check on whether the number is realistic.

How do I set a gift budget for each person?

Start from the total gift budget and work down. Group people into tiers, such as partner, close family, extended family, friends and extras like teachers and neighbors, and give each tier a fixed amount. If the per-person amounts add up to more than the total, lower a tier or trim the list before you start shopping.

Is there a free holiday budget template for Google Sheets?

You can build one free in about 15 minutes with the three-tab layout in this guide: People for per-person gift budgets, Budget for categories and Log for every purchase. If you already use Voice Sheet's free Personal Finances template, you can add a People tab and a For column to that spreadsheet instead of starting a new one.

How do I stop overspending at Christmas?

Write the budget down before you shop and log each purchase when you pay, not when the card statement arrives weeks later. A spreadsheet that shows what's left for each person turns every purchase into a quick check. Most overspending comes from small extras, so give wrapping, food and last-minute gifts their own lines.

What should I do with my holiday budget after Christmas?

In early January, match your card statements to the log, add returns as negative amounts, and compare planned against actual for each person and category. Write down next year's numbers while you still remember why things ran over. Then divide next year's total by 12 and start saving that amount each month.

  • holiday budget
  • christmas budget
  • gift budget
  • google sheets
  • seasonal spending
  • budget template
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

The Envelope Budget Method in Google Sheets

Build an envelope budget spreadsheet in Google Sheets: digital envelopes that refill on the 1st, a rollover formula and simple rules for overspending.

· 6 min read

Log spending in seconds, see what’s left

Every entry lands in your own Google Sheet, so your budget formulas keep working. Free to start, voice included.

Download on the App StoreGet it on Google Play