{"product_id":"group-trip-expense-splitter","title":"Group Trip Expense Tracker Spreadsheet","description":"\u003cp\u003eThis group trip expense tracker is for the friend who ends up holding the receipts. Log each shared cost with who paid and who it was for, and the file works out everyone's share and the fewest payments that settle the trip.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose everyone or one friend, and the cards, charts and tables follow. The page fills itself from your expenses.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFive live cards: trip total, who paid most, still to settle, payments and paid back\u003c\/li\u003e\n\u003cli\u003eWhat each person paid out next to what their share came to\u003c\/li\u003e\n\u003cli\u003eWho pays whom: the fewest payments that square everyone\u003c\/li\u003e\n\u003cli\u003eWhere the money went: lodging, food, activities and the rest, each as a percentage\u003c\/li\u003e\n\u003cli\u003eThe six biggest costs and who paid for them\u003c\/li\u003e\n\u003cli\u003eWho owes and who gets money back, either side of one line\u003c\/li\u003e\n\u003cli\u003eEvery day's spending, and each person's share of every category\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSplit expenses your way\u003c\/h2\u003e\u003cp\u003eEach cost can be split equally between everyone, by share for someone bringing a partner or a child, or only between the people you tick on that row. The file works out each person's share of every cost, for up to ten people and 300 costs, which covers a girls trip, a bachelor party or a family week away.\u003c\/p\u003e\u003ch2\u003eSettle up in the fewest payments\u003c\/h2\u003e\u003cp\u003eThe Settle Up tab answers who owes who: it lists the fewest payments that square everyone, and how much each one is. Log a payment back and both people move toward square, so you can see how far the group still has to go.\u003c\/p\u003e\u003ch2\u003eWhere the shared expenses went\u003c\/h2\u003e\u003cp\u003eBy Category shows every category of travel expenses, what each person's share came to and who paid for what.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Expenses, Settle Up, By Category and Dashboard.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example: a week at the beach for seven friends, with 32 shared costs\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan we use it in Google Sheets so everyone can see it?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan one person pay a bigger share?\u003c\/h3\u003e\u003cp\u003eYes. Split a cost equally, by share for someone bringing a partner or a child, or only between the people you tick on that row.\u003c\/p\u003e\u003ch3\u003eHow does it work out who owes who?\u003c\/h3\u003e\u003cp\u003eSettle Up lists the fewest payments that square everyone and the amount of each. Paybacks you log move both people toward square.\u003c\/p\u003e\u003ch3\u003eHow many people and costs does it hold?\u003c\/h3\u003e\u003cp\u003eUp to ten people and 300 costs.\u003c\/p\u003e\u003ch3\u003eIs there a worked example?\u003c\/h3\u003e\u003cp\u003eYes. The filled copy is a week at the beach for seven friends with 32 shared costs, and a blank copy is included for your trip.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597875642462,"sku":"OPX-234","price":15.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/group-trip-expense-splitter-01.jpg?v=1790833264","url":"https:\/\/opxviashop.com\/products\/group-trip-expense-splitter","provider":"OPXVIA","version":"1.0","type":"link"}