Amazon P&L
Where the money Amazon paid you went, line by line, for the settlements in your date range.
What this statement is
The Amazon P&L is built from Amazon's settlement reports — the statements behind each payout — not from your orders. Every line is dated by when it settled rather than when the order was placed, so a sale, its refund and its fees can land in three different date ranges. The page states this above the tables: "Amazon P&L is based on settlement report dates."
That single difference explains most of what looks wrong here, so read it before you compare anything.
The page holds two tables, read top to bottom:
- Products Settlements — one row per SKU, sorted by Net Sales, highest first. This is where you find which product is carrying the payout and which one is eating it.
- Profit and Loss Statement — the same settlement money rolled into eight categories and totalled as Profit & Loss. Expenses show as negative numbers, so the total is every category added together.
It needs one store. Pick a single seller account and marketplace from the selector at the top; the page does not render for an Organisation.
COGS comes from what you enter in Cost Settings, matched to each SKU at the settlement date. A SKU with no cost entered contributes zero cost, which understates COGS and overstates profit for every row it touches. If any active product is missing a cost, the page shows a red warning above the tables with a link straight to Cost Settings. Clear that warning before you trust the margin.
Read it in this order
Three moves, in this order: what came in, what came back, what Amazon kept.
1. Start with Revenue from Sales. It is the product money on settled orders, split by who shipped them — FBA Sales where Amazon fulfilled, MFN Sales where you did. It is also the denominator for the whole statement: every % of Revenue from Sales figure is that line divided by this one.
2. Take off the refunds. Refunded Sales is the same split in reverse — FBA Refunded Sales plus MFN Refunded Sales. Revenue Sales minus Refunded Sales is Net Sales, and Net Sales is what %COGS is measured against, not Revenue Sales.
3. Then read what Amazon deducted. Cost of Advertising, Cost of Goods Sold, Fees and Tax come off; Other Income goes back on. What survives is Profit & Loss.
Worked example. A settlement period shows €8,000 of FBA Sales and €2,000 of MFN Sales, so Revenue from Sales is €10,000. Refunds run €700 FBA and €300 MFN, so Refunded Sales is €1,000 and Net Sales is 10,000 − 1,000 = €9,000. COGS is €2,700, so %COGS is 2,700 ÷ 9,000 = 30%. The statement then reads:
| Category | Amount | % of Revenue from Sales |
|---|---|---|
| Revenue from Sales | €10,000 | 100% |
| Refunded Sales | −€1,000 | −10% |
| Cost of Advertising | −€1,200 | −12% |
| Cost of Goods Sold | −€2,700 | −27% |
| Other Income | €150 | 1.5% |
| Fees | −€2,250 | −22.5% |
| Tax | −€50 | −0.5% |
| Others | −€100 | −1% |
| Profit & Loss | €2,850 | 28.5% |
Read the percentage column, not the amounts. Fees at 22.5% and advertising at 12% are the two lines you can act on, and together they cost more than the goods did.
The line items
Products Settlements — one row per SKU
| Line item | What it is | Where it comes from |
|---|---|---|
| SKU | The seller SKU the settlement lines were booked against. | Settlement report |
| Net Sales | Revenue Sales minus Refunded Sales. The table sorts on this by default. | Calculated |
| Revenue Sales | Product money on settled orders: FBA Sales plus MFN Sales. | Calculated |
| Refunded Sales | Product money handed back: FBA Refunded Sales plus MFN Refunded Sales. | Calculated |
| COGS | Your unit cost at the settlement date, times the units settled. | Cost Settings |
| %COGS | COGS divided by Net Sales. Blank or zero usually means no cost was entered. | Calculated |
| Quantity | Units settled on those lines. | Settlement report |
| FBA Sales | Product money on orders Amazon fulfilled. | Settlement report |
| MFN Sales | Product money on orders you fulfilled yourself. | Settlement report |
| FBA Refunded Sales | Refunded product money on Amazon-fulfilled orders. | Settlement report |
| MFN Refunded Sales | Refunded product money on self-fulfilled orders. | Settlement report |
| Fees | Every Amazon fee on that SKU added together — commission, fulfilment, closing, storage, service, refund administration, shipping labels and statutory deductions. | Settlement report |
| Tax | Product, shipping and gift wrap tax, plus withheld tax and regulatory fees, for that SKU. | Settlement report |
Sales and refunds are split by fulfilment channel because they behave differently. FBA carries Amazon's fulfilment and storage fees inside the Fees column; MFN does not. Shipping labels you bought through Amazon sit in Fees either way.
Profit and Loss Statement — eight categories
Each category carries an Amount and a % of Revenue from Sales. Expense categories are shown negative, and a higher percentage on an expense category means more of your revenue went to it.
| Line item | What it is | Where it comes from |
|---|---|---|
| Revenue from Sales | Seller fulfilled product sales plus FBA product sales. The base every percentage on this table is measured against. | Settlement report |
| Refunded Sales | Seller fulfilled and FBA product sale refunds. | Settlement report |
| Cost of Advertising | What Amazon deducted for advertising in this settlement, less any advertiser refunds. | Settlement report |
| Cost of Goods Sold | The COGS from the table above, rolled up. | Cost Settings |
| Other Income | Money that is not product sales: shipping and gift wrap credits, promotional rebates, inventory reimbursements, A-to-z claims, chargebacks, liquidation proceeds. | Settlement report |
| Fees | Selling fees, FBA transaction and pick-and-pack fees, closing fees, refund administration, storage and inbound services, subscription and service fees, shipping labels, and statutory deductions — net of fee refunds. | Settlement report |
| Tax | Tax and regulatory fees collected, less tax refunded, less any tax Amazon withheld on your behalf. | Settlement report |
| Others | Every remaining credit and debit in the settlement that no category above claimed. A large figure here is worth raising with support. | Settlement report |
| Profit & Loss | Every category added together. The bottom line of the statement. | Calculated |
Where the data comes from
Both tables are built from Amazon's Settlement Report (the V2 flat file), aggregated per day and per SKU, then converted into your marketplace's currency. The Amazon Summary page is built from a different report — Sales and Traffic — which is why the two disagree. COGS is the only figure on this page that Amazon does not supply: it is read from the per-SKU cost history you maintain in Cost Settings, using the cost that was in effect on the settlement date.
What to check first
Clear the COGS warning. If the red line above the tables says active products are missing COGS, every margin figure below it is optimistic. Fix that before reading anything else.
Then find the expensive winner. The scan is three steps:
- Sort by Net Sales, descending — the table already does.
- Now look across to %COGS.
- The row you want is high Net Sales with high %COGS. That SKU is carrying your payout and keeping very little of it. A row with high Net Sales and 0%COGS is not a triumph, it is a missing cost.
Then read the statement's percentage column downwards. Fees and Cost of Advertising are the two deductions you can actually change. There's no published band for either, so read them against your own trend and your own mix — oversized or slow-moving FBA units carry fulfilment and storage fees out of proportion to what they sell for.
Common misreads
They are not meant to. Amazon Summary counts orders on the day they were placed; this page counts settlement lines on the day Amazon settled them. A sale placed near the end of a month can settle in the following period, and its refund later still. Compare long ranges against long ranges rather than one week against another, and expect Ordered Product SalesOrdered Product SalesShows gross product demand from Amazon orders. and Units OrderedUnits OrderedThe volume side of demand, before value. on the Summary page to lead this statement rather than match it.
Check that a cost exists for it first. COGS is whatever you entered in Cost Settings; a SKU you never costed reads as zero, drags %COGS down, and pushes Profit & Loss up. An unusually low %COGS on the page is more often missing data than a good margin.
It is what Amazon deducted from this settlement, so it moves on the payout calendar rather than the campaign calendar. Judge campaigns on ACOSACOSThe share of ad revenue eaten by the ads themselves.Under 20% is healthy and TACOSTACOSHow dependent your whole business is on ads.Under 8% is healthy where the spend is dated to the click. Use this line for the cash question instead: how much of the payout advertising took.
It is product money only, on settled orders only. Shipping charges, gift wrap and promotional rebates sit in Other Income; tax sits in Tax. Adding Revenue from Sales to a figure from anywhere else in the app double-counts unless you know both are drawn from settlements.
A short date range can fall between two settlements and legitimately show almost nothing. Widen it before treating a thin statement as a data problem.
See yours
See yoursYour settled sales by SKU and the full statement, for the settlements in your date range. Check the COGS warning first.
Open Amazon P&L →