- Home
- Odoo Integration
- Odoo dashboards
Odoo dashboards and reports in Odoo 20: how they are built and who sees what
Odoo 20's Dashboards app runs on Odoo Spreadsheet, part of Odoo Documents, which Odoo's Compare Editions page lists in Enterprise only. Each dashboard is a spreadsheet tied to live data, and Odoo reinstalls its standard ones at every version upgrade, so work on a copy. Each viewer sees only the records their access rights allow, so one shared dashboard can show different totals to different people.
Odoo 20 dashboards are spreadsheets with live data
A dashboard in Odoo 20 is an Odoo spreadsheet with tables and charts that pull from your database. Data sources link the sheet to Odoo, and the latest numbers load each time the dashboard opens or refreshes. Odoo’s Spreadsheet module is part of Odoo Documents. Odoo’s Compare Editions page ticks Documents and Spreadsheet for Enterprise only. Its pricing page says the Standard and Custom plans include all apps.
Three facts shape how you work with them:
- Standard dashboards come with your apps. A set is there by default, and which ones depends on the apps you installed.
- A converted sheet moves. Once a spreadsheet becomes a dashboard, you open it only from the Dashboards app.
- My Dashboard is the odd one out. It is built on Odoo views, the lists and charts inside each app, not on Odoo Spreadsheet.
Building one takes two steps and two access rights
Odoo puts it simply: insert Odoo data into a spreadsheet, then convert that spreadsheet into a dashboard. The data comes in as lists, pivot tables or charts that you prepare in Odoo’s views first. To build from scratch, a user needs Dashboards / Admin rights and at least Documents / User rights.
A dashboard can run to several pages. Links between the sheets let users move from page to page, and global filters apply across all of them. A new dashboard is open by default to everyone in the default internal user group, so set its groups before you share it.
Odoo’s stock dashboards show the pattern. Three sit in the Dashboards app: Warehouse Daily Operations, Operation analysis and Warehouse Metrics. Warehouse Daily Operations flags late and unassigned transfers and forecasts the next 7 days of scheduled work. By default, only users with admin access to Inventory can see the other two.
Standard dashboards reset at every upgrade
Edit a copy, never the original. Odoo reinstalls its standard dashboards at each version upgrade, and any changes to the original version are lost. Delete one and it comes back at the next upgrade.
On Odoo Online, upgrades are not optional. A database on a major version must upgrade every two years, and Odoo runs the upgrade itself if you take no action by the due date. A database on a minor version must upgrade a few weeks after the next one comes out, and minor versions usually come every two months. Odoo’s pages do not say whether a minor upgrade also reinstalls standard dashboards. So put your changes on a duplicate, and keep a note of what you changed.
Two rules decide who sees what
Seeing a dashboard and seeing its data are separate. User groups decide who finds a dashboard in the Dashboards app. The data inside it follows each user’s access rights to the records behind it.
That gap can mislead. Odoo’s own example: give the Sales / User: Own Documents Only group the Sales dashboard, and each person sees only their own sales. The dashboard opens fine, but the totals are not the team’s totals. Check the rights of each group before you give it a dashboard.
For someone outside, use Share. It makes a link to a frozen copy of the dashboard, for an outside party or a colleague without access.
Reports without a dashboard: graph, pivot and PDF
Most Odoo apps have reports under a Reporting menu. Odoo names two views made for reporting: graph and pivot. The base layout of every printed report, one of seven, is set in Settings, Configure Document Layout, outside Studio.
Scroll the table sideways to see every column.
| Tool | What it does | Limits from Odoo’s docs |
|---|---|---|
| Graph view | Bar, line or pie charts of filtered records | Measures number fields only, plus a Count |
| Pivot view | Totals broken down by rows and columns | Same measure rule; downloads as an .xlsx file |
| Studio PDF reports | Edit printed reports such as invoices and quotations, or make new ones | Odoo’s pricing page lists Studio under the Custom plan only; Compare Editions ticks it for Enterprise only |
What Odoo’s AI and an outside AI client can do with reports
Odoo’s AI app page claims “Sales figures, performance analysis, forecasts, trends… just ask!” Odoo 20’s release notes say its AI assistant can answer questions about your finances, based only on the accounting data in your database. Odoo’s AI features use its In-App Purchase credits.
An outside AI client can also report through Odoo’s MCP server. Read group, one of the 5 tools on by default, groups records and computes totals such as sums and averages. Open Menu Graph and Open Menu Pivot stay hidden until an admin exposes them. Then they open those views with the groupings and measures you ask for. Compute Report Measures is meant to run first, to find what can be measured. Odoo’s sample prompts include charting pipeline value by salesperson, and comparing this quarter’s invoices with last quarter’s. Those tools open views in Odoo. We found no tool on Odoo’s list that builds or saves a Dashboards app dashboard. Our Odoo MCP page covers the tools and how a client signs in.
Apps from Odoo’s Apps Store are a separate route. We searched it on 19 November 2026. With version 20.0 picked, “dashboard” returned 2,261 apps. With the Odoo Online filter on, the search across all versions returned 0. The filter does return apps: with no search term, it listed 123 on 18 November 2026. On Odoo Online, dashboards come from Odoo’s own Dashboards app, either standard ones or ones you build from a spreadsheet.
Our team’s reporting work
Our team has taken Odoo live.
In one ERPNext rollout for a food manufacturer, the system gives batch records with lot numbers and expiry dates, yield reports, and live dashboards for production yield and wastage. Read the case study: a full ERPNext rollout for a food manufacturer for what the plant tracks.
For stock records and valuation, see our Odoo inventory page. For jobs an agent can take off your team’s desk, see Odoo AI agents.
The first call is free.
Questions
Is there a mobile app for Odoo?
Yes, two kinds. Odoo recommends its progressive web app, which you install from the browser to your home screen. Its features include push notifications and SSO sign-in. There are also store apps on Google Play and the Apple App Store, which do not work with SSO. Odoo's Compare Editions page ticks the Android and iOS interface for Enterprise only.
Can ChatGPT create a dashboard in Odoo?
Not a Dashboards app dashboard, as far as Odoo's tool list shows. Connected through Odoo 20's MCP server, ChatGPT can group and total records with Read group, one of the 5 tools on by default. Once your admin turns on the view tools, it can also open a graph or pivot view in Odoo with the measures you ask for. Odoo's own sample prompt asks it to chart pipeline value by salesperson. We found no tool on the list that builds or saves a dashboard.
What are the two types of accounting methods used in Odoo?
For stock, Odoo's docs name two accounting standards. Under Continental accounting, the cost of goods becomes an expense when the vendor bill posts. Under Anglo-Saxon accounting, it becomes an expense when the customer invoice posts. Odoo says periodic valuation often goes with Continental and perpetual valuation with Anglo-Saxon, though a company may choose otherwise.
Is Odoo built in Python?
Its business logic is. Odoo's developer tutorial says the logic tier is written only in Python, and the data tier supports only PostgreSQL as its database. The screens use HTML5, JavaScript and CSS. So a custom feature that runs inside Odoo is written in Python, with HTML5, JavaScript and CSS for what users see.
What is the downside of Odoo dashboards?
Three things catch teams out. Odoo reinstalls standard dashboards at each version upgrade, so edits to the original are lost. A viewer without the right access sees only part of the data, so totals can mislead. And Odoo's docs say Apps Store modules cannot run on Odoo Online, where a filtered search for dashboard, across all versions, returned 0 apps on 19 November 2026.
Can I share an Odoo dashboard with someone outside the company?
Yes, as a snapshot. Click Share at the top right of the dashboard and copy the link. Odoo calls it a frozen version, so the person sees the numbers as they were when you shared, not live data. It also works for a colleague who has no access to that dashboard.
Can I export an Odoo report to Excel?
Yes, from the pivot view. Odoo's reporting docs say you can download an .xlsx copy of a pivot with its download button. A pivot measures only number fields, such as amounts and quantities, plus a Count of records. For a printed report, such as an invoice, Studio edits the PDF, and Odoo's pricing page puts Studio on the Custom plan. Without Studio, you still pick the base layout in Settings, Configure Document Layout.
Sources
Every source behind a figure or a vendor fact on this page, with the day we read it.
- Odoo 20 documentation, DashboardsRead 19 Nov 2026
- Odoo 20 documentation, Build and customize dashboardsRead 19 Nov 2026
- Odoo 20 documentation, SpreadsheetRead 19 Nov 2026
- Odoo 20 documentation, Inventory dashboardsRead 19 Nov 2026
- Odoo 20 documentation, ReportingRead 19 Nov 2026
- Odoo 20 documentation, PDF reports in StudioRead 19 Nov 2026
- Odoo 20 documentation, Odoo mobile appsRead 19 Nov 2026
- Odoo 20 documentation, Architecture overviewRead 19 Nov 2026
- Odoo 20 documentation, Inventory valuationRead 19 Nov 2026
- Odoo 20 documentation, Available MCP toolsRead 19 Nov 2026
- Odoo 20 documentation, AI MCP serverRead 19 Nov 2026
- Odoo, Odoo 20 release notesRead 18 Nov 2026
- Odoo, PricingRead 18 Nov 2026
- Odoo 20 documentation, UpgradeRead 18 Nov 2026
- Odoo Apps Store, search for dashboard, version 20.0Read 19 Nov 2026
- Odoo Apps Store, search for dashboard, Odoo Online filterRead 19 Nov 2026
- Odoo, Compare EditionsRead 18 Nov 2026
- Odoo, Artificial Intelligence appRead 18 Nov 2026
- Odoo 20 documentation, Odoo OnlineRead 18 Nov 2026
- Odoo Apps Store, Odoo Online filter with no search termRead 18 Nov 2026
Bring the numbers your team checks each week
The first call is free. Bring the reports your team builds by hand today and the Odoo apps you run, and we can talk through which dashboard or view fits each one.