Odoo Dashboards and Alerts: KPI Boards, Automation Rules, Thresholds

Most companies switch on Odoo and still run their weekly numbers in Excel. The data is in Odoo; what is missing is a board per role and alerts that fire before a problem gets expensive. Our Odoo customization services build both on standard Odoo tools.

This guide is for owners, finance leads and operations managers on Odoo 19 or Odoo 20. If your team still exports to spreadsheets, read our post on why Odoo users keep Excel after go-live first.

What are Odoo dashboards and alerts?

Odoo dashboards and alerts are four separate tools that work together: spreadsheet dashboards, automation rules, digest emails and activities. Each one answers a different question, so pick the tool by the job.

Odoo's Dashboards documentation says data refreshes each time a dashboard is opened. So a dashboard is a view, not an alert: nobody is told unless they look.

Which Odoo dashboards come standard in Odoo 19 and 20?

Odoo installs a standard dashboard for most apps you install, such as Sales, Invoicing, CRM leads, Timesheets and warehouse operations. They are a good start, but they show company-wide numbers, not a role's daily to-do list.

Each standard dashboard has global filters, such as period or salesperson. Click a value or chart point to open the underlying records.

The key rule from Odoo's docs: standard dashboards are reinstalled at each version upgrade, so changes to the original are lost. Always duplicate a standard dashboard and customize the copy.

How do you build an Odoo KPI dashboard?

You build an Odoo KPI dashboard by inserting prepared Odoo lists, pivots and charts into a spreadsheet, adding formulas and filters, then converting it into a dashboard. The thinking before you insert data matters more than the charts.

1. Write the questions first: for example, "Are we collecting cash faster than last quarter?" Each question becomes one KPI.
2. Prepare the view: in Invoicing, filter posted customer invoices, group by month and pick the measures you need.
3. Insert it: use "Insert in spreadsheet" from the pivot or list view; the data stays linked to Odoo.
4. Add the math: margin %, days sales outstanding or win rate as formulas over the inserted pivots.
5. Add global filters: date, company, team and salesperson, so one board serves many users.
6. Format for action: put the 4 to 6 headline KPIs on the first sheet, and use conditional formatting to turn a cell red past its threshold.
7. Convert and share: convert the spreadsheet into a dashboard, place it in a section and set the user groups that may see it.

Building needs Dashboards admin and Documents user rights, and editing spreadsheets needs the Enterprise apps.

What changed for Odoo 20 dashboards and spreadsheets?

Odoo 20 brings seven Dashboards changes and 30 Spreadsheet changes, and most of them make dashboards easier to share safely and read on a phone. Our Odoo 20 Dashboards release notes show each one with a screenshot.

Our Odoo 20 Spreadsheet release notes add conditional formatting by date and a top or bottom ranking rule, so "overdue" cells turn red without a formula. Odoo 19 dashboards keep working after the upgrade.

How do Odoo automation rules alerts work?

An Odoo automation rule watches a model, waits for a trigger, checks your conditions and then runs one or more actions, such as creating an activity or sending an email. This is how a number on a dashboard becomes a task for a person. Older Odoo versions called them automated actions.

Odoo's automation rules documentation lists five trigger groups: values updated, email events, timing conditions, custom and external webhooks. Actions include Create Activity, Send Email, Send SMS, Send WhatsApp and Execute Code.

For alerts, the timing triggers matter most. "Based on date field" fires a set time before or after a date, such as 15 days after an invoice due date. "After last update" catches records nobody has touched.

Timing rules run through a scheduled action that checks every 4 hours by default. If any rule has a delay shorter than 40 hours, Odoo runs it more often, for example every 18 minutes. Plan same-day alerts with that in mind.

Two warnings from the docs. Run the scheduled action manually once for a new timing rule, or it may fire on old records. For "On create and edit" rules, fill "When updating", or the action may repeat. Our Odoo automation rules guide walks through the setup screens.

Role-by-role starter alerts with real thresholds

Start with one or two alerts per role, each with a number, an owner and an action, and review them after 30 days. The thresholds below are our starting points from projects, not Odoo defaults; tune them to your payment terms and cycle times.

Low stock is the most asked alert on the Odoo forum. One user wanted "an automatic (live) notification" when products drop below a level. Often a reordering rule that creates the RFQ itself beats an email. See our guide to MRP shortage alerts and safety stock.

