Split Group Trip Expenses Fairly and Write the Settle-Up Message

Paste your trip expenses and get a fair split that handles skipped meals and kids, a who-owes-whom table with the fewest transfers, and a ready-to-send group message.

You getExpense split table, balance table and transfers table

Prompt

Prompt
Act as a careful trip treasurer who splits shared costs for friend and family groups.

I will paste our trip expenses right after this prompt: what was bought, the amount, who paid, and who took part. Before calculating, check for gaps. If it is unclear who joined an expense, how to count kids (full share, half share or free), or which currency to use, ask me up to 3 short numbered questions in one message and wait for my answers.

Rules:
1. Split each expense only among the people who took part. Use weighted shares for kids or partial participants, and state the weight used.
2. Show every person's total share and total paid. Net balances must add up to exactly zero. Show that check.
3. Settle with the fewest possible transfers, and have debtors pay creditors directly.
4. Round to the cent and explain any leftover cent.
5. Keep the settle-up message under 120 words, friendly and neutral, with no blame.

Output format:
- Expense split table: Expense | Amount | Paid by | Split among | Each share
- Balance table: Person | Paid | Share | Net
- Transfers table: From | To | Amount
- Settle-up message ready to paste into the group chat

End with one line listing any assumptions I should confirm with the group.

Example output

Example for: four friends on a 2-night cabin weekend. Cara brought her 7-year-old son Leo, who counts as a half share for food and is free for lodging and activities.

Expense split
ExpenseAmountPaid bySplit amongEach share
Cabin, 2 nights$600.00AnaAna, Ben, Cara, Dev$150.00 each
Groceries$180.00BenAna, Ben, Cara + Leo (0.5), Dev$40.00 per share; Cara $60.00
Dinner out (Ben skipped)$140.00DevAna, Cara + Leo (0.5), Dev$40.00 per share; Cara $60.00
Gas (shared car)$90.00CaraBen, Cara, Dev$30.00 each
Kayak rental$120.00AnaAna, Ben, Dev$40.00 each
Balances
PersonPaidShareNet
Ana$720.00$270.00+$450.00
Ben$180.00$260.00-$80.00
Cara$90.00$300.00-$210.00
Dev$140.00$300.00-$160.00

Check: Total spent $1,130.00 = total shares $1,130.00. Nets: +450 - 80 - 210 - 160 = 0. No rounding was needed.

Transfers (3, the minimum for this group)
FromToAmount
CaraAna$210.00
DevAna$160.00
BenAna$80.00
Settle-up message

Hi all! Thanks for a great cabin weekend. I added up everything we spent ($1,130 total). Each cost was split only among the people who joined it, and Leo counted as a half share for food. Here's how we square up:

  • Cara → Ana: $210
  • Dev → Ana: $160
  • Ben → Ana: $80

Ana covered the cabin and kayaks, so everything goes to her. That's only 3 transfers and nobody else needs to pay anyone. Full breakdown is below if you want to check it. Shout if I got anything wrong!

Assumptions to confirm: Leo is free for the cabin, Ana did not use the shared car, and all amounts are in USD.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Weighted shares per expense handle kids and skipped activities, so nobody pays for a dinner they missed.
  • Requiring nets to sum to zero gives a visible check that catches arithmetic errors before money moves.
  • The fewest-transfers rule plus a neutral message cuts awkward back-and-forth payments in the group chat.

Use this after a group trip, before the costs get forgotten. Paste a list or spreadsheet rows of expenses into ChatGPT, Claude or Gemini, with notes on who skipped what and how kids should count.

Common edits

  • Add a currency conversion step if expenses were paid in more than one currency, and state the exchange rate used.
  • Ask for the settle-up message in a shorter text-message version or with payment app handles included.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Travel