Use this Google Sheets template to track and split expenses with friends, colleagues, whoever.
You, like me, were probably convinced to use Splitwise at some point. Seemed innocent enough - nice little app to help you split group expenses. Connects to your Venmo account. Etc etc… You were duped. I was duped. Splitwise is the devil.
USE THIS GOOGLE SHEETS TEMPLATE INSTEAD (Last updated: 3/31/2022)
Start by entering names of the people in your group in tab “Expenses”, row 7, starting in column G and moving to the right. With each new expense you enter, simply click the checkboxes beneath the individual’s name if he/she was part of that expense (including the person who paid for it). As you do, the “Settling Up” tab tallies who owes and who is owed…. And that’s it. A clear audit trail. No “consolidating debts” or whatever nonsense features other apps drop in. SIMPLE.
Hope it’s helpful. Leave comments below.