The Inventory Values page in Link My Books gives you a clear summary of your month-end FBA (Fulfilled by Amazon) inventory values. It's a handy tool for tracking the total value, units, and unique SKUs of your products stored in Amazon's fulfilment centres, which is crucial for accurate accounting and financial reporting.
You can find this page by navigating to Inventory > Inventory Values in your Link My Books account.
đą Which currency are the values shown in? The Inventory Values report, including the Month End Inventory Valuation Report, uses the cost figures and the currency setting from your Product Costs page. The cost currency is a single account wide setting, chosen from the currency dropdown at the top of that page. If a report is showing the wrong currency, change that dropdown to the correct currency and the report, including previous months, will update to match. The figures themselves are not converted, only the currency they are displayed in.
What Data Powers This Report?
Link My Books creates your Inventory Values report using data from the Amazon Monthly Inventory History report.
You can access this source report directly from Amazon Seller Central by going to: Reports > Fulfilment by Amazon > Inventory > Inventory Ledger.
We specifically use all your sellable inventory data from this Amazon report to generate your accurate Month-End Inventory Report within Link My Books.
There's also an option to view your inventory broken down by country. This data, relevant for FBA sellers, is described by Amazon as a tab-delimited flat file. It provides historical monthly snapshots of your available inventory in their fulfilment centres, including average and end-of-month quantities, locations, and disposition, with content updated daily by Amazon.
How to Use the Inventory Values Reports
The Inventory Values page offers both a summary view and a detailed breakdown for each month.
Summary Report View
The summary page gives you a high-level overview of your month-end inventory, including:
The total value of products you have at Amazon warehouses.
The total number of units.
The total number of unique SKUs.
If you haven't entered product costs for all SKUs in a report, you'll see an orange exclamation mark (â ď¸) in the Product Costs Entered column for that month.
To fix this, just enter your missing product costs on the Product Costs page. Once you've done that, a blue checkmark (â ) will appear, confirming all costs are accounted for.
Detail Report View
Each month's inventory report can be viewed in more detail. Simply click the "View" icon (often a magnifying glass or eye symbol) in the action column next to the summary entry for the month you want to look at.
The detailed report will show a comprehensive SKU-level breakdown for that specific month.
