New to the report? Start with Profit and Loss Report Explained.
Pick transaction types
By default, the P&L report includes everything: orders, refunds, adjustments and more. To see only some types, use the types dropdown at the top and pick the ones you want.
Customize
Click Customize at the top. You'll see these options.
Display Items By (what name each row shows):
SKU (the default)
Item ID (ASIN/GTIN)
Parent Asin: groups variations under their parent
QuickBooks Item Name, if a store tracks inventory in QuickBooks
ConnectStock Item, if you use ConnectStock
Group By (put rows into groups):
None, SKU, Asin or Parent Asin
Categories: the categories you gave your products
Fulfillment Channel: Marketplace (like FBA) or Seller (like FBM)
Buyers and Seasons
Store
Order Type: business orders vs standard orders
Gateway and Tags: for Shopify payment gateways and tags
Some Group By options change with Display Items By. With ConnectStock Item you can group by Store, Tags, Item Category, Brand, Manufacturer or Vendor.
Click a group row (or its + icon) to open it. Click it again to close it.
Transaction Date (which date to use):
Posted Date: when the marketplace posted the payment (often the ship date).
Order Date: when the customer placed the order.
Shipped Date: when the order shipped.
FBA orders usually post 1 or 2 days after they ship. FBM orders can take about a week. Business orders can take a month.
Currency: if you sell in other countries, view the report in another currency.
Cost Type (which cost to use):
Default Cost
QuickBooks Cost: the current average cost in QuickBooks.
QuickBooks Historical Cost: the average cost in QuickBooks at the time each order shipped, not just today's cost.
Both QuickBooks costs show only if a store tracks inventory in QuickBooks. See How ConnectBooks Handles Product Cost Changes in QuickBooks.
Manual Cost: the cost saved on your listings in ConnectBooks, including costs synced from SellerCloud or GoFlow.
ConnectStock Cost, ConnectStock Cost with Fallback and Item Cost, if you use ConnectStock.
If you see Sellercloud Cost or Goflow Cost, don't pick it. It doesn't use your synced costs. Use Default Cost instead.
Checkboxes:
Include Open Orders: add orders the marketplace hasn't posted yet, with estimated fees. Not available with Posted Date.
Exclude Advertising: ads still show, but don't count toward Profit, ROI or Profit Margin.
Include Estimated Storage: add Amazon's estimated FBA storage fees before the real charge posts.
Ignore Prep Cost: leave prep costs out.
Returns by Order Date: show returns on the original order date, not the return date. Only with Order Date.
Sort and filter columns
Click the search icon in the row under a column header to filter it. For example, pick "less than" on Profit and type 0 to find products that lose money.
To pick several products at once, click the filter icon next to the column header.
Choose your columns
Click Columns at the top right of the report to show or hide columns. See Customizing Reports with the Column Chooser.
Download
Click Export at the top right of the report to download it as an Excel file.
Save your setup
Save your filters as a template so you don't have to set them up each time. See Save and Update Report Templates.
Frequently asked questions
Include Open Orders is greyed out.
It doesn't work with Posted Date. Switch Transaction Date to Order Date or Shipped Date.
I don't see the Transaction Date choices.
They only show if your account syncs orders.
Can I make these my default?
Yes. Save a template and set it as default. Some, like Display Items By and Cost Type, can also be set in Default Settings.