Split the hotel bill by person-night when the rooms are close enough that nobody cares who sleeps where. If one room is a suite and the rest are standard, you can still make the split fair. You just have to agree on the adjustment rule before anyone pays. The most workable method runs in two passes: hand the lodging pool out to rooms first, then divide each room's share among the people who actually used it.

Thing is, size is only one ingredient in a room's value. Privacy, bathroom access, a balcony, how many people are sharing the bed. Those can matter as much as square footage, and a good formula makes those judgments visible instead of pretending square footage settles everything.

Pick a rule before anyone books

Write the rule down in the group chat before someone pays a deposit. That timing does real work. People haggle happily over room premiums before assignments feel permanent. After checkout, not so much.

Three rules cover almost every group trip:

Rule Use it when How it works Main tradeoff
Equal per person-night Rooms and features are similar Divide the shared total by total person-nights Fast and clear, but it ignores room differences
Actual room charges The hotel itemizes each room's rate Divide each room's final charge among its occupants Transparent, though hotel pricing may reflect demand
Room-size adjustment One room is clearly larger or has important extras Weight each room, then divide its allocation among occupants and nights More tailored, but it requires judgment

If nobody wants to put a price on a view, a closet, or the lighting, that's your signal to use the equal rule. When the gap is obvious, a standard room sitting next to a suite, an adjustment is easier to defend. A few extra square feet usually isn't worth a debate. If the group can't land on a premium, use equal per-person-nights and move on.

Start with the hotel's final total

Split what the hotel actually charged, not the rate you saw when booking. Advertised nightly prices often leave out taxes, mandatory resort fees, and whatever else shows up on the folio at checkout.

Before dividing anything, sort the bill into three pools:

  • Shared lodging: Room charges, mandatory taxes, and fees that apply to the group.
  • Shared add-ons: Parking or another charge, but only if everyone agreed to share it.
  • Personal extras: Minibar purchases, personal room service, damage charges, or an individual upgrade.

The resort fee needs a closer look. Hotels charge it per room, per night, or per stay, so follow the folio rather than guessing.

Discounts, refunds, and credits go into the shared pool unless one person clearly owns them. A refundable authorization isn't an expense yet. It only becomes one if the hotel keeps some of it.

If the hotel already reports totals per room, use those numbers. There's no reason to estimate room value from square footage when the real figures are sitting right there.

Use formulas that match real occupancy

The math gets easy once you separate the room question from the occupancy question. A couple is two people. A solo traveler is one.

  1. Count person-nights. Add up each person's nights. Someone who stays four nights contributes four.

  2. Calculate the equal baseline.

    Person's share = total shared pool x person's nights / total group person-nights

    A $1,600 total spread across eight person-nights comes to $200 per person-night. This baseline stays useful even if you adjust for rooms later.

  3. Add room weights when the group agrees to use them.

    Room weight = room size x agreed feature factor

    Room allocation = shared room pool x room weight / sum of all room weights

    Person's room charge = room allocation x person's nights / total person-nights in that room

    Use 1.00 for an ordinary room. If everyone agrees an ensuite deserves a small premium, 1.10 works as an example. That factor is a group decision, not a standard value for hotel bathrooms.

  4. Add personal charges separately. A third-person fee belongs to whoever caused it. Shared room service can sit on its own line.

Rooms that cover different dates need their own pass, calculated per room-night. It sounds fussy. It also stops the person who left early from paying for nights they never slept there. Splittyapp's worked hotel example walks through this same person-night logic.

Fixed booking fees stay separate when possible. Split them by person-nights, or apply the room-weight rule only if everyone agrees the fee represents room value.

A worked room-size example

Say two rooms cost $200 a night each for two nights. Room A runs 300 square feet with two occupants. Room B runs 200 square feet with one. The total is $800, and the group weights Room A at 0.60 and Room B at 0.40.

Room Size Occupants Weight Two-night allocation Amount per person
Room A 300 sq. ft. 2 0.60 $480 $240 each
Room B 200 sq. ft. 1 0.40 $320 $320

An equal split looks different. Six person-nights means $133.33 per person per night, or $266.67 for the two nights.

Turns out the size-adjusted number charges the solo traveler more, and that's deliberate. They have Room B to themselves. Room A is bigger overall, but two people share its value.

If the solo traveler balks at $320, go back to the rule everyone agreed on. A formula can't settle a disagreement the group never defined.

When someone leaves early

Take a standard room at $200 a night for four nights. Three people use it for the first two nights, and two stay on for the last two.

