RRico AutoExecutive Cockpit

Data Health & Lineage

Can you trust the number, and how current is it? Every governed domain's source system (SAP S/4, plant MES, Salesforce, BSE/NSE), owner, freshness against SLA, record count and data grain — so a decision knows what it's standing on.

Rico Auto Industries Limited · FY26 (Mar'26, actuals)
Leading Indian aluminium high-pressure die-casting auto-components maker
7,500 employees · 8+ plants & units · 12 export markets
🌐 Enterprise 360 modules· on Data HealthBrowse all 31 views ▾
10/12
Sources fresh
within SLA
1
Stale
past cadence
1
Late (SLA breach)
needs attention
17,130
Records governed
across domains
Ingestion heartbeat

Source freshness & lineage

Grain tells you how bankable a domain is (Actuals = plant-grain SAP ledger; Allocated/Region-only = estimated while the cutover completes). Status flags anything past its SLA.

DomainSource systemOwnerLast syncCadenceSLAStatusRecordsGrainNote
External signals — BSE/NSE filingsBSE/NSE / SEBI adapterStrategy2026-06-15 06:00Daily24hLate4ActualsListed-co disclosures; last poll missed SLA.
Order / QuotingSAP SD + estimatorsRevOps2026-06-16 21:00Daily24hStale1,600Region-onlyAAN aero-defence estimator export blocked (open blocker).
General Ledger / P&LSAP S/4 (core ERP)Controller2026-06-17 04:10Nightly24hFresh1,850ActualsCore divisions on the common ledger.
Accounts ReceivableSAP S/4 ARTreasury2026-06-17 04:12Nightly24hFresh35ActualsOpen-invoice level; drives DSO & collections.
CRM / OEM AccountsSalesforce + legacy plant CRMsRevOps2026-06-17 03:50Hourly4hFresh2,400AllocatedEntity resolution applied; some units pre-migration.
Plant MES / ProductionPlant MES + die-casting line busManufacturing2026-06-17 02:30Hourly4hFresh1,850AllocatedAAN / EV-Hosur still on legacy MES.
Machine telemetry (OEE)Industry-4.0 telemetry busManufacturing2026-06-17 05:08Streaming1hFresh1,850ActualsDie-cast / CNC machine health / OEE / maintenance posture.
HR / WorkforceWorkdayCHRO2026-06-17 04:00Nightly24hFresh7,500ActualsPlant workforce, skilling, utilization.
Growth & capex pipelineStrategy / PMO trackerStrategy & Growth2026-06-16 18:20Manual72hFresh7ActualsInitiative funnel & capex diligence.
External signals — NewsNews adapter (RSS/API)Strategy2026-06-17 05:01Streaming2hFresh6ActualsWatchlist: OEM customers, LME aluminium, peers, EV/PLI policy.
Treasury / DebtBank feeds + lender portalTreasury2026-06-17 04:05Nightly24hFresh4ActualsCash positions, covenant, debt stack.
Transformation PMOPMO tracker + state.dbTransformation PMO2026-06-17 05:09On change24hFresh24ActualsWorkstreams, blockers, decisions.
Read this: the Order/Quoting feed is stale (the AAN aero-defence estimator export is blocked — see Transformation 360) and the BSE/NSE filings poll is late. Everything else is within SLA. Figures are modeled; this panel simulates the ingestion heartbeat the live adapters would write.
14
Identities tested
governed tie-outs
13
Tie out (≈0)
components = total
1
Flagged
residual over tolerance
₹280 Cr
Max residual
largest break
Do the numbers tie out?

Reconciliation tests

Each governed metric must equal the sum of its components (residual ≈ 0). Run live on the dataset — the two flags are the known modelling gaps, not silent errors.

GroupIdentityComponents vs totalResidualStatus
Revenue roll-upRevenue = Σ divisionsΣ division revenue = total revenue₹2,477 Cr vs ₹2,477 Cr₹0 Cr✓ ties
Revenue roll-upRevenue = Σ geographiesΣ geography revenue = total revenue₹2,477 Cr vs ₹2,477 Cr₹0 Cr✓ ties
Revenue roll-upRevenue = Σ end-marketsΣ end-market revenue = total revenue₹2,477 Cr vs ₹2,477 Cr₹0 Cr✓ ties
Revenue roll-upRevenue = Σ plantsΣ plant revenue = total revenue₹2,477 Cr vs ₹2,477 Cr₹0 Cr✓ ties
ProfitEBITDA QoE bridgeReported + add-backs = Adjusted EBITDA₹223 Cr vs ₹223 Cr₹0 Cr✓ ties
ProfitRun-rate normalization ladderReported + add-backs + unbanked + annualize − leakage = Run-rate₹240 Cr vs ₹240 Cr₹0 Cr✓ ties
Value-addedValue-added revenue bridgeBeg + New + Expansion − Contraction − Churn = Ending₹545 Cr vs ₹545 Cr₹0 Cr✓ ties
Value-addedValue-added = product-line bookbridge close = Σ value-added product-line revenue₹545 Cr vs ₹545 Cr₹0 Cr✓ ties
Capital / valueEV / market-cap bridgeEV − net debt − adjustments = shareholder value₹971 Cr vs ₹971 Cr₹0 Cr✓ ties
Capital / valueLeverage = Net debt / EBITDAcurrent leverage = end debt ÷ LTM EBITDA3.08x vs 3.08x0.004✓ ties
CashAR = DSO-implied receivablesΣ AR aging ≈ revenue × DSO ÷ 365₹373 Cr vs ₹373 Cr₹-0 Cr✓ ties
Growth initiativesInitiative pricing identitycapex = multiple × revenue × EBITDA% (worst of 7 initiatives)max residual ₹0 Cr across 7 initiatives₹0 Cr✓ ties
Cross-grain (flags)Installed machines = Σ plant machinesmachine metric = Σ site.devices1,850 vs 1,890-40✓ ties
Cross-grain (flags)Value-added = Σ plant value-addedproduct-line revenue = Σ site.arr₹545 Cr vs ₹825 Cr₹-280 Cr⚠ flag
Read this: 13 of 14 governed identities tie out to the rupee. The 1 flags are intentional, known modelling gaps — the plant-grain installed-machine count and value-added revenue don't fully foot to the headline (representative footprint vs. true total). The harness catches them rather than hiding them — exactly what a CFO/auditor wants to see.