Finance Product

MIS Dashboard

Automated financial data extraction from Excel MIS files. AI-powered normalization across varying formats, units, and terminology. Interactive dashboards for investment teams.

Request Demo View Pricing

Portfolio Overview — FinLens

100+

Companies Tracked

₹2,340 Cr

Total Revenue

<3 min

Processing Time

95%

Extraction Accuracy

Company	Revenue	EBITDA%
Alpha Corp	₹84.2 Cr	12.4%
Beta Inc	₹56.8 Cr	-3.2%
Gamma Ltd	₹123.5 Cr	8.7%

THE PROBLEM

Manual MIS Processing Is Broken

Analysts spend 3–5 days/month copying data from 100+ different Excel formats
Varying terminology: "Net Revenue" vs "Revenue from Operations" vs "Top Line"
Different units: Lakhs, Crores, Millions — all in one spreadsheet
Error-prone: one wrong copy-paste can skew investment decisions

THE SOLUTION

AI-Powered Extraction

Processes all 100+ files in under 3 minutes — zero human intervention
3-tier mapping: cache → fuzzy matching → GPT-4o AI fallback
Auto-normalizes all values to INR Crores regardless of source unit
Analyst time reduced from 3–5 days to 1–2 hours (review only)

FEATURES

What FinLens Does

Excel Parsing

Handles merged cells, formula values, date serials, Indian number formatting, and 16 date patterns.

AI-Powered Mapping

3-tier strategy: SHA-256 cache lookup → FuzzySharp matching (240+ synonyms) → GPT-4o-mini for novel formats.

Unit Normalization

Multi-pass detection of Lakhs, Crores, Thousands, Millions. Auto-converts everything to INR Crores.

12 Standard Metrics

Revenue, COGS, Gross Margin, Logistics, CM1/CM2/CM3, Marketing, EBITDA, Net Cash, Total Debt.

Interactive Dashboard

Portfolio overview, fund drill-down, company detail, P&L waterfall, trend charts, and runway gauge.

Review Queue

Low-confidence extractions flagged for analyst review. Approve, reject, or correct inline with dual-write.

ARCHITECTURE

How It Works

Upload

Excel MIS files uploaded to Azure Blob Storage by portfolio companies.

Extract

Azure Functions parse Excel, detect periods, identify metrics via 3-tier AI mapping.

Normalize

Values converted to INR Crores. Derived metrics (EBITDA%, GM%, ROAS, Runway) calculated.

Visualize

Blazor dashboard shows real-time portfolio KPIs, fund comparison, and company deep-dives.