Christmas Budget Spreadsheet: Google Sheets or Excel (2026)

By Cedar & Ledger

A Christmas budget spreadsheet does what a paper list can't: it adds up every gift as you buy it, warns you when a person goes over their cap, and keeps food, travel and decorations in the same total. Here's how to build one in Google Sheets or Excel in about 25 minutes.

All amounts below are made-up examples. This is general information, not financial advice.

Step 1: Set one total first

Make a tab called Budget. Before listing anyone, decide the whole-season number from what you actually have (savings plus what you can spare from December paychecks without a card balance).

Category	Planned
Gifts	$600
Food & hosting	$200
Travel	$150
Decor & cards	$50
Stockings	$60
Total	`=SUM(B2:B6)` → $1,060

Step 2: The Gifts tab

Headers in row 1:

A	B	C	D	E	F
Person	Gift idea	Store	Price	Status	Notes

Status dropdown (select E2:E200): Sheets: Data > Data validation > Dropdown; Excel: Data > Data Validation > List. Options: Idea, Bought, Wrapped, Given.

Step 3: The People tab with caps

A	B	C	D
Person	Cap	Spent	Left
Mom	75	`=SUMIF(Gifts!A:A,A2,Gifts!D:D)`	`=B2-C2`
Jake	60	(fill down)	(fill down)
Teacher	15

Fill C and D down for everyone. Add a total under the Cap column and check it against the Gifts line on the Budget tab: =SUM(B2:B30) should be no more than $600. If it is, lower caps now, not on Dec 20.

Step 4: Red when someone goes over

Select D2:D30 > conditional formatting > less than 0 > red fill. One glance shows who's over.

Only count bought gifts? Change Spent to: =SUMIFS(Gifts!D:D, Gifts!A:A, A2, Gifts!E:E, "<>Idea")

Real Summary tab (example data)

The template for this: Christmas Budget Spreadsheet and Gift List Tracker ($5 · Excel + Google Sheets)

Budget tab: your total holiday budget, minus what you set aside for extras, splits into a gift cap for each person or group (up to 30).
Gift List for up to 200 gifts: person, gift idea, store, cost, and Bought / Wrapped / Shipped or given, with a status that calculates.
Extras tab: travel, hosting food, decor, cards and postage, wrapping and shipping, estimate vs spent.

Get it on Gumroad · See all previews

Or get the set: Complete Household Money Bundle ($29): all 13 home money spreadsheets, this one included (about $69 one by one). Get it on Payhip · What's inside

Optional. You can do everything in this guide with a notebook. I make this template and sell it under Cedar & Ledger, so I'd earn from a purchase. Not financial advice.

Step 5: Link the actuals back to the Budget tab

Add an Actual column on Budget:

Gifts actual: =SUM(People!C2:C30)
Other categories: a small Spending tab (Date, Category, Amount) and =SUMIF(Spending!B:B, A3, Spending!C:C) for each row.
Left: =B2-C2, with the same red rule.

Step 6: A countdown to keep you on pace

On Budget add: Days left: =DATE(2026,12,25)-TODAY() Still to buy: =COUNTIF(Gifts!E:E,"Idea") Thirty gifts and 20 days left means about 1.5 a day; better to know on Dec 5 than Dec 22.

Tips that save money

Cap first, then shop. Ideas go in the sheet before they go in a cart.
Log returns as negative amounts so totals stay true.
Watch the extras: wrapping, shipping and batteries add up; give them a line.
Keep the file for next year. Rename it "Christmas 2027" in January and you already know last year's real number.

Skip the setup

Our Holiday Gift List & Budget Planner ($5) is this spreadsheet, done: one holiday budget, a gift cap per person for up to 30 people or groups, up to 200 gifts tracked from bought to given, and travel, hosting, decor and cards in the same total. Works in Google Sheets and Excel. Prefer paper? See our Christmas gift list tracker guide.

Made with AI assistance and reviewed before release.

See all Cedar & Ledger templates

Try the free holiday gift budget calculator →

Frequently asked questions

What does this guide cover?

Build a Christmas budget spreadsheet in Google Sheets or Excel: one season total, a gifts tab, caps per person with SUMIF, red when over, actual vs plan.

What are the steps?

1) Set one total first; 2) The Gifts tab; 3) The People tab with caps; 4) Red when someone goes over; 5) Link the actuals back to the Budget tab; 6) A countdown to keep you on pace.

Do I need a template to do this?

No. A notebook or a sheet you build yourself works fine. Cedar & Ledger also sells spreadsheet templates (I'd earn from a purchase); see the template box at the top of this page.

Is this financial advice?

No. It's general information with example numbers only, not financial, tax, legal or medical advice. Use your own numbers and check anything important with a qualified professional or the official source.