Vacation Rental Cost Splitter Spreadsheet, Split Rent by Nights and Room, Shared Expense Tracker, Group Trip Budget, Excel

Sharing a vacation rental? Split the rent by nights stayed and room size, add the groceries, drinks and activities, 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
• Stay Plan tab: enter each guest's nights and room weight, and the Nights split divides lodging by nights times room weight
• Expenses tab for up to 150 shared bills with Equal, Custom or Nights splits (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

HOW IT WORKS
1. Open Sample.xlsx to see an 8-guest lake house week with 12 shared bills.
2. Open Blank.xlsx, save your own copy, add names on Settings and nights on Stay Plan.
3. Add the rent as a Nights split and other bills as Equal or Custom.
4. Record repayments as they happen and read Pay or Receive on the Dashboard.

FEATURES
• Rent splits by nights times room weight
• Custom weights per bill for guests who skipped an activity
• Every cent is assigned, so shares always add up to the bill
• Rows that need attention are flagged CHECK until fixed

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
• Vacation Rental Cost Splitter - Blank.xlsx, ready for your vacation rental
• Vacation Rental Cost Splitter - 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.