Can you split a Las Vegas rental evenly when half the group leaves early on Sunday? Probably not without someone grumbling. Group trips to Vegas almost always turn messy on the money side. People arrive on different flights, snag unequal bedrooms, and cover random rounds of drinks on personal cards.
A shared spreadsheet cuts through that noise. It gives everyone a clean record of what was booked, what fees landed on the final receipt, and who owes what.
Setting Up the Ledger
Set up two tabs in Google Sheets or Microsoft Excel: an expense log and a settlement summary. Keeping them separate prevents accidental formula breaks when friends enter receipts on their phones.
Your primary expense log needs six basic columns across row 1:
| Column | Header | What Goes Here |
|---|---|---|
| A | Date | Date the card was charged |
| B | Description | Airbnb deposit, cleaning fee, grocery haul |
| C | Category | Lodging, Food, Transport, Drinks |
| D | Paid By | Name of the person who paid |
| E | Amount | Total dollar amount on the receipt |
| F | Split Method | Equal, person-nights, or custom |
Lock that header row before anyone touches the file. In Google Sheets, click View, then Freeze, then 1 row. In Excel, select Freeze Panes under the View tab. Now the headers remain visible when the list hits fifty rows.
Handling Clark County Fees and Local Taxes
Vacation rentals in Clark County carry a different cost profile than a standard hotel on the Strip. Unincorporated Clark County caps occupancy at two guests per bedroom or ten persons per unit, whichever is less. Hosts pass county transient lodging taxes and licensing fees directly into your checkout invoice.
Thing is, Airbnb displays these taxes alongside cleaning and platform service charges. Never dump the entire checkout total into your spreadsheet as one generic number. Break it out.
Cleaning fees are fixed costs. If the host charges $350 for checkout turnover, everyone who slept in the house benefited from that clean space. Split that cleaning fee equally across all attendees. Nightly rates, however, require a different approach if people stay for different lengths of time.
Splitting Staggered Nights Fairly
Suppose three friends stay four nights, while two others fly in late for just Friday and Saturday. Dividing the entire Airbnb total by five means the weekend guests subsidize the longer stay.
Calculate "person-nights" instead. Add up the total nights every individual guest sleeps in the house:
- Alex: 4 nights
- Jordan: 4 nights
- Taylor: 4 nights
- Casey: 2 nights
- Morgan: 2 nights
That comes to 16 total person-nights. Take the base rental charge (the nightly rate plus taxes, excluding the cleaning fee) and divide it by 16. That gives you the exact cost per person per night.
Multiply that single-night figure by the number of nights each guest stayed. Finally, add each person's equal slice of the cleaning fee to their total. Everyone pays for their actual bed time, and the flat fees stay shared.
Formulas to Calculate Balances
Your settlement summary tab can track each traveler's balance automatically using conditional math.
- Total spent by each traveler: Use
=SUMIF(Expenses!$D$2:$D$100, A2, Expenses!$E$2:$E$100)where column D holds names and column E holds charges. You can review advanced conditions through Microsoft Support for SUMIFS. - Net balance owed: Subtract what a person actually spent from their assigned share. A simple
=B2-C2does the job. - Typo prevention: Add dropdown lists to the "Paid By" column. If someone types "Dan" on Friday and "Danny" on Saturday, the formula splits his payments across two separate people. Set this up with guidance from Microsoft Support on data validation.
A negative balance means that person spent more than their fair share and needs reimbursement. A positive number means they must pay money into the pool.
Protecting Formulas from Accidental Edits
To be honest, sharing an unlocked spreadsheet with eight tired travelers is asking for trouble. Someone will accidentally paste an Uber receipt over your summary equations.
Protect your formula cells before sharing the link. In Google Sheets, select the summary cells, right-click, and choose "Protect range." Set permissions so only you can alter calculations while allowing friends to edit rows in the expense log. The exact process is detailed in Google Docs Editors Help.
Excel uses a two-step method. You unlock the receipt entry cells first under Format Cells, then turn on sheet protection under the Review tab, following the steps in Microsoft Support for worksheet protection.
The Central Banker Reimbursement Flow
Avoid a maze of separate peer-to-peer payments. When five people try to pay four other people across different apps, records get lost and someone gets double-paid.
Work through a central banker instead:
- Pick one reliable person to act as banker before reserving the rental.
- The banker books the property and logs the initial charge in row 2.
- Travelers enter their own receipts for rides, groceries, and shared supplies as they happen.
- On the final morning, the banker locks the sheet and reviews the totals.
- Anyone with a positive balance sends one payment to the banker.
- The banker pays out anyone with a negative balance in full.
Before boarding your flight, set up the spreadsheet columns and input the Airbnb reservation confirmation. Settle on your split method before the trip starts so there are no surprises at checkout.