Overview
Sellercloud automatically generates a Profit & Loss for each individual order after it is shipped. This allows you to focus on the order's bottom line and evaluate its income.
Access Profit & Loss on an Order
To get aggregated Profit and Loss data for an individual order, follow the steps below.
Go to Orders > Manage Orders.
Open the order for which you want the Profit & Loss report to display.
Click Toolbox and select Profit & Loss.
Profit and Loss Data
Order Profit and Loss data is generated after the order is fully shipped. Due to this, if you open the profit and Loss tab of your order, you will see the panel name includes (Estimated), which disappears once the order is Completed. To review and manage Profit and Loss values for an individual order, follow the steps below and click the respective article links for more detailed instructions.
On the Profit and Loss panel, click the requested value to get details or update information.
When changed, select ReCalculate Order Cost from the Actions menu to refresh the report. For more information, refer to Order Item Cost Regeneration.
See the definition of each parameter in the P&L report according to the table below.
PARAMETER |
DEFINITION |
Item Cost |
Displays the items' cost when products were purchased from vendors. This is managed by the Order Profit & Loss Calculated Using client setting. Click the value to update the item cost of each product*, if needed. *The calculation can be based on the product's Site Cost, Average Cost, or Last Cost. To get more information on Item Cost Calculation, go to Order Item Cost Calculation. |
Posting Fee |
Displays the eBay listing fee amount. |
Commission |
Displays the dollar amount the channel receives from the sale proceeds. To change, click the value and enter the requested values in the Final Value Fee fields. |
Transaction Fee |
Reflects costs associated with processing payments (e.g. PayPal fee) |
Shipping Cost |
Displays the amount you paid to ship an item to a customer, regardless of whether a customer paid for shipping. The calculation can be based on the info sent by a carrier, or the results of a Settlement report. For more information on Order Shipping Costs, go to Import Shipping Costs. |
Tax |
Displays the Tax Amount paid on the order. |
Promotion |
The amount the company has spent on order (component products) promotion. |
Rebates |
Reflects Vendor Rebates. The Order Cost is reduced by rebates which are configured on the product’s detail page. |
Order Cost |
Displays the total amount across all the Order Costs. |
Payments |
The total amount a customer has paid for an order including Shipping. |
ROI |
This will only display on Shipped orders. Return On Investment is calculated by (Profit / Order cost) * 100 |
Estimated Profit |
The expected profit value for the order Refer to Order Profit Calculation – Cash vs Accrual for more information on building P&L reports based on the Accounting Basis selected. |
* If the Client Setting is adjusted to use the Average Cost, but its value is zero, then Site Cost is used instead.
Order Profit Details
The Order Profit Detail table represents the profit for each product in the selected order. The report is built on the transaction records of the associated payments.
Columns with Unit refer to a single product unit value. Columns with Site refer to all units of that product across the order.
PARAMETER |
DEFINITION |
SKU |
The SKU of the product added to an order. |
Qty Sold |
The number of units of a particular product added to an order. |
Unit Cost |
Cost of a single product unit in the order (defined upon purchasing). |
Unit Price |
The customer’s price for a single product unit. |
Product Cost |
The current cost of a product. |
Site Cost |
Cost of all units in the order (defined when each unit was purchased). |
Selling Price |
Current price of a product. |
Refund |
Total Refund Amount by order item. |
Commission |
The amount the channel receives from the sale of the ordered item. |
Trans. Fee |
Payment processing fee. |
Final Cost |
Total amount spent for all items in the order. |
Profit |
Profit for an order by a certain item (dollar value). |
Profit, % |
Profit for an order by a certain item (percentage-value). |
Related Client Settings
To access these settings, go to Settings > Client Settings > General Client Settings > Advanced.
CLIENT SETTING |
DEFINITION |
Order Profit & Loss Calculated Using |
Use this parameter to determine which item cost to pull into the Profit & Loss report. |
Enable adjustments in P&L |
Allows you to manually add adjustments to the order. |