Take control of the group trip
without losing your mind.
Weddings, clubs, school trips: 40 people, 40 payments, 40 passports and a rooming list that changes every week. This kit puts the lot into one Excel workbook with 5 linked sheets — with traffic lights that do the watching for you.
Get the kit by email
Free. Excel, Google Sheets or LibreOffice. In English.
The group is the best sale of the year.
And the worst week of your life.
The group list buried in a WhatsApp thread, the ID documents as loose photos and the payments "jotted down" in three different places.
Finding out 10 days before departure that the best man's passport expires before the return flight.
"Who's paid their deposit?" — and nobody knows for certain.
Redoing the rooming list by hand every time someone swaps rooms.
5 linked sheets.
Type it once, everything updates.
You set the group up on the first sheet and from there the names, payments and rooms flow between sheets without copying anything twice.
Travellers
Paste in the group list and the document alerts light up on their own: expired passport in red, under 6 months in amber, all clear in green.
Payments
Deposit and balance per person with traffic lights (no payments / deposit received / paid) and a panel that adds up live: group total, collected, outstanding and % complete.
Rooming
Create the rooms, assign each traveller from a dropdown (no typing names twice) and the summary warns you if anyone is left without a bed.
Ground handler
The sheet you send to the hotel or your local partner fills itself in with names, documents and rooms — clean, printable and with no payment data on it.
Excel Google Sheets LibreOffice No macros — no security warnings
Inside Manglar, this rooming list
builds itself.
You flag the opportunity as a group trip and everything this kit does lives connected inside the file — customer payments and supplier payments included:
Travellers with automatic alerts
Passport expired or with under 6 months left: the traffic light comes on by itself, with no formulas to maintain. And every traveller stays in your customer database.
Genuine per-person payments
Every traveller gets their own payment link (Stripe, Redsys, PayPal). When they pay, their traffic light switches to PAID on its own — nothing to write down on any sheet.
Rooming list in your brand, in one click
The list for the hotel or the ground handler is generated as a PDF with your logo and your brand colour, always up to date with the latest changes.
Supplier payments connected
Every service in the file with its net rate, its due date and its payment status with the supplier. The group's real margin, always in view.
No card required. The Excel workbook stays yours forever.