Subscription Reporting in Odoo 18
By Braincuber Team
Published on December 28, 2025
SaaS executives tracking subscription metrics in spreadsheets create blind spots: CEO asks "what's our MRR growth?" finance scrambles exporting data from 3 systems taking 2 days to calculate, churn rate unknown until quarterly board meeting when it's too late to intervene, and expansion revenue opportunities missed because nobody tracking which customers upgraded vs downgraded—making strategic decisions based on gut feel not data.
Odoo 18 Subscription Reporting provides real-time analytics with MRR analysis tracking monthly recurring revenue changes, retention analysis showing customer cohort behavior, MRR breakdown by event type (new/expansion/churn/contraction), subscription analysis by salesperson/team/plan, visual dashboards with graph/pivot/list views, and customizable metrics—enabling data-driven decisions on pricing, sales strategy, and customer success.
Reporting Features: MRR analysis, Retention tracking, Churn breakdown, Revenue categorization (New/Expansion/Contraction), Multiple view types, Custom grouping, Real-time dashboards
Report Types
Access via Subscriptions → Reporting. Four core reports:
Subscriptions Analysis
Overview of all subscriptions by state, team, salesperson, product, template
Retention Analysis
Customer cohort retention over time by day/week/month/year
MRR Breakdown
MRR changes categorized: New, Expansion, Transfer, Churn, Contraction
MRR Timeline
Historical MRR trend analysis with ARR change tracking
Subscriptions Analysis
Available Views:
- Graph View: Bar chart, Line chart, Pie chart with Stacked/Cumulative/Ascending/Descending options
- Pivot View: Group by Subscription State, Sales Team, Salesperson, Customer, Template, Plan, Product, dates
- List View: Tabular data by Order Reference, Customer, Product Category, Template, Salesperson, Team
Measures Available:
- Monthly Recurring Revenue
- Yearly Recurring Revenue
- Quantity
- Unit Price
- Untaxed Total
- Count
Retention Analysis
Access via Reporting → Retention Analysis. Shows customer cohort retention:
- Data chart format showing retention % over time
- Period grouping: Day, Week, Month, Year
- Measures: Amount to Pay, Margin, Prepayment %, Shipping Weight, Count
Use case: See that customers from January 2024 cohort have 85% retention after 6 months vs March cohort at 70%. Investigate what changed in March onboarding.
MRR Breakdown
Access via Reporting → MRR Breakdown. Categorizes MRR changes:
Event Categories:
- New: Revenue from new subscriptions
- Expansion: Existing customers upgrading/adding features
- Transfer: Plan changes at same revenue level
- Churn: Lost revenue from cancellations
- Contraction: Downgrades/feature removals
Views & Grouping:
- Graph: Stacked/Cumulative visualization of MRR changes
- List: Sales Order, Event Date, Salesperson, Event Type, MRR Change, New MRR
- Pivot: Group by Event Date/Type, Salesperson, Team, Template, Customer, Country
MRR Timeline
Historical MRR tracking with measures:
- Active Subscription Change
- ARR (Annual Recurring Revenue) Change
- MRR Change
- Count
Best Practices
Monitor MRR Breakdown Weekly: Churn +10% week-over-week = red flag requiring immediate investigation. Don't wait for monthly reports.
Set Retention Benchmarks: SaaS standard = 90%+ retention after 12 months. If yours 70%, either product-market fit issue or onboarding problem—prioritize fixing.
Track Expansion Revenue: Best SaaS companies get 20-30% revenue from existing customer expansion. If yours <10%, upsell process broken—review pricing tiers.
Conclusion
Odoo 18 Subscription Reporting eliminates spreadsheet chaos with real-time MRR analysis, retention tracking, event-based revenue categorization, and visual dashboards. Make data-driven decisions on pricing, sales strategy, and customer success without manual data compilation.