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 with those processed by payment gateways and banks, ensuring 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.

Access and Customize the Report

To use the report:

1. Navigate to Reports > Settlement > Reconciliation Summary.
2. Set up the Default and Custom filters.
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

The tables below provide filter and column descriptions.

Default Filters

Custom Filters

Report Data