Life events

Farmhouse or villa booking with friends: a split sheet

A split sheet for a farmhouse or villa booking with friends: record advances, per-head share and extras, with a worked example of who owes whom.

Editorial illustration for Farmhouse or villa booking with friends: a split sheet

When a group books a farmhouse or villa, money moves in stages: a token, a balance, then groceries, a cook and small extras, usually paid by different people. A split sheet records each payment, divides the total by the headcount, and shows who owes whom. Set it up on the day you book, not after the trip.

What columns does the sheet need?

Keep two small tables on one sheet. The first lists payments: date, item, paid by, amount. The second lists people: name, share, paid and net. Add a note column for the mode of payment, such as UPI or cash, and for who is attending.

  • Booking advance and balance, paid to the property.
  • Cook, caretaker or housekeeping, if charged separately.
  • Groceries, drinks, ice and firewood.
  • Decoration, music or speaker rental, if any.
  • Cab or fuel, if you pool it, which is better kept as a separate sheet.

Can you see a worked example?

Say eight friends book a farmhouse for two nights. All figures are hypothetical.

ItemPaid byAmount (₹)
Token advanceRahul10,000
Balance to propertySneha30,000
Groceries and cookKaran6,400
Firewood, ice, extrasRahul2,400
Total-48,800

Per-head share: 48,800 divided by 8 is ₹6,100. Rahul paid 10,000 + 2,400 = 12,400, so he is owed 12,400 - 6,100 = ₹6,300. Sneha paid 30,000, so she is owed ₹23,900. Karan paid 6,400, so he is owed ₹300. The other five each owe ₹6,100, which is 30,500 in all. Those owed also total 6,300 + 23,900 + 300 = 30,500, so the sheet balances.

How should you handle an advance when someone drops out?

Decide it before anyone pays. The usual choices are: the person who drops out is replaced and settles with the replacement; the share is redistributed among those who remain; or the property's refund terms decide, with the person bearing any loss. Write the rule in the group chat when you collect the first advance. Recalculate the per-head share whenever the headcount changes, because everyone else's share changes with it.

What about kids, day guests and drivers?

Add a "weight" column. A child who shares a bed might count as half, a day guest might pay only for food, and a friend who is not staying overnight might pay nothing toward the room. Per-person share then becomes total divided by total weights, multiplied by each person's weight. Agree the weights in advance so nobody feels charged for a rule invented later.

Which formulas help?

  • What one person paid: =SUMIF($C$2:$C$30,"Rahul",$D$2:$D$30), with names in column C and amounts in column D.
  • Equal share: =SUM($D$2:$D$30)/8
  • Weighted share: =SUM($D$2:$D$30)*F2/SUM($F$2:$F$9), where F holds each person's weight.
  • Net: paid minus share; positive means the person is owed money.

Collect money in the same order as you pay. If the property wants a token in three days, ask each person to send their share of it now, not later. A short deadline in the group chat, followed by the sheet showing who has paid, removes the need for anyone to chase. Keep the booking confirmation, the cancellation terms and the sheet in one shared folder so that everyone can check them without asking.

After settling

The sheet is a record of the group split. Your own share still belongs in your personal tracking, so add it to your trip tag. If you import statements into SpendixAI, you can review the rows and tag your payments, but the split itself belongs in the sheet.

SPENDIXAI JOURNAL

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

Explore your reports