Holiday Budget Planner Spreadsheet | Year Round Sinking Fund and Gift Budget Tracker for Excel and Google Sheets | Every Holiday Funded

Your calendar already knows when every holiday lands. This is the spreadsheet that makes your money know it too.

Every holiday is a bill with a due date you've known about all year — and somehow October costumes, November travel and December everything still hit the same three paychecks. This 12-tab command center is the year-round fix: list the days your family celebrates, give each one a budget, and it computes ONE number — what to set aside this month so every holiday is funded before it arrives. Works in both Microsoft Excel and Google Sheets. Pay once.

HOW IT WORKS — THREE MOVES, ALL COMPUTED
• List the days. 14 built-in holidays with On/Off toggles plus 6 custom rows (anniversaries, Diwali, anything). 11 days On in the sample = a $2,810 year budget, computed on the spot.
• Run the autopilot. For every upcoming holiday: (budget − funded) ÷ months left. The sample family needs $182.83/month against a $200 capacity — every holiday funded before it arrives, with room to spare.
• Log and trust the statuses. Deposits fill the envelopes, spending empties them, and every holiday reads FUNDED / ON TRACK / BEHIND / DONE — honestly (the sample's July 4th closed $1.20 over, and it says so).

WHAT YOU GET — 12 CONNECTED TABS (EXCEL + GOOGLE SHEETS)
• Dashboard — year budget vs funded vs spent vs remaining, the next three holidays with live countdowns and funded %, underfunded-in-30-days alerts, and this month's autopilot number.
• Setup — Year (rolls forward — no annual reset), Planning Date, monthly capacity, and the holiday table with On/Off toggles.
• Sinking Fund Autopilot — months left, left-to-fund and required-per-month for every upcoming holiday, totalled against your capacity, with the funding-curve chart.
• Holiday Envelopes — budget, funded, spent, remaining and an honest status per holiday.
• Gift Lists — recipient and holiday caps, ideas, actuals, statuses (Idea/Bought/Wrapped/Given) and automatic over-cap flags.
• Spending Log — date, holiday, category (Gifts/Food/Decor/Travel/Party/Cards/Other), planned or not — SUMIFS feeds everything.
• Deposits Log — every transfer into the fund; this is what fills the envelopes.
• Valentine's, Easter, Fall and Winter Planners — seasonal mini-budgets, planned vs actual, that reconcile to the envelopes.
• Glossary & Help — every term in plain English, and the one rule: type only in the blue cells.

WHY THIS ONE
Most "holiday planners" are one December page of empty boxes. This one runs the whole year and computes: required-per-month per holiday, envelope statuses with a pace check, countdown alerts, gift caps with over-cap flags — 681 formulas doing the math your Decembers used to absorb.

HONEST PROOF
681 formulas · recalculated clean · 40/40 independent math checks · every screen in the photos and videos is the real file. No stock mock-ups.

WORKS IN EXCEL AND GOOGLE SHEETS — one-click Google Sheets access PDF included, plus the xlsx for Excel. Instant download, yours forever, free lifetime updates.

🎥 WATCH THE FULL VIDEO TUTORIAL: https://youtu.be/X1HPQCBS3Iw

YOU MAY ALSO LIKE
• Christmas Budget Command Center → https://www.etsy.com/listing/4538246215/christmas-budget-planner-spreadsheet (the December deep-dive — gifts, deals, cards, menus)
• Birthday Budget Planner → https://www.etsy.com/listing/4543591624/birthday-budget-planner-spreadsheet (every family birthday, planned for the whole year)
• Savings Challenge Vault → https://www.etsy.com/listing/4538256980/savings-challenge-tracker-excel-google (the deposit-schedule cousin — 100-envelope, 52-week)

Hosting the gift exchange too? The Secret Santa Party Kit has the questionnaires, games, and an automatic name draw: https://www.etsy.com/listing/4554171593/secret-santa-questionnaire-printable

This is a budgeting tool, not financial advice.