# Reconciliation By Order

## Overview

In this article, you will learn about Sellercloud’s **Amazon & Walmart** **Reconciliation By Order** report. This report provides a reconciliation overview by order. It includes information about orders, financials, shipping, and handling. Reconciliation reports are intended to match the transactions recorded in an online store's financial records to those processed by payment gateways and banks to ensure the reliability and accuracy of financial reporting. You can see the following:

- **Order Information:** Order Number, Order Date, Channel, Shipping, and Ship Date.
- **Financial Information:** Subtotal, Grand Total, Commission, Adjustments, Tax, Marketplace Facilitator Tax, Sellercloud Amount, Settlement Amount, and Amount Difference.
- **Shipping & Handling Information:** Shipping Cost, Gift Wrap, Handling, Insurance, and Posting Fee.
- **Promotion Information:** Promotion Cost and Rebate.

This report only shows settlement information about Amazon, Walmart Marketplace, FBA, and WFS Orders.

## Access and Customize the Report

To use the report, follow these steps:

1. Navigate to **Reports** > **Settlement** > **Amazon and Walmart Reconciliation By Order**.
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 the desired format – **Excel**, **CSV**, or **PDF**. 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. |

### Custom Filters

|     |     |
| --- | --- |
| **FILTER** | **DESCRIPTION** |
| **Company Group** | Include only orders from one or more [Company Groups](https://descartessystems.aha.io/pages/7630838282103460827). |
| **Order Number** | Include only one or more specific orders by order number. |
| **Status Type** | Include only reconciled or unreconciled payments. |

### Report Data

|     |     |
| --- | --- |
| **DESCRIPTION** |  |
| **Order Number** | Shows the Sellercloud order number. |
| **Order Date** | Shows the date when the order came in. |
| **Channel** | Shows the order’s sales channel. |
| **Subtotal** | Shows the total amount of the items before any discounts, tax, shipping, etc. |
| **Grand Total** | Shows the total amount of the order, calculated as such: (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount). |
| **Shipping** | The amount paid for shipping the order. |
| **Commission** | Shows [Sales rep commission](https://descartessystems.aha.io/pages/7630866113237453806) fees. |
| **Adjustments** | Shows any positive or negative adjustment amounts to orders. |
| **Tax** | Shows the amount paid for tax for the order. |
| **Marketplace Facilitator Tax** | Shows the marketplace facilitator tax. |
| **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. |
| **Gift Wrap** | Shows the amount paid for gift wrapping for the order. |
| **Handling** | Shows the amount paid for handling. |
| **Insurance** | Shows the amount paid for order insurance. |
| **Posting Fee** | Shows the listing's posting fee and [Reverb bump fee](https://reverb.com/page/bump). |
| **Promotion Cost** | Shows the amount paid for sponsored product ads, sponsored brand ads, display ads, and other promotional programs. |
| **Items Rebate** | Shows the incentive amount the vendor reimburses for a product’s promotion. |
| **Ship Date** | Shows the date set for shipping of the order. |
| **Shipping Cost** | Shows the cost of outbound shipping. Includes refunds on shipping costs. <br>- **For FBA** – This includes the following types of fees: FBA Per Unit Fulfillment Fee, FBA Weight Based Fee, FBA Per Order Fulfillment Fee, Shipping Chargeback, Gift Wrap Chargeback, and Cross-Border Fulfillment Fee.<br>  <br>Enabling **Predict shipping cost of an order** in **Client Settings** will calculate an **Estimated Shipping Cost** based on the last 30 days. When the **Shipping Cost** field is marked with an **E**, this indicates the **Estimated Shipping Cost** is being shown.