Cello Square

SDS QUOTATION & P&L BUILDER v14.4 Clean Stable

Created by Waradith C.

Samsung SDS
Workflow:1. Header→2. FX→3. Carrier/Schedule→4. Charge Items→5. Review P&L→6. Generate Output

1) Quotation Header

Alias: Pan / Ton / Helen / Jakky / Liu / Ter / Chanon / Kannika. For Non, select from suggestion list.
v11.5 Route Builder / Smart Location Auto Fill
Trade Lane: -

2) FX Master Table

Quotation Currency is controlled from Section 1 only. Real-time FX requires internet and updates only when user clicks the button. If offline, current/manual rates remain active or use the last saved FX cache.
FX Status: Ready
Thai Baht base
US Dollar
Euro
Chinese Yuan
Japanese Yen
Korean Won
Vietnamese Dong
Indian Rupee
Manual currency

3) Carrier / Airline / Schedule Information

Carrier / Airline Service / Flight / Vessel Transit Time Transshipment TS Port / Airport ETD ETA Frequency Action

4) Charge Item Builder

Smart Unit Auto Fill Guide
Ocean FCL20GP, 40GP, 40HC, CNTR, TEU, FEU, BL
Ocean LCLCBM, RT, W/M, Shipment, BL, Pallet
Air FreightChargeable KG, Gross KG, AWB, HAWB, MAWB
CustomsEntry, Declaration, Shipment, Invoice, Permit
TransportTrip, Truck, Container, Route, Day, Hour
WarehousePallet, CBM, SQM, Storage Day, Storage Month, Bin
ExpressKG, Shipment, AWB, Package, Parcel, Carton
Other ChargesJob, Lot, Set, Case, Document, Certificate
v15.0 Smart Charge Template Library
Revenue / Cost / GP summary will refresh after calculation.
v11.4 Commercial Control
SDS Standard: Freight/Trucking = Round Up 100, Local/Customs/Warehouse = Round Up 10, Documentation = Round Up 10. Hotfix: all sell rate rounding is always rounded up to protect GP.
Group Charge Item Description LSP/Carrier Name Unit Volume CCY AP / Unit GP% Sell / Unit AP in Quote CCY Sell in Quote CCY Action
LSP/Carrier Name links each AP rate to the payable vendor for Billing. All charge lines are customer-facing unless quote display option is changed. AP / GP remains internal only.

5) Scope & Remarks

6) P&L Review Before Quotation Ready

Total Revenue / AR
-
Total Cost / AP
-
Total GP
-
Weighted GP %
-

7) P&L by Charge Item with Total Result

GroupItem / DescriptionLSP/Carrier NameCCYRevenue / ARCost / APGPGP%
TOTAL RESULT----

8) Output Prompt

Word Quotation
Customer Quotation Excel
Billing P&L Excel
HTML Customer Email
Click “Refresh Output”.