Set one Christmas budget and see where every dollar is going while there is still time to adjust. The Christmas Budget & Gift Tracker keeps your gift list, your per-person budgets and everything else you spend at Christmas in one spreadsheet that does the adding up for you.
What’s inside (7 tabs):
- Start Here: steps and a color key (blue = type here, yellow = example data, grey = calculates).
- Settings: year, total Christmas budget, budgets for Cards & Postage, Food & Hosting, Decor, Travel and Other, your shopping-done date, your ship-by date and a warning level. Shows what is not yet assigned and warns if your categories add up to more than your total.
- People: up to 60 people or groups with a gift budget each. Counts gifts, gifts still to buy, planned cost, spent and remaining, with a status: No gift yet, Still shopping, Done or Over budget.
- Gifts: up to 400 gifts. Pick the person from a dropdown, then gift, where bought, estimated cost, order date, actual cost, expected arrival, status (Idea, Ordered, Bought, Arrived, Wrapped, Given) and order number. Flags orders expected after your ship-by date.
- Extras: up to 200 non-gift costs (cards and postage, food and hosting, decor, travel, other), planned against paid.
- Dashboard: budget, planned, spent and remaining for every category with OK / Near limit / Over and a bar; gift progress by status; a watch list; budget against spent by group (Family, Friends, Kids, Work, Other).
Files: Christmas-Budget-and-Gift-Tracker.xlsx · Christmas-Budget-and-Gift-Tracker-Guide.pdf (3 pages) · OPEN-IN-GOOGLE-SHEETS.txt
Made for Microsoft Excel, Google Sheets and LibreOffice (.xlsx, no macros). Tested in LibreOffice only (recalculated with 0 errors, totals checked against an independent calculation); not tested by the maker in Excel or Google Sheets.
Example data: the yellow rows are made-up example people, gifts, stores and prices so you can see how it works. Delete them before you start.
Good to know: A household planning aid, not financial advice. Dollar format. For your own household use; please do not resell or share the files.
Made by Real World Solutions Online · realworldsolutions.online





Reviews
There are no reviews yet.