Management reporting: what it includes and how to automate it

Management reporting is the set of reports that shows the owner the real state of the business: how much the company earned, where the money sits and what the company's assets consist of. Unlike statutory accounting, it is made not for the tax authority but for internal use — so decisions rest on honest numbers rather than on a feeling.

Below we cover what management reporting includes, why the three key reports are needed, how it differs from statutory accounting, why manual Excel starts lying as the company grows, what automating it actually means and where to start.

What is management reporting?

In short: it is the numbers of the business, assembled for the owner and in the form the owner needs, not for reporting to the state.

Accounting answers the state's question of whether taxes were calculated correctly. Management reporting answers the owner's question of what is happening in the business and how much they actually earn. These are different tasks, and keeping only statutory accounts is not enough: profit on a tax return and cash in the bank account are not the same thing, and cash gaps happen to companies that are profitable on paper.

The practical point of management reporting is that decisions are made on facts. Whether to take a loan, whether the company can support a new hire, which business line brings in money and which one eats it — these questions are answered by specific reports, not by intuition.

The three key reports: P&L, cash flow and the balance sheet

In short: the P&L shows profit, the cash flow statement shows money, the balance sheet shows assets and their sources. Taken separately each one is misleading; together they give the full picture.

An industry breakdown explains well why all three are needed:

Without a cash flow statement, a P&L and a balance sheet you cannot build a business: one report shows profit, another the movement of money, the third pulls it all together into a full picture of assets and liabilities — a breakdown of the three basic management reports, Adesk.

A typical mistake is to look only at the cash in the account. The account is full, yet the company is loss-making, because that cash is customer prepayments and unpaid taxes. Or the opposite: there is profit but no money, because it is frozen in inventory and receivables. What separates these situations is the set of reports together, not any one of them.

How does management reporting differ from statutory accounting?

In short: statutory accounting is for the state in strict formats; management reporting is for the owner in whatever logic suits the business.

Because of this difference, management reporting cannot simply be exported from the accounting software. It is built on its own methodology: split by business line, reflecting what matters to this particular company. That is why it is so often kept separately — and most often in spreadsheets.

Why does Excel stop coping?

In short: while there are few transactions the spreadsheet works; as the company grows it turns into a source of errors and manual labour.

Excel is an honest starting point. The problem begins when the business grows: data has to be collected by hand from 1C, the accounting and ERP platform most Russian companies run on, from the bank, the CRM and the warehouse system, then consolidated into one spreadsheet and reconciled for variances. At that stage the spreadsheet stops helping and starts hiding errors:

A single error in an Excel formula can cost a company millions: the numbers are distorted in key metrics — revenue, costs, payroll — and go unnoticed — a review of the risks of manual accounting in Excel, vc.ru.

On top of that come diverging versions, the absence of a change history and weak connections to other systems. Time is a separate pain point: the report is ready a week after the month is closed, when the decisions have already been made blind. Why spreadsheets stop carrying the accounting load and what replaces them is covered in detail in the article “When it is time for a business to leave Excel”.

What does automating reporting mean?

In short: data flows into the reports on its own from the sources under a single logic, and the owner sees the numbers in real time instead of assembling them by hand.

Reporting automation is when the system itself pulls data from 1C, the CRM, the bank and the warehouse system, brings it to one calculation logic and shows the result in reports and dashboards. Manual transfer between systems disappears, and with it most of the errors:

A BI approach brings together data from 1C, CRM, warehouses and external sources into a single calculation logic, automates its loading and transformation, and reduces the number of errors when preparing management reports — on automating management reporting with BI, Qlever.

It is important not to confuse automating the collection with answering the question of which numbers to look at in the first place. First define the metrics that decisions are made on, and only then automate their collection. Which numbers exactly belong on an owner's dashboard is covered in the article on the owner's dashboard. And how to connect 1C, the CRM and the bank into a single data flow technically is covered in the piece on system integrations.

