📊 Overall Overview
Complete import shipment performance at a glance
🏭 Branch: MUMBAI - SAKINAKA
📅 FY 2026-2027
👤 KAM: Prashant Parab
🏢 RAYZON SOLAR LIMITED
42
Total Active Jobs
All Ports | All Countries
📦 Shipment & Logistics Overview
Total Shipments
42
Active Jobs: 42
View Details →
Total Containers
447
20ft: 230 | 40ft: 217
View Details →
Countries of Origin
3
China | Malaysia | Vietnam
View Details →
Suppliers
6
Shipping Lines: 7
View Details →
Avg TAT (Days)
6.6
ETA → Out of Charge
View Details →
💰 Financial Overview (INR)
Total Assessable Value
₹61.94 Cr
619,400,989
View Details →
Total Duty Amount
₹20.93 Cr
BCD + SW + IGST
View Details →
BCD | SW | IGST
₹4.40 | ₹0.43 | ₹12.80 Cr
Duty Breakdown
View Details →
Total CFS Expense
₹54.58 L
105 Invoices | 41 Jobs
View Details →
📊 Assessable Value & Duty by Country
INR values grouped by origin country
🥧 Shipment Share by Country
Count distribution
🏭 Supplier Wise Duty Summary
Top suppliers by total duty amount
🚢 Container Split Overview
20ft vs 40ft container distribution
🌍 Country of Origin Summary
Click any row for detailed shipment breakdown
| Country of Origin | Shipments | Assessable Value (INR) | Duty Amount (INR) | Avg TAT (Days) | Action |
|---|---|---|---|---|---|
🏭 Supplier Wise Summary
Click any row for detailed job breakdown per supplier
| Supplier | Shipments | Assessable Value (INR) | Duty Amount (INR) | Action |
|---|---|---|---|---|
⏱️ Clearance Performance
TAT Analysis, Container Summary, Port & Country Performance
Port: Nhava Sheva (INNSA1)
Avg TAT: 6.6 Days
41 Shipments Tracked
6.6
Avg Clearance Days
ETA → Out of Charge
⏱️ TAT Distribution Overview
Excellent (0-3 Days)
8
19.5% of shipments
View Details →
Good (4-5 Days)
15
36.6% of shipments
View Details →
Moderate (8-10 Days)
9
22.0% of shipments
View Details →
Delayed (11-15 Days)
5
12.2% of shipments
View Details →
Critical (16+ Days)
2
4.9% of shipments
View Details →
📊 TAT Distribution — Shipment Count
Number of shipments in each TAT bracket
🥧 TAT Category Share
Percentage distribution of clearance speed
⏱️ Clearance TAT — ETA to Out of Charge
Detailed TAT analysis by category
| TAT Category | No. of Shipments | % of Total | Min TAT | Max TAT | Avg TAT |
|---|---|---|---|---|---|
📦 Container Summary — 20ft vs 40ft
Total container count by type
🚢 Shipping Line — Count & Avg Validity
Shipment count and average validity days
🚢 Shipping Line Wise Summary
Container count and validity analysis per carrier
| Shipping Line | Shipments | 20ft | 40ft | Total Containers | Avg Validity (Days) | Action |
|---|---|---|---|---|---|---|
🌍 Country of Origin — TAT & Value Performance
Avg clearance days and total assessable value by origin
📦 Product Summary
Duty, Assessable Value, BCD, SW & IGST Analysis
7 Products | 4 CTH Codes
6 Suppliers
₹65.34 Cr Total Assessable Value
₹21.67 Cr
Total Product Duty
BCD + SW + IGST Combined
📦 Product Duty Breakdown
Total Assessable Value
₹65.34 Cr
Product Level Total
View Details →
Total BCD Duty
₹4.40 Cr
Basic Customs Duty
View Details →
Total SW Duty
₹0.43 Cr
Social Welfare Surcharge
View Details →
Total IGST Duty
₹12.80 Cr
Integrated GST
View Details →
📊 Product Wise — Total Duty (INR)
Stacked BCD + SW + IGST by product
🥧 Product Duty Share
Contribution to total duty
📦 Product Wise Duty Summary
Click any row to see CTH and job level details
| Product Description | Items | Assessable Value (INR) | BCD Duty | SW Duty | IGST Duty | Total Duty | Action |
|---|---|---|---|---|---|---|---|
🔢 CTH Wise — Duty Distribution
Duty breakdown by CTH code
📊 CTH Wise — Assessable Value vs Duty
Comparison of value and duty per CTH
🔢 CTH Wise Duty Summary
Click any row for detailed product breakdown
| CTH Code | Items | Assessable Value (INR) | BCD Duty | SW Duty | IGST Duty | Total Duty | Action |
|---|---|---|---|---|---|---|---|
🏭 Supplier Wise Duty Summary
Total duty by supplier
| Supplier Name | Shipments | Assessable Value (INR) | BCD Duty | SW Duty | IGST Duty | Total Duty | Action |
|---|---|---|---|---|---|---|---|
💰 Expense Summary
Vendor, Type & Job-wise expense analysis
105 Invoices
41 Jobs
8 Vendors
6 Expense Types
₹54.58 L
Total Expense (INR)
CFS + Stamp + Insurance + Others
💰 Expense Overview
Total Expense
₹54.58 L
105 invoices
View Details →
CFS Payment
₹45.98 L
84.2% of total | 52 invoices
View Details →
Stamp Duty
₹8.29 L
15.2% of total | 41 invoices
View Details →
TDS Deducted
₹0.67 L
Net Payable: ₹53.91 L
View Details →
🏢 Vendor Wise Expense
Total invoice amount per vendor
🥧 Expense Type Distribution
Share of each expense category
🏢 Vendor Wise Expense Summary
Click any row to see job-level invoices for that vendor
| Vendor Name | Invoice Count | Total Amount (INR) | TDS | Net Amount | Pay Mode | Action |
|---|---|---|---|---|---|---|
📋 Expense Type Wise Summary
Breakdown of expenses by type
| Expense Type | Invoice Count | Total Amount (INR) | % of Total | Visual |
|---|---|---|---|---|
📁 Job Wise Expense Summary
Top 20 jobs by expense amount — click row for invoice details
| Job No | Invoices | Total Expense (INR) | CFS Amount | Stamp Duty | Other | Action |
|---|---|---|---|---|---|---|
📋 Raw Data View
Explore the complete raw datasets from uploaded files
Upload XLSX to refresh
All 3 data sources
🚢 Shipment Data (42)
📦 Product BE Data (76)
💰 Expense Data (105)