P&L Summary Report

General Info

This is a standard report sums all orders and shows profit and loss ($ value). Only orders that have been shipped or paid are included in the Profit and Loss report. The dates used refer to the Ship Date.  
Please Note: These reports calculate the P&L of refunds etc to the ship date. To see P&L based on when the payment or refund occurred, use the Transaction Reports.

You can summarize by Channel, Company, Manufacturer, or Vendor.

  • Read how Item Cost is calculated here. The item cost in the reports is based on the cost of the item at the time of the order, and the method which was used to calculate the cost (Average, Last, or Site).
  • Read how P&L is calculated and tracked on an order here
  • If the item cost on an order gets changed manually, the reports will recalculate the order cost. A service will do this recalculation automatically.

Frequently Asked Questions About Reports


How to read the P&L Summary Report In SellerCloud

On-Screen Field NameDescription
CompanyCompany name
No. OrdersNumber of orders
Units SoldTotal of units sold
Posting FeePosting Fees from orders
CommissionCommission fees from orders. Refunds on Commission fees are also included
Trans. FeeTransaction fees from orders. PayPal fees are included here
Shipping CostThe cost for outbound shipping. Refunds on ShippingCost are also included. For FBA, it includes the following fee types: FBAPerUnitFulfillmentFee, FBAWeightBasedFee, FBAPerOrderFulfillmentFee, ShippingChargeback, GiftWrapChargeback and Cross-Border Fulfillment Fee
TaxThe amount of tax collected on the order. Refunds on Tax are also included
Items CostThe cost of the items on the order. Based on client setting "Order Profit & Loss Calculated Using: (Average Cost, SiteCost, LastCost)". Refunded costs are also included
PaymentsThe actual amount the customer paid. Usually, this will be the same amount as GrandTotal.
Note: Shows only when running Cash Profit
Grand TotalThe total of the order. GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount)
Note: Shows only when running Accrual Profit
RefundsTotal refunds amount from orders
AdjustmentsAdjustment amounts from orders. This can be a positive adjustment or a negative adjustment
Total CostTotal cost on the order. TotalCost = (ItemCost + Commission + ShippingCost + PostingFee + TransactionFee + Tax + PromotionCost) - (Adjustment + Rebate). Refunded costs are also included
Cash ProfitCalculation: Profit = Payment - (Refunds + ItemCost + TotalFees)
Note: Shows only when running Cash Profit
Accrual ProfitCalculation: Profit = GrandTotal - (Refunds + ItemCost + TotalFees)
Note: Shows only when running Accrual Profit

How to read the P&L Summary Report On the Exported Sheet

Excel Export Field NameDescription
CompanyIDSellerCloud's unique Company Identification
NameCompany name
numOrdersNumber of orders
UnitsSoldTotal of units sold
PostingFeePosting Fees from orders
CommissionCommission fees from orders. Refunds on Commission fees are also included
TransactionFeeTransaction fees from orders. PayPal fees are included here
ShippingCostThe cost for outbound shipping. Refunds on ShippingCost are also included. For FBA, it includes the following fee types: FBAPerUnitFulfillmentFee, FBAWeightBasedFee, FBAPerOrderFulfillmentFee, ShippingChargeback, GiftWrapChargeback and Cross-Border Fulfillment Fee
TaxThe amount of tax collected on the order. Refunds of Tax are also included
ItemsCostThe cost of the items on the order. Based on client setting "Order Profit & Loss Calculated Using: (Average Cost, SiteCost, LastCost)". Refunded costs are also included
PaymentsThe actual amount the customer paid. Usually, this will be the same amount as GrandTotal
Note: Shows only when running Cash Profit
GrandTotalThe total of the order. GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount)
Note: Shows only when running Accrual Profit
RefundsTotal refunds amount from orders
AdjustmentsAdjustment amounts from orders. This can be a positive adjustment or a negative adjustment
TotalCostTotal cost on the order. TotalCost = (ItemCost + Commission + ShippingCost + PostingFee + TransactionFee + Tax + PromotionCost) - (Adjustment + Rebate). Refunded costs are also included
CashProfitCalculation: Profit = Payment - (Refunds + ItemCost + TotalFees)
Note: Shows only when running Cash Profit
AccrualProfitCalculation: Profit = GrandTotal - (Refunds + ItemCost + TotalFees)
Note: Shows only when running Accrual Profit



How did we do?