The order list can show per-order net profit — yet month-end still hurts: what did this month actually earn? How do rand payouts and yuan costs sit on one sheet? Where do the cash sitting in the platform wallet and the stock sitting in the warehouse belong? 辉光ERP adds a Profit Report tab under Reports — rolling the per-order rules into a P&L you can reconcile against.

The Net Profit column in Order Management answers "what did this order make?"; this article is the roll-up: pick a date range, pull true net profit for the store, then break it open by calendar month, SKU and order — and say out loud what's missing instead of padding with guesses.

What this feature does for you

Two tabs on Reports: beside the existing Platform Reports sits Profit Report. Pick dates or tap the 7/30/90-day presets and numbers load for the current store. If a sub-account has profit visibility turned off, the tab simply isn't there — no permission means invisible, not an error after the click.
Profit breakdown (P&L style): five sections on one screen — (1) platform books (settled only: sales − commission − fulfilment − other fees = settlement); (2) China-side real costs (CNY payout − purchase cost − international freight − PO handling = operating net); (3) other platform income/expense in the range (returns reversal, fee refunds, cancel penalties, storage/rent and the rest, by ledger month); (4) final net profit; (5) payout reconciliation. ZAR and CNY columns plus share percentages; click a line item to re-sort the SKU detail below.
Order and SKU detail: the engine reuses the order-page net-profit rules (cost priority, billed freight allocation, settlement-day FX, 0.97 arrival factor), with two deliberate roll-up differences: cancelled lines dropped, totals only over computable items. Missing cost, missing dimensions/weight, missing settlement-day rate, whole orders still unsettled — amber notes at the bottom name the qty and revenue. Blank beats invented.
Calendar-month summary: aggregated on the SAST calendar — settled portions by order month, returns/penalties by ledger month. The monthly table lists qty, sales, unsettled-in-transit, platform settlement, purchase cost, international freight, operating net, margin, returns reversal, cancel penalties, actual disbursement, ledger FX and final net.
Monthly ledger FX lock: stops "one rate tick and every historical bill moves". Priority: your locked rate → that month's month-end historical rate (past months never drift) → live rate (current month only; freezes to month-end when the month closes). Click the Ledger FX cell to edit or clear to unlock; badges show Locked / Month-end / Live. Only the main account can write locks.
Payout reconciliation (cash-side balance bridge): beyond accrual net profit, match the money that actually landed — platform settlement + other platform income/expense = implied book-balance move − actual disbursement (disbursement transactions; EFT top-ups don't count) = cash still stranded on the platform. Unsettled-in-transit is called out separately, never mixed into section one's books.
Stock snapshot: SKU rows pull the official Takealot warehouse snapshot (JHB / CPT / DBN by DC + total + in transit), de-duplicated by offer so cross-order lines don't double-count. The summary shows available units, in transit and capital tied up (stock × unit cost), clearly labelled "as of generation time, not a historical month-end" — don't treat it as a month-end stocktake.
Full-formula XLSX export: four sheets — Profit Summary, SKU Detail, Order Detail, Monthly Summary. FX, arrival factor and unit cost on cost-missing rows are yellow editable cells; Monthly Summary SUMIFs off the Month column on Order Detail so filling costs recalculates monthly net; ledger conversion uses each month's in-row rate, while summary cell C5 is What-if only (mainly for SKU Detail).

tip: SKUs missing purchase cost are left out of on-screen net profit — export, fill the yellow Unit Cost column on SKU Detail, and every formula in the workbook catches up. Section two only counts "computable" rows, so settlement from cost-missing or dimension-missing lines never inflates as pure profit. The stock snapshot is the warehouse state when you open the report, not a month-end close for the date range you picked.

Real seller scenarios

Month-end close: pick last month's calendar range, read Final Net Profit, clear the amber missing-cost list, export XLSX for accounting — fill the yellow cells and Monthly Summary plus the summary sheet recalculate themselves. No rebuilding formulas in Excel.
FX post-mortem: the rand slides for weeks; open Monthly Summary — May shows Month-end, June shows Locked if you set one. Past months aren't repainted by today's quote; returns reversals and penalties convert at each month's own rate.
Payout doesn't match: settlement "earned" and the platform balance disagree — open section five's bridge: how much is still unsettled in transit, how much actually disbursed, how much is still stranded. Cash bridge and accrual P&L sit in separate columns, so you stop guessing where the money stuck.
Tied-up stock check: one stock-snapshot line under the P&L — available units, in transit, capital in yuan; hover a SKU row for JHB/CPT/DBN. Bestsellers empty and slow movers full show up in one glance.

The Profit Report tab is part of 辉光ERP's finance suite — the all-in-one platform for Takealot cross-border sellers in South Africa. Per-order net profit lives on the order column; whole-store P&L lives here — close the books on facts, and make the months add up.