Odoo CRM Reporting: Pipeline, Forecast and Dashboards in Odoo 19/20
Odoo CRM reporting in Odoo 19 and 20: pipeline analysis, win/loss, forecast, activity reports, sales dashboards and customer 360 views, step by step.
Most teams open the CRM reporting menu once, see a bar chart of opportunity counts and go back to Excel. The reports are deeper than that, and our Odoo implementation services include setting up Odoo CRM reporting so the numbers match how your team sells.
Related service: Odoo implementation services — CRM-to-cash set up end to end, from lead to invoice.
This guide is for sales managers, revenue leaders and Odoo admins on Odoo 19 or 20. It covers reporting only. For pipeline setup and stages, see our Odoo CRM guide; for how probabilities are calculated, see our guide to Odoo predictive lead scoring.
What does Odoo CRM reporting include in Odoo 19 and 20?

Odoo CRM reporting includes four reports under CRM > Reporting, plus spreadsheet dashboards and the smart buttons on each contact. Each one answers a different management question.
| Report | Where to find it | Question it answers | Best view |
|---|---|---|---|
| Pipeline Analysis | CRM > Reporting > Pipeline | How many deals sit in each stage, and for whom? | Graph, pivot, cohort |
| Leads Analysis | CRM > Reporting > Leads | Where do leads come from, and how fast are they converted? | Pivot, list |
| Forecast | CRM > Reporting > Forecast | What revenue is likely to close each month? | Kanban by month |
| Activities Analysis | CRM > Reporting > Activities | Which calls, emails and meetings did each rep complete? | Pivot, graph |
| Dashboards | Dashboards app | What does leadership need on one screen? | Spreadsheet dashboard |
| Customer 360 | Contact form smart buttons | What is our full history with this customer? | Form |
All of these reports read the same opportunity records, so clean pipeline data makes every report trustworthy.
How do you read the Odoo pipeline analysis report?
The Odoo pipeline analysis report opens as a stacked bar chart of this year's opportunities by stage, color-coded by the month each one reached that stage. From there, measures, filters and groupings turn it into almost any pipeline report.
Odoo's Pipeline Analysis documentation lists four views: graph, pivot, cohort and list. The pivot view shows expected revenue by stage and month, and can be split by salesperson, team, campaign, medium or source.
The measures matter more than the chart type. These are the ones sales managers use most:
- Expected Revenue: the raw deal value in each stage.
- Prorated Revenue: deal value weighted by probability, the honest pipeline number.
- Days to Assign and Days to Close: how long leads wait for an owner and how long deals take.
- Exceeded Closing Days: how far deals have slipped past their expected closing date.
- Expected MRR and Recurring Revenues: appear when the Subscriptions app is installed.
Odoo applies groupings in the order you pick them, so Stage then Salesperson differs from Salesperson then Stage. Save weekly views as favorites so everyone reads the same report.
How do you build a win/loss report in Odoo CRM?
You build an Odoo win/loss report from the Pipeline Analysis page with a custom filter on Won/Lost and the Include archived toggle switched on. Without that toggle, lost deals quietly drop out of the numbers.
Odoo defines the win/loss ratio as opportunities won divided by opportunities lost. Follow these steps:
- Go to CRM > Reporting > Pipeline and open the search panel.
- Enable both the Opportunities and Leads filters.
- Add a custom filter where Won/Lost is Won, add a rule for Lost, and switch on Include archived.
- Group by Stage, then add a custom group on Won/Lost, then group by Salesperson.
- Turn off the stacked toggle to see won and lost bars side by side.
- Switch to pivot to see expected revenue, or to cohort to compare created and closed dates.
Lost and archived records cause most win/loss confusion. One user on the Odoo forum found that lost leads and archived leads mix in CRM reporting, because both are inactive. The fix suggested there: filter on Lost Reason is set.
That fix only works if your team always uses Mark Lost with a reason, and never archives bad leads without one. A reason such as "Not a fit" or "Disqualified" keeps junk leads separate from real losses. Lost reasons are managed under CRM > Configuration > Lost Reasons.
How does the Odoo CRM forecast work?
The Odoo CRM forecast groups open opportunities by the month of their expected closing date and totals prorated revenue at the top of each column. It is a drag-and-drop view, so managers can move deals between months in a pipeline review.
According to the Odoo forecast report documentation, the default view shows the current user's opportunities expected to close within four months, plus those with no expected closing date. Dragging a card to a new month sets its date to the last day of that month.
Prorated revenue is expected revenue times probability. In Odoo's own example, a $3,800 deal at 90% and a $22,500 deal at 20% give $3,420 plus $4,500, so the June column shows $7,920. That is why the forecast is only as good as your probabilities.
Expected revenue report for a month or quarter
For a team-level Odoo sales forecast, Odoo documents an expected revenue report built on Pipeline Analysis. Use these three custom filters, matched on "all":
- Expected Closing is set, and is between the first and last day of the month or quarter.
- Salesperson is set, so unassigned leads do not inflate the number.
- Sales Team is in the teams you want, or leave this out for the whole company.
The expected revenue report guide notes that Pipeline Analysis loads with default filters, which you should remove before adding your own. Skip that step and two managers can get different totals.
What does the Odoo CRM activity report show?
The Odoo CRM activity report shows activities marked as done on leads and opportunities, grouped by type, salesperson, stage or date. Planned activities that nobody completed do not appear.
In the Odoo 20 source, the Activities Analysis empty state reads "Activities marked as Done on Leads will appear here." The report pulls completion date, activity type, salesperson, sales team, stage, customer and won or lost status, so you can compare effort with results.
Useful cuts for a weekly sales meeting:
- Activity type by salesperson: calls, emails and meetings completed per rep.
- Activity type by stage: where effort goes in the pipeline, and where it is missing.
- Won filter: how many touches a won deal usually needs.
Calls logged outside Odoo never reach this report. Agree on one rule: if it is not marked done in Odoo, it did not happen.
How do you build an Odoo CRM dashboard?
You build an Odoo CRM dashboard by inserting pipeline, forecast or activity views into an Odoo spreadsheet, then publishing that spreadsheet in the Dashboards app. The data refreshes each time the dashboard is opened.
From any pivot, graph or list view, click Insert in Spreadsheet. Odoo's Dashboards documentation explains that data sources link the sheet to your database, and global filters such as date, team or salesperson filter the whole board at once.
A practical Odoo sales dashboard for a sales manager usually has six tiles:
- Prorated pipeline by stage for the current quarter.
- Expected revenue closing this month, by salesperson.
- Win/loss ratio by salesperson for the last 90 days.
- Lost revenue by lost reason.
- Completed activities by rep this week.
- Average days to close by sales team.
Two rules from Odoo's docs save a lot of rework. First, standard dashboards are reinstalled at each version upgrade, so duplicate one before you edit it. Second, users see only data their access rights allow, so a "own documents only" salesperson sees a misleading team board.
For thresholds and automated alerts on top of these boards, see our guide to Odoo dashboards and alerts.
How do you get an Odoo customer 360 view?
Odoo gives a customer 360 view on the contact form, where smart buttons pull related records from every installed app into one place. No extra module is needed for the basics.
The Odoo contacts documentation explains that smart buttons appear for each installed app. With CRM, Sales, Calendar and Invoicing, a customer shows Opportunities, Sales, Meetings and Invoiced totals.
| Smart button | App | What a sales rep learns |
|---|---|---|
| Opportunities | CRM | Open and past deals with this customer |
| Meetings | Calendar | Next scheduled meeting and history |
| Sales | Sales | Quotations and confirmed orders |
| Invoiced | Invoicing | Total invoiced amount |
| Subscriptions (on the lead) | Subscriptions, Odoo 20 | Active plans, upsells and renewals |
Odoo 20 adds a Subscriptions smart button on the lead itself when the customer already has subscriptions, as shown in our Odoo 20 CRM release notes. Upsell and renewal quotes made from there link back to the opportunity.
For account managers, a customer 360 dashboard adds what the form cannot, such as revenue by year and last activity date, using a customer global filter instead of custom code.
What changed for CRM reporting in Odoo 20?
Odoo 20 adds a team pipeline switcher that works across CRM reports, and several dashboard features that make shared sales boards easier to run. None of them changes how the core reports calculate.
- Pipeline switcher: the pipeline title is now a team dropdown, and it works in kanban, list, calendar, pivot, graph, map, cohort and forecast views.
- Favorite global filters: save dashboard filters as favorites and set a default one.
- Fiscal year date filter: report on your financial year, not the calendar year.
- Private dashboards: create a dashboard and share it with specific users only.
- Frozen share links: manage snapshot links from a dedicated menu in the Dashboards app.
Our Odoo 20 dashboards release notes show each change with screenshots. On Odoo 19, every report here works the same way; you filter by sales team instead.
What are the common Odoo CRM reporting mistakes?
Most wrong CRM numbers in Odoo come from five data and filter habits, and each one has a simple fix. Check these before you blame the report.
| Mistake | What goes wrong | Fix |
|---|---|---|
| Archiving instead of Mark Lost | Junk leads inflate losses | Always mark lost with a reason |
| Win/loss without archived records | Losses vanish from the ratio | Switch on Include archived |
| Blank expected closing dates | Deals sit outside the forecast | Make the field required by stage |
| Editing a standard dashboard | Changes lost at the next upgrade | Duplicate first, then edit |
| Fixed dates in spreadsheet filters | Weekly boards stop updating | Use relative date global filters |
The last one is a real forum case: a user found a weekly CRM dashboard stuck on one week after inserting a filtered pivot. An Odoo answer notes that contextual domains, added in version 17, keep the dynamic parts of a domain when inserted into a spreadsheet.
Odoo CRM reporting by industry
The reports are the same in every industry, but the measures that matter change with how you sell. This table shows where we usually start.
| Industry | Pain or cost driver | Odoo approach | How iVentureTeam helps |
|---|---|---|---|
| B2B manufacturing | Long quote cycles, slipping close dates | Exceeded Closing Days, forecast by quarter | Stage rules and a slip report |
| Distribution | Many small deals, many reps | Activity report by rep, win/loss by source | Rep scorecard dashboard |
| SaaS and subscriptions | Renewals mixed with new business | Expected MRR measures, Subscriptions button | Separate new and renewal pipelines |
| Professional services | Proposals that stall after a meeting | Activity type by stage | Activity plans and a stall report |
How iVentureTeam helps with Odoo CRM reporting

