HomeModulesPoint of SalePOS Analytics Dashboard | Sales by Hour, Cashier, Category | POS KPIs & Targets
POS Analytics Dashboard | Sales by Hour, Cashier, Category | POS KPIs & Targets
Point of SaleAuraOdoo Verified

POS Analytics Dashboard | Sales by Hour, Cashier, Category | POS KPIs & Targets

Live Point of Sale manager dashboard: sales by hour, by cashier and by category,

Technical Specifications & Compatibility

Technical Module Name
Supported Odoo Versions
v19.0
License
Odoo
Deployment Support
Odoo OnlineOdoo.shOn Premise
Lines of Code
2012 lines (Python / XML / JS)

Overview & Description

Odoo 19.0 Odoo 20 Community & Enterprise OPL-1 License POS Analytics Dashboard Live Point of Sale manager intelligence dashboard: Sales by hour, cashier performance, category breakdowns, top and slow-moving products, margin analysis, session KPIs, sales targets, and multi-sheet XLSX export. Real-Time POS Intelligence: Zero configuration needed. Install and immediately gain actionable operational insights for your retail and restaurant operations. Transform POS Data Into Strategic Revenue Decisions Replace flat pivot tables with a single-screen command center that answers when you sell, who sells, what sells, and whether your stores are on target. 9 Headline KPIs Track total revenue, orders, basket size, margin, discounts, refunds, customer identification, and peak sales hours. 5 Interactive Visualizations Hourly sales by local timezone, daily trend lines, cashier revenue rankings, category mix, and payment method split. Target Tracking & Export Set shop sales goals, monitor real-time target gauges, and export comprehensive 11-sheet Excel reports in one click. Module Overview Designed specifically for shop managers, floor supervisors, and retail executives. Standard Odoo ships with basic order lists and generic pivot reporting. Neither tells you that 14:00 is your daily peak hour, that a specific cashier's average basket is 40% lower than peers, or that your store is at 42% of its monthly revenue goal. The POS Analytics Dashboard unifies point of sale metrics into a clear, single-screen dashboard. It reads directly from Odoo POS reporting models, preserving multi-company security and user access rights while delivering instant analytics without slowing down transaction processing. Odoo Version 19.0 Dependency point_of_sale Setup Time Instant Export Format XLSX (11 Sheets) Key Features Comprehensive analytics built on modern OWL framework architecture. Headline KPIs & Deltas Nine primary tiles comparing current performance against the immediately preceding period of equal length: • Total Sales & Order Counts • Average Basket Value • Items Per Order • Gross Margin & Margin % • Discounts & Refunds Tracked • Identified Customer Share Timezone-Aware Charts Visual analytics tailored for high-volume store environments: • Hourly Sales (Local Timezone) • Daily Sales Trend Line • Cashier Revenue Rankings • Product Category Distribution • Payment Method Breakdown Table Twin Views Full accessibility compliance with one-click chart-to-table toggling: • Every chart has an exact tabular view • Top 10 Best Selling Products • Bottom 10 Slow Moving Items • Session List with Cash Differences • Clickable rows to open POS sessions Sales Target Management Set and monitor shop objectives directly inside the dashboard: • Shop-specific or multi-store targets • Daily, weekly, monthly, yearly targets • Revenue and order volume goals • Visual progress meters on dashboard • Achievement rate status filters Unified Global Filter Single filter bar ensuring consistent metrics across all dashboard views: • Presets: Today, Yesterday, Last 7 Days • Presets: Last 30 Days, Month, Year • Custom date range picker • Multi-select Point of Sale filter • Smooth state preservation on refresh Professional XLSX Export Server-computed Excel export with formatted numbers and separate sheets: • 11 organized worksheets • Summary comparing current vs previous • Proper currency and percentage formats • Frozen headers and styled tables • Recomputed server-side for integrity Business Benefits Measurable operational value for retail store management. Optimize Staffing & Shifts Identify hourly transaction surges bucketed in your exact local timezone. Align staff shifts and cashier coverage to peak rush hours, eliminating long checkout queues and reducing labor costs during lulls. Control Discounts & Cash Differences Track refund volumes, discount percentages, and session cash imbalances. Highlight high cash differences instantly to detect drawer discrepancies and prevent inventory shrinkage. Improve Inventory Velocity Compare top 10 best sellers against slow-moving items with real margin percentages. Make data-driven restocking decisions and clear slow-moving inventory before it turns into dead stock. Motivate Sales Teams Empower store managers with real-time target progress gauges. Compare actual revenue against sales goals daily and reward top-performing cashiers based on verified order metrics. Screenshots & Interface Clean, responsive layout designed for desktop and tablet screens. Main Analytics Dashboard Overview Live POS Analytics Dashboard displaying headline KPIs, hourly sales column chart, daily trend line, cashier rankings, product category mix, and sales target gauges. Module Banner & Branding Module overview banner showcasing core analytical widgets. Target Tracking Interface Target Management View Configure target periods, target amounts, and assigned retail stores. Status badges automatically highlight achieved versus missed targets. Target meters integrate seamlessly into the primary dashboard view for instant supervisor feedback. Workflow Simple 4-step operational routine for shop management. Step 1 Access Dashboard Navigate to Point of Sale > Reporting > Analytics Dashboard in your Odoo navigation menu. Step 2 Filter Store & Date Select date range presets or custom dates, and filter by specific POS registers or all shops. Step 3 Analyze Metrics Review sales trends, click cashier bars to open orders, check slow movers, and monitor target progress. Step 4 Export Excel Report Click Export to generate an 11-sheet XLSX report for executive review and financial auditing. Configuration Out-of-the-box functionality with zero initial setup required. Dashboard Configuration No setup required! The dashboard automatically reads data from active POS sessions and posted orders immediately after module installation. Default access: All Point of Sale users can view the Analytics Dashboard. Sales Target Setup (Optional) Go to Point of Sale > Reporting > Sales Targets. Click Create and select target period type (Day, Week, Month, Quarter, Year). Enter target revenue amount and optional order volume goal. Assign target to a specific POS shop or leave blank for company-wide target. Technical Details Built strictly following Odoo 19 developer guidelines and security standards. Technical Name pos_analytics_aura Odoo Version 19.0 License OPL-1 Dependencies point_of_sale (No third-party Python dependencies required) Frontend Framework OWL 2 Component Framework + Chart.js (Loaded via Odoo backend lazy assets) Database Safety Read-only aggregated queries using _read_group. Computes zero database writes. Security Models Multi-company rules, record rules, and access control lists (ACL) strictly enforced. Automated Test Suite 22 automated unit tests including full Chrome browser tour and end-to-end XLSX verification. Compatibility Tested and validated across standard Odoo environments. Odoo 19.0 Fully optimized and native for Odoo version 19.0 web client and backend views. Modern Browsers Compatible with Google Chrome, Mozilla Firefox, Apple Safari, and Microsoft Edge. Dark & Light Mode Includes full dark mode assets via Odoo's web.assets_web_dark bundle. Supported Editions Works seamlessly across all deployment types. Odoo Community Edition 100% compatible with Odoo 19 Community Edition without requiring any enterprise modules. Supported Odoo Enterprise Edition Fully compatible with Odoo 19 Enterprise Edition, Odoo.sh, and cloud hosting. Supported Installation Guide Follow standard Odoo module installation steps. Extract Module Folder Download the zip file and extract the pos_analytics_aura folder into your custom Odoo addons path. Update Apps List Activate Developer Mode in Odoo Settings, navigate to the Apps menu, and click Update Apps List. Install POS Analytics Dashboard Search for pos_analytics_aura or POS Analytics Dashboard in Apps and click Install. Launch Dashboard Open Point of Sale > Reporting > Analytics Dashboard to start viewing real-time POS insights. Frequently Asked Questions Answers to common operational and technical questions. No. The dashboard operates on read-only reporting aggregations. Cashiers can continue scanning items and processing transactions in the POS interface without any delay or impact. Sales hours are bucketed in the user's specific local timezone using database timezone conversion. This ensures that 14:00 on the dashboard reflects the exact 2:00 PM local time of the shop. Yes! Clicking the Export button generates a comprehensive XLSX file containing 11 separate worksheets covering summary KPIs, hourly sales, daily trends, cashier performance, category breakdowns, payment mix, best sellers, slow movers, sessions, and sales targets. No. To ensure financial accuracy, only orders in paid or posted states are calculated. Draft carts and cancelled orders are automatically excluded. Changelog Release history and updates. Version 19.0.1.0.0 Initial Release Initial production release of POS Analytics Dashboard for Odoo 19.0. Implemented 9 headline KPI cards with period-over-period comparison deltas. Added 5 interactive Chart.js visualizations (Hourly, Daily, Cashier, Category, Payment Mix). Created Table Twin views for accessibility and quick data inspection. Integrated Sales Target management with dynamic meter gauges. Added 11-sheet XLSX export functionality. Need Support or Customization? Our team of Odoo experts is available to help you with installation, configuration, or custom dashboard widgets tailored to your business needs. Aura Odoo Tech Professional Odoo Development & Consulting Services Visit Our Website © 2021-2026 Aura Odoo Tech. All Rights Reserved. POS Analytics Dashboard for Odoo 19.0 — Released under OPL-1 License.

