Hotel & Vacation Rental Split Calculator

The intuitive fix for uneven stays is to weight by nights: add up everyone’s person-nights, and give each guest that fraction of the total. It is much better than dividing by heads, and for a stay where everyone arrives and leaves together it is exactly right. It goes wrong precisely when it is most needed — when occupancy changes partway through.

The reason is that a booking’s cost is incurred one night at a time. On a night with two people in a $200 property, the group spent $200 to accommodate two people; that is $100 each, and no amount of later arithmetic changes it. Person-night weighting treats all ten person-nights in the example above as interchangeable units at $80 apiece, which silently subsidises the nights with the fewest people in the room using money from the nights with the most.

Splitting night by night removes the ambiguity. Each night is a small, self-contained expense with a known set of participants, and a guest’s total is just the sum of the nights they were present for. It is also the version that survives being questioned at the table, because every line of it corresponds to something that visibly happened.

A hotel with two rooms booked on one reservation, or a rental where one couple gets the master suite with the en-suite and someone else gets the pull-out sofa, is not a per-night problem — it is a room-quality problem sitting on top of one.

The cleanest way to handle it is to treat each room as its own booking. Take the nightly rate for that room, list only the guests in it, and run this calculator once per room. Two runs give you two sets of totals that you can add together, and nobody has to accept an average that smooths over a real difference in what they got.

Where a single rate covers wildly different sleeping arrangements — one big rental, one sofa bed — the usual settlement is a flat discount agreed up front rather than a weighting: the person on the sofa pays a round amount less, and everyone else absorbs it evenly. Decide that number before the trip. Deciding it afterwards, when the total is already known, turns a small courtesy into a negotiation.

Short-stay rentals bury a surprising share of the cost in one-off charges. A cleaning fee, a resort fee, parking for the week, the security deposit that may or may not come back — none of these scale with how many nights any individual guest slept there. They are charged once for the booking, so they belong to the booking, and an even split across everyone named on it is the defensible answer.

The exception is anything a guest specifically caused. If one person brought the dog that triggered the pet fee, or parked the second car, that is theirs. Put it outside this calculator and add it to their share directly, rather than trying to bend the split to accommodate it.

Groceries and shared meals during the stay are a different problem again, and this is the wrong tool for them: they have different payers and different participants each time. Work those out on the settle-up calculator, then bring the single per-person figure back here — or simply settle the accommodation and the food as two separate conversations, which most groups find easier to follow.

One person almost always pays the whole booking months in advance, which makes them the group’s involuntary lender. Say out loud when they get paid back. “Before we go” is a reasonable norm and avoids the situation where somebody is $800 down for six weeks because they happened to have the card details to hand.

Cancellation policy is worth reading before the deposit is split rather than after. If the booking is non-refundable and a guest drops out a week before, the money is already gone and the remaining guests are simply a smaller group splitting the same total — re-run the calculator without that guest and the answer is correct, if unwelcome. If the booking is refundable and they cancel in time, nobody is out of pocket.

The unpleasant middle case is a late drop-out on a refundable booking where the group could have rebooked something smaller. There is no arithmetic that settles that; there is only whether the group agreed in advance that a late cancellation forfeits your share. Agreeing it when everyone is excited about the trip is far easier than agreeing it afterwards.