Record the order-level facts
A useful order ledger captures order date, order ID, sales channel, SKU, quantity, currency, gross item revenue, shipping collected, discounts, refunds and sales tax separately. Keep a consistent order identifier so you can reconcile the ledger with marketplace statements and payment processor exports.
Useful cost columns
- Product cost and inbound freight allocation
- Packaging, postage, fulfilment and storage
- Marketplace commission, listing and payment processing fees
- Promoted listing fees, advertising allocation and coupon costs
- Refunds, return labels, replacements and chargebacks
- Net contribution and, if allocated, overhead and net profit
Define the formulas consistently
Net sales should reflect discounts and refunds using a clearly stated basis. Contribution per order is net sales less variable costs. Contribution margin percentage is contribution divided by net sales. If you allocate fixed overhead, label the result as fully loaded profit rather than contribution.
Reconcile with source records
Marketplace dashboards may report order date, payout date and fee posting date differently. Keep those dates separate. Reconcile fees and payouts against platform statements and bank deposits, and investigate differences rather than forcing totals to match. Record the source and date of imported data.
Worked example: one order ledger row
Suppose one order records $50 net sales, $14 landed product cost, $6 fulfilment, $6 marketplace and payment fees, $8 advertising allocation and $2 expected return allowance. The row shows $36 total variable costs and $14 contribution. Store each amount in its own column rather than entering only the final profit figure; this makes it possible to trace a change back to its source.
When the marketplace later posts a fee adjustment or refund, update the relevant field and retain the statement reference. Keep the order date and payout date separate. Use the marketplace payout reconciliation workflow to match order records with settlement reports and bank deposits.
Review the numbers that drive decisions
Review contribution by SKU, channel, campaign and month. Watch for products with strong revenue but weak contribution, rising return rates, unusually high shipping costs or advertising spend that exceeds the margin available before ads.
Start simple and improve it
A spreadsheet with consistent columns is better than a complex system that is not maintained. Start with a small set of high-volume products, check the process against a sample of actual orders, and expand when the numbers reconcile. The profit calculator can help test individual order assumptions. Download the free order profit tracker to record actual results.