At a glance
Time-series chart showing consolidated revenue (post-elimination, in reporting currency) over the trailing period, broken out per subsidiary as stacked layers. The portfolio view of revenue trend: which subsidiaries are growing, which are flat, which are declining, and the rate of change of the consolidated total. The top of the OneWorld CFO’s dashboard.
Card gate: only_when: multi_subsidiary. Single-subsidiary tenants see a placeholder (or use Revenue Trend for single-subsidiary).
| What it counts | SUM(invoice.total) GROUP BY month, subsidiary, NET of intercompany eliminations. Each month is a stacked bar/area; each layer is one subsidiary. |
| VAT / tax treatment | Per subsidiary’s local basis; consolidation in reporting currency. |
| Shipping | Included. |
| Discounts | Already deducted. |
| Refunds | Net of credit memos. |
| Cancelled / voided orders | Excluded. |
| Currency | Each subsidiary in native, summed in consolidation currency at period-average FX rate. |
| Channels / sources | All sources blended within each subsidiary. |
| Intercompany handling | Eliminations applied; consolidated trend shows external-revenue only. |
| Time window | 90D default (rolling 90 days; can toggle to 12M, YTD, etc). |
| Alert trigger | None directly; trend declines surface via revenue and margin alert cards. |
| Roles | owner, CFO, board |
Calculation
Calculated automatically from your NetSuite data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US-headquartered industrial fastener distributor on NetSuite OneWorld, 5 subsidiaries. 12-month trailing view as of 30 Apr 26. Consolidated revenue by quarter:| Quarter | US Inc | UK Ltd | AU Pty | EU BV | CA Ltd | Total |
|---|---|---|---|---|---|---|
| Q2 25 | $20.1m | $5.8m | $3.6m | $2.4m | $1.9m | $33.8m |
| Q3 25 | $21.4m | $6.2m | $3.9m | $2.7m | $1.8m | $36.0m |
| Q4 25 | $22.8m | $6.8m | $4.2m | $3.1m | $1.7m | $38.6m |
| Q1 26 | $23.2m | $6.4m | $4.4m | $3.4m | $1.5m | $38.9m |
- Total trend: +15.1% YoY (Q1 25 to Q1 26). Healthy growth. The trailing 12-month CAGR is 14.5%.
- US Inc grew +15.4%. In line with portfolio average. The home market is healthy and proportionate.
- UK Ltd grew +10.3%. Slower than portfolio. Investigation: UK’s largest retailer-customer rebid their supply contract at lower margins; revenue is being protected but at lower margin (cross-reference Subsidiaries List margin column).
- AU Pty grew +22.2%. Fastest-growing subsidiary. The new local-warehouse strategy is paying off (cross-reference Inventory Turnover AU column at 9.2x).
- EU BV grew +41.7%. Triple-digit growth from a small base; the EU subsidiary is in scale-up mode.
- CA Ltd declined -21.1%. The portfolio’s only declining subsidiary. Cross-reference Top Findings Across Subsidiaries for CA Ltd: 8 open alerts including dead-stock, margin compression, sales-rep transitions. The subsidiary needs structural intervention.
- Action: at the next board meeting, present (a) consolidated growth +15% (positive top line), (b) AU + EU as growth engines (invest more), (c) CA as turnaround focus (decision: invest in turnaround team or wind down).
Sibling cards merchants should reference together
| Card | Why pair it with Consolidated Revenue Trend |
|---|---|
| Subsidiaries List | Per-subsidiary performance; this is the time-series complement. |
| Subsidiary Health Roll-up | Health-status overlay. |
| Top Findings Across Subsidiaries | Alert-aggregation companion. |
| Revenue by Subsidiary | Per-subsidiary revenue snapshot. |
| Revenue Trend | Single-subsidiary equivalent. |
| Revenue Booked into GL | The GL-level total. |
Reconciling against the vendor’s own dashboard
Where to look in NetSuite’s own dashboard:Reports > Financial > Income Statement (Consolidated) with the period set and subsidiary filter “All”. The Revenue line, broken out by subsidiary class, is directly comparable. Reports > Banking/Budgeting > Consolidated Reports > Multi-Subsidiary Revenue Trend (where available; depends on tenant configuration).Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| FX rate selection | Material | Vortex IQ uses period-average rate; NS reports may use period-end. |
| Intercompany eliminations | Material | Vortex IQ approximates eliminations live; NS posts at period-close. Mid-period the consolidated total can show 1-3% different. |
| Period boundary | Either | Vortex IQ uses Invoice tranDate; some NS reports use SO date. |