Profit by Order Summary

This report shows Profit and Loss (P&L) by summarizing order transactions made on a specific date, or range of dates, for a channel, company, manufacturer, product type, or product vendor.

To access this report, click Reports > Transaction Reports > Profit by Order Summary.

Take a look at a sample grid report summarized by channel:

For the report showing each individual order's profit and loss, see the Profit by Order Details report. You can open this version right from the summary, and then drill down even further into each order.

To see profit and loss based on Ship Date, run the P&L Reports.

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 typical example of both.)

After clicking Run Report, 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 the 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.

*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

  • 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 the starting and ending dates. (If you chose a default date range, these auto-populate.)

Summarize by

Choose how to summarize profit in the report. Your choice will determine the report's first column.

  • Channel
  • Company
  • Manufacturer
  • Product type
  • Product vendor

Purchaser (Buyer)

Include only the products belonging to one purchaser, 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.

A settlement is a channel's order-related fees, commissions, and taxes. Currently, this filter works for Amazon/FBA, eBay, and Newegg 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.

Order #

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

  • For a specific order number - Enter the number and click Run Report.
  • For multiple order numbers - Click the Order # List, then enter or copy/paste multiple order numbers on separate lines, then click Select Orders to populate the Order# box, and then click Run Report.
  • For all order numbers in your date range - Leave this field blank and click Run Report.

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.

Orders Status toggle

Include Amazon and FBA orders in one of two ways:

  • All Orders - Shows profit for all orders regardless of settlement status.
  • Settled - Shows profit only for orders that have settlement data.



About the grid data

Here's a sample grid report summarized by channel. 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

Channel, Company, Manufacturer, Product Type, or Vendor


Shown based on your Summarize By filter: Channel name, company name, manufacturer, product type, or product vendor.

Orders*

Total number of orders.

*Only shown if you summarize by Channel or Company.

Qty Sold

Total quantity of items sold.

Qty Returned

Total quantity of items returned.

Subtotal

Total amount of the items before shipping, discounts, tax, etc.

Shipping

Amount the buyer paid for shipping on the order.

Tax

Amount the buyer paid for tax on the order. Refunds on tax are also included.

Other Charges

Total of handling, insurance, gift wrap, discount, and shipping discount.

Grand Total*

Total amount of the order.

Grand Total calculation: (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 amounts 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. Includes refunded costs.

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

The cost for outbound shipping. Includes refunds on shipping cost.

  • For FBA - This includes the following types of fees: FBA Per Unit Fulfillment Fee, FBA Weight Based Fee, FBA Per Order Fulfillment Fee, Shipping Chargeback, Gift Wrap Chargeback, and Cross-Border Fulfillment Fee.

Commission

Channel selling fees. Includes refunds on commission 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.

Profit

Will be 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.

Below is part of a sample spreadsheet trimmed for display purposes (or see one with all columns):

The table below defines each of the columns.

COLUMN

DESCRIPTION

Channel or Company ID*

Unique identifier for a channel or company within SellerCloud.

*Only shown in the spreadsheet if you summarize by channel or company, respectively.

Channel, Company, Manufacturer, Product Type, or Vendor


Shown based on your Summarize by filter: Channel name, company name, manufacturer, product type, or product vendor.

Orders*

Total number of orders.

*Only shown if you summarize by channel or company.

Qty Sold

Total quantity of items sold.

Qty Returned

Total quantity of items returned.

Subtotal

Total amount of the items before any shipping, discounts, tax, etc.

Shipping

Amount the buyer paid for shipping on the order.

Tax

Amount the buyer paid for tax on the order. Refunds on tax are also included.

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*

Total amount of the order.

Grand Total calculation: (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 in reports 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.

Watch how SellerCloud calculates item cost.

Items Rebate

Incentive amount the vendor reimburses for a product's promotion.

Shipping Cost

The cost for outbound shipping. Includes refunds on shipping cost.

  • For FBA - This includes the following fee types: FBA Per Unit Fulfillment Fee, FBA Weight Based Fee, FBA Per Order Fulfillment Fee, Shipping Chargeback, Gift Wrap Chargeback, and Cross-Border Fulfillment Fee.

Commission

Channel selling fee.

Transaction Fee

Paypal processing fee.

Posting Fee

eBay listing fee and Reverb bump fee.

Dropship Fee

Vendor dropship fee.

Co-Op 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).

Cash Profit* or Accrual Profit**

  • Cash Profit - Based on the Payment amount of an order.
    Cash Profit calculation: Payment - (Refunds + Item Cost + Total Fees).
    *Only shown if you set the filter's Profit Calculation toggle to Cash.

  • Accrual Profit - Based on the Grand Total amount of an order.
    Accrual Profit calculation: Grand Total - (Refunds + Item Cost + Total Fees).
    **Only shown if you set the filter's Profit Calculation toggle to Accrual.

Cash Profit Margin* or Accrual Profit Margin**

  • Cash Profit Margin calculation: ((Payments - Refunds) - (Order Cost Total + Adjustments)) / (Payments - Refunds)) * 100.
    *Only shown if you set the filter's Profit Calculation toggle to Cash.

  • Accrual Profit Margin calculation: ((Sum(Grand Total) - (Order Cost Total + Adjustments)) / (Sum(Grand Total)) * 100.
    Note: Sum(Grand Total) = Order Grand Total - Return Grand Total.
    **Only shown if you set the filter's Profit Calculation toggle to Accrual.


How did we do?