The right MIS report format fits on two to four pages, reaches the owner within seven working days of month end and answers three questions every business asks: did we make money, where did the cash go, and who owes us what. Ten sections cover it, from a P&L against budget to receivables ageing, working capital, ratios and a short commentary. Anything longer gets skimmed. Anything shorter hides the problem until the bank calls.
This guide gives you a complete MIS report format with a worked sample in rupees, explains who reads each part and how often, and shows how to pull the numbers out of TallyPrime, Zoho Books or QuickBooks Online. If you would rather skip the spreadsheet work, upload your P&L and balance sheet exports to our MIS dashboard for Indian businesses, free for your first 10 uploads. It checks every import against the statement’s own printed totals before it draws a single chart.
What an MIS report is, in plain words
MIS stands for management information system. An MIS report is the pack of numbers and short notes that owners and managers read every month to run the business. Annual financial statements tell shareholders, lenders and regulators what happened over a whole year. A monthly MIS report tells the people running the business what is happening now, while there is still time to act.
Think of it like school. The audited annual accounts are the final exam report card: formal, late and impossible to change. The monthly MIS report is the class test every few weeks. It is rougher, but it shows which subject is slipping while you can still fix it.
Five terms you will see in any MIS report format:
- P&L (profit and loss statement): income minus expenses for a period, such as September.
- Balance sheet: what the business owns (assets), owes (liabilities) and the owners’ money (equity) on one date, such as 30 September.
- Budget: the numbers you planned for the month before it started.
- Variance: actual minus budget. On income a positive variance is good news; on costs it is bad news.
- Ageing: sorting unpaid invoices by how long they have been outstanding, such as 1 to 30 days or more than 90 days.
Is there a legal MIS report format?
No. No law prescribes an MIS report format, so you can design it around the decisions your business actually makes. If the business is a company, though, borrow two ideas from Schedule III to the Companies Act, 2013, which sets the format of a company’s annual balance sheet and statement of profit and loss. Amendments that apply from 1 April 2021 added ageing schedules for trade receivables and trade payables, with payables split between MSME suppliers and others, and a list of ratios such as the current ratio, debt-equity ratio and trade receivables turnover ratio.
A company must also explain any ratio that changes by more than 25% against the previous year. Build the same buckets and ratios into your MIS report format every month and the year-end notes almost write themselves.
The 10 sections of a monthly MIS report format
Here is the MIS report format we recommend for an Indian SME, and for a CA firm that prepares management accounts for its clients. Keep the order fixed so every reader knows exactly where to look.
1. Headline page
Every MIS report format should open with four to six numbers on one strip: revenue, gross margin, net profit, cash and bank, receivables and payables. Each shows this month, budget and last month. Many owners read only this page, so it must stand on its own.
2. P&L summary against budget and last month
This is the heart of the MIS report format: a condensed profit and loss statement with columns for actual, budget, variance, last month and change. Keep it to eight or ten lines, from revenue down to profit before tax, with year to date figures in a second block below.
3. Revenue mix
Revenue split the way the business is managed: by product line, branch, customer group or channel, in rupees and as a share of the total. The mix explains the margin. Different streams earn different margins, so a sales jump in a thin-margin line can lower profit even while revenue grows. Keep the same streams every month so the MIS report format compares like with like.
4. Gross margin
Gross profit is revenue minus the direct cost of what you sold: purchases adjusted for opening and closing stock, freight inward and direct labour. Gross margin is gross profit as a percentage of revenue. Show it overall and by stream, and split any miss against budget into a volume effect (you sold less) and a margin effect (you earned less on each rupee).
5. Operating costs
Indirect expenses grouped into six to eight heads that someone owns: salaries, rent, marketing, travel, professional fees, power and admin. Flag any head that moves more than 10% against budget and give the reason in the commentary section of the MIS report format.
6. Cash and bank
Opening balance, receipts, payments and closing balance for each bank account, plus any cash credit limit and how much of it is used. Profit is an opinion; cash is a fact. Reconcile every account first (our bank reconciliation template walks through it), or the closing figure is a guess. To look ahead as well as back, pair this page of the MIS report format with our free 6-week cash flow forecast template.
7. Receivables and payables with ageing
Your MIS report format should sort debtors and creditors into the same buckets every month: not yet due, 1 to 30 days overdue, 31 to 60, 61 to 90 and more than 90 days. List the top ten customers by overdue amount, with a named person chasing each one.
Show dues to MSME suppliers separately. A buyer who does not pay a micro or small supplier within 45 days of accepting the goods or services owes compound interest, with monthly rests, at three times the bank rate notified by the RBI, as the MSME Samadhaan portal sets out. Our MSME delayed payment interest calculator shows what a late bill costs, and our free accounts payable template keeps supplier bills, payments and AP ageing in one Excel file.
8. Working capital
Working capital is current assets (receivables, inventory, cash) minus current liabilities (payables, short-term borrowings, GST and TDS payable). In the MIS report format, show it in rupees and in days. Debtor days plus inventory days minus creditor days gives the cash conversion cycle: how long your money stays stuck before it comes back as cash.
9. Key ratios
Six to eight ratios with this month, last month and the same month last year, each with a one-line reading. If your MIS report format already tracks the Schedule III ratios, the annual disclosure becomes a copy job instead of a project.
10. Commentary
Commentary is the part of the MIS report format owners actually read. Five to eight sentences on what beat budget, what missed, why, and what happens next. Good commentary names a number, a cause and an owner: “Revenue missed budget by Rs 2 lakh because two film orders slipped to October, and dispatch is confirmed for 10 October” beats “Revenue was lower than expected”.
Sample MIS report format with real rupee numbers
Here is the MIS report format filled in for a fictional Pune distributor of packaging material, Northstar Packaging, for September 2026. Every figure is invented, and every figure adds up.
The format at a glance
| Section of the MIS report format | Main figures |
|---|---|
| 1. Headline page | Revenue, gross margin, net profit, cash |
| 2. P&L summary | Actual, budget, variance, last month |
| 3. Revenue mix | Revenue by stream and share |
| 4. Gross margin | Gross profit and margin by stream |
| 5. Operating costs | Expense heads against budget |
| 6. Cash and bank | Opening, receipts, payments, closing |
| 7. Ageing | Ageing buckets, top overdue parties |
| 8. Working capital | Current assets, current liabilities, days |
| 9. Key ratios | Six to eight ratios with trend |
| 10. Commentary | Causes, actions, owners |
P&L summary for September 2026
| Line (Rs) | Actual Sep | Budget Sep | Variance | Actual Aug | Change vs Aug |
|---|---|---|---|---|---|
| Revenue | 48,00,000 | 50,00,000 | (2,00,000) | 45,00,000 | 3,00,000 |
| Cost of goods sold | 33,60,000 | 34,50,000 | (90,000) | 31,05,000 | 2,55,000 |
| Gross profit | 14,40,000 | 15,50,000 | (1,10,000) | 13,95,000 | 45,000 |
| Gross margin | 30.0% | 31.0% | (1.0 point) | 31.0% | (1.0 point) |
| Operating expenses | 9,20,000 | 9,00,000 | 20,000 | 8,85,000 | 35,000 |
| Operating profit | 5,20,000 | 6,50,000 | (1,30,000) | 5,10,000 | 10,000 |
| Interest and depreciation | 1,00,000 | 1,00,000 | 0 | 1,00,000 | 0 |
| Profit before tax | 4,20,000 | 5,50,000 | (1,30,000) | 4,10,000 | 10,000 |
Brackets mean a negative number. Revenue missed budget by Rs 2,00,000 (4.0%) but grew Rs 3,00,000 (6.7%) on August. Gross profit fell Rs 1,10,000 short of budget. Split the miss like this:
- Volume effect: Rs 2,00,000 less revenue at the budgeted 31% margin cost Rs 2,00,000 × 31% = Rs 62,000.
- Margin effect: the margin on actual sales was one point lower (31% minus 30%), so Rs 48,00,000 × 1% = Rs 48,000.
- Check: Rs 62,000 + Rs 48,000 = Rs 1,10,000, exactly the gross profit variance.
Selling less is a sales problem. Earning less on each sale is a pricing, discount or purchase-cost problem. The split tells the owner which one to fix.
Revenue mix and gross margin by stream
| Stream | Revenue (Rs) | Share | Gross margin | Gross profit (Rs) |
|---|---|---|---|---|
| Stretch film | 26,00,000 | 54% | 25% | 6,50,000 |
| Corrugated boxes | 15,00,000 | 31% | 34% | 5,10,000 |
| Tapes and labels | 7,00,000 | 15% | 40% | 2,80,000 |
| Total | 48,00,000 | 100% | 30% | 14,40,000 |
Stretch film brings in more than half the sales at the thinnest margin, so every extra rupee of film sales pulls the blended margin down. That is the first place to look for the one-point slip.
Cash and bank
| Item | Rs |
|---|---|
| Opening bank balance, 1 September | 18,40,000 |
| Add: receipts from customers | 46,20,000 |
| Less: payments to suppliers, staff, taxes and expenses | 49,10,000 |
| Closing bank balance, 30 September | 15,50,000 |
| Cash credit limit / used | 50,00,000 / 25,00,000 |
Cash fell by Rs 2,90,000 in a profitable month. That is normal when sales grow on credit, and it is exactly why cash gets its own page in the MIS report format.
Receivables and payables ageing
| Bucket | Receivables (Rs) | Payables (Rs) |
|---|---|---|
| Not yet due | 30,00,000 | 22,00,000 |
| 1 to 30 days overdue | 16,00,000 | 10,00,000 |
| 31 to 60 days overdue | 9,00,000 | 5,00,000 |
| 61 to 90 days overdue | 4,00,000 | 3,00,000 |
| More than 90 days overdue | 3,00,000 | 0 |
| Total | 62,00,000 | 40,00,000 |
Rs 7,00,000 of receivables (Rs 4,00,000 + Rs 3,00,000), about 11% of the total, is more than 60 days overdue, so those customers go on the chase list with a name and a date. Of the payables, Rs 8,00,000 is owed to MSME suppliers, and anything past 45 days from acceptance goes to the top of the payment run.
Working capital and key ratios
At 30 September, receivables Rs 62,00,000, inventory Rs 45,00,000 and bank Rs 15,50,000 make current assets of Rs 1,22,50,000. Payables Rs 40,00,000, cash credit Rs 25,00,000 and statutory dues Rs 5,00,000 make current liabilities of Rs 70,00,000. Working capital is the difference, Rs 52,50,000. The term loan is Rs 15,00,000 and net worth Rs 80,00,000.
| Ratio | How to work it out | September |
|---|---|---|
| Gross margin | Gross profit ÷ revenue | 30.0% |
| Net margin | Profit before tax ÷ revenue | 8.75% (budget 11.0%) |
| Current ratio | Current assets ÷ current liabilities | 1.75 |
| Quick ratio | (Current assets less inventory) ÷ current liabilities | 1.11 |
| Debt-equity | (Cash credit + term loan) ÷ net worth | 0.50 |
| Debtor days | Receivables ÷ revenue × 30 | 39 days |
| Inventory days | Inventory ÷ cost of goods sold × 30 | 40 days |
| Creditor days | Payables ÷ cost of goods sold × 30 | 36 days |
| Cash conversion cycle | Debtor days + inventory days less creditor days | 43 days |
Creditor days here use cost of goods sold as a stand-in for purchases. That is fine if you keep the same basis every month.
Commentary
The commentary that closes this MIS report format reads like this:
September revenue was Rs 48.0 lakh, 4% below budget but 6.7% up on August. Gross margin slipped from 31% to 30%, with Rs 62,000 of the Rs 1.1 lakh gross profit gap from lower volume and Rs 48,000 from margin. Overheads ran Rs 20,000 over budget on temporary warehouse staff. Cash fell Rs 2.9 lakh to Rs 15.5 lakh as receivables grew, and Rs 7 lakh is more than 60 days overdue. The sales head will collect Rs 4 lakh of it by 15 October.
Who reads the MIS report, and how often
| Reader | What they read first | How often |
|---|---|---|
| Owner or managing director | Headline page, cash, commentary | Monthly, plus a one-page weekly cash flash |
| Board or investors | Full pack with year to date and trends | Quarterly, or monthly for funded startups |
| Bank (cash credit or term loan) | Receivables, stock and borrowings | As the sanction letter requires |
| Sales head | Revenue mix, top overdue customers | Monthly |
| Purchase and operations | Payables ageing, inventory days | Monthly |
| CA firm or outsourced accountant | Every page, to catch errors first | Monthly |
Whatever MIS report format you choose, send it within seven working days of month end. That needs a fixed closing calendar: bank reconciliations by day 2, bills and provisions by day 3, stock by day 4, then review and commentary.
For a CA firm, one MIS report format used across every client beats a clever custom pack for each. Partners can review ten clients in an hour when every pack looks the same, and the monthly MIS becomes a recurring service instead of a favour.
How to fill the MIS report format from Tally, Zoho Books or QuickBooks
Each of these packages can export everything this MIS report format needs to Excel or CSV. The routine is the same in each: close, export, tie, arrange and explain. If you are still choosing a package, our Zoho Books vs TallyPrime comparison sets the two side by side.
Before you export: close the month
- Reconcile every bank account and the cash book.
- Post all purchase bills and expense claims for the month.
- Book provisions for expenses incurred but not yet billed, such as rent, power and professional fees, and release this month’s share of prepaid expenses (a prepaid expense schedule template does the monthly split).
- Book depreciation and value closing stock.
- Match the GST and TDS payable ledgers to the returns working.
Our tested AI prompts for accounting include a month-end close calendar, a trial balance flux analysis and a payables ageing check.
From TallyPrime
- Open the Profit & Loss A/c report and set the period to the month.
- Press Alt+E (Export) and choose Current.
- Press C (Configure), set the file format to Excel (Spreadsheet) and the folder path, then press E to export.
- Repeat for the Balance Sheet as at the last day of the month.
- For ageing, go to Gateway of Tally > Display More Reports > Statements of Accounts > Outstandings > Receivables, then Payables. Press F6 (Ageing Method) to age by bill date or due date, set your ageing periods and export the same way. These reports need bill-wise entry enabled in F11 (Features).
Then arrange the exports into your MIS report format. On TallyPrime Release 7.1 and later, the Financial Statements add-on can also export the balance sheet and P&L into an Excel template in the Schedule III Division I format, which helps at year end. Tally’s export help page covers the file formats.
From Zoho Books
- Go to Reports > Profit and Loss and set the date range to the month.
- Click the Customise icon, open General and use Compare to add the previous period.
- Click Export As and choose XLSX. Repeat for the Balance Sheet.
- For receivables, open the Aging Summary (see the Zoho Books receivables reports help). It ages by invoice due date or invoice date, and you can choose the length and number of intervals, so change the default 15-day buckets to 30 days to match your MIS report format. For payables, the Vendor Balance Summary shows what you owe each supplier.
From QuickBooks Online
- Go to Reports > Standard reports and open Profit and Loss for the month.
- Use the export menu at the top of the report, choose Export to Excel or Export as CSV, and save the file.
- Repeat for the Balance Sheet, then copy both into your MIS report format. Intuit’s QuickBooks reports help shows the same steps.
Tie every number before you send it
An MIS that does not agree with the books loses the reader’s trust in one meeting. Whatever MIS report format you use, run these checks every month:
- The balance sheet balances: assets equal liabilities plus equity, to the rupee.
- The P&L lines add up to the printed totals for income, expenses and net profit.
- The ageing totals equal sundry debtors and sundry creditors on the balance sheet.
- Closing bank in the cash section equals the reconciled bank balances on the balance sheet.
- Last month’s closing figures equal this month’s opening figures. If someone changed a closed month, find out why.
Build it in Excel, or let the MIS dashboard do it
A spreadsheet works when one person owns the report and the layout never changes. Our free Excel financial dashboard templates give you a ready chart layout. Paste each export into a raw data tab, point the summary tabs at it with SUMIFS (our guide to Excel formulas for finance shows how) and protect the formulas, so the MIS report format stays fixed while the numbers change.
The ReconScribe MIS dashboard covers this MIS report format without the copy and paste. Upload the P&L and balance sheet as .xlsx or .csv files (save an old .xls as .xlsx first) and it builds the charts, ratios and commentary. The free trial covers the P&L and balance sheet sections; ageing and budget against actual come with premium. Here is what each plan includes today:
| Free trial | Premium |
|---|---|
| A one-time trial of 10 uploads of your P&L and balance sheet | 20 uploads a month per company, kept, so the dashboard builds month over month |
| The full chart deck: revenue streams, spend, cash, working capital and ratios | Ageing, sales and budget-vs-actual datasets |
| Any layout: AI reads an unfamiliar export once, then the layout is remembered | Lock periods and roll forward month over month |
| Every import checked against its own printed totals, and refused with the reason when it does not tie | Public share link, saved reports with PDF export and a custom layout |
| AI commentary, with each import kept for 30 days | Unfamiliar layouts read and commentary written by our strongest AI |
The totals check matters most. A confident chart drawn from a misread export is worse than no chart, so an import that does not agree with its own printed totals is refused with the reason, and nothing from it is stored.
Common mistakes that make an MIS report useless
Even a good MIS report format fails when the pack falls into one of these traps:
- No comparison. A number without budget or last month beside it means nothing.
- Too many pages. A 30-page pack gets filed, not read. Move detail to an appendix.
- Cash and profit mixed up. Profit comes when you invoice; cash comes when the customer pays.
- Numbers that do not tie. One wrong total and the owner stops trusting every page.
- Commentary that repeats the table. Say why, and what happens next.
- A layout that changes every month. Fix your MIS report format once and change it only at the start of a financial year.
Start with the ten sections above and fill them in for last month, even roughly. The second month goes faster, and by the third the MIS report format runs itself. When you want the charts, ratios and commentary without the spreadsheet, upload last month’s P&L and balance sheet to the ReconScribe MIS dashboard tool and see the whole month on one screen.
Related guides to go with this MIS report format
- Bank statement to Excel: convert and prove each statement before the cash page goes into the pack.
- Excel financial dashboard template: ten dashboard designs on one P&L table.
- Bank reconciliation template: tie the cash page to the bank before you send the pack.
Please note: we update this page from time to time, but rules, report layouts and software menus change, and there can be a gap between a change and our update. Check the official source, such as the Ministry of Corporate Affairs website for Schedule III or your accounting software’s help pages, before you act. This guide helps you design a management report; it is not legal, tax or audit advice, and ReconScribe is not responsible for decisions made on it.
Frequently asked questions
What is the standard MIS report format?
No law prescribes a single MIS report format. A practical one has ten sections: a headline page, a P&L summary against budget and last month, revenue mix, gross margin, operating costs, cash and bank, receivables and payables ageing, working capital, key ratios and a short commentary.
What should a monthly MIS report include?
A monthly MIS report format should include results against budget and last month, cash and bank, receivables and payables ageing, working capital, six to eight key ratios and a commentary that names causes and actions. Keep it to two to four pages plus appendices.
Is Schedule III the same as an MIS report format?
No. Schedule III to the Companies Act, 2013 sets the format of a company's annual balance sheet and statement of profit and loss. An MIS report is an internal monthly report with no prescribed layout, but using Schedule III's ageing buckets and ratios in it makes year-end disclosures easier.
How do I prepare an MIS report from Tally?
Export the Profit & Loss A/c, Balance Sheet and Outstandings reports from TallyPrime to Excel with Alt+E (Export), arrange them into your MIS report format and check that every total ties to the books. Or upload the P&L and balance sheet exports to an MIS dashboard that builds the charts and ratios for you.
What is the difference between an MIS report and an MIS dashboard?
An MIS report is the monthly pack of tables and commentary, usually sent as a PDF. An MIS dashboard shows the same numbers as charts that build up month by month, so trends show at a glance. Most teams use both: the dashboard for the meeting, the report for the record.
When should the MIS report be ready each month?
Whatever MIS report format you use, aim for seven working days after month end, with a fixed closing calendar: bank reconciliations first, then bills and provisions, stock, review and commentary. A report that arrives after the 15th is history, not management information.
Which ratios should an MIS report show?
Any MIS report format should carry gross margin, net margin, current ratio, quick ratio, debt-equity, debtor days, inventory days and creditor days. Show each against last month and the same month last year, with a one-line reading of what changed.
Sources
- Companies Act, 2013 including Schedule III, Ministry of Corporate Affairs
- MSME Samadhaan: delayed payment provisions of the MSMED Act, 2006
- TallyPrime help: export data
- TallyPrime help: export a report to Excel (Spreadsheet)
- TallyPrime help: outstanding receivables and payables
- TallyPrime help: financial statements add-on
- Zoho Books help: receivables reports
- Zoho Books help: business overview reports
- Zoho Books help: payables reports
- QuickBooks Online help: run and export reports