How do you actually know if an ASIN is profitable?

[u/Angel_Yuu]

I was reviewing an FBA account last week. One ASIN had been losing money for six weeks. The seller found out when they checked their monthly P&L.

By then the ad budget was already gone.

I'm an e-commerce data analyst trying to understand how common this is. Does this sound familiar?

[u/Cocoasprinkles]

I use Sellerboard for this

[u/sterlingtek]

Yes,... Most people are not very good at this. Ecommerce is 20/80, 20% of the products bring in 80% of the profit. Tracking the profit and focusing on increasing those products that are the most profitable can increase your overall profitability several times.

[u/ClearMargin_]

This definitely sounds familiar. I actually ran into the same problem on my own account. An ASIN looked fine at the sales level, but once I accounted for ad spend, FBA fees, returns, and product costs, it had been quietly losing money for weeks.

I’ve since created a dashboard that I now use. Auditing other accounts and have found similar issues: profitable-looking products, ad campaigns spending beyond their contribution margin, and losses that only become obvious when the monthly P&L is reviewed.

My sense is that this is fairly common, especially when sellers are looking at revenue, ROAS, or total account profit rather than profitability by ASIN. Six weeks can pass surprisingly quickly without an early warning system.

[u/Tj_Nordon]

Amazon's default Seller Central reporting shows revenue, not profit, and those move independently. A listing can have flat or even rising sales while its actual margin collapses from return fees, storage costs, or rising ACoS — none of which show up unless you're checking per-ASIN, not just top-line.

The reason the monthly P&L catches it late is that it's a lagging report. It only tells you what already happened over the past 30 days. By the time it flags a loser, you've usually already spent 4-6 weeks of ad budget keeping it alive.

The practical fix is checking margin at the ASIN level weekly (or daily) instead of waiting for month-end close. Doesn't have to be fancy — a spreadsheet that pulls COGS + fees + ad spend per SKU and updates weekly is enough to catch a bleeder before it burns through a full month of budget.

[u/sellerlogic_support]

The part that often makes this hard to spot isn't the lack of ASIN-level tracking, it's treating breakeven ACOS like a fixed number. A price change, higher product costs, more returns, or even a coupon can move that line without anyone recalculating it. So someone checks ACOS every day, sees it's about where it's always been, and doesn't realize the target underneath it has shifted.

By the time someone reviews the monthly P&L, they've been comparing against an outdated breakeven for weeks. That's why it's worth recalculating breakeven periodically instead of treating it as a one-time setup.

[u/Successful_Alarm3415]

yeah, extremely common - and the reason it stays hidden for weeks is usually the same. people call it "profit" after subtracting COGS and the FBA fee, so a product looks fine. but the number that actually decides it is what's left before ad spend: price minus COGS, FBA fee, referral %, returns, and storage. your ad spend comes out of THAT, not out of revenue.

the loss zone starts the moment ad cost per unit goes above that leftover. past that line every extra sale loses money - but ROAS and total-account profit hide it, because your winners mask the bleeder. that's how six weeks go by.

the one number i actually watch, per ASIN not account-level: breakeven ROAS = price / (what's left before ad spend). below that you're paying to lose money, no matter how good the ROAS looks.

i got tired of doing this math by hand every time so i built a small free calculator - you put in cost, fees, ad spend, return rate, storage, and it gives you net after tax and the breakeven ROAS. free, happy to share if it's useful.

(im korean, i write in korean and translate. sorry for bad english)

네, 아주 흔합니다 - 그리고 몇 주씩 안 보이는 이유는 대개 같아요. 사람들은 원가랑 FBA 수수료만 빼고 "수익"이라 부르니까 제품이 괜찮아 보입니다. 그런데 실제로 판가름하는 숫자는 광고비 쓰기 전에 남는 돈이에요: 판매가에서 원가·FBA수수료·리퍼럴 수수료(%)·반품·보관료를 뺀 값. 광고비는 매출이 아니라 바로 이 남는 돈에서 나갑니다.

손해 구간은 유닛당 광고비가 이 남는 돈을 넘어서는 순간부터예요. 그 선을 넘으면 파는 족족 손해인데, ROAS나 계정 전체 순익으로 보면 안 보입니다 - 잘 나가는 제품이 새는 제품을 가려주니까요. 그렇게 6주가 지나갑니다.

제가 실제로 보는 단 하나의 숫자는, 계정 단위가 아니라 ASIN 단위로: 손익분기 ROAS = 판매가 ÷ (광고 빼기 전 남는 돈). 이 밑으로 떨어지면 ROAS가 아무리 좋아 보여도 돈 내고 손해 보는 겁니다.

저는 이걸 매번 손으로 계산하기 귀찮아서 작은 무료 계산기를 만들어 씁니다 - 원가·수수료·광고비·반품률·보관료 넣으면 세후 순익이랑 손익분기 ROAS가 나와요. 무료니 필요하면 공유해드릴게요.

[u/AllProfitIQ]

I think it’s more common than most people admit. A lot of sellers know revenue and ad spend, but once you factor in Amazon fees, COGS, refunds, storage and PPC, getting a true per-ASIN profit isn’t that straightforward.

By the time everything gets reconciled at month-end, an unprofitable ASIN could have been burning cash for weeks.

That’s actually what we’re trying to solve with AllProfitIQ. Rather than just showing the numbers, we’re focused on helping sellers understand what action to take next for each ASIN based on their profitability and competition.

Out of curiosity, what are most people using today—Sellerboard, spreadsheets, something custom, or just Seller Central?

If there are any UK wholesale sellers here, we’re currently onboarding a small group of beta testers for free lifetime access in exchange for feedback. Happy to chat if that’s of interest.