P&L by channel
One row per channel and month: revenue, returns, cost of sales, variable costs, marketing, contribution and fixed costs.
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
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Month | month | Text | yes | month as YYYY-MM |
| Channel | channel | List value | yes | own-retail, wholesale, marketplace or ecom |
| Revenue, thousand, excl. VAT | revenue | Number | yes | a number not below 0 |
| Returns, thousand | returns | Number | yes | a number not below 0 |
| Cost of sales, thousand | cogs | Number | yes | a number not below 0 |
| Variable channel costs, thousand | variable | Number | yes | a number not below 0 |
| Channel marketing, thousand | marketing | Number | yes | a number not below 0 |
| Contribution, thousand | cm | Number | yes | calculated: revenue − returns − cost of sales − variable − marketing |
| Fixed channel costs, thousand | fixed | Number | yes | a number not below 0 |
| Channel profit, thousand | profit | Number | yes | calculated: contribution − fixed |
Example rows
| Month | Channel | Revenue, thousand, excl. VAT | Returns, thousand | Cost of sales, thousand | Variable channel costs, thousand | Channel marketing, thousand | Contribution, thousand | Fixed channel costs, thousand | Channel profit, thousand |
|---|---|---|---|---|---|---|---|---|---|
| 2027-02 | own-retail | 8,200 | 590 | 3,380 | 410 | 520 | 3,300 | 1,400 | 1,900 |
| 2027-02 | wholesale | 6,100 | 180 | 3,290 | 150 | 60 | 2,420 | 280 | 2,140 |
| 2027-02 | marketplace | 4,300 | 640 | 1,710 | 790 | 480 | 680 | 120 | 560 |
| 2027-02 | ecom | 2,600 | 260 | 1,000 | 240 | 410 | 690 | 180 | 510 |
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
- Profit and loss statement and profitability
- Margin by sales channel
- Contribution levels CM1–CM3 by channel with buyout
- Profit bridge: full-price sales growth and flow-through
- Gross-margin bridge by cause
- Plan versus actual by store: pace, period forecast, required daily pace
- Plan scenarios: base, optimistic, pessimistic
- Plan sensitivity and breaking point
Documents that need this data
- Income statement (P&L): management and statutory
- Store, channel and marketplace P&L
- Plan versus actual and profit factor analysis (bridge)
- The 365-day strategy and the hypothesis register: prioritization, a plan by area and defense before the owner and the bank
- The financial audit of a brand: P&L, profit bridge, loss map and checklist
- Financial model (FinModel): sheets, links, checks, scenarios
- Formats by economics: haute couture, luxury, bridge, mass market, off-price, flash sales, travel retail and live shopping
- Management accounting: financial responsibility centers, overhead allocation, standard cost and the accounting policy
- Unit economics by platform: how to build the calculation from deductions, compare schemes and find the break-even price
- Resale, collaborations and packaging: economics of buy-back and resale, capsule P&L and partner deal structure, the eco fee (EPR)