TripSplit v0.2

Google Sheet for divvying up expenses on a trip

UPDATE (9 Mar): I've updated this for international travel (story here), so versioned it

This tool is currently in Google Sheet form. I've presented it as read only below, so to get your own copy, click the link, then go to File -> Make a Copy.

Instructions (international):

  1. Enter the guests names in H2:W2
  2. Enter applicable currencies in A25:A40
  3. Share the sheet with your friends
  4. Record each expense in D:G, and who used them in H:W
  5. Update the currencies by going to the "TripSplit" menu and selecting "Update Exchange Rates"
  6. At the end, have everybody pay (Venmo/Paypal) the person who is owed the most money
    Note: that person will then need to pay out anybody else who is owed money


If you don't need multi-currency support, feel free to just use this older copy (v0.1)

Instructions (domestic):

  1. Enter the guests names in G2:V2
  2. Share the sheet with your friends
  3. Record each expense in D:F, and who used them in G:V
  4. At the end, have everybody pay (Venmo/Paypal) the person who is owed the most money
    Note: that person will then need to pay out anybody else who is owed money