Sellerboard Alternative for Noon: Calculate True Profit Without Software

The Spreadsheet Trap: Why Most Noon Sellers Are Blind to Their Real Profit

You list a product on Noon. The order arrives. You see the money in your settlement report. You feel like you made a sale. But did you actually make profit?

Most Noon sellers in the UAE, Saudi Arabia, and Egypt do not know the answer. They build a spreadsheet. They add up COGS, throw in a Noon commission percentage they think they remember, maybe account for a refund or two, and call it a day. Then a fee changes. Or returns spike. Or their ad spend suddenly doubles because they panic-adjusted bids. The spreadsheet becomes fiction.

This post shows you how to calculate your true Noon profit manually, step by step. But more importantly, it shows you exactly where that manual method collapses, why a Sellerboard alternative for Noon becomes essential, and what real sellers actually need to survive in 2026.

How Noon Settlement Actually Works: The Math Behind the Money

Before you can calculate profit, you need to understand what Noon actually takes from you. Not what you think they take. What they actually take.

When you sell a product on Noon, three things happen simultaneously:

1. You receive an order.
2. Noon deducts fees from the sale price before the money reaches your account.
3. You carry the cost of COGS, refunds, returns, storage, and ads.

The settlement report is your source of truth. It shows the final amount Noon paid you. But it does not tell you why. It does not tell you which product, which order, which fee ate into your margin. That is what you have to reverse-engineer.

Let us walk through a real example. Say you sell a AED 150 kitchen gadget in the UAE on FBN fulfilment.

The order arrives. Here is what Noon takes:

• Category commission (let us say 15%, but check your settlement report for the exact rate): AED 22.50
• FBN fulfilment fee (varies by weight and category, but let us estimate AED 12 for a light item): AED 12
• Payment processing fee (typically 2-3% of the sale price): AED 3-4.50
• Value-added tax (VAT is handled differently depending on your jurisdiction, but assume Noon withholds it): AED 13.50 (if applicable)

Your payout before COGS and ads: AED 150 minus AED 22.50 minus AED 12 minus AED 3.75 minus AED 13.50 = AED 98.25

Now subtract your cost of goods sold (COGS). If that AED 150 gadget cost you AED 60 to source and import, your gross profit is AED 38.25 on a AED 150 sale. That is a 25.5% margin. Not bad. Except:

• You ran ads to get that order. Say you spent AED 8 on ads for this particular sale (or AED 8 divided by conversion rate, allocated per order). Profit drops to AED 30.25.
• The customer filed a return. Noon refunded them AED 150, you lose the product, but you keep COGS cost AED 60 and the ad spend AED 8. You are down AED 26.75 on that transaction.
• Noon charged you FBN storage fees for inventory that did not sell. If you stored 100 units for 30 days and 20 of them never moved, that is AED 2-3 per unit per month in storage costs you need to amortise across all units.

Suddenly, that AED 150 sale is not as profitable as the settlement report suggested.

The Manual Calculation Method: Step by Step

Here is how to calculate true profit per SKU without a Noon profit calculator or Sellerboard alternative:

Step 1: Gather Your Data

Pull your Noon settlement report for the past 30-90 days. You need:

• Total revenue (sum of all order values)
• Total category commissions (Noon takes these automatically)
• Total fulfilment fees (FBN or FBPI)
• Total payment processing fees
• Total VAT withheld (if applicable)
• Total returns and refunds
• Total ad spend (from your Noon ads dashboard)
• Total storage fees (if on FBN)

You should also know:

• Your COGS per SKU (this is your responsibility to track)
• Your return rate (Noon does not always break this down clearly)
• Your conversion rate and average order value

Step 2: Calculate Your Net Revenue

Take your total revenue and subtract all Noon fees:

Net Revenue = Gross Revenue - Category Commission - Fulfilment Fees - Payment Processing Fees - VAT Withheld

Example: If you had AED 50,000 in gross sales, AED 7,500 in commissions, AED 2,000 in fulfilment fees, AED 1,000 in processing fees, and AED 2,250 in VAT, your net revenue is AED 37,250.

That is what actually hit your bank account (before you account for COGS and ads).

Step 3: Subtract Cost of Goods Sold

Here is where most sellers fail. They do not track COGS accurately. They estimate. They guess. They use supplier invoices from six months ago when prices were different.

You must know your exact COGS per SKU, including:

• Product cost (what you paid the supplier)
• Import duties and shipping to your warehouse
• Packaging and labelling
• Any shrinkage or damage in transit

If you sold AED 50,000 worth of products and your total COGS was AED 20,000, your gross profit is AED 37,250 minus AED 20,000 = AED 17,250.

Step 4: Account for Returns and Refunds

This is the killer. Most sellers do not properly account for the true cost of a return.

When a customer returns a product:

