# Trip organizer Excel (free): payments and costs

> Free Excel sheet to organise a group trip: participants, seats, rooms, instalments and who has not finished paying, cost per person, break-even, expense split.

Source: https://softwiro.com/blog/trip-organizer-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Trip organizer in Excel (free): participants, instalments, costs and itinerary

One workbook for participants, seats and rooms, instalments, costs per person, break-even, itinerary and friends' expense split.

15 November 2026 6 min read

## In short

- Each payment is typed once; the sheet shows paid, balance and a list sorted by who owes most.
- Costs are fixed or per person, with a contingency %, giving the cost per person and the surplus.
- Break-even shows how many participants cover the cost, so you can decide before announcing the trip.
- Warnings for a duplicate seat, a full room or a missing emergency contact, plus a friends' expense split.

You are organising a trip for a school, company, club or group of friends, and you want to know without scrolling through chats: who confirmed and who cancelled, how much each person paid and still owes, what the trip costs per person, how many people you need so you do not lose money, and who sits where. The free [trip organizer sheet](https://softwiro.com/templates/trip-organizer) keeps it together: participants, payments, costs, rooms, itinerary, a checklist, and an expense split for friends. (The template page is in Arabic.)

## The problem it solves

On most trips names sit in a chat group, payments on a slip and costs in another file. When someone asks how much is left on their account, or you want to know whether the trip still covers itself if two people drop out, you get lost adding things up. Here each fact is typed once: the person in "المشتركون" (Participants), the payment in "الدفعات" (Payments), the trip costs in "التكاليف" (Costs), and the rest is calculated. If you are a travel agency, use the [travel agency bookings sheet](https://softwiro.com/templates/travel-agency-bookings) and read its [guide](https://softwiro.com/blog/travel-agency-bookings-free-excel-online.html).

## Steps, from opening the file to the decision

1. Trip: enter the destination, departure and return dates, today's date, the last payment date, seats per bus, adult price, child price and the contingency %.
2. Participants: one row per person with number, name, phone, type, status (confirmed or cancelled) and discount, then room, bus, seat and emergency contact.
3. Payments: one row per payment with the participant number, amount and method; the sheet works out paid and balance.
4. Costs: each item is fixed for the trip or per person, with unit price, quantity and times.
5. Rooms, itinerary and checklist: add the rooms, the day plan and what must be done.
6. Open Late payers and Summary.
7. For friends: Expense split, then Who pays whom.

## What each sheet does

"Participants" shows payment status (paid, partial, nothing paid, or refund due) and flags a duplicate seat, a full room or a missing emergency contact. "Late payers" sorts by the biggest balance on its own. "Costs" multiplies a per-person item by the confirmed head count and adds the contingency. "Rooms" compares occupants with capacity. "Summary" shows the break-even and the surplus with three charts.

## A walk-through on the sample numbers

These are made-up sample names and numbers for a four-day trip to Luxor and Aswan (adult 6,500, child 4,500):

- Participants: 24 confirmed (18 adults, 6 children) and one cancelled person who paid 2,000, shown as refund due.
- Expected revenue: 142,500 after two discounts (500 and 1,000).
- Payments: collected 99,000 (69.5%), balance 43,500 across 15 people: 9 paid in full, 13 part-paid and 2 paid nothing. The biggest balance is 4,500 for Salma Hassan (paid 2,000 of 6,500).
- Cost: fixed 66,700 (two minibuses, hotel rooms, guide, Nile boat) and per-person items 51,600 (meals, tickets, insurance), plus 5% contingency = 5,915, so the total is 124,215 and the cost per person 5,175.63.
- Surplus: 142,500 − 124,215 = 18,285 (12.8% of revenue).
- Break-even: average price per person 5,937.50, variable cost per person with contingency 2,257.50 and fixed cost 70,035, so break-even is 20 participants, a safety margin of 4.
- Logistics: two buses (14 seats each) with four empty seats, ten rooms holding 24 people, one warning because Eman Zakaria has no emergency contact, and 4 of 12 checklist items done with two overdue.
- Friends: expenses of 14,000 over 7 shares (Karim has two), so a share is 2,000. Net: Karim +2,000, Sara +100, Ahmed 0, Mahmoud −200, Mona −500, Yasmin −1,400. Yasmin pays 66.67 to Sara and 1,333.33 to Karim.

## Common mistakes

- Leaving a participant's status blank so they are not counted in cost and revenue: type "confirmed".
- Marking meals as "fixed" so they do not multiply by head count.
- Logging a payment under the wrong participant number: it shows "participant not found".
- Not updating today's date, so items do not show as overdue on time.
- The prices here are illustrations: use your suppliers' real prices and check licences and insurance under local law.

## When to move to a system

If you run several trips a month and want people to register through a link, pay online and receive an instalment reminder, a [custom system](https://softwiro.com/contact) serves you better than a file one person edits at a time.

## Try it now

[Open the sheet and try it online, or download the Excel file](https://softwiro.com/templates/trip-organizer), clear the samples, enter your trip price and your first ten participants today, and look at the break-even before you announce the trip. If you want something tailored, [request it here](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: trip organizer (1/3)](https://softwiro.com/uploads/cheatsheets/trip-organizer/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/trip-organizer/en-1.jpg)[![Cheat sheet: trip organizer (2/3)](https://softwiro.com/uploads/cheatsheets/trip-organizer/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/trip-organizer/en-2.jpg)[![Cheat sheet: trip organizer (3/3)](https://softwiro.com/uploads/cheatsheets/trip-organizer/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/trip-organizer/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I work out the cost per person on a group trip?

Enter the cost items in the Costs sheet and mark each as fixed for the trip (bus, guide) or per person (meals, tickets). The sheet adds them up, adds the contingency % and divides by confirmed participants.

### What does break-even mean in the sheet?

The smallest number of participants whose fares cover the cost: fixed cost with contingency ÷ (average price per person − variable cost per person with contingency), rounded up. It is an estimate that moves with the child share and discounts.

### How do I see who has not finished paying?

Log each payment with the participant number in Payments. Participants works out each balance and the Late payers sheet lists everyone who still owes, biggest first, with a phone number.

### How do I split trip expenses between friends?

In the Expense split sheet enter the names (two shares for someone with family) and who paid each expense. The sheet gives each person's share and net, and Who pays whom shows the amount between each debtor and creditor.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
