Net revenue

What customers actually paid after discounts, minus refunds. Which deductions are included differs between companies, so always state them.

FormulaNet = paid after discounts − completed refunds

How we work it through

1
List every deduction you apply: discounts, refunds, fees, taxes.
2
Decide what to do with refunds still pending (115 of them here) and say it.
3
Never compare a net number with a gross one from another report.

On the practice dataset

The query we run on Meridian, Atterna’s practice marketplace, and what it returns.

SELECT SUM(paid_eur)
  - (SELECT SUM(amount_eur) FROM meridian.refunds
     WHERE status = 'completed') AS net
FROM meridian.orders
WHERE status = 'paid';

Result€518,808 — from €552,645 of goods, €23,376 of platform discounts and €10,461 of completed refunds

The common trap

Forgetting pending refunds, or mixing gross and net in one comparison.

ExampleMeridian: €529,269 paid after platform discounts, €518,808 after completed refunds. On a marketplace that is still mostly the sellers’ money; the platform’s own revenue is its commission.

When an AI answers

An AI assistant

“Net revenue was €552,645.”

What it didn’t know: It did not know discounts and refunds are stored in other columns and another table.
Ask back: “Which deductions did you subtract? Show goods value, discounts and refunds as separate lines.”

Paste a real AI answer into the checker — it writes these questions for you →