splitpocket

How to run a group trip's money without a spreadsheet

A six-day trip, seven expenses, four people, and one settle-up that reconciles to exactly zero.

4 min read

Six days in Manali, four friends, one person who ends up paying for the villa because they had the card handy. By day three nobody remembers who covered the cab. By day six there's a WhatsApp thread with the word "roughly" in it. Here's the whole trip run properly, with every number shown.

Set the group up before you leave

One group, named for the trip, in one currency, with the four of you in it. That's the entire setup. Do it at the airport while you're waiting, not on day four when the arguing starts.

The seven expenses

Each one logged by the person who paid, in the moment, in about ten seconds. Notice that three of them aren't split by everyone.

Manali: all expenses

6 days · 4 people

Airport cabPriya paid · split 4 ways
₹3,600.00
Villa, 3 nightsYou paid · split 4 ways
₹18,000.00
GroceriesArjun paid · split 4 ways
₹2,480.00
Dinner, day 2Sam paid · split 4 ways
₹4,200.00
Scooter rentalPriya paid · you, Priya, Arjun
₹1,600.00
RaftingYou paid · Priya, Arjun, Sam
₹6,000.00
FuelArjun paid · split 4 ways
₹900.00

Trip total

₹36,780.00

The scooter was rented by three of you; Sam didn't ride. You sat out the rafting. Those two exclusions are the whole reason a group app beats a spreadsheet. In a spreadsheet, "everyone except Sam" is a formula you get wrong at 1am.

What each person paid, and what each person owed

Paid out of pocket

Youvilla + rafting
₹24,000.00
Priyacab + scooter
₹5,200.00
Arjungroceries + fuel
₹3,380.00
Samdinner
₹4,200.00

Matches the trip total

₹36,780.00

Fair share of what was spent

after the two partial splits

Youno rafting
₹7,828.33
Priya
₹9,828.33
Arjun
₹9,828.34
Samno scooter
₹9,295.00

Adds up exactly

₹36,780.00

The scooter's ₹1,600 divides into three as ₹533.33, ₹533.33 and ₹533.34, so the stray paisa lands on Arjun.

The balances

Paid minus owed. Positive means the trip owes you; negative means you owe the trip.

Net position

Yougets back
+₹16,171.67
Priyaowes
−₹4,628.33
Arjunowes
−₹6,448.34
Samowes
−₹5,095.00

Sums to zero, as it must

₹0.00

Settling: three payments, not twelve

Twenty-odd individual debts came out of those seven expenses: you owe Priya for the cab, Priya owes you for the villa, and so on in both directions. Almost all of it cancels. What's left is one payment per person who owes:

Settle up

3 payments

Priya → you
₹4,628.33
Arjun → you
₹6,448.34
Sam → you
₹5,095.00

Clears every debt

₹16,171.67

Three transfers on the train home and the group reads "settled up". Nobody had to reconstruct anything, because nothing was ever reconstructed. It was recorded as it happened.

Four things worth agreeing on day one

  • Who books the big things. One person fronting the villa is fine. It's visible in the ledger from minute one, so it never feels like a favour being called in later.
  • What counts as group spend. Food, transport, stays, activities everyone joins. Not souvenirs, not that person's extra massage.
  • A spending line. Above, say, ₹2,000, ask the group before you buy on its behalf.
  • When you settle. Pick the last evening, or the day after you're all home. A date, not a mood.

And when the signal dies

It will: in the valley, on the drive, in the basement restaurant with the good food. SplitPocket writes to your device first and syncs when you're back on a network, so the ledger is never a reason to say "I'll add it later". Later is where trips lose ₹4,000.