Air Import 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. "Processing") 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
—
Document check
Orange Channel
—
X-ray required
Red Channel
—
Physical exam
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 (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. ↕ AWB # ↕ Supplier ↕ Item / Cargo ↕ ETA ↕ E2M Date ↕ E2M Stat Status ↕ Port ↕ Delivery Stat Delivery ↕ Detail
✈

Loading shipment data…

Connecting to Google Sheets, please wait.

Loading data…

Change Password