Christmas Budget & Gift Tracker — Google Sheets & Excel

About this product

Plan your whole holiday in one spreadsheet: set your total Christmas budget, list every gift with what you planned and what you actually spent, track other holiday expenses, and keep a Christmas card list. The Dashboard adds it all up for you, so you always know how much money is left.

What you get

• Dashboard — total budget, total planned, total spent, money left, % of budget used and a progress bar
• Plan check — a warning if your planned spending is higher than your budget
• Days-until-Christmas countdown
• Gift List with 40 slots — recipient, group, gift idea, store, budget, spent and status
• Automatic Difference and Budget Check on every gift (under / on / over budget)
• Status dropdown: Idea, Ordered, Bought, Wrapped, Given — rows turn green when given
• Other Expenses tab with 25 slots — dinner, travel, decorations, postage, parties, charity, outfits
• Christmas Card List with 30 slots — cards sent and cards received
• Spending by group (partner, kids, parents, friends, coworkers, teachers…) and by expense category
• Color-coded, protected cells — formulas can't be overwritten by accident
• Works in Google Sheets AND Excel

How it works

1. Download the .xlsx file
2. Upload it to Google Sheets (File → Import → Upload) or open it directly in Excel
3. Demo gifts and expenses are pre-loaded so you see it working immediately
4. Type your total holiday budget on the Dashboard, delete the demo rows and add your own
5. Update the Status and Spent columns as you shop — everything recalculates instantly

Perfect for

• Families planning Christmas gifts on a budget
• Parents buying for several kids
• Anyone with a long gift list (friends, coworkers, teachers, extended family)
• Couples who share the holiday budget
• Planning Christmas dinner, travel and decorations costs
• Avoiding January credit-card surprises

Good to know

• Instant digital download — nothing is shipped
• Made for Google Sheets; a free Google account is all you need. It also opens in Microsoft Excel.
• Amounts are in US dollars ($). In Google Sheets you can change the currency under Format → Number → Currency.
• This is a digital template for personal use. Please don't resell or redistribute the file.
• Not a printable PDF — this is an editable spreadsheet.
• Questions? Send me a message — happy to help! 🎅

Questions