Fix the period and store first
Reconcile one Qoo10 account, one period and source currencies: JPY and purchase currencies. A bank settlement is not the same as period profit.
The market context is Japan and Qoo10 cross-border routes. Validate local reports before consolidation.
Build the financial result
Combine sales, returns, reimbursements, marketplace fees, logistics, storage, advertising and other deductions. Then add product cost and external operating expenses.
- gross sales and returns
- settlements and adjustments
- fees, logistics and storage
- product cost, ads and external expenses
Move from totals to products
The Qoo10 operating focus is beauty, fashion, campaigns, coupons and cross-border orders with a local storefront. Expand store totals to SKU, variant, category and fulfillment model.
Review negative-profit products, sharp expense changes and sales without product cost.
Turn the report into a decision
Fix data quality first, isolate one-off adjustments and only then change price, advertising or replenishment.
SellerStrat keeps a traceable path from total profit to expense line and product.
Frequently asked questions
Why is a Qoo10 settlement not profit?
A settlement is cash movement and may include other periods. Profit needs sales, returns, deductions, product cost and external expenses for one aligned period.
Where should report review start?
Verify store, period, currency, sales and returns before deductions and negative-profit products.