Reporting
The monthly MIS report format Indian SMEs actually need
What belongs in a management reporting pack, in what order, and why most MIS in Indian SMEs gets built once and then quietly ignored.
On this page
Ask ten Indian SMEs for their monthly MIS and you will get ten different things: a Tally P&L export, a spreadsheet of sales by customer, a WhatsApp message with the bank balance, or an apologetic nothing. All of them are called MIS. None of them is one.
What an MIS actually is (and isn’t)
An MIS is a decision document. Its only test is whether a reader finishes it knowing something that changes what they do next. Statutory accounts are a different animal entirely — prepared once a year, structured by schedule, optimised for comparability and audit.
| Statutory accounts | Monthly MIS | |
|---|---|---|
| Audience | Regulators, auditors, tax | You, your board, your lender |
| Frequency | Annual | Monthly, cash weekly |
| Optimised for | Compliance | Decisions |
| Granularity | Statutory heads | Product, client, branch, channel |
| Contains opinion? | No | Yes — commentary is the point |
If your “MIS” is a P&L with the schedule headings still on it, what you have is a statutory extract wearing a different name.
The format: nine sections, in this order
Order matters. Cash first, because that is what kills companies. Explanation last, because it should refer to everything above it.
1. Cash position and movement
Opening cash, closing cash, and the bridge between them: operating, investing, financing. Plus available facility headroom. One page, first page, every month.
2. Profit & loss with four comparatives
A number on its own is not information. Every line should show: this month, last month, the same month last year, and year-to-date against budget. Five columns. That is the minimum for a reader to know whether ₹14 lakh of salary cost is normal.
3. Gross margin by segment
The most valuable page in the pack and the one most often missing. Split by whatever actually runs your business — product line, client, project, branch, channel. Blended margin across everything is nearly useless because it hides exactly the thing you need to find.
4. Balance sheet, reconciled
With a supporting schedule behind every material line. If a balance cannot be explained, it appears in the open-items list rather than quietly sitting there.
5. Debtor ageing
Bucketed 0–30, 31–60, 61–90, 90+, with the top ten overdue accounts named and a note on what is being done about each. Ageing without an action column is a report; ageing with one is a collections process.
6. Creditor ageing and commitments
What you owe, when, plus purchase commitments not yet invoiced. Businesses are routinely surprised by the second one.
7. Working capital and the cash cycle
DSO, DIO, DPO and the resulting cash conversion cycle, tracked as a trend rather than a snapshot. A cycle drifting out by five days a quarter is a slow-motion funding problem. Our working capital calculator computes it from your balance sheet.
8. KPI page
Eight to twelve numbers that genuinely run your business, on one page, tracked monthly. Mostly operational, not financial: orders, utilisation, throughput, rejection rate, headcount, revenue per employee.
9. Commentary and open items
Written prose. What moved, why, and what is being done. Plus everything unresolved, stated plainly, with what is needed to close it.
A variance column says travel cost rose 40%. Commentary says it rose because the Pune contract’s site visits began, it was budgeted, and it ends in March. Only one of those is management information.
The one page that matters most
If you build nothing else this month, build this. A single page carrying:
- Cash today, and cash this time last month
- Revenue: month, YTD, versus budget
- Gross margin %: month, and the trailing three-month trend
- Debtors over 90 days, in rupees
- Three operating metrics specific to you
Owners who will not read a 20-page pack will read this. And a page that gets read beats a pack that does not, every single month.
What changes by business type
| Business | Add to the standard pack |
|---|---|
| Manufacturing | Capacity utilisation, yield and rejection, raw material price variance, WIP ageing |
| Trading / distribution | Stock ageing and dead stock, fill rate, margin by SKU, supplier credit used |
| Services | Utilisation, realisation versus standard rate, WIP and unbilled revenue, margin by project |
| Multi-branch retail | Like-for-like sales, margin and cost per branch, footfall conversion |
| Subscription / SaaS | MRR movement, churn, CAC payback, deferred revenue |
Why most SME MIS gets ignored
Five reasons, in the order we encounter them.
- It arrives too late. A pack landing on the 25th describes a month that is already history. Nothing in it can be acted on.
- It has no commentary. Numbers without explanation put the analytical work back on the reader, who is the busiest person in the building.
- It is not reconciled. One number the owner knows to be wrong destroys confidence in all the others, permanently.
- It has no segment view. Blended totals cannot answer the only question that matters — which part of this is working?
- Nobody owns it. Produced when someone remembers, in a format that drifts month to month.
Notice that four of the five are process failures, not analytical ones. Better charts fix none of them.
Cadence: when it has to land
| By working day | What happens |
|---|---|
| 2 | Source data complete — bank, sales, purchase, expenses, payroll summary |
| 5 | Posted and reconciled; every bank and control account agreed |
| 7 | Accruals, prepayments, depreciation; trial balance locked |
| 9 | Statements, margins, KPIs, commentary drafted |
| 10 | Reviewed by someone who did not prepare it, then issued |
The review step is not optional. It is what keeps errors away from the owner, and the reason people keep trusting the pack in month fourteen.
Building your first pack
Do not start with a template. Start with the three decisions you made badly last year because you lacked a number — then build the page that would have given you that number. Add sections only when someone asks for them.
The prerequisite is honest books. Reporting built on unreconciled ledgers is worse than no reporting, because it is confidently wrong. Get the close right first, then build the pack on top of it.
If you would rather it simply arrived every month, that is what our MIS and performance reporting service does, delivered within 24 working hours of complete data — and if you also want someone to interpret it with you and act on it, that is the VCFO engagement. Send us your current reporting and we will tell you plainly what is missing.
Written by
Soham T. Savdavkar, Director at Outsourced Finance Solutions — an outsourced finance company providing accounting, MIS reporting, GST and TDS compliance and virtual CFO (VCFO) support to growing businesses across India, from an office in Kanjurmarg, Mumbai.
OFS is not a firm of chartered accountants and performs no CA-reserved work. This article is general information, not advice for your specific situation.