Per-Order Net Profit: Settlement-Day FX, International Freight, Actual Purchase Cost — What Each Order Really Earned, in One Column
Order Management gains a Net Profit column: your CNY payout converted at the exchange rate of the order's actual settlement day, minus volumetric-weight international freight, handling fees and the real purchase cost — every order's true profit or loss sits right on the row. Import your forwarder's billing statement and freight flips from estimate to actual, giving each PO a final, settled profit figure.
"So how much did this order actually make?" — the question cross-border sellers ask most and answer worst. The sale is in rand, the costs are in yuan, the exchange rate moves daily, freight is charged by weight, and the platform takes several fees along the way. 辉光ERP now settles that question per order, in a Net Profit column right in your order list.
How the number is built
Each order's net profit = CNY payout − international freight − handling fee − purchase cost. Simple to say; the honesty is in the details:
- Payout at the settlement-day rate: not today's rate, not the order date's — the rate of the day the platform actually settled that order. The system syncs international rates daily and converts ZAR→CNY at the settlement day's rate, with a 97% arrival factor reserved for conversion costs. March orders keep March's rate, June orders keep June's — history doesn't get repainted by today's market.
- Freight by volumetric weight: the greater of actual weight and volumetric weight (L×W×H÷6000), times your configured rate per kg — bulky-but-light parcels are costed the way your forwarder costs them.
- Purchase cost prefers real money: three tiers — the actual amounts collected from your 1688/Pinduoduo orders first, then source unit price × quantity, then the product-profile cost as a last resort. Actuals show as solid black figures; estimates show grey and dashed with their source explained. Real books and rough books never blur.
- No fake numbers: unsettled orders honestly say "pending settlement"; orders missing a weight, a rate or a cost say exactly what's missing. Blank beats invented.
Import your freight bill: from estimate to actual
The shipping page gains "import freight bill": upload your forwarder's wallet statement and the system reconciles it line by line — each PO's courier, handling, VAT and customs-duty components split out, refunds and surcharges netted. The dispatched-PO list gains a Profit (¥) column: "projected" while freight is open, "final" once the bill is in, with a hover breakdown that even counts the value of stock still sitting in the warehouse.
Once a bill is imported, order-level international freight switches from estimate to the billed actual, allocated across orders by volumetric weight — and net profit sharpens accordingly. Freight you entered by hand is never silently overwritten: conflicts pop a confirmation card and you choose which number stands.
Real seller scenarios
- Bestseller check-up: sort your top seller by the net-profit column — turns out each order clears only ¥11, and returns eat most of that. Reprice the same day and pull the margin back into the safe zone.
- FX post-mortem: the rand slides for two weeks and the same product's May and June orders differ by 8% in net profit. Settlement-day accounting shows exactly how much the currency took — so you know whether to reprice or hedge.
- Month-end close: import the forwarder's statement, watch in-transit POs' freight settle to final, and see PO-level profit agree with order-level net profit — this month's earnings are a number, not a feeling.
Per-order net profit is part of 辉光ERP's finance suite — the all-in-one platform for Takealot cross-border sellers in South Africa. Run the business on instinct if you like; keep the books on facts.