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.
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 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 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.
Date RangeSelect a preset time range from Yesterday to Last Year.
DateEnter the Start and End dates. For a single date, choose the same Start and End date.
Custom Filters
FILTERDESCRIPTION
Company GroupInclude only orders from one or more company groups.
Order NumberInclude only one or more specific orders by order number.
Status TypeInclude only reconciled or unreconciled payments.
Report Data
COLUMNDESCRIPTION
Order NumberShows the Sellercloud order number.
Order DateShows the date when the order came in.
ChannelShows the order’s sales channel.
SubtotalShows the total amount of the items before any discounts, tax, shipping, etc.
Grand TotalShows the total amount of the order, calculated as such: (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount).
ShippingThe amount paid for shipping the order.
CommissionShows sales rep commission fees.
AdjustmentsShows any positive or negative adjustment amounts to orders.
TaxShows the amount paid for tax for the order.
Marketplace Facilitator TaxShows the marketplace facilitator tax.
Sellercloud AmountShows the amount calculated in Sellercloud for the corresponding transactions.
Settlement AmountShows the amount calculated from the settlement for the corresponding transactions.
Amount DifferenceShows the difference between the Sellercloud amount and the settlement amount.
Gift WrapShows the amount paid for gift wrapping for the order.
HandlingShows the amount paid for handling.
InsuranceShows the amount paid for order insurance.
Posting FeeShows the eBay listing fee and Reverb bump fee.
Promotion CostShows the amount paid for sponsored product ads, sponsored brand ads, display ads, and other promotional programs.
Items RebateShows the incentive amount the vendor reimburses for a product’s promotion.
Ship DateShows the date set for shipping of the order.
Shipping CostShows the cost of outbound shipping. Includes refunds on shipping costs.

  • 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.

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.


Was this article helpful?

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