When people on a trip stay for different lengths of time, split the shared costs by person-nights instead of by head. Add the nights each person stayed, divide the cost by that total, and everyone pays for the nights they were actually there. The example below is a cottage weekend priced in Canadian dollars.
Why splitting by head feels unfair
A cottage rented for three nights costs the same whether six people sleep there or four. But two friends who only come up for Saturday did not use three nights of it. If you divide by six, the people who stayed the whole time quietly subsidise the part-timers, and the part-timers may not even have realised how much they were being charged for.
Step one: count person-nights
Say the cottage was booked for three nights. Four people stay all three nights, which is 12 person-nights. Two people come for one night only, which is 2 person-nights. The total is 14 person-nights.
Step two: price one person-night
| Cost | Amount (CAD) | Per person-night (/ 14) |
|---|---|---|
| Cottage (paid by Jordan) | 1,260.00 | 90.00 |
| Groceries (paid by Mei) | 434.00 | 31.00 |
| Total | 1,694.00 | 121.00 |
So a full-stay guest owes 3 x 121 = $363.00, and a one-night guest owes $121.00. Check: 4 x 363 = 1,452, plus 2 x 121 = 242, gives $1,694.00, the whole bill.
Step three: compare share with what each person paid
- Jordan paid $1,260.00 and owes $363.00, so is owed $897.00.
- Mei paid $434.00 and owes $363.00, so is owed $71.00.
- The other two full-stay guests each paid nothing and owe $363.00.
- The two one-night guests each paid nothing and owe $121.00.
Total owed to Jordan and Mei: 897 + 71 = $968.00. Total owed by the other four: 363 + 363 + 121 + 121 = $968.00. The books balance.
Who pays whom?
Both full-stay guests send $363.00 to Jordan, which is $726.00. Jordan is still owed 897 - 726 = $171.00. One of the one-night guests sends $71.00 to Mei and $50.00 to Jordan, and the other sends $121.00 to Jordan. Jordan then receives 726 + 50 + 121 = $897.00, and Mei receives $71.00. That is five payments, and nobody has to wait for a second round.
What about food or drinks people did not share equally?
Person-nights is a good default for roof and groceries, but it is not magic. If two people brought their own food or someone does not drink, take those lines out of the shared pool and share them among those who used them. A simple test is to ask, before adding any line to the pool, whether everyone who is paying for it would have been happy to be told the price in advance.
What if a guest changes plans midway?
Plans change: someone leaves a night early, or a friend drops in for dinner and stays over. Do not edit the whole sheet in a hurry. Update the person-night count for just that guest and recompute the price of one night. If one full-stay guest leaves after two nights, the total falls from 14 to 13 person-nights, so every night costs a little more per person than before. Recalculate once, at the end, from the final count, and let everyone see the new figures before money moves.
Closing steps
- Write down who stayed which nights while everyone remembers.
- Collect all receipts into one folder.
- Compute the cost of one person-night per cost type.
- Publish each person's share and the exact payments, then settle within the week.
If you also keep personal records of your spending, enter only your own share. SpendixAI is built around India and INR, so this particular trip is not something to log there in Canadian dollars; the method, though, carries over to any group cost you share in rupees.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


