# Order P&L Adjustments

## Overview

**P&L Adjustments** are an element of the [Order Profit and Loss (P&L)](https://descartessystems.aha.io/pages/7630859407371251876) of each individual order. These adjustments refer to any post-sale transactions that were not part of the original sale but are important for keeping accurate financial records. Some examples include Reimbursements, Shipping Claims, and Return Labels. This article will walk you through all the available adjustment types and how to add them to your orders in Sellercloud.

The [Client Setting](https://descartessystems.aha.io/pages/7630835167106228692) **Enable adjustments in P&L** must be enabled for this workflow.

## Order P&L Adjustments

You can create **P&L Adjustments** for individual orders or import them via file for multiple orders at once. Positive Adjustments will increase the overall calculated **Profit**, but you can also make negative adjustments, which will be deducted. Refer to the sections below for detailed instructions.

### Add P&L Adjustment to Order

To add **P&L Adjustments** to a specific order:

1. Go to **Orders > Manage Orders > Search** and open an **Order.**

2. From the **Toolbox >** click **Profit & Loss.**

3. Click **Edit**.

4. In the **Profit and Loss** panel, click the value next to **Adjustments.** This is a hyperlink that will open the **Adjustments** modal. To add a new one:

1. Choose an **Order Item**.
   2. Input the adjustment **Amount.** This field accepts negative as well as positive values.
   3. Select the **Type** of adjustment.
   4. Optionally, input a **Reason**.
   5. Click **Save Adjustment**.

The **Adjustments** modal also displays a list of existing adjustments. You can **delete** them by clicking the bin icon on the corresponding rows.

### Import P&L Adjustments

You can update the **Profit and Loss (P&L)** of your orders in bulk via a file import. To do that:

1. Navigate to **Orders > Show More > Tools**.
2. Click **Import Order Info via File**.
3. In the **Import Order** panel, select **Import P&L Adjustments**.
4. Click on the icon in the **Import P&L Adjustment** panel header to download the template.
5. Fill in your template:
   01. **Order #** - The Sellercloud Order ID.
   02. **Order Item #** - This is not the same value as the **Product ID**. You can find the specific **Order Item ID** in the order’s **Change Log.** This column is required if no **SKU** is provided in the file.
   03. **SKU** - The Sellercloud **Product ID**. Required when there is no **Order Item ID** provided.
   04. **Amount** - Numerical value only. You can input a positive or a negative value, e.g., 5 or -5.
   05. **Reason** - Enter a reason for the Adjustment. This serves as a reference to help you keep track of manual actions.
   06. **Adjustment Type** - See the section below for all supported Adjustment types.
   07. **Adjustment #** - Not necessary if the **Adjustment Type** is provided. Refer to the table below for the numerical ID of each type. The second tab of the template you downloaded in step 4 also lists Adjustment Types.
   08. **Channel Order #** - The **Order Source Order ID**. Not necessary if the Sellercloud Order ID is provided in the first column.
   09. **Channel Name** - Required if you have provided **Channel Order ID.**
   10. **_ACTION_** - Use this column to delete an existing adjustment. To do that, add _DELETE_ for the relevant row. Leave empty when adding a new adjustment.
6. Once you have saved your template, upload the file back into Sellercloud.
7. Click **Import**.

## Adjustment Types

The table below provides the full list of available **Order P&L Adjustment Types** along with their numerical IDs necessary for importing adjustments via file.

|     |     |
| --- | --- |
| **Adjustment Type** | **Adjustment ID** |
| Misc | 0 |
| eBay Subsidy | 1 |
| FBAServiceFee | 2 |
| Return Label | 3 |
| FBA Reimbursement | 4 |
| FBA CSErrorItem | 5 |
| FBA SalesTaxServiceFee | 6 |
| eBay Top Seller Discount | 7 |
| FBA RestockingFee | 8 |
| FBA Order Retrocharge | 9 |
| FBA Refund Retrocharge | 10 |
| FBA Shipping Cost Adjustment | 11 |
| FBA ShippingLabelForReturn | 12 |
| ShippingClaim | 13 |
| Amazon ShippingServicesRefund | 14 |
| Amazon Adjustment | 15 |
| CoOpFee | 16 |
| OrderHandlingFee | 17 |
| Groupon Chargeback | 18 |
| SAFE T Reimbursement | 19 |
| Trans Shipment | 20 |
| Global Shipping Program Shipping | 21 |
| Listing fee | 22 |
| FBA Pick and Pack Fee Adjustment | 23 |
| MarketplaceFacilitatorRegulatoryFee Principal | 24 |
| RegulatoryFee | 25 |
| TotalWalmartFundedSavings | 26 |
| Shipping Label | 27 |