A monthly MIS report in Excel needs six sheets in this order: an executive summary, the profit and loss against budget and last year, working capital, a cash flow summary, KPIs, and an exceptions sheet where every item has an owner and a due date. The first page should let a managing director see in two minutes what moved, why, and who is fixing it; everything behind it is support.
No law prescribes this format. An MIS is a management document, so the test of a good one is simply whether decisions get made from it. This guide sets out the format, the order, what to leave out, and the mistakes that make a pack arrive late and unread.
If you want the working file rather than the explanation, start here:
| Need | Use this |
|---|---|
| The monthly MIS workbook in Excel, built from your own numbers | MIS Report Format Generator |
| Debtor days, inventory days, creditor days and the cash tied up in them | Cash Conversion Cycle Calculator |
| A close calendar, so the pack has numbers to report on time | Month-End Close Checklist Generator |
| Receivables ageing to attach behind the working capital page | Debtors Ageing Analyzer |
The monthly MIS report format, sheet by sheet
| Order | Sheet | What it shows | The question it answers |
|---|---|---|---|
| 1 | Executive summary | Revenue, gross margin, EBITDA, profit after tax, cash, net debt, cash conversion cycle, and three or four sentences of commentary | Are we on plan, and if not, where? |
| 2 | P&L against budget and last year | Each line: actual, budget, variance, variance %, same month last year, change %, and a red, amber or green flag | Which lines caused the gap? |
| 3 | Working capital | Cash, receivables, inventory, payables and borrowings at this month-end and last month-end, with the movement and the days | Where is the cash sitting? |
| 4 | Cash flow summary | A bridge from EBITDA to the movement in cash and bank | Why did profit not turn into cash? |
| 5 | KPIs | Margins, debtor days, inventory days, creditor days, current ratio, net debt, headcount — each with how it is computed, a target and an owner | Is the trend moving the right way? |
| 6 | Exceptions and actions | Every red or amber line: what happened, why, action agreed, owner, due date, status | Who is doing what, by when? |
The order matters. Most packs are built in the order the finance team prepares them — trial balance, schedules, then a summary at the back. Readers need the reverse.
1. The executive page
One page. Headline numbers against budget and last year, a flag against each, the cash position, and a few sentences of commentary. If a reader stops here, they should still know the three things that need attention.
2. P&L against budget and against last year
Both comparatives are needed because they answer different questions. Budget tells you whether you are doing what you said you would do. Last year tells you whether the business is actually growing. A month that is behind budget but well ahead of last year is a different conversation from one that is behind both.
Variance is actual minus budget; variance per cent is that amount divided by the budget figure. For revenue and profit lines a negative variance is adverse. For cost lines a positive variance is adverse. State the convention once on the sheet so nobody has to guess.
3. Working capital and cash
Show cash and bank, trade receivables, inventory, trade payables and borrowings at this month-end and the previous one, with the movement. Then turn the three trading balances into days: debtor days (DSO), inventory days (DIO) and creditor days (DPO). DSO plus DIO minus DPO is the cash conversion cycle. Behind this page sit the receivables ageing, the slow-moving stock list and the vendor ageing.
4. Cash flow summary
A short bridge: EBITDA, less the increase in receivables and inventory, plus the increase in payables, gives cash from operations before tax and interest. Add the change in borrowings; what is left is capex, tax, interest and other items. This is a management bridge, not the cash flow statement in the annual accounts — say so on the sheet, and analyse the balancing figure from the cash and bank books.
5. KPIs
Keep the list short and keep it the same all year. A KPI that changes definition in October cannot be compared with April. Write the formula beside each one.
6. Exceptions, with an owner and a date
This is the sheet that turns a report into management. Every line flagged red or amber gets one named owner and one due date, and stays in next month's pack until it is closed. A pack without this sheet describes problems; it does not move them.
Worked example: one month on the executive page
The figures below are illustrative, in ₹ lakh, with flags set at amber for 5% adverse and red for 10% adverse.
| Line | Actual | Budget | Variance vs budget | Last year | Change vs last year | Flag |
|---|---|---|---|---|---|---|
| Revenue | 1,840 | 2,000 | −8.0% | 1,650 | +11.5% | Amber |
| Gross margin | 515 | 600 | −14.2% | 480 | +7.3% | Red |
| Operating expenses | 330 | 320 | +3.1% | 300 | +10.0% | Green |
| EBITDA | 185 | 280 | −33.9% | 180 | +2.8% | Red |
| Profit after tax | 96 | 150 | −36.0% | 92 | +4.3% | Red |
| Working capital | This month-end | Last month-end | Days |
|---|---|---|---|
| Cash and bank | 210 | 265 | — |
| Trade receivables | 3,650 | 3,380 | 60 |
| Inventory | 2,400 | 2,250 | 55 |
| Trade payables | 1,750 | 1,690 | 40 |
| Cash conversion cycle | 75 |
Days are computed on the month's revenue (for receivables) or cost of sales (for inventory and payables), multiplied by twelve, over 365 days.
What the page should say in words: revenue is 8% short of budget but 11.5% ahead of last year, so the plan was ambitious rather than the business shrinking. The real issue is margin — 28.0% of revenue against a budgeted 30.0% — which turns an 8% revenue shortfall into a 34% EBITDA shortfall. Cash fell by ₹55 lakh in the month because receivables rose by ₹270 lakh and inventory by ₹150 lakh. Three actions follow: a margin analysis by product, a collection plan for the receivables build-up, and a stock review. Each needs a name and a date.
That is the whole purpose of the format. The numbers took five rows; the decision took one paragraph.
What to leave out
- The full trial balance. Keep it as support, not as a page.
- Ledger-level expense detail. Group expenses into six to ten lines. A reader who wants travel by employee can ask.
- Ratios nobody acts on. If no decision has ever changed because of a ratio, drop it.
- Charts that repeat a table. One trend chart for revenue, margin and cash is plenty.
- Statutory disclosure detail. That belongs in the annual accounts.
MIS and financial statements are different documents
| Monthly MIS | Financial statements | |
|---|---|---|
| Purpose | Running the business | Reporting to shareholders, lenders and regulators |
| Format | Whatever helps management decide | Schedule III and the accounting standards |
| Frequency | Monthly | Annual, with quarterly results where required |
| Comparatives | Budget, last month, same month last year | Previous year |
| Audience | Promoters, CFO, business heads, the board | Members, lenders, authorities |
| Looks forward? | Yes — actions, forecast, risks | Largely backward-looking |
They are different documents built from the same books. The MIS can regroup lines to suit the business, but the totals must still agree to the trial balance.
Common mistakes in a monthly MIS report
| Mistake | What it looks like | Fix |
|---|---|---|
| Numbers do not tie to the books | MIS profit differs from the trial balance and nobody can explain the gap | Add a one-line reconciliation from the frozen trial balance to the MIS, with every manual adjustment listed and approved |
| No comparatives | A column of actuals with nothing beside it | Budget and same month last year on every line, and year-to-date once the monthly columns are settled |
| Commentary restates the numbers | "Revenue decreased by 8% compared to budget" | Give the reason and the action: which customer, which product, what is being done |
| Pack arrives after the 15th | Reviewed when the next month is half over | Fix the close first; the MIS cannot be earlier than the books |
| Every line gets equal space | Forty rows, none highlighted | Flags against a tolerance management has set, and commentary only on what crossed it |
| Exceptions have no owner | "Receivables to be followed up" | One name, one date, carried forward until closed |
| Definitions drift | EBITDA includes other income in some months | Write the formula on the KPI sheet and do not change it mid-year |
The late pack is worth dwelling on. It is almost never a reporting problem. If the bank reconciliation is done on the 12th and provisions on the 14th, no template will produce an MIS on the 7th. A close calendar with named owners is the fix, and the MIS date falls out of it.
How the pack changes for a multi-entity group
A group pack is not the entity packs stapled together. Four things change:
- A group page comes first. Consolidated revenue, margin, EBITDA, cash and net debt after eliminations, then one line per entity.
- Intercompany is removed before anyone reads it. Sales between group companies inflate revenue; intercompany balances inflate receivables and payables. Agree the balances between entities before the pack is prepared, not in the meeting.
- Cash and borrowings are shown by entity. A comfortable group cash figure can hide one entity that is short and another that is holding idle balances.
- The same format for every entity. Same line grouping, same KPI definitions, same tolerances. Where some entities run on Tally and others on SAP, the mapping from each chart of accounts to the common MIS lines should be written down once and kept.
The exceptions sheet then becomes a group list, with the entity named against each item, so that the same weakness appearing in three companies is seen as one issue.
From a monthly report to a daily view
The format above is a monthly discipline, and most finance teams should get it right before attempting anything more frequent. The natural next step is to stop waiting for the month-end to learn about exceptions: a receivable crossing its credit period, a payment made twice, a margin dipping on one product. Those can be surfaced as they happen, from every transaction rather than a sample, with the same rule — an owner and a closure date. That is the idea behind tools such as CORAA's enterprise intelligence view. The monthly pack remains the place where it is all summarised and decided.
MIS report FAQ
What is the format of an MIS report in Excel?
A monthly MIS report in Excel usually has six sheets: an executive summary, the P&L against budget and last year, working capital, a cash flow summary, KPIs, and an exceptions and actions sheet. The MIS Report Format Generator produces exactly this workbook from the headline numbers you enter.
What should a monthly MIS report include in 2026?
At a minimum: revenue, gross margin, operating expenses, EBITDA and profit after tax against budget and the same month last year; cash, borrowings and net debt; receivables, inventory and payables with the days they represent; the main KPIs; and a list of exceptions with an owner and due date for each.
Is there a prescribed MIS report format for management in India?
No. An MIS report is an internal management document and its format is not prescribed by the Companies Act or by any accounting standard. The annual financial statements follow Schedule III; the monthly MIS follows whatever layout helps management decide, provided it agrees to the books.
What is the difference between an MIS report and financial statements?
An MIS report is a monthly management document compared against budget and prior periods, in a format the company chooses. Financial statements are the statutory annual accounts in the Schedule III format. Both come from the same books and should reconcile.
By which date should the monthly MIS report be ready?
There is no rule; it depends on how fast the books close. Many finance teams aim to issue the pack within a few working days of the close being signed off. If it regularly arrives after the 15th, look at the close calendar before changing the template.
Can I prepare an MIS report from Tally or SAP?
Yes. In either system the starting point is the month's trial balance with comparatives, mapped to the MIS lines, plus the receivables and payables outstanding and the stock summary at the month-end. The mapping is done once and reused every month.
Related CORAA resources
- MIS Report Format Generator
- Cash Conversion Cycle Calculator
- Month-End Close Checklist Generator
- Intercompany Reconciliation Template
- Debtors Ageing Analyzer
Sources
- Companies Act, 2013 — Schedule III, Ministry of Corporate Affairs — the format of the annual financial statements; it does not govern a monthly MIS