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 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 and read its guide.
Steps, from opening the file to the decision
- 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 %.
- Participants: one row per person with number, name, phone, type, status (confirmed or cancelled) and discount, then room, bus, seat and emergency contact.
- Payments: one row per payment with the participant number, amount and method; the sheet works out paid and balance.
- Costs: each item is fixed for the trip or per person, with unit price, quantity and times.
- Rooms, itinerary and checklist: add the rooms, the day plan and what must be done.
- Open Late payers and Summary.
- 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 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, 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.





