FBA Reconciliation

Updated 1 month ago

Please read first! This topic explains how to run the FBA Reconciliation report in Sellercloud's Delta interface. For instructions in Sellercloud's original interface, please download this file.


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. 


How did we do?


Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter
Powered by HelpDocs (opens in a new tab)