The Magic Pot: Reducing Shared Expenses to One Number - sunday 2014-12-07 0026 last modified 2014-12-07 0026
Categories: Daily Grind
TrackBacks Sent: None

Having shared housing and living expenses with as many as six other people at a time, being able to track our expenses and account for them in a way that made sure everybody was paid what they were owed was essential. I set up an accounting system that let us reconcile after a period of time with a minimum of transactions. That is, you'd never have to give money to somebody who was just going to give it back or pass it on to somebody else - there would be at most one check to hand out per party, in total.

I called it The Magic Pot. It's a matter of changing slightly what you track so that instead of trying to keep all the relationships between each party in mind, which is n(n-1) relationships if you're counting each direction debt would flow, down to n*2 - your relationship to an imaginary central account. Sometimes adding another actor into the mix makes it easier. What you track is how much The Magic Pot owes you and how much everybody else owes The Magic Pot. At the end of a period, you can then sum up your transactions with The Magic Pot and arrive at a total for how much you owe or are owed, as can everybody else, free from the complex web of tracking that is the complete connected graph.

Imagine one party purchases toilet paper as a house resource. In straightforward terms, it's simple enough - divide the cost evenly, and everybody else pays the purchaser their share. In The Magic Pot terms, the purchaser logs that each person owes an even share of the cost in their columns, and then they also log the sum total of those into their own column. If somebody else buys milk, in straightforward terms you might have to receive toilet paper money and then hand back milk money. This is simple enough to imagine for a couple transactions, but if other people are paying for internets, electricity, and rent, it starts to be much harder to track without going through the pain of gathering everybody and replaying every transaction. With The Magic Pot, all you need to account for is how much everybody owes you for each purchase.

An example:

Expense Cost Alice Bob Charles Danica
Toilet Paper $12.00 -$9.00 $3.00 $3.00 $3.00
Milk $6.00 $2.00 $2.00 -$4.00 $0.00
Electric $44.00 $11.00 $11.00 $11.00 -$33.00
Internets $61.00 $15.25 $15.25 -$45.75 $15.25
Total $123.00 $19.25 $31.25 -$35.75 -$14.75

Alice purchases toilet paper for $12, and everybody else owes her 25% of the cost. That's noted in each person's column (as a positive, by an arbitrary convention), and she notes the total in her own column - (negative because she's owed it). Note that the bottom row of totals sums to zero, because each row sums to zero (not counting the actual cost of the item, in the 'Cost' column). Alice and Bob owe money to Charles and Danica; they can resolve this with three checks. Note also that Danica is lactose intolerant and has no share in the milk; it doesn't require equal division to even out, just that the individual shares are noted and summed.

You can keep adding transactions for months. Ideally each person would be making purchases to keep their total close to zero so little is missing from their pockets and little needs to be reconciled in the end.




We did a simpler thing with one guy buying everything, and mostly figured it out more manually, but could have used your system years ago.

The one thing that we did write was some software that downloaded the phone bill from the phone company, and then looked through a list of known phone numbers, and billed the numbers to each person, and then emailed everyone to ask them for any unknown numbers, and they each could reply via email to claim the appropriate numbers, and then remember it for the next month. Any shared destinations had to be claimed every month.

I suppose people don't have house phones now...

Jon Daley on January 05, 2015 05:00 AM

Wow thats a great start .

ezcard info on February 20, 2020 07:13 AM

You must login to leave a comment


No TrackBacks for this entry.