A solution to that annoying accounting problem

It was a great weekend ... but now we get to the dreaded task of figuring out who owes whom (and how much)? Heres a simple spreadsheet that does the task for you.

http://www.megafileupload.com/en/file/271916/accounting-xls.html

You only need to edit the parts with the grid

Under the "expenditures" columns, you enter how much money each guy spent (one transaction per row) and in the "paid by" columns, you enter who paid for that transaction (in terms of the ratio of the total money spent).

So if there are 3 people (check the xls file): pqr, xyz, and abc
transaction 1 : they spend 10, 12, 12 (34 total) respectively and xyz pays for it (ratio 1 i.e 34/34)
transaction 3 : they spend 500, 200, 150 (850 total) respectively while pqr and xyz pay 350 (ratio is 350/850) and 500 (ratio is 500/850) respectively.

If you make any error while entering values, the leftmost cell of the row with the error will turn red.

The last row shows who needs to pay (negative and red) and who needs to be paid (positive and green)