By the Planfolk team · Updated: October 2026
A Christmas budget is one total that you decide on first and then split two ways: by category (gifts, food, travel, decorations, cards and so on) and by person, with one gift budget for each name on your list. The person budgets have to fit inside the Gifts category, every purchase is logged against the plan, and partway through the season one more check shows whether the gifts still on your list fit in what is left.
Below we work through that method with the sample file from our own Christmas budget spreadsheet, as it reads on December 1, 2026. Every name, gift and dollar in it is fictional, made up to show the arithmetic. Please read it as an organizing example, not as a suggestion of how much to spend: the method is the same with your own numbers.
Start with one total, then split it by category
The total comes first because it is the number you decided you can spend on the holidays this year. The categories only divide it; they never add to it. In our example the total is $1,700.
We use 11 categories, and this is how the sample splits the $1,700:
- Gifts: $900
- Food & drinks: $220
- Decorations: $120
- Cards & postage: $45
- Wrapping & tags: $35
- Travel: $140
- Entertaining & parties: $60
- Outfits: $50
- Charity & giving: $40
- Experiences & outings: $60
- Other: $30
Gifts take $900 of the $1,700, which is 53% of this budget. That share is a choice the fictional family made, not a rule. A household that hosts the big dinner or flies across the country will tilt its own split toward food or travel. The point of the categories is to see where the money goes before it goes, so name them after your own holiday; in our sheet all 11 can be renamed.
Then split the gift budget by person
The Gifts category is still just one number, and "gifts" is really a list of people. Splitting it by person is what turns it into something you can shop with. The example has 13 names, each with a gift budget:
- Mom and Dad: $150 each
- Emma and Jake: $100 each
- Grandma Rose and Grandpa Joe: $60 each
- Lily and Noah: $50 each
- Sarah and Mia: $40 each
- Office Secret Santa: $25
- Ms. Parker, a teacher: $20
- The Millers, the neighbors: $25
The person budgets add up to $870. That is $30 under the $900 Gifts category, a little room for a forgotten name or a last-minute exchange. This is the check that matters at this level: the per-person budgets have to fit inside the Gifts category. If they add up to more, either someone's budget comes down or the Gifts line goes up, and then another category has to come down by the same amount to keep the total. Our sheet compares the two figures and warns you when the people add up to more than the category.
Gift ideas go on a list, not in the budget
A person's budget says how much; the gift list says what. Each idea gets its own row with who it is for, a planned price and, once it is bought, what was actually paid. The sample list has 20 gifts with a planned total of $745, and $585 has been paid so far. Each gift also carries a status that moves from Idea to Ordered, Bought, Wrapped and finally Given. A row stays an idea until you buy it, which keeps a wish list from turning into spending before you have checked it against the budget.
Writing a planned price next to every idea is the habit that makes the rest work. It is what lets the sheet compare a person's ideas with their budget before you shop, and it is what the projected total below is built on.
Reading the budget on December 1
Here is the sample as it stands on December 1, 2026, 24 days before Christmas. 14 of the 20 gifts are bought, and 8 of the 13 people are done.
- Spent so far: $965.23. That is $585 paid for gifts plus $380.23 of other spending: string lights and a wreath, cards and stamps, wrapping paper, train tickets, baking supplies, a toy drive donation, a sweater and ice skating tickets.
- Left to spend: $734.77 of the $1,700.
- Used: 57% of the total.
At 57% used with more than three weeks to go, the budget looks comfortable. But left to spend only counts what has been paid. It says nothing about the gifts that are still on the list.
The projected total
The projected total adds the planned price of every gift not paid yet to what has already been spent. In the example, four gifts are still ideas: a mystery novel set ($30), a hoodie ($45), warm slippers ($30) and a cozy socks bundle ($20). Their planned prices add up to $125, so:
$965.23 spent + $125 still planned = $1,090.23 projected total
That leaves $609.77 of the $1,700 once the planned gifts are bought. This is the number a plain list of expenses never shows. Left to spend tells you what is unspent; the projected total tells you whether what is still on your list fits. If it came out above the total, you would see it on December 1, while there is still time to swap a gift idea, rather than at the checkout a week before Christmas.
It counts gifts only. Food and parties that are not bought yet are not in it, so read the $609.77 with those open lines in mind: in the sample, Food & drinks still has $177.40 left and Entertaining & parties has its full $60.
Where the money goes
The dashboard chart shows how the $965.23 spent so far divides: gifts 61%, travel 10%, decorations 7%, experiences and outings 5%, food and drinks 4%, and everything else 13%. Gifts are 53% of the budget but 61% of the spending so far, because in this example most presents are already bought while most of the holiday food shopping is still ahead.
The category table also flags lines that are close to their limit. Cards & postage has used 90% of its $45 and shows "Almost there", with 24 days still to go. Small lines like this one are the ones that tip over quietly, because nobody watches a $45 budget.
If you are starting late or small
The method works with fewer lines. If it is already December, or the budget is small, three or four categories are enough: gifts, food, travel if there is any, and one line for everything else. Start with the people list, since gifts are usually the biggest part of the holidays (in our example they are more than half the budget), then give each person a number.
Two habits do most of the work:
- Decide the total before the first purchase. A total set after the shopping is a record, not a budget.
- Write a planned price for every idea before you buy it. That is what makes the projected total possible.
Keep a line for the small things, too. Cards, postage, wrapping paper and tags are the lines people forget; in our example they get $80 across the two categories.
Our Christmas budget and gift tracker
The screenshots above come from the sample file of our Christmas Budget & Gift Tracker spreadsheet. It has a Budget sheet with 11 categories you can rename, a People sheet for up to 60 names with a gift budget each, a Gift List for up to 300 gifts, an Other Spending sheet for everything that is not a gift, a Card List, and a Dashboard with the countdown and the projected total. It works in Excel and Google Sheets. You type in your own numbers; the sheet does the adding up and never suggests an amount. How downloads work explains what arrives after checkout.
If you would rather write it all by hand, our Classic Christmas holiday planner and its lighter Merry Pastel design are hyperlinked PDF planners with a holiday budget page and a gift list for 60 people. Nothing in them calculates: you write in your own figures. All three are in Holidays.
Questions
Is this financial advice?
No. This is an organizing example, not financial advice. The family, the names and every amount in it are invented to show the arithmetic. How much to spend on the holidays is your own decision.
What if I don't know my total yet?
Start from what you know. Last year's receipts and statements show what the holidays actually cost, or you can write a first gift budget for each person and add them up. Then set the total and split it by category.
Can I use the same budget next year?
Yes, in a fresh copy of the file, since the spending is not split by year. Copy this year's file, keep the category names and the people, and clear the gifts and purchases. This year's file stays as the record of what the holidays cost, which is a useful starting point for next year's total.
Written by the Planfolk team, who design Planfolk's planners and templates.