Free template, no sign-up

Free Christmas gift list and budget tracker

Who, clue, budget, gift, status, done. Copy it into Google Sheets, Excel or Numbers.

Giftin profile for Sarah with her interests and birthday in 30 days
The template

A Christmas gift list should tell you what is left to decide, buy and finish without making you rebuild the season from browser tabs. A good list shows six things at a glance: who, clue, budget, gift, status and done.

Blank Christmas gift list
Blank Christmas gift list with columns for person, clue, budget, gift, status, done and actual spend
PersonUseful clue / wishlistBudgetGift / ideaStatusWrapped / doneActual spend
 
 
 
 
 
 
The copy and download versions have 20 rows and add up the Budget and Actual spend columns for you. Paste into Google Sheets, Excel or Numbers. No sign-up, no email.

What a filled-in version looks like

Example Christmas gift list with four people
PersonUseful clue / wishlistBudgetGift / ideaStatusWrapped / doneActual spend
MumWants to replace old gardening gloves; hates clutter$60Good gloves and favourite bulbsBoughtNo$52
DadKeeps talking about a local history book$45Book from the local shopArrivedYes$40
SarahAsked for no objects; wants a day together$80Lunch and exhibition ticketsBookedN/A$72
LeoExact game on his wishlist$40The gameNeed to buyNo

What each column is for

  • Person: one person, one row. Organising by store or order makes the list harder to finish.
  • Useful clue / wishlist: the exact item, “no scented products,” a size, a favourite shop, a life change or a wishlist link. This is the column that stops the gift field starting from zero.
  • Budget: set it before browsing. It is a planning boundary, not a score for how much you like someone. How to set it.
  • Gift / idea: rough ideas are allowed. “Concert tickets if the date works” is more useful here than in one of five browser tabs.
  • Status: use a small fixed set, such as Idea → Need to buy → Ordered → Arrived → Finished.
  • Wrapped / done: bought and finished are not the same thing. If you do not wrap, use the real final step: shipped, card written, booking sent or delivered.
  • Actual spend: add the final amount when you pay, so you can compare it with the budget.

Add only the extra columns you need

Store / linkOrder number or delivery dateGift receiptShared / claimed by

Order numbers help when you order a lot online. For six gifts, you can skip them.

Keep four budget totals

  1. Total Christmas budget. Everything you can comfortably spend on the season.
  2. Gift budget. What remains after food, travel, events and other seasonal costs.
  3. Planned gifts total. The sum of your per-person budgets.
  4. Actual gift spend. What you have really spent so far.

The warning that matters is not “you spent $14 more on Dad.” It is this:

Your planned list now exceeds the total amount you said you could afford.

Update the list at three moments

When a clue appearsAdd the clue

You do not need the gift yet.

When you buy somethingUpdate it now

Gift, actual price and status, so an ordered item leaves your mental “not done” pile.

Once a week in DecemberLook only at blockers

No idea, need to buy, delivery risk, needs wrapping.

Hide finished rows until it is time to give the gifts. Keep the list focused on what still needs doing.

Gift ideas for everyone on the list

Stuck on the gift column for someone? Find their row below and grab a few ideas.

Spreadsheet, Notes or Christmas planner?

Budgets, totals and status

Use a spreadsheet

If you already know most of the gifts, a spreadsheet is hard to beat.

Five or six people

Use Notes

“Mum / $60 / gloves / bought / wrap.” If you keep it updated, that works.

Shared lists and parcels

Use a planner app

Family wishlists, secret claims, Secret Santa and parcel tracking. See the Christmas planner comparison.

Where Giftin fits

Giftin is useful before and between Christmas shopping seasons. It keeps the person, important dates, interests, things to avoid, past gifts and saved ideas together across the year. That helps with the hardest column in the template, the first one after the name: what do I actually know that could help?

Giftin…

Person memory, ideas and past gifts, all year.

Your Christmas list…

Budget, shopping status and wrapping, for December.

For tracking parcels and wrapping, use this list or a Christmas planner app.

Saved gifts for Steve in Giftin: two ideas to buy and one gift already given
To buy, bought, given. The same three columns, kept per person instead of in one sheet.

A better way to start next Christmas

When Christmas is over, keep the information that survives the season: what you gave each person, what worked, useful sizes or preferences, things they said they do not want, and good ideas you did not use.

Those belong with the person, in Giftin or wherever you keep notes. The ordered, arrived and wrapped columns can go once the season is over. Next December, you start with what you learned instead of an empty list.

Keep what you learned for next year.

Past gifts, sizes and the things they said they wanted, next to the person. Free, for as many people as you want.

Download Giftin