Running a household or when going on a group holiday, many expenses and purchases are shared between multiple people but paid only by a few. SplitExpense is an Add-on for Google Sheets to easily manage this.

With SplitExpense you can generate a Google Spreadsheet and share it with everybody. They can add what they have paid for and who the users are that consumed the items. The Add-on works out the consumed and paid totals and the balances for every person. This way you never have to worry about who paid what, just add it to the sheet and let SplitExpense show you.

Every User has a one letter symbol of your choosing associated with them. You record the consumers of an item with a list of their symbols. For example "MT" could mean "Mark" and "Tim" were the users. The '*' symbol is special and represents the whole group. The item's cost are split as ratios so "MMT" would mean that "Mark" pays 2/3rds and "Tim" one third. 

You can specify that users were only present for certain days by supplying date ranges in this format: yyyy-mm-dd~yyyy-mm-dd; 

Check out the help page for further information: https://sites.google.com/view/splitexpense/help