Group Trip Passenger Instalment and Balance Tracker

Group Trip Passenger Instalment and Balance Tracker is an offline app (one HTML file in a zip) for someone who organises group trips. For each trip you enter the fares, the number of seats and the payment milestones: a deposit at booking, a share by a date, a bigger share by a later date and the full amount by a final date. You add the passengers and record each payment. The app shows what every passenger should have paid by today, how much they are behind, and what is still owed overall.

The problem it removes: Group travellers pay in parts, in cash, by transfer and sometimes through a relative, and the organiser keeps the balances in chat messages and a notebook. Nobody knows on a given day who is behind, how much the group has collected, or whether a seat is really free. This app keeps one payment schedule for the trip and measures every passenger against it.

What is inside:

• Trips with fares for adult, child and infant, a single room supplement, a seat limit and four payment milestones as percentages by date
• Passengers with age band, room type, discount, status and a fare worked out from the trip
• Payments and refunds with date, method and reference, and a printable receipt
• For each passenger: fare, paid, balance, the amount due by today from the schedule, the amount behind and a state (On schedule, Behind, Paid in full, Overpaid, Cancelled)
• A seat limit rule that stops booking more passengers than the trip has seats, and cancellation fees that turn into amounts owed or to refund
• Today page with total collected, balances, passengers behind with WhatsApp links, and a printable passenger statement and group balance sheet
• Example data you can load in one click, a Start here guide and an Honest limits panel
• JSON backup and restore, CSV export, and CSV import with a check of every row before anything is added

Who it is for: organisers of group tours, school or club trips, community outings and travel agents who sell group trips and collect payments in several parts.

What it is NOT: It does not take card payments, issue tax invoices or hold passports and visas. It does not decide your cancellation terms: you type the cancellation fee for each passenger. It has no rooming list, flight manifest or itinerary, and it does not send messages by itself. It is not legal, tax or accounting advice, it is not connected to any government system, bank or messaging service, and it does not file or send anything by itself. UAE e-invoicing is not part of it.

Your data stays on this device in your browser. Back it up with Export; clearing browser data loses it otherwise.

Verified by us: scripted tests in Chromium (141 checks through the real screens: adding, editing and deleting records in every table, required-field messages, backup then clear then restore, CSV export then import, keyboard order, print layouts rendered to PDF, no horizontal scrolling at 375 and 1280 pixels, no network requests) and an independent recalculation by a separately written Python evaluator of 1598 calculated values (25 randomised rows plus the example data) with 0 mismatches. Safari engine (WebKit): smoke test passed; Firefox: could not be launched. Not tested: Firefox beyond what is stated here, and no real printer was used (print layouts were checked as PDF).