This is done all in columns A and B, and then marking off their name in column K. 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. We decided to create a tool that can be used for all scenarios no matter the number of people and costs involved. Here’s the link to the tool we developed in Google Sheets to help solve this widespread social problem of splitting costs with friends. 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. expense report, financial analyst, financial modeler, google sheets, group trips, splitting costs, sumif, sumproduct.
Home / Splitting Costs With Friends Just Got Easier In A Spreadsheet Splitting Costs With Friends Just Got Easier In A Spreadsheet
0 kommentar(er)
