Skip to main content
iVentureTeam
Odoo CRM & Sales

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.

Siddharth JambukiyaSiddharth JambukiyaOdoo Techno-Functional Consultant
November 20, 202612 min read2 views
Odoo CRM Reporting: Pipeline, Forecast and Dashboards in Odoo 19/20 cover

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: Which report answers which question?

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.

ReportWhere to find itQuestion it answersBest view
Pipeline AnalysisCRM > Reporting > PipelineHow many deals sit in each stage, and for whom?Graph, pivot, cohort
Leads AnalysisCRM > Reporting > LeadsWhere do leads come from, and how fast are they converted?Pivot, list
ForecastCRM > Reporting > ForecastWhat revenue is likely to close each month?Kanban by month
Activities AnalysisCRM > Reporting > ActivitiesWhich calls, emails and meetings did each rep complete?Pivot, graph
DashboardsDashboards appWhat does leadership need on one screen?Spreadsheet dashboard
Customer 360Contact form smart buttonsWhat 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:

  1. Go to CRM > Reporting > Pipeline and open the search panel.
  2. Enable both the Opportunities and Leads filters.
  3. Add a custom filter where Won/Lost is Won, add a rule for Lost, and switch on Include archived.
  4. Group by Stage, then add a custom group on Won/Lost, then group by Salesperson.
  5. Turn off the stacked toggle to see won and lost bars side by side.
  6. 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:

  1. Prorated pipeline by stage for the current quarter.
  2. Expected revenue closing this month, by salesperson.
  3. Win/loss ratio by salesperson for the last 90 days.
  4. Lost revenue by lost reason.
  5. Completed activities by rep this week.
  6. 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 buttonAppWhat a sales rep learns
OpportunitiesCRMOpen and past deals with this customer
MeetingsCalendarNext scheduled meeting and history
SalesSalesQuotations and confirmed orders
InvoicedInvoicingTotal invoiced amount
Subscriptions (on the lead)Subscriptions, Odoo 20Active 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.

MistakeWhat goes wrongFix
Archiving instead of Mark LostJunk leads inflate lossesAlways mark lost with a reason
Win/loss without archived recordsLosses vanish from the ratioSwitch on Include archived
Blank expected closing datesDeals sit outside the forecastMake the field required by stage
Editing a standard dashboardChanges lost at the next upgradeDuplicate first, then edit
Fixed dates in spreadsheet filtersWeekly boards stop updatingUse 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.

IndustryPain or cost driverOdoo approachHow iVentureTeam helps
B2B manufacturingLong quote cycles, slipping close datesExceeded Closing Days, forecast by quarterStage rules and a slip report
DistributionMany small deals, many repsActivity report by rep, win/loss by sourceRep scorecard dashboard
SaaS and subscriptionsRenewals mixed with new businessExpected MRR measures, Subscriptions buttonSeparate new and renewal pipelines
Professional servicesProposals that stall after a meetingActivity type by stageActivity plans and a stall report

How iVentureTeam helps with Odoo CRM reporting

Planning CRM reports? Price the project first

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?

Book a CRM reporting review

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.

We use cookies to improve your experience

Essential cookies make the site work, and we use analytics to improve it. Choose “Only necessary” to turn analytics off. See our cookie policy.