Daily Sales Report in Odoo 18 POS
By Braincuber Team
Published on January 6, 2026
Retail managers close their store at 9 PM and spend the next hour manually counting cash drawers, cross-referencing receipts, calculating total sales by payment method, identifying which products sold best, and preparing the daily summary for headquarters. By the time they finish, it's 10 PM—and they still discover discrepancies the next morning when comparing register totals to actual deposits. This nightly routine wastes time, creates errors, and provides outdated information that can't drive real-time business decisions.
Odoo 18 Point of Sale provides a built-in Daily Sales Report that automatically captures every transaction, payment, product, and session detail throughout the day. Access the report from POS backend, view sales totals by session, payment method breakdown, product performance, cashier statistics, and discount usage—all updated in real-time. Filter by date range, compare periods, export to Excel or PDF, and make data-driven decisions before the day even ends. No more manual calculations, no more discrepancies, no more late nights reconciling registers.
Core Benefit: Every POS transaction automatically feeds into the Daily Sales Report → real-time visibility into sales performance, payment mix, product trends, and cashier productivity → close sessions confidently knowing all data is accurate and ready for analysis.
Understanding the Daily Sales Report
Real-Time Sales Tracking
Every transaction is recorded instantly as it happens. View current day's sales total, compare to yesterday, track hourly patterns, and monitor performance throughout the day—no waiting for end-of-day reports.
Payment Method Analysis
Break down sales by payment type: cash, credit card, debit card, mobile payments, gift cards. Identify customer payment preferences and reconcile each payment method against actual deposits.
Product Performance
See which products sold best today, track quantities, revenue per product, and identify slow movers. Spot trends, adjust inventory, and plan promotions based on actual daily performance data.
Cashier Statistics
Track individual cashier performance: transactions processed, sales volume, average ticket size, discount usage. Identify top performers and coaching opportunities for staff development.
Accessing the Daily Sales Report
The Daily Sales Report is accessed from the POS backend, providing comprehensive analytics for all your point of sale operations.
Navigate to POS Reports
From the Odoo main menu:
- Go to Point of Sale → Reporting → Orders
- Or access Point of Sale → Reporting → Sales Details
- Dashboard displays key metrics with graphical representations
- Use filters to focus on specific dates, sessions, or payment methods
Select Date Range
Filter reports by time period:
- Today: Current day's transactions only
- This Week: Monday through current day
- This Month: First of month through today
- Custom Range: Select specific start and end dates
- Compare periods using the comparison toggle
View Report Sections
Key report components:
- Summary: Total sales, order count, average ticket
- Payment Methods: Breakdown by cash, card, other
- Products: Top sellers, quantities, revenue
- Sessions: Performance by POS session
- Staff: Sales by cashier/employee
Report Components Deep Dive
Daily Sales Summary:
DAILY SALES REPORT - RIVERSIDE ELECTRONICS Date: January 6, 2026 POS Session: Main Store - Register 1, Register 2 ═══════════════════════════════════════════════════════════ SALES SUMMARY ─────────────────────────────────────────────────────────── Total Revenue: $12,847.50 Total Orders: 156 Average Order Value: $82.36 Items Sold: 423 Comparison to Previous Day: Revenue Change: +$1,245.00 (+10.7%) Order Count Change: +12 orders (+8.3%) Average Ticket Change: +$2.15 (+2.7%) HOURLY BREAKDOWN ─────────────────────────────────────────────────────────── 09:00 - 10:00 | $845.00 | 11 orders | ***** 10:00 - 11:00 | $1,125.50 | 14 orders | ****** 11:00 - 12:00 | $1,567.25 | 19 orders | ******** 12:00 - 13:00 | $2,234.00 | 28 orders | ************ (Peak) 13:00 - 14:00 | $1,890.75 | 23 orders | ********** 14:00 - 15:00 | $1,245.00 | 15 orders | ******* 15:00 - 16:00 | $987.50 | 12 orders | ***** 16:00 - 17:00 | $1,456.25 | 18 orders | ******** 17:00 - 18:00 | $1,496.25 | 16 orders | ******** Peak Hour: 12:00 - 13:00 (Lunch Rush) Slowest Hour: 09:00 - 10:00 (Opening)
Payment Method Breakdown:
PAYMENT METHOD BREAKDOWN - January 6, 2026 ═══════════════════════════════════════════════════════════ Method | Amount | Orders | % of Total ───────────────────────────────────────────────────────── Credit Card | $6,423.75 | 78 | 50.0% Debit Card | $3,211.88 | 42 | 25.0% Cash | $2,247.31 | 28 | 17.5% Mobile Payment | $642.38 | 5 | 5.0% Gift Card | $321.18 | 3 | 2.5% ───────────────────────────────────────────────────────── TOTAL | $12,847.50 | 156 | 100.0% CASH RECONCILIATION ─────────────────────────────────────────────────────────── Opening Cash: $200.00 Cash Sales: $2,247.31 Cash Returns: -$45.00 Expected Drawer: $2,402.31 Actual Drawer Count: $2,402.31 Variance: $0.00 ✓ Balanced CARD PROCESSING SUMMARY ─────────────────────────────────────────────────────────── Visa: $4,856.25 (62 transactions) Mastercard: $2,890.50 (38 transactions) American Express: $1,245.88 (16 transactions) Discover: $643.00 (4 transactions)
Product Sales Performance:
TOP SELLING PRODUCTS - January 6, 2026 ═══════════════════════════════════════════════════════════ Rank | Product | Qty | Revenue | Margin ───────────────────────────────────────────────────────────── 1 | USB-C Fast Charger | 45 | $1,125.00 | 42% 2 | Wireless Earbuds Pro | 28 | $2,799.72 | 38% 3 | Phone Screen Protector | 67 | $670.00 | 65% 4 | Laptop Stand Adjustable | 23 | $1,149.77 | 35% 5 | Bluetooth Speaker | 19 | $1,140.00 | 40% 6 | HDMI Cable 6ft | 38 | $569.62 | 55% 7 | Wireless Mouse | 31 | $929.69 | 45% 8 | USB Hub 7-Port | 15 | $599.85 | 38% 9 | Webcam HD 1080p | 12 | $839.88 | 35% 10 | Power Bank 20000mAh | 18 | $719.82 | 32% PRODUCT CATEGORY SUMMARY ─────────────────────────────────────────────────────────── Category | Revenue | % of Sales | Qty Accessories | $4,567.89 | 35.5% | 178 Audio | $3,939.72 | 30.7% | 47 Cables & Adapters | $1,694.62 | 13.2% | 85 Computer Peripherals | $1,529.54 | 11.9% | 46 Power Solutions | $1,115.73 | 8.7% | 67 LOW PERFORMERS (Consider Promotion) ─────────────────────────────────────────────────────────── Product | Qty Sold | Revenue | Days in Stock Phone Ring Holder | 2 | $15.98 | 45 USB-A to Micro Cable | 3 | $14.97 | 38 SD Card Reader | 1 | $12.99 | 52
Session Details:
POS SESSION DETAILS - January 6, 2026 ═══════════════════════════════════════════════════════════ SESSION 1: Main Store - Register 1 ─────────────────────────────────────────────────────────── Opened By: Sarah Johnson Open Time: 08:55 AM Close Time: 05:15 PM Duration: 8 hours 20 minutes Status: Closed & Validated Session Totals: Total Sales: $7,234.25 Order Count: 89 Average Ticket: $81.28 Items Sold: 245 Payment Summary: Cash: $1,247.31 (17.2%) Card: $5,486.94 (75.8%) Other: $500.00 (7.0%) Cash Control: Opening Balance: $200.00 Closing Balance: $1,447.31 Expected: $1,447.31 Difference: $0.00 ✓ ─────────────────────────────────────────────────────────── SESSION 2: Main Store - Register 2 ─────────────────────────────────────────────────────────── Opened By: Michael Chen Open Time: 09:00 AM Close Time: 06:00 PM Duration: 9 hours Status: Closed & Validated Session Totals: Total Sales: $5,613.25 Order Count: 67 Average Ticket: $83.78 Items Sold: 178 Payment Summary: Cash: $1,000.00 (17.8%) Card: $4,148.69 (73.9%) Other: $464.56 (8.3%) Cash Control: Opening Balance: $200.00 Closing Balance: $1,200.00 Expected: $1,200.00 Difference: $0.00 ✓
Cashier Performance:
CASHIER PERFORMANCE - January 6, 2026 ═══════════════════════════════════════════════════════════ Cashier | Orders | Revenue | Avg Ticket | Items/Order ───────────────────────────────────────────────────────────────────── Sarah Johnson | 89 | $7,234.25 | $81.28 | 2.75 Michael Chen | 67 | $5,613.25 | $83.78 | 2.66 ───────────────────────────────────────────────────────────────────── TOTAL | 156 | $12,847.50 | $82.36 | 2.71 DETAILED METRICS ─────────────────────────────────────────────────────────── Sarah Johnson: Hours Worked: 8.33 Orders per Hour: 10.7 Revenue per Hour: $868.47 Discount Given: $145.50 (2.0% of sales) Returns Processed: 2 ($45.00) Michael Chen: Hours Worked: 9.00 Orders per Hour: 7.4 Revenue per Hour: $623.69 Discount Given: $89.25 (1.6% of sales) Returns Processed: 1 ($22.00) PERFORMANCE RANKINGS ─────────────────────────────────────────────────────────── Highest Revenue: Sarah Johnson ($7,234.25) Most Orders: Sarah Johnson (89) Best Avg Ticket: Michael Chen ($83.78) Lowest Discount Rate: Michael Chen (1.6%) Most Items/Order: Sarah Johnson (2.75)
Filtering and Analyzing Data
Date Filters
Narrow down reports by time:
- Specific Date: View single day performance
- Date Range: Compare week-over-week or month-over-month
- Custom Period: Analyze promotional periods or seasons
- Use comparison mode to see growth/decline trends
Group By Options
Organize data for insights:
- By Product: See individual product performance
- By Category: Compare department sales
- By Salesperson: Track staff productivity
- By Session: Analyze register performance
- By Payment Method: Understand customer preferences
Export Options
Share and archive reports:
- PDF Export: Generate printable daily summary for archives
- Excel Export: Download data for further analysis
- Print: Physical copies for store records
- Schedule automatic report emails to management
Using Reports for Business Decisions
INSIGHTS FROM DAILY SALES REPORT - January 6, 2026 ═══════════════════════════════════════════════════════════ 1. STAFFING OPTIMIZATION ─────────────────────────────────────────────────────────── Finding: Peak hour 12:00-1:00 PM had 28 orders vs 11 at opening Action: Schedule additional cashier during lunch rush Impact: Reduce customer wait times, increase throughput 2. INVENTORY DECISIONS ─────────────────────────────────────────────────────────── Finding: USB-C Fast Chargers sold 45 units (best seller) Action: Reorder trigger—current stock may deplete in 3 days Impact: Prevent stockouts of high-demand items 3. PROMOTION OPPORTUNITIES ─────────────────────────────────────────────────────────── Finding: Phone Ring Holders sold only 2 units in 45 days Action: Create bundle with phone cases or discount clearance Impact: Move slow inventory, recover capital 4. PAYMENT PROCESSING REVIEW ─────────────────────────────────────────────────────────── Finding: 50% of sales on credit card, only 5% mobile payment Action: Promote mobile payment with loyalty points Impact: Lower transaction fees, faster checkout 5. CASH HANDLING VERIFICATION ─────────────────────────────────────────────────────────── Finding: Both registers balanced perfectly ($0 variance) Action: Maintain current cash handling procedures Impact: Continued cash control, loss prevention 6. STAFF PERFORMANCE COACHING ─────────────────────────────────────────────────────────── Finding: Sarah's avg ticket $81.28 vs store avg $82.36 Action: Train on upselling complimentary accessories Impact: Increase average ticket by 5-10% 7. PEAK PREPARATION ─────────────────────────────────────────────────────────── Finding: 17:00-18:00 shows secondary peak (after-work rush) Action: Ensure both registers staffed through 6 PM Impact: Capture end-of-day sales, reduce closing delays
Configuring Report Settings
Enable Cash Control
For accurate cash reconciliation:
- Go to Point of Sale → Configuration → Settings
- Enable Cash Control under POS Interface
- Set Opening & Closing Cash Count required
- Reports will show cash variance for each session
Configure Payment Methods
For detailed payment tracking:
- Navigate to Point of Sale → Configuration → Payment Methods
- Create separate methods for each payment type (Visa, Mastercard, etc.)
- Link to appropriate journal accounts
- Reports will break down by individual payment method
Set Up Product Categories
For category-level analysis:
- Organize products into logical categories (Electronics, Accessories)
- Use POS product categories for retail-specific grouping
- Reports can filter and group by category
- Enables department-level sales comparison
Best Practices
✅ Follow These Guidelines:
- Review reports daily: Make checking the daily sales report part of your closing routine—catch issues same day instead of next week
- Investigate variances immediately: Any cash drawer discrepancy should be investigated before staff leaves—paper trail is critical
- Compare to benchmarks: Track average tickets, orders per hour, and category mix against historical data to spot trends
- Use hourly data for scheduling: Staff to your actual sales patterns, not assumptions—let data drive labor decisions
- Monitor discount usage: Excessive discounting erodes margin—track by employee and investigate outliers
- Archive daily reports: Export and save reports monthly for year-over-year comparison and audit purposes
- Share with team: Post daily results where staff can see them—transparency drives performance
- Act on slow movers: Products with low sales velocity tie up capital—use reports to identify and address
Common Issues and Solutions
🚨 Issue #1: Report Shows $0 Sales
No data appearing in daily report despite processing transactions. Solution: Ensure POS session was properly closed and validated. Draft sessions don't appear in reports until closed.
🚨 Issue #2: Cash Variance Showing
Report shows difference between expected and actual cash. Solution: Recount physical cash, check for returns processed after initial count, verify no refunds were issued from wrong payment method.
🚨 Issue #3: Missing Product in Report
Sold product not appearing in product sales breakdown. Solution: Verify product is marked as "Available in POS" and has correct POS category assigned. Miscellaneous sales may not map to products.
🚨 Issue #4: Payment Totals Don't Match
Card payment total in report differs from processor statement. Solution: Check for returns, partial refunds, or transactions processed outside POS (phone orders). Reconcile transaction-by-transaction if needed.
Conclusion
The Daily Sales Report in Odoo 18 Point of Sale transforms end-of-day reconciliation from a manual chore into an automated, instant process. Real-time access to sales totals, payment breakdowns, product performance, session details, and cashier statistics enables data-driven decisions throughout the day—not just after closing. Filter by date ranges, compare periods, export to Excel or PDF, and identify actionable insights from staffing optimization to inventory decisions. Close each session confidently knowing cash balances are verified, payment methods reconcile, and all transaction data is captured automatically for analysis, compliance, and business growth.
🎯 Key Takeaway: Every POS transaction feeds the daily report automatically. Review in real-time, close sessions knowing data is accurate, use insights to optimize staffing, inventory, and promotions. No more late-night spreadsheets, no more calculation errors, no more guessing about what sold today.
