Split hotel costs by person-night unless everyone stays the same nights and agrees to an equal share. A person-night means one person's use of the room for one night. Write the rule before booking, use the final shared lodging total, and record who paid. The spreadsheet should make the agreement visible.
Choose the rule before booking
Equal splitting is easiest when everyone stays the same nights and gets roughly the same access to the room. Nights-stayed splitting works better when arrival dates or departure dates differ.
| Rule | Works best when | Basic calculation | Main tradeoff |
|---|---|---|---|
| Equal per person | Everyone stays the same nights | Total lodging cost divided by the number of people | Simple, but it ignores early departures |
| Nights-stayed | People arrive or leave on different dates | Each night's cost divided by the people present that night | Fairer for changing attendance, but needs better records |
| Room or bed weighting | Room quality or bed access differs | Assign agreed weights before booking | Handles unequal rooms, but requires a real conversation |
| Income-based contributions | The group wants affordability to shape contributions | Use percentages the group agrees on | Personal finances can feel intrusive |
| Reimbursement after proof | One person pays the hotel upfront | Each person reimburses their calculated share | This handles payment, not the fairness rule itself |
The simplest default is equal per person per night when everyone overlaps fully. Use nights-stayed when the dates do not match.
Thing is, reimbursement and fairness are separate. One person can pay the whole booking while the sheet still calculates what everyone owes.
Suggested group message: "We'll split the shared lodging total by person-night. A person who is not staying that night owes $0 for that night. Personal charges stay with the person who made them."
Use the final shared lodging total
Start with what the hotel actually charges, not only the advertised room rate. For covered U.S. short-term lodging, the FTC's Rule on Unfair or Deceptive Fees FAQ says a mandatory fee that cannot be avoided must be included in the advertised total. That rule became effective May 12, 2025.
The rule is a pricing check. It does not decide how your housemates should divide the bill, and it is not a legal conclusion about every charge.
Use the final hotel receipt when you have it. Include the room charge, agreed lodging taxes, and mandatory lodging fees. Keep minibar purchases, room service, spa charges, and other personal incidentals outside the shared total unless the group explicitly agrees otherwise.
For example, a $199 nightly rate plus a mandatory $39 resort fee creates a $238 nightly shared base before other taxes or charges. That is an example for the math, not a standard hotel price.
If a fee applies once to the whole stay, place it in a separate row. Then apply the rule you agreed on. A group using person-nights might distribute it by total person-nights, while an equal-share group might divide it equally among travelers.
Build a spreadsheet that shows the math
A shared Google Sheet or Excel file is enough for many short trips. Start with two tabs: Nightly Costs and Summary.
The nightly tab can use this layout:
| Column | What to record |
|---|---|
| Date or night | The date covered by the charge |
| Shared lodging total | The room cost and agreed shared fees for that row |
| One column per person | Enter 1 if the person stayed that night and 0 if absent |
| Occupants | The sum of the person columns |
| Person shares | Each person's portion of that night's total |
| Paid by | The person who paid that charge |
| Receipt or notes | Confirmation name, receipt details, or an exception |
Assume column B holds the nightly total, columns C through E hold Alex, Jordan, and Sam's presence values, and column F holds the occupant count. In F2, use =SUM(C2:E2). In G2, use =IF($F2=0,0,$B2*C2/$F2). Copy the share formula across for the other people.
The summary tab can contain Name, Share owed, Amount paid, Balance, and Status. Use =B2-C2 for the balance if column B is the person's share and column C is what they paid. A positive balance means the person still owes money. A negative balance means the group owes that person money.
Keep full precision in the formulas, then format the visible amounts to two decimal places. Hotel shares often produce repeating decimals. At the end, assign any one-cent difference to a named person and record that choice.
Limit formula editing to the person maintaining the sheet. Everyone else can review the dates, receipts, and totals. Do not add bank account numbers, passwords, or other sensitive information.
See how a nights-stayed split works
Take a $200 room for four nights. Alex, Jordan, and Sam stay the first two nights. Alex and Jordan stay the last two.
| Nights | People staying | Calculation | Unrounded share |
|---|---|---|---|
| 1 and 2 | Alex, Jordan, Sam | $200 divided by 3 | $66.666... each per night |
| 3 and 4 | Alex, Jordan | $200 divided by 2 | $100 each per night |
Alex and Jordan each owe $333.333... before rounding. Sam owes $133.333... for two nights. One possible final request is $333.33 from Alex, $333.33 from Jordan, and $133.34 from Sam. Together, those amounts equal the $800 lodging total.
That example assigns the extra cent to Sam. Your group can assign it differently.
Turns out, the hard part is rarely division. It is deciding what counts as shared before the receipt arrives.
Follow a simple reimbursement workflow
Use this sequence before and during the trip:
-
Confirm the dates and occupants. Write down who is expected to stay each night. Update the sheet if plans change.
-
Put the rule in the group chat. State how you will handle early departures, different rooms, children, deposits, and personal charges.
-
Capture the booking details. Save the confirmation, quoted total, payment schedule, and any mandatory fees. Keep the final receipt in the same shared folder.
-
Enter each charge promptly. Add the date, total, payer, occupants, and receipt note. Do not rely on memory at checkout.
-
Separate paying from owing. If Alex pays the full $800 but owes only $333.33, record both numbers. Alex's balance is a $466.67 credit, not a zero-dollar share.
-
Reconcile the final receipt. Replace estimates with the actual total, add approved changes, and subtract refunds or credits. Leave a note explaining each adjustment.
-
Send one specific request. Use the sheet's final balance and the payment method your group already accepts. A clear message might say: "Your hotel balance is $133.34. The sheet shows two nights at the three-person rate, and the final receipt is in the shared folder. Please send it by [date] and mark it paid."
An upfront payment should never disappear into the math. It belongs in the Amount paid column.
Set rules for the awkward cases
Most disputes start with an exception that nobody defined. Decide these points while the booking can still be changed.
| Situation | Rule to decide in advance |
|---|---|
| Someone leaves early | Use $0 for unused nights under a nights-stayed rule, unless the group agrees to share a nonrefundable cost |
| Rooms or beds differ | Use equal shares only if access is reasonably similar; otherwise agree on room or bed weights before booking |
| A child or non-sleeping guest joins | Decide whether that guest counts as a full, partial, or no share |
| A deposit or one-time fee is charged | Track it separately, then record any refund as a credit against the lodging total |
| Someone orders personal extras | Keep the charge with that person unless the group approves it as shared |
| The booking is canceled | Use the actual nonrefundable amount and apply the written split rule to that amount |
Do not quietly change the rule after someone has paid. If the group makes an exception, write down who approved it and why.
Keep reimbursement conversations calm
Set a due date before the trip, not after a balance becomes awkward. If someone needs more time, record an installment plan while keeping the original share visible.
A useful reminder names the amount and points to the evidence: "Your balance is $X according to the final sheet. The receipt and calculation are in the shared folder. Please let me know by [date] if one of the dates or charges looks wrong."
If someone disputes the amount, check the inputs in order: stay dates, occupants, fees, deposits, personal charges, payments, and rounding. Fix the row that is wrong. Do not rewrite the entire agreement to hide one mistake.
To be honest, late payment is easier to discuss when the original rule is still visible. If a person cannot pay, agree on dates in writing. If no agreement is possible, stop fronting additional group costs for that person.
Questions that come up
Is an equal hotel split always fair?
No. It is cleanest when everyone stays the same nights and has similar room access. Use nights-stayed or weighted shares when the facts are different.
Can I split one final hotel total without nightly rows?
Yes, if everyone stayed the same nights. When attendance changes, nightly rows are safer because they show exactly who used the room on each date.
What if the final hotel total changes?
Update the shared total and leave a note describing the change. Use the final receipt for the last reimbursement request, not an earlier estimate.
Do I need an app?
Not necessarily. A spreadsheet, receipt folder, and written rule can handle a small trip. An app may help with reminders, but it does not replace an agreement about fairness or a record of the final charge.
Before booking, create the sheet, enter the dates and names, paste the rule into the group chat, and test one row against the hotel quote. Keep the final receipt beside the finished tracker.