When friends stay different numbers of nights, split the stay by person-nights: total accommodation cost divided by the total nights everyone stayed, multiplied by each person's nights. Costs that everyone used, such as a group dinner, are split equally. That keeps a two-night guest from paying for a four-night stay.
What is the method?
- List each person and the number of nights they stayed.
- Add them up to get total person-nights.
- Divide the total stay cost by total person-nights to get the cost of one person-night.
- Multiply by each person's nights.
- Add each person's equal share of the costs everyone used.
What does a worked example look like?
Five friends rent an apartment for four nights at ₹6,000 per night, so ₹24,000. Asha and Bala stay all 4 nights, Chitra stays 3, and Dev and Esha stay 2 each. The numbers are hypothetical.
Total person-nights are 4 + 4 + 3 + 2 + 2 = 15. One person-night costs ₹24,000 ÷ 15 = ₹1,600.
| Person | Nights | Stay share | Equal shared costs | Total |
|---|---|---|---|---|
| Asha | 4 | ₹6,400 | ₹2,400 | ₹8,800 |
| Bala | 4 | ₹6,400 | ₹2,400 | ₹8,800 |
| Chitra | 3 | ₹4,800 | ₹2,400 | ₹7,200 |
| Dev | 2 | ₹3,200 | ₹2,400 | ₹5,600 |
| Esha | 2 | ₹3,200 | ₹2,400 | ₹5,600 |
| Total | 15 | ₹24,000 | ₹12,000 | ₹36,000 |
The equal costs here are an airport cab at ₹7,500 and a group dinner at ₹4,500, which is ₹12,000, and ₹12,000 ÷ 5 = ₹2,400 each. The grand total checks: ₹24,000 + ₹12,000 = ₹36,000.
Why not charge by the actual night?
You could price each night separately: the night with three guests costs ₹2,000 each, and the night with two costs ₹3,000 each. That punishes the last people standing, who did not choose to be the only ones sharing the bill. Pooling the whole stay over person-nights treats the apartment as a single booking for the group, which is what it was.
How do I write it in a sheet?
- Put the total stay cost in B1 and total person-nights in B2: =SUM(C5:C9), with nights in C5 to C9.
- Cost per person-night in B3: =B1/B2.
- Each person's stay share in D5: =C5*$B$3, copied down.
- Each person's equal share in E5: =$B$4/COUNTA($A$5:$A$9), where B4 holds the shared costs.
- Total in F5: =D5+E5.
These formulas behave the same in Excel and Google Sheets. Round the final totals to whole rupees and let the organiser carry the difference.
How do the payments settle?
Usually one person pays for the apartment and another for something else. In the example, Asha paid the ₹24,000 apartment and the ₹7,500 cab, ₹31,500 in all, and Bala paid the ₹4,500 dinner. Compare what each person paid with what they owe.
| Person | Owes | Paid | Balance |
|---|---|---|---|
| Asha | ₹8,800 | ₹31,500 | +₹22,700 |
| Bala | ₹8,800 | ₹4,500 | -₹4,300 |
| Chitra | ₹7,200 | ₹0 | -₹7,200 |
| Dev | ₹5,600 | ₹0 | -₹5,600 |
| Esha | ₹5,600 | ₹0 | -₹5,600 |
Everyone with a negative balance pays the person with the positive one: Bala ₹4,300, Chitra ₹7,200, Dev ₹5,600 and Esha ₹5,600. That is ₹22,700 in total, exactly what Asha is owed.
What if someone arrives late or leaves early mid-night?
Count a night if the person slept there or the room was held for them. Keep one rule, write it in the group chat, and stick to it for everybody, including the organiser.
Do I need an app for this?
No. For your own records, though, SpendixAI can hold your final share as a single trip expense with the booking receipt, and import your bank statement so that the transfers you made to the organiser fall under the same category.
Final checks
- Total of the individual shares equals the actual spend.
- Everyone has seen the formula or the arithmetic.
- Advance payments are subtracted before the final request.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

