I used to use an Excel spreadsheet but that quickly became a pain in the ass. Now, I use Chipped.In to manage these shared expenses.
This service tracks expenses and any cash exchanged between participants so everyone has a clear picture of what each person has put in.
It is a great tool for partners to track their investments into a business. I highly recommend it.