Gateway settlement reconciled against orders
Settlement batches are matched to the orders they cover with fees posted as fees
rather than as revenue reduction, so the receivable from each gateway is a balance that
can be aged and queried rather than a plug at month end.
Returns linked to the original order
A return authorisation references the order it reverses, carries the refund, the
inbound movement and the restock or write-off, so order-level profitability is stated
after returns rather than before them.
Channel as a reporting dimension from the order down
Orders carry their channel through to revenue, commission, fulfilment cost and
settlement, so margin by channel is produced from the same records rather than assembled
per platform in separate exports.
Fulfilment cost attributed per order
Shipping, packaging and collection costs are recorded against the order they served
so contribution per order and per basket size is measurable — which is what turns a free
delivery threshold into a decision rather than a guess.