Odoo Reports and Dashboards: Data-Driven Decision Making

The best ERP system is useless if you cannot extract insights from it. Odoo provides multiple reporting layers — from quick pivot tables to custom PDF reports to integrated spreadsheets — that turn your operational data into decisions.

Built-In Report Views

Graph Views

Every Odoo model with data includes graph view options: bar charts, line charts, and pie charts. Toggle between them to visualize sales by month, tickets by category, or expenses by department without writing a single query.

Pivot Tables

Pivot tables provide multi-dimensional analysis directly in the browser. Drag and drop dimensions (rows and columns) and measures (sums, counts, averages) to explore data from different angles. A sales pivot might show revenue by product category (rows) and month (columns) with average order value as the measure.

List Views with Grouping

Group any list view by one or more fields. Group sales orders by salesperson, then by stage, to see each representative pipeline at a glance. Inline totals show sums for numeric fields at each group level.

Custom Dashboards

Creating Dashboards

Odoo Enterprise includes a dashboard builder where you add widgets: graphs, KPI cards, pivot tables, and list snippets. Arrange them into a layout that gives managers a complete operational picture on one screen.

KPI Cards

Display single-metric cards with: the current value, comparison to the previous period (up/down indicators), and color coding based on targets (green for on-track, red for behind).

Department-Specific Dashboards

Build dashboards tailored to each department:

• Sales: Pipeline value, conversion rates, top deals, revenue forecast
• Support: Open tickets, SLA compliance, CSAT score, agent workload
• HR: Headcount, open positions, time-off calendar, training completion
• Finance: Cash position, overdue receivables, monthly P&L summary, budget utilization
• Operations: Order fulfillment rate, inventory turns, production efficiency, quality metrics

PDF Reports

Standard Reports

Odoo includes pre-built PDF reports for common documents: invoices, sales orders, purchase orders, delivery slips, balance sheets, profit and loss statements, and tax reports.

Customizing PDF Reports

Modify existing reports or create new ones using QWeb templates (Odoo templating engine). Customize: your company branding (logo, colors, fonts), report layout and content, calculated fields and summaries, conditional content based on data values, and multi-language support.

Batch Printing

Generate multiple reports at once: print all unpaid invoices, export all delivery slips for the day, or generate month-end financial statements in one batch.

Scheduled and Automated Reports

Email Subscriptions

Subscribe stakeholders to periodic reports. Configure: which report, which filters (e.g., "my team only"), delivery frequency (daily, weekly, monthly), and recipient list. Reports arrive in their inbox without manual effort.

Automated Alerts

Set up alerts when metrics cross thresholds: notify the sales manager when pipeline value drops below target, alert finance when overdue receivables exceed a limit, or flag inventory items below reorder point.

Spreadsheet Integration

Odoo Spreadsheet

Enterprise includes integrated spreadsheets that pull live data from Odoo. Create analysis workbooks with formulas referencing Odoo data — when the underlying data changes, the spreadsheet updates automatically.

Excel/Google Sheets Export

Export any view to spreadsheet format for ad-hoc analysis. For recurring needs, use the API to pull data into Google Sheets or Excel workbooks with automatic refresh.

Advanced Analytics

Analytic Accounting

Track costs and revenue by analytic accounts — projects, departments, cost centers, campaigns. Cross-reference financial data with operational data for true profitability analysis.

Custom SQL Reports

For advanced users, create reports using SQL queries through Odoo Studio or custom modules. Access any data in the database for specialized analysis not covered by standard views.

Best Practices

1. Start with questions, not dashboards — define what decisions you need data for
2. Keep dashboards focused — 5-7 KPIs per dashboard, not 20
3. Automate routine reports — stop spending time generating reports people expect regularly
4. Validate data quality — reports are only as good as the data behind them
5. Review and retire — remove reports nobody looks at to reduce clutter
6. Empower self-service — train managers to build their own pivot analyses

Our Odoo consultancy service designs reporting frameworks that drive better decisions.

Frequently Asked Questions

Can I create reports without technical knowledge?

Yes. Pivot tables, graph views, and dashboard widgets require no coding. PDF report customization and SQL reports require technical skills.

Can reports pull data from multiple modules?

Yes. Analytic accounting links data across modules. Custom reports can query any model relationship in the database.

Are reports real-time?

Dashboard and view-based reports reflect current data. Scheduled email reports capture data at the time of generation.

Can I share reports with external stakeholders?

PDF reports can be emailed or downloaded for sharing. For recurring external reporting, scheduled email delivery works well. The customer portal provides limited self-service reporting for clients.