The MIS problem most SMEs have
Most SME MIS packs we encounter share three failure modes:
- Too long30-50 pages of historical detail with no decision-relevance;
- Too lateproduced 25-30 days after month-end when the data is stale;
- Too detailedline-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 statusfor 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 forecastreceipts, 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:
- GSTreturns filed status (GSTR-1 / 3B), pending notices, refund status;
- TDS / TCSpayment and return status, mismatch flags;
- Income Taxadvance tax payment, TDS reconciliation, assessment status;
- ROCannual return filed, board / shareholder meeting compliance;
- FEMA / RBIFC-GPR / APR / ECB-2 status if applicable;
- Statutory auditfieldwork status, expected sign-off, key issues raised;
- Open litigationmaterial 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 checklistitemised list of what must be done by Day 7; reviewed weekly during month-end;
- Variance protocolevery variance >10% from budget gets a 1-line explanation; commentary is data + diagnosis + decision;
- Monthly KPI reviewfounder / leadership team reviews the dashboard each month, not just quarterly;
- Cash-forecast accuracy trackingactual vs forecast variance tracked weekly; iteratively tighten the forecast model;
- Board pack as artefact, not toolthe 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-roundmonth-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.