About this template
Take the stress out of holiday shopping. The Christmas Gift Planner & Budget Tracker keeps your entire gift list in one spreadsheet: who each gift is for, what you are giving, how much you planned to spend, and what you actually paid. The dashboard shows Budget vs. Spent for every group, a Spending Breakdown chart, a countdown to Christmas, and live counts of gifts purchased, in hand, wrapped, and given.
What’s included
- Gift Tracker V1: drop-down checkmark version, filled in with an example list
- Gift Tracker V2: click-a-checkbox version, filled in with an example list
- Blank Gift Tracker V1 & V2, ready for your own list
- Excel file (.xlsx) plus a link to make your own Google Sheets copy
- Step-by-step instructions
Key features
- Budget vs. Spent by group (Family, Friend, Neighbor, Coworker, Teacher, In-Laws, Babysitter, Client) with automatic totals
- Editable “Who For” groups to match your own list
- Auto charts: Budget vs. Spent bars and a Spending Breakdown pie chart
- Gift status tracker: check off Bought, In Hand, Wrapped, and Sent, and the row turns green as you go
- “How’s my gift list going?” counters for gifts purchased, in hand, wrapped, and sent
- Christmas countdown showing the days left
- Automatic difference per gift: green under budget, red over
- Store, link, and shipping address columns for online and in-store gifts
- Works in any currency: $, £, €, and more
Perfect for
Parents, families, and anyone who wants to stay on budget this holiday season and never forget a gift, from family and friends to teachers, neighbors, coworkers, and clients.
How to get started
- Complete checkout. Your downloads appear instantly and are emailed to you.
- Open the .xlsx file in Excel, or open the PDF and use the link to make your own Google Sheets copy (File → Make a copy).
- Pick the version you like (checkbox or drop-down) and edit the “Who For” groups and budgets.
- Add each gift and check off its progress. The dashboard updates automatically.
