What we do
Tools
Industries
Department
How we workLet's talk →
Home/Odoo/Odoo Report Tools
Odoo

Making an Odoo Report: Pivot View, Spreadsheet Dashboard or a PDF Layout

Your manager wants this month's sales by salesperson and product category, and the default chart in the Sales app shows neither. Odoo can build that table in about a minute. The trick is opening the right tool: a pivot for a quick answer, a spreadsheet when it has to refresh, Studio when the report is a printed document.

Where Odoo reports live

A table of numbers: open the app's Reporting menu, switch to the pivot view, and set Measures and Group By.

Any app Reporting Pivot view

A chart: same screen, graph view. Bar, line or pie, one measure at a time.

A dashboard that refreshes: click Insert in Spreadsheet on the pivot, then add that spreadsheet to a dashboard.

Dashboards Configuration Dashboards

A printed document such as an invoice or delivery slip: that's a PDF report, changed in Studio.

Toggle Studio Reports

Balance sheet or profit and loss: these come with the Accounting app.

Accounting Reporting

Edition: spreadsheets, dashboards and Studio generally need Odoo Enterprise, or the matching Odoo Online plan (Studio sits in the Custom plan). Confirm what your subscription includes before you plan around them.

The Odoo report tool for each job

What you need Use this Watch for
A quick answer on screen Pivot or graph view from the Reporting menu. A graph shows one measure. Switch to the pivot for several.
A figure managers check every week A spreadsheet linked to Odoo data, turned into a dashboard. Edit a copy, not the standard dashboard.
A customer-facing document A PDF report in Studio: Toggle Studio, Reports, then New with an External, Internal or Blank layout, or a duplicate of the standard report. On Odoo Online, Studio comes with the Custom plan, or as the one app on the free plan. Header and footer edits change every report.
Logic the report editor can't do The report's XML through Edit sources, or a custom module. Conditions in a PDF report can only be changed in XML. Custom modules need Odoo.sh or your own server, not Odoo Online.
Statutory statements The Accounting app's balance sheet, profit and loss and related reports. Check the date range and the company before you read a total.
Figures from systems outside Odoo None of the above reads them. That takes the external API, which on Odoo Online is part of the Custom plan. Two exports joined in Excel go stale as soon as they're pasted.

Sales by category in an Odoo pivot, then onto a dashboard

  1. 1

    Filter before you group

    The pivot adds up whatever the search bar lets through. Set the filters first, such as this month and confirmed orders only, so the totals mean what you think they mean.

    Watch for: the default filter that's already in the search bar. It's easy to miss, and it changes every total below it.

  2. 2

    Pick the measure

    Click Measures. Only number fields (integer, decimal, monetary) can be measured, plus Count, which counts records. A pivot can show several measures side by side.

  3. 3

    Set rows and columns

    Click the + beside the Total header on the rows to add salesperson, then on the columns to add product category. The flip axis button swaps them. Click a measure's label to sort by it.

    Watch for: dates. Odoo often groups by Date > Month on its own, which splits your table if you only wanted one period.

  4. 4

    Download it, or insert it into a spreadsheet

    The download button gives you an .xlsx file, which is a snapshot. Insert in Spreadsheet, then Blank spreadsheet, keeps the table linked to Odoo. New spreadsheets are saved in the Documents app under My Drive, and linked data refreshes each time the sheet is opened.

    Watch for: the inserted pivot is static at first. To change its rows or measures, use Data, then Re-insert dynamic pivot.

  5. 5

    Turn the spreadsheet into a dashboard

    Dashboards Configuration Dashboards

    Pick a section and choose Add a spreadsheet. Once it's a dashboard, it's only reachable from the Dashboards app.

    Watch for: changes made to Odoo's standard dashboards are lost on upgrade. Duplicate one first and edit the copy.

An Odoo report that doesn't show what you expected

The spreadsheet won't let you change the pivot

How you'll know: You can't add a group or swap a measure on a table you inserted from a pivot view.

Fix: It was inserted as a static pivot. Use Data, then Re-insert dynamic pivot, and pick the table.

Your dashboard changes vanished after an upgrade

How you'll know: A standard dashboard is back to how Odoo shipped it.

Fix: Edits to standard dashboards don't survive upgrades. Rebuild them on a duplicate.

You changed one invoice header and every PDF changed

How you'll know: Delivery slips and quotations now carry the line you meant for invoices.

Fix: Header and footer edits in Studio apply to all reports. Company-wide layout lives in Settings, Configure Document Layout. Put invoice-only text in the invoice report's body instead.

The total is right in Odoo and wrong in the meeting

How you'll know: Someone adds sales from a separate till system or a 3PL portal to the Odoo export by hand.

Fix: Odoo can only report on records it holds. Bring those figures into Odoo, or report from both systems in one place.

Before you build another Odoo report

Does Odoo have built-in reporting?

Yes. Each app has a Reporting menu with pivot and graph views, spreadsheets can hold tables linked to live Odoo data, the Dashboards app turns those spreadsheets into dashboards, and Studio edits the PDF reports Odoo prints, such as invoices.

Is OpenERP reporting the same as Odoo reporting?

Odoo is OpenERP under a new name. The rename came in 2014, and the pivot and graph views longtime users know carried forward. Spreadsheet dashboards and the Studio report editor came later, so a report built the OpenERP way is rarely the quickest route now.

Can I build a custom report in Odoo?

Yes. For a printed report, open the model, click Toggle Studio, then Reports and New, and choose External, Internal or Blank. For a table or chart, a pivot inserted into a spreadsheet covers most needs. Logic the editor can't express goes in the report's XML or a custom module, and custom modules don't run on Odoo Online.

Does Odoo produce standard financial reports like a balance sheet?

Yes. The Accounting app includes the balance sheet, profit and loss and related statements under its Reporting menu, without an add-on.

Can Odoo reports be automated to run and send themselves?

Partly. Dashboards and linked spreadsheets refresh whenever they're opened, so the figures are current for anyone who logs in. Odoo's Digest Emails send chosen KPIs to recipients daily, weekly, monthly or quarterly, but not a pivot table or a spreadsheet. Emailing the report itself on a schedule needs a scheduled action with code behind it, or a build outside Odoo. n-frames builds that scheduled send on Odoo's external API, including reports that mix Odoo data with another system's.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.