Reconciliation Details

Overview

In this article, you will learn about Sellercloud’s Reconciliation Details report. This report goes into detail about 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:

  • Order and Product Information: Company, SKU, Order Number, Channel Order Number, Amazon Shipment ID, Transaction Type, Movement Type, and Transaction Date.
  • Financial Information: Cost of Goods Sold, Commission, Carrier Shipping Cost, Channel Shipping Cost, Tax, Price Amount, Fee Amount, Transaction Fee, Posting Fee, Misc Fee, and Grand Total.
  • Settlement: Settlement ID, Sellercloud Amount, Settlement Amount, and Amount 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 Details.
  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

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

Default Filters
FILTER DESCRIPTION
Company Include only one or more companies.
Channel Include only one or more sales channels.
Settlement ID Include only specific settlements by ID. This filter works only for Amazon/FBA, Jet, eBay, Newegg, and Walmart Marketplace settlements.
Custom Filters
FILTER DESCRIPTION
Company Groups Include only one or more company groups.
Movement Type Include only specific movement types (Order, PO, etc.).
Order Number Include only one or more specific orders by order number.
Status Type Include only reconciled or unreconciled payments.
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
COLUMN DESCRIPTION
Settlement ID Shows the settlement ID.
Company Shows the company.
Transaction Type Shows the type of transaction, order or non-order.
Movement Type Shows the type of movement (Order, PO, etc.).
Transaction Date Shows the date when the transaction occurred.
Order Number Shows the Sellercloud order number.
Channel Order Number Shows the channel-specific order number.
SKU Shows the product’s SKU.
COGS Shows the cost of goods sold.
Commission Shows sales rep commission fees.
Carrier Shipping Cost Shows the fulfillment fees from the shipping carrier (FBM orders).
Channel Shipping Cost Shows the fulfillment fees from the Channel (FBA/WFS orders).
Tax Shows the amount paid for tax on the order.
Transaction Fee Shows the Paypal processing fee.
Posting Fee Shows the eBay listing fee and Reverb bump fee.
Misc Fee Shows the misc fee amount on the settlement for the corresponding transactions.
Grand Total Shows the total amount of the order, calculated as such: (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount).
Sellercloud Amount Shows the amount calculated in Sellercloud for the corresponding transactions.
Price Amount Shows the order amount on the settlement i.e. principal sale, tax, etc.
Fee Amount Shows the fee amount on the settlement 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.
Amazon Shipment ID Shows a unique number used by Amazon to identify FBA shipments.

Was this article helpful?

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