Manage Profit & Loss (P&L)

Overview

The Manage P&L page allows you to view and manage various aspects of your Profit and Loss reports. You can perform actions such as:

• Exporting and importing P&L data.

• Configuring the types of non-order transactions included in P&L.

• Viewing details about recent settlements.

• Viewing P&L generation metrics.

Manage Profit & Loss

See the following sections to learn how you can use the Manage P&L page.

Export Profit & Loss

To export your orders’ P&L data to an Excel spreadsheet:

1. Go to Reports > Profit & Loss > Manage P&L.

2. Under the Export Profit and Loss section, select the Ship From Date and End Date.

3. Enter your Order #s.

4. Select whether you want to export Missing information. This option can help you identify eBay orders with a missing Item Cost, Payment, or Transaction Fee, as well as Amazon, FBA, eBay, Sears, or Newegg orders missing Commission.

5. Select your Channel from the dropdown menu. To include all channels, select ALL.
   
   

6. Click Export Report. If you have entered order numbers, the file will be downloaded to your device immediately. If you have left the Order #s field blank, a Queued Job will be generated. Click the Job # link to view it. When the job finishes, click the .xlsx file link next to Output File.

Import Profit & Loss

You can import the following extra costs to your orders in bulk:

• Commissions - Commissions owed to Sales Representatives. They appear as Commission on the Profit & Loss tab of the Order Details Page.

• Payment Fees - Transaction processing fees, such as charges by PayPal. They appear as Transaction Fee on the Profit & Loss tab of the Order Details Page.
  
  

To import additional costs to your orders:

1. Go to Reports > Profit & Loss > Manage P&L.

2. Under Import P&L, click the link This option has been moved to here to be redirected to the new page.
   
   

3. On the new page, select Commission or Payment Fee from the Partial Info dropdown menu.

4. Click Download Sample.

5. Enter your information into the spreadsheet and save it.

6. Click Choose File, select your file, and click Import Order Partial Info. A Queued Job will be generated. Click the Job # link to view it. When the job finishes, click the .xlsx file link next to Output File.
   
   

Profit & Loss Metrics

To view how fast P&L data is generated:

1. Go to Reports > Profit & Loss > Manage P&L.

2. Under Profit & Loss Metrics, you can see:
   
   

   1. The Transactions To Generate.

   2. The P&L Transactions To Generate (New).

   3. The P&L Transactions To Update.

Non-Order Transaction Type List

You determine if item cost is included in the calculation of specific non-order transactions, changing the overall profit and loss data. The item cost will be considered for all transactions you enable in the list. To include item cost in specific non-order transaction types:

1. Go to Reports > Profit & Loss > Manage P&L.

2. Under Non-Order Transaction Type List, check the items to include.
   
   

3. Click Save. You will be prompted to update past transactions as well. Click Yes or No.

Recent Settlements

This chart shows the most recent Settlement reports per company channel. To view recent settlements:

1. Go to Reports > Profit & Loss > Manage P&L.

2. Under Recent Settlements, you can see these details:
   
   

   1. Company - The company associated with the settlement.

   2. Channel - The channel associated with the settlement.

   3. Settlement ID - The settlement's unique identification number. Clicking the ID will take you to a Settlement Details page where you can access detailed information about each transaction.

   4. Imported On - The date when the settlement has been imported to Sellercloud.

   5. Start Date - The settlement’s start date.

   6. End Date - The settlement’s end date.

   7. Amount - The settlement’s total amount.

   8. Currency - The currency used for the transactions.

Back to top