Group Trip Planner Spreadsheet, Shared Expense Tracker, Exact Cent Cost Splitter, Itinerary and Packing List, Google Sheets Excel

Planning a getaway with friends or family? Keep every shared bill, every repayment, the itinerary and the packing list in one spreadsheet, and see exactly who owes whom, down to the cent.

WHAT YOU GET
• Settings tab for up to 12 guests with fixed IDs P01 to P12, so duplicate first names never get mixed up
• Expenses tab for up to 150 shared bills: who paid, the amount, and an Equal or Custom split (a weight of 0 leaves a guest out)
• Shares and Weights tabs that work out each guest's share to the exact cent, with every cent accounted for
• Repayments tab for up to 100 payments already sent, so balances update as people settle up
• Dashboard showing what each guest paid, owes or should receive, plus a check that the totals reconcile
• Itinerary tab with 50 rows for days, times, plans, owners and booking notes
• Packing tab with 50 rows for shared items and tasks, owners, quantities and a Packed? column

HOW IT WORKS
1. Open Sample.xlsx to see an 8-guest cabin weekend with 12 shared bills.
2. Open Blank.xlsx, save your own copy and type your guests' names on Settings.
3. Add each bill on Expenses, choose Equal or Custom, and record repayments as they happen.
4. Check the Dashboard: Pay and Receive tell everyone where they stand.

FEATURES
• Every cent is assigned, so shares always add up to the bill
• Custom weights per bill for guests who skipped an activity
• Rows that need attention are flagged CHECK until fixed
• Printable, plain layout with no macros

LIMITS
One currency per workbook. Amounts must be positive; there is no refund or negative-expense row. The workbook records payments already sent; it does not move money.

WORKS WITH
• Microsoft Excel (desktop or Microsoft 365)
• Google Sheets (free with a Google account)
• Apple Numbers
Best on a computer or tablet.

WHAT YOU RECEIVE
• Group Trip Planner - Blank.xlsx, ready for your group trips
• Group Trip Planner - Sample.xlsx, filled with example data so you can see how it works
• A quick start guide (PDF)
This is a digital download. Nothing is shipped, and the files are yours to keep. For personal use.

HOW WE MAKE IT
Every Toast & Tally planner is designed in-house with AI-assisted tools, then every tab, formula and sample file is checked and tested before it is listed.

QUESTIONS?
Message us on Etsy. We're happy to help you get set up.