Select Page

Keeping Amazon FBA in check

agsdix-smt1-event

November 22, 2020

agsdix-fas fa-user

Kalvin Mizzi

agsdix-fas fa-comment

0

To continue the discussion on Keeping your 3PL in check, Amazon FBA is a 3PL that warrants special treatment.

Operationally, the real-time inventory figures are available via the “GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA” report, accessible via the Reporting API.

We have not found any inventory report accessible via Seller Central that offers the same level of real-time detailed data, breaking down Fulfillable, Unsellable, and Inbound inventory levels.

Thus, it is important for operationally critical fulfillment decisions rely on this specific report. This is usually important for sellers who do Multi-Channel fuifillment (Using Amazon FBA warehouses to fulfill non-Amazon sales).

Accounting-wise, Amazon does offer an audit trail through a series of reports. The formula for Amazon inventory reconciliation is:

Ending inventory balance = starting Inventory balance + received inventory – customer orders + customer returns +/- adjustments – removals

Starting and Ending Inventory Balance

Reporting API Name: _GET_FBA_RECONCILIATION_REPORT_DATA_
Seller Central Name: Inventory Reconciliation

  • Available on the 6th of each month for the previous month
  • Columns:
    • Beginning Quantity
    • Ending Quantity
    • Received
    • Returned
    • Found
    • Sold
    • Removed
    • Lost
    • Disposed
    • Other
    • Discrepant Quantity

Received Inventory

Reporting API Name: _GET_FBA_FULFILLMENT_INVENTORY_RECEIPTS_DATA_
Seller Central Name: Received Inventory

Customer Orders

Reporting API Name: _GET_AMAZON_FULFILLED_SHIPMENTS_DATA_
Seller Central Name: Amazon Fulfilled Shipments

Customer Returns

Reporting API Name: _GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA_
Seller Central Name: FBA customer returns

Adjustments

Reporting API Name: _GET_FBA_FULFILLMENT_INVENTORY_ADJUSTMENTS_DATA_
Seller Central Name: Inventory Adjustments

Removals

Reporting API Name: _GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA_ & _GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA_
Seller Central Name: Removal Order Detail & Removal Shipment Detail

One check that can be performed is to make sure that the Ending inventory balance = starting Inventory balance + received inventory – customer orders + customer returns +/- adjustments – removals formula balances. If it does not, it could be justification for Amazon reimbursement.

Careful analysis should be done with all “Adjustments”. These are inventory events not initiated by the seller. There could be adjustment situations that warrant an Amazon reimbursement.

Should you keep your own set of books for every inventory event at Amazon FBA?

This is not entirely practical. You would only be able to reliably keep track of Sales, and the source of that information comes from Amazon anyway. If you really wanted to go the extra mile, you could match each Sale with an Amazon Financial Event to make sure you get paid for each order.

Better practice would be to trust Amazon’s inventory reports and simply analyze the reasons for any adjustments.

For Inventory Receipts, this should correspond to an Amazon FBA Inbound Order and reconciling discrepancies on inventory receipts is a whole other topic (and an area where Amazon makes mistakes quite often).

Share this post

Kalvin Mizzi

Online Seller, Finance Geek, Developer

Kalvin Mizzi has over 20 years experience in the E-commerce industry.  He holds an Economics degree from University of Toronto, where he graduated with Honors, and is a self-taught programmer and entrepreneur.

Kalvin started his career in the real estate development industry, raising equity/debt, financial modeling, and sales/brokerage.

He is passionate about systems and helping other E-commerce sellers.

Related posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *