What's inside
- People tab: up to 60 people with a group and a budget; gifts planned and bought, expected cost, spent, left, and a status (No gift yet / Shopping / All bought / Over budget)
- Gift list: up to 200 gifts with a drop-down for who it's for, planned price, actual price, bought? and wrapped?, and where to buy it
- Other costs: food and hosting, decorations, cards and postage, travel, wrapping and shipping, charity
- Plan tab: budget vs expected vs spent for every category, what's left, how much you still need to save and how much per month, gifts still to buy, gifts bought but not wrapped; a chart
- Sample: a $1,700 Christmas for 13 people with food, travel and decorations: $64 left after everything planned, one person over budget, $433 a month to save
Checked, not just designed: all 953 formulas recalculate with zero errors, and every gift, person, category and summary figure was recomputed independently in 3 scenarios per file.
Works in Excel and Google Sheets. Not just for Christmas: rename the holiday on the Setup tab.
Try the free version first
The free online calculator uses the same model for a quick answer. The spreadsheet adds tracking, history and the full views.