Reconciliation Summary

Overview

In this article, you will learn about Sellercloud’s Reconciliation Summary report. This report provides a summary of all transactions related to a specific settlement.

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 information about:

  • Settlement Identifier: Settlement ID.
  • Transaction Information: Transaction Type and Movement Type.
  • Financial Information: Cost of Goods Sold, Sellercloud Amount, Settlement Amount, and Difference.
For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

Access and Customize the Report

To use the report, follow these steps:

  1. Navigate to Reports > Settlement > Reconciliation 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 a different color. 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

Click the drop-downs below for filter and column descriptions.

Default Filters
FILTERDESCRIPTION
CompanyInclude only one or more companies.
ChannelInclude only one or more sales channels.
Settlement IDInclude only specific settlements by ID. This filter works only for Amazon/FBA, Jet, eBay, Newegg, and Walmart Marketplace settlements.
Custom Filters
FILTERDESCRIPTION
Company GroupsInclude only one or more company groups.
Movement TypeInclude only specific kinds of movements (Order, PO, etc.).
Transaction Type
  • Order – These are listed as Debit or Credit
  • Non-order – These are listed individually by transaction type; for example, Warehouse Lost, Warehouse Damage, FBA Disposal Fee, FBA Inbound Shipping Cost, Product Ad, etc.
Report Data
COLUMNDESCRIPTION
Settlement IDShows the settlement ID.
Transaction TypeShows the type of transaction.
Movement TypeShows the type of movement (Order, PO, etc.).
COGSShows the cost of goods sold.
Sellercloud AmountShows the amount calculated in Sellercloud for the corresponding transactions.
Settlement AmountShows the amount calculated from the settlement for the corresponding transactions.
DifferenceShows the difference between the Sellercloud amount and the settlement amount.

Was this article helpful?

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