Blog

Holiday spending plan worksheet to set your total before the sales start

List every holiday cost, fix a total, split it between saved cash and a card, and time it to statement dates, with a worked $1,540 example and a blank copy.

Black Friday falls on November 27 this year, eleven days from the date this was written, and the sales emails have already started. The usual way people overspend in December is not one big splurge. It is dozens of small, reasonable purchases made one at a time, each of which felt fine, with no one number to stop at. The cure is boring and works: decide the total before the sales begin, and decide how it will be paid.

This worksheet does that in seven steps. It uses a fully worked, labeled example with round numbers, and then gives you a blank copy. Nothing in the example is a recommendation about how much anyone should spend. The right total is whatever fits your own cash flow.

Step 1: List everything the holidays cost you

Most people budget for gifts and forget the rest. Start by writing down every kind of holiday cost, using last year's statements as a prompt. Open your card and bank statements for November through January and scroll through them. You will find things you did not think of.

A starting list:

  • Gifts, one line per person or group.
  • Travel: fuel, flights, a night in a hotel, parking, a rental car, pet boarding.
  • Food and hosting: the meal itself, drinks, extra groceries, a party.
  • Events and cards: tickets, a school or office exchange, cards, postage, shipping charges.
  • Decor and wrapping: lights, a tree, paper, tape.
  • Giving and tipping: charity, a tip for a regular service provider, a teacher or neighbor's present.
  • Surprises: a last-minute gift, an item that gets lost in the mail and must be replaced, a guest who arrives with a family.

The last category is the one that blows budgets. That is why step 3 adds a cushion.

Step 2: Choose the total from the top down

Set the total before you price anything. A total built from the bottom up, by adding up whatever you think you want to buy, tends to grow. A total set from the top forces the list to fit. Three ways to choose it:

  1. From cash flow. Look at what you can spend between now and the first statement due date in January without leaving any card balance unpaid. That is a ceiling.
  2. From last year. Add up the actual holiday spending on last year's statements, then decide to match it, cut it or let it rise. Do not use memory for this, because memory is usually lower than the statements.
  3. From a share of income. Pick a percentage of one or two months' take-home pay and hold to it.

Say a household picks method one and decides it can safely spend $1,540. The next step shows how it gets there.

Step 3: Fill in the plan table

Write a line for each category, then add a cushion. A common size for the cushion is about 10 percent of the subtotal, enough to absorb a few surprises.

Category Planned amount
Gifts (eight gift lines, see below) $520
Travel (fuel and one hotel night) $340
Food and hosting $260
Events, cards and postage $120
Decor and wrapping $60
Giving and tipping $100
Subtotal $1,400
Cushion (10 percent of $1,400) $140
Total plan $1,540

Check the arithmetic: $520 + $340 + $260 + $120 + $60 + $100 = $1,400, and $1,400 × 0.10 = $140, so the total is $1,540.

The gift line breaks down by person:

Gift line Amount
Mom $90
Dad $70
Sister $80
Brother's family $90
Two nieces ($40 each) $80
Friend exchange $50
Coworker exchange $30
Teacher gifts $30
Total $520

That sums as $90 + $70 + $80 + $90 + $80 + $50 + $30 + $30 = $520. The point of a per-line cap is that you can see a gift costs more than its line while you are still in the store, and choose what to do about it.

Step 4: Decide how each dollar will be paid

For every dollar in the plan, decide whether it comes from saved cash or from a card. This is the step that keeps a December purchase from turning into a January balance.

Say the household has been setting aside money since summer and has $900 saved for the holidays. The card has to cover the remaining $640 ($1,540 − $900).

A useful rule for the card portion: only charge what next month's income will pay off in full. If the household takes home enough in December and January to pay a $640 statement balance and still cover its other bills, then the card portion is a convenience. If it would have to carry part of the $640 into February, the plan is too big or the saved portion too small.

Here is what carrying costs, at an illustrative 24% APR. If the household pays only half of the $640 and carries $320, interest is about $6.40 a month ($320 × 0.24 ÷ 12). If it carries all $640, interest is about $12.80 a month ($640 × 0.24 ÷ 12). Those are modest numbers, but they come with a second cost: on most cards, carrying a balance also means new purchases lose their interest-free period. The grace period depends on paying the previous statement balance in full by the due date, so one partially paid statement can make every new purchase accrue interest from the day it posts.

Pace the plan through the season

A total is easier to keep when it has checkpoints. Schedule when each category is likely to be bought, and add up what should have been spent by each date. In the example, the household expects to buy decor and half of its gifts around the sale weekend, the rest of the gifts and the events in the first part of December, and the travel and food in the days before the holiday.

By this date What is bought Spent in the period Cumulative
November 30 Decor ($60) and early gifts ($260) $320 $320
December 12 Remaining gifts ($260) and events ($120) $380 $700
December 24 Travel ($340) and food ($260) $600 $1,300
December 31 Giving and tipping $100 $1,400

The cushion of $140 stays unspent unless a surprise uses it. Checking: $320 + $380 + $600 + $100 = $1,400.

Now read the table against the funding split. If the household spends its $900 of saved cash first, the cash runs out between December 12 (cumulative $700) and December 24 (cumulative $1,300), and the card is touched for the last $400 of the December 24 batch plus the $100 after it. That is $500 on the card if the cushion is never used ($1,400 − $900), and $640 if all of it is ($1,540 − $900). So the card portion is a range, and the plan should be able to clear the top of it.

This pacing view also shows when to stop and think. If cumulative spending on December 12 is already $900 instead of $700, you know on that day, not on January 13, that something ran ahead of the plan.

Step 5: Match purchases to your statement dates

