A ₹40 Cr precision components manufacturer in Pune. 180 employees. Three product lines. The MD — let's call him Ajay — spent the first two hours of every working day compiling his morning MIS. He would collect WhatsApp screenshots from four plant managers, open three Excel files sent by his accountant, cross-reference the delivery schedule from his ERP, and manually type the summary into a single sheet before his 9 AM team call.
The problem
The 2-hour morning ritual meant Ajay was making his 9 AM decisions on data that was already 12–14 hours old. Production numbers from the previous afternoon, receivables from the previous day's accounting run, dispatch data from the previous evening. By the time he had 'visibility', the first shift was already two hours in.
What we built
We spent two weeks mapping every data source. Then built connectors for each:
- Tally Prime → production cost and inventory data via TDL API, refreshed every 2 hours
- Plant manager inputs → a WhatsApp bot that asks 3 questions at 6 AM and parses structured responses
- Dispatch schedule → exported from their ERP via CSV, auto-ingested at 7 AM
- Bank feeds → connected via account aggregator to show live cash position
- Receivables → Tally ledger extract, cross-checked against the 45-day MSME clock
All of this feeds into a Next.js dashboard, refreshed automatically. At 7:30 AM every morning, Ajay gets a WhatsApp message: 'Your MIS is ready. 3 items need your attention today.' The dashboard link opens in 4 seconds. He reviews it in 4 minutes.
The results — 90 days in
The number that changed everything
With 40 hours a month recovered, Ajay started doing something he hadn't done in three years: customer site visits. In the first quarter, he closed two new accounts worth ₹3.2 Cr in annual revenue — accounts that had been in the pipeline for over a year without momentum. The MIS automation paid for itself in the first week of those closures.
Want to see what this could look like for your business? Book a Free Diagnostic — we'll map your exact data sources and show you what's possible.
Book a Free DiagnosticHow automation-ready is your business?
Answer 10 questions. Get your Automation Score and a free mini-roadmap.