Download the file : Settle Group Spend
I created this sheet to settle the expenses within a team. A few of us were travelling together and spent months on a project. The typical expenses on travel, food, entertainment would be typically paid by any member within a group. The amount spent and the members participating would obviously vary. All the expenses were logged in this sheet, with the initials of person spending the amount listed first, followed by initials of those on whom the money was spent.
A running total of outstanding amount for each person was easily maintained and those who owed money would typically settle at the end of month.
A little fault tolerance was built in the sheet for typos.