Amazon P&L
What Amazon actually paid out in this range, and which SKU carried it.
Before you read a number
Everything below is money Amazon has already paid out, not orders you took. That one difference explains most of what will look odd to you here.
Three controls above the tables decide which payouts you are looking at, and whether the profit underneath them is real.
Select Account appears when you sell on more than one Amazon account or marketplace. The page shows one account and one marketplace at a time. It also needs a single store — with an organisation selected, nothing renders.
"Amazon P&L is based on settlement report dates." Every figure is dated by when Amazon settled it, not when the order was placed. One sale, its refund and its fees can land in three different date ranges.
The red warning line, when it shows, reads "N active products are missing COGS - Enter COGS here." Click it and you land on Cost Settings. A SKU with no cost entered counts as costing nothing, so every profit figure below reads high until you clear it.
The tables
One tells you which SKU earned the payout. The other tells you what Amazon took out of it on the way to your bank.
Products Settlements
One row = one SKU.
Columns: SKU · Net SalesNet SalesSee the full entry. · Revenue SalesRevenue SalesEntry coming soon. · Refunded SalesRefunded SalesEntry coming soon. · COGS · %COGS% COGSLower % generally means better product margins. · QuantityQuantityThe core volume measure across products. · FBA SalesFBA SalesFBA Sales · MFN SalesMFN SalesMFN Sales · FBA Refunded SalesFBA Refunded SalesFBA Refunded Sales · MFN Refunded SalesMFN Refunded SalesMFN Refunded Sales · FeesFeesSum of commission, fulfilment, closing, storage, service, refund admin, shipping label, statutory deduction, and related fee fields for the row. · TaxTaxSum of product, shipping, gift wrap, withheld tax, and regulatory fee related fields for the row.
How to scan it
- Sort by Net Sales, highest first. It already opens this way.
- Look across at %COGS.
- The row that matters: big Net Sales, high %COGS. That SKU is carrying your payout and keeping very little of it. A big Net Sales row showing 0% is a missing cost, not a good margin.
Then run it a second way. Sort by Refunded Sales, highest first, and read Quantity on those rows. A SKU handing back a large share of what it sells has a listing or a sizing problem, and no bid change will fix it.
And a third. Sort by Fees, highest first, then look at FBA Sales against MFN Sales on that row. Amazon's fulfilment and storage charges ride inside Fees on the FBA side only — a heavy Fees row that is mostly FBA is telling you the unit is expensive to store and ship, not expensive to sell.
Profit and Loss Statement
One row = one line of the statement. Rows open to show what sits underneath them.
Columns: Line Item · Amount · % of Revenue from Sales% of Revenue from SalesEntry coming soon.
Expand all and Export sit in the header. Expenses are shown as negative numbers, so the bottom line is every category added together.
How to scan it
- Read the % of Revenue from Sales column, top to bottom. The amounts move with the length of your date range; the percentages don't.
- Expand Fees and Cost of Advertising. Those two are the deductions you can actually change.
- The line that matters: an expense whose percentage grew while Revenue from Sales held flat. That is money leaving without more sales arriving.
For what every line item contains, see the line-by-line breakdown.
Filters
Moving the date range is the only way to compare anything on this page. Nothing else here changes a number.
Previous period is decorative on this page. Neither table carries a change column, so setting a comparison changes nothing you can see. Compare by moving the date range instead.
Both buttons sit at the top right. Only Date Range reaches these two tables.
There is no Filters button. Country, customer type and order source are Shopify filters and don't reach Amazon.
Watch out for
Settlement dates, not order dates. This is the single reason most figures here won't line up with anything else you have. Compare a long range against a long range, never one week against another.
An empty-looking range may be correct. A few days can fall between two settlements and legitimately show almost nothing. Widen the range before treating it as broken.
COGS is the only number Amazon doesn't give you. It comes from what you typed into Cost Settings, matched to the cost that was in effect on the settlement date. Everything else on the page is Amazon's own figure.
Amazon Summary counts a different thing. That page counts orders on the day they were placed. This one counts settlement lines on the day Amazon settled them. They lead and lag each other; they do not reconcile.
Do this first
Clear the COGS warning. Then sort Products Settlements by Net Sales and read %COGS across the top five rows — that is where most of your payout, and most of your missing cost, is sitting.
See yoursYour settled sales by SKU, and the statement behind the payout.
Open Amazon P&L →