FREE DOWNLOAD · 2026
Vacation Math Trip Tracker
Plan a budget with a configurable over-count buffer. Log expenses as you go. See planned vs actual on a live dashboard.
Download the .xlsxWhat's inside
Six sheets, designed to work together. Edit any number — every total updates live.
Start Here
Trip name, destination, travelers, dates. These feed every other sheet automatically.
Plan
13 default categories with Disney starter numbers. Edit any cell. Buffer (default 10%) is configurable.
Trip Log
50 rows ready for daily expenses. Category dropdown, automatic per-traveler split, who-paid tracking.
Dashboard
KPI cards for planned vs actual, conditional formatting (green = under budget, red = over), by-category table, who-paid summary, and a live chart.
Categories
The dropdown source. Edit, add, rename. The Trip Log dropdown updates automatically.
Methodology
Nine FAQ items covering the buffer math, named ranges, and what to do if a formula breaks.
What it does
- Adds a configurable buffer (default 10%) on top of your plan — biased toward over-counting so you don't get surprised
- Calculates per-traveler costs everywhere — change the traveler count once, every per-person number updates
- SUMIFs the Trip Log into Dashboard categories automatically — log a $42 expense, dashboard updates instantly
- Conditional formatting on the dashboard: red text + pink fill for over budget, green for comfortable, plain for in-between
- Dropdowns on Category and Split columns so a typo can't break the math
- Tracks who paid (Card A, Card B, Cash, Other — rename to match your actual cards) for easy reimbursement math
- Personal vs split expenses — set the Split column per row, per-person share adjusts automatically
- 50 expense rows ready, easy to add more without breaking formulas
- All formatting, dropdowns, and the dashboard chart preserved across Excel, Numbers, Google Sheets, and LibreOffice
The pairing that works best:
Run a website calculator first to set your plan numbers. The Disney, cruise, all-inclusive, road trip, and theme parks calculators all give you sourced 2026 line items in 60 seconds. Drop those into the tracker's Plan sheet. Then log actuals as you go.
Common questions
Does it work in Apple Numbers?
Yes. Numbers opens .xlsx files natively. All formulas, conditional formatting, dropdowns, and the dashboard chart are preserved. If you want a .numbers file specifically, open the .xlsx in Numbers and choose File → Save As → Numbers format.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open with Sheets. All 138 formulas work, the dashboard chart converts cleanly, and dropdowns are preserved.
Do I need to sign up or share my email?
No. The download is a direct .xlsx file. No signup wall, no email gate, no tracking. Free to copy, edit, and share.
What's the 'biased to over-count' buffer?
The Plan sheet adds a configurable buffer (default 10%) on top of your category totals. The philosophy: better to over-budget and have buffer than be surprised on the credit card statement. Change the buffer rate at cell D5 of the Plan sheet to anything you like (0% to 25% is typical).
How is this different from the website calculators?
The calculators give you a one-shot estimate using sourced 2026 pricing. The tracker is editable, lives on your computer, lets you customize categories, and tracks actual spending against your plan as the trip happens. Use the calculators first to set your plan numbers, then drop those into the tracker.
Can I add more categories?
Yes. Edit the Categories sheet — add a row, type your new category name. The Trip Log dropdown picks it up automatically. For full Dashboard tracking on a new category, also add it to the Plan sheet and the Dashboard's by-category table.
What if a formula breaks?
The Methodology sheet inside the workbook covers this. The most common cause: a named range was deleted. Named ranges in this workbook: TravelerCount, BufferRate, PlannedTotal, PlannedSubtotal, ActualTotal, LogAmountRange, LogCategoryRange, LogPaidByRange, CategoryList. Restore via Formulas → Name Manager in Excel.
How we built it
Every default number in the Plan sheet matches the same sources we use for the calculators: official 2026 Disney pricing, NerdWallet, AAA, Touring Plans, and cruise line tariffs (updated July 2026). The buffer is deliberate — we'd rather you over-budget and have money left than under-budget and panic. All formulas use named ranges so they survive when you add or rename rows.