Christmas gift tracker printable: a budget per person, every gift tracked
Short answer
Write one row per person with a budget, then one line per gift: idea, where to buy, price, bought, wrapped. Spent = sum of prices bought; Left = budget minus spent. Add up the per-person budgets first and compare with what you can spend in total, so you cut the plan before the shopping, not after.
- List everyone you buy for, including teachers, hosts and stocking fillers.
- Give each person a budget and check the total against your overall holiday budget.
- For each gift write the idea, the shop, the price and a status: idea, ordered, arrived, wrapped.
- Check it weekly: left to spend, gifts not yet bought, and parcels still to arrive.
Copy-paste code
Spreadsheet formulas (Excel or Google Sheets)
Spent per person: =SUMIFS(D:D, A:A, "Mum", E:E, "<>Idea")
Left per person: =B2 - Spent
Total spent: =SUMIF(E:E, "<>Idea", D:D)
Still to buy: =COUNTIF(E:E, "Idea")
Days to Christmas: =DATE(2026,12,25) - TODAY()| Person | Budget | Gift | Price | Status |
|---|---|---|---|---|
| Mum | $60 | Cookbook + apron | $48 | Wrapped |
| Sam (8) | $50 | Art set | $35 | Ordered |
| Teacher | $15 | Gift card | $15 | Idea |
| Stockings | $40 | Small treats x4 | $22 | Bought |
Source: example household, made-up numbers
What else goes in a Christmas planner
Beyond gifts: a card list (who, sent, received), a food plan for Christmas dinner with a cooking timetable, a December calendar for events and school dates, and a countdown for kids. Christmas Day 2026 is a Friday.
Good to know
Order online gifts early in December; carriers publish their own last shipping dates each year.
Jolly List Christmas Planner & Gift Tracker: Every gift and every dollar, sorted
from $5.99Jolly List does this for you: a Christmas gift tracker and holiday budget for Excel and Google Sheets (budget per person, status of every gift, countdown) plus a 23-page printable planner with a dated December 2026 calendar, menus and a card list. $5.99.
Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)Questions
Printable or spreadsheet?
A spreadsheet adds things up for you; a printable sits on the fridge. Jolly List gives you both.
Can two people share it?
Yes, put the spreadsheet in Google Sheets and share it.
Free: the Free Planner Sampler
4 printable previews (budget, debt payoff, focus planner, habit tracker), then 5 short emails with formulas that make a budget stick.