Profit and Loss Detail Report

General Info

This is a more detailed version of the P&L report. In this report the P&L is displayed per order ($ value). 

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
  • Only orders that have been shipped or paid are included in the Profit and Loss report. 
  • The dates used refer to the Ship Date.  
  • 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.

How to read the P&L Detail Report In SellerCloud


On-Screen Field Name Description
Order IDSellerCloud's unique Order Identification
Source Order IDThe channels unique Order Identification
Order DateThe date the order was placed
Ship DateThe date the order shipped
ChannelThe order source name
Posting FeePosting fees from orders
CommissionCommission fees from orders. Refunds on Commission fees are also included
Shipping CostThe cost for outbound shipping. Refunds on Shipping Cost 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.
Trans. FeesTransaction fees from orders. PayPal fees are included here
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.
PaymentThe 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
AdjustmentAdjustment 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 Detail Report In the Exported Sheet


Excel Export Field NameDescription
OrderIDSellerCloud's unique Order Identification
SalesRepThe first Sales Representative listed on the order
SalesRep2The second Sales Representative listed on the order. Enable client setting "Enable Multiple Sales reps" to populate this field.
WholesaleCustomerWholesale customer, Business name
OrderSourceOrderIDThe channels unique Order Identification
OrderDateThe date the order was placed
ShipDateThe date the order shipped
OrderSourceSellerCloud's unique Channel Identification
OrderSourceNameChannel name
PostingFeePosting fees from orders
CommissionCommission fees from orders. Refunds on Commission fees are also included.
DropShipFeeA Vendor Fee for DropShipping the products directly to the customer
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
ShippingThe amount the customer paid for shipping, on the order
TaxThe amount of tax collected on the order. Refunds on 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.
GrandTotalThe total of the order. GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount)
PaymentsThe actual amount the customer paid. Usually, this will be the same amount as GrandTotal
RefundsTotal refunds amount from orders
AdjustmentAdjustment 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)
AccrualProfitCalculation: Profit = GrandTotal - (Refunds + ItemCost + TotalFees)
FBAPickAndPackTotal FBA "PickAndPack" fee on orders
FBAWeightHandlingTotal FBA "WeightHandling" fee on orders
FBAOrderHandlingTotal FBA "OrderHandling" fee on orders

How did we do?