The fair way to split a friends' trip is to write down who paid what, add everything up, divide by the number of people, and then settle the differences with the fewest UPI transfers. Do it the same evening or the next morning, while everyone remembers. The method below takes ten minutes and needs only a sheet.
What do you record for each payment?
One row per payment, with four columns: what it was (fuel, toll, stay, food), who paid, how much, and how it was paid. Take fuel and toll first, because they come in pieces: a few fill-ups and a few toll crossings, often paid by different people or from a FASTag linked to one person's account. Ask the owner of the FASTag to read out the toll entries from their statement instead of guessing.
Can you see the whole method on one trip?
Say four friends, Aman, Bhavna, Chirag and Dev, take a trip. These numbers are hypothetical.
| Item | Paid by | Amount (₹) |
|---|---|---|
| Fuel | Aman | 3,200 |
| Toll | Bhavna | 640 |
| Stay | Chirag | 9,600 |
| Food | Aman | 4,800 |
| Total | - | 18,240 |
Equal share: 18,240 divided by 4 is ₹4,560 each. Now compare what each person paid with that share:
- Aman paid 3,200 + 4,800 = 8,000, so he is owed 8,000 - 4,560 = ₹3,440.
- Bhavna paid 640, so she owes 4,560 - 640 = ₹3,920.
- Chirag paid 9,600, so he is owed 9,600 - 4,560 = ₹5,040.
- Dev paid nothing, so he owes ₹4,560.
Check: those owed add up to 3,440 + 5,040 = 8,480, and those who owe add up to 3,920 + 4,560 = 8,480. They match, so the arithmetic is sound.
How do you settle with the fewest transfers?
Match the people who owe with the people who are owed. Bhavna pays Aman ₹3,440 and Chirag ₹480, which is her 3,920 in total. Dev pays Chirag ₹4,560. Chirag receives 480 + 4,560 = 5,040, exactly what he was owed. Three UPI transfers close the whole trip, instead of everyone paying everyone.
What if the split should not be equal?
Agree it before the trip, not after. Someone who joined for one night, did not drink at dinner, or sat in the car for only half the distance may reasonably pay a different share. A simple method is to give every cost its own list of people: fuel and toll shared by the car's passengers, the stay by everyone staying, and a dinner by those who ate. Then run the same arithmetic for each cost separately and add up each person's net balance.
Which formulas help?
- What one person paid: =SUMIF($B$2:$B$20,"Aman",$C$2:$C$20), where column B holds names and column C holds amounts.
- Equal share: =SUM($C$2:$C$20)/4
- Net balance per person: paid minus share. Positive means they are owed money.
Two small rules save most of the friction. First, round shares to the nearest rupee and let the last person absorb the odd rupee, so nobody sends ₹4,559.75 by UPI. Second, set a cut-off: anything paid after the trip, such as a parking challan or a forgotten bill, goes into a second round only if it is more than a figure the group agrees, say ₹200. Otherwise the settlement never ends.
If one person fronted a large amount such as the stay, settle with them first. Their money is tied up, and a friendly reminder in the group chat on day two is better than a tense one a month later.
A last checklist
- Note each payment in the group chat or a shared sheet as it happens.
- Confirm the total and headcount the next morning.
- Compute net balances, then settle in the fewest transfers.
- Add a short note to each UPI payment, such as the trip name, so it is easy to find later.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

