The Profit & Loss (P&L) report shows how much money each product makes after fees, ads and costs.
The columns you see
Column | What it means |
Item | The product. |
Sales Qty | Units sold. |
Refund Qty | Units refunded. It shows as a negative number. |
Sales | Money from sales, before refunds. |
Refunds | Money refunded. |
Fees | All marketplace fees added together. It shows as a negative number. |
Ad Spend | What you spent on ads for this product. It shows as a negative number. |
Cost | What the units that left your stock cost you. |
Cost Per Item | Cost ÷ Total Units. |
Sale Price | Average price per unit: Sales ÷ Sales Qty. |
Profit | Net Sales minus Fees, Ad Spend and Cost. If you tick Exclude Advertising, Ad Spend is left out. |
Profit Per Item | Profit ÷ Total Units. |
Ad Sales (14 Days) | Sales from ads, up to 14 days after the click. |
ACOS | Ad Spend ÷ Ad Sales (14 Days). |
ROI | Profit ÷ Cost. |
Profit Margin % | Profit ÷ Net Sales. |
Return Rate | Refund Qty ÷ Sales Qty. |
Sessions, Conversion Rate, Buy Box % | Amazon traffic numbers for the product. Amazon stores only. |
% Of Sales | This product's share of your total Net Sales. |
Qty vs Units
The report counts items in 2 ways:
Qty is what happened on paper: what was sold or refunded.
Units is what moved in your stock: what left your shelf or came back.
For example, 10 items are refunded, but only 7 come back to your stock. Refund Qty counts 10 refunds (shown as a negative number), and 7 units go back to inventory.
That's why Sales Qty and Total Units can be different. Profit Per Item uses Total Units, because it's about real stock.
More columns you can add
Click Columns at the top right of the report and tick the columns you want, such as:
Net Sales: Sales minus refunds, plus or minus adjustments.
Total Units: units that actually moved in or out of your stock.
TACOS: Ad Spend ÷ Sales.
Organic Sales: Sales minus ad sales from the same day. Amazon stores only.
Ad Sales (same day), Ad Sales 7 Days and Ad Sales Same SKU.
Each fee on its own: every fee type can be its own column.
See "Customizing Reports with the Column Chooser".
See the details of a product
Click the + next to a product. You'll see 4 tabs:
Financial Transactions: the Qty side (sales, refunds and adjustments).
Ads: each ad cost.
Fees: each fee.
COGS Transactions: the Units side (what moved in your stock).
To see every fee for a product, open the Fees tab.
Good to know
Some fees can't be matched to 1 product. They show as unitemized fees. See "Unitemized Fees Explained".
You can drag column headers to reorder them. To filter the report, see Advanced Filters and Customization for the P&L report.
Frequently asked questions
Where's the Net Sales column?
It's hidden by default. Click Columns and tick Net Sales.