,

Christmas Budget & Gift Tracker Spreadsheet: Gift List per Person, Holiday Budget Dashboard, Cards, Food, Decor and Travel

$12.99

Instant download. Files: spreadsheet (.xlsx, made for Excel or Google Sheets; tested in LibreOffice only), PDF guide, how to open in Google Sheets (TXT). Secure checkout; your download link appears right after payment and is emailed to you.

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.

Be the first to review “Christmas Budget & Gift Tracker Spreadsheet: Gift List per Person, Holiday Budget Dashboard, Cards, Food, Decor and Travel”

Your email address will not be published. Required fields are marked *