For those first two nights, each person owes $66.67 per night. For the last two, each remaining person owes $100 per night. Add it up: the early leaver owes $133.33, and the person who stayed all four nights owes $333.33.

For comparison, a $400-per-night suite held for four nights costs $1,600. With three full-time occupants, each person's share of that actual room charge comes to $533.33.

Build a sheet everyone can audit

A spreadsheet earns its keep the moment room assignments, nights, or payers start shifting. Use two tabs if the group has different rooms on different nights.

Tab and field What to record Formula or rule
RoomNights - Night Night or date One row for each room used that night
RoomNights - Room Room name or number Keep names consistent
RoomNights - Size Published square footage, if available Do not invent precision from photos
RoomNights - Feature factor Agreed value such as 1.00 Record the decision before splitting
RoomNights - Weight Size multiplied by factor =C2*D2
RoomNights - Nightly pool Shared room amount for that night Include the agreed taxes and fees
RoomNights - Room allocation Room's weighted share =F2*E2/SUMIF($A$2:$A$20,A2,$E$2:$E$20)
People - Night, person, room Who used which room One row per person-night
People - Room occupants Number of people in that room that night =COUNTIFS($A:$A,A2,$C:$C,C2)
People - Person share Room allocation divided by occupants =SUMIFS(RoomNights!$G:$G,RoomNights!$A:$A,A2,RoomNights!$B:$B,C2)/D2
People - Paid by Person who fronted the charge Use the payer's name
People - Reimbursed Yes, no, or date paid Keep the status current

One assumption lives inside that room allocation formula: each room should appear exactly once per night on the RoomNights tab. If you'd rather keep everything on a single tab, that can work, but keep room-night rows separate from person-night rows anyway so the occupant counts don't inflate the room weights.

Give the group view access and let one or two people edit the formula columns. Protect those columns if your spreadsheet tool allows it. Drop the final hotel folio or receipt into the same shared record.

Update the sheet whenever the booking changes, when someone swaps rooms, and once more after checkout. The final check is dull and effective: all person shares, fixed-fee shares, and personal charges should reconcile to the amount actually paid.

Most mistakes come from counting guests instead of person-nights, or from applying an amenity premium twice. Splitting a refundable deposit as if it had been spent is another classic. Check the total before you send any reimbursement requests.

Handle awkward cases up front

A handful of pre-agreed rules prevents most of the arguing:

  • Couples and solo travelers: Divide a room's allocation among its actual occupants. A couple is two shares, a solo traveler is one.
  • Extra-person fees: The person who triggers the fee pays it, unless the group agreed to share it.
  • Upgrades: Someone who requests a pricier room covers the difference unless the group approved it.
  • Early departures: Charge nights actually used when the room cost can shrink or be reassigned. If the reservation stays committed, the rule set before booking wins.
  • Views, balconies, and bathrooms: Adjust only when the difference is clear enough that everyone would describe it the same way.

Nobody needs a perfect valuation of every feature. What the group needs is a rule people understood before money changed hands.

Put the agreement and reimbursement in writing

One short message covers it:

"The rooms are close in size, so we're splitting the hotel by person-night. If we book a suite, we'll settle on the adjustment before anyone pays."

For the final request, name the nights and the method:

"Per the sheet, your share comes to $150 for two nights in the king suite, final hotel fees included. Please send it through your usual payment method by Friday."

Choose a deadline instead of leaving the balance open. Seven days after the trip is a workable group rule. It isn't a universal one.

The payment app moves the money. The spreadsheet or receipt folder explains why the number is what it is. Keep those two jobs separate.

Questions people usually ask

When do rooms differ enough to justify a size adjustment?

When the gap is plain to see, like a suite next to a standard room, or a private bathroom where others share one. Minor differences usually create more debate than they're worth.

What if the hotel does not list square footage?

Work from the room category and obvious features instead. If nobody can agree on a reasonable weight, fall back to equal per-person-nights. A rough guess from a hotel photo isn't a measurement.

Should taxes and resort fees follow the room adjustment?

Let the final folio decide. A charge tied to one specific room can follow that room. A fixed stay fee splits by person-nights, or by another rule the group records.

What if one person pays the whole hotel bill?

List that person in the payer column, calculate each share, and send requests with the supporting sheet. Confirm the reimbursement total equals what the payer covered, excluding any personal charges.

Before anyone sends a deposit, write down the split rule, the room assignments, and how early departures get handled. Add the final hotel total after checkout. Then send each person one clear number with the calculation behind it.