Business Process Catalog (Why) › Order to cash › Analyze sales performance
› Analyze revenue › Analyze total revenue in Dynamics 365 Finance
Description:
Analyze revenue delivers a governed, end‑to‑end view of revenue performance and
predictability—covering totals, mix, recurring revenue health, growth trends,
forecasts, and variances—so leaders can act quickly to protect margins and
accelerate durable growth
Applies to: Dynamics 365 Finance, Business Central, Sales, Commerce, Project
Operations, Subscription Billing; Microsoft Fabric and Power BI for models and
scorecards; Copilot (narratives, anomaly detection, next‑best actions)
Typical dimensions (slicers): Time (day/week/month/quarter/fiscal),
Product/Service/SKU, Category/Family, Customer/Account/Segment, Channel
(POS/e‑commerce/call center/direct/partner), Region/Country/Currency, Sales
org/Rep/Territory/Partner, Project/Contract/Subscription/Plan,
Campaign/Promotion, Industry
Typical revenue types: Booked, Billed (invoiced), Recognized (IFRS 15/ASC 606),
Recurring (MRR/ARR), One‑time, Usage/Consumption, Services (T&M/fixed fee),
Deferred/Unbilled, Backlog/RPO
Bold section headers requested below
Core KPIs and definitions
* Total revenue and revenue mix: total recognized revenue; mix by
product/service, category, channel, region, customer segment, and seller.
* Revenue growth: YoY, QoQ, 3/12‑month rolling growth, organic vs. FX‑neutral
growth, like‑for‑like/comparable sales.
* Revenue by product or service: SKU/family/portfolio performance;
attach/cross‑sell rates; promo lift vs. baseline.
* Category analysis: category contribution, margin mix shift, price/volume/mix
decomposition.
* Customer revenue: top‑N concentration, share‑of‑wallet,
expansion/contraction, cohort retention revenue.
* Recurring revenue: MRR, ARR, net dollar retention (NDR), gross retention,
expansion/contraction/churn revenue, logo churn, renewals due/past‑due,
average revenue per account (ARPA/ARPU).
* Forecast and pipeline: in‑period revenue forecast; sales‑to‑revenue
conversion; coverage ratios; backlog/RPO burn.
* Forecast quality: MAPE, bias (over/under), hit‑rate by
segment/channel/product; forecast vs. plan/commit.
* Variance to forecast/plan: volume, price, mix, timing/recognition,
returns/credits/rebates, delivery slippage, FX, accounting reclassifications.
* Returns/credits/rebates and trade allowances: gross‑to‑net waterfall, accrual
accuracy, claim aging, deduction recovery rate.
* Profitability tie‑ins: gross margin %, contribution margin, promo ROI,
discount leakage.
Standard reports and scorecards
* Executive revenue scorecard: totals, growth, mix, forecast vs. plan, variance
bridge with drivers.
* Revenue by product/service: hierarchy drill (portfolio → family → SKU) with
price/volume/mix and promo impact.
* Customer revenue and retention: top customer trends, cohort curves, NDR/gross
retention, churn and reactivation.
* Recurring revenue dashboard: MRR/ARR waterfall (new, expansion, contraction,
churn), renewals runway.
* Channel/POS revenue: store/region conversion, UPT, tender mix, returns/voids,
promo uplift.
* Bookings–Billings–Backlog/RPO view: conversion cadence and risk flags.
* Forecast quality pack: MAPE, bias, funnel conversion, aging of forecast
changes.
* Gross‑to‑net revenue waterfall: list price → discounts → rebates/trade
allowances → returns → net revenue.
* FX and multi‑currency views: constant‑currency restatements and FX variance
bridges.
High‑level process
1. Define metrics and targets
* Publish a metric dictionary (formulas for revenue, growth, MRR/ARR, NDR,
MAPE, variance drivers); set targets by segment/channel/product; lock
fiscal calendars and currency policies (spot vs. average vs. constant).
2. Assemble the trusted revenue model
* Land sales orders, invoices, revenue schedules, returns/credits,
rebates/trade allowances, subscription events, backlog/RPO, pipeline, and
POS receipts; harmonize dimensions and currencies; stamp revenue
recognition attributes and FX basis.
3. Produce baselines and gross‑to‑net
* Reconcile booked→billed→recognized; build gross‑to‑net waterfalls;
validate deferred/unbilled schedules; ensure accruals for
rebates/allowances are complete.
4. Monitor totals, mix, and growth
* Track total revenue and growth; analyze price/volume/mix and category
shifts; surface concentration risk and margin‑dilutive patterns.
5. Analyze revenue by product/service, category, channel, and customer
* Drill to SKU/category; review promo effects; evaluate channel and
customer segment performance; tie outcomes to assortment, pricing, and
fulfillment signals.
6. Assess recurring revenue health
* Generate MRR/ARR and cohort views; calculate NDR/gross retention;
quantify expansion/contraction; track renewal pipeline and churn drivers.
7. Build and reconcile revenue forecasts
* Combine opportunity pipeline and rev‑rec rules (for
projects/subscriptions) with statistical/time‑series and driver‑based
models; generate scenario cases (base, upside, downside).
8. Explain variance to forecast/plan
* Produce bridges with standardized drivers (volume, price, mix,
timing/recognition, returns/credits/rebates, delivery slippage, FX);
separate one‑offs from run‑rate.
9. Recommend and track actions
* Propose pricing/promo adjustments, portfolio actions, renewal saves,
deduction cleanup, and delivery de‑bottlenecking; assign owners, due
dates, and expected impact; close the loop.
10. Govern and continuously improve
* Run weekly operational and monthly business reviews; monitor forecast
accuracy/bias; refine models, dimensions, and policy settings; update the
metric dictionary as changes are approved.
Roles and responsibilities
* Revenue/Sales Finance: Owns revenue policy adherence, forecast, variance
analysis, gross‑to‑net integrity.
* Sales Operations/RevOps: Maintains pipeline hygiene, conversion analytics,
quota/coverage modeling.
* Product/Commercial: Acts on category and price/pack architecture insights;
manages promo ROI.
* Subscription/Billing Operations: Owns MRR/ARR, renewals, proration, and
contract changes.
* Order Management/Fulfillment: Addresses timing and delivery drivers behind
revenue variance.
* Accounting/Controller: Ensures rev‑rec compliance, FX policy, adjustments,
and close governance.
* Data & Analytics: Curates semantic models, scorecards, row‑level security,
alerting, and model MLOps.
Dynamics 365 support
* Finance and Business Central: Revenue recognition schedules, invoicing,
returns/credits, rebates/trade allowances, deferred/unbilled revenue,
multi‑currency, bank and GL reconciliation, standard P&L/by‑dimension
reports.
* Sales: Pipeline to revenue conversion, forecast categories, win/loss and
discount analytics feeding forecast.
* Commerce/POS: Store/channel revenue, conversion and UPT, promo uplift,
refunds/voids exception analytics.
* Project Operations: Milestone‑ and percentage‑of‑completion‑based rev‑rec for
services.
* Subscription Billing: Plans, proration, amendments, renewals; MRR/ARR, NDR
calculation support.
* Finance Insights, Power BI, Fabric: Forecast models, scorecards, variance
bridges, constant‑currency views; automated refresh and alerting.
* Copilot: Narrative summaries (“what changed and why”), anomaly detection,
suggested actions (e.g., price/mix changes, renewal saves), auto‑drafted exec
notes.
Operational controls and governance
* Policy compliance: IFRS 15/ASC 606 frameworks for recognition; approval
workflows for manual adjustments; documented FX treatment.
* Metric governance: Versioned metric dictionary; change control for KPI
formulas and targets.
* Data quality & access: Master data stewardship, duplicate prevention, revenue
cutoff checks; role‑based security and audit trails.
* Period close integrity: Reconciliation between subledgers and GL, lock
periods, reproducible snapshots for “as‑of” reporting.
Key inputs and outputs
* Inputs: Sales orders/opportunities, invoices/credit memos, revenue schedules,
returns/allowances/rebates, subscription events, POS receipts, backlog/RPO,
FX rates, promo calendars.
* Outputs: Executive revenue scorecards, product/category/channel/customer
reports, recurring revenue dashboard, bookings–billings–backlog/RPO, forecast
packs with bridges, constant‑currency views, gross‑to‑net waterfall, action
register with owners/impact.
KPI target examples (illustrative)
* Revenue growth: ≥ plan with ±2% tolerance; FX‑neutral growth tracked
separately.
* Forecast accuracy (MAPE): ≥ 85–90% at portfolio level; bias within ±3%.
* Net dollar retention: ≥ 110% for target subscription cohorts; gross retention
≥ 95%.
* Gross‑to‑net leakage: Stable or improving; deduction aging >90 days trending
down.
* Promo ROI: Positive lift without margin erosion in priority categories.