From orders to the money you keep.
Bring sales, refunds, marketplace charges and recorded costs into a report with definitions your team can explain.
Discuss this challengeQuestions the report should answer
- Which channels generate net sales after refunds?
- Are platform payouts and order reports reconciling?
- Which products need a closer look at their cost or return rate?
Measures and their meaning
Net sales
Completed sales less refunds, using an agreed date basis.
Recorded contribution
Net sales less costs included in the model; exclusions remain explicit.
Return rate
Returned orders divided by the agreed population of orders.
A practical first implementation
Choose one channel and reporting period.
Agree order states, dates and the treatment of returns.
Reconcile a small set of orders before scaling.
Build a channel overview and an order-level detail view.
Keep the explanation beside the number.
A returned order changes both the revenue calculation and the record you need to inspect. The report should show that record rather than hide it in a total.
Try the reporting toolStart with your sources
View all sourcesShopee
Connect order reporting with returns, charges and settlement records.
Review access & implementationShopify
Structure order, refund and product records for commerce reporting.
Review access & implementationTikTok Shop
Build consistent order and return reporting from your shop.
Review access & implementationExcel / CSV
Analyze your own order file in the Data Workbench.
CSV tool availableServices behind this solution
Data integration & centralization
Connect sales, marketing and operations so teams can work from a shared source of information.
See scopeData warehousing & modeling
Standardize structures, define metrics and organize data around how your business actually works.
See scopeDashboards & management reporting
See important metrics in a clear view connected to everyday decisions and actions.
See scope