Tested Templates & Toolstested before it ships

● Free tool · personal finance

Christmas budget calculator: how much to save each month

List who you're buying for with a budget and what the gifts will cost, add food, travel and decorations, and see what's left, who's over budget, and how much to put aside each month until the holiday.

✓ TestedSame calculation as the tested spreadsheet
Save each month–
Gifts (expected)
Other costs
Expected spending
Left in the budget
Still to save
People over their budget

How it works

Expected spending is every person's gift cost plus the other costs. What's left is your total budget minus that. The amount you need by the day is the larger of the two (if the plan runs over budget, you still have to pay for it), minus what you've already saved; divide it by the months left to get the monthly amount. Months left counts from next month to the holiday month, so each month's saving comes out of a paycheck you haven't spent yet: from late September to 25 December that's October, November and December. Someone is over budget when their gifts cost more than the budget you set for them.