Tally · MIS Reporting · Business Intelligence
MIS report in Tally: the format, the reports to use and what an owner should read
Short answer. An MIS report is a short monthly summary of the numbers a business owner uses to decide: profit, cash, receivables, payables, stock and expenses. Tally has no single report called “MIS”. You build it from reports Tally already has, mainly Profit & Loss, Balance Sheet, Cash Flow, Ratio Analysis, Outstandings and Stock Summary, and then compare them with last month and last year.
What an MIS report is
MIS stands for Management Information System. An MIS report is prepared for the people who run the business, not for a tax office or an auditor. There is no legal format. A good one answers a few questions quickly: are we making money, where is the cash, who owes us, whom do we owe, what is lying in stock, and what changed since last month.
Statutory accounts look back at a full year. An MIS report looks at a month or a week, so that a problem is seen while there is still time to act on it.
Which Tally reports go into an MIS report
TallyPrime already holds most of what an owner needs. These are the reports to pull, and where to find them from the Gateway of Tally.
| Question | Tally report | Where it is |
|---|---|---|
| Did we make a profit? | Profit & Loss A/c | Gateway of Tally → Profit & Loss A/c |
| What do we own and owe? | Balance Sheet | Gateway of Tally → Balance Sheet |
| Where did the cash go? | Cash Flow and Funds Flow | Display More Reports → Cash Flow / Funds Flow |
| Who owes us, and for how long? | Bills Receivable with ageing | Display More Reports → Statements of Accounts → Outstandings → Receivables |
| Whom do we owe? | Bills Payable with ageing | Display More Reports → Statements of Accounts → Outstandings → Payables |
| What is in stock? | Stock Summary | Gateway of Tally → Stock Summary |
| Are the basics healthy? | Ratio Analysis | Gateway of Tally → Ratio Analysis |
| Which branch or department earns? | Cost Centre reports | Display More Reports → Statements of Accounts → Cost Centres |
Three keys do most of the work inside these reports. Alt+C adds a column so you can place another period next to the current one. Alt+N adds columns automatically, for example month by month. F6 inside the outstanding reports switches to the age-wise view. Alt+E exports the report to Excel or PDF.
A simple monthly MIS format for an owner
Keep the pack to what will be read. One page per item is enough.
- Profit summary. Sales, gross profit and net profit for the month, next to last month and the same month last year.
- Cash position. Opening balance, money in, money out, closing balance, and the bank and cash balances today.
- Receivables ageing. Total outstanding split into 0–30, 31–60, 61–90 and over 90 days, with the ten largest overdue customers.
- Payables ageing. The same split for suppliers, with what falls due in the next 30 days.
- Stock. Closing stock value, and items that have not moved in 90 days.
- Sales detail. Top customers and top products for the month.
- Expenses. Each main expense head against last month, and against budget if you keep one in Tally.
- Dues to the government. GST and TDS payable, and the due dates.
- Five ratios. Gross profit %, net profit %, current ratio, receivable days and stock turnover, all of which Ratio Analysis shows.
Settings that must be on first
An MIS report is only as good as the entries behind it. Check these before trusting the numbers.
- Bill-wise details must be enabled for customer and supplier ledgers. Without it, Tally cannot show which invoice is unpaid or how old it is.
- Credit periods should be entered on invoices, so that “overdue” means something.
- Cost centres must be enabled and used on entries if you want profit by branch, department or project.
- Stock items and godowns must be maintained in Tally if you want a stock page.
- Books must be up to date. A report run on the 5th from books entered till the 20th of last month misleads more than it helps.
Where the manual method strains
Tally shows each report correctly on screen. The effort is in the assembly: someone opens eight reports, exports each one, pastes them into a workbook, formats it and sends it. That takes time every month, it depends on one person, and it usually arrives after the decisions it was meant to inform. It also shows numbers without saying what to do about them.
That is the point at which businesses move from an exported workbook to a dashboard that reads the Tally data directly.
What to read first
If you read only three things each month, read these: the receivables over 90 days, the cash closing balance against next month’s payables, and gross profit % against last month. Most unpleasant surprises show up in one of the three.
Common questions
Does Tally have a built-in MIS report?
No single report in TallyPrime is called MIS. Profit & Loss, Balance Sheet, Cash Flow, Funds Flow, Ratio Analysis, Outstandings, Stock Summary and Cost Centre reports together make up an MIS report. You compare periods with Alt+C or Alt+N and export with Alt+E.
How do I get a receivables ageing report in Tally?
Open Display More Reports → Statements of Accounts → Outstandings → Receivables, then press F6 for the age-wise view and set the ageing periods, for example 0–30, 31–60, 61–90 and over 90 days. Bill-wise details must be enabled on the customer ledgers.
How often should an MIS report be prepared?
Monthly is the usual minimum. Cash, receivables and overdue payables are worth checking weekly, because those are the items where a delay of a few weeks costs money.
Can an MIS report be exported from Tally to Excel?
Yes. Open the report and press Alt+E, choose Export, and select Excel or PDF as the format. Each report is exported separately, so a full pack means several exports.
