Autobot
What is an MIS report?
An MIS report is a regular summary of how the business is doing, made for the owner and managers. MIS stands for management information system: the records, sheets or software that collect your day-to-day data. The report is what you read from it [1].
In most Indian firms, "MIS" simply means this report. The accountant or an MIS executive prepares it, and the owner reads it. A good one answers five questions in two minutes:
- Are we selling more or less than before?
- Are we making money on what we sell?
- Is the money coming in, or is it stuck with customers?
- Is our stock moving, or piling up?
- How much cash do we have, and what is due soon?
An MIS report is not your books of account. The balance sheet and profit and loss account are formal statements made by your accountant. The MIS is an internal working report. It comes more often, compares periods and shows things the accounts don't, such as which customers are late and which items are about to run out.
What should a small business MIS report include?
Seven sections cover most trading, manufacturing and service businesses: sales, margin, expenses, collections, money owed by age, stock and cash. Keep each to a few lines, and add a short list of actions at the end.
| Section | What it shows | The question it answers |
|---|---|---|
| Sales | Total sales, against last month, the same month last year and your target | Are we growing? |
| Margin | Sales minus the cost of what you sold, in rupees and as a percentage | Is the growth profitable? |
| Expenses | Salaries, rent, transport and other running costs, against last month | Are costs under control? |
| Collections | Payments received in the period | Is cash coming in? |
| Money owed to you | Customer dues split by age: 0 to 30, 31 to 60, 61 to 90 and over 90 days | Who do we chase first? |
| Stock | Stock value, items below reorder level, items not sold in 90 days | What do we reorder, and what is stuck? |
| Cash | Cash and bank balance, and what you must pay in the next 30 days | Can we pay what is due? |
Manufacturers add a production line: output against plan, rejects and machine downtime. Service firms swap stock for jobs: jobs open, jobs closed and hours billed.
MIS report format with an example
Here is a monthly MIS for a made-up wholesale trader of electrical goods with 12 staff. Each line shows this month, last month, the same month last year and the change from last month.
| October 2026 | This month | Last month | Oct 2025 | Change |
|---|---|---|---|---|
| Sales | ₹48.6 lakh | ₹44.2 lakh | ₹41.9 lakh | +10% |
| Margin | ₹6.3 lakh (13.0%) | ₹5.6 lakh (12.7%) | ₹5.2 lakh (12.4%) | +13% |
| Expenses | ₹3.9 lakh | ₹3.7 lakh | ₹3.4 lakh | +5% |
| Operating profit | ₹2.4 lakh | ₹1.9 lakh | ₹1.8 lakh | +26% |
| Payments received | ₹42.1 lakh | ₹45.3 lakh | ₹40.2 lakh | −7% |
| Money owed to you | ₹53.7 lakh | ₹47.2 lakh | ₹44.0 lakh | +14% |
| Stock value | ₹62.0 lakh | ₹58.4 lakh | ₹55.1 lakh | +6% |
| Cash and bank | ₹9.2 lakh | ₹11.6 lakh | ₹8.7 lakh | −21% |
The money owed to you, split by age at the end of the month:
| Days since the invoice | Amount | Customers |
|---|---|---|
| 0 to 30 days | ₹31.4 lakh | 46 |
| 31 to 60 days | ₹12.8 lakh | 19 |
| 61 to 90 days | ₹5.6 lakh | 7 |
| Over 90 days | ₹3.9 lakh | 4 |
| Total | ₹53.7 lakh | 76 |
Then three lines on stock and three actions:
- Stock: 14 items below reorder level. ₹4.8 lakh of stock has not sold in 90 days.
- Payments due in the next 30 days: ₹28.5 lakh to suppliers.
- Actions: call the 11 customers past 60 days this week (₹9.5 lakh); reorder the 14 items; offer the slow stock to dealers at a small discount.
Read it the way an owner would. Sales grew 10% and margin improved, so the month looks good. But payments received fell 7% while dues grew 14%, and cash dropped by ₹2.4 lakh. Growth is being paid for by credit to customers. Without the collections and ageing lines, this MIS would have hidden the problem.
What are the types of MIS reports?
Most businesses use a handful of MIS reports, one for each part of the business: sales, collections, purchases, stock, production, expenses, cash and staff. Each goes to the person who acts on it, at the pace that part of the business moves.
| Report | What it covers | Who reads it | How often |
|---|---|---|---|
| Sales MIS | Sales by customer, item, salesperson or area, against target | Owner, sales head | Daily or weekly |
| Collections MIS | Payments received, dues by age, promises to pay | Owner, accounts | Weekly |
| Purchase MIS | Purchases by supplier, rates paid, bills due to suppliers | Owner, purchase | Weekly |
| Stock MIS | Stock value, items below reorder level, slow-moving items | Owner, store | Weekly |
| Production MIS | Output against plan, rejects, downtime | Owner, plant head | Daily |
| Expense MIS | Costs by head against last month and budget | Owner, accounts | Monthly |
| Cash flow MIS | Cash and bank, money expected in and out over 30 days | Owner | Weekly |
| Staff MIS | Headcount, attendance, overtime, salary cost | Owner, HR | Monthly |
They also differ in when they arrive. Scheduled reports come on fixed dates, like the monthly MIS. On-request reports answer a question when you ask it, such as "sales by area this quarter". Exception reports appear only when something crosses a limit: a customer over their credit limit, an item below reorder level or a payment 60 days late. Exception reports are the easiest to act on, because they only show what needs you.
Daily or monthly MIS: which do you need?
Every business needs the monthly MIS. Add a daily summary if cash and stock move fast, and weekly sales numbers if you have a sales team.
A daily MIS should be five lines you can read on your phone before work. For the same trader it might say:
- Yesterday: sales ₹1.9 lakh from 14 invoices.
- Payments in: ₹1.6 lakh.
- Orders waiting to dispatch: 3.
- Cash and bank: ₹9.2 lakh.
- Follow up today: a customer who promised ₹2.1 lakh by today, 68 days past the invoice.
The monthly MIS goes deeper: margin, expenses, the full ageing and stock lists, with comparisons. Try to have it by the 5th of the next month. A report that lands on the 25th is history by the time you read it.
How do you make an MIS report in Excel or Google Sheets?
Keep your raw entries in separate sheets, tag each entry with its month, and build one MIS sheet that adds them up with SUMIFS or a pivot table. After that, each month you only add new entries and the MIS updates itself.
- Keep one sheet for each register: Sales, Payments received, Purchases, Stock and Expenses. Use one row per entry and a header on every column. Pivot tables need those headers [2].
- Add a Month column next to the date, for example
=TEXT(A2,"yyyy-mm"), so every entry carries its month. - On an MIS sheet, add up each line with SUMIFS. Sales for October 2026, if amounts are in column F and months in column H:
=SUMIFS(Sales!F:F, Sales!H:H, "2026-10"). For one customer in that month, add a second condition on the customer column [3][4]. - For dues by age, add a Days column to your list of unpaid invoices with
=TODAY()-B2, label each row 0-30, 31-60, 61-90 or 90+, and add up each label with SUMIFS. - For top customers or items, use a pivot table instead of formulas. In Google Sheets, go to Insert, then Pivot table. In Excel, go to Insert, then PivotTable. Put Customer in Rows and the sum of Amount in Values [2][5].
- Put this month, last month and the same month last year side by side, with a change column.
- Lock the layout. From now on you only paste new entries into the registers.
If your accounts are in Tally or another accounting package, export the sales register and outstanding reports to Excel each week and paste them into the registers. Check the MIS totals against your books once a month, so nobody acts on a wrong number.
What is the difference between an MIS report and a dashboard?
An MIS report is a fixed summary for a period, usually a month, with comparisons and notes. A dashboard is a live screen of a few numbers you check through the day. Most owners need both: a dashboard to watch and an MIS to review.
The trouble with both is upkeep. Someone has to paste the data, fix broken formulas and send the file. When that person is on leave, the MIS stops. That is why a report that updates itself from the same sheets your team already fills is worth more than a prettier one.
Mistakes that make an MIS report useless
- Too many numbers. If it doesn't fit on one page, nobody reads it. Move the detail to a second page.
- No comparison. ₹48.6 lakh in sales means little. Next to ₹44.2 lakh last month, it tells a story.
- Sales without collections. Sales can rise while cash falls, as the example above shows.
- Arriving late. October's MIS on 25 November is history. Aim for the first week.
- Numbers that don't match the books. Tie sales and dues to your accounts every month.
- No actions. End with three lines: who does what, by when.
FAQ
What is the full form of MIS?
Management information system. In business, "MIS" usually means the regular report it produces: a summary of sales, collections, stock and cash for the owner and managers [1].
Who prepares the MIS report in a small business?
Usually the accountant or an MIS executive. In smaller firms the owner often makes it. Whoever makes it, someone else should check it against the books once a month.
How often should an MIS report be made?
A one-page monthly MIS is the minimum. Add a short daily summary if cash and stock move fast, and weekly sales numbers if you have a sales team.
Is an MIS report the same as a balance sheet or profit and loss account?
No. Those are formal accounts prepared by your accountant. An MIS report is an internal summary for decisions. It comes more often and adds comparisons, dues by age and stock alerts.
Can I make an MIS report from Tally?
Yes. Export the sales, outstanding and stock reports to Excel and build the MIS on top of them. Autobot itself isn't connected to Tally, so for a live MIS keep the data in Google Sheets.
What is the difference between MIS and ERP?
ERP software records the transactions: orders, invoices and stock movements. MIS is the summary you read from those records. Most ERP software includes some MIS reports.
Sources
General information, not accounting advice.
The example business and its numbers are made up to show the format.
- Wikipedia, Management information system ("transforming raw operational data into structured, periodic reports that aid managerial oversight"). https://en.wikipedia.org/wiki/Management_information_system
- Google Docs Editors Help, Create and use pivot tables ("Each column needs a header"; Insert, then Pivot table). https://support.google.com/docs/answer/1272900
- Google Docs Editors Help, SUMIFS function ("Returns the sum of a range depending on multiple criteria"). https://support.google.com/docs/answer/3238496
- Microsoft Support, SUMIFS function. https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
- Microsoft Support, Create a PivotTable to analyze worksheet data (Insert, then PivotTable). https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576