• You lose the sale revenue (already deducted in Step 2).
• You lose the COGS (already deducted in Step 3).
• You lose the ad spend that drove that sale.
• You may incur a restocking or inspection cost (Noon may charge you for processing the return).
• The returned item may be unsellable (damaged, wrong size, customer satisfaction issue).

If your return rate is 8% (typical for fast fashion on Noon) and your average ad spend per order is AED 5, a 8% return rate on AED 50,000 in sales means you are losing AED 4,000 in revenue, AED 1,600 in COGS, AED 200 in wasted ad spend, plus whatever Noon charges you to process the return.

Adjusted Gross Profit = Gross Profit - (Return Rate x Average Order Value) - (Return Rate x Average COGS) - (Return Rate x Average Ad Spend per Order)

If your gross profit was AED 17,250 and returns cost you AED 5,800, your adjusted gross profit is AED 11,450.

Step 5: Subtract Ad Spend

Noon ads are not optional if you want visibility. Every order you get through Noon ads costs you. You need to know your cost per order (CPO) and your return on ad spend (ROAS).

If you spent AED 3,000 on ads and generated AED 50,000 in sales, your ROAS is 16.67:1 (AED 50,000 divided by AED 3,000). That sounds great. But it is not profit. It is just the ratio of revenue to spend.

Your actual ad cost per order depends on your conversion rate. If you had 500 orders from AED 50,000 in sales, your average order value is AED 100. If you spent AED 3,000 on ads, your CPO is AED 6.

True Profit = Adjusted Gross Profit - Total Ad Spend

If your adjusted gross profit is AED 11,450 and you spent AED 3,000 on ads, your true profit is AED 8,450.

Step 6: Account for Fixed Costs (The Part Most Sellers Skip)

You have a Noon subscription (if on FBP or FBN). You may have paid for product photography, listing optimisation, or a virtual assistant. You may have paid for warehousing space.

These are not per-order costs. They are fixed costs. But they are real costs. If you want to know your true profit, you need to allocate them.

If your Noon seller subscription is AED 99 per month and you made AED 8,450 in profit from the calculation above, your net profit is AED 8,450 minus AED 99 = AED 8,351. If you also spent AED 500 on photography and AED 200 on a virtual assistant that month, your true net profit is AED 7,651.

That is your real profit. Not the settlement report number. Not the spreadsheet guess. Your actual profit.

Where the Manual Method Breaks Down

Now here is the hard truth: this manual method works for one month. Maybe two. But it collapses the moment anything changes.

Problem 1: Noon Fees Change Without Notice

In 2025-2026, Noon has shifted commission rates, introduced new fulfilment fees, and changed VAT handling multiple times. If you calculate profit based on last month's fee structure and Noon changes category commissions next month, your spreadsheet is worthless.

You would need to recalculate everything. Every single month. Every time Noon updates the fee table.

Problem 2: You Cannot Allocate Costs Accurately Per SKU

The manual method above works for your entire account. But what about individual SKUs?

If you sell 50 different products, you need to know which ones are actually profitable. The spreadsheet approach requires you to:

• Track COGS per SKU (most sellers do not do this accurately).
• Allocate ad spend per SKU (Noon ads dashboard shows total spend, not per-product spend).
• Calculate return rates per SKU (Noon settlement does not break this down clearly).
• Allocate fixed costs per SKU (how much of your AED 99 subscription applies to your garlic press versus your phone case?).

You can do this manually, but it takes hours. And if you have 100 SKUs, it becomes impossible.

Problem 3: Returns and Refunds Are a Moving Target

Your return rate is not static. It changes by season, by product category, by listing quality, by customer demographics. If you calculate profit based on an 8% return rate and next month it jumps to 12%, your profit forecast is wrong.

Moreover, Noon does not always clearly label which returns are customer-initiated, which are damaged-on-arrival, and which are lost-in-transit. You have to dig through settlement notes and match them to orders manually.

Problem 4: Ad Spend Attribution Is Fuzzy

Noon ads tell you total spend and total sales attributed to ads. But this is not per-order. If you spent AED 3,000 on ads and Noon says you got AED 50,000 in attributed sales, how much ad spend belongs to each order?

You could divide evenly (AED 3,000 divided by 500 orders = AED 6 per order). But Noon's attribution model is not linear. Some orders are influenced by ads but not directly driven by ads. Some orders are driven by organic search after an ad impression weeks earlier. The manual method forces you to make assumptions that are often wrong.

Problem 5: Storage Fees and Inventory Costs Are Hard to Allocate

If you are on FBN fulfilment, Noon charges you storage fees. These are typically per unit per month, but the exact rate depends on the size and weight of your product, the time of year, and your storage utilisation.

If you stored 500 units for 30 days and only 200 of them sold, how much storage cost applies to the 200 units that sold? Do you divide the total storage cost evenly across all 500 units? Or only across the 200 that moved? The answer affects your per-unit profit significantly.