Because a card statement covers a billing cycle, the date you buy something decides which statement it lands on, and so when it is due. Use your own closing and due dates; the dates below are labeled illustrations.

Say the card's statement closes on the 19th of each month and its payment is due 25 days later. Then:

  • Purchases from November 20 to December 19 appear on the statement that closes December 19, due January 13.
  • Purchases from December 20 to January 19 appear on the statement that closes January 19, due February 13.

A gift bought on December 18 is due January 13; the same gift bought on December 21 is due February 13, about a month later. That timing is real, and some people use it to line a purchase up with a paycheck. The risk is losing track: two statements arrive close together, and the total of what is owed is spread across two due dates. Keep one running list rather than relying on each statement. The mid-cycle payment calculator shows how the closing date and the due date shape what you owe and when, and why your card budget should follow the statement cycle, not the calendar explains how to build the whole budget around the cycle.

Step 6: Set guardrails before you shop

Guardrails are rules you set when you are calm that you will follow when you are not.

  1. Write the total and the funding split somewhere you will see them. A sticky note on the card or a note at the top of a phone list works.
  2. Track as you go. After every purchase, subtract it from its category line. Check the running total weekly, and note when a category is 80 percent used.
  3. Turn on card alerts for purchases above a set amount and for balances, if your issuer offers them.
  4. Do not open a new card for a checkout discount unless it is part of the plan. A store card's 20 percent off can be worth it or not; A store card offers 20 percent off at checkout. Should I take it? works out when.
  5. Do not stack buy-now-pay-later plans on top. Several short plans across several providers are easy to lose track of. holiday gifts on a card or on buy now, pay later, side by side sets out the costs and protections side by side.
  6. Hold the cushion. If the cushion is gone before December 15, stop. It is the signal the total was too tight, not a reason to spend more.
  7. Plan for returns. If a gift is returned, the credit goes back to the card and reduces the statement later. Do not spend it twice.

For the sale weekend specifically, Black Friday and sale events on a card, a checklist for returns and protections covers return windows, protections and how to follow pending charges.

Four patterns that quietly inflate a holiday total

Knowing the usual leaks helps you spot them in real time.

  • The "while I'm here" add-on. A second item at the register, a small stocking stuffer, a gift for someone who gave you something unexpectedly. Each is small. Ten of them are a real line in the budget, and your plan should have a line called "extras" for them rather than leaving them to the cushion.
  • Buying to reach free shipping. Spending an extra $15 on something you did not plan to qualify for free shipping on a $40 order costs more than the shipping would have. Compare the shipping fee with the price of the filler item before you decide.
  • Gifts for yourself. Sales are designed to make you want things. Put a small, explicit line in the plan for yourself, or decide to skip it; either is better than an unplanned purchase that happens to be on sale.
  • Free trials that renew. A streaming or delivery trial started for a holiday weekend can renew at full price after the season ends. If you start one, set a reminder for the day before it ends and note it in your plan; a subscriptions audit worksheet for the recurring charges on your cards shows how to find recurring charges later.

None of these is a character flaw. They are what a sales season is built to produce, and a written plan is how you stay ahead of it.

Step 7: Plan the January check-in

Put a date in your calendar for the day after the first January statement closes. On that date:

  1. Compare the actual total with the plan, category by category.
  2. Pay the statement balance in full by its due date, if the plan worked.
  3. If it did not, write down which category ran over and why, and what you will change next year.
  4. If a balance remains, use the next step in january after the holidays, a month-by-month plan to clear card balances to decide the order of payments.

A plan that is checked once a year gets better every year. A plan that is never checked is a hope.

Your blank worksheet

Copy this onto paper or into a spreadsheet.

Category Last year (from statements) This year's plan Actual so far Remaining
Gifts
Travel
Food and hosting
Events, cards, postage
Decor and wrapping
Giving and tipping
Cushion (about 10 percent)
Total

Then answer four questions in writing:

  • Total plan: $____
  • Paid from saved cash: $____
  • Paid on a card, to be cleared by the first January due date: $____ (this should equal total minus cash)
  • Statement closing date: ____ and due date: ____

If the card portion is larger than you can clear in full by the first January due date, change one of three things: the total, the cash set-aside, or the timing. Do not change the rule.

When money is already tight

If you are already carrying card debt, the plan above still helps, but its rules change. The cash portion should be smaller than the card portion only if you have a way to clear the card portion; otherwise, a smaller total is the honest answer. Think of the holidays as a budget line like any other, not as an exception, and leave your emergency fund alone; it exists for the job loss or the car repair, and a holiday that drains it leaves the next surprise to land on a card. It is also fine for a gift to be a letter, a favor or time, and for a family to agree on a lower limit or draw names.

If you are behind on payments, or cannot see a way to clear what you already owe, do not add to it. Call the number on the back of your card about a hardship program, and consider a nonprofit credit counselor. A holiday is not worth a debt that follows you through the spring, and no one who loves you wants a gift bought that way.

Key takeaways

  • Choose the total from the top down before the sales begin; a total built from a shopping list grows to fit the list.
  • List every holiday cost, including travel, hosting, shipping and tips, and add a cushion of about 10 percent; in the worked example, $1,400 plus $140 gave a $1,540 plan.
  • Split the plan between saved cash and the card, and charge only what the next month's income will clear in full; in the example, $900 saved left $640 for the card.
  • Your closing and due dates decide when each purchase is owed: in the illustration, a gift bought December 18 is due January 13 and one bought December 21 is due February 13.
  • Check the plan in January, pay the full statement balance if you can, and carry any shortfall into a payoff plan rather than letting it drift.

Terms used in this article

Related tools

Latest on this topic