Syntha Lab RU

Marketplace unit economics

One row per SKU and platform: price, VAT, commission, logistics, storage, return logistics, cost, buyout, advertising and contribution per sold unit.

Layouts for documents 13 columns 3 example rows

Download CSV ↓

What the template is for

Checking what is left per sold unit after all fees and returns.

What one row is
one row = SKU × platform

Columns

ColumnCodeTypeRequiredValidation rule
SKU codeskuTextyesa value from the product reference
PlatformplatformList valueyesa value from the platform reference
Customer price incl. VATpriceNumberyesa number not below 0
VAT, %vatNumberyesfrom 0 to 100
Platform commission, % of pricecommNumberyesfrom 0 to 100
Logistics per unitlogiNumberyesa number not below 0
Storage per unitstorNumberyesa number not below 0
Logistics of one returnretlogNumberyesa number not below 0
Unit costcogsNumberyesa number not below 0
Buyout rate, %buyoutNumberyesfrom 0 to 100
Advertising, % of priceadNumberyesfrom 0 to 100
Contribution per sold unitcmNumberyescalculated: price ÷ (1 + VAT) − commission − cost − logistics − storage − advertising − return logistics × (100 − buyout) ÷ buyout
Contribution, % of price excl. VATcmPctNumberyescalculated: contribution ÷ price excl. VAT × 100

Example rows

SKU codePlatformCustomer price incl. VATVAT, %Platform commission, % of priceLogistics per unitStorage per unitLogistics of one returnUnit costBuyout rate, %Advertising, % of priceContribution per sold unitContribution, % of price excl. VAT
SKU-A1platform-a3,990221711824611,4808412479.7714.7
SKU-B2platform-a7,490221714231682,7908291,214.0219.8
SKU-C3platform-b5,290221412628551,9307810966.9522.3

The example data is illustrative: an exercise, replace it with your own.

Note

Take tariffs, the commission base (with or without VAT) and logistics rules from the platform offer on the calculation date: they change. Return logistics and non-resalable losses depend on the return share. The example data is illustrative: an exercise, not a norm or an industry benchmark.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →