Life events

A Holi long weekend trip with friends: a split-cost sheet

A shared split-cost sheet for a Holi long weekend trip with friends: log stay, transport, food and colours, see who paid what, and settle up by UPI afterwards.

Editorial illustration for A Holi long weekend trip with friends: a split-cost sheet

For a Holi trip with friends, keep one shared sheet where every shared cost is entered with who paid and the amount. At the end, add the total, divide it by the number of people, and compare each person's share with what they paid. The difference tells you who sends money to whom, and a few UPI transfers settle it. Agree the spending cap before anyone books.

What does the shared sheet need?

  • A: Date
  • B: What, such as stay, fuel, toll, lunch or colours
  • C: Paid by, one person's name
  • D: Amount in rupees
  • E: Shared by, either All or the names of the people it covers
  • F: Proof, such as a screenshot of the booking or the bill

Make the sheet in Google Sheets and share the link with the group so that everyone can add rows as they pay. Ask people to fill in a row on the day, not at the end.

Worked example: six friends, one long weekend

Say the group spends as follows, and every cost is shared by all six. The stay costs ₹14,400 and A paid it. Fuel and tolls cost ₹6,000, paid by B. Food was ₹9,600, of which C paid ₹5,000 and D paid ₹4,600. Colours cost ₹1,200, paid by E. F paid nothing.

PersonPaidShareNet
A₹14,400₹5,200+₹9,200
B₹6,000₹5,200+₹800
C₹5,000₹5,200-₹200
D₹4,600₹5,200-₹600
E₹1,200₹5,200-₹4,000
F₹0₹5,200-₹5,200

The total is 14,400 + 6,000 + 9,600 + 1,200 = ₹31,200, and 31,200 / 6 = ₹5,200 each. Net is paid minus share. A positive number means the person is owed money. Positives are 9,200 + 800 = 10,000 and negatives are 200 + 600 + 4,000 + 5,200 = 10,000, so the sheet balances.

How do you settle up with the fewest transfers?

Match the people who owe with the people who are owed. F pays A ₹5,200 and E pays A ₹4,000, which clears A's ₹9,200. C pays B ₹200 and D pays B ₹600, which clears B's ₹800. Four UPI transfers settle the whole trip. Each person sends the amount to the receiver's number or UPI ID that the receiver gives directly, and checks the name shown before confirming.

In a sheet, with the payer's name in C and the amount in D, a person's total paid is =SUMIF($C$2:$C$40,"A",$D$2:$D$40). The share is =SUM($D$2:$D$40)/6, and net is paid minus share.

What about costs that are not shared equally?

  • If two people shared a room that others did not use, put those names in the Shared by column and split that line only among them.
  • If one person drank and others did not, keep drinks as a separate line for those who joined in.
  • If someone joined late or left early, decide up front whether the stay is split by nights.
  • Personal shopping stays out of the sheet.

The extra column means the formula for each person has to add only the lines that cover them, so keep the sheet simple. If most lines are shared by all, handle the exceptions by hand and note them in the sheet.

Agree the cap before booking

Where does your own tracker come in?

The group sheet is not your personal record. After settling, add your own share, in this example ₹5,200, as one entry in your tracker under travel or festivals. SpendixAI is not a bill-splitting app, so keep the group sheet separate and use your tracker for what you personally spent.

The last-day checklist

  • All shared costs entered, with proof
  • Total divided by the number of people
  • Net per person checked, with positives equal to negatives
  • UPI transfers done within a couple of days
  • Your own share recorded in your tracker
SPENDIXAI JOURNAL

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

Explore your reports