Updated & Improved - Google Sheets Expense Split Template
- Zach
- Sep 20, 2024
- 2 min read
100K posts on the original post!? Didn't see that coming. Take this as my token of appreciation. Here are the new and improved Google Sheets expense templates.
A few years ago, I created a simple post with a simple template for splitting expenses (oh, and a simple message - that Splitwise sucks and you shouldn't use it). Somehow it's managed to pick up over 100,000 views. Not sure how that happened, but hey! I'm not complaining.
In that post, I offered up: "If you have any issues or requests - email me." Well... I got a lot of emails. With a lot of suggestions. I created these updated versions based largely on those suggestions.
The Basic (Updated) Template << Click to create your copy.
If you're splitting expenses evenly amongst a group of people. This is your template.
The Two-Person Version << Click to create your copy.
For splitting just with 1 other person. This also allows you to do uneven splits (say you and your roommate split everything 60/40)
For Groups or Families << Click to create your copy.
What if you go on a vacation with multiple families. What if the families are of different sizes? Also, do you want to know that your friend's kid owes you money or just that that family owes your family? This template helps with all that.
Un-Even Splits << Click to create your copy.
In this version, expenses aren't necessarily split evenly. You can choose to have 1 person pay 70%, another pay 20% and the other pay 10% (for example).
Multiple Currencies (or just not USD) << Click to create your copy.
This version lets you use other currencies. Or multiple currencies.
Questions / suggestions / requests / etc - you know where to find me.
What a gift! I downloaded and customized (with a lot of help from Zach) the two-person version. It's working just as I had hoped and I didn't have to go through an app and worry about my data getting in to the wrong hands. Looking forward to using one for groups on my next adventure! Thank you so much Zach. Truly appreciated.
Liz
I am not excellent with Excel or Google Sheets, and neither is my roommate, so I used Perplexity for recommendations and found Zach's template. It was easy to input, but I still managed to screw some things up. While embarrassed about my lack of competency in this arena, I have learned to ask for help. I reached out to Zack, and he told me that there was a better version of the template to use that I had totally missed. Zack showed such kindness to me by helping me out. He went over and above anything that I could have expected and totally made my day. Thank you, thank you, thank you, and you do this for what you d…
The currencies template is super helpful! Have an international trip coming up where cash is king so I think I'll sit down to edit my previous "color coded" template from your original base expense splitting that I made last summer. Hopefully the goal is to turn it into a travel log where it has trip planning to do tabs, reservation info, budget summary, and the expense tracking (with currency converters). Thanks as always for sharing the templates and keeping them free!!
Wish me luck :)
-Molly