Published · Updated · sheetfolk guides
Holiday Spending Tracker in Google Sheets: Gifts, Travel and Food Without a January Surprise
Set up a holiday budget in Google Sheets with five categories, four formulas and a spending log, so you know the total before the card statement arrives.
Set up the budget sheet
Open a new Google Sheet and name the first tab Holiday. Put these headers in row 1:
| A | B | C | D | E |
|---|---|---|---|---|
| Category | Budget | Spent | Remaining | Status |
List five categories in A2:A6: Gifts, Travel, Food and hosting, Decorations, Cards and postage. Type a budget for each in B2:B6.
Then add these formulas:
- D2:
=B2-C2(fill down to D6). It shows what is left in each category. - E2:
=IF(C2>B2,"Over budget","On track")(fill down to E6). It flags a category only when spending is higher than the budget. - Row 7, totals:
=SUM(B2:B6)in B7,=SUM(C2:C6)in C7 and=B7-C7in D7.
Add a spending log
Create a second tab called Log with the headers Date, Category, Amount and Paid with in A1:D1. Every purchase goes in one row. Use the same category names you used on the Holiday tab.
Back on the Holiday tab, replace the typed numbers in column C with a lookup. In C2, enter:
=SUMIF(Log!B:B,A2,Log!C:C)
and fill it down to C6. Now each purchase you log updates its category automatically, and you never type a total by hand.
See what will land on your card
The part that causes a January surprise is the amount you put on a credit card. On the Holiday tab, add a label in A9, To pay on card, and this formula in B9:
=SUMIFS(Log!C:C,Log!D:D,"Card")
Type exactly Card in the Paid with column for every card purchase. Compare B9 with the money you have set aside to clear the statement.
Worked example
Suppose the budget is 1,000 in total: Gifts 400, Travel 300, Food and hosting 200, Decorations 60, Cards and postage 40. After a month of logging, the Spent column reads 380, 310, 150, 45 and 40.
| Category | Budget | Spent | Remaining | Status |
|---|---|---|---|---|
| Gifts | 400 | 380 | 20 | On track |
| Travel | 300 | 310 | -10 | Over budget |
| Food and hosting | 200 | 150 | 50 | On track |
| Decorations | 60 | 45 | 15 | On track |
| Cards and postage | 40 | 40 | 0 | On track |
| Total | 1,000 | 925 | 75 |
Travel is the only category over budget, by 10. The total is still 75 under, so you can cover travel from the Food and hosting surplus or leave it as a small overrun. Either way you made that choice in November instead of finding it in January.
A common mistake
Do not set the Gifts budget by guessing a total. List each recipient with a planned amount on a separate tab, then set the Gifts budget to the sum of those amounts with =SUM('Gift list'!B2:B20). A budget built from names is easier to hold to than one built from a round number.
Related guides
If you save a little each month for the holidays, the sinking funds calendar shows how to schedule those contributions. For more SUMIF and IF patterns, see the guide to Google Sheets budget formulas.
Template for this guide
2026 Ultimate Budget Bundle
Monthly budget, paycheck planner, debt payoff, net worth and a yearly dashboard in one Google Sheets and Excel workbook. Browse every tab before you buy. One-time price, no subscription, free updates to the current-year edition.