Vanessa Hung - Fulltime Amazon
5 min read
#FBAseries — Formula to make the inventory reconciliation on FBA inventory.
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.
I recommend downloading the Inventory Reconciliation report at least once a month and checking for any discrepancies to request a reimbursement.
2. From the left side menu, go to Inventory > Click on Inventory Reconciliation.
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.
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:
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.
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.
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.
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 (%).
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.
2. Click “Selling on Amazon” > Scroll down and click on “Or, browse for your issue in the menu”
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”
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.
“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.
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.
Get the latest resources, news and more