Dashboards vs automation rules vs digest emails: which should you use?

Use a dashboard to review trends, an automation rule to make someone act on one record, and a digest email to keep managers informed without logging in. Most teams need all three, aimed at different people.

The digest emails documentation lists ready KPIs such as New Leads, Opportunities Won, Open Tasks, Tickets Closed and All Sales. Custom KPIs need Studio, which comes with the Custom plan at US$61.00 per user a month billed yearly in the US, per Odoo pricing.

Who can see what on an Odoo dashboard?

Dashboard access is set by user group, but the data inside follows each user's own access rights and record rules. So a user can open a dashboard and still see only part of the numbers.

Odoo's docs give the example of the `Sales / User: Own Documents Only` group: those users can open the Sales dashboard but see only their own sales, which makes team totals misleading. Grant dashboards to groups whose rights match the data.

For manager views, one forum user built a dashboard filter on the current user and their team with a relation filter and default values.

• Restrict by group: Configuration, Dashboards, then the Group column on each board.
• Restrict by company: set companies in a multi-company database, or leave blank for all.
• Restrict by person: in Odoo 20, use Allowed Users for board or HR dashboards.
• Share outside: use a frozen snapshot link, then revoke it in Odoo 20's Share links menu.

Common mistakes with Odoo dashboards and alerts

Most failed dashboard projects fail on scope and ownership, not on Odoo features. These are the mistakes we fix most often.

• Editing the standard board: the changes vanish at the next upgrade. Duplicate first.
• Too many KPIs: 25 charts on one sheet means nobody reads any. Keep 4 to 6 headline numbers per role.
• Alerts with no owner: an email to a shared inbox gets ignored. Assign an activity to a named user field.
• Alert fatigue: a threshold that fires 50 times a day is noise. Raise it until each alert needs action.
• Skipping the manual first run: a new timing rule can hit old records. Run the scheduled action once.
• Copied databases: a duplicate database with sending enabled keeps sending digest emails until you turn them off.

Odoo dashboards and alerts by industry

The right KPIs and thresholds depend on what costs your industry money when it slips. The table shows where we usually start.

For a wider view of which processes to automate first, see our Odoo 20 use cases by department. To price a dashboard and alerts project, try the Odoo project estimate tool.

How iVentureTeam helps with Odoo dashboards and alerts

We turn your management questions into role-based Odoo dashboards and a short list of alerts that people actually act on. We have delivered 150+ ERP projects across 35+ countries with 40+ Odoo specialists over 13+ years.

• KPI workshop: we agree the 4 to 6 numbers per role and the threshold for each.
• Dashboard build: duplicated standard boards plus custom spreadsheet dashboards with filters per role.
• Alert setup: automation rules with conditions, owners and a tested first run, through our Odoo consulting services.
• Custom dashboards: where Spreadsheet is not enough, a custom module for special charts or older versions.
• Review after 30 days: we cut noisy alerts and adjust thresholds with real data.

Odoo dashboards case study: MechSoft

A Turkish IT services firm moved its KPI tracking from spreadsheets into Odoo with a custom dashboard module on Odoo 11. MechSoft needed live management dashboards without a disruptive version upgrade.

Reporting meant exporting data and rebuilding charts by hand, and KPI tracking against targets lived in spreadsheets.

We built a Highcharts dashboard module with eight chart and item types, KPI cards comparing two queries against targets and the previous period, date and user-scoped filters, multi-company support and export to PNG, PDF, Excel or CSV. Delivery took 8 weeks.

Managers now watch auto-refreshing KPIs against targets inside Odoo, on any device. Read the MechSoft Odoo dashboard customization case study.

The bottom line on Odoo dashboards and alerts

Build a few role-based dashboards for review, then add automation rules so that every threshold has an owner and an action. Dashboards without alerts get ignored; alerts without dashboards lack context.

Duplicate the standard boards per role, add two alerts per role with written thresholds, and review after 30 days.

Ready to put your KPIs and alerts inside Odoo?

Get a dashboard and alert plan built for your roles and your numbers. Plan your Odoo KPI dashboards with us, call +91-90235-15208, or email business@iventureteam.com.