FBA Reconciliation

[accordions id=’8861′]


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.

Filing a claim must be done through Amazon’s Shipment Reconciliation tool, located on the “c” tab on each shipment’s summary page. Read more here.

Running the report

To run the FBA Reconciliation report:

  1. Click Settings > Marketplaces > Amazon > FBA Reconciliation.
  2. Select your filters. The table below defines each of these filters.
FILTER DESCRIPTION
Company Company name.
Product IDFNSKU, ASIN Product identifiers.
Show Discrepancy Only
  • All – Show all products
  • Yes – Only show units with discrepancies.
  • No – Only show units with no discrepancies.
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:

  • Actual: Taken from the “afn-warehouse-quantity” column in the most recent FBA Manage Inventory Report. Calculation: afn-warehouse-quantity = (afn-fulfillable-quantity) + (afn-unsellable-quantity) +  (afn-reserved-quantity)
  • Adjustment: This value is based on the FBA Inventory Adjustments report’s Quantity column. 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.
  • Discrepancy: Calculation: Expected Inventory – Actual
  • Expected: Calculation: Beginning Qty + Shipped – ((Orders + Removals + Reimbursed) – Returns) = Expected Inventory
  • Reimbursed: Number of times this SKU appeared in the FBA Reimbursement report. Reimbursements occur when Amazon recognizes that your units were lost or damaged, and they accept responsibility for the loss. The item is removed from inventory and merchant is reimbursed.
  1. Click Search to show your Amazon-fulfilled products.
  2. Select the products > click Action Menu > Set Start Date. The page will refresh with editable Start Date and Beginning Qty fields.
  3. 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.
  4. Click Save.

Understanding the grid results

The table below defines each of the report’s columns.

HEADER DESCRIPTION
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.

 

Was this article helpful?

Related Articles