Your Odoo database already holds every sales order, stock move, posted invoice, and timesheet entry. The problem is rarely missing data. It is that the data sits inside separate modules while leadership waits for someone to compile a monthly spreadsheet by hand. An Odoo dashboard closes that gap by turning live operational records into numbers decision makers can actually see. This guide explains how Odoo dashboards and reporting work, what they show out of the box, how to build a leadership view across modules, and why clean data decides whether any of it can be trusted.
📋 Key Takeaways
- Every Odoo module ships with a built in dashboard, so pipeline, inventory, profit and loss, production, and project margin are live without custom development.
- Pivot and graph views sit on every list, so any data set becomes a chart, table, or spreadsheet in a few clicks.
- A custom Odoo dashboard gathers KPIs from several modules into one view you build once and refresh automatically.
- Scheduled reports email any dashboard on a fixed cadence, so nobody compiles figures by hand.
- A dashboard is only as honest as its data. Skip posting invoices or confirming stock moves and the numbers will mislead.
📑 Table of Contents
- Why Your ERP Holds Data Leadership Never Sees
- Built In Dashboards Versus Custom Reporting
- Pivot and Graph Views on Any Data Set
- The KPIs an Odoo Dashboard Tracks by Module
- Building a Leadership Dashboard
- Spreadsheet View and Live Export
- Scheduled Reports and Threshold Alerts
- Data Quality as the Real Prerequisite
- When You Need an External BI Tool
- Setup Steps to an Executive Dashboard
- Frequently Asked Questions
Why Your ERP Holds Data Leadership Never Sees
- Every department touches Odoo daily. Sales enters orders, the warehouse confirms deliveries, finance posts invoices. Yet each number stays locked inside the module that created it.
- Leadership wants this month revenue, the current inventory value, and which projects are profitable. Answering that normally means logging into three modules and assembling a report by hand.
- That job usually lands on finance, who rebuild the same spreadsheet from Odoo data, and by the time a decision maker sees it the figures have already moved on.
- The data was live the whole time. The gap is visibility, not availability, and an Odoo dashboard closes it.
Built In Odoo Dashboards Versus Custom Reporting
Dashboards every Odoo module ships with
- Sales surfaces pipeline value, quotation conversion, and revenue by salesperson.
- CRM shows leads by source, the conversion funnel, and activities that are due.
- Inventory reports stock levels, incoming and outgoing moves, and category valuation.
- Accounting presents a profit and loss summary, aged receivables and payables, and bank balances.
- Manufacturing tracks production orders by status and work centre use.
- Project displays task status, profitability per project, and unbilled hours.
Custom reporting your team or partner can build
- Cross module dashboards placing revenue, inventory, and receivables in one view.
- Custom KPI tiles that drill into the source records behind every number.
- Filtered views such as every project below a thirty percent margin.
- Department dashboards shared only with the groups that need them.
Pivot and Graph Views: Analysis on Any Data Set
- The pivot view sits on every list. Switch to pivot, drag dimensions such as salesperson or month onto rows and columns, and measures populate on their own. A live pivot table without opening Excel.
- The graph view renders the same records as a bar, line, or pie chart. One click swaps the type, and filters narrow it by date or team.
- Both views drill into detail. Click a cell or a bar and Odoo lists the records behind that figure, so a headline sales number resolves to the exact invoices.
- Any configured pivot or graph saves as a shared favourite, so the same analysis stays reproducible instead of being rebuilt each time.
The KPIs an Odoo Dashboard Tracks by Module
Odoo tracks the important numbers natively, and because the modules share one database, a sales figure already reflects what happened in inventory and accounting. For how those records flow together, see our guide to how Odoo inventory data connects across accounting, manufacturing, and sales.
Metrics each module exposes out of the box
- Sales reports quotation to order conversion, average deal size, and revenue per salesperson.
- CRM measures the lead to opportunity rate, weighted pipeline value, and sales cycle length. A connected pipeline matters here, so it helps to understand how Odoo CRM feeds the rest of your ERP.
- Inventory follows stock turnover, dead stock value, and warehouse valuation.
- Accounting calculates current ratio, days sales outstanding, and gross margin.
- Manufacturing watches production lead time, equipment effectiveness, and scrap rate.
- Project reports margin, employee utilisation, unbilled hours value, and on time delivery.
Building a Leadership Dashboard
What a leadership dashboard should put on one screen
- This month revenue against last month and target, with drill down by product line and region.
- Cash position, meaning bank balances with receivables and payables due this week.
- Gross margin, revenue minus cost of goods sold, by product category and trended over recent months.
- Inventory value in total and by warehouse, with turnover shown and dead stock flagged.
- Receivables ageing in bands from current to long overdue, largest customers first.
- Project health, active projects ranked by margin with weak ones flagged.
A functional consultant usually builds this view during implementation by working out which numbers leadership relies on. Setup runs a couple of hours while the value is permanent. If you are weighing that help, see what an Odoo consulting engagement actually covers.
Spreadsheet View and Live Export
- Odoo Spreadsheet pulls live data from your records. Build a formula referencing an Odoo model and the sheet refreshes as data changes, with no manual export to repeat.
- Insert a pivot from any model into that spreadsheet, then filter, group, and calculate while it stays connected to live figures.
- Spreadsheets live inside Odoo and share with user groups, so everyone reads one source and the version control mess disappears.
- When you need a static copy, any list, pivot, or report exports to a spreadsheet file.
Scheduled Reports and Threshold Alerts
- Any dashboard or report can arrive by email on a fixed cadence, such as a daily revenue summary for the sales head or a weekly receivables ageing for finance.
- Threshold alerts fire automatically when a metric crosses a boundary you set, such as overdue receivables climbing past a figure you care about.
- Activity reminders chase the tasks, follow ups, and approvals that have slipped, keeping the data feeding your dashboard current.
Data Quality: The Prerequisite a Dashboard Cannot Fix
Why a dashboard sometimes shows the wrong number
- Revenue reads zero for the month because fifty invoices sit in draft. The data exists but was never posted.
- The inventory screen claims a hundred units while the shelf holds eighty, because receipts were never confirmed.
- Project profitability looks healthy until you learn the team logged only half their hours, which inflates the margin.
- A sales by region report reads blank because hundreds of customers have no state assigned.
The dashboard is rarely wrong. The data behind it is incomplete. A pre-implementation Odoo ERP audit surfaces these discipline gaps, and following the Odoo accounting configuration checklist ensures the right entries are enforced before anyone trusts the numbers.
When You Need an External BI Tool
Where Odoo dashboards stop and BI tools begin
- Comparing Odoo data against a separate system such as marketplace analytics or a legacy database.
- Forecasting, regression, or cohort analysis on your Odoo data.
- Interactive visuals with custom widgets or maps beyond the built in chart types.
- A warehouse piping several sources into one store for unified reporting.
Tools that connect to Odoo cleanly
- Metabase is open source, connects to PostgreSQL, and suits many mid market teams.
- Power BI is enterprise grade and connects through a PostgreSQL connector or API.
- Looker and Looker Studio are cloud native and fit teams already on Google.
- Each reads from PostgreSQL directly, so no custom development is required. If you are weighing one anyway, our take on when an Odoo custom build is actually worth it helps, and read only access stays the safe default.
Setup Steps: From Zero to an Executive Odoo Dashboard
A practical path to a working leadership view
- Name the five to seven numbers leadership checks every week, not twenty and not every metric Odoo can produce.
- Verify data quality. Confirm invoices posted daily, stock moves validated, and timesheets approved weekly before you trust a tile.
- Configure the built in dashboards with filters, date ranges, and grouping per module, then save as favourites.
- Build one custom dashboard so revenue, inventory, receivables, and project margin share one screen.
- Schedule a snapshot to leadership inboxes weekly, with the profit and loss going to the board monthly.
- Review after thirty days, drop tiles nobody opened, and add anything missing.
Most of this setup takes a couple of hours with a partner, yet the payoff repeats every week. Leadership sees live figures instead of a stale spreadsheet, and the dashboard adapts as reporting needs shift.
Odoo Dashboards
Want Leadership Dashboards That Show Live Data Instead of Last Month Spreadsheet?
Tatvamasi Labs builds executive Odoo dashboards during implementation. Five to seven KPIs, cross module visibility, and scheduled email reports your leadership can act on.
Set Up Your Dashboard →Frequently Asked Questions
An Odoo dashboard turns live module records into visible numbers such as pipeline value, stock levels, profit and loss, and project margin. Every module ships with one, and you can build a custom view that pulls metrics from several modules onto a single screen.
Yes. Sales, CRM, Inventory, Accounting, Manufacturing, Project, and Purchase each arrive with a built in dashboard. Use those as they are or add filters and grouping and save the result as a favourite.
Yes. A custom dashboard places tiles from several modules in one view, so revenue, inventory, receivables, and project margin sit together. Because the modules share one database, the numbers stay consistent.
Pivot and graph views are the building blocks. Any list can become a pivot table or a chart, and a saved pivot or graph can be dropped onto a dashboard so the analysis refreshes automatically.
Yes. Any dashboard or report can be scheduled to send by email on a daily, weekly, or monthly cadence. It runs on its own and arrives as a file or a link, removing the manual compilation step.
The dashboard reflects whatever is in the database. Unposted invoices, unconfirmed stock moves, and unapproved timesheets make figures look wrong even though the dashboard calculates correctly. Clean data entry is the fix, not configuration.
Reach for a tool like Metabase, Power BI, or Looker when you need cross database analysis, advanced statistical modelling, data from non Odoo sources, or visuals beyond the built in graphs. Each connects to the PostgreSQL database Odoo uses.
Prefer a quick chat? Message the Tatvamasi Labs Odoo team on WhatsApp for fast answers about dashboard and reporting setup.
CHAT ON WHATSAPP
