Amazon FBA inventory reconciliation

The Brightpearl Amazon FBA inventory reconciliation provides the tools you need for keeping your central inventory records in Brightpearl inline with the items you have stocked with Amazon FBA. In other words, what you think you have in FBA fullfilment center and what Amazon says you have.

Brightpearl provides the tools to:

  • View and compare the inventory levels from Brightpearl and Amazon
  • View additional details from Amazon such as reserved, unsellable and inbound inventory
  • Calculate stock corrections to make in Brightpearl
  • The ability to override the suggested corrections
  • A bulk update to apply the stock corrections in Brightpearl which in turn updates inventory accounting

Amazon inventory statuses

  • Fulfillable - inventory units that are currently in Amazon Fulfillment Centers (Available quantity). These items are listed for sale on Amazon. 
  • Reserved - these items have been ordered by a customer but not yet shipped (pending order), are being transferred between warehouses (FC Transfer), are being inspected by Amazon (FC Processing), or are otherwise temporarily not available for sale.
  • Inbound - Amazon knows your product is on its way to the FBA warehouse.
  • Unsellable - inventory that Amazon believes is damaged or can't be sold for some reason.

How to reconcile Amazon FBA inventory

  1. Go to Channels > Amazon channel > Live Amazon listings report.
  2. Click Filter > Configure columns and select the columns that you wish to see on the report (we suggest either adding all of the following (or those with * as a minimum):
    • Brightpearl FBA fulfillable qty*
    • Amazon FBA fulfillable qty*
    • Amazon FBA reserved
    • Amazon FBA inbound qty
    • Amazon FBA unsellable qty
    • Total Amazon FBA qty
    • Suggested Adjustment*
      Read more about these headings below
  3. Save this view as a preset and click Filter. Once saved as a preset you can access this report from the preset views dropdown.
    Screen_Shot_2020-07-22_at_5.32.26_PM.pngBrightpearl will suggest an adjustment value (Amazon FBA fulfillable qty - Brightpearl FBA fulfillable qty). Review and change the values to specify the desired stock corrections you want to make for each item.
  4. To proceed with the corrections, select each item (max 500 from a single page) and click the Reconcile FBA inventory button. 

    Screen_Shot_2020-07-22_at_5.53.16_PM.png

  5. In the pop-up window specify which warehouse and cost price list (the related products will need a price on the selected price list) to use for the adjustments for adding and removing inventory. Also enter a reason for the adjustments which will be seen on the inventory audit trail.
    Screen_Shot_2020-07-22_at_6.04.26_PM.png
  6. To proceed with the adjustments click Reconcile. The pop-up window will close and the Brightpearl FBA warehouse quantities and the suggested adjustments on the report will refresh. All the items added into stock will be placed into the default warehouse location recorded on the product record for the relevant warehouse. All necessary accounting adjustments will be made.

    It will also create corresponding accounting entries for addition or removal of inventory.

    Note: It is not possible to reconcile items where multiple Amazon listings are connected to the same Brightpearl product. If this is attempted you will be notified that these items were skipped during the reconciliation.

FBA inventory reconciliation report columns

The following report columns are available for the Amazon FBA reconciliation report.

  • Brightpearl FBA fulfillable qty is the quantity of Amazon inventory that you have in your Brightpearl virtual warehouse. Brightpearl virtual warehouse is the warehouse that you set up in the system to track your inventory in Amazon fulfillment centers.
  • Amazon FBA fulfillable qty is what is currently available on Amazon to be purchased by Amazon buyers. 
  • Amazon FBA reserved are the items that have been ordered by a customer but not yet shipped (pending order), are being transferred between warehouses (FC Transfer), are being inspected by Amazon (FC Processing), or are otherwise temporarily not available for sale.
  • Amazon FBA inbound is the quantity you shipped to Amazon fulfillment center when created an inbound shipment to Amazon.
  • Amazon FBA unsellable are the items that Amazon believes cannot be sold.
  • Suggested adjustment is the difference between the inventory levels on Amazon than in Brightpearl; the number of items that need to be added or removed from Brightpearl virtual FBA warehouse to make it equal to the Amazon fulfillable qty. This does not take unsellable or inbound inventory into consideration.

Note that returned items are not counted under any status. Refunds and returns need to be managed manually. 

Suggested adjustment for Amazon FBA

The suggested adjustment for Amazon FBA inventory is calculated as:

Amazon FBA fulfillable qty

The quantity Amazon have recorded

LESS: Brightpearl FBA fulfillable qty

The quantity on hand in the Brightpearl warehouse

= Suggested adjustment

 

A positive suggested adjustment means inventory will be added into the Brightpearl warehouse, i.e. Amazon is showing there is more in stock than Brightpearl.

A negative suggested adjustment means inventory will be removed from stock in the Brightpearl warehouse, i.e. Amazon is showing there is less in stock than Brightpearl.

The suggested adjustment value can be manually edited in order to specify the adjustment desired.

A suggested adjustment of 0 means that no correction will be made.

FAQs

Can I configure the Amazon FBA inventory reconciliation to run automatically?

The Amazon FBA inventory reconciliation can only be run manually. The reason we do not allow automatic reconciliation is because every inventory update results in a GL entry, if your inventory levels change on a daily basis you may end up with many unnecessary journal entries. To avoid this, Brightpearl gives merchants the ability to decide when and how they want to reconcile their Amazon inventory.

Can I reconcile Amazon FBM (fulfilled by merchant) inventory?

The reconciliation only looks at Amazon FBA listings since these values are the ones considered the source of truth based on what Amazon say they have in their warehouse.

Have more questions? Submit a request