โฆ 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
๐ท Payment Ledger
Total Received
ยฃ0.00
Transactions
0
Full Payments
0
Partial Payments
0
| # | Date & Time | Invoice / Ref | Passenger / Client | Type | Sell Price | Amount Paid | Method | Status | Note | Entered By | Del |
|---|---|---|---|---|---|---|---|---|---|---|---|
| No payments recorded yet | |||||||||||
| Total Received: | ยฃ0.00 | ||||||||||
๐ฅ User Management
Add, edit and manage system users. Admin only.