sheetfolk

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-C7 in 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.

Buy for $15 See what's inside

Written with AI-assisted research and drafting under our direction, based on sheetfolk's own templates and pricing. Not financial advice.