Christmas & Holiday Budget Planner
Holiday budget, gift tracker (Idea to Given), stockings, cards, meal and baking, Black Friday savings, a Nov-Dec calendar and a fairness view. Light and dark mode.
Set one holiday budget, split it across gifts, stockings, cards, events, the big meal and decorations, and see where you stand at any point in the season. It works the same in Microsoft Excel and Google Sheets, with no macros and nothing to install.
What's inside
- Dashboard: total budget, spent, remaining, planned (ideas included), Black Friday savings and days until Christmas, plus spending against budget for each category.
- Recipients: a per-person budget for everyone you buy for, grouped (Family, Kids, Friends, Work…), compared with last year.
- Gift tracker: each gift moves Idea → Bought → Wrapped → Given, with estimated and actual price, store, order and arrival dates.
- Stockings, Cards (with a Sent column), Events & hosting, Meal & baking shopping list, Decor & extras.
- Black Friday & Cyber Monday tracker: regular vs sale price, saving and % off, with each deal labeled Good deal, Small discount or No saving against your own threshold.
- November–December calendar: key dates (US Thanksgiving, Black Friday, Small Business Saturday, Cyber Monday, Giving Tuesday, Christmas Eve and Day, Boxing Day, New Year's Eve) worked out for whatever year you enter, plus every dated item from your tabs.
- Fairness view: compares each person's total with their group's average and flags anyone well above or below, so the kids stay even.
- Light and dark mode with one dropdown.
- Reusable every year: change one Year cell and the dates, calendar and countdown follow.
In the download
Holiday-Budget-Planner.xlsx(blank) andHoliday-Budget-Planner-EXAMPLE.xlsx(filled for a made-up family)- A quick-start PDF guide
- Bonus: an offline gift-budget calculator (a single HTML file). It splits a budget between people and answers "can I afford this gift?" in any browser. Nothing is uploaded.
Good to know
- Works in Excel 2016 or newer (including Excel for the web) and Google Sheets (File → Save as Google Sheets). Only functions that work in both are used.
- Capacity: 50 recipients, 300 gifts, 200 cards, plus room on every other tab.
- Want only the gift tracker? Christmas Gift Budget Lite is $2.99.
- A budgeting tool, not financial advice. License: personal use; please don't resell or share the files.
- Built by Sheet & Flow with AI assistance. Every formula was recalculated in LibreOffice and checked against an independent calculation before release (details in the guide).
Refunds: 30-day refund if it doesn't work as described (refund policy).
Learn the method (free)
- Black Friday Deal Tracker Spreadsheet: Check the Real Discount Against the Lowest Price You've Seen (Excel & Google Sheets)
Build a two-tab Black Friday and Cyber Monday deal tracker that compares each deal with the lowest price you've actually seen, not just the store's "regular" price, labels it Good deal, Small discount, Same as usual or Worse than before, and totals claimed vs real savings. Exact formulas, tested in LibreOffice against an independent model.
- Christmas Gift Budget Spreadsheet: Per-Person Budgets, Gift Status and Black Friday Dates (Excel & Google Sheets)
Build a three-tab Christmas gift budget that counts a gift as spent once it's bought, totals planned vs spent per person, flags anyone over budget, and works out Thanksgiving, Black Friday and Cyber Monday for any year. Exact formulas, tested in LibreOffice against an independent model.
Save with a bundle
- Holiday + 2027 Budget Bundle
2 products for $14.99 instead of $21.99 (save $7).
Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.