Google Sheets and Excel · version 1.0
Christmas Budget & Gift Tracker
Plan every gift. Stay on budget this Christmas.
List your people and the gifts for each one. Add food, decorations and cards. See what you spent, what is left and the days to go. Light and dark versions.
Pay on Etsy. Download right after you pay.
- Works on your phone with the free Google Sheets app
- Also Microsoft Excel 2010 or newer
- Something not working? Tell us and we fix it
How it works
- 1
PEOPLE
Type who is on your list and a gift budget for each one.
3 minutes
- 2
GIFT LIST
Add each gift idea and its price. Mark it Bought and Wrapped.
20 seconds a gift
- 3
BUDGET
Type a budget for food, decorations, cards and the rest.
2 minutes
Then read the top of BUDGET. "How are you doing?" says what is left in one line.
See it
What's inside: 4 tabs
- START HERE
- 3 steps to begin, the color code and an "Is everything OK?" check.
- BUDGET
- Days to go, total budget, spent so far, left to spend, gifts bought and wrapped, and 10 more lines for food, decorations, cards and more, with bars and a chart.
- PEOPLE
- Up to 40 people. Budget, gift total, what is left and a bar for each one. It turns red when you go over.
- GIFT LIST
- 150 lines. Person from a list, gift, price, Bought? and Wrapped?, and a note.
Made to be easy
- You type only in the yellow boxes. Example people and gifts are filled in.
- Pick the person from a list. Pick Yes for Bought and Wrapped.
- Over budget for someone? The line turns red and says by how much.
- "After every gift on your list" tells you before you shop if the plan fits.
- Works on your phone with the free Google Sheets app.
What it counts
- Up to 40 people, each with a gift budget
- 150 gift lines
- 10 more lines for food, decorations, cards, a party and more
- Days to go until Christmas
- Gifts bought and gifts wrapped, out of the total
- What is left if you buy every gift on the list
What you get
- Christmas_Budget_Gift_Tracker.xlsxYour tracker, light look, with example people and gifts
- Christmas_Budget_Gift_Tracker_Dark.xlsxThe same sheet in dark mode. Use the one you like
- Quick Start Guide (PDF)2 pages in plain English, with buttons to make your own copy in Google Sheets
Works on
- Google Sheets (free), on your phone or computer. The guide has buttons to make your own copy.
- Microsoft Excel 2010 or newer.
- No macros. No add-ons. No account with us.
What it does not do
- No taxes and no bank connection. It only does your own numbers.
- No year in the file. Use it again next year.
Ready to plan every gift?
$1.98. One time. Download right after you pay. Open the guide, make your copy, type your people. Five minutes.
Questions people ask
How do I get the files?
This is a digital download. Nothing is shipped. After you pay on Etsy, download the files from your Etsy account (Purchases). Open the PDF guide first.
Does it work on my phone?
Yes. Use the free Google Sheets app. The guide has buttons to make your own copy, light or dark. It also works in Microsoft Excel 2010 or newer.
Can I use it next year?
Yes. Type the new year at the top of BUDGET, clear Bought and Wrapped, and keep your people. Or make a fresh copy.
How does "Spent so far" count?
A gift counts when Bought says Yes. For food, cards and the rest, type what you spent in the BUDGET tab.
Is this financial advice?
No. It is a planning tool. It only does your own numbers.
Something is not working. What do I do?
Send us a message on Etsy. We answer and fix it. If we can't, we review your case for a refund.
Good to know
- The people and gifts are examples. Type yours over them.
- This is a planning tool. It is not financial advice.
- Single-user license: for you and your home. Please do not resell or share the files.
- We design every spreadsheet. We use AI tools to help write and test some formulas and text. Every formula is tested before sale.