A manual spreadsheet forces you to make a choice. But that choice is often wrong, and it changes month to month.

Why You Need a Sellerboard Alternative for Noon

This is where a Noon profit calculator or Noon analytics software becomes not just convenient, but necessary.

A proper Noon seller tool does what your spreadsheet cannot:

1. Pulls live data from your Noon settlement report in real time, so fee changes are captured automatically.
2. Calculates profit per SKU, not just per account, so you know which products are actually making money.
3. Tracks return rates per SKU and allocates refund costs accurately.
4. Integrates ad spend data from your Noon ads account and matches it to orders, so you know the true cost of acquisition per product.
5. Amortises fixed costs and storage fees across your SKUs based on actual sales velocity, not guesses.
6. Updates daily or weekly, so you see profit trends in real time instead of discovering problems at month-end.
7. Alerts you when a SKU turns unprofitable, so you can act before you lose money on dead inventory.

A Sellerboard alternative for Noon does not just save you time. It saves you from making decisions based on bad data.

For example, SKUmargin is built specifically for Noon sellers in the GCC. It pulls your settlement data, your order history, your returns, and your ad spend, then calculates your true net profit per SKU after every fee, every refund, and every ad dollar. You see instantly which products are printing money and which are bleeding margin. You do not have to guess. You do not have to build a spreadsheet. You do not have to wonder if you are profitable.

Advanced Tactics: When to Use Manual Calculation and When to Automate

That said, not every Noon seller needs a paid Noon accounting software tool. Here is when to use manual calculation and when to upgrade:

Use Manual Calculation If:

• You have fewer than 10 active SKUs.
• Your product mix is stable (low turnover, similar margins across products).
• You update your spreadsheet weekly, not monthly.
• You are willing to spend 2-3 hours per week on profit analysis.
• Your average order value is high enough that a 1-2% profit error does not matter (e.g., AED 500+ average order value).

Upgrade to a Noon seller tool If:

• You have more than 20 active SKUs.
• Your product mix is diverse (different categories, wildly different margins).
• Your return rate is high (above 10%) or volatile.
• You run significant ad spend (above AED 500 per month).
• You are on FBN and paying storage fees.
• You need to make SKU-level decisions (which products to restock, which to kill, which to reprice).
• You cannot afford to make profit calculation errors.

For most serious Noon sellers in the UAE, KSA, or Egypt in 2026, the answer is clear: a Sellerboard alternative for Noon is not a luxury. It is the cost of doing business accurately.

Common Mistakes Sellers Make When Calculating Profit Manually

Mistake 1: Forgetting to subtract VAT.

VAT handling varies by country and by whether you are VAT-registered. Noon withholds VAT in some cases. If you forget to account for this, your profit calculation is inflated by up to 15%.

Mistake 2: Using last month's commission rate for next month's forecast.

Noon changes fees. Do not assume stability. Check your settlement report every month and update your rate assumptions.

Mistake 3: Not tracking COGS accurately.

If you source from multiple suppliers, or if prices fluctuate, your COGS estimate is probably wrong. Spend the time to calculate true COGS per unit, including shipping and duties. This is the single biggest source of profit miscalculation.

Mistake 4: Allocating ad spend evenly across all orders.

Some orders come from organic search. Some come from ads. Noon tries to attribute them, but the attribution is imperfect. If you assume all orders are equally expensive to acquire, you will overshoot ad costs on high-converting products and undershoot on low-converting ones.

Mistake 5: Ignoring opportunity cost.

If a SKU has a 5% net profit margin and you could invest that capital in a SKU with a 15% margin, the 5% SKU is actually costing you money in terms of opportunity cost. Manual spreadsheets do not account for this. A Noon profit calculator does.

Conclusion: The Path Forward

You can calculate your true Noon profit manually. The method above is sound. But it is also labour-intensive, error-prone, and fragile. The moment Noon changes a fee, the moment your return rate spikes, the moment you add a new product category, your spreadsheet becomes outdated.

For sellers with a handful of products and stable operations, manual calculation is fine. For everyone else, a Sellerboard alternative for Noon that automates profit tracking is not optional.

The real question is not whether you can calculate profit manually. It is whether you can afford not to know your true profit per SKU in real time. In 2026, when margins are tighter and competition is fiercer, that knowledge is the difference between scaling and failing.

Start with the manual method to understand how profit actually works on Noon. But do not stay there. Pull your settlement data, plug it into a Noon profit calculator or Noon analytics software, and see your true profit per SKU. You will probably be shocked at what you find. Most sellers are. And once you see it, you cannot unsee it. That is when you start making decisions based on data instead of guesses.

The path to profitability on Noon is not complicated. But it requires visibility. Get that visibility first. Everything else follows.