A returned Amazon unit costs the seller the refunded price, minus the referral fee Amazon gives back, plus a refund administration fee Amazon keeps, plus the fulfillment fee that is never refunded, plus the cost of the unit if it comes back unsellable. On a $40 product that can be $30 to $45 of contribution gone per return, and the return arrives two to five weeks after the sale that earned it. A SKU with a 12 percent return rate looks like a 37 percent margin product in the month it sells and a 28 percent margin product once the returns land. Finding those SKUs is a matching problem: every refund has to be tied back to its original order, its original fees, and the disposition of the unit. That is the data an AI needs, and most sellers do not have it.
Return rate by SKU. Refunds matched to orders in the same period, divided by orders in that period. Account-level return rate hides everything; a 5 percent blended rate can contain one SKU at 14 percent and forty at 3.
Refund versus return. Some refunds come with a unit back. Some do not: the buyer is refunded and keeps the product, whether through a returnless-refund setting or a customer service concession. A refund without a return costs the full refund with nothing recovered. Count them separately.
Sellable versus unsellable. A returned unit graded sellable goes back into FBA inventory, and its cost of goods reverses. A unit graded unsellable, damaged, or customer-damaged is gone, and the COGS expensed at sale stays expensed. Per Amazon's FBA page on sell.amazon.com, Amazon handles returns processing for FBA orders; the grading outcome is in the returns report, not the settlement, so the two have to be joined.
The refund administration fee. When a seller refunds an order, Amazon returns the referral fee minus an administration fee. Amazon's Seller Central help page on the refund administration fee defines it as the lesser of $5 or 20 percent of the referral fee on the refunded item, calculated on item price plus shipping and gift wrap, and not on tax. A separate returns processing fee applies on some orders where Amazon provides free return shipping, per sell.amazon.com; its rates are on Seller Central and vary by category, so treat it as a further line to check on your own settlements.
The lag. Amazon's return window runs weeks. A unit sold on August 28 can be refunded on September 24. On an order-date ledger, August gets the sale and September gets the refund, and both months are misstated until the refund is matched back to its order.
Illustrative numbers. Take a seller with a cordless milk frother at $39.99 in Home and Kitchen, where sell.amazon.com lists the referral fee at 15 percent. Fulfillment fee is $5.04 per unit, Amazon's 2026 non-peak large standard rate for 1 to 1.25 pounds at $10 to $50, before the fuel surcharge. Landed cost is $11.50. August: 500 units sold, $1,400 of ad spend.
August as booked, before returns:
Returns on August orders, landing in September: 60 units, a 12 percent return rate. Grading: 36 sellable, 24 unsellable.
August restated: $7,325.75 minus $1,697.40 equals $5,628.35, or 28.1 percent. Eight and a half points of margin, invisible in August, charged to September if nobody matches the refunds back.
And the frother is one SKU. A seller reading a blended September that is $1,697 worse than expected has no way to know from the P&L that the cause is August's frothers rather than September's anything.
Three data joins, none of which Seller Central does for you.
The refund line on the settlement to the original order, so the refund lands against the sale's date and SKU. The settlement to the returns report, so each refund carries a disposition: returned sellable, returned unsellable, or not returned. And the unit back into inventory at its FIFO cost, so the COGS reversal is right. The FBA inventory reconciliation guide covers the third. ConnectBooks does the first two as part of settlement reconciliation into QuickBooks or Xero, posting the refund, the referral credit, and the administration fee to their own accounts against the SKU, and the SKU-level profit reports carry returns as a line per product.
With the joins in place, the analysis is a set of questions.
Ask which SKUs had a return rate above 8 percent on trailing 90-day orders, matched by order date. The answer is a list with rates and dollar cost, not a blended percentage.
Ask what returns cost by SKU last month including unrecovered fulfillment fees and unsellable COGS. This is the figure that turns a 12 percent rate into $1,697.
Ask which SKUs' return rates rose in the last eight weeks against the prior eight. A rate that moves is a batch, a listing change, or a packaging change; a rate that is stable and high is the product.
Ask how many refunds last quarter had no unit returned, by SKU. Expect them where the return shipping would cost more than the item is worth, and check whether that matches your catalog.
Crunch, the analytics AI inside ConnectBooks, answers these from the reconciled data, following its standard chain: find what changed across sales, fees, and returns; compare the periods; find the products responsible; explain why; recommend what to do next. Asked why September profit fell, it will find the frother, say the decline is August's returns landing, and separate that from anything September did on its own.
It cannot read the return reason. It sees 60 units back and 24 graded unsellable. "Arrived damaged" versus "not as described" versus "no longer needed" points at three different fixes (packaging, listing, buyer intent), and the reason codes and the units themselves are where that lives.
It cannot see a disposition Amazon has not reported yet. Returns in transit or awaiting grading are refunds without a disposition, and the COGS reversal is unknown until the returns report catches up. A good tool holds those open rather than guessing sellable.
It cannot tell you the return is not your fault. Amazon's reimbursement policies cover some carrier and warehouse damage, and claiming them is a separate workflow with its own evidence requirements.
It will not file the claim, change the packaging, or edit the listing. It tells you the frother is the SKU to look at, and by how much.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
