# Line Summary

## Overview

In this article, you will learn about Sellercloud’s **Line Summary** report. This report summarizes the financial settlements, including revenue information and other details. Settlement is the process of transferring funds from a payment processor or acquiring bank to a merchant's bank account. The settlement process reconciles the transactions and ensures that the funds from the customer's payment are accurately credited to the merchant's account. Settlements contain information about a channel’s order-related fees, commissions, and taxes. In this report, you can see the following:

- **Settlement Information:** Settlement Number, Start Date, End Date, Deposit Date, Currency, and Currency Conversion.
- **Revenue:** Sellercloud Amount, Settlement Amount, Amount Difference, and Sellercloud Amount in Foreign Currency.
- **Company and Channel Information:** Company and Channel.

For more information about Sellercloud’s Financial Reporting Suite, see the [Reports FAQ](https://descartessystems.aha.io/pages/7630865220332472858).

## Access and Customize the Report

To use the report, follow these steps:

1. Navigate to **Reports** > **Settlement** > **Line Summary**.
2. Set up the **Default** and **Custom filters** to have the report show precisely what you need.
3. Click **Search**. Each filter you apply gets highlighted in green. If a filter is gray or not displayed at all, it’s not active.

4. To manage the columns in the report, click the three dots icon on the top right and select **Customize Columns**. You can:
   1. Reorder columns by dragging them up or down in the list.
   2. Hide columns by clicking the **Trash** icons.
   3. Add columns by clicking **Add column**.

5. To sort the data differently, use the **Sort by** menu.
6. To save your filtering and sorting options, click **Save view**, type a **Name** and click **Save**.

7. To export the full report to a spreadsheet, click **Actions** on the bottom right and select **Export to Excel**. Spreadsheets include all columns, including those hidden in the report.

## Filter and Column Definitions

Below you will find descriptions of the available filters and columns.

### Default Filters
|     |     |
| --- | --- |
| **Filter** | **Description** |
| **Company** | Include only one or more [Companies](https://descartessystems.aha.io/pages/7630838368529930257). |
| **Channel** | Include only one or more sales [Channels](https://descartessystems.aha.io/pages/7630870720735739402). |
| **Date Range** | Select a preset time range from **Yesterday** to **Last Year**. |
| **Date** | Enter the **Start** and **End** dates. For a single date, choose the same **Start** and **End** date. |
| **Date Type** | Choose how to reflect orders and their associated activity: <br>- **Start**<br>  <br>- **End**<br>  <br>- **Deposit** |

### Custom Filters
|     |     |
| --- | --- |
| **Filter** | **Description** |
| **Company Groups** | Include only one or more [Company Groups](https://descartessystems.aha.io/pages/7630838282103460827). |
| **Settlement ID** | Include only specific settlements by ID. This filter works only for Amazon/FBA, Jet, eBay, Newegg, and Walmart Marketplace settlements. |

### Report Data
|     |     |
| --- | --- |
| **Column** | **Description** |
| **Settlement ID** | Shows the settlement’s unique ID. |
| **Company** | Shows the company. |
| **Channel** | Shows the sales channel. |
| **Start Date** | Shows the settlement start date. |
| **End Date** | Shows the settlement end date. |
| **Deposit Date** | Shows the settlement deposit date. |
| **Sellercloud Amount** | Shows the amount calculated in Sellercloud for the corresponding transactions. |
| **Settlement Amount** | Shows the amount calculated from the settlement for the corresponding transactions. |
| **Amount Difference** | Shows the difference between the Sellercloud amount and the settlement amount. |
| **Currency** | Shows the currency of the transaction. |
| **Currency Conversion** | Shows currency conversion fees. |
| **Sellercloud Amount in Foreign Currency** | Shows the Sellercloud amount in foreign currency.