Segment Revenue Reporting in Odoo#
Investors and boards want to see revenue broken down by segment - product line, geography, sales channel, or customer type. GL accounts alone don't provide this; analytic dimensions do.
Defining Revenue Segments#
Create analytic accounts for each reporting dimension:
Product Line Segment (Plan 1):
- Software Licenses
- Professional Services
- Maintenance & Support
- Hardware
Geography Segment (Plan 2):
- North America
- Europe
- Asia Pacific
- Rest of World
Channel Segment (Plan 3):
- Direct Sales
- Partner/Reseller
- eCommerce
- Inbound (Marketing Sourced)
Applying Segments to Revenue#
On each customer invoice line:
- Plan 1 (Product Line): Professional Services
- Plan 2 (Geography): North America
- Plan 3 (Channel): Direct Sales
For invoices generated from sale orders, automate this:
Product → General tab → Analytic Distribution:
- Product "Consulting Service": always tagged with Professional Services (Plan 1)
- Salesperson in US: tagged with North America (Plan 2)
- Sales order source: Direct Sales (Plan 3)
Revenue by Segment Report#
Accounting → Reporting → Analytic Report → select Plan 1 (Product Line):
| Segment | Q1 Revenue | Q2 Revenue | Q3 Revenue | Total |
|---|---|---|---|---|
| Software Licenses | $280,000 | $295,000 | $310,000 | $885,000 |
| Professional Services | $120,000 | $145,000 | $138,000 | $403,000 |
| Maintenance | $85,000 | $87,000 | $90,000 | $262,000 |
| Total | $485,000 | $527,000 | $538,000 | $1,550,000 |
Cross-Segment Analysis#
Filter by multiple plans simultaneously:
- Plan 1: Professional Services × Plan 2: Europe
- Shows: European professional services revenue specifically
This multi-dimensional slice is impossible from the GL alone.
MRR by Segment (Subscription Companies)#
Subscriptions → Reporting → MRR Analysis → add analytic filter:
- MRR by product line: which subscription type drives most recurring revenue?
- MRR by geography: where is growth fastest?
- Churn by segment: which segments have highest cancellation rate?
Board-Ready Segment Report#
Export the analytic report → format in a standard board template:
- Revenue breakdown by product line (current quarter vs. prior quarter)
- Geographic mix (pie chart)
- Channel efficiency: revenue per dollar of marketing spend by channel
Segment reporting demonstrates operational discipline to investors - key for Series B+ fundraising and M&A due diligence.