Use a Google Sheets template with columns for hotel costs, payers, participants (marked as 1s or percentages), and split type (equal or budget share %). Formulas like =SUMIF for totals paid and =IFERROR(B2/sum(C2:J2),"") for per-person shares calculate balances automatically by budget share, as shown in KeyCuts' 2014 editorial.

This setup helps U.S. travel groups, roommates, or friends split hotel bookings unevenly by income, room usage, nights stayed, or agreed shares without paid apps. Enter details for deposits, nightly rates, or cancellations in rows. Share the link for real-time edits, review weekly during trips, and export for records. It works for groups of 2-10 on one-off trips.

Choose Your Hotel Cost Split Type

Travel groups often split hotel costs unequally to match budgets or usage. Equal splits divide totals per person. For budget shares, assign percentages like 40% and 60%, as in Indzara's 2016 template example.

Participation-based splits use nights stayed or room size. Mark 1 for each night a person stays, then divide by the sum. Income-based splits adjust by earnings ratio; if incomes are 60/40, one covers 60% of bills, per Jake Lee's 2023 example.

Reimbursements treat one person at 100% initially, others at 0%, then settle later, as noted in ExpenseSorted's workflow.

Tradeoffs: Equal is simplest but ignores differences. Percentages fit custom agreements but need consensus. Usage-based promotes fairness for variable stays but adds tracking. Discuss upfront to avoid disputes.

Set Up the Google Sheets Hotel Split Calculator

Create a new Google Sheet named "Hotel Costs Split by Budget Share." Add these recommended columns in row 1:

  • A: Date
  • B: Hotel Description (e.g., "Hilton deposit" or "Nightly rate Night 2")
  • C-J: Participant 1-8 (enter 1 or 0 for participation, or % like 0.4 for budget share)
  • K: Payer Name
  • L: Total Cost
  • M: Split Type (e.g., "Equal", "Budget %", "Nights Stayed")
  • N: Notes

KeyCuts' 2014 setup uses 1s under participant columns for inclusion. For a sample row: Enter 2026-07-15 in A2, "3-night suite" in B2, 1s under four participants in C2-F2 (or 0.4/0.6 in C2/D2 for budget split), "Alex" in K2, 800 in L2, "Budget %" in M2.

Add a summary section below data (rows 30+): Columns for each person's total paid, total owed, and balance. Freeze row 1 and column A via View > Freeze.

Share via link: Set to "Editor" for real-time updates, as in ExpenseSorted's 2026 notes. Common mistakes: Forgetting to lock formulas, not labeling split types clearly, or editing without notes.

Add Formulas for Budget Share Calculations

In the summary (e.g., row 31 headers: Alex Paid, Alex Owed, Balance), use these attributed formulas. Adjust ranges like K2:K25 to your data.

For total paid by person (e.g., Alex in C31): =SUMIF($K$2:$K$25,C$30,$L$2:$L$25), from KeyCuts 2014. This sums costs in L where payer matches the name in C30.

For per-person owed (e.g., D31 under Alex): Sum individual shares across rows. First, add a helper column O for each row's per-person share: =IFERROR($L2/SUM($C2:$J2),"") for equal/participation splits, adapted from KeyCuts. For budget % (entered directly in C-J), it divides total by sum of %s (which equals 1).

Then D31: =SUMIF($C$30:$J$30,C$30,$O$2:$O$25) or similar to pull shares. Balance (E31): =C31 - D31.

For reimbursements, enter 1 or 100% for one participant, 0 for others, per ExpenseSorted.

For international hotels, add =GOOGLEFINANCE("CURRENCY:USDZAR") in a cell for live rates (fluctuates; check daily), from Johnny Africa via Spark. These are editorial approximations; test on sample data.

Share, Update, and Track Hotel Reimbursements

Share the sheet link with "Editor" access for live collaboration, where changes appear instantly for all, per ExpenseSorted 2026.

Update cadence: Enter costs daily during booking or trip. Review weekly via comments or a "Last Updated" cell. Mark paid reimbursements by adding rows with "Reimbursement - Alex to Jordan" description, payer as sender, 100% to receiver.

Export via File > Download > PDF for records. Track balances in a "Settled?" column with yes/no. Common mistakes: Over-editing without version history (use File > Version history), forgetting currency notes for multi-country trips, or not confirming participant %s sum to 100%.

When to Use This Template vs. Apps or Cash

This template suits one-off trips with 2-10 people tracking hotels manually. It's free, customizable, and avoids app accounts.

Use cash or Venmo for tiny groups (<4) with simple equal splits - no sheet needed. Switch to apps for >10 people, receipt scans, or payments if tracking alone grows tedious.

Tradeoffs: Sheets offer real-time views and formulas but require discipline. Apps automate scans/payments but may charge fees (check their pages). For infrequent hotel shares, sheets suffice; for ongoing groups, consider rules like "reimburse within 7 days post-trip."

FAQ

How do I handle unequal budget shares for a hotel room (e.g., one pays more due to bigger bed)?
Enter %s directly under participants (e.g., 0.6/0.4), set Split Type to "Budget %". Formula divides total by sum of %s.

What if someone stays fewer nights - how to adjust the split?
Use participation columns: Enter number of nights (e.g., 2 vs. 3) instead of 1s. Per-person formula divides by total nights sum.

Can I add currency conversion for international hotels?
Yes, =GOOGLEFINANCE("CURRENCY:USDEUR") pulls live rates (fluctuates), per Johnny Africa examples. Multiply costs and note daily.

How do I mark who paid the deposit vs. nightly rates?
Separate rows: One for deposit (payer noted), others for nights. Formulas aggregate totals owed/paid across rows.

Common mistakes when sharing the sheet for group edits?
Accidental formula overwrites (protect ranges via Data > Protect sheets), unclear notes on changes, or sharing view-only links by mistake.

Is this template good for long-term roommate hotel shares or just trips?
Best for trips; for roommates, add recurring utilities. Works if group stays stable, but review formulas yearly for accuracy.

Next, copy this setup into a new sheet, test with sample data, and agree on split rules before booking.