THE DIFFICULT PART

The total is shared. The amounts are not.

This combination is the whole reason it cannot be a spreadsheet, and it is the reason these arrangements are done badly and privately instead of properly.