In 5 seconds
Sales are not profit. To know what an ASIN or channel is really earning, subtract the right costs, keep missing costs visible, and use the cost that applied when the sale happened.
For you if: Multichannel sellers, owners, and operators who need a useful product-by-product or channel-by-channel profitability view.
Marketplace dashboards are very good at showing sales.
That is useful — but it creates an easy trap.
A product can sell a lot and still earn very little. Your biggest marketplace can bring in the most sales but leave less profit than a smaller channel. An ASIN can also have good-looking ad numbers while its real costs are getting worse.
Revenue tells you how much was sold.
Profit asks a simpler question: after the costs needed to make and fulfill those sales, how much money was left? It also matters whether the data behind that answer is complete.
For multichannel sellers, the math is spread across several systems. Each channel may report fees, refunds, fulfillment, and ads differently. Product cost also changes over time, and some costs may be missing. You need clear rules so the same type of sale is treated the same way every time.
A useful profit report should show both the math and anything you still do not know.
1. Sales and profit are not the same
A marketplace sales report might tell you:
Gross sales: $100,000
That number is not profit.
A simple product or channel profit view might subtract:
- discounts or promotions;
- refunds or returns;
- marketplace fees;
- fulfillment fees;
- product cost;
- inbound/landed cost components, depending on your model;
- advertising spend;
- other direct channel costs.
The exact definitions should match how your business wants to make decisions. The important rule is consistency.
If you call one report “profit” but it excludes ad spend and another includes it, the numbers are not comparable even if both calculations are individually correct.
Define the metric before building the dashboard.
2. A marketplace report is only part of the picture
Amazon, Walmart, TikTok Shop, Shopify, and other channels each expose different slices of economic activity.
One report may show order revenue. Another shows fees. Another shows advertising. Another contains refunds. Your accounting system may contain cash settlements or expenses that are not tied cleanly to individual orders or SKUs.
That means a marketplace profitability view is usually a matching-and-checking problem.
You are combining evidence from multiple systems into a consistent decision model.
The marketplace is the best source for some facts. Your cost history is the best source for other facts. Accounting may be a useful place to check totals for cash and ledger totals.
Do not force one system to answer questions it was not designed to answer.
3. Missing product cost does not mean the product was free
This is a dangerous shortcut in product profit reporting.
If a SKU has no mapped product cost and the report silently substitutes $0, the resulting margin is overstated.
That is not just a formatting problem. It can make a weak product look profitable.
A better model distinguishes at least:
- known cost;
- estimated cost;
- unmapped / missing cost.
You can still calculate partial views. Just do not present missing cost as though the item was free.
For example, if 22 of 500 SKUs are missing product cost, say so. Show results for the SKUs with known costs and list the 22 that still need work. That is better than showing a clean-looking profit number that is wrong.
4. Use the cost that applied when the sale happened
Product cost changes.
A shipment purchased in March may have a different landed cost than replenishment received in August. Supplier pricing, freight, duties, packaging, and currency can all move.
If you calculate January's profitability using September's current cost, you rewrite history.
A stronger model uses the product cost that applied on the sale date: match the sale to the cost that was valid at the time of the transaction under your chosen cost policy.
That policy might be weighted average, standard cost, FIFO-derived reporting, or another defensible method. The Nyansa principle is not that one method is universally correct. It is that the method should be explicit and historical reports should not silently inherit today's number.
When the cost history is unclear, mark it as such.
5. Decide how refunds should affect cost
Refunds complicate profitability because the economic effect depends on what happened to the product and how you want to report the event.
Questions include:
- Was revenue reversed?
- Were marketplace fees returned?
- Was fulfillment cost reversed?
- Was the item returned to sellable inventory?
- Was it damaged, lost, or disposed?
- Should product cost be reversed in the reporting view?
- Is the marketplace reimbursement recorded separately?
Different businesses can choose different reporting treatments. The dangerous approach is letting the data source decide implicitly.
Document your refund basis and use it consistently.
If the marketplace report does not give enough information to choose the right treatment, mark the result as unknown instead of pretending the cost reversal is known.
6. Include advertising when the decision needs it
A product can look healthy before ads and weak after them.
That does not mean every profitability view must allocate every advertising dollar perfectly to every order. It means the report should be clear about whether ad spend is included, where it comes from, and at what level it is allocated.
For PPC decisions, product-level money left before advertising is especially important because it tells you what the product can afford.
For higher-level channel analysis, you may also want money left after advertising.
Use both when they answer different decisions. Label them clearly.
This is also why ACoS alone cannot tell you whether advertising is profitable. The ad metric needs a real cost-and-profit layer underneath it.
7. Make every filter affect the whole report
Profitability dashboards become misleading when filters change the denominator in one metric but not another.
For example, if the date filter updates sales but ad spend remains lifetime, profit after ads is meaningless. If the channel filter removes Walmart revenue but leaves Walmart fees, the comparison is broken.
Every important filter should have a defined scope:
- transaction date;
- order date vs. settlement date;
- marketplace/channel;
- SKU/ASIN/product;
- fulfillment method;
- brand/category;
- refund inclusion;
- advertising period;
- mapped vs. unmapped cost state.
Consistency is more important than dashboard complexity.
A small number of trustworthy metrics beats a large number of partially filtered ones.
8. Check totals against accounting without changing the books
Marketplace profitability and accounting should connect, but they do not need to be the same system.
A management view may need SKU-level economics that the general ledger does not contain. Accounting may need settlement-level entries, tax treatment, payroll, fixed overhead, and financial-statement rules that an operator dashboard does not model.
A good boundary is:
Use accounting to check major totals. Do not let the profitability tool automatically change the books.
Compare totals. Investigate gaps. Document adjustments. But do not allow a marketplace analysis tool to silently modify financial records simply because its numbers differ.
If you eventually build controlled accounting writes, that is a separate authorization and verification problem.
Example scenario: the “best-selling” product
Imagine a product that generated $60,000 in marketplace revenue over a quarter.
It looks like a winner.
Then you add the rest of the picture:
- promotional discounts reduced realized revenue;
- fulfillment and marketplace fees were high;
- product cost increased halfway through the quarter;
- advertising spend rose aggressively;
- refund volume increased;
- several sales rows are missing historical cost.
The correct conclusion may still be that the product is valuable. But “it sold $60,000” is no longer the decision.
You might find that:
- the first half of the quarter was highly profitable;
- the later cost increase left less money after direct costs;
- ad spend remained calibrated to the old margin;
- returns concentrated in one variation;
- some of the apparent margin exists only because product cost is missing.
Now the business has operating questions it can act on.
Revenue was the starting signal. Profitability produced the decisions.
A practical marketplace profitability sequence
- Define the metric you are calculating.
- Retrieve sales and refund evidence for the same scope.
- Retrieve channel fees and fulfillment costs.
- Map product cost using a documented historical method.
- Keep missing/estimated cost visible.
- Add advertising according to a defined allocation level.
- Apply refund treatment consistently.
- Ensure all filters affect the relevant components consistently.
- Check major totals against marketplace settlements and accounting.
- Investigate unexplained gaps instead of forcing the numbers to balance.
- Use the resulting profit view for pricing, PPC, inventory, and claims decisions.
You can build this by hand in a spreadsheet. If you manage many SKUs or marketplaces, ordinary browser AI such as ChatGPT or Claude can help clean exports, explain formulas, find mismatches, and build a review list. The important part is to keep the same definitions and evidence rules every time you run the report.
Choose the right next resource
If this is the problem you are trying to solve, the Marketplace Profitability Toolkit is the core paid operating resource. It is designed for building a defensible product/channel view that distinguishes known, estimated, and unmapped costs instead of silently changing the evidence.
If your immediate decision is Amazon advertising, use the free Profitability-Aware PPC Calculator to translate product economics into ACoS/CPC limits, then use the Profitability-Aware Amazon PPC Playbook for the recurring campaign-review method.
For pricing or reimbursement work, profitability is a companion layer when cost truth is the blocker — not an upsell that every buyer automatically needs.
Marketplace revenue matters. Just do not confuse the top line with the answer to “Did this product actually make money?”
Go one step deeper
For the cost-data failure that most easily inflates a profit report, read Missing COGS Is Not Zero COGS. It explains why a missing product cost must stay visible as missing instead of silently becoming $0 and making margins look stronger than they are.
Platform note: Marketplace screens, policies, rules, and report fields change. Check current marketplace guidance before acting on time-sensitive or account-specific requirements.
Put this into practice
If you are diagnosing one profitability question, use this guide and the related articles first. For recurring product- and channel-level profitability work, use the Marketplace Profitability Toolkit. If that profit view also needs to drive Amazon advertising decisions, use the Seller Profitability Bundle. Browse the full Marketplace Profitability resource family.
Nyansa Hub — Playbooks for Smarter Ecommerce. Built for sellers and operators managing multiple marketplaces, large catalogs, and recurring ecommerce operations.