Reports (profit & loss)

See revenue, costs, fees, returns and true profit by SKU, ASIN or order for any date range, and drill into any item.

What it's for

Reports is your profit and loss (P&L) report. For any date range it shows, per SKU, ASIN or order: units, orders, revenue, cost of goods, marketplace fees, shipping, return costs and the profit and margin left over. Account-level costs that can't be split per item (such as advertising and storage fees) are included in the total, so the bottom line is your true profit.

Where to find it

Sidebar → Accounting & Reports → Reports. You need the financials permission.

Reports is an add-on. If it isn't turned on for your company yet, the page shows an Unlock the Reports add-on screen; Activate turns it on, Not now closes the screen.

The screen at a glance

Toolbar

• Date range — Today, Yesterday, Last week (Sun–Sat), Last month, Last 7 / 30 / 90 days, Last year, Week to date, Month to date, Year to date, or Custom range… (pick a first and last day on a two-month calendar).
• Date basis:
• By order date — when the buyer ordered. Has an Include open orders tick box for orders not yet shipped.
• By ship date — when the order shipped.
• By posted date (settled) — when the marketplace posted the money.
• Group — SKU, ASIN or Order.
• Stores — All stores, Amazon or Walmart.
• Sort — Revenue, Profit (best or worst first), Units, Orders, COGS, Return cost or SKU A–Z.
• Run report, Columns, Export.

Columns

• Item (always shown) — product photo, SKU (or ASIN / order), title and UPC, each with a copy button. A search box in the header finds a SKU, ASIN or title.
• Vendors — one letter per vendor that supplies the item. Green = in stock, red = out of stock.
• Units, Orders, Net revenue, Gross and Tax (hidden by default), COGS (cost of goods), COGS / unit, Referral (marketplace commission), Other fees, Ship paid (postage you paid), Ship charged (shipping the buyer paid), Returns (count, red when above zero), Return cost, Cost / return, Total cost, Cost / order, Profit, Profit / unit, Margin.

Profit and margin are green when positive and red when negative. Click any column header to sort by it; click again to flip the order.

Unidentified fees & misc.

A row above the Total collects money that belongs to the whole account rather than one item: Amazon advertising, subscription, storage, adjustments, coupons and so on; return credits from vendors; and purchases made on a vendor's website without a purchase order. The Total row includes it.

Buttons and actions

How to see which products make money

1. Pick a Date range, for example Last 30 days.
2. Leave Group: SKU and All stores.
3. Choose Sort: Profit ↓ for the best first, or Profit ↑ (worst first) to find losers.
4. Click an item to see every order behind it.

How to drill into one item

1. Click the item in the report.
2. Orders tab — totals (orders, units, revenue, ship paid, COGS, return cost, profit, margin) and one line per order. Orders with a return are highlighted in red.
3. Purchased by vendor tab — each vendor you bought this item from in the range: number of POs, units ordered, received and invoiced, cost per unit and total paid, and the first and last PO date. Click a vendor to list its POs.
4. Click ✕ to close.

How to see account-level fees

1. Click the Unidentified fees & misc. row above the Total.
2. Each line shows its source, what it is and the amount, with the net at the bottom.
3. Click a line to see the individual postings or invoices behind it.

How to export the report

1. Run the report you want.
2. Click ⬇ Export. A CSV file downloads with the rows on screen.

Tips and troubleshooting

• "No data in this range" — try a wider range or a different store.
• By posted date and By ship date can't see orders that haven't shipped, so Include open orders only matters with By order date.
• Searching for a SKU hides the account-level fees row, because those fees belong to the whole account.
• Your column choices are saved in your browser, so they come back next time on the same computer.