Home › Christmas Budget Spreadsheet (Australia)
Christmas Budget Spreadsheet (Australia)
Plan gifts, food and events against one Christmas budget, in A$, in Excel or Google Sheets.
A spreadsheet keeps every person, gift and amount in one place, so there are no duplicate gifts or January surprises.
Example: an Aussie family Christmas budget
| Bucket | Example amount | Share |
|---|---|---|
| Kids' gifts | A$500 | 33% |
| Extended family (Kris Kringle) | A$150 | 10% |
| Teacher & coach gifts | A$60 | 4% |
| Christmas Day food & drinks | A$350 | 23% |
| Events & school breakup | A$120 | 8% |
| Wrapping, cards, postage | A$70 | 5% |
| Travel / fuel | A$250 | 17% |
| Total | A$1,500 | 100% |
Example only. Set your own total first.
Example: paydays to go
| Paydays left (fortnightly) | Per pay for A$1,500 |
|---|---|
| 4 | A$375 |
| 6 | A$250 |
| 10 | A$150 |
| 26 (start in January) | A$57.69 |
Starting earlier makes each pay smaller. See the Christmas checklist.
General information only, not financial or tax advice.
How do I set a Christmas budget?
Choose one total you can save without credit, then split it into gifts, food, events and travel.
How much per pay do I need?
Divide your total by the paydays left before Christmas.
Does it work in Google Sheets?
Yes, in Excel and Google Sheets.
Try it in an app
Party Budget Planner (A$19, one-off): Christmas parties, birthdays and get-togethers: budget, shopping list, guests and a countdown for each event.
Fortnightly Budget Dashboard (A$29, one-off): Plan every payday: bills smoothed across fortnights, a tick-off payday planner, three-pay months and savings goals.