Sellercloud offers an FBA Reconciliation report that shows discrepancies between units that should be in FBA versus those that are currently in FBA.
While Amazon provides a per-shipment reconciliation report, Sellercloud’s FBA Reconciliation report reconciles your entire inventory at FBA in a more comprehensive manner.
This report compiles data from multiple Amazon reports, including all orders, returns, reimbursements, removals, etc., as well as from FBA inbound shipments in Sellercloud. All data is loaded onto a single page to provide the expected quantity at FBA.
Running the report
To run the FBA Reconciliation report:
- Click Settings > Marketplaces > Amazon > FBA Reconciliation.
- Select your filters. The table below defines each of these filters.
|Product ID, FNSKU, ASIN||Product identifiers.|
|Show Discrepancy Only||
|Beginning Qty||Enter the From and To quantity at FBA at the time of the Start Date.|
|Shipped||Enter the From and To quantity that was shipped to FBA since the Start Date.|
|Received||Enter the From and To quantity that FBA marks as received for that item since the Start Date.|
|Returns||Enter the From and To quantity of units for this SKU in the FBA Return report.|
|Orders||Enter the From and To quantity of orders for this SKU in the FBA Customer Shipment Sales report.|
|Removals||Enter the From and To quantity of times this SKU appears in the FBA Removal Shipment Detail report.|
|Custom Filters||Select the following optional filters:
- Click Search to show your Amazon-fulfilled products.
- Select the products > click Action Menu > Set Start Date. The page will refresh with editable Start Date and Beginning Qty fields.
- Complete those two fields with the start date and the quantity at FBA on that start date. This will designate the date from when to start calculating the inventory sent and received.
- Click Save.
Understanding the grid results
The table below defines each of the report’s columns.
|Start Date||Date from which to start calculating the inventory sent and received.|
|Product ID, Merchant SKU, ASIN, Product Name||Product identifiers.|
|Beginning Qty||Quantity at FBA at the time of the Start Date.|
|Shipped||Quantity that was shipped to FBA since the Start Date.|
|Received||Quantity that FBA marks as received for that item since the Start Date.|
|Returns||Number of units for this SKU in the FBA Return report.|
|Orders||Number of units for this SKU in the FBA Customer Shipment Sales report.|
|Removals||Number of times this SKU appears in the FBA Removal Shipment Detail report.|