Start with the decision, not the dashboard
Gross merchandise value can rise while cash quality deteriorates. Discounts, marketplace fees, advertising, returns, logistics, taxes, and landed product cost sit between the order value and the money available to operate the business. A useful P&L makes those layers visible rather than compressing them into one margin percentage.
Begin by naming the decisions the model must support: which SKUs deserve advertising, which promotions remain viable, where pricing needs to change, and which channel is producing durable contribution. That keeps the model commercial and prevents a spreadsheet from becoming an accounting archive nobody uses.
- Net selling price after customer discounts
- Marketplace, payment, fulfilment, and logistics charges
- Advertising cost attributed with a stated method
- Returns, cancellations, replacements, and reverse-logistics cost
- Landed product cost and any channel-specific packaging cost
Build the contribution bridge at SKU level
For each SKU, bridge from net sales to contribution in a consistent order. Subtract variable channel charges, fulfilment and shipping, return provisions, advertising, and landed cost. Keep fixed overhead outside the first contribution view so operators can see whether one additional sale helps or hurts before the wider business cost base is allocated.
Document every assumption beside the number. If advertising is allocated by attributed sales, say so. If return cost uses a rolling category rate, record the window. Transparent assumptions make the model debatable and improvable; hidden assumptions make it look precise while weakening decisions.
Reconcile economics with settlement cash
The P&L explains economic performance; the settlement statement explains cash movement. They should connect. Create a reconciliation queue for fee adjustments, withheld balances, reimbursements, claims, and timing differences. Do not force unexplained differences into a miscellaneous line and move on.
Use stable identifiers wherever available: order, SKU, settlement period, marketplace transaction, and claim reference. The goal is not only to close a period. It is to identify repeat leakage patterns and assign an owner to prevent or recover them.
- Separate timing differences from genuine leakage
- Keep an evidence link for each disputed charge or recovery
- Age unresolved items and give each one an owner
- Feed confirmed cost changes back into pricing and advertising rules
Turn the P&L into a weekly operating rhythm
A strong model ends with action. Review the largest contribution changes, the SKUs below the agreed floor, return-cost movement, advertising efficiency, and settlement exceptions. Rank interventions by financial impact, urgency, and effort, then record the decision and expected signal.
Over time, this creates a useful history: what changed, why it changed, who approved it, and whether the economics improved. That history is more valuable than a static monthly report because it teaches the business which levers actually compound.