
ServiceFinance & Business Advisory
MIS & management reporting
Monthly reports that show management what is working, what is not and where to act.
Statutory accounts look back over a year and are prepared for shareholders, lenders and tax authorities. Management needs something else: a short pack every month, on a fixed date, showing performance by product, branch, customer or segment against budget, with the reasons for the main movements. MIS and management reporting covers the design of that pack, the definitions and data sources behind it, the dashboards and cost and margin analysis it contains, and the commentary and board papers that go with it. The firm can design the reporting once, prepare it each month, or review what the in-house team produces.
Service overview.
Most businesses already produce reports. The difficulty is that they come from different places and do not agree. Sales reports its own numbers from the billing system, operations keeps spreadsheets of production and dispatch, and accounts produces a profit and loss account weeks after the month ends. When figures are discussed in a review meeting, time goes on reconciling them rather than on decisions.
In Indian mid-sized businesses the source is often Tally or a mid-market ERP, with cost centres, branches or godowns set up years ago and not used consistently. Product and customer codes may not map to the way management thinks about the business. Shared costs such as freight, sales promotion, head office and finance costs are either left unallocated or spread in different ways each month.
Owners and boards want something simple: a few measures they can track, a view of margins where the money is made and lost, and an explanation when results differ from plan. Lenders and investors increasingly ask for the same information in a regular format. Achieving this depends less on software than on agreed definitions, a disciplined close and a routine that runs every month.
The work therefore starts from the decisions management takes and the questions it asks in review meetings, and builds back to the data needed to answer them.
- 07Areas of assistance
- 08Process stages
- 07Key deliverables
- 09Sectors served
Business challenges.
Reports arrive too late to act on
The monthly pack depends on the full accounting close and arrives three or four weeks into the next month, by which time the information is too old to change outcomes.
Different numbers from different teams
Sales, operations and finance each report their own figures. Definitions of revenue, volume and margin differ, and no one is sure which version is correct.
No view of margins below company level
Profit is known for the company as a whole, but not by product, customer, branch or channel. Loss-making activities are funded by profitable ones without anyone noticing.
Too many measures, too little insight
Reports run to dozens of pages and track everything. The measures that drive results are buried, and exceptions are not highlighted.
Data trapped in the accounting system
Tally or the ERP holds the transactions but not in a form suited to analysis. Cost centres and masters are incomplete, so reports are rebuilt by hand in spreadsheets each month.
Board papers without a narrative
The board receives tables of figures without commentary. Discussion stays on what happened rather than on why, and on what management proposes to do.
Our approach.
- 01
Understanding decisions
Discussion with promoters and department heads on the decisions they take and the questions they ask in reviews.
- 02
Review of current reports
Existing reports, spreadsheets, systems and the time taken to produce them.
- 03
Defining measures and structure
KPIs, reporting dimensions, allocation rules and definitions agreed in writing.
- 04
Data mapping
Masters, cost centres and extraction from Tally, the ERP and other sources reviewed and mapped to the reporting model.
- 05
Building the pack
Dashboard, profit and loss, margin, working capital and operating reports prepared in draft.
- 06
Parallel run
The new pack produced alongside existing reports for one or two months, with differences resolved.
- 07
Monthly cycle
Preparation or review of the pack and commentary on the agreed timetable.
- 08
Refinement and handover
Measures and formats revised as needs change, with documentation for the in-house team.
How the firm works with you
Decisions first
Reports are designed around the decisions management takes, not around what the system can produce.
Reconciled to the books
Every management figure is reconciled to the general ledger, so management and statutory numbers do not drift apart.
Written definitions
Measures, allocation rules and data sources are documented, so the pack means the same thing each month.
Fewer, clearer measures
Reports are kept short, with exceptions highlighted and detail available only where it is needed.
Built for the existing team
Packs are built in tools the business already uses, so the in-house team can maintain them.
Independence observed
Where the firm is a company's statutory auditor, it does not design or implement financial information systems for that company, as the Companies Act, 2013 requires.
Scope & deliverables.
Each part of the service can be engaged on its own or together, depending on what the business needs.
01Reporting close and timetable
Management reports can be issued earlier than the statutory close if the process is designed for it.
More detailLess detail
The firm sets a reporting calendar, identifies the minimum set of reconciliations and accruals needed for reliable monthly figures, agrees the cut-off rules for estimates, and defines who provides each input by which working day.
The aim is a pack issued within a fixed number of working days after the month ends, with the estimates used in it trued up in the following month and tracked so that their accuracy improves.
What you can expect: a written reporting calendar, a fixed issue date and figures reliable enough to act on.
02KPI design and definitions
Key performance indicators are chosen from the decisions management takes, not from a standard list.
More detailLess detail
For a manufacturer they may include capacity utilisation, yield, conversion cost per unit and order book; for a distributor, sales per salesperson, debtor days and stock turns; for a services business, utilisation, billing rates and revenue per employee.
For each measure the firm documents a definition, the data source, the owner, the frequency and the target, so that the same figure is calculated in the same way every month and by every team.
What you can expect: a short, agreed set of measures with a written definition for each.
03Dashboards and report design
The monthly pack typically opens with a one-page dashboard of headline results and key measures against budget and the prior year, followed by sections on profit and loss, cash and working capital, and operating performance.
More detailLess detail
Visual design is kept plain, with charts used where trends matter and tables where precision does.
The firm designs the pack in the tools the business already uses, such as Excel, Power BI or the reporting module of the ERP, and keeps it maintainable by the in-house team after handover.
What you can expect: a concise pack and dashboard that management can read in a few minutes and drill into where needed.
04Cost and margin reporting
Margin analysis shows where the business earns and loses money.
More detailLess detail
The work covers contribution and gross margin by product, customer, channel or project, standard cost against actual cost where standard costing is used, and analysis of variances by price, volume, mix and efficiency.
Shared costs are allocated on documented bases agreed with management, such as volume, revenue, headcount or floor area, and the same bases are used each month so that trends are meaningful. Costs that cannot sensibly be allocated are reported separately rather than spread arbitrarily.
What you can expect: margin reports by the dimensions management uses, with allocation rules written down and applied consistently.
05Segment, branch and product reporting
Businesses with several branches, plants, divisions or product lines need each unit's results reported separately.
More detailLess detail
The firm defines the reporting structure, maps cost centres, profit centres or godowns in the accounting system to it, and sets rules for inter-unit transfers and shared services.
Where the company reports operating segments in its financial statements under Ind AS 108 or AS 17, the firm considers how management reporting aligns with that disclosure, so that internal and external figures can be reconciled.
What you can expect: results by branch, product or segment that add up to the company total and can be compared month to month.
06Data from ERP, Tally and other systems
Reliable reports depend on reliable data extraction.
More detailLess detail
The firm reviews the masters, cost centres and ledger structure in Tally or the ERP, recommends changes so that transactions are tagged correctly at entry, and sets up extraction and mapping from the general ledger, sales, inventory and payroll records into the reporting model.
Every report is reconciled to the general ledger, so that management figures and the books agree. Where the existing system cannot support the required reporting, the firm notes the limitation and the options, without recommending a particular vendor.
What you can expect: a documented data flow from source systems to the report, reconciled to the books each month.
07Commentary and board packs
Figures need an explanation.
More detailLess detail
The firm prepares or reviews a short commentary on the main variances against budget and the prior year, their causes and the actions proposed or taken. For boards, the monthly or quarterly material is condensed into a board pack with an executive summary, key risks and items for decision.
Where the company is required to place financial statements or results before the board, the board pack complements those documents rather than replacing them.
What you can expect: a written commentary each month and board papers that focus discussion on causes and actions.
Key deliverables
Monthly MIS pack
Dashboard, profit and loss, margins, working capital and operating measures.
KPI definitions document
Definition, source, owner, frequency and target for each measure.
Reporting calendar
Inputs, owners and working-day deadlines for the monthly cycle.
Margin and cost analysis
By product, customer, branch or channel, with allocation rules.
Data mapping and reconciliation
From source systems to the reports, reconciled to the general ledger.
Variance commentary
A short written explanation of results against budget and the prior year.
Board pack
Executive summary, key results, risks and matters for decision.
Value & outcomes.
Who can benefit, and how
- Owner-managed businesses
- Need a few reliable figures every month to run the business without waiting for annual accounts.
- Multi-location businesses
- Have branches, depots or plants whose results must be compared on a consistent basis.
- Manufacturers and processors
- Need product costing, conversion cost and margin analysis to support pricing and production decisions.
- Investor-backed companies
- Report monthly to investors and boards and need consistent definitions over time.
- Subsidiaries of foreign groups
- Need local management reporting that agrees with the figures sent to the parent.
Practical applications
These scenarios are illustrative. They describe common situations and are not accounts of particular clients or assignments.
- Illustrative scenario 01
A pharmaceutical company without product-wise margins
A formulation company knows its overall margin but not which products and stockists earn it. Schemes, returns and freight are booked to common ledgers. The work involves tagging these costs at entry, allocating shared costs on agreed bases and producing monthly contribution by product and channel.
- Illustrative scenario 02
A multi-plant manufacturer with late reports
An engineering manufacturer receives its monthly results four weeks after month-end. The firm sets a reporting calendar with defined estimates for accruals and inventory, reduces the pack to the measures the owners use, and brings the issue date forward while reconciling each pack to the books.
- Illustrative scenario 03
A distributor tracking branch performance
A distribution business with branches across several states wants to compare branches fairly. The work covers mapping cost centres in Tally, rules for inter-branch transfers and head office costs, and a monthly branch league table with sales, margin, debtor days and stock turns.
- Illustrative scenario 04
A technology company preparing an investor pack
A software company has investors who expect monthly reporting. The firm designs a pack covering recurring revenue, customer additions and losses, gross margin, people costs and cash runway, with definitions agreed in advance so that figures are consistent each month.
Discuss your requirements.
Discuss your reporting needs with the firm. A copy of a recent management report and a note on what is missing from it is a useful place to start.
