top of page

Split Expenses the Old-Fashioned Way, with Google Sheets

  • Writer: Zach
    Zach
  • Dec 1, 2020
  • 1 min read

Updated: Nov 4, 2024

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




 


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.


91 Comments


Sonja Hanchar
Sonja Hanchar
Oct 05, 2024

This is awesome, thank you!

Like

ppakala
Oct 01, 2024

The spreadsheet is very useful. However, how do I know who owes how much to a specific person when multiple paid different amounts throughout the trip? In our case, we had multiple people paying different amounts and curious how do I get the due per person?

Ty

Like

Wmar
Wmar
Sep 01, 2024

how can I get the updated one?


Like

mlwmx3tjo
Jun 27, 2024

Worked well, no help required from Zach - thanks.


Used it in GBP, and started by selecting "File, Settings" to set the default currency and date formats. That made it easy just to click on the columns and then select the £ symbol to change the formats rather than having to change each currency column using a series of menu clicks.

Like

msanand33
Jun 17, 2024

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

SUBSCRIBE TO THE CHEAT SHEETS BLOG

Thanks for submitting!

© 2019 by Cheat Sheets LLC

bottom of page