JM Travel and Tours Ltd — Booking System

🗂 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

💷 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.