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.
| Expense | Paid by | Amount | Shared by |
|---|---|---|---|
| Stay | Asha | ₹30,000 | All five |
| Cab | Bala | ₹8,000 | All five |
| Dinner | Chitra | ₹5,500 | Asha, Bala, Chitra, Dev |
| Scooter rental | Dev | ₹3,000 | Dev 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?
| Person | Paid | Share | Net |
|---|---|---|---|
| Asha | ₹30,000 | ₹8,975 | gets back ₹21,025 |
| Bala | ₹8,000 | ₹8,975 | owes ₹975 |
| Chitra | ₹5,500 | ₹8,975 | owes ₹3,475 |
| Dev | ₹3,000 | ₹10,475 | owes ₹7,475 |
| Esha | ₹0 | ₹9,100 | owes ₹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?
- 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.
- In I2 enter =C2/SUM(D2:H2) and fill down.
- A person's share, for example Asha's, is =SUMPRODUCT($I$2:$I$5,D$2:D$5).
- Amount paid, for Asha: =SUMIFS($C$2:$C$5,$B$2:$B$5,"Asha").
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


