How to get your money back from lost and damaged FBA inventory ?

Vanessa Hung - Fulltime Amazon

5 min read

#FBAseries — Formula to make the inventory reconciliation on FBA inventory.

Image for post

This article will explain how to manually pull and use the inventory reconciliation report to find discrepancies in your inventory and ask for reimbursements. This is the manual process to find out discrepancies in your inventory, but several tools in the market do it automatically and even ask for a reimbursement on your behalf.

If you are using Amazon fulfillment services (FBA) to fulfill your products. The only way to manage your inventory by looking at the number of units shipped over a period of time vs. the number of units sold and available. When these numbers don’t match, we need to look for lost, returned, and damaged items.

Image for post

I recommend downloading the Inventory Reconciliation report at least once a month and checking for any discrepancies to request a reimbursement.

How to Reconcile your Inventory? Step-by-step

  1. Go to Seller Central > Click Reports > From the drop-down menu click Fulfillment.
Image for post

2. From the left side menu, go to Inventory > Click on Inventory Reconciliation.

Image for post

You can choose between “View Online” which is a single search, or “Download” to get the full report on the Inventory Reconciliation page. The single search gives you the information of any individual SKU in a date range. If you choose to download the report, it will provide you with the movements and ending quantities of every SKU in your inventory in a specific date range.

3. Click on Download and choose the date range you want to reconcile.

Image for post

If this is your first time using this tool or reconciling your inventory you might want to request the broadest event date, which is 18 months.

4. After you download the report, you need to convert the columns in a table to filter the information faster. #ExcelTip — Select all the information in the spreadsheet, click Alt+N+T, then hit enter and you will have a table of information that will look like this:

Image for post

5. In the “lost” column (13) filter all the numbers to get a list of all the SKUs that were misplaced/lost in the fulfillment center. We will use the list of lost items to manually check if Amazon reimbursed us or we need to request a reimbursement.

6. Go to Reports > Fulfillment > Inventory > Inventory Adjustments. Copy one SKU or FNSKU of the list of lost items and paste it in the correspondent field in the Inventory Adjustment page.

Image for post

This will generate a detailed report of all the units that were misplaced. In this example, I have 8 units lost, 3 units damaged at Amazon and 2 units found.

7. Click on the arrow next to the reason for the transaction and check if Amazon has reimbursed you or if they found your item. In my case, Amazon reimbursed me for all the units lost and damaged.

Image for post

8. Click on the word “Reimbursed” to go to the reimbursements report which gives you all the transaction information like date, reimbursement ID, quantities, total amount, etc.

Image for post

I always check the reimbursements report because sometimes Amazon reimbursed for less money than they should. The formula for the reimbursement amount (RA) is your price (P) minus the Amazon referral fee or any applicable fees (%).

Reimbursement Formula: P - % = RA

If in Step 7 you don’t see an arrow next to the transaction reason, this means that Amazon hasn’t taken any action to solve the issue. They neither have reimbursed you nor found your items. Considering that Amazon can take up to 45 days to take action, if your transaction is out of that waiting period, you can open a case to request a reimbursement.

Image for post

How to Open a Case to Request a Reimbursement? Step-by-Step

  1. Go to help in the top right corner of Seller Central > Scroll down to the bottom of the page > Click “Get Support” in the Need more help? section.
Image for post

2. Click “Selling on Amazon” > Scroll down and click on “Or, browse for your issue in the menu”

Image for post

3. In the left side menu, click on “Fulfillment by Amazon” to open more options > click on “Inventory Damaged or Inventory Lost in Warehouse”

4. Then select the reason for the reimbursement request, which can be lost or damaged. For this example, I selected “Investigate Inventory Lost in FBA Warehouse”

Image for post

Here you will need to describe your issue and add as much information as possible using the Inventory Reconciliation report to support your claim. #SellerSupportHack I recommend adding attachments to your cases to avoid getting an automatic response from Seller Support. They must respond to your case in less than 48 hours if they don’t, open a new one.

Template

“Hello Amazon team,

We are requesting the reimbursement of ONE (1) unit of the FNSKU X00054545R that was lost in the warehouse.

Attached you will find the screenshot of the inventory adjustments.

Please advise,”

I hope this article helps sellers to find opportunities to get reimbursed and to manage their inventory in a better way. Being on top of your inventory can make a huge difference in your business because lost and damaged items are very common when using FBA.

If you have any questions, leave them in the comments and follow me @fulltimeamazon for more #FBAseries information, and if you found this article helpful share it with a seller in need.

Read More

Keep in touch.

Get the latest resources, news and more

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.