P&L Order Summary

Updated 3 weeks ago

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

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 Name

Description

Company

Company name

No. Orders

Number of orders

Units Sold

Total of units sold

Posting Fee

Posting Fees from orders

Commission

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

Trans. Fee

Transaction fees from orders. PayPal fees are included here

Shipping Cost

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

Tax

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

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

Payments

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

Adjustments

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

This is based on the Payment of the order:  (Payment - Refunds) - (Item Cost + Total Fees) + Adjustments.
Note: Shows only when running Cash Profit. 

Accrual Profit

This is based on the Grand Total amount of the order:  Sum(GrandTotal) - (Item Cost + Total Fees) + Adjustments.
Note: Sum(Grand Total) = Order Grand Total - Return Grand Total. 
Note: Shows only when running Accrual Profit.


Understanding the P&L Summary Report on the exported spreadsheet

Column Name

Description

Company ID

SellerCloud's unique Company Identification

Name

Company name

numOrders

Number of orders

Units Sold

Total of units sold

Posting Fee

Posting Fees from orders

Commission

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

Transaction Fee

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

Tax

The amount of tax collected on the order. Refunds of 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.

Payments

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

Adjustments

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

This is based on the Payment of the order:  (Payment - Refunds) - (Item Cost + Total Fees) + Adjustments.
Note: Shows only when running Cash Profit. 

Accrual Profit

This is based on the Grand Total amount of the order:  Sum(GrandTotal) - (Item Cost + Total Fees) + Adjustments. 
Note: Sum(Grand Total) = Order Grand Total - Return Grand Total. 
Note: Shows only when running Accrual Profit.


How did we do?