Free Christmas budget template for Excel and Sheets
Download a free family Christmas budget: meals, shared gifts, decorations, travel and 100 expense rows. Excel or Google Sheets, worked example, no signup.
On this page
To keep a family Christmas on budget, write down what you plan to spend together by category (meals, shared gifts, decorations, travel, drinks), then log each real purchase with the person who paid. This free template does it for you: six categories, 100 expense rows and the remaining budget calculated automatically.
Download the free template (.xlsx)
No signup or email required. Open the file in Excel or import it into Google Sheets to fill it in together. The example uses US dollars. The file does not calculate what each person owes; the example below works it out by hand.
Get started
- Open the file in Excel or import it into Google Sheets.
- In Budget, enter the number of people sharing the costs and edit the blue cells.
- In Expenses, clear the five examples without deleting the rows. Then log shared purchases as they happen.
What is in the file?
Budget holds your plans: meals, shared gifts, decorations, travel, drinks and other costs. The sheet calculates spending by category, the amount remaining and an average per person. A negative remainder means spending has gone over the plan.
Expenses records the date, category, description, person who paid, amount and notes. There are 100 input rows, from row 7 to row 106. Keep the category names unchanged so the dropdown and summary continue to match.
What belongs in the shared budget?
Only what the group pays for together. The present you give your sister stays out of the sheet; the joint gift for the grandparents goes in. Travel works the same way: if each household pays its own train, leave it out. If the family covers the grandparents' tickets, log them. Settle this before the first purchase, not on December 26.
Example: a $1,300 budget for six people
These are the fictional figures in the file, not a price guide for a holiday dinner. Replace them with your own amounts. Remaining is the planned amount minus recorded spending.
| Category | Planned | Spent | Remaining |
|---|---|---|---|
| Meals | $500 | $468 | $32 |
| Shared gifts | $300 | $240 | $60 |
| Decorations | $80 | $72 | $8 |
| Travel | $200 | $180 | $20 |
| Drinks | $150 | $120 | $30 |
| Other | $70 | $0 | $70 |
| Total | $1,300 | $1,080 | $220 |
The $220 remaining is room in the budget, not money held in a shared account. If dessert or bread is still to buy, take it out of that margin before treating the rest as spare.
How do I use it in Google Sheets?
Download the file, open a spreadsheet in Google Sheets, then choose File → Import → Upload. Select the workbook, choose to create a new spreadsheet and import the data. Both tabs come with the file. Google documents this in its guide to importing Excel files.
Share one working copy with the family. Before entering your own figures, check that the example shows $1,300 planned, $1,080 spent and $220 remaining. Agree who logs what so the same groceries are not entered twice.
Record each cost once
If Claire pays $468 for the Christmas Eve groceries, record $468 once. When Inès sends her share, that transfer is a repayment, not another expense. For an item returned to the store, enter a negative amount in its original category.
An average is not everyone's share
Children often pay nothing, a couple may count as one share, and relatives who only come for lunch on the 25th may not share the Christmas Eve dinner. The template's average helps you plan; it does not allocate those cases. Read how to split the cost of Christmas dinner and how to set a budget for a group gift. For a gift exchange with a draw, see the Secret Santa rules.
Who pays whom in this example?
In the file, Claire paid for the Christmas Eve groceries ($468) and the tree and decorations ($72), Paul for the grandparents' gift ($240) and the drinks ($120), Marc for the grandparents' train tickets ($180). Assume all six people share everything equally and no repayments have been made. $1,080 divided by six is $180 each.
| Person | Paid | Share | To receive or repay |
|---|---|---|---|
| Claire | $540 | $180 | Receives $360 |
| Paul | $360 | $180 | Receives $180 |
| Marc | $180 | $180 | Nothing to settle |
| Inès, Léo and Zoé | $0 | $180 each | Repay $180 each |
Inès and Léo each pay Claire $180, and Zoé pays Paul $180. Claire receives $360 and Paul $180, and everyone is settled. The workbook does not calculate these repayments; this table explains the example.
Budget in the sheet, balances in Spliz
- Create a Christmas group in Spliz and send its link to the family.
- Add each expense with the person who paid and the people it covers. Leave out anyone who did not take part in that expense.
- Check the balances, repay by bank transfer, in cash or with another app, then record the repayment. Recording it does not move money.
Use Spliz for event expenses. The app is free. Family members can join the group as guests without creating an account, after installing the app. The file does not sync with Spliz: keep the sheet for planning and one shared record for the expenses.
What if a total looks wrong?
Check that amounts are numbers, not text, and that the number of people is a whole number between 1 and 100. The Budget tab flags invalid inputs. An amount with a missing or unknown category appears under Uncategorized and still counts toward spending. Check that you have removed the sample expenses and stayed within the 100 input rows.
This is an editable planning file, with no macros, external data connections or payments. Keep a clean copy before changing its formulas.
Download the Christmas budget (.xlsx)
Sources and method
- Google Sheets: import an Excel workbook, instructions for importing both tabs.
- The tables reproduce the figures in the downloadable Spliz workbook. All people and amounts are fictional.
Put the numbers into practice. Track what each friend paid in Spliz.

