Christmas budget spreadsheet UK: planner, tracker and template columns

A Christmas budget spreadsheet (planner, tracker or template — search boxes use all those words) keeps category limits, what you have spent and what is left in one Excel or Google Sheets file you reopen all season. This guide shows practical columns, a spending log, gift-per-person limits, a payday savings plan, simple formulas and how the spreadsheet differs from the free live calculator and our method guides. It is a planning method, not financial advice. For a free browser total with no download, use the Christmas budget calculator instead.

What this guide is (and is not)

Spreadsheet vs live calculator vs family-budget method vs how-to-save guide

ToolWhat it doesUse it when
Live calculatorTotals gifts and other costs, subtracts what you have saved, shows how much per payday. Nothing is stored.You want a quick figure before shopping lists firm up
Family Christmas budget guideMethod: set a total you can pay, gift limits by group, food, travel and how to avoid January debt.You need the decisions, not the file layout
How much to save guideFridays and paydays left before Christmas 2026, last payday, worked weekly examples.You already have a total and need the schedule
Budget spreadsheet (this page)Reusable Excel or Sheets file: category budgets, spending log, gift limits and a savings tracker you update as you buy.You want one household source of truth all season

A simple flow: set the total with the Christmas budget calculator and the family Christmas budget method, plan the weekly or payday amounts with how much to save for Christmas, then keep the live numbers in the spreadsheet.

Columns for a Christmas budget spreadsheet

One row per category. Rename categories to match your household.

ColumnWhat goes in it
CategoryGifts, food & drink, Christmas dinner, decorations & tree, cards & postage, wrapping, going out, travel, outfits, charity, other
Budget (£)Limit you set before shopping for that category
Spent (£)What you have actually paid so far (often summed from the spending log)
Left (£)Budget minus spent
% usedSpent ÷ budget (optional; handy for a traffic-light status)
Notes"Shop Wed 23 Dec", "includes Secret Santa", "travel shared with Mum"

Put a dashboard at the top: total budget, spent so far, left to spend, % used, and (optional) days to Christmas. Count days with the free days until Christmas page if you prefer not to calculate them in the sheet.

Gift budgets: a limit per person

Most Christmas overspend happens one present at a time. A separate gift tab (or section) keeps a limit next to each name:

For present ideas, bought/wrapped status and online orders, pair this with the Christmas gift tracker UK guide, the free Christmas gift list, or the Christmas Gift List Tracker (£2.99).

Spending log columns

One row per purchase. This is what keeps the category "Spent" column honest.

ColumnWhat goes in it
DateDD/MM/YYYY
ItemWhat you bought
CategorySame list as the budget sheet (drop-down helps)
PersonOptional — for gift lines, who it is for
Amount (£)What you paid
ShopWhere you bought it
Paid?Yes / No — or Cash / Debit / Credit card / Buy now pay later
NotesOrder number, return-by, "split with Alex"

Illustrative sample rows (made-up)

The rows below are made-up examples to show the layout. They are not typical spends, averages or a recommended Christmas budget.

CategoryBudgetSpentLeftNotes
Example — Gifts£200£85£115Four people left to buy for
Example — Food & drink£120£40£80Main shop still to do
Example — Travel£50£0£50Train tickets mid-December
Example — Cards & postage£25£18£7Second-class stamps bought

Made-up spending-log examples: 02/11/2026 · Cookbook · Gifts · Mum · £22 · High street · Paid; 09/11/2026 · Fairy lights · Decorations · — · £12 · Supermarket · Paid.

Payday or weekly savings plan columns

Once you know the total still to find, track how you will get there:

Boxing Day 2026 falls on Saturday 26 December, so the Boxing Day bank holiday in England and Wales is the substitute day on Monday 28 December 2026 (GOV.UK bank holidays). That long weekend affects shop opening hours more than the savings plan itself — finish the main food shop before Christmas Eve if you can.

Simple formulas for Excel and Google Sheets

Both programs use the same formulas here. Assuming budget is in column B, spent in C and left in D for row 2:

Excel or Google Sheets? Google Sheets is easier if two of you update it from your phones; Excel suits one person. An .xlsx file opens in both: upload it to Google Drive and use File › Save as Google Sheets.

How it pairs with gift tracker, dinner planner, to-do list and countdown

Printable vs Excel / Sheets / app

DIY sheet vs ready template

More: Christmas gift list spreadsheet UK · Christmas budget calculator · family Christmas budget · how much to save for Christmas · Christmas gift tracker UK · Christmas to-do list UK · days until Christmas · Christmas gift list · January budget reset · household budget spreadsheet UK

Free tools for this

Frequently asked questions

What columns should a Christmas budget spreadsheet have?

Category, budget £, spent £, left £, optional % used and notes. Add a spending log (date, item, category, amount, shop, paid?) and a gift tab with a limit per person. Put total budget, spent, left and % used at the top.

Is there a Christmas budget spreadsheet template for Excel or Google Sheets?

Yes. You can build the columns in this guide yourself, or use our Christmas Budget Planner: an Excel and Google Sheets template with category budgets, a spending log, gift limits per person and a payday or weekly savings plan, in £ with UK dates.

What is the difference between a Christmas budget spreadsheet and the Christmas budget calculator?

The calculator totals gifts and other costs and shows how much to save per payday, but saves nothing. The spreadsheet is the working file you update as you spend. Use the calculator first, then the spreadsheet.

How do I make a Christmas budget tracker in Google Sheets?

Copy the category and spending-log columns into a blank Google Sheet, use SUMIF to pull spent totals from the log, and add a savings plan tab with each payday or Friday. An .xlsx template can be uploaded to Drive and saved as Google Sheets.

How do I track Christmas spending by category?

Log every purchase with a category, then sum amounts per category with SUMIF (or enter spent by hand). Compare spent with each category budget and watch left £ before the next shop.

Should I use a Christmas budget planner or a gift list?

A gift list tracks who you buy for and whether presents are bought or wrapped. A budget planner tracks the money across gifts, food, travel and the rest. Many households use both.

Can I make a free Christmas budget spreadsheet?

Yes. Copy the columns and formulas from this guide into a blank Excel or Google Sheets file. The free Christmas budget calculator will give you a starting total and payday amount to use as your targets.

Is the Christmas Budget Planner financial advice?

No. It is a fill-in Excel and Google Sheets planning template that tracks what you enter. This guide is not financial advice either — set limits you can afford without borrowing or missing bills.

Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.