Split Expenses the Old-Fashioned Way, with Google Sheets

Use this Google Sheets template to track and split expenses with friends, colleagues, whoever.

Don’t ever use Splitwise again... because it’s terrible.

September, 2024 - I got lots of comments and suggestions on this template, and channeled all of that into a new suite of free templates. Check out the article and thanks for your continued support! - Zach

CLICK HERE TO ACCESS THE UPDATED TEMPLATES!

---

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.