Family · Money - Template 80
Christmas Planner & Gift Budget Tracker
Christmas, all of it, in one spreadsheet that adds up for you.
Microsoft Excel◆Google Sheets◆.xlsx files
Pick a person from the dropdown and the whole dashboard answers for them: their budget, what you have spent, what is left, how many gifts are bought and where the money went. Pick a category or a different Christmas year and everything moves again. Gifts, stockings, cards, food, plans and baking all live in thirteen linked tabs, the shopping list sorts itself by shop, by person or by budget, and the calendar fills itself in from your plans and posting dates. A Year Review keeps every Christmas side by side, so next year starts from something. Two files: a blank copy and a full sample Christmas.
What's inside · 13 tabs
- Christmas Dashboard - person, category and year selectors driving a budget summary, charts and a countdown
- Gift Planner - a row per gift: who it is for, budget, spent, shop, buy by date, bought and wrapped
- Other Expenses - food, decorations, travel, cards and baking
- Shopping List - sorts itself by shop, person or budget, with a running total per shop
- Stocking Tracker - every filler costed, with four stockings on screen at once
- Card Tracker - addresses, post by dates, and posted and emailed ticks
- Christmas Calendar - fills itself in from your plans, gift buy by dates and card posting dates
- Plans & Traditions, Christmas Meals - dated activities, and the menu with a cost per head
- Baking & Grocery - recipes turned into a shopping list grouped by shop
- Year Review & Setup - every Christmas side by side, and your people, shops and currency in one place
In Motion
Pick a person, the dashboard answers.
Tick a gift as bought and its row turns green, it drops down the shopping list, and every total and chart updates.
Pairs Beautifully With
