Most owners I meet get either no reports or far too many. The accountant sends a 14-tab file at month end, the sales head sends a long WhatsApp message, and nobody can say in one line whether last month was good. A useful MIS report format fixes this. One page, eight numbers, a target and an owner for each, read in two minutes. This post gives you the format, the rhythm to run it, and the mistakes that make owners stop reading their own reports.
Aapko accountant wali report nahi chahiye. You need a page that tells you where to look.
What an MIS report is for
An MIS report has one job: tell the owner, quickly, which part of the business needs attention. It is not a record of everything that happened. Accounting does that. It is a set of signals.
So every number on the page must pass one test: if this number goes red, would I do something different this week? If the answer is no, it doesn't belong on the first page.
The one-page format
Here is the layout I start with. Each row is one number. Each number has five columns.
| Number | This period | Target | Status | Owner |
|---|---|---|---|---|
| New enquiries | … | … | Green / amber / red | Sales head |
| Conversion rate (orders ÷ enquiries) | … | … | … | Sales head |
| Orders booked (value) | … | … | … | Sales head |
| Gross margin % | … | … | … | Accounts |
| Cash in bank | … | … | … | Accounts |
| Receivables over 45 days | … | … | … | Accounts |
| On-time dispatch or delivery % | … | … | … | Operations head |
| One number specific to your business | … | … | … | … |
The full template, with a second page for supporting detail, is the one-page dashboard template.
Choosing your eight numbers
The first seven above work for most owner-run businesses. They cover the path from enquiry to cash: demand, conversion, sales, margin, cash, collections and delivery. The eighth depends on what can hurt you most:
- Manufacturer: machine utilisation, rejection rate, or raw material days in stock.
- Trader or distributor: stock days, or dead stock value older than 90 days.
- Service firm: billable hours as a share of available hours.
- Retail or D2C: repeat-customer share, or return rate.
Resist adding more. A page with 25 numbers gets glanced at. A page with eight gets read.
Define every number once, in writing
Half the arguments in review meetings are about what a number means, not what it says. Write a one-line definition for each, and never change it quietly.
- New enquiries: unique buyers who contacted you for the first time in the period, from any source. Repeat calls from the same buyer count once.
- Conversion rate: orders won in the period divided by enquiries received in the same period. If your sales cycle is long, use enquiries from the previous period instead, and say so on the sheet.
- Orders booked: value of confirmed orders before GST, by order date, not invoice date.
- Gross margin: sales minus the direct cost of what you sold (material, direct labour, freight), as a percentage of sales.
- Cash in bank: balance across all business accounts on the last day of the period, minus any overdraft used.
- Receivables over 45 days: money owed by customers on invoices older than 45 days. If you are a micro or small enterprise, this is also the line where the law on delayed payments starts helping you.
- On-time dispatch: orders dispatched on or before the promised date, divided by all orders dispatched.
Put these definitions on the second page of the report. When a new accounts person joins, the numbers stay the same.
Targets and the traffic-light rule
A number without a target is just information. Set a target for each, based on the last three to six months and where you want to be. Then set the colours in advance so nobody argues later:
- Green: at or better than target.
- Amber: within 10% of target.
- Red: more than 10% worse than target, or worse for two periods in a row.
For receivables and costs, "better" means lower. Write that down on the sheet so the colour logic is never in doubt.
A worked example
Illustration only: hypothetical numbers to show how to read the page, not a client result.
Say your monthly page shows: 180 enquiries (target 160, green), conversion 7% (target 10%, red), orders ₹38 lakh (target ₹45 lakh, red), gross margin 26% (target 25%, green), receivables over 45 days ₹22 lakh (target ₹15 lakh, red).
Two minutes tells you the story. Demand is fine. Enquiries are coming in but not converting, so the problem is follow-up or pricing, not marketing. And cash is getting stuck in old dues. Your week now has two clear questions: why is conversion down, and who is chasing the overdue ₹22 lakh? You didn't need the 14-tab file for that.
Notice what the page doesn't do. It doesn't explain why conversion fell. That's the job of the person who owns the number, who should come to the review with an answer: perhaps quotations went out late because the pricing person was on leave, or a competitor cut rates on one product line. The page points; people explain. If you find yourself digging through invoices during the review, the report is missing a number or the owner of that number didn't prepare.
The weekly and monthly rhythm
A report only works if it is read on a fixed rhythm.
Every day: the 6 PM report
Team leads send enquiries, orders, dispatches and collections for the day. This is raw input, not the MIS. The format is in the 6 PM report template.
Every Monday: the weekly page
Operating numbers for last week (enquiries, conversion, orders, dispatch, collections), ready by 11 AM. A 30-minute review with team leads. For every red, the owner of that number says what they will do this week.
By the 7th of every month: the full page
All eight numbers, including margin and cash, for last month. A one-hour review. Targets for next month are confirmed or changed.
Fixed days matter more than perfect numbers. A report that arrives on the 7th every month beats a better one that arrives "when it's ready".
Where the numbers come from
You will need three sources:
- CRM or lead register: enquiries, quotations, orders, source and conversion.
- Accounting software: sales, margin, cash and receivables ageing.
- Operations records: dispatch dates, delivery dates, rejections or stock.
Start manually. One person from accounts collects the numbers into a spreadsheet every Monday. That alone will show you where your data is weak, for example enquiries with no source or orders with no dispatch date. Fix those gaps first. Once the numbers are clean and you know which ones you actually use, automate the page so it fills itself from your CRM and accounting software. Automating a messy report only gives you wrong numbers faster.
Mistakes that kill MIS reports
- The owner compiles it. Then it stops the week the owner is busy. One named person compiles; the owner reads.
- Too many numbers. If everything is on the page, nothing stands out.
- No targets. Without a target, nobody knows whether 7% conversion is good.
- No owner per number. A red number with no name against it stays red.
- Reports with no meeting. If nobody discusses the page, people stop updating it within two months.
- Only looking back. Add at least one forward-looking number, such as quotations pending or cash expected in the next four weeks.
Start this week
Pick your eight numbers. Set a target for each from the last three months. Name an owner and a compiler. Fix the Monday review in the calendar. You'll have a usable page in two weeks and a good one in two months.
This is the Measure & Run layer of the Self-Running Business System, and my post on using data to make better decisions goes deeper into reading the numbers. The dashboard, the review rhythm and the templates behind them are all in my book, Jugaad Is Not a System. If you want the dashboard built, connected to your systems and reviewed with you every month, that's what the Growth Partner service (monthly MIS dashboard and review) covers. Not sure where to start? The free Automation Scorecard shows which part of your business needs it most.
