P&L Summary Report

Introduction

This standard report sums all orders, and shows profit and loss ($ value). Only orders that were shipped or paid are included in the  P&L Summary Report. The dates used refer to the Ship Date.  
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 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.

See answers to frequently asked questions about reports. 


Understanding the P&L Summary Report in SellerCloud

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

Understanding the P&L Summary Report on the exported spreadsheet

Column 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?