What is net revenue?
Net revenue is the sales figure every revenue breakdown in the app agrees on: the sum of order-line revenue over net sales — orders that are neither cancelled nor refunded — excluding tax. One definition, applied identically whether the number is the headline KPI, a per-product ranking, or a country split, so two widgets never disagree about what a euro of revenue is.
Formula
net revenue = Σ line_revenue_base WHERE is_net_sale
Worked example
A store books €120,000 of order lines in a month. €6,000 sits on cancelled orders and €4,000 on fully refunded ones — net revenue is €110,000. A platform report that counts orders at placement would show €120,000; the €10,000 difference is not missing data, it is the countable-sale rule. Partial refunds are different: the order still counts as a sale, and its refund shows in the refunds metric instead of silently shrinking revenue.
How Saldo Metrics computes it
v_orders defines is_net_sale once — status neither cancelled nor refunded — and
every revenue surface applies it. Line revenue is line_revenue_base: the line's
as-sold amount converted to EUR at the order date's ECB rate (each order also keeps
its original currency and rate). The KPI and trend chart sum v_order_lines over
the selected period; the product, brand and category rankings sum through
v_contribution_margin so revenue and margin come from the same rows; the country
split reads v_order_accounting, which also carries the tax-inclusive figure and
VAT beside the net number. Order-level discounts are allocated onto lines in the
margin path, so a brand's net revenue and its margin always describe the same
discounted euros.
Why it matters
Revenue is the denominator of margin percent and the base of MER and blended ROAS — if it drifted between widgets, every derived number would drift with it. Anchoring one net-sale definition at the view layer is what lets the app put revenue, margin and refunds side by side without reconciliation footnotes.
Common mistakes
- Comparing against a platform's gross figure. Store platforms often report placed-order totals including tax; net revenue is post-cancellation, pre-tax. Reconcile through the order-accounting view, which carries both bases.
- Reading a revenue ranking as a profit ranking. The product and brand tables show margin next to revenue for a reason; the top-revenue row is regularly a mid-table margin row.
- Expecting refunds to reduce net revenue. Only fully refunded orders drop out. Partial refunds are reported separately — netting them here too would double-count the loss.
Where you see this in the app
The Revenue KPI and trend on the dashboard, the top-products, brand, category and country revenue widgets, and the revenue alert metrics (7-day and 30-day).
- Formula
- Σ line revenue over net sales (cancelled and refunded orders excluded)
- How Saldo Metrics computes it
- canonical.v_order_lines, canonical.v_orders, canonical.v_contribution_margin, canonical.v_order_accounting
Last reviewed 2026-08-29