Christmas Gift Planner - Holiday Budget Spreadsheet (Excel + Google Sheets)
Christmas Gift & Holiday Budget Planner (Excel + Google Sheets)
Stop guessing how much Christmas is costing you. Give every person on your list a budget, log each gift idea, and watch the planner keep score: what you have spent, what is still planned, and what is left, per person and for the whole season.
WHAT'S INSIDE
- Dashboard: days to go, total budget, spent, still planned, money left, savings from deals, and % of gifts done, all on one page
- People: a budget for each name; spent, planned, left and a plain status ("1 to buy", "Wrap it", "All done", "Over budget") fill in by themselves
- Gift tracker (400 rows): who it is for, store, rough price, price paid, normal price, status from Idea to Ordered, Arrived, Wrapped and Given
- Late-delivery alert: ordered gifts turn red when the "arrives by" date has passed
- Deals tracker: type the normal price and see how much you saved
- Other holiday spending with category budgets: food, decorations, wrapping, travel, parties, donations, stocking stuffers
- Holiday card list with addresses, sent and received
- Charts: budget per person and where the gifts are
EASY TO USE
- Yellow cells are inputs, everything else is automatic
- Drop-down menus for people and status, so there is nothing to remember
- Comes with sample names and gifts so you can see it working; select the yellow cells and press Delete to start fresh
- Works in Excel (2016+, Microsoft 365, Mac and Windows) and Google Sheets, including the Google Sheets phone app
- Reuse it every year: change the year and clear the yellow cells
- Celebrate a different holiday? Change the big day on Setup
You get a .zip with the .xlsx file and a one-page quick start. Digital download, nothing ships.
Personal use. Please do not share or resell the file.