Diversified group

From 200 hours of chasing data to an automated monthly review

A diversified group with turnover above $800 million across 25 entities was spending 180–200 hours a month chasing, validating and formatting data for its monthly business review. We rebuilt the process on Finlens — companies upload, the system validates, reporting is automated.

60% less reporting time
180–200 hrs per month of manual work removed
25 entities in one executive view
~25 KPIs across 6 categories
0 follow-up emails in the cycle

The challenge

Preparing the monthly business review meant collecting data from 15–20+ companies by email and follow-up. A dedicated team member spent roughly 180–200 hours a month chasing submissions, validating numbers, consolidating, formatting and building the presentation — before any analysis started. Every company had its own P&L format built around its own business, so consolidation was manual, and group KPIs, cash positions and budget-versus-actual comparisons arrived late and inconsistently.

What we built

The reporting cycle now runs itself. Each company uploads its own data against a set deadline; the system validates it on submission; the company reviews and comments on its own numbers and submits; the group sees the data as it lands; and the group company owner locks the period once it is final. An Excel add-in pulls and pushes data both ways, so finance teams work in the tool they already use — no email threads, no follow-up chasing. On top, Finlens produces the full MIS pack — P&L, Balance Sheet, Cash Flow and Budget vs Actuals — for all 25 entities, each company keeping its own individual P&L format while a standard P&L mapping underneath derives the consolidated group reports from the same data. A KPI layer of roughly 25 measures spans six categories: profitability (gross, EBITDA and net margin, ROE, ROA, ROCE), liquidity (current, quick and cash ratios, working capital), efficiency (asset and inventory turnover, DSO, DPO), leverage (debt-to-equity, interest coverage, debt-to-asset, equity multiplier), cash (operating CF margin, cash conversion) and manpower (headcount, direct and indirect cost as a percentage of revenue, revenue per employee) — each with green, amber and red thresholds against target.

The outcome

Reporting time is down about 60%. The person who used to spend the month consolidating, chasing and formatting now spends it acting on the numbers. The Chairman and CFO have single-window visibility across the group; company-level reporting stays in the format each business runs on; consolidation is derived rather than rebuilt; and working capital is managed proactively through DSO, DIO and DPO instead of reviewed in arrears.

Start a conversation → All stories
✦ Get in touch