SEA LCL Report Dashboard

β€”
β€”
Not yet refreshed + New Shipment
Filter Applies to all KPIs and charts above β€” Total Shipments through Cash Advance Entries. Search also matches CA Purpose β€” type a purpose (e.g. "Storage Charges") to use this as a quick Billing Summary. The Shipment Records table below has its own independent filter.
Total Shipments
β€”
All records
Green Channel
β€”
Cleared
Yellow Channel
β€”
Doc check
Orange Channel
β€”
X-ray
Red Channel
β€”
Physical exam
In Warehouse
β€”
Transferred / Stripped
Performance KPIs
On-Time Delivery Rate
β€”
Reliability Β· delivery ≀ release +1 day
Clearance Turnaround
β€”
Speed Β· avg. days, ETA to release
Cost Savings Achieved
β€”
Value delivered Β· vs. previous freight
Doc Accuracy Rate
β€”
Compliance Β· Docs Status field
Duties & Taxes Processed
β€”
Value delivered Β· sum of assessed D/T

Shipments by Entry Status

Shipments by Month (ETA)

Cash Advance Summary (In-House)
Total CA Amount
β€”
All shipments
CA Entries
β€”
Line items with an amount
Shipments w/ CA
β€”
Have β‰₯1 entry
Avg per Shipment
β€”
Total Γ· shipments w/ CA

Cash Advance by Purpose

Cash Advance by Bank

Cash Advance Entries

Ref. No.DateCA #Purpose ToBankAmountRemarks
πŸ’΅

Loading…

Shipment Records

Ref. No. ↕ BL # ↕ Supplier ↕ Vessel ↕ Cargo ↕ ETA ↕ Status ↕ Warehouse ↕ WH Status ↕ Storage Fee ↕ Delivery Dt ↕ Delivery Stat Detail
πŸ“¦

Loading shipment data…

Connecting to Google Sheets, please wait.

Loading data…

Change Password