MIS Report Format: What a Monthly Board Pack Must Include

By SCORE Editorial Team · Prepared by SCORE’s audit, tax and advisory practice · Law stated as on 28 September 2026

Quick answer: A good MIS report format has eight parts. They are a dashboard, variance commentary, segment P&L, cash flow and forecast, working capital, balance-sheet health, compliance status and decisions required. It should reach management within 7–10 working days of month-end. It answers four questions: how did we do, where is cash going, what is at risk, and what must we decide?

What is an MIS report in accounting?

MIS stands for management information system. An MIS report is an internal summary of financial and operating data, prepared for promoters, the management team and the Board.

It is not a statutory document. You do not file it with MCA, and the statutory auditor does not sign it. Its only job is to help people decide faster and better.

A board pack is the version of the MIS that goes to the Board. It is shorter, more forward-looking, and ends with the decisions the Board must take.

Why do most MIS reports get ignored?

Most MIS is a reformatted trial balance. It is accurate, late and silent on causes. Promoters stop reading it, and decisions get made on instinct or on the bank balance.

Common causes:

1. Too many pages and no summary up front.
2. Commentary that restates numbers instead of explaining them.
3. Metrics that change every month, so nobody can see a trend.
4. No budget, so every number lacks a reference point.
5. Late adjustments that make the board stop trusting the pack.

The fix is not more pages. It is designing the pack around decisions.

What should a monthly MIS report format include?

Use these eight sections as your standard MIS report format. Keep the main body to 6–10 pages. Push detail into appendices.

1. One-page dashboard: revenue, gross margin, EBITDA, cash, receivable days and payable days. Show each against budget and last year.
2. Variance commentary: the three largest variances, with cause, owner and next step, in plain words.
3. P&L by segment: by product, region, plant or store. Show wherever profit is made or lost.
4. Cash flow and 13-week forecast: actual cash movement plus a rolling forecast. Flag funding gaps early.
5. Working capital: debtor, inventory and creditor ageing, and the cash conversion cycle.
6. Balance-sheet health: debt, covenant headroom, interest cover and current ratio.
7. Compliance status: filings due and done across GST, TDS, income tax, Companies Act and other regulators. Include open notices.
8. Decisions required: what management needs from the promoters or Board this month.

Sample one-page dashboard layout

Metric	This month	Budget	Variance	Same month last year	YTD vs budget
Revenue (₹ lakh)				|
Gross margin %				|
EBITDA (₹ lakh)				|
Closing cash (₹ lakh)				|
Debtor days				|
Inventory days				|
Creditor days				|
Months of runway or cash cover				|

Keep the same metrics every month. Change them only once a year, at budget time.

Which KPIs should an MIS report track by industry?

The dashboard core stays the same. The operating KPIs change with the business model.

Industry	Lead KPIs
Manufacturing	Yield and wastage, cost per unit, capacity utilisation, inventory days
Retail	Sales per square foot, store-level margin, shrinkage, stock turns
SaaS / technology	Annual recurring revenue, churn, CAC payback, burn multiple, runway
Logistics	Revenue per vehicle, fuel cost per km, branch cash variance
Real estate	Project-wise collections, cost to complete, balance in the RERA designated account
Services	Utilisation, realisation per hour, unbilled revenue, revenue per employee

For real estate, RERA requires 70% of amounts realised from allottees for a project to sit in a separate bank account. Tracking that balance monthly avoids withdrawal disputes at certification time.

How soon after month-end should the MIS be ready?

Aim for 7–10 working days. Later than that, the next month is already half gone and the numbers are history, not information.

Working day after month-end	Milestone
Day 3	Books closed; bank, GST and key ledger reconciliations done
Day 5	Draft numbers and variance analysis ready
Day 7	Commentary agreed with business heads
Day 8–10	Pack issued to promoters or Board

A fast MIS depends on a fast close. If core accounting errors surface in the pack, fix the close process first.

How often does the Board need a board pack?

Management needs MIS every month. The Board pack follows the Board calendar.

Under Section 173 of the Companies Act, 2013, a company must hold at least four Board meetings a year. The gap between two meetings cannot exceed 120 days. Small companies, one person companies and dormant companies need only one meeting in each half of the calendar year, at least 90 days apart.

So most companies send a quarterly Board pack built from three monthly MIS reports. The Board still benefits from a short monthly flash between meetings.

Is an MIS report the same as financial statements?

No. They serve different readers and rules.

Point	MIS report	Financial statements
Purpose	Internal decisions	Legal and external reporting
Frequency	Monthly or weekly	Annual (quarterly for listed companies)
Format	Designed by the company	Schedule III and accounting standards
Audit	Not audited	Audited by the statutory auditor
Filing	Not filed	Filed with ROC in AOC-4
Detail	Segment, store, product, customer	Company-level, with notes

MIS figures can differ from the books for valid reasons, such as provisional accruals. But keep a reconciliation, or bridge, from MIS profit to book profit. Unexplained gaps are a red flag for auditors, lenders and investors.

How do you build an MIS report in Excel?

Most mid-sized companies start in Excel before moving to a BI tool. A simple build:

1. Export the trial balance and sub-ledgers from your accounting software.
2. Map each ledger to an MIS line on a mapping sheet. Do this once and lock it.
3. Load the budget on the same mapping.
4. Build the dashboard and section sheets with formulas, not pasted values.
5. Add a check sheet that ties MIS totals back to the trial balance.
6. Version-control the file and record who approved each month’s pack.

Monthly MIS checklist before you send it

• ☐ Bank, GST and inter-company reconciliations complete
• ☐ Accruals and provisions posted, with a note on estimates
• ☐ MIS profit reconciled to book profit
• ☐ Top three variances explained with cause and owner
• ☐ 13-week cash forecast updated
• ☐ Compliance tracker updated, including open notices
• ☐ Decisions required listed on the last page
• ☐ Reviewed by the CFO or Virtual CFO before release

Frequently asked questions

What should a monthly MIS report include?

A dashboard, variance commentary, segment P&L, cash flow and forecast, working capital, balance-sheet health, compliance status and decisions required. Keep the main body short and move detail to appendices.

Is an MIS report audited or filed with MCA?

No. MIS is an internal management document. Only the financial statements are audited and filed with the ROC in Form AOC-4.

Can MIS figures differ from audited accounts?

Yes, for provisional entries or different groupings. Keep a written bridge from MIS profit to book profit, so every difference is explained.

Who prepares the MIS report?

Usually the finance team, with the CFO or Virtual CFO owning the commentary. Business heads should agree the variance explanations before the pack is issued.

Do small companies need an MIS?

Yes. Even a three-page pack with a dashboard, cash forecast and compliance status improves decisions once turnover passes a few crore.

How SCORE helps

SCORE’s Virtual CFO practice designs the MIS around how you actually run the business. We set up the ledger mapping, budget and dashboard, then issue the pack every month with commentary.

Segment-level reporting is where money hides. In a retail audit across 12 stores, store-level analysis led to 2 stores being closed.

Want a board pack your directors actually read? Book a finance-function diagnostic with SCORE and ask for our Monthly MIS Template.

Sources

• Certifications under RERA (WIRC of ICAI)
• Companies Act, 2013 and rules (India Code)
• Income Tax Department (CBDT)

This article is general information, not professional advice.