Holiday Travel System — Road Trip & Flight Cost Splitter, Packing Lists & Itinerary Excel
Traveling as a family for Thanksgiving or Christmas 2026? One workbook holds the whole trip: what it should cost, what it actually cost, who paid, who owes whom, what is packed, what happens each day, and what the house sitter must do.
AAA projects 81.5 million Thanksgiving 2026 travelers and the most expensive holiday flights in a decade. Guessing the cost and splitting it from memory is how families overpay and argue. This system does the math by formula.
WHAT IS INCLUDED:
- holiday-travel-system.xlsx — 6 sheets, real formulas, sample Christmas 2026 trip pre-filled so you can see every total work before you enter your own trip.
- Start Here — live summary pulled by formula from every other sheet: total budget, total actual, budget left, total shared expenses, packing %, and itinerary cost.
- Trip Budget — 9 categories (Flights, Gas/Tolls/Parking, Lodging, Food, Car Rental, Activities, Gifts, Sitter, Buffer) with Budget vs Actual, Difference = Budget − Actual, and % of Budget Used. Over-budget differences flag red.
- Cost Splitter — each shared expense with Amount, Paid By, and Split Among (N). Per-Person Share = Amount ÷ N. Balance table uses SUMIF for Total Paid per person, Fair Share = Total ÷ travelers, Balance = Paid − Fair Share, and a plain-words Settlement column ("Owes $…" / "Receives $…").
- Packing Lists — by person (Mom, Dad, Alex, Jordan, Everyone), with Category and Packed? Yes/No. Overall % Packed and per-person % Packed update by COUNTIF / COUNTIFS formulas. 24 sample items.
- Itinerary — dated Dec 23–27, 2026 sample with Time, Activity, Location, Cost, and Confirmation columns. Total cost sums by formula.
- Pet & House Sitter Checklist — feeding, walks, mail, plants, thermostat, trash, snow, locks, and return handoff, with Done? and % Complete formula. Safety note included: never write alarm codes in the file.
- holiday-travel-system-guide.pdf — 4-page guide: 10-minute start, budget rules, how the splitter math works with a worked sample ($2,729 shared, $682.25 fair share), packing and itinerary use, sitter handoff, and 2026 fare and traffic notes.
Works for road trips and flights, Thanksgiving and Christmas. Works in Microsoft Excel and Google Sheets. No macros. No subscription. One payment. Instant download (.xlsx + .pdf).
This is a planning tool. It is not travel or financial advice. Confirm prices, schedules, and baggage rules before you travel.