Passenger List

# Title First Name Middle Name Last Name DOB Gender Citizenship Passport # / Expiry Date Email Phone 1 MR Juan Borrego 4/28/1967 M Mexico juanfborre... 5558131940 2 MSTR Juan Borrego 4/27/2000 M Mexico juanfborre... 5558131940 3 MISS Natalia Borrego 4/28/2003 F Mexico juanfborre... 5558131940 4 INFT Eduardo Borrego 4/26/2012 F Mexico       Select Mr Ms Mrs Mast Miss Inft Dr M F Afghanistan Albania Algeria American Samoa Andorra Angola Anguilla Antigua And Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire, St Eustatius and Saba Bosnia Botswana Brazil Brunei Bulgaria Burkina Faso Burundi Byelorussian SSR Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Rep. Chad Chile China Christmas Islands Cocos Keeling Isl. Colombia Comoros Congo Congo (Kinshasa) Cook Islands Costa Rica Croatia Cuba Curacao Cyprus Czech, Rep. Denmark Djibouti Dominica Dominican, Rep. Ecuador Egypt El Salvador Equatorial Guinea Estonia Ethopia Faeroe Islands Falkland Isl. Malvina Fiji Finland France French Guiana French Polynesia Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Iran, Islamic Rep. Of Iraq Ireland Isle Of Man Israel Italy Ivory Coast Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Korea, DPR Korea, Republic Of Kuwait Kyrgystan Lao PDR Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mexico Micronesia Moldova, Republic Of Monaco Mongolia Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Isl. Norway Ocean or Sea Oman Pakistan Palau Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Reunion Romania Russia Rwanda Saint Kitts And Nevis Saint Lucia Samoa San Marino Sao Tome And Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa Spain Sri Lanka St Helena St Pierre & Miquelon St Vincent & Grenada St. Maarten Sudan Suriname Swaziland Sweden Switzerland Syrian Arab Republic Taiwan Tanzania, United Rep. Thailand Togo Tonga Trinidad And Tobago Tunisia Turkey Turkmenistan Turks & Caicos Isl. Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States Uruguay US Minor Outlying Isl. Uzbekistan Vanatu Venezuela Vietnam Virgin Islands, UK Virgin Islands, US Wallis & Futuna Isl. West Indies Yemen, Democratic Yugoslavia zaire Zambia Zimbabwe

Segment Fare List

Type Vendor Start Date End Date Total Fares Booking Status QC Status Deposit Due Date Final Pmt Due Date Cruise Royal Caribbean... 12/15/2012 12/22/2012 $58,874.64 Confirmed Not QC-ED 2/10/2012 10/1/2012

Agency Fees   Description Amount Total agency fares:  $0.00 Select fare item Processing Fee Agency Fee INTERNATIONAL SHIPPING FEE ADMINISTRATION FEE AGENT ERROR Credit Card Surcharge Enter a Valid Amount

Client Payment List
	Payment Type	Paid To/ Paid For	Payer Name/ CC #	Ref. #/ Exp. Date	Payment Date	Agent	Contact Name	Amount
	American Express	To Vendor 1 - Cruise	Juan Francisco ... ...4002	2502440 11/2015	2/10/2012	a.reyes	Ale	$9,525.00
	American Express	To Vendor 1 - Cruise	Alejandro Borrego ...4003	2505049 08/2012	2/13/2012	a.reyes	aLE	$3,175.00
	Pay Direct	To Vendor 1 - Cruise	Royal Caribbean... Royal Caribbean Mexi	2664777	9/5/2012	i.macias	Irma	$46,174.64
Total Payments:								$58,874.64

Client Balance Summary
Total of Active and Cancelled Segments:	$58,874.64
Total of Pending and Quote Segments:	$0.00
Total of All Segments:	$58,874.64
Total Agency Fees:	$0.00
Total Invoice Charges:	$58,874.64
Amount Paid to Date:	$58,874.64
Balance Due From (To) Client:	$0.00

Profit Calculation  Adjustment/Agent Error:
Type	Vendor	Gross Amount	Commission Amount	Net Amount	Pax Amount	Profit
Cruise	Royal Caribbean Int.	$58,874.64	$4,852.32	$54,022.32	$58,874.64	$4,852.32
Total Fares:		$58,874.64	$4,852.32	$54,022.32	$58,874.64	$4,852.32

Profit on Invoice
Profit on All Segments:	$4,852.32
Total Agency Fees:	$0.00
Total Invoice Profit:	$4,852.32

Accounting Profit Offset
Type	Vendor	Commission Amount Due	Accounting Profit	Balance
Cruise	Royal Caribbean Int.	$4,852.32	$0.00	$4,852.32
Totals:		$4,852.32	$0.00	$4,852.32

Agent Payment Details
1 - Cruise (5402120)	$0.00
Total Amount Received:	$0.00
Amount Paid to Agent:	$0.00

Comment to Client

Supervisor Comment

Last In-house Comment  [Date & Time: 4/22/2012 3:41:01 PM]

Sailing modified: arrival.

Click on a button to add a segment