Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesTravel & HospitalityTrip PlanningGroup Trip Expense Splitter

SpreadsheetTrip PlanningFree

Group Trip Expense Splitter

Log who paid for what on a shared trip and see exactly who owes money and who is owed.

Shown with sample data

Colour

Group Trip Expense Splitter

Log who paid for what on a shared trip and see exactly who owes money and who is owed.

Trip total
$3,065
Share per person
$766.25
Expenses logged
8
Largest expense
$1,680
Paid by each person
  • Alex$1,800
  • Bea$572
  • Dee$438.60
  • Chris$254.40

How to use it

  1. 1List everyone on the Balances sheet.
  2. 2Add each shared expense with who paid.
  3. 3Leave out personal spending.
  4. 4At the end, people who owe pay those who are owed.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

End the trip as friends. Enter every shared cost with who paid; the sheet divides the total equally, compares it with what each person actually paid and tells each traveller whether they owe money or are owed it, so settling up takes one round of transfers.

Who it’s for

  • Holidays with friends
  • Stag, hen and group weekends
  • Shared house or project costs

What’s included

  • Expenses sheet: One row per shared expense.
  • Balances sheet: What each person paid, their equal share and the difference.

How to use it

  1. 1List everyone on the Balances sheet.
  2. 2Add each shared expense with who paid.
  3. 3Leave out personal spending.
  4. 4At the end, people who owe pay those who are owed.

Questions

What if a cost was not shared by everyone?

Leave it out of this sheet and settle it between the people involved, or enter it as two rows paid by each of them.

Related searchessplit expensesgroup trip costsshared expenses calculatorwho owes whotravel cost split

Details

Format
Spreadsheet
Category
Trip Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetTrip PlanningFree

Group Trip Expense Splitter

Log who paid for what on a shared trip and see exactly who owes money and who is owed.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Trip Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More trip planning templates

View all
Travel Itinerary Planner
  • Apr10NYC JFK → Lisbon LIS (TP210)Flight
  • Apr10Hotel Alfama: 4 nightsHotel
  • Apr11Belém walking tourActivity
  • Apr11Dinner at Taberna da RuaRestaurant
SpreadsheetTrip Planning

Travel Itinerary Planner

Day-by-day plan with times, places, bookings, confirmation numbers and costs.

10 min setupPreview
Trip Budget Planner2 sheets

Total budget

$3,915

Spent

$3,650

Per person

$1,825

Actual spend by item
37%
  • Return flights (2)
  • Hotels (7 nights)
  • Restaurants & cafés
  • Tours & tickets
SpreadsheetTrip Planning

Trip Budget Planner

Plan and track travel spending by category with per-person and per-day costs.

10 min setupPreview
Packing List2 sheets

Items

13

Packed

38%

Still to pack

8

ABCD
1CategoryItemQtyWho
2DocumentsPassports2Sam
3DocumentsTravel insurance printout1Sam
4DocumentsBoarding passes2Sam
5ClothingT-shirts6Each
Checklist
SpreadsheetTrip Planning

Packing List

A reusable packing checklist by category with packed status and trip type filters.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