Syntha Lab RU

P&L by channel

One row per channel and month: revenue, returns, cost of sales, variable costs, marketing, contribution and fixed costs.

Layouts for documents 10 columns 4 example rows

Download CSV ↓

What the template is for

Comparing channels on contribution and profit and plan-versus-actual by channel.

What one row is
one row = channel × month

Columns

ColumnCodeTypeRequiredValidation rule
MonthmonthTextyesmonth as YYYY-MM
ChannelchannelList valueyesown-retail, wholesale, marketplace or ecom
Revenue, thousand, excl. VATrevenueNumberyesa number not below 0
Returns, thousandreturnsNumberyesa number not below 0
Cost of sales, thousandcogsNumberyesa number not below 0
Variable channel costs, thousandvariableNumberyesa number not below 0
Channel marketing, thousandmarketingNumberyesa number not below 0
Contribution, thousandcmNumberyescalculated: revenue − returns − cost of sales − variable − marketing
Fixed channel costs, thousandfixedNumberyesa number not below 0
Channel profit, thousandprofitNumberyescalculated: contribution − fixed

Example rows

MonthChannelRevenue, thousand, excl. VATReturns, thousandCost of sales, thousandVariable channel costs, thousandChannel marketing, thousandContribution, thousandFixed channel costs, thousandChannel profit, thousand
2027-02own-retail8,2005903,3804105203,3001,4001,900
2027-02wholesale6,1001803,290150602,4202802,140
2027-02marketplace4,3006401,710790480680120560
2027-02ecom2,6002601,000240410690180510

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

Note

Allocate shared costs (management, warehouse) by a rule chosen in advance and do not change it within a period. Platform commissions and acquiring are variable. 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 →