Christmas Gift Budget Tracker Spreadsheet, Holiday Gift List for Excel & Google Sheets

Enjoy the holidays without the January money hangover.

Set one total holiday budget, list everyone you're shopping for, and the Christmas Gift Budget Tracker keeps score for you: how much you've spent, how much is left, how many gifts are bought and which ones went over budget. Decorations, food, travel, cards and parties get their own budgets too, so nothing sneaks up on you.

WHAT'S INCLUDED
• Dashboard: holiday budget, spent, remaining, days until Christmas and average cost per gift
• Gift shopping progress bar (gifts bought, wrapped or given vs. your full list)
• Gifts by group (Family, Friends, Work, Kids, Other: rename or add your own) with budget, spent and a chart
• Gift status summary: Idea, Bought, Wrapped, Given
• Over-budget list showing the gifts that went over and by how much
• Gift list (200 rows): recipient, group, gift idea, budget, actual cost, store, status and tracking number or notes
• Other holiday spending: budgets for decorations, food & baking, travel, cards & postage, events and wrapping, plus a 150-row purchase log
• Setup tab and Start Here guide
• Two files: a blank tracker and a filled-in example

WORKS WITH
• Microsoft Excel (2010 or later, Windows and Mac, and Excel online)
• Google Sheets (free): upload the file to Google Drive and open it with Google Sheets

HOW IT WORKS
1. Purchase and download instantly from your Etsy Purchases page.
2. Open the file in Excel, or upload it to Google Drive and open it in Google Sheets.
3. Set your budget on the Setup tab, then add gifts and purchases as you shop.

PLEASE NOTE
• This is a digital download. No physical item will be shipped.
• Amounts are in US dollars ($). Currency formatting can be changed in your spreadsheet app.
• Reusable every year: keep a blank copy and start fresh each season.
• For personal use. Please don't resell or share the file.
• Not financial advice.

How we make it: Every Penny & Pencil template and worksheet is designed in-house with AI-assisted tools, then each page, formula and answer key is checked and tested before it is listed.

Questions? Send us a message. We usually reply within a day.