Profit by Product Details
Here's how it looks in this report. This same feature is also available for the Profit by Product Summary.
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 each SKU's order and 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
- FBA disposal fees from the FBA Removal Shipment Order report
- New! FBA inbound shipping costs (see note at top)
- Product fees for Amazon's sponsored ads' per-day "Spend" (if imported from Seller Central's Sponsored Products Ad report)
To access this report in Sellercloud, click Reports, then either:
- Transaction Reports > Profit by Product Details; OR
- P&L Reports > Product Profit Details
Take a look at a sample grid report with each SKU's transaction details:
For the report summarizing SKUs' order and non-order transactions on your selected date or date range, see Profit by Product Summary.
Choose your filters
There are numerous filters to include the exact 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 each specific filter 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 | FILTER DESCRIPTION |
Company | Include only the orders from one or more companies, or include orders from all companies. |
Company Groups* | Include orders from only 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. Learn how. |
Channel | Include only the orders from one or more sales channels, or include orders from all channels. |
Date Range |
|
Start Date and End Date | If you chose a custom date range, choose the starting and ending dates. (If you chose a default date range, these auto-populate.) |
Date Type | Have orders, and their associated activity, reflected in one of 3 ways:
|
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, Jet, eBay, Newegg, and Walmart Marketplace settlements. This field has 3 options:
*Only appears if choosing "Transaction" as the Date Type filter. |
SKU | Note: For shadow products, this filter is dependent on the Show Products by Original (Shadow) SKU setting. If checked, the filter uses the original orders' shadow SKUs; if unchecked, the filter uses the orders' parent SKUs.
|
Order # | Include orders by order number. This field has 3 options:
|
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:
Note: If you choose Cash Profit, you can still see each order's Accrual Profit by opening the order and hovering over Cash Profit on the P&L tab, and vice versa. |
Orders Status toggle | Include Amazon/FBA orders in one of two ways.
|
About the grid data
Take a look at a sample grid report:
You can export this report to a spreadsheet with additional data by clicking the Export to Excel icon. For more details, see About the spreadsheet data.
The table below defines each of these columns:
COLUMN | DESCRIPTION |
Trans Date | The date the transaction occurred. |
Trans Type |
|
SKU* | Unique stock keeping unit (SKU) code assigned to the product. *For shadow products: This is the parent SKU; whereas, this is the original shadow SKU if Show Product by Original (Shadow) SKU is checked. |
Order # | Unique order identification number in Sellercloud. Click the # to open the order, see its details, and choose an action. |
Channel Order # | Unique order number from the channel. |
Order Date | Date the order was placed. |
Ship Date | Date the order was shipped. |
Qty | Total quantity of items sold. |
Subtotal | Total amount of the items before any discounts, shipping, tax, etc. |
Shipping | Amount the buyer paid for shipping on the order. |
Tax | Amount the buyer paid for tax on the order. |
Other Charges | Total of handling, insurance, gift wrap, discount, and shipping discount. |
Grand Total | Total amount of the order. Grand Total = (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) - (Discount + Shipping Discount). *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). *Only shown if you set the filter's Profit Calculation toggle to Cash. |
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). Here's how P&L is calculated and tracked on an order. Watch how Sellercloud calculates item cost. If the cost of an item on an order is manually changed, follow these steps to have the updated cost reflected in the order's profit and loss. |
Shipping Cost | Cost for outbound shipping.
|
Commission | Channel selling fees. |
Total Fees | Total of shipping cost, commission (channel selling fee), transaction fees (Paypal processing fee), posting fees (eBay listing fee and Reverb bump fee), dropship fees, co-op fees, and tax payable. |
Other Channel Fees | Non-order-related transaction fees, including:
|
Profit | Either Cash Profit or Accrual Profit based on your filter toggle. |
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.
Take a look at a sample spreadsheet report.
The table below defines each of these columns:
COLUMN | DESCRIPTION |
Transaction Date | Date the transaction occurred. |
Trans Type |
|
Order # | Unique order identification number in Sellercloud. |
Order Date | Date the order was placed. |
Ship Date | Date the order shipped. |
Channel | Source of the order. |
Channel Order # | Unique order number from the channel. |
Channel Order # (2) | The second unique order number from the channel. |
Settlement ID | ID for Amazon/FBA, eBay, and Newegg settlements. |
Company | Company name. |
SKU* | Unique stock keeping unit (SKU) code assigned to the product. *For shadow products: This is the parent SKU; whereas, this is the original shadow SKU if Show Product by Original (Shadow) SKU is checked. |
Original Shadow SKU* | The original orders' shadow SKU. *Only shown if the Show Products by Original (Shadow) SKU filter is unchecked. |
Parent SKU* | The orders' parent SKU. *Only shown if the Show Products by Original (Shadow) SKU filter is checked. |
Product Name | Name of the product. |
Product Type | Category associated with the product. |
Vendor | Vendor associated with the product. |
Manufacturer | Manufacturer associated with the product. |
Brand | Brand associated with the product. |
ASIN | Amazon Standard Identification Number. *Only populated if your Channel filter includes Amazon. |
Ship From Warehouse | Warehouse from which the product shipped. |
Sales representative assigned to the order. | |
Sales Rep (2)* | Secondary sales representative. *Only shown if you select Enable Multiple Sales Reps in the Client Settings. |
Purchaser | Purchaser associated with the product. |
Qty | Total quantity of items sold. |
Unit Price | Price of a single item. |
Subtotal | Total amount of the items before any discounts, tax, shipping, etc. |
Shipping | Amount the buyer paid for shipping on the order. |
Tax | Amount the buyer paid for tax on the order. |
Handling | Amount the buyer paid for handling on the order. |
Insurance | Amount the buyer paid for insurance on the order. |
Gift Wrap | Amount the buyer paid for gift wrap on the order. |
Discount | Amount of discount applied to the order. |
Shipping Discount | Amount of discount applied to the shipping. |
Other Charges | Total of handling, insurance, gift wrap, discount, and shipping discount. |
Grand Total | The total amount of the order. Unlike the grid, this appears if the filter's Profit Calculation toggle is set to Cash or Accrual. Grand Total = (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) - (Discount + Shipping Discount). |
Payments | Actual amount the buyer paid (usually the same amount as Grand Total unless there was an underpayment or overpayment). Unlike the grid report, this appears whether you set the filter's Profit Calculation toggle to Cash or Accrual. |
Refunds | Total refunds amount from orders. Unlike the grid report, this appears whether you set the filter's Profit Calculation toggle to Cash or Accrual. |
Adjustments | Adjustments, 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). Here's how P&L is calculated and tracked on an order. Watch how SellerCloud calculates item cost. If the cost of an item on an order is manually changed, follow these steps to have the updated cost reflected in the order's profit and loss. |
Incentive amount the vendor reimburses for a product's promotion. | |
Shipping Cost | The cost for outbound shipping.
|
Commission | Commission fees from orders. |
Transaction Fee | Paypal processing fee. |
Posting Fee | eBay listing fee and Reverb bump fee. |
Vendor dropship fee. | |
Allowance fee from select channels. | |
Tax Payable | Tax payable portion of the order. |
Total Fees | Total of shipping cost, commission (channel selling fee), transaction fees (Paypal processing fee), posting fees (eBay listing fee and Reverb bump fee), dropship fees, co-op fees, and tax payable. |
Item Cost Total | Calculation: (Item Cost - Rebate) + Shipping Cost + Commission + Transaction Fee + Posting Fee + Dropship Fee + Co-Op Fee + Tax Payable). |
Other Channel Fees | Non-order-related transaction fees, including:
|
Accrual Profit | This is based on the Grand Total amount of an order. Accrual Profit calculation: Sum(Grand Total) - (Item Cost + Total Fees) + Adjustments + Other Channel Fees. Note: Sum(Grand Total) = Order Grand Total - Return Grand Total. |
Cash Profit | This is based on the Payment amount of an order. Cash Profit calculation: (Payment - Refunds) - (Item Cost + Total Fees) + Adjustments + Other Channel Fees. |
