How to Set Up a Monthly MIS Report for Your Startup or SME in India

23 Oct 2026

Most growing Indian companies have plenty of data. The accounting software has the ledgers, the sales team has its CRM, and the bank portal has the balances. What's missing is a single, reliable view that the leadership team trusts and reviews every month. That's what an MIS is for. Done well, it turns month-end from a scramble into a routine, and it gives lenders and investors the confidence that management knows its numbers.

What a good MIS contains

1. Profit and loss against budget

Show revenue, gross margin, operating expenses, EBITDA and profit for the month and year to date. Put each line next to the budget and the same period last year, with the variance in rupees and percent. Comment on the large variances. A number with no explanation invites questions; a number with a clear reason builds trust.

2. Cash and runway

Show opening cash, cash generated or used in operations, investing and financing, and closing cash. Add unused working capital limits. For loss-making companies, show monthly net burn and runway in months, based on current cash and the expected burn. Link this to your 13-week cash flow forecast if you run one.

3. Working capital

• Debtor ageing: receivables by customer, split into buckets such as 0–30, 31–60, 61–90 and over 90 days, plus debtor days
• Creditor ageing: payables by supplier, with any overdue amounts flagged, including dues to MSME suppliers, which generally must be paid within 45 days under the MSMED Act where there is a written agreement
• Inventory: stock value, inventory days, and slow-moving or obsolete items

4. Unit economics and KPIs

Pick the five to ten numbers that actually drive your business, and keep them consistent month to month. Examples:

• SaaS or subscription: monthly recurring revenue, churn, customer acquisition cost, lifetime value
• D2C or retail: orders, average order value, contribution margin per order, repeat rate, returns
• Manufacturing: capacity utilisation, yield, cost per unit, order book
• Lending or fintech: disbursements, assets under management, collection efficiency, portfolio at risk

Define each KPI clearly in a glossary, so everyone calculates it the same way.

5. Compliance status

A simple table showing whether each statutory obligation for the month was filed and paid on time: GST returns (GSTR-1 and GSTR-3B), TDS deposits and returns, PF and ESI, professional tax, and advance tax in the relevant quarters. Note any notices received from tax authorities and their status. Missed compliance creates interest, penalties and problems in lender due diligence, so the board should see it every month.

6. Bank covenants and debt

List each loan and working capital limit: sanctioned amount, outstanding balance, interest rate, repayment due and next due date. Then show each financial covenant in your sanction letters (for example, minimum net worth, maximum debt-to-equity, minimum DSCR or current ratio) with the actual figure and whether you're compliant. Spotting a covenant at risk two months early lets you talk to the lender before it becomes a breach.

A sample MIS page layout

The table below is an illustrative layout with made-up numbers, for a business with about ₹50 Cr of annual revenue. Amounts are in ₹ lakh.

A full MIS has a page or two behind each line, but a one-page summary like this is what most boards and lenders read first.

How to build it, step by step

1. Agree who the MIS is for. Founders, the board, lenders and investors all need slightly different detail. Build one core pack and add short appendices for specific audiences.
2. Fix your chart of accounts.Group ledgers so revenue, direct costs and overheads roll up cleanly into the MIS lines. Messy ledgers are the most common reason MIS numbers can't be trusted.
3. Set up a monthly budget. Break the annual budget into months, reflecting seasonality, so comparisons are meaningful.
4. Choose your KPIs and define them. Write down the formula and data source for each one.
5. Design the template.A summary page, then sections for P&L, cash, working capital, KPIs, compliance and debt. Keep the layout the same every month so readers know where to look.
6. Build the data flow. Pull trial balance, debtor and creditor ageing, bank balances and operational data from your accounting software and other systems. Automate exports where you can, but keep a reconciliation step.
7. Write the commentary. The finance head should explain the big variances and the actions being taken, in plain language.
8. Review and circulate on a fixed date. The founder or CEO reviews the draft, then it goes to the board, investors or lenders on schedule.

A realistic month-end close timeline

A practical target for most startups and SMEs is to circulate the MIS by working day 7 to 10 of the following month:

• Working days 1–3: record all sales and purchase invoices, complete bank reconciliations, book payroll
• Working days 3–5: accruals and provisions, inventory valuation, depreciation, inter-company entries, GST reconciliation with your books
• Working days 5–7: prepare the trial balance and draft MIS, review variances
• Working days 7–10: commentary, management review and circulation

It's fine to start later and tighten the timeline as processes mature. Consistency matters more than speed in the first few months.

Common mistakes

• Too much data, too little insight. Fifty pages of tables nobody reads help no one. Lead with a one-page summary.
• No budget comparison.Without a plan to compare against, you can't tell whether a number is good or bad.
• Changing formats every month. Readers lose the ability to track trends.
• Unreconciled numbers.If revenue in the MIS doesn't match the books or the GST returns, credibility falls fast.
• Leaving out cash. A profit-only MIS can hide a cash crunch.
• Missing compliance and covenants. These are often where the real risks sit.
• Late MIS. A report that arrives in week four is too late to act on.
• Numbers without commentary.Explain what happened and what you're doing about it.

How lenders, investors and boards use it

Lenders often require monthly or quarterly MIS as a condition of a loan or working capital limit, along with stock and debtor statements for drawing power. They use it to monitor covenants and spot early signs of stress. A timely, consistent MIS makes renewals and limit enhancements much easier.

Investors use it to track progress against the business plan, understand burn and runway, and prepare for the next round. A strong MIS history also shortens due diligence, because much of the data is already organised.

Boardsuse it to hold management accountable, approve spending decisions and spot risks early. A good MIS shifts board meetings from "what happened?" to "what should we do?"

Your monthly MIS checklist

• Clear audience and one core template, used every month
• Clean chart of accounts mapped to MIS lines
• Monthly budget, phased for seasonality
• P&L for the month and year to date, against budget and last year
• Cash flow, closing cash, unused limits, burn and runway
• Debtor, creditor and inventory ageing, with MSME dues flagged
• Five to ten KPIs with written definitions
• Compliance status for GST, TDS, PF, ESI and other dues
• Loan schedule and covenant compliance
• Revenue reconciled to books, GST returns and bank receipts
• Commentary on major variances and actions
• Circulated by a fixed working day each month

How ImpactCFO helps

ImpactCFO founder Sudhir Singal has raised over ₹1,000 Cr of debt for a microfinance lender and has led finance at SuperPe, Happy Fintech and Sarala Microfinance. We design your MIS template and KPIs, clean up the chart of accounts, set up the month-end close and data flow, and write the commentary your board, investors and lenders want to read.

Related: How to Build a 13-Week Cash Flow Forecast for Your Startup or SME in India · How to Prepare Your Startup or SME for a Bank or NBFC Loan in India · How to Calculate Your Cash Runway, and 5 Ways to Extend It