All posts
Profit analytics

How to Read a Marketplace P&L for Better Noon Profit

#profit #pl #noon #sku #margin

Introduction

A profit and loss (P&L) report is more than a list of revenue and expenses. For Noon sellers using FBN or FBPI fulfilment, it is the tool that tells you whether each SKU is adding value or draining resources. This guide shows you how to read a marketplace P&L the right way, translate the numbers into actionable insight, and improve your Noon profit.

1. The basic structure of a marketplace P&L

A typical Noon settlement report is split into three sections:

  • Revenue – gross sales, shipping income, any promotional rebates.
  • Cost of Goods Sold (COGS) – purchase price, inbound freight, customs duties.
  • Marketplace fees – commission, fulfilment, storage, return handling.

The bottom line after these rows is your net profit per unit. If the figure is negative, the SKU is losing money.

2. Start with gross sales per SKU

The first column you will see is the total sales amount for each SKU. For example:

SKU Units sold Gross sales (AED)
12345 150 4,500
67890 80 2,400

Do not confuse this with the amount that lands in your bank. It is the price the buyer paid before any deductions.

3. Subtract the direct cost of the product

Next, locate the COGS column. This should include:

  • Purchase price per unit (say AED 15 for SKU 12345).
  • Inbound freight (AED 0.50 per unit).
  • Customs duty (if applicable, e.g., AED 0.30 per unit).

Calculate total COGS per SKU:

  • SKU 12345: (15 + 0.5 + 0.3) × 150 = AED 2,430.
  • SKU 67890: (12 + 0.4) × 80 = AED 992.

Subtracting COGS from gross sales gives you gross profit before marketplace fees.

4. Identify the marketplace fee components

Noon charges several fees, each shown as a separate line item. Because the exact percentages change, use the values in your settlement report or, for illustration, say a 15% category commission, plus the FBPI fulfilment fee of AED 2 per unit and a storage fee of AED 0.20 per unit.

SKU Commission (15%) Fulfilment fee Storage fee Total fees
12345 675 300 30 1,005
67890 360 160 16 536

5. Calculate marketplace margin

Marketplace margin is the proportion of fees to gross sales. Use the formula:

Marketplace margin = Total fees ÷ Gross sales

  • SKU 12345: 1,005 ÷ 4,500 = 22.3%.
  • SKU 67890: 536 ÷ 2,400 = 22.3% (coincidentally the same in this example).

A high marketplace margin erodes profit quickly. Benchmark your margin against your target (often below 20% for low‑margin categories).

6. Derive net profit per unit

Now bring everything together:

Net profit per unit = (Gross sales – COGS – Total fees) ÷ Units sold

  • SKU 12345: (4,500 – 2,430 – 1,005) ÷ 150 = AED 0.71 per unit.
  • SKU 67890: (2,400 – 992 – 536) ÷ 80 = AED 0.48 per unit.

These figures are the net profit per unit you need to compare against your business goals. If the amount is below your minimum acceptable profit (say AED 1), consider pricing adjustments, sourcing cheaper suppliers, or dropping the SKU.

7. Spotting trends across the catalogue

When you have dozens of SKUs, summarise the data in a pivot table:

  • Group by product category.
  • Average gross profit, marketplace margin, and net profit per unit.
  • Highlight categories where margin exceeds 25% or net profit per unit is negative.

This visual overview helps you decide where to focus marketing spend and where to prune inventory.

8. Adjusting for returns and refunds

Returned items generate additional costs:

  • Reverse‑logistics fee (often a flat AED 5 per return).
  • Restocking charge (e.g., 10% of the purchase price).

Add a returns column to your P&L and recalculate net profit per unit. If returns push a SKU into loss, investigate the cause – quality issues, inaccurate sizing, or misleading listings.

9. Factoring in advertising spend

If you run Noon Sponsored Products, the ad spend appears as a separate line item. Treat it like any other fee:

Adjusted net profit per unit = Net profit per unit – (Ad spend ÷ Units sold)

For instance, if you spent AED 300 on ads for SKU 12345, the adjusted profit becomes:

0.71 – (300 ÷ 150) = 0.71 – 2.00 = -1.29 AED per unit.

A negative adjusted profit signals that the campaign is not sustainable. Either improve conversion rates or reallocate the budget.

10. Building a regular review routine

  • Weekly: Pull the latest settlement report, update the SKU spreadsheet, and flag any unit that fell below the profit threshold.
  • Monthly: Review trends, adjust pricing, and negotiate with suppliers if a whole category is under‑performing.
  • Quarterly: Re‑evaluate your fee assumptions (commission rates may change) and run a scenario analysis for new product launches.

Consistent monitoring prevents small leaks from becoming large losses.

11. Practical tips for improving Noon profit

  • Bundle low‑margin SKUs with higher‑margin accessories to raise average order value.
  • Optimise packaging to reduce fulfilment weight, thereby lowering the per‑unit fulfilment fee.
  • Use Noon’s bulk upload tool to keep inventory data accurate; mismatched stock leads to cancellations and hidden costs.
  • Negotiate storage discounts during off‑peak months if you have a large volume of slow‑moving items.
  • Test price elasticity: raise the price by 5% on a SKU with a 22% marketplace margin and watch the impact on units sold and net profit per unit.

12. Conclusion

Reading a marketplace P&L is not a one‑off exercise. By breaking down revenue, COGS, and each fee line, you can calculate SKU profitability, understand your marketplace margin, and arrive at a realistic net profit per unit. Use the steps above to turn raw numbers into decisions that protect your bottom line and grow your Noon business.

All monetary examples are illustrative. Check the current rate in your settlement report for accurate calculations.