Odoo's reports don't show what I need. How do I get better ones?
Short answer: Odoo, a suite of business apps for sales, stock and accounting, gives you four ways to get a report: built-in screens, a Dashboards app built on spreadsheets, Odoo Studio for printed documents, and exports to Excel or CSV. For most distributor questions, like which customers are slipping or which items are about to run out, a dashboard or a saved export is enough. Reports that mix Odoo with other systems need a connection through Odoo's external API.
Odoo has the data you need, but the screens do not show it the way you want, and you are not sure which option to try first.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
What does Odoo reporting include?
Four things, from simplest to hardest.
- Built-in screens: list and report views inside each app, with search filters. Fast, but you get the layout Odoo chose.
- Dashboards app: Odoo's documentation says its spreadsheets are the foundation of dashboards, and that data sources link a dashboard to your live database. You can add lists, pivot tables (a table that sums data by rows and columns) and charts, and put filters above them.
- Odoo Studio reports: Studio is Odoo's editor for screens and printed documents. It can change a PDF report such as a quote or a delivery slip. As of November 2026, Odoo's pricing page lists Studio under the Custom plan.
- Exports: any list can be exported to CSV or XLS.
Odoo's pricing page also lists the external API under the Custom plan. The API is the door that other software uses to read and write Odoo data. It matters if you want to send Odoo numbers to another tool. For more detail, see Odoo versus NetSuite.
How do I build a dashboard in Odoo?
Odoo's documentation has a separate guide for building and customizing dashboards. The sections I would use are these.
- Pick the question. One dashboard, one question. For example: which customers ordered less this quarter than last?
- Insert a pivot table. Choose the sales data, put customers in the rows and months in the columns.
- Add a chart from the same data, if a picture helps.
- Add filters. Odoo's docs describe global filters that appear as a search bar above the dashboard, with date filters too.
- Share it. You can share a snapshot of a dashboard with people who lack the access rights, or with outside users. Odoo's docs describe it as a snapshot, so remember it shows data at that moment.
This is the right route for team views that several people open. If the question is about sales activity and targets, my guide to a KPI dashboard your team will use covers which numbers to choose.
What should I know before sharing a dashboard?
Four details from Odoo's dashboard documentation save trouble.
- Duplicate before you edit. Odoo's standard dashboards are reinstalled at each version upgrade, so any change made to the original is lost. Duplicate the dashboard and edit the copy. If you delete a standard one, it comes back at the next upgrade.
- Access has two layers. Who sees a dashboard in the left panel is set by user groups in the Dashboards configuration. What data appears inside is set separately, by each person's rights to the underlying records. A manager can open a dashboard and see empty tables if their data rights are narrower than the author's. Test with a real user, not only the admin.
- You can drill down. Click a value in a table or a point on a chart to open the records behind it. Click a chart or table title to open the list, pivot or graph view that feeds it. That is how you check a surprising number.
- Time charts can zoom. Most charts over time let you change the unit, such as week or month, and a full-screen slider zooms in on a span.
Odoo also ships standard dashboards for installed apps, including a Warehouse Daily Operations dashboard, and a personal My Dashboard that collects your favourite Odoo views. Both are a quick way to find out how much of your Monday list is already covered before you build anything.
A worked example with made-up names: the sales manager wants a Monday view of customers whose orders fell. You duplicate the standard sales dashboard, add a pivot of customers by month, put a date filter in the search bar, and give the group "Sales managers" access. You then log in as a sales manager and check that the customers appear. Only then do you tell the team it is ready.
What can the built-in report views do?
Before you build a dashboard, try the Reporting menu inside each app. Odoo's documentation names two views made for analysis: graph and pivot.
- Pivot view: you pick a measure (a number field such as untaxed amount or margin, or a simple count of records) and group it by rows and columns. Click the plus sign beside Total to add a group, flip the axes with one button, and sort by clicking a measure label. A button downloads the pivot as an .xlsx file, which is the quickest way to get a one-off table into Excel.
- Graph view: bar, line and pie charts. Bar charts handle larger sets of categories, line charts show change over time, and pie charts suit a small number of parts of one whole. Bar and line charts can be stacked, and line charts can be cumulative to show growth.
By default the data is grouped by month, which suits a trend question. Only numeric fields can be measured. If the number you want is text, such as a status, use Count and group by that field. Many of the questions in the table below, such as a customer trend, can be answered here in a few minutes, before any dashboard is built.
How do I export Odoo data to Excel?
Odoo's documentation gives these steps.
- Open the list view of the records you want, such as sales order lines.
- Tick the records, then choose Action, then Export.
- Choose the fields. Drag them into the order you want.
- Pick CSV or XLS as the file type.
- Save your field choice as an export template, so next week it is one click.
One limit to know: Odoo warns that large exports can time out, and suggests exporting in smaller batches. For a very big item or order history, split it by month. For more detail, see NetSuite reporting options.
Exporting is good for one-off questions and for a weekly report that one person builds in Excel. It does not scale to a report a manager expects every morning without anyone touching it.
How do I change a printed document in Odoo Studio?
Studio can edit existing PDF reports or create new ones. Odoo's documentation recommends that you duplicate the standard report first and change the copy. Some limits it lists:
- Changes to a report's header and footer affect all standard and custom reports.
- Conditions (show this block only if...) can only be changed in the XML, the code behind the layout, not in the visual editor.
- You can restrict a report to certain user groups.
- A reset button brings back the standard version.
Studio changes layout. It does not do new calculations across other systems. A packing slip with your logo and a lot number: yes. A margin report using your freight bills held in another tool: no.
Which reports do distributors usually lack?
These are the ones I hear about most. Most can be built from a pivot table or export, once the data is clean.
| Report | Question it answers | Where to build it |
|---|---|---|
| Customer sales trend | Who is ordering less than last quarter? | Dashboard pivot |
| Reorder watch | Which items will run out before the next delivery arrives? | Dashboard list, or a saved export |
| Supplier lead times | Which suppliers ship later than they promised? | Export, then Excel |
| Margin by customer | Where does a special price cost me money? | Needs cost data. Check landed costs are set |
| Open backorders | What have I promised that I cannot ship? | Dashboard list |
| Combined view | Odoo plus bank, shipping or web data in one place | External API into a separate tool |
Worked example, made-up numbers: a customer ordered 40 cases a month for six months, then 22 cases last month. A customer sales trend pivot shows that drop. Nobody has to hunt for it, and a salesperson can call that week.
What if Odoo still lacks the report?
Then the answer is a layer outside Odoo. A small reporting tool reads your data through the external API, joins it with other sources and shows one page. It can send a summary by email each morning. My guide to Odoo for distributors covers where else Odoo needs help, and my Odoo alternatives guide covers the case where the whole system does not fit. If you connect Odoo to your accounting software, ask your partner which connection they have used before. The route depends on the version and the accounting tool, so check before you plan around it.
How I'd approach this
I would write the five questions the owner asks every Monday. Then I would try to answer each one with a dashboard first, an export second, and a custom layer last. In my experience, most of those questions fit a dashboard, and one or two need more.
Do not start by buying another reporting product. Start by fixing the data feeding the report: item codes, customer names and costs. A dashboard on messy data only shows messy numbers faster.
Questions people ask
Does Odoo have a report builder?
Odoo has list and report views, a Dashboards app built on spreadsheets, Studio for PDF documents, and exports. Studio is listed under the Custom plan. It changes layout and fields. It does not combine data from other systems.
Can I customize Odoo reports?
Yes. Studio lets you duplicate a standard PDF report and edit it. Odoo recommends changing the copy, not the original, and notes that header and footer edits affect every report.
How do I export Odoo data to Excel?
Open a list, tick records, choose Action then Export, pick fields and choose CSV or XLS. You can save the field list as a template. Large exports can time out, so use smaller batches.
Can Odoo reports be automated?
Dashboards update from live data. For a report that arrives by email each morning, use a small tool that reads Odoo through the external API. My business process automation guide explains how to pick tasks to automate.
Do I need the Custom plan for reporting?
Studio and the external API are listed under Custom on Odoo's pricing page. Exports are a standard list action. Ask Odoo or your partner which plan includes the Dashboards app before you plan around it.
More in this topic: B2B: ERP reporting and integrations (10 guides) →