SellerCloud provides a reconciliation report that displays discrepancies between units that should be in FBA and that which is currently in FBA. While Amazon provides a per-shipment reconciliation report, SellerCloud's report reconciles your entire inventory at FBA more comprehensively. SellerCloud's report complies data from multiple Amazon reports, including all orders, returns, reimbursements, removals, etc., as well as from FBA inbound shipments in SellerCloud. All data will be loaded onto a single page to provide an expected qty at FBA.
Please note: Filing a claim needs to be done through Amazon's Shipment Reconciliation Tool located in the "Reconcile" tab on each shipment's summary page. Read more about that here
Explanation of Column Headers
- Navigate Settings > Client Settings and activate client setting Enable FBA Reconciliation Page.
- Navigate Inventory > FBA Reconciliation.
- Press Search to return your FBA products. You can filter by Company, ProductID, ASIN, or FNSKU prior to pressing Search. Only Amazon Fulfilled product will be returned.
- Select the products and select Set Start Date from the action menu. The page will refresh with the "Start Date" and "Beg. Qty" fields now editable.
- Enter a start date and the qty at FBA at the start date. This will designate the date from when to start calculating the inventory sent and received.
- Press Save.
- The page will display the following data:
| 1. Product identifiers|| ProductID, Merchant SKU, ASIN, Product Name. |
| 2. Beginning Qty|| The quantity at FBA at the time of the Start Date. |
| 3. Qty Shipped || The Qty that was shipped to FBA since the Start Date.|
| 4. Received|| The Qty FBA marks as received for that item since the Start Date.|
| 5. Returns || Number of units for this SKU in the FBA Return Report.|
| 6. Orders || Number of units for this SKU in the FBA Customer Shipment Sales report|
| 7. Removals || Number of times this SKU shows in the FBA Removal Shipment Detail Report. |
| 8. Reimbursed || Number of times this SKU showed in the FBA Reimbursement Report. Reimbursements occur when Amazon recognizes that your units were lost or damaged, and Amazon accepts responsibility for the loss. The item is removed from inventory and merchant is reimbursed.|
| 9. Adjustments || This value is based on the FBA Inventory Adjustments Report column “quantity”. This report shows corrections and updates to your inventory in response to issues such as damage, loss, receiving discrepancies, inventory transfers, and so on. This column is not used in SellerCloud's reconciliation calculations. Read more about the Amazon Inventory Adjustment Report here.|
| 10. Expected Inventory|| The sum of: Beginning Qty + Shipped - ((Orders + Removals + Reimbursed) - Returns) = Expected Inventory|
| 11. Actual || Taken from the “afn-warehouse-quantity” column in the most recent FBA Manage Inventory Report. |
(afn-warehouse-quantity = (afn-fulfillable-quantity) + (afn-unsellable-quantity) + (afn-reserved-quantity).
| 12. Discrepancy|| Expected Inventory - Actual = Discrepancy|