Reimbursing Lost, Damaged, and Destroyed Inventory on Amazon
It is inevitable for items to sometimes get lost, damaged, and destroyed, especially if it has to go through a lot of journeying over warehouses. The good news is there is a way to reimburse these items, let’s check out how by reading through this blog.There are 3 steps to getting reimbursements. First you need to identify reimbursable transactions. Second is to determine if Amazon has already reimbursed you. Amazon is allowed 30 days from the event to reimburse you automatically. After the 30 days, you can file your own cases. The last step is to submit a case to Amazon either in groups of events or one by one and provide necessary information required to get reimbursed.
Steps to Identify Eligible Items for Reimbursement
- Point your cursor to the “Reports” tab, and select the “Fulfillment” option below the main tab.
- After that, a new page will appear. Under the “Inventory” section, click on “Show more”.
- Then, you will see “Inventory Adjustments” which will help us determine the items due for reimbursement. Kindly, click on it.
- Choose how you want to view the products, you can either view them online or download them.Recommendations: If you have more than 50 items on each potential reason group, choose the download feature while if you have less than 50 items choose “View Online”.
To “View online”
- For the Reason Group, select the dropdown option “Lost”.
Note: If it is your first time making this report, in order to recover all the potential reimbursements, go back 18 months to try to recover as much as possible. Run each report to open the case of affected items. For the Event Date, select the dropdown option “Exact Date”
- Then, click on “Generate Report”
Every item that will be displayed on the report must be reimbursed. Now, in order to open a case, you have to verify each item to check if it has been reimbursed before or not. Although, there is an option to open a case for all items directly with Amazon, it could result in reimbursing only the items that have not been reimbursed before. To have a precise result, you can reconcile each item. However, if you have a lot of items in these reports, it is recommended to just create a case for each 5-20 SKU’s in the report.
- For the Damaged, Destroyed, and Other items which include Miscellaneous only, you can follow the same steps that we did in Step 5. You should be able to see the dropdown options besides the “Reason Group”.
- For the Event Date, select the dropdown option “Exact Date”. You should set up the Start Date as the day you created your account and the End Date should be the date when you are trying to view the items. Then, click on “Request Download”.
- Next, click “Download” besides the report you requested.
- You can now Open the text file and transfer it into an Excel File.
- Click on the text file and do the shortcut Ctrl+A to select all. Then, do the shortcut Ctrl+C to copy the report or or by clicking right on your mouse and selecting Copy.
- Next, Open a new Excel Spreadsheet
- After that, click cell A1 then paste the report by doing the shortcut, Ctrl+P, or by clicking right on your mouse and selecting Paste.
Now, that you’ve successfully transferred the report into the Excel Spreadsheet. The next thing that you should do is filter the top row of the document in order to have an organized view of each data on the report.
- First, click on the “Data” tab. Second, highlight the top row by clicking Row 1. Third, Click the “Filter“ button.
After that, you need to sort out the “Reason” Column. Click on the dropdown arrow next to the “Reason Column” and select the checkbox E – for Damaged Items, D – for Destroyed Items, M – for Lost items, Q – for Damaged, Miscellaneous. Then, click “Ok”. The items that have been now sorted out should be reimbursed.
- Create and save a different Excel Spreadsheet for easy attachment of filing a case on every 5 to 20 SKU’s.
5. Now, that you’re done with viewing the eligible items to be reimbursed. You can now open a case.
- You can submit an open case for all items directly with Amazon if you viewed the item by downloading the report because it means that you have sorted out all the items that have issues on an Excel Spreadsheet. It has been proven that submitting the items in bulk even without reconciling turned out to be efficient in this method.
- And, if you choose to reconcile the items one by one before submitting for reimbursement, here’s how:
- Point your cursor to the “Reports” tab, and select the “Fulfilment” option below the main tab.
- After that, a new page will appear. Under the “Payments” section, click on “Reimbursements”.
- Choose how you want to view your reimbursement, you can either view them online or download them.If you choose the “Download” feature, you can compare the lost, damaged, and destroyed items in Excel, too.To “View Online”
- You can use either “Merchant SKU” or “Fulfillment Network SKU” fields.
- For the Event Date, make sure it is set as the day you created your account
- Then, click on “Generate Report”
- The report will be generated below the first screen that we filled up Note: Though you have been reimbursed for an item before, there are cases where you should have been reimbursed again for multiple items that had the same SKU. If you have the Excel Spreadsheet with you, this would be easier to see the duplicate data or by searching the file using the shortcut Ctrl+f and see if there’s more.
- If in case, there’s no result generated. It means that the item has no reports of reimbursement yet and that it should be included when creating cases.
Steps to Create Cases for Lost, Damaged, Destroyed Inventory
- Look on the right-most corner of the screen from the Seller Central page and click the “Help” button.
- Next, Scroll down to the bottom to open a case.
- Now, when the new screen shows. Amazon will ask the service that they can help you with, you can now tell them the issues regarding the reimbursement and here’s how:
- Click on “Selling on Amazon”
- Then, Select “Other Issue” and “All other Issue”
- Lastly, a contact form will be opened and you will now select to contact Amazon via Email. You can now write an Email to Amazon about your reimbursement issue. Note: Avoid including more than 5 units in each case. If you have separate Excel files, name each with the same title and number it.Example: Items 1 Items 2 So that, there wouldn’t be confusion in terms of uploading a file.
- If you choose to “View Online”, below the message of your email, you need to paste 20 SKU’s and their matching FNSKU’s.
- If you choose to “View Online”, Upload the spreadsheet by selecting “Add Attachment”. Using our finalized spreadsheet, copy the items by 20 into a new Spreadsheet and repeat until you submit all the eligible Items for reimbursement. Do you find this blog useful? We have more blogs about reimbursement, we will keep you posted. Thank you! See you on our next blog.