Who owes whom, in as few payments as possible SETTLE
Ten pounds between three is 3.33 each, which is 9.99. The missing penny has to go somewhere specific, and over a year of a shared house it is always the same person paying it.
Who is in it
What was spent
Columns are: what it was, who paid, how much, how it splits, and then either the names it splits between or the shares. Shares mean “Ash 2, Bea 1”: Ash bears twice what Bea does.
Pay these and it is settled
Where everybody stands
The odd pennies
The working
How it works
The penny has to go somewhere, and it has to be named
Ten pounds between three people is 3.33 each, which is 9.99. The missing penny cannot be ignored: drop it and the books do not balance, round it up for everybody and the group is two pence out the other way.
The only correct answer is to give the remainder to specific people, by a rule that is the same every time, and to say who got it. Over one dinner that is a penny and nobody cares. Over a year of a shared house it is pounds, and because most spreadsheets round the same way every time, it is always the same person paying them, which is how a small unfairness becomes a real one without anybody noticing.
So the remainder is allocated deterministically here and shown. You can see who absorbed it, which means anybody can check, and the totals add up exactly to what was spent rather than to something close.
As few payments as possible
The other trap is the number of transfers. Six people with a tangle of shared costs produce a list of who owes whom that can run to a dozen payments, most of which cancel each other out: A owes B five pounds, B owes C five pounds, and C owes A five pounds is three transfers that achieve nothing.
What matters is each person's net position. Once everybody is reduced to a single number (up or down), the people who are down pay the people who are up, and the number of transfers is at most one less than the number of people involved. Six people go from a dozen payments to at most five.
That is not a cosmetic improvement. Every transfer is something somebody has to actually do, and a settlement with twelve steps does not get done: two people pay, the rest is forgotten, and the group is now in a worse state than before because the record says it was settled.
Getting the inputs right
Record who paid and who the cost was for, which are different and are the part people collapse. A taxi paid by one person for four of them is not a cost shared by everyone on the trip, and treating it as one is the commonest source of a disagreement that then gets argued as though it were about arithmetic.
Put costs in as they happen. Reconstructing a month of receipts from memory produces a settlement everybody has a reason to doubt, and the doubt is usually justified.
Agree the uneven splits explicitly and in advance: the bigger room, the person who does not drink, the one who arrived on the second night. Written down beforehand it is an arrangement; raised at settlement time it is a negotiation, and those go badly among people who are otherwise friends.
Nothing you type is uploaded, and there is no account, which for a record of who owes whom among a group of named people is the right default. Nearby: LEDGER keeps a cash book, RECEIPTS holds the paperwork behind each line, MONEY does the arithmetic on one-off sums, and DIGITS checks that a total is what it claims.
Questions people ask about SETTLE
Why does it matter who gets the odd penny?
Because it has to go to somebody or the total is wrong, and most tools drop it silently. Over one dinner that is a penny. Over a year of a shared house, with a division every week, it is pounds, and if the rule is arbitrary rather than stated, it is always the same person paying them without anybody noticing.
How does it get the number of transfers down?
By settling from net positions rather than individual debts. It does not matter who owed whom, only that everybody ends up square, so the tangle collapses to a list of people who are up and a list who are down. Pairing the largest of each repeatedly finishes in at most one fewer transfer than there are people.
Is that the fewest possible transfers?
Usually, and it does not claim to be always. Finding the guaranteed minimum means looking for subsets that cancel exactly, which is a partitioning problem with no fast general solution. The greedy answer is never worse than one fewer than the number of people, which is the bound that matters in practice.
Can one person pay for something they are not part of?
Yes. Set the split to some of the group and leave them out. They will show as being owed the whole amount, which is correct.
Does it work in other currencies?
It works in whatever unit you type, held as hundredths. The rounding rule is the same in any currency with two decimal places.
Doing this often? OBSCURA Pro saves the settlement from here, along with the result of every other tool outside the Workspace, and includes the paid applications. Everything is US$5 a month or US$48 a year.