The MIS problem most SMEs have
Most SME MIS packs we encounter share three failure modes:
- Too long — 30-50 pages of historical detail with no decision-relevance;
- Too late — produced 25-30 days after month-end when the data is stale;
- Too detailed — line-item GL extracts that nobody reads, with the strategic story buried.
Useful MIS is the opposite — short, fast, decision-oriented. The senior team should be able to read the entire pack in 15 minutes and walk into the board meeting with a clear view of the business. The framework below has worked across multiple SME engagements.
The 5-block MIS framework
Build the MIS around five reporting blocks:
| Block | What it covers | Pages |
|---|---|---|
| 1. Executive Dashboard | Top 8-10 KPIs vs target vs prior month vs YoY | 1 |
| 2. P&L Analytics | Revenue cuts, gross margin, opex, EBITDA, variance vs budget | 2 |
| 3. Working Capital | Receivables ageing, inventory days, payables days, working-capital cycle | 1 |
| 4. Cash & Treasury | Cash position, runway, cash-flow forecast 3 months | 1 |
| 5. Compliance & Risk | GST / TDS / ROC / audit / litigation status | 1 |
Total: 6 pages. No appendices. Detailed schedules go to a separate operational MIS for the finance team's use; the board pack is the executive view only.
Block 1 — Executive Dashboard
The single most important page. Top 8-10 KPIs in a single view. Typical SaaS / tech startup KPIs:
- Revenue (MRR / ARR / monthly bookings);
- Gross margin %;
- Net new customers / churn;
- Burn rate;
- Cash on hand and runway months;
- Key channel CAC / LTV;
- Hiring vs plan;
- Customer NPS or CSAT;
- Top 1-2 product / sales metrics specific to the business.
For traditional SME / manufacturing / distribution:
- Revenue, gross margin, EBITDA;
- Receivables days (DSO);
- Inventory days;
- Working-capital cycle;
- Order book / pipeline;
- Capex spend vs budget;
- Cash on hand and bank-line utilisation.
Each KPI shows: actual, target, prior month, YoY. Add a traffic light (green / amber / red) for visual scanning.
Block 2 — P&L Analytics
Two pages of P&L cuts. Page 1 = monthly P&L with budget variance:
- Revenue (with sub-categories);
- Gross margin = Revenue − COGS (split by major product / segment);
- Opex by function (sales, marketing, product/operations, G&A);
- EBITDA;
- One-time items called out separately;
- Variance vs budget for each major line.
Page 2 = trend / segment cuts:
- Last 6 months of revenue and EBITDA — trend chart;
- Revenue by segment / channel / geography;
- Gross margin by segment;
- Customer concentration — top 10 customers as % of revenue.
The variance commentary should be 3-5 bullet points only, focused on the 3 most material variances and what is being done about them.
Block 3 — Working Capital
One page on working-capital health:
- DSO (Days Sales Outstanding) = (AR / Revenue) × 30 — target depends on industry; B2B services typically 45-90 days, B2B products 30-60 days, B2C 0-15 days;
- Receivables ageing buckets: 0-30, 31-60, 61-90, 90+, with absolute values;
- Inventory days: COGS-weighted days of inventory;
- DPO (Days Payable Outstanding): (AP / COGS) × 30;
- Cash-conversion cycle = DSO + Inventory days − DPO;
- Top 5 overdue receivables with action items;
- MSMED Act 45-day rule status — for SME suppliers, listed payments due >45 days create interest exposure.
Practical note: The MSMED Act 45-day rule (Section 16) creates statutory interest exposure of 3× bank rate on payments to MSME suppliers beyond 45 days. From FY 2023-24, Section 43B(h) of the Income Tax Act disallows the expense if not paid within the 45-day window. This is a material exposure most SMEs underestimate.
Block 4 — Cash & Treasury
One page on cash health:
- Cash on hand (operating accounts);
- Investments (FDs, MFs, T-bills);
- Bank-line utilisation (CC, OD, term loans) with sanctioned vs utilised;
- Net cash position;
- 13-week rolling cash forecast — receipts, payments, opening / closing cash;
- Major upcoming receipts and payments flagged;
- FX exposure (if international operations) — open positions, hedge ratio;
- Runway months at current burn / EBITDA loss rate.
The 13-week cash forecast is the single most useful operational tool. It surfaces upcoming cash crunches 8-12 weeks ahead, giving time to negotiate vendor terms, expedite receivables, or arrange short-term financing.
Block 5 — Compliance & Risk
One page covering compliance status:
- GST — returns filed status (GSTR-1 / 3B), pending notices, refund status;
- TDS / TCS — payment and return status, mismatch flags;
- Income Tax — advance tax payment, TDS reconciliation, assessment status;
- ROC — annual return filed, board / shareholder meeting compliance;
- FEMA / RBI — FC-GPR / APR / ECB-2 status if applicable;
- Statutory audit — fieldwork status, expected sign-off, key issues raised;
- Open litigation — material matters and status;
- RBI compliance for NBFCs / banks — separately tracked.
Use traffic-light indicators (green / amber / red) for at-a-glance compliance health.
Cadence and closing discipline
The MIS calendar:
| Day | Activity |
|---|---|
| Day 1-3 of new month | GL closing, accruals, reconciliations |
| Day 4-5 | Trial balance review, adjustment entries |
| Day 6-7 | P&L finalisation, variance analysis |
| Day 7-8 | MIS pack drafted |
| Day 8-9 | Virtual CFO / finance head review; comments incorporated |
| Day 9-10 | MIS distributed to founder / CEO / board |
| Day 12-15 | Monthly review meeting (founder / leadership team) |
| Day 15-30 | Quarterly board meeting (every 3 months) |
Target: MIS in management hands by Day 10 of next month. Anything later is decorative — by the time you read it, you cannot act on the issues.
Operational disciplines that make MIS useful
The disciplines that distinguish useful MIS from decorative MIS:
- Closing checklist — itemised list of what must be done by Day 7; reviewed weekly during month-end;
- Variance protocol — every variance >10% from budget gets a 1-line explanation; commentary is data + diagnosis + decision;
- Monthly KPI review — founder / leadership team reviews the dashboard each month, not just quarterly;
- Cash-forecast accuracy tracking — actual vs forecast variance tracked weekly; iteratively tighten the forecast model;
- Board pack as artefact, not tool — the MIS is for management every month; the board pack is a 5-page polish of the same data quarterly;
- Compliance dashboard owned by CS / finance manager, not the Virtual CFO — the Virtual CFO reviews exceptions only;
- Audit-ready year-round — month-end reconciliations done thoroughly, not deferred to year-end.
For working-capital optimisation strategies that connect to this MIS framework, see Working Capital Management for Indian SMEs.