Key Capabilities & Features

  • Total Sales & Order Counts
  • Average Basket Value
  • Items Per Order
  • Gross Margin & Margin %
  • Discounts & Refunds Tracked
  • Identified Customer Share
  • Hourly Sales (Local Timezone)
  • Daily Sales Trend Line
  • Cashier Revenue Rankings
  • Product Category Distribution
  • Payment Method Breakdown
  • Every chart has an exact tabular view
  • Top 10 Best Selling Products
  • Bottom 10 Slow Moving Items
  • Session List with Cash Differences
  • Clickable rows to open POS sessions
  • Shop-specific or multi-store targets
  • Daily, weekly, monthly, yearly targets
  • Revenue and order volume goals
  • Visual progress meters on dashboard
  • Achievement rate status filters
  • Presets: Today, Yesterday, Last 7 Days
  • Presets: Last 30 Days, Month, Year
  • Custom date range picker
  • Multi-select Point of Sale filter
  • Smooth state preservation on refresh
  • 11 organized worksheets
  • Summary comparing current vs previous
  • Proper currency and percentage formats
  • Frozen headers and styled tables
  • Recomputed server-side for integrity
  • Go to Point of Sale > Reporting > Sales Targets.
  • Click Create and select target period type (Day, Week, Month, Quarter, Year).
  • Enter target revenue amount and optional order volume goal.
  • Assign target to a specific POS shop or leave blank for company-wide target.
  • Extract Module Folder Download the zip file and extract the pos_analytics_aura folder into your custom Odoo addons path.
  • Update Apps List Activate Developer Mode in Odoo Settings, navigate to the Apps menu, and click Update Apps List.
  • Install POS Analytics Dashboard Search for pos_analytics_aura or POS Analytics Dashboard in Apps and click Install.
  • Launch Dashboard Open Point of Sale > Reporting > Analytics Dashboard to start viewing real-time POS insights.
  • Initial production release of POS Analytics Dashboard for Odoo 19.0.
  • Implemented 9 headline KPI cards with period-over-period comparison deltas.
  • Added 5 interactive Chart.js visualizations (Hourly, Daily, Cashier, Category, Payment Mix).
  • Created Table Twin views for accessibility and quick data inspection.
  • Integrated Sales Target management with dynamic meter gauges.
  • Added 11-sheet XLSX export functionality.
  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.

Screenshots & Previews

3 images available
POS Analytics Dashboard | Sales by Hour, Cashier, Category | POS KPIs & Targets screenshot 1
Expand Preview
POS Analytics Dashboard | Sales by Hour, Cashier, Category | POS KPIs & Targets screenshot 2
Expand Preview
POS Analytics Dashboard | Sales by Hour, Cashier, Category | POS KPIs & Targets screenshot 3
Expand Preview
The AuraOdoo Quality Guarantee
100% Tested

Verified with Odoo 17, 18, and 19 test pipelines for stability and no conflicts.

Clean Architecture

Built according to official Odoo guidelines and PEP 8 standards with zero bloat.

Dedicated Support

Free installation assistance and quick bug turnaround from our team.