Guide
MIS report from Tally: which raw reports to take, and what to do with them
Tally holds everything a monthly MIS needs, in reports it already produces. What it does not do is assemble them into one management report with comparatives, ratios, ageing and commentary. This is how to bridge that gap — by hand, or without.
Free to create. No subscription, and credits never expire.
Also called mis report, management accounts, monthly financial reporting, board pack and month-end reporting package, depending on where you are. Every name, explained.
The raw reports worth taking
Only the first is required. Each of the others adds a section to the report rather than being needed to produce one.
| Tally report | What it gives the MIS |
|---|---|
| Trial BalanceRequired | The ledger balances every MIS is built from. One per month you want to report. |
| Profit & Loss A/c | Checks the MIS income statement back against the books. |
| Balance Sheet | Checks assets and liabilities at the month end. |
| Bills Receivable | Outstanding customer bills with due dates — the debtors ageing section. |
| Bills Payable | Outstanding supplier bills with due dates — the creditors ageing section. |
| Day Book or Ledger Vouchers | Voucher-level detail, used to explain a movement rather than just show it. |
| Sales and Purchase Registers | Invoice-level revenue and input GST, where the MIS needs that detail. |
| Stock Summary | Closing quantities and values, for inventory days and stock movement. |
Each report is named as Tally names it. The few menu paths on this page are the ones Tally’s own help gives for TallyPrime; they can differ between releases, so where your screen disagrees, trust the screen.
Three export settings that decide whether this works
Export as Excel, never PDF
A PDF export turns every figure into text on a page. The numbers have to be re-keyed or scraped, and both introduce errors that are invisible until someone reconciles.
Keep the ledger detail
A trial balance condensed to groups loses the ledger names, and the ledger names are what the mapping is built from. Export with ledgers shown under each group.
One export per month, not a range
A single export covering a year cannot be split back into months reliably. Export each month separately and the comparatives build themselves.
How to prepare an MIS report in TallyPrime: take the trial balance ledger by ledger
TallyPrime opens the trial balance from Gateway of Tally > Display More Reports > Trial Balance, or by pressing Alt+G (Go To) and choosing Trial Balance. It opens group-wise; press F5 (Ledger-wise) so every ledger is listed by name, because the ledger names are what an MIS is mapped from. In F12 (Configure), setting Show Opening Balance to Yes puts the opening balance beside the closing one.
Set the period to the month you are reporting, export it, and repeat for each month you want in the comparatives. From there the MIS is built outside Tally: map each ledger to a report head, add the heads up into the P&L and balance sheet, set this month beside last month and last year, and write the commentary. The ratios and ageing sections need the Stock Summary and the bills outstanding reports listed above.
Tally to Excel: the export that works keeps every ledger as a number
With the report open in TallyPrime, press Alt+E (Export) and choose Current. Press C (Configure) to set the options for that export, choose Excel (.xlsx) among the formats offered, and press E (Export). The file is written to the folder set for exported files.
The export that works is the ledger-wise trial balance as Excel, one file per month. A group-wise export loses the ledger names; a PDF turns the figures into text; a year in one file cannot be split back into months. Magic MIS reads the .xlsx as it comes out of Tally — and the other formats too — finding each column by its header rather than its position.
By hand, it is a workbook per client
The usual method is a workbook per client: paste the trial balance into a sheet, map each ledger to a report head with lookups, and let the statements calculate. It works, and for one company it is entirely reasonable.
It degrades in two predictable ways. Ledger names drift, so a lookup silently returns nothing and a head quietly understates. And the mapping lives in one person’s workbook, so when they are away the month is late. Both are failures of the mapping being an artefact rather than a record.
Doing it with Magic MIS
The same four steps, with the mapping kept as a record rather than a spreadsheet.
1. Export the reports and upload them
Drop the raw files in, in any format. They are encrypted as they arrive, and before you pay for anything the screen shows only file names, sizes, sheet counts and row counts.
2. The ledger mapping is done for you
Each ledger is matched to a canonical MIS head: Tally's group structure does most of the work and AI handles what is left. The mapping is kept, so next month it is reused.
3. Take the workbook
A validated Excel workbook with live formulas, a dashboard and written commentary. Every figure traces back to the ledger and voucher it came from.
4. Next month, refresh
Load the new trial balance. If the structure has not changed, the refresh reuses the mapping and makes no AI calls at all — which is why a monthly refresh costs a fraction of the first setup.
No sample on this page is computed from anyone’s accounts. Before a paid action, the product itself shows only file names, sizes, sheet counts and row counts.
What people ask about an MIS from Tally
What is MIS in Tally?
MIS in Tally usually means the management reports a business builds from its Tally data each month: a profit and loss and balance sheet with comparatives, cash flow, ratios, debtors and creditors ageing, and commentary. Tally holds every figure those need and produces the underlying reports; the MIS is the one management report assembled from them, usually in Excel.
Can Tally produce an MIS report by itself?
Tally produces the underlying reports — trial balance, P&L, balance sheet, registers and outstandings — but not a consolidated management report with comparatives, ratios, ageing and commentary in one workbook. That assembly is what is normally done by hand in Excel each month.
Do I need to connect anything to my Tally installation?
No. There is no connector, no ODBC link and nothing to install beside Tally. You export the reports you would export anyway and upload the files; nothing connects to your Tally installation.
Does my accounting data leave my computer?
The raw files are uploaded, encrypted under a key unique to that company, and kept for you until you delete them. The AI model receives only redacted samples and ledger names, never a whole file and never your parties' names.
What if ledger names change between months?
New and renamed ledgers are flagged for you to place, and the rest of the mapping is reused. Only the changed part needs attention — the structure being unchanged is the normal case, and that case makes no AI calls.
Does it work with Tally.ERP 9 as well as TallyPrime?
Yes. Parsing is driven by the column headers in the export rather than by fixed positions, so both versions' files are read the same way and a changed column order does not break it.
On BUSY, Marg, Zoho Books or Vyapar instead, the same exports make the same MIS
Nothing above depends on Tally: the MIS is built from a trial balance, ledgers and registers, whichever system kept them. Where each of the others keeps those reports, and how to take them to Excel, is in its own guide: BUSY, Marg ERP, Zoho Books and Vyapar.
Read next
- MIS report format in Excel: what a monthly MIS should containThe monthly MIS report format used by Indian businesses, section by section: P&L summary, balance sheet, cash flow, ratios and ageing — with a worked example.
- Client reporting software for accounting firms and CAS teamsManagement reporting across a portfolio of clients, without a junior rebuilding each workbook by hand. One mapping per client, reused every month, with every number traceable.
- Security and data handlingWhere your accounting files go: encrypted under each company's own key, redacted before the AI sees any of them, and opened by no one on our side. Stated exactly.
See it on your own month
Create an account, load last month's trial balance, and get the report — paid per action.
Prepaid credits, no subscription. Credits never expire.