What stages does automation consist of?

In short: five stages, and the first two are about methodology, not about software.

1. Define the decisions and the metrics. Which decisions the owner makes and which numbers those decisions need. Without this you automate the collection of data nobody needs.
2. Describe the sources and the methodology. Where each number comes from and by which rules profit, margin and cost of goods are calculated. This is where a single logic is agreed.
3. Clean up the data. Reference books, consistent names for line items, a split by business line. Garbage in gives garbage in the report.
4. Set up automatic collection. Integrations with 1C, the CRM and the bank, loading and transforming data, calculating metrics, delivering them to reports and dashboards.
5. Ongoing support. Reconciliation checks, new breakdowns, support as the business grows.

The main mistake is to skip the first two stages and go straight to building dashboards. The system then shows wrong numbers quickly and vividly, and trust in the reporting is lost at the start.

How much does it cost and what drives the price?

In short: the price depends not on the tool but on the number of sources and the complexity of the methodology; what you should calculate is the total cost of ownership.

A specific figure cannot be named — the range is set by the task. The cost drivers:

• the number of data sources (1C, CRM, bank, warehouse, website) and the complexity of the integrations;
• the complexity of the calculation methodology and the number of breakdowns;
• the quality and volume of the source data that has to be cleaned up;
• the depth of visualisation and the number of dashboards;
• support and further development as the business grows.

One point worth understanding: the main cost sits not in the BI tool licence but in the implementation — setting up integrations, agreeing the methodology and putting the data in order. An off-the-shelf dashboard builder is cheap to start with but hits a ceiling as soon as the calculation logic is non-standard. A custom system built around the process costs more at the start, but the code and the data stay with the company. A detailed comparison is in the piece “A custom system or an off-the-shelf one”.

Why does reporting automation fail to take root?

In short: almost always the cause is not the tool but the methodology and the data.

Typical scenarios:

1. Automated without a methodology. Collection was set up before anyone agreed how profit and margin are calculated. The report looks good, but the numbers are debatable.
2. Garbage in the sources. Different names for the same line items, duplicated counterparties, transactions with no allocation. The system honestly consolidates the mess.
3. A dashboard for the dashboard's sake. Plenty of metrics, but no decisions are made on them. A nice picture nobody opens.
4. The report does not reconcile with the money. Management profit does not match the bank balance, and trust in the system disappears.

The first and second points are the most common. Reporting automation does not put the data in order — it requires order. If there is no methodology, the system will lock its absence in place.

Where do you start?

An order of steps that does not have to be redone:

1. Write down the decisions. The 5–7 decisions you regularly make on the basis of numbers: hiring, purchasing, loans, pricing, business lines.
2. Define the metrics. For each decision, a specific metric: profit by business line, margin, cash gap, turnover.
3. Describe the sources. Where each number comes from and by which rule it is calculated.
4. Clean up the data. Consistent reference books and allocation by business line before automation, not after.
5. Automate the collection. Integrations with 1C, the CRM and the bank, a single calculation logic, output to reports and a dashboard.
6. Plan for support. Reconciliation checks and new breakdowns as the business grows.

At IncubeAi we build management reporting around the company's own process: integrations with 1C, CRM systems and banks, a single calculation logic, dashboards built for the owner's decisions. The code and the data stay on the business's side, the data stays in Russia, the work runs under a contract, and support continues after handover. If it is clear which decisions you need numbers to close, start with a conversation about them — discuss a project.

Sources

• Adesk, “The three pillars of management reporting: why you cannot build a business without a cash flow statement, a P&L and a balance sheet” — the purpose of the three basic reports and how they connect.
• vc.ru, “A single error in Excel can cost a company millions” — the risks of assembling reporting by hand in spreadsheets.
• Qlever, “Management, operational and accounting reports: can they be automated with BI” — combining data from 1C and CRM and automating report collection.