Airbnb does not support splitting payments among guests, per the Airbnb Help Center and forums. The guest split feature was discontinued post-2018. Instead, designate one primary payer to book the Phoenix stay. Then, use a shared Google Sheet to track shares, receipts, and reimbursements with a pre-agreed workflow.

This approach helps U.S. friend groups manage equal per-person splits or adjusted ones, such as nights-stayed or share-based (singles as 1 share, couples as 2). Agree on rules upfront, set up a tracker, follow a review cadence, and settle post-trip. It keeps records clear for casual travel groups without relying on payment apps.

Confirm Airbnb's Payment Limitations for Groups

Airbnb's payment system requires one guest to book and pay the full amount upfront, including nightly rate times nights plus fees and taxes. Co-hosts are available only for hosts to divide earnings, not for guests splitting costs, per the Airbnb Help Center.

Guest-side splitting is not an option in 2026. Forums note the prior feature ended years ago, leaving groups to handle divisions manually. This setup protects the booking but shifts tracking to your group.

Agree on Split Rules and Roles Before Booking

Start with a group chat or call to align on costs and rules before the primary payer books.

  1. Estimate total cost: Nightly rate times nights, plus cleaning fee, service fee, and taxes. Share the Airbnb quote screenshot.

  2. Decide the split method. Options include equal per-person or adjusted, like share-based (example: singles 1 share, couples 2 shares).

  3. Assign roles: Primary payer books and shares the receipt; tracker updates the sheet; everyone else reimburses their share.

  4. Set rules, such as submit receipts within 48 hours of spend and reimburse within 24 hours of request.

Sample group chat script: "For our Phoenix Airbnb: Total $X for 5 nights, 6 people (4 singles=4 shares, 1 couple=2 shares, total 6 shares). Equal share $Y each. [Name] books as primary payer. I'll set up the Google Sheet. Rules: Share receipts in 48 hours, pay via Venmo/Zelle in 24 hours. Agree?"

Document agreement via screenshot or sheet note. This prevents disputes, especially for uneven stays.

Set Up a Google Sheets Tracker for Phoenix Trip Costs

Create a free Google Sheet for real-time group tracking. Share the link with edit access for live updates; it supports offline edits that sync later.

Recommended columns (row 1 headers):

  • A: Person
  • B: Nights (e.g., 4 out of 5 total)
  • C: Share (e.g., 1 for single, 2 for couple)
  • D: Category (Airbnb, Groceries, Gas)
  • E: Amount (per receipt)
  • F: Paid By (primary payer or others)
  • G: Total Nights (fixed, e.g., 5; lock this cell)
  • H: Owed (= (G2 / $G$1) (B2 $C$1) for nights-adjusted share of Airbnb; adapt for categories)
  • I: Paid (reimbursement amounts)
  • J: Balance (= H2 - I2)

Formulas to add:

  • Category totals: In a summary section, use =QUERY(A2:J100, "SELECT D, SUM(E) GROUP BY D LABEL SUM(E) 'Total'").

  • Conditional sum example: =SUMIFS(E2:E100, D2:D100, "Travel", F2:F100, "Yes") to total specific categories.

Lock total cost cells (right-click > Protect range) to avoid errors. Update daily: Primary payer adds Airbnb receipt first. Common mistakes: Not sharing edit links or skipping nights column for early departures.

For Phoenix trips, add rows for gas, groceries, meals. Test formulas pre-trip with sample data.

Follow Review and Settlement Cadence During/After Trip

Maintain momentum with timed checks.

  • Pre-trip (booking day): Finalize sheet with Airbnb total; everyone confirms share.

  • Mid-trip (day 3): Group review call. Check balances; add receipts. Example: "Sheet shows balances; submit any groceries receipts."

  • Post-trip (within 7 days): Export sheet as PDF. Message balances: "Per sheet row 5, you owe $X for your share. Venmo/Zelle by [date]."

Receipt rule: Submit proof (photo/link) within 48 hours of spend to the sheet or chat.

Settlement steps:

  1. Tracker exports summary (File > Download > PDF).

  2. Primary payer messages balances.

  3. Confirm payments in sheet's Paid column.

  4. Final zero-balance check.

If issues arise, reference pre-agreed rules. Keep the sheet for records.

FAQ

Does Airbnb allow guests to split payments directly in 2026?
No, per the Airbnb Help Center. One guest pays full; groups track manually.

What if someone stays fewer nights - how to adjust the split?
Add a Nights column. Use formula like =(G2 / total nights) (person share nightly total) for proportional owed amount.

Can we use Google Sheets formulas for uneven shares like couples vs. singles?
Yes. Set Share column (1 for single, 2 for couple), then multiply in Owed formula for share-based totals.

How soon after the trip should we settle balances?
Within 7 days post-trip, to keep records fresh and avoid forgotten debts.

What rules should we set for receipts and reimbursements?
Examples: Submit receipts within 48 hours; reimburse within 24 hours of request. Agree upfront.

Is a spreadsheet enough, or do we need an app?
A shared Google Sheet works for most small groups with real-time edits. Apps add requesting features but are optional.

Next, copy the column setup into a new Google Sheet and test with your Phoenix quote. Adjust rules to fit your group for smooth tracking.