The Order report gives you the full breakdown of every sale as it actually happened. You can see each order number, items sold, the price, all fees, refunds, and any adjustments made. This makes it simple to trace where numbers in your profit and loss come from and confirm that everything is accurate.
To open the report, go to Reports, then Sales, then Order P&L Report.
What you'll see
All transactions from the marketplace
Order Date, Posted Date, and Shipped Date
Order numbers, adjustment types, and all fees, including shipping fees from third parties such as ShipStation
Cost of Goods Sold (COGS)
Fees display
Fees show in the "Fees" column on the report page. Hover over the tooltip to see a breakdown of each fee.
Exporting the report
Click Export at the top right of the table to export all data to Excel. The Excel file gives you even more detail:
Each fee becomes a separate column
The "Adjustment Description" column gives a detailed explanation
You can review complete P&L data per order
Filtering options
Click the "Filter" button to narrow your view by SKU, ASIN, Order #, CB ID and Tags. You can also filter by Fulfillment and Order Type.
You can also run the report by Order Date, Shipped Date or Posted Date. Pick this under "Transaction Date" inside the date picker. This option shows only when order syncing is on for your account.
You can also filter the report by store and by transaction type, like orders or refunds.
If you choose to view the report by adjustments, hover over each adjustment to see the description.
Excel download limit
The Excel export supports up to 75,000 rows. To include all your data, make the date range smaller.
Frequently asked questions
Where do I find the Order report?
Go to Reports, then Sales, then Order P&L Report.
How do I see each fee on its own?
Hover over the tooltip in the "Fees" column, or click Export. In Excel, each fee becomes a separate column.
Can I run the report by ship date?
Yes. Open the date picker and choose Shipped Date under "Transaction Date". You can also pick Order Date or Posted Date. This option shows only when order syncing is on for your account.
Why is my Excel file missing rows?
The Excel export supports up to 75,000 rows. Make the date range smaller to include all your data.