Shop · Budget and Money

Christmas Budget & Gift Planner: photo 1 of 5 from its Etsy listing
Budget and Money

Christmas Budget & Gift Planner

Christmas Gift Tracker and Budget Planner UK, Gift List Spreadsheet by Person, Christmas Food Shop and Card List, Excel & Google Sheets

£6 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

Christmas creeps up: a present here, panto tickets there, the big food shop the week before. Put your budget in once, list everyone you're buying for and what you've planned, and this spreadsheet keeps the running total for you.

It shows what you've spent, what's still to pay, and how much to put aside each week between now and Christmas. It also adds up anything on a credit card or pay later, so January's bill isn't a surprise.

Christmas Budget & Gift Planner: photo 2 of 5Christmas Budget & Gift Planner: photo 3 of 5Christmas Budget & Gift Planner: photo 4 of 5Christmas Budget & Gift Planner: photo 5 of 5

What's inside (8 tabs)

  • Start Here: Your budget, eight live totals and a weekly saving plan
  • Gift List: Every gift: budget, cost, bought, wrapped and given
  • People: Totals for each person and group, and who's over budget
  • Budget: Planned v spent for gifts, food, decorations, cards and the rest
  • Spending: Everything else you spend, with credit card and pay later added up
  • Food Shop: The Christmas food list by day, and what's still to buy
  • Cards: Who you're sending cards to, and how many stamps you need
  • Guide: How to use it, in plain English

What it does

  • Gift list by person: budget, actual cost, bought, wrapped and given
  • Totals for each person and group, and who's over budget
  • Save each week: what's still to pay, less what you've saved, over the weeks left
  • Plan v spent for food, decorations, cards, wrapping, going out, travel and clothes (rename any line)
  • Credit card and pay later spending added up separately, for January
  • Food shop list by day and a card list that counts the stamps you need

What you get

  • christmas_planner.xlsx with example data, so you can see how it works
  • christmas_planner_blank.xlsx: the same file, empty and ready for your own
  • A step-by-step PDF setup guide

What you need

  • Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
  • OR a free Google account to use it in Google Sheets (the guide shows you how)
  • Best on a computer or tablet. Not made for Apple Numbers

Please note

  • This is a digital download. No physical item will be sent
  • The example family and prices are made up. Not financial advice
  • For your own personal use. Please don't resell or share the file

How it's made

Designed by me, built with the help of AI tools, then checked formula by formula in two different spreadsheet programs.

Christmas Budget & Gift Planner £6
Buy on Etsy