From the headline number to the detail behind it.
Sales before returns = gross sales − discounts. Net revenue = sales before returns − return amounts recorded in the selected period. Net COGS = shipped COGS − return COGS. Gross profit = net revenue − net COGS.
Return value rate = period return amounts / period sales before returns. It is a period measure, not an order cohort rate. Returns have no original invoice identifier, so they are not matched to individual invoices.
MTD shows the selected month through the latest available date in that month; this demonstration contains complete actual months through 31 July 2026. YTD covers January–July and FY shows the full year or available actuals. Comparisons use the same selected months in the previous year. All views follow the active year, period, brand and channel. Actuals stop in July 2026; full-year actual comparisons use Jan–Jul in both baselines. Forecasts use the workbook’s cached Current Outlook forecast for Aug–Dec 2026. Scenario contributions use Shapley attribution across the four assumptions and reconcile to the change from Current Outlook. Scenario adjustments add percentage points to the model’s growth and return assumptions; historical actuals, Current Outlook and Budget stay fixed. No SKU-level forecast is implied.
Operating Profit = Gross Profit − synthetic Operating Expenses, including depreciation. Actual costs are locked; Budget is fixed. Shared fixed costs use frozen FY2026 budget-sales weights across active markets. Filtered profitability therefore includes allocated shared costs. Only performance marketing and fulfilment respond to relevant scenario changes.