We set up Odoo CRM reporting around the questions your managers ask, then make sure the data behind it stays clean. We have delivered 150+ ERP projects across 35+ countries with 40+ Odoo specialists, led by a consultant with 13+ years in Odoo.
- Reporting audit: we check lost reasons, closing dates, probabilities and access rights before building anything.
- Saved reports: pipeline, forecast, win/loss and activity views saved as shared favorites for each team.
- Dashboards: sales manager, leadership and customer 360 boards built in Odoo spreadsheets with global filters.
- Custom reports: where standard views fall short, our Odoo customization services add SQL-backed reports or fields.
- Upgrade care: duplicated dashboards and tested reports when you move from Odoo 19 to 20.
Want a quick budget first? The Odoo project estimate tool gives a free range in a few minutes.
Odoo CRM reporting case study: Indep Consulting
A business selling cleaning chemicals, equipment and maintenance contracts needed management reports it could not get from disconnected tools. Sales, stock and accounting data sat in separate systems.
Questions like product margin or vendor spend were slow to answer, and maintenance contracts and customer claims had no tracking tied to commercial records. iVentureTeam rolled out Sales, CRM, Inventory, Stock and Accounting in Odoo as the core.
We then wrote eight SQL-based management reports, including invoice, order and sales-activity reports, plus product margin, vendor summary, stock rotation and a contract report. Claims and contracts are now tracked against the same records as sales and invoicing.
The company's Managing Partner said: "The reports we could never get out of Odoo are now one click away." Read the Indep Consulting Odoo SQL reporting case study.
The bottom line on Odoo CRM reporting
Odoo CRM reporting is strong enough for most sales teams without add-ons, as long as lost reasons, closing dates and probabilities are kept clean. The reports rarely lie; the data habits do.
Start with four saved views (pipeline, forecast, win/loss and activities) on one dashboard, reviewed weekly. Add custom reports only when filters and groupings cannot answer a real question.
Ready to trust your sales numbers in Odoo?

Get CRM reports and dashboards your managers will actually open. Ask us to set up your Odoo CRM reports and dashboards, call +91-90235-15208, or email business@iventureteam.com.
Frequently Asked Questions
Where are the CRM reports in Odoo?
+
Open the CRM app and click Reporting. You will find Forecast, Pipeline, Leads (when leads are enabled) and Activities. Each report can be switched between graph, pivot and list views and saved as a favorite.
How do I create a win/loss report in Odoo CRM?
+
In CRM > Reporting > Pipeline, add a custom filter on Won/Lost for both Won and Lost, switch on Include archived, then group by Stage, Won/Lost and Salesperson. Without archived records, lost deals drop out.
How is prorated revenue calculated in the Odoo forecast?
+
Prorated revenue is expected revenue multiplied by probability. A $10,000 deal at 30% probability adds $3,000 to its month in the forecast. Columns update as you drag deals between months.
Why are my lost opportunities missing from Odoo reports?
+
Marking an opportunity lost also archives it, and most report filters hide archived records. Turn on Include archived or add a filter that covers inactive records to see them again.
Can I build a CRM dashboard in Odoo without coding?
+
Yes. Insert any CRM pivot, graph or list view into an Odoo spreadsheet, add global filters, and publish it in the Dashboards app. The data refreshes each time the dashboard is opened.
Does Odoo have a customer 360 view?
+
Yes. Each contact form shows smart buttons from installed apps, such as Opportunities, Meetings, Sales and Invoiced. For trends across years, build a customer dashboard with a customer global filter.
What does the Odoo CRM activity report show?
+
It shows activities marked as done on leads and opportunities, with type, salesperson, team, stage and completion date. Scheduled activities that were never completed do not appear in it.
Is Odoo CRM reporting different in Odoo 20?
+
The core reports work the same. Odoo 20 adds a team pipeline switcher that works in report views, plus dashboard favorite filters, a fiscal year date filter and private dashboards.
Free Odoo implementation plan
Planning your Odoo implementation?
A senior consultant reviews your processes and sends a phased roadmap, what to set up first and a fixed-price range.
Free, with no obligation. A senior consultant replies within 12 business hours.
Free Odoo tools
All tools- Odoo Health CheckVersion, modules, findings and upgrade cost
- Odoo App SelectorWhich apps you need, by industry
- Odoo Project EstimateIndicative cost and timeline in minutes
- Odoo Implementation Cost CalculatorImplementation cost and timeline, in minutes
- Odoo Migration Cost CalculatorVersion jump or legacy ERP, priced in minutes
Continue reading
Odoo Lead to Invoice Workflow: CRM, Quote, Sales Order and Billing
Set up the Odoo lead to invoice workflow step by step: CRM leads, quotation templates, sales orders, invoicing policy, down payments and Odoo 20 changes.
Odoo Predictive Lead Scoring: How It Works, Setup and Limits
How Odoo predictive lead scoring computes win probability with naive Bayes, which variables it uses, setup steps, data needed, limits and Odoo 20 AI.
Odoo 20 Sales Commission: Plans, Setup, Calculation and Payout
Odoo 20 sales commission explained: commission plans, targets vs achievements, paid-invoice and manager commissions, calculation, payout and limits.
