P&L Order Details

Updated 3 weeks ago

There's a brand new topic available about this newly combined report. Check it out!

General Info

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

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 are included in the Profit and Loss report. 
    • Note: Amazon orders that are unshipped, but that have settlement data, will be included in the report (Amazon orders without settlement data will not be included).
  • 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 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. 

How to read the P&L Detail Report In SellerCloud

On-Screen Field Name

Description

Order ID

SellerCloud's unique Order Identification

Source Order ID

The channels unique Order Identification

Order Date

The date the order was placed

Ship Date

The date the order shipped

Channel

The order source name

Posting Fee

Posting fees from orders

Commission

Commission fees from orders. Refunds on Commission fees are also included

Shipping Cost

The 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

Tax

The amount of tax collected on the order. Refunds on Tax are also included.

Trans. Fees

Transaction fees from orders. PayPal fees are included here

Items Cost

The 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.

Payment

The actual amount the customer paid. Usually, this will be the same amount as GrandTotal.
Note: Shows only when running Cash Profit

Grand Total

The total of the order. GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount).
Note: Shows only when running Accrual Profit

Refunds

Total refunds amount from orders

Adjustment

Adjustment amounts from orders. This can be a positive adjustment or a negative adjustment

Total Cost

Total cost on the order. TotalCost = (ItemCost + Commission + ShippingCost + PostingFee + TransactionFee + Tax + PromotionCost) - (Adjustment + Rebate). Refunded costs are also included.

Cash Profit

Based on Payment amount of an order (the actual amount the buyer paid). 
Calculation: (Payment - Refunds) - (Item Cost + Total Fees) + Adjustments.

Note: Shows only when running Cash Profit.

Accrual Profit

Based on Grand Total amount of an order, so you can see profit for orders that haven't been paid. 
Calculation: Sum(Grand Total) - (Item Cost + Total Fees) + Adjustments.
Note: Sum(Grand Total) = Order Grand Total - Return Grand Total. 

Note
: Shows only when running Accrual Profit.


How to read the P&L Detail Report In the Exported Sheet


Excel Export Field Name

Description

OrderID

SellerCloud's unique Order Identification

SalesRep

The first Sales Representative listed on the order

SalesRep2

The second Sales Representative listed on the order. Enable client setting "Enable Multiple Sales reps" to populate this field.

WholesaleCustomer

Wholesale customer, Business name

OrderSourceOrderID

The channels unique Order Identification

OrderDate

The date the order was placed

ShipDate

The date the order shipped

OrderSource

SellerCloud's unique Channel Identification

OrderSourceName

Channel name

PostingFee

Posting fees from orders

Commission

Commission fees from orders. Refunds on Commission fees are also included.

DropShipFee

A Vendor Fee for DropShipping the products directly to the customer

TransactionFee

Transaction fees from orders. PayPal fees are included here.

ShippingCost

The 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

Shipping

The amount the customer paid for shipping, on the order

Tax

The amount of tax collected on the order. Refunds on Tax are also included.

ItemsCost

The 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.

GrandTotal

The total of the order. GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount)

Payments

The actual amount the customer paid. Usually, this will be the same amount as GrandTotal

Refunds

Total refunds amount from orders

Adjustment

Adjustment amounts from orders. This can be a positive adjustment or a negative adjustment

TotalCost

Total cost on the order. TotalCost = (ItemCost + Commission + ShippingCost + PostingFee + TransactionFee + Tax + PromotionCost) - (Adjustment + Rebate). Refunded costs are also included.

Cash Profit

Based on Payment amount of an order (the actual amount the buyer paid). 
Calculation: (Payment - Refunds) - (Item Cost + Total Fees) + Adjustments.

Note: Shows only when running Cash Profit.

Accrual Profit

Based on Grand Total amount of an order, so you can see profit for orders that haven't been paid. 
Calculation: Sum(Grand Total) - (Item Cost + Total Fees) + Adjustments.
Note: Sum(Grand Total) = Order Grand Total - Return Grand Total. 

Note
: Shows only when running Accrual Profit.

FBAPickAndPack

Total FBA "PickAndPack" fee on orders

FBAWeightHandling

Total FBA "WeightHandling" fee on orders

FBAOrderHandling

Total FBA "OrderHandling" fee on orders


How did we do?