Your Marketplace P&L Is Probably Missing Costs

Marketplace dashboards make revenue easy to see and profit easy to overestimate. Commission is only one cost. Fulfillment, storage, advertising, returns, purchase cost, packaging, and reconciliation gaps can change the product decision completely.

A useful P&L follows an order from customer payment to contribution after every variable cost—and shows where data is missing.

1. Define the margin waterfall

Use consistent layers so every product and period can be compared:

Name each margin level and use it consistently. Teams often compare gross margin in one report with contribution margin in another and interpret the difference as performance.

2. Make COGS ownership explicit

Missing COGS should not silently become zero. Mark it as incomplete and assign an owner. For purchased inventory, landed cost should include purchase price plus relevant shipping, customs, and allocation costs. Partial receipts can change weighted cost over time.

Allow deliberate manual overrides, but preserve the source. Operators need to know whether a number came from a purchase order, bulk upload, manual correction, or system estimate.

3. Reconcile marketplace fee timing

Orders and fee invoices can arrive on different schedules. A recent period may have revenue before all associated fees are available. Show this timing gap instead of calling the period final.

Compare order-level expectations with settlement or invoice lines. Investigate unmatched orders, missing fee types, duplicate lines, currency issues, and late returns. Completeness matters as much as consistency: two reports can agree because both omit the same rows.

4. Allocate advertising carefully

Direct product spend belongs with the product. Shared campaign spend needs a documented allocation method. Avoid presenting allocated spend as exact causal truth; label the method and keep portfolio totals reconciled.

Review profit before and after ads. A product may have healthy operating economics but inefficient acquisition, or weak core margin that no bid optimization can solve. The remedies differ.

5. Treat returns as an economic event

A return can reverse revenue, preserve or destroy inventory value, add handling, and affect marketplace fees. Model the outcome rather than subtracting only the refund. Use an allowance for recent periods when final returns have not matured, then replace estimates with actuals.

High return rates often signal listing or product-fit problems. Profit reporting should connect the financial symptom to the operational queue.

6. Show confidence and missingness

Add visible completeness indicators for COGS coverage, fee reconciliation, advertising allocation, and return maturity. A slightly older complete period can be better for strategy than yesterday’s incomplete period.

Create explicit exception lists:

• products without COGS;
• orders without matching fee evidence;
• fees without a known order or product;
• returns without a recoverable-value decision;
• advertising spend without product allocation.

Fixing exceptions improves every later decision.

7. Use profit for action, not reporting theater

Segment products by both contribution and operational health. Profitable products losing the Buy Box need growth recovery. Unprofitable products winning it may be scaling a problem. Low-volume products with incomplete data need evidence, not immediate deletion.

Review absolute contribution euros alongside percentage margin. A strong percentage on negligible volume and a moderate percentage on substantial volume serve different portfolio roles.

8. Worked example: why completeness changes the ranking

Product A reports €20,000 revenue and €5,000 margin after marketplace commission. Product B reports €12,000 revenue and €3,500. The first dashboard ranks A as the obvious winner. Then finance completes the missing inputs: A has expensive fulfillment, €2,000 advertising spend, a high return allowance, and COGS based only on supplier price. Product B has complete landed cost, little advertising, and stable returns.

After the full waterfall, A contributes €800 and B contributes €2,400. The original ranking rewarded missing data. A team using it might increase advertising on A and underinvest in B.

Add confidence beside the result. Product A could be labeled incomplete while freight allocations and recent returns mature. Product B can be labeled reconciled. Portfolio totals should show both the reported contribution and the revenue share covered by complete COGS, fees, ads, and returns.

Use a month-end exception meeting to close the largest gaps. Sort missing data by revenue exposure, not row count. Ten low-volume products can matter less than one major SKU without a current cost. Assign finance, procurement, advertising, and operations owners to their relevant exceptions.

Month-end evidence pack

• COGS coverage by revenue and product count.
• Marketplace fee reconciliation rate and unmatched value.
• Advertising allocation coverage.
• Return maturity for recent order cohorts.
• Manual overrides added or changed.
• Material estimates that remain in the closed period.

9. Practical checklist

• Margin levels have stable definitions.
• Missing COGS never defaults to zero.
• Cost source and override history are visible.
• Fee reconciliation shows unmatched rows.
• Advertising allocations reconcile to portfolio spend.
• Returns include operational loss, not only refund value.
• Recent periods display completeness and maturity warnings.
• Product decisions use contribution euros and margin rate.
• Every missing-data category has an owner.

Profit truth is an operating capability, not a prettier revenue chart. Build the data chain first; optimization becomes much safer afterward.

Establish ownership for financial truth

Assign a named owner to each layer of the margin waterfall. Finance may own invoice reconciliation and tax treatment; procurement owns purchase and landed cost evidence; operations owns fulfillment assumptions; advertising owns spend allocation. The P&L owner is responsible for bringing those inputs together, not silently estimating around missing work.

Publish a short data-quality note with every management review. State the period, coverage, material estimates, unmatched value, and changes in method. This prevents executives from interpreting a provisional number as final and helps teams distinguish business movement from data movement.

When a cost method changes, calculate the historical effect where practical and mark the break in comparability. Do not overwrite old results without explanation. A trustworthy P&L lets operators trace both commercial events and accounting-method changes. That discipline creates confidence to use profit in pricing, advertising, inventory, and assortment decisions.