Spreadsheets

Sheet or app to split trip costs with friends: when each works

Split trip expenses with friends using a shared spreadsheet or an app: a worked five-person example with unequal shares, settle-up formulas and when each works best.

Editorial illustration for Sheet or app to split trip costs with friends: when each works

A shared sheet works well for one trip with a patient organiser, because you can see every share and check the maths. A splitting app is faster when everyone adds expenses live from their phones and shares are uneven. The deciding factors are speed of entry, how easily people can verify fairness, and how simple the final settle-up is. The worked example below uses a five-person trip with an unequal split.

What is the benchmark trip?

Five friends: Asha, Bala, Chitra, Dev and Esha. Four expenses, with hypothetical numbers.

ExpensePaid byAmountShared by
StayAsha₹30,000All five
CabBala₹8,000All five
DinnerChitra₹5,500Asha, Bala, Chitra, Dev
Scooter rentalDev₹3,000Dev and Esha

Esha skipped dinner and only Dev and Esha rode the scooter, so the shares are uneven.

How do you work out each person's share?

  • Stay: 30,000 ÷ 5 = ₹6,000 each.
  • Cab: 8,000 ÷ 5 = ₹1,600 each.
  • Dinner: 5,500 ÷ 4 = ₹1,375 each for four people.
  • Scooter: 3,000 ÷ 2 = ₹1,500 each for two people.

Asha, Bala and Chitra each owe 6,000 + 1,600 + 1,375 = ₹8,975. Dev owes 6,000 + 1,600 + 1,375 + 1,500 = ₹10,475. Esha owes 6,000 + 1,600 + 1,500 = ₹9,100. The shares add up to 3 × 8,975 + 10,475 + 9,100 = ₹46,500, which equals total spending of 30,000 + 8,000 + 5,500 + 3,000. If a check like this does not tie out, something is wrong.

Who owes whom at the end?

PersonPaidShareNet
Asha₹30,000₹8,975gets back ₹21,025
Bala₹8,000₹8,975owes ₹975
Chitra₹5,500₹8,975owes ₹3,475
Dev₹3,000₹10,475owes ₹7,475
Esha₹0₹9,100owes ₹9,100

The amounts owed, 975 + 3,475 + 7,475 + 9,100, come to ₹21,025, exactly what Asha is owed. Everyone pays Asha, so there are four UPI payments instead of a tangle of cross-payments.

How do you build this in a sheet?

  1. Columns: A item, B paid by, C amount, then D to H with a 1 or 0 for each of the five people (D Asha, E Bala, F Chitra, G Dev, H Esha), and I for amount per head.
  2. In I2 enter =C2/SUM(D2:H2) and fill down.
  3. A person's share, for example Asha's, is =SUMPRODUCT($I$2:$I$5,D$2:D$5).
  4. Amount paid, for Asha: =SUMIFS($C$2:$C$5,$B$2:$B$5,"Asha").
  5. Net is paid minus share. A positive net means that person gets money back.

If a share has paise, such as a ₹1,000 bill split three ways, round per-head amounts to two decimals and let the payer absorb the odd paisa.

Sheet or app: which suits which trip?

A sheet is transparent and free, and everyone can see the formulas, which settles arguments about fairness. Its weakness is that adding an expense on the road is clumsy, and a person must be willing to be the organiser. A dedicated splitting app is faster for entry and shows balances automatically, which helps on long trips with many small expenses. Check how it handles uneven shares and whether everyone has to install it.

Rounding is the usual source of small arguments. Agree beforehand that amounts are rounded to the nearest rupee, and that any leftover rupee is absorbed by the person who paid. It is a simple rule and it avoids haggling over ₹1.

Before the trip starts

  • Agree one person to hold the record.
  • Agree how shares work for optional items before spending.
  • Keep a photo of every bill above a limit you set.
  • Settle up within a few days of returning, while everyone remembers.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports