SellerStrat
Guide · Finance

Build a marketplace financial report without missing costs

Revenue does not show what a store earned. A decision requires sales, returns, fees, logistics, deductions, product cost and advertising for one consistent period.

Reviewed: SellerStrat Editorial Team
Short answer

A marketplace financial report should reconcile net sales with returns, commissions, logistics, storage, penalties, advertising, taxes and product cost for the same period.

Grand total

OverviewSalesExpensesProfitAll
Delivered842Previous: 803
Change, %: 4,2
Share, %: 12,5
Refused26Previous: 28
Change, %: 4,9
Share, %: 14,6
Sales adjustments5Previous: 6
Change, %: 5,6
Share, %: 16,7
Damage compensation1 760Previous: 1 930
Change, %: 6,3
Share, %: 18,8
Sales655Previous: 621
Change, %: 7
Share, %: 20,9
Returns41Previous: 43
Change, %: 7,7
Share, %: 23
Refresh OzonFilterProduct, seller code or barcodeSelect periodColumns
View: OverviewRows: CategoriesPeriod: MonthSort: Sales, pcs. ascending
CategoryBarcodeSales, pcs.Returns, pcs.Net sold, pcs.Buyout, %CommissionLogistics costTotal payable
Household goods46070002100007913176091,4160,4162,1524 800
Beauty46070002101377573372990,7300,4302,1496 100
Clothing46070002102747233569890440,4442,1467 400
Electronics46070002104116893766789,3580,4582,1438 700
Sport46070002105486553963688,6720,4722,1410 000
Tableware46070002106856214160587,9860,4862,1381 300
Home textiles46070002108225874357487,21 000,41 002,1352 600
Accessories46070002109595534554386,51 140,41 142,1323 900
Demo illustration · sample data
Calculation example

Period profit example

The example reconciles revenue with every major deduction for one period.

1,200,000 - 90,000 - 180,000 - 75,000 - 25,000 - 520,000 - 95,000 = 215,000 RUB
Revenue and returns
1,200,000 - 90,000 RUB
Marketplace and operating deductions
280,000 RUB
Product cost and advertising
615,000 RUB

Profit: 215,000 RUB. Margin: 17.9%.

Illustrative calculation; actual values come from marketplace statements and seller cost inputs.

Inputs to connect

Use one period and one reporting currency.

  • sales and returns
  • commissions and payment fees
  • logistics and storage
  • deductions and adjustments
  • product cost and advertising

Review order

Start with the lines that have the largest profit impact, then move to categories and SKUs.

  1. 1

    Reconcile sales and returns.

  2. 2

    Review fees and logistics share.

  3. 3

    Compare profit with units sold.

  4. 4

    Inspect unprofitable products.

Common errors

Mixed periods, missing deductions, zero product cost and confusing accruals with cash flow distort the result.

SellerStrat workflow

The finance module connects report lines, profit and expenses and lets a seller move from a period total to a category or product.

Frequently asked questions

Why are revenue, payout and profit different?

Returns, fees, logistics, deductions, product cost, advertising and payment timing make these values different.

Evidence and sources

How this material was reviewed

SellerStrat Product and Data TeamProduct, analytics and integration specialists

Reconciled the example and checked the visible report fields, filters and statement detail.

Product version: SellerStrat 2.0
Stickers, barcodes and KIZ labels are free

Use SellerStrat with your store data

Start free