How many times have you waited for the "consolidated report" while someone from accounting manually combined the CRM, inventory, and finances into one Excel file? And while the file is being prepared, the data in it is already partially outdated.
Management reporting without Excel is not about beautiful charts. It's about the manager seeing the state of the business when they need it, not when the report is finally ready. In this article, we will discuss which dashboards are worth setting up in Odoo, which KPIs are truly worth tracking, and what mistakes companies make when transitioning from Excel to a system.
Why Excel reporting loses to real-time dashboards
The problem with manual reporting is not in Excel itself, but in the fact that the data for it is collected from disparate sources: CRM separately, inventory separately, accounting separately. Each consolidation is manual labor, as well as maintenance and risk of error. A typical situation: there is a formula in the file that someone accidentally broke last month, and no one noticed it until the numbers diverged from reality.
Dashboards in Odoo are built on the same data that the system already has in real-time: CRM deals, inventory movement, processed invoices in accounting. The manager does not wait for a summary report — they open the dashboard and see the current picture at that moment. And if a number looks suspicious — they can immediately drill down into the details and see which specific deals or operations it consists of, instead of writing "please clarify" in the accounting chat.
From practice. One of the international franchise networks we worked with previously compiled reports from all locations manually — with a delay of several days. After implementing a unified dashboard, the owner sees the metrics of the entire network in real-time, without waiting for a summary report from each location.
What KPIs should be displayed on the manager's dashboard
Not every number deserves a place on the main screen. An overloaded dashboard is just as useless as its impression — the manager simply stops opening it. Stick to the principle: the dashboard should display metrics that require action, not just inform.
Financial metrics
Revenue over periods in dynamics — not a one-time figure, but a trend.
Accounts receivable — who owes the company money and how many days past due.
Profitability by segments or products — where the company earns and where it breaks even.
Sales and customer metrics
Deal funnel by stages — where deals get stuck most often.
Average check and deal cycle — are they increasing or decreasing over time.
Top clients by revenue — to promptly notice if a major client starts purchasing less.
Operational metrics
Execution of the production plan — fact against plan, not just plan.
Inventory levels and product turnover.
Tasks and projects — how many are overdue, how many are at risk.
From practice. In one of the public sector organizations, preparing reports took up to 100 hours a month of manual work by the team. After implementing automated reporting in Odoo, this time can be completely eliminated — the data is generated by the system, rather than collected by internal employees.
How dashboards eliminate "speaking different languages" between departments
A classic situation: the sales department says "everything is fine," the finance department sees cash gaps, and production is not keeping up with the sales plan. Each department looks at its own numbers in its own system — and none sees the full picture.
When the dashboard is built on a single Odoo database, all departments see the same numbers. There is no situation where the sales department reports a "record month," while the CFO sees completely different figures in their system — it’s the same number, just in different dimensions: sales see it as the number of deals, finance sees it as cash flow, production sees it as load on the lines.
From practice. In a manufacturing company that produces up to 4 tons of products per day, the production planning dashboard allows for simultaneous viewing of the loading line, raw material consumption, and order fulfillment — the production manager and the sales department work with the same data, rather than reconciling it afterward. More about this approach to production Automation in Odoo .
Three mistakes that cause the dashboard in Odoo not to work
The dashboard is compiled from all available system widgets. Odoo allows you to add virtually any metric with a single click — and this is the main trap. Companies often display 15-20 charts on the main screen simply because they are "available," instead of consciously focusing on 5-7 metrics relevant to a specific role. The result is that the manager opens the dashboard, gets lost in the colorful blocks, and returns to the habit of asking for an Excel report from accounting.
Default filters are not set up for the decision-making horizon. The Odoo dashboard often shows data "for all time" or "for the current month" by default — and if this filter is not reconfigured to match how the manager makes decisions (a week for operational issues, a quarter for strategic ones), they look at the wrong number every day and draw incorrect conclusions about the dynamics.
A uniform dashboard for all roles in the company. The sales department head needs a deal funnel and conversion rates, the CFO needs cash flow and accounts receivable, and the business owner needs a consolidated view across all areas. Odoo allows for the customization of separate dashboards for each role based on the same data, without duplicating analytical work — but in practice, companies often stick to one general dashboard "for everyone," which ultimately does not suit anyone.
How to start: what implementation consists of
Audit of current data sources and reports that the company receives manually.
Defining 5-7 key KPIs for each management role separately — not one set "for all."
Reconfiguring default filters to match the actual decision-making horizon, rather than system values "as is."
Training the team to work with dashboards instead of the usual Excel files.
Management reporting without Excel is not about rejecting analysis, but about ensuring that the analysis is based on current data rather than outdated weekly summaries. When a dashboard is built on a single system—and tailored to a specific role, rather than "for everyone at once"—the manager sees the real state of the business at any moment, rather than waiting for a report from the team.