![expense tracker excel template split expense tracker excel template split](https://images.template.net/wp-content/uploads/2016/04/21114730/Business-Expense-Tracking-Template-Download.jpg)
This is done all in columns A and B, and then marking off their name in column K.
![expense tracker excel template split expense tracker excel template split](https://db-excel.com/wp-content/uploads/2019/01/split-expenses-spreadsheet-for-split-expenses-spreadsheet-parttime-jobs.jpg)
The first step is to get your friends to enter in what they paid for various things on the trip. In case you need the visual, here you go: This way you can actually edit the numbers and names to suit your needs. Open the Google Sheet, and click on File > Make a copy. We went on a trip a few months ago and these are actual costs from the trip, but with names and cost items slightly changed. If we were to e-mail Excel files back and forth, the process would be a nightmare. One of the important features of Google Sheets is that many people collaboratively edit the Sheet and changes are saved on the fly. While Appizy does offer pretty good functionality, we opted for using Google Sheets instead of Appizy or a regular Excel file since it’s just easier to send to friends if you decide to actually use this tool. We talked about a different version of this tool in a story a few months ago we wrote about Appizy.
![expense tracker excel template split expense tracker excel template split](http://myexceltemplates.com/wp-content/uploads/2010/03/Roommate-Budget.jpg)
The Splitting Costs with Friends Google Sheets template is available for purchase here to help solve this widespread social problem of splitting costs with friends. We decided to create a tool that can be used for all scenarios no matter the number of people and costs involved. After every trip, we would find ourselves creating some ad hoc Excel spreadsheet to keep track of expenses and haphazardly figure out who owes who. No matter how organized you are with receipts and how many e-mails you send back and forth with friends, there’s always going to be some confusion with who owes who. Or maybe one person pays for everything, making splitting costs much more easier at the end of the trip. How many times have you gone on a group trip with friends, and figure out the costs at the end of the trip? Maybe one person pays for the hotel, one person pays for the rental car, and someone else pays for the dinners.