Teacher Christmas Gift Budget & Class Gift Tracker (Excel + Google Sheets + Printable PDF)

Thirty students, a co-teacher, the office, the custodian, the principal, a class party, and a room-parent fund that someone has to account for. Every December the same thing happens: receipts in a tote bag, a sticky note of who still needs a gift, and no idea what it all cost until January.

That guesswork is where the money goes. One more $4 gift times 30 is $120 you did not plan for, a forgotten aide means an awkward last-minute run, and a room parent who cannot say exactly what came in and what went out loses the trust of the whole class list.

The Teacher Christmas Gift Budget & Class Gift Tracker is a spreadsheet plus an 11-page printable built for exactly this. Set a budget per group in Settings, log each gift as you buy it, and the Dashboard shows Remaining in red the moment a category goes over. The Student List tab holds all 30 names with allergies, gift idea, budget and what you actually spent. Room parents get their own Class Gift Collection tab: pledged, received, thank-you sent, and a goal that counts down.

What you get:

• Budget vs spent for Students, Co-teachers/aides, Office staff/custodian, Principal, Room-parent collection, Class party supplies, Wrapping/cards. Red when over.
• Gift Log with Date, Person/category, Name, Gift, Store, Cost and Status (Idea / Bought / Wrapped / Given), room for 500 rows.
• Student List tab (30 rows) with allergies/notes and a Spent column that adds up from the log automatically.
• Class Gift Collection tab for room parents: pledged, received, date, thank-you sent, still owed.
• 11-page printable PDF (Letter/A4): budget page, 30-student gift list, staff gifts by role, class party checklist, collection tracker, thank-you tracker, 40+ gift ideas under $5 per student, and 12 cut-out gift tags.
• A low-ink print-friendly PDF is included.
• Works in Microsoft Excel or free Google Sheets (upload to Drive, open with Sheets). Type only in the white cells; the shaded cells calculate.

Gifts need to be bought before the last day of school in December. Set the budget this week and the tracker does the adding for the rest of the month. Instant download.

Made with AI assistance and checked by a human