FBA Reconciliation


Overview

Sellercloud offers an FBA Reconciliation report that shows discrepancies between units that should be in FBA versus those that are currently in FBA. This report is generated using data from multiple Amazon reports, including All Orders, Returns, Reimbursements, and Removals. While Amazon provides an FBA reconciliation report as well, theirs is provided per shipment whereas Sellercloud’s report reconciles your entire inventory at FBA in a more comprehensive manner. You can learn more about the data included in this report below.

FBA Reconciliation Report

To run the FBA Reconciliation report:

  1. Click User > Client Settings > select Enable FBA Reconciliation Page > Save.FBA reconciliation page enabled
  2. Go to Settings > Marketplaces > Amazon > FBA Reconciliation.FBA reconciliation report
  3. Select your filters. The table below defines each of these filters.
    FILTER DESCRIPTION
    Company Company name.
    Product ID, FNSKU, 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, and inventory transfers. 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 the merchant is reimbursed.
  4. Click Search to show your Amazon-fulfilled products.
  5. Select the products > click the action menu > Set Start Date. The page will refresh with editable Start Date and Beginning Qty fields.set start date
  6. 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.
  7. Click Save.

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.

 

Sellercloud offers an FBA Reconciliation report that shows discrepancies between units that should be in FBA and 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 about that here.

Running the report
To run the FBA Reconciliation report:

  1. Click Settings > Client Settings > select Enable FBA Reconciliation Page.
  2. Click Inventory > FBA Reconciliation.
  3. Filter by Company, Product ID, ASIN, or FNSKU, then click Search to show your FBA products. Only Amazon-fulfilled products will appear.
  4. Select the products > click Action Menu > Set Start Date > Go. The page will refresh with editable Start Date and Beg. Qty fields.
  5. 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.
  6.  Click Save. The page will display the data shown in the table below.

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

HEADER DESCRIPTION
Product ID,
Merchant SKU,
ASIN, Product
Name		 Product identifiers.
Beg. 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.
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.
Adjustments 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.
Expected
Inventory		 Calculation: Beginning Qty + Shipped – ((Orders + Removals +
Reimbursed) – Returns) = Expected Inventory
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)
Discrepancy Calculation: Expected Inventory – Actual

Setting start date in bulk
To set the start date in bulk, use the following column headers:

  • FBA Reconciliation Start Date
  • FBA Reconciliation Start Quantity

Was this article helpful?

Yes No

Related Articles