Searching...

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.
To learn about the different P&L reports, refer to our Profit & Loss category.
For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

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. Transactions To Generate
    2. P&L Transactions To Generate (New)
    3. 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.

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.
To learn about the different P&L reports, refer to our Profit & Loss category.
For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

Manage Profit & Loss

To access the Manage P&L page, go to Reports > Profit & Loss Reports > Manage P&L.

sellercloud profit and loss p&l orders import export

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

Export Profit & Loss

You can export your P&L reports to an Excel file.

  1. Go to Reports > Profit & Loss Reports > Manage P&L > Export Profit and Loss.
  2. Choose your Ship From Date and End Date.
  3. Input Order #s.
  4. Select your choice from the Missing Information dropdown menu.
  5. Check your choice for Order Information.
  6. Select your Channel from the dropdown menu. To include all channels, select ALL.
  7. Click Export Report. This generates a request notification. Click on your Job # to view your queued job, or click the link sent to your email.
  8. On your Job Details page, go to Select Action > choose Export to Excel > Go.

View Profit & Loss Metrics

You can view your P&L metrics. This features shows you the number and date of your Transactions To Generate, P&L Transactions To Generate (New), and P&L Transactions To Update.

Non-Order Transaction type list

You can update your non-order transaction type list here. When you select an item in the list, you are including that item cost in the profit calculation.

  1. Go to Reports > Profit & Loss Reports > Manage P&L > Non-Order Transaction Type List.
  2. Check which items you want to include in the profit calculation.
  3. Click Save.
  4. Optional: You will be prompted to update past transactions as well. Click Yes or No.

sellercloud yes or no manage profit and loss p&l in reports page

Recent Settlements

This chart shows the most recent settlement reports per company channel and displays the Company, Channel, Settlement ID, date Imported On (into Sellercloud), State Date, End Date, Amount, and Currency.

Import Profit & Loss

The steps to edit P&Ls with a file import have changed. You now import from the Orders page or click the link provided under Import Profit & Loss.
  1. Go to Reports > Profit & Loss Reports > Manage P&L > Import P&L.
  2. Click This option has been moved to here to be redirected to the new importing steps.

Import Partial Order Information

You can import partial order information into Sellercloud through the Orders Import Partial Info page. This is not located on the Manage P&L page; however, it will appear on the P&L report. This helpful page gives you the option to upload commission or payment-related information quickly and easily. All you need to do is upload your Order ID and the Commission Value or Payment Fee.

To access the Orders Import Partial Info page:

  1. Go to Orders > Import Orders Partial Info.
  2. Select Commission or Payment Fee from the Partial Info dropdown menu > Click Download Sample.
  3. Enter your information into the Excel spreadsheet > Save your updated spreadsheet.
  4. Click Choose File > Select your file > Click Import Order Partial Info.
The Payment Fee is shown as the Transaction Fee on the P&L tab of your Orders Details page.

Was this article helpful?

Yes No
Need Support?
Can't find the answer you're looking for?
Contact Support