✦ Est. 2010 · ATOL Protected ✦
JM TRAVEL
AND TOURS LTD
Booking Management System
📍 44 Watling Ave, Burnt Oak, Edgware HA8 0LT | 📞 07900 123058
✦ Select Booking Type ✦
🗂 All Bookings
0 records
| # | Invoice | Passenger | PNR | Type | Pax | Route | Travel | Issued | Agent | Cost | Sell | Profit | Status | Payment | Special Note | Actions |
|---|
📊 Reports
| # | Invoice | Passenger | Ticket/PNR | Pax | Issued Date | Travel Date | Agent | Supplier | Issued At £ | Sold At £ | Profit £ | Payment | Status |
|---|
🧾 Invoices
🛂 Visa Report
| # | Date Applied | Client Name | Visa Type | Cost (£) | Sale (£) | Profit (£) | Actions |
|---|---|---|---|---|---|---|---|
| Total | £0.00 | £0.00 | £0.00 | ||||
🏨 Hotel Bookings
| Date | Full Name | Booking Ref | Hotel | Check-in | Check-out | Agent | Cost (£) | Sell (£) | Profit (£) | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Totals | £0.00 | £0.00 | £0.00 | ||||||||
↩ Refund Report
| Invoice | Passenger | PNR | Route / Hotel | Type | Booking Date | Charges | Refund Date | Total Refund | Profit | Status | Refund Paid | Actions |
|---|
⭐ Additional Services
| # | Date | Client Name | Service Type | Cost £ | Sell £ | Profit £ | Payment | Agent | Notes | Actions |
|---|
📊 Excel Sheet Import
Upload your Excel (.xlsx/.xls) report files — data is mapped to system fields automatically
📥 Import April 2026 Bookings (125 records)
Imports passenger name, dates, PNR, cost & sell price from the supplied report. Profit is calculated automatically.
📁 Upload Excel File
📊
Drop Excel file here or click to browse
Supports: .xlsx · .xls · .csv — upload one file at a time
No file selected
🗂 Column Mapping
Map your Excel columns to system fields. Only these fields are imported:
Upload a file to see column mapping.
Importable fields:
Passenger Name · Issue Date · Travel Date · PNR/Ref · Airline · Route · Supplier · Cost Price · Sell Price · Payment Method · Payment Status · No. of Passengers · Notes · Issued By
Importable fields:
Passenger Name · Issue Date · Travel Date · PNR/Ref · Airline · Route · Supplier · Cost Price · Sell Price · Payment Method · Payment Status · No. of Passengers · Notes · Issued By