End-to-End Processing Pipeline & Architecture
3-Year Multi-Currency Ingestion & FX Normalization
Ingests multiple foreign currencies (USD, EUR, GBP, AED, JPY, SGD), applies historical time-series FX conversion rates, and normalizes all spend into INR in Crores (₹ Cr).
Upload Purchase History (Multi-Currency)
Max 2GBUpload Purchase History for Apex Industrial Dynamics
AI automatically detects USD, EUR, GBP, AED, JPY & converts to INR in Crores (₹ Cr)
Uploaded Procurement File Details
Verified dataset with record count strictly excluding header row
Category Spend Breakdown by Fiscal Year (FY24 – FY26)
Fiscal Year: 1st April to 31st March • Total 3-Yr spend for Apex Industrial Dynamics (Fortune 500): ₹732.41 Crores.
Other Balance Categories (7 Minor UNSPSC Segments)
0.4% Total ShareAggregated tail spend across 7 minor UNSPSC segments (Laboratory, Janitorial, Office Spares, Security, Telecom, HVAC & Racks).
Multi-Currency Validation & Line Item Pre-Check (FR-ING-03)
Line-item data cleansing pre-flight check. Converts multi-currency items to Base INR in Crores, highlights unresolved ETL anomalies, and updates active spend calculations in real time.
₹732.41 Cr
44,530 Raw Records Extracted (100% Target)
₹728.76 Cr
3 of 6 Sample Records Cleared
₹3.65 Cr
3 Anomalies Excluded from Analytics
50.0%
Remediation in Progress
| Record & Year | PO & Line Item Description | Category & Column L Code | Vendor Entity | Order Qty (Q) | Net Price (P) | Currency & FX Rate | Line Spend (₹ Cr) | Inclusion & ETL Status | Action |
|---|---|---|---|---|---|---|---|---|---|
| REC-88412024 | PO-2024-99812High Density Polyethylene Granules (25kg Bags) | Direct Materials Col L: 13101502 | Continental Polymer S.A. | 1,000 | EUR 145.00 | ₹90.801 EUR | ₹1.32 Cr 1000×145×90.8 | Missing Currency Code⚠️ Excluded until resolved | |
| REC-88422025 | PO-2025-11029Cross-Border Air Express & Customs Clearance Fee | Logistics & Freight Col L: 78101801 | DHL Logistics GmbH / DHL Express US | 320 | USD 120.00 | ₹84.801 USD | ₹0.33 Cr 320×120×84.8 | Unmapped Supplier Name⚠️ Excluded until resolved | |
| REC-88432025 | PO-2025-44910Double Wall Corrugated Pallet Container 48x40x36 | Packaging Materials Col L: 14121506 | Amcor Packaging Group | 2,000 | USD 44.60 | ₹84.801 USD | ₹0.76 Cr 2000×45×84.8 | Passed CleanActive in Spend (₹0.76 Cr) | Ready |
| REC-88442023 | PO-2023-77123Hydrochloric Acid 37% Tech Grade Bulk Tanker | Direct Materials Col L: 12352204 | Acme Chemical Co. LLC | 650 | GBP 300.00 | ₹102.801 GBP | ₹2.00 Cr 650×300×102.8 | Tax Discrepancy⚠️ Excluded until resolved | |
| REC-88452023 | PO-2023-33901Emergency Centrifugal Pump Impeller Re-machining | Indirect & MRO Col L: 40151501 | Flowserve Industrial Services | 50 | AED 850.00 | ₹22.501 AED | ₹0.10 Cr 50×850×22.5 | Passed CleanActive in Spend (₹0.10 Cr) | Ready |
| REC-88462026 | PO-2026-10022Reinforced Shipping Cartons Heavy Duty 32ECT | Packaging Materials Col L: 14121506 | Crown Paper Box Corp | 10,000 | USD 6.73 | ₹86.501 USD | ₹0.58 Cr 10000×7×86.5 | Passed CleanActive in Spend (₹0.58 Cr) | Ready |