Requirement: Using this workflow requires choosing the new client setting "Include FBA Inbound Shipping Costs in Profit by Product reports." This disables the client setting "Include FBA Inbound Shipping Costs in Order Item P&L," removing the option to apply the shipping costs as an adjustment on the orders from the FBA inbound shipment's Action menu.

This report shows profit and loss for SKUs by summarizing their order and/or non-order transactions on your selected date or date range:

Order transactions - These are debits (sales and payments, etc.) and credits (returns and refunds, etc.)

Non-order transactions - Sources can include:

Product-related transactions from the Amazon and eBay settlement reports

Non-order transactions only appear if you choose "Transaction" as the Date Type filter.

To access this report in Sellercloud, click Reports, then either:

P&L Reports > Product Profit Summary; OR

Transaction Reports > Profit by Product Summary

Take a look at a sample grid report you can expand by SKU to see each one's transaction details:

For the report showing an individual SKU's profit and loss by debit or credit on a specific date or range, see Profit by Product Details. You can also open this version right from the summary by clicking any SKU, and then drilling down even further into the order and the product.

For answers to general questions about using Sellercloud's Financial Reporting Suite, see the Reports FAQs.

Choose your filters

There are numerous filters to include the data you want in your report. (Most filters offer single-choice and multiple-choice fields. See a generic example of both).

After clicking Run Report to show these transactions, you can see which filters you applied. If a filter is not shown, you left it blank or chose All. Here's a common report filter.

The table below defines each of these filters:

FILTER

DESCRIPTION

Company

Include only the orders from one or more companies, or include orders from all companies.

Company Groups*

Include only the orders from one group of companies, or include orders from all companies.

*This filter is only shown if you enabled the company group setting and grouped companies together. Here's how.

Channel

Include only the orders from one or more sales channels, or include orders from all channels.

Date Range

Custom (default) - Enter the Start and End Dates. For a single date, choose the same Start and End Date.

Date ranges (presets) - There are 22 choices from Yesterday to the Last Year to Date.

Start Date and End Date

If you chose a custom date range, choose starting date and ending date. (If you chose a default date range, these auto-populate.)

Date Type

Have orders, and their associated activity, reflected in one of 3 ways:

By transaction date - View all order activity that occurred within your selected date range. Note: This will use the ship date for sales (debit) transactions.

By ship date - View all orders and their associated activity where ship date is in your selected date range.

By order date - View all shipped orders and their associated activity where order date is in your selected date range.

Purchaser (Buyer)

Include only the products belonging to one or more purchasers, or include all products.

Product Type

Include only the products belonging to one product type, or include all products.

Product Group

Include only the products belonging to one product group, or include all products.

Vendor

Include only the products belonging to one vendor, or include all products.

Note: For dropship orders, this will be the vendor that the products were actually purchased from.

Manufacturer

Include only the products belonging to one manufacturer, or include all products.

Brand

Include only the products belonging to one ​brand​​, or include all products.

Settlement ID*

Include orders with specific settlement IDs. Currently, this filter works for Amazon/FBA, eBay, Newegg, and Walmart Marketplace settlements. This field has 3 options:

For one Settlement ID - Enter a specific Settlement ID and click Run Report

For all Settlement IDs in your date range - Leave this field blank and click Run Report

For a list of 20 most recent IDs - Click Search

*Only appears if choosing "Transaction" as the Date Type filter.

SKU

Note: This filter is dependent on the Show Products by Original (Shadow) SKU setting. If you check that box, the report shows original orders' shadow SKUs; if you uncheck that box, the report shows orders' parent SKUs.

For one SKU - Enter a specific SKU and click Run Report.

For all SKUs in your date range - Leave this field blank and click Run Report.

To enter multiple SKUs - Click SKU List, then enter or copy/paste multiple SKUs on separate lines, then click Select Products to populate the SKU box, and Run Report.

Order #

Include orders by order number. This field has 3 options:

For one order number - Enter the number and click Run Report.

For all order numbers in your date range - Leave this field blank and click Run Report.

For multiple order numbers - Click Order # List, then enter or copy/paste multiple order numbers on separate lines, then click Select Orders to populate the Order# box, and Run Report.

Show Products by Kit Component SKU

For kit products, show the kits' component SKUs. Otherwise, the kits' parent SKUs are shown by default.

Note: This works for all kit types.

Show Products by Original (Shadow) SKU

For shadow products, show the original orders' shadow SKUs. Otherwise, the orders' parent SKUs are shown by default.

Profit Calculation toggle

Calculate profit in one of two ways:

Cash - Shows profit based on Payment of the orders.

Accrual - Shows profit based on Grand Total amount of the orders.

Note:If you choose Cash Profit, you can still see each individual order's Accrual Profit by opening the order and hovering over Cash Profit on the P&L tab, and vice versa.

*Only shown if you set the filter's Profit Calculation toggle to Accrual.

Refunds*

Total refund amount from orders.

*Only shown if you set the filter's Profit Calculation toggle to Cash.

Adjustments

Adjustment amounts, either positive or negative, to orders.

Items Cost

Cost of the items on the order.

Items Cost is based on A) The item cost on the Order Date, and B) The method used to calculate cost, which is determined by the Client Setting Order Profit & Loss Calculated Using (either Average Cost, Site Cost, or Last Cost). Includes refunded costs. Here's how P&L is calculated and tracked on an order.

About the spreadsheet data

Exported spreadsheets include more data than the grid report. Spreadsheets also let you manipulate data, such as filter within a column, sort with advanced parameters, etc. You can even create custom bar graphs and pie charts; for example, to show daily sales trends for a selected date range.

The spreadsheet version also features 2 tabs:Tab 1 - "Report Table" is the collapsed version. Show me.Tab 2 - "Report Table Expanded" is the expanded version with one line for each item per transaction type. Show me.

*Only shown if you set the filter's Profit Calculation toggle to Accrual.

Payments

Actual amount the buyer paid (usually the same amount as Grand Total unless there was an underpayment or overpayment).

Refunds

Total refund amount from orders.

Adjustments

Adjustment amounts, either positive or negative, to orders.

Items Cost

Cost of the items on the order.

Items Cost is based on A) The item cost on the Order Date, and B) The method used to calculate cost, which is determined by the Client Setting Order Profit & Loss Calculated Using (either Average Cost, Site Cost, or Last Cost). Includes refunded costs. Here's how P&L is calculated and tracked on an order.