Christmas Tracker Spreadsheet

About this download

Track every Christmas gift by person with a light budget per person, progress rings and a days until Christmas countdown, in Google Sheets. Keep wishes, purchases, delivery details and past gifts together in one workbook.

𝗪𝗛𝗔𝗧'𝗦 𝗜𝗡𝗦𝗜𝗗𝗘 (𝟖 𝗧𝗔𝗕𝗦)

• How To: seven quick steps, color key, copy links and sorting instructions.
• Dashboard: budget totals, three progress rings, Budget vs spent by person, gifts by status, ship-by watch and who still needs a gift.
• People: 60 people with group, address, gifts planned, notes, Budget, Spent and Left. Calculated counts show wishes, gifts and progress.
• Gift Tracker: 300 gifts with six status steps, delivery method, Cost, ordered and ship-by dates, tracking number, Arrived, hiding spot, repeat-gift check and Mail to address lookup.
• Wish Lists: 200 wishes, links, sizes or colors, Must or Nice, from Us, Santa or Other, and Picked TRUE or FALSE.
• Secret Santa: 30 participants, event settings, manual assignments, draw checks and spending limit checks.
• Gift History: 300 past gifts and reactions. The tracker flags a matching person and gift as Given before.
• Chart Data is a hidden helper tab for the five Dashboard charts.

𝗡𝗘𝗪: 𝗕𝗨𝗗𝗚𝗘𝗧 𝗔𝗡𝗗 𝗗𝗔𝗦𝗛𝗕𝗢𝗔𝗥𝗗

Give each person a budget. Spent counts Cost for Ordered, Bought, Wrapped, Shipped and Given gifts; Ideas and blank statuses are planned, not spent. Negative Left amounts are flagged in red. See Total Budget, Total Spent, Left to Spend and a budget chart for the first 30 people with a budget or spending. Everyone is still counted in the totals.

The rings count gifts Bought or further, Wrapped or further and Given. Set a holiday date, or leave it blank for December 25. The default date rolls to next year after Christmas. Pretend today is lets you preview another day.

Choose In person, Mail, Ship from store or Gift card or digital. Mailed gifts look up the person's address from People.

𝟐 𝗖𝗢𝗟𝗢𝗨𝗥 𝗧𝗛𝗘𝗠𝗘𝗦

Light and Dark are included in one purchase. Each is a separate file with identical features, plus its own filled sample. Choose the one you prefer.

𝗙𝗜𝗟𝗘𝗦 (𝟓)

1. START-HERE-Christmas-Gift-Tracker.pdf: opening instructions and quick start. Works in the free Adobe Acrobat Reader, Chrome or Edge.
2. Christmas-Gift-Tracker-Light.xlsx: blank Light workbook.
3. Christmas-Gift-Tracker-Dark.xlsx: blank Dark workbook.
4. Christmas-Gift-Tracker-Light-Sample.xlsx: filled Light sample with a fictional family.
5. Christmas-Gift-Tracker-Dark-Sample.xlsx: the same filled sample in Dark.

𝗪𝗢𝗥𝗞𝗦 𝗪𝗜𝗧𝗛

Developed for Google Sheets. An Excel file is included for the latest Microsoft 365 (Office 365 Desktop App). Older Excel versions may not support all features.

Use the matching Google Sheets copy link in Start Here, or upload an .xlsx to Google Drive and open with Google Sheets.

No macros, add-ons or Apps Script. Standard formulas recalculate your counts and totals.

ℹ 𝗚𝗢𝗢𝗗 𝗧𝗢 𝗞𝗡𝗢𝗪

The budget is light by design. Want a detailed holiday budget with spending log, Black Friday price tracker and meal plan? See our Christmas Budget Spreadsheet in the shop.

Sample names, addresses and gifts are fictional.

Formula cells are protected without a password. Filtering works while protected.

To sort, use Review > Unprotect Sheet (no password), sort the whole table, then Protect Sheet again.

For long entries, increase row height or use AutoFit Row Height.

Personal use only. Please do not resell or share the files.

Digital download only. No physical item will be shipped.

Utility Forge Studio is not affiliated with, sponsored by, or endorsed by Google or Microsoft.

Designed by me, created using AI tools.

The Etsy listing is the final source for what is included. See it on Etsy.