Christmas Gift Tracker Spreadsheet

Keep Christmas shopping and spending in one spreadsheet. List everyone you buy for with a budget each, log every gift idea with where to buy it and the price, and move it along from idea to ordered, bought, wrapped and given. Each person's spent and left fill in by themselves, the holiday budget covers food, decorations, travel and hosting too, and one dashboard shows the days to go, what is left to buy and who is over budget.

WHAT YOU GET

• Christmas Gift Tracker and Holiday Budget (Excel, opens in Google Sheets): Start here, Dashboard (days to go, gift budget, spent, left, people over budget, gifts still to buy, wrapped and given, cards sent, holiday budget planned and spent, chart per person), People (100, budget, spent, left, status), Gifts (500 rows, status drop-down), Holiday Budget (20 lines planned vs actual), Cards (200), Settings
• Quick-start PDF

2,221 formulas, recalculated and checked for errors before listing.

HOW TO USE

1. Buy, then download on the page that opens right after payment (your Stripe receipt email carries the same link).

2. Open the workbooks in Excel 2016 or later, Google Sheets or LibreOffice; the quick-start PDF opens in any PDF app.

3. Yellow cells are inputs, grey cells calculate. Replace the example rows with your own.

PLEASE NOTE

• Digital download only; nothing is shipped. Returns are not possible on digital files; if a file will not open, email [email protected] and it gets fixed.
• Works in Excel 2016 or later, Google Sheets and LibreOffice; drop-downs, filters and the chart included. Amounts are plain numbers, so any currency works; the example people, gifts and prices are placeholders to delete.
• For personal use. Not for resale or redistribution.

Designed by A3E Studio (Ontario, Canada) and generated by our own software; every formula is recalculated and checked before listing.