top of page
  • Writer's pictureZach

Split Expenses the Old-Fashioned Way, with Google Sheets

Updated: Apr 5, 2022

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


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

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.


105,314 views87 comments

Recent Posts

See All

87 Comments


This is a great tool for groups that don’t all use the same app. I needed some additional help with the sheet, and Zach was super responsive and found a great solution!

Like

This was super helpful for calculating my travel expenses with a group of friends and Zach went above and beyond to help me with it. Appreciate it so much

Like

Really helpful tool for bachelorette parties. Using for my current one and cannot imagine going forward without it!

Like

I cannot explain how helpful this spreadsheet was! Recently went to Chicago and this was a huge lifesaver in terms of maintaining expenses! Plus, Zach is super helpful and receptive towards any questions you may have! Highly recommend using this spreadsheet!

Like

Zach's expenses sheet was a godsend for a recent holiday! When I ran into an issue (that I caused) he was quick to respond and the issue was solved. So happy I found this template!

Like
bottom of page