The FBA Restock Inventory Report gives you an overview of your inventory levels, recent sales and restock recommendations. We get the inventory data from Amazon's restock report and work out what to restock from your recent sales and your settings.
How to open it
Go to Reports, click Inventory, then click FBA Restock Report.
What does ConnectBooks use to suggest reordering?
ConnectBooks builds this report from your recent sales and the inventory settings you entered on the Listings page.
Your settings
Reorder Days: The number of days of stock you want each order to cover.
Safety Stock: The extra stock you want to keep on hand as a buffer so you don't run out.
Lead Time: The time it takes to get new stock from your supplier.
Sales calculation
ConnectBooks also looks at your sales to work out your average daily sales, leaving out any days you were out of stock. It combines these with your settings to build the report.
Default report columns
Column | What it shows |
Item | The FNSKU of the item. |
SKU | The product SKU. |
Total | Amazon's total unit count. With Exclude Inbound Shipments on, it is Available + Reserved. |
Inbound | Units on their way to Amazon's fulfillment centers. |
Available | Units available for sale on Amazon. |
Reserved | The total units reserved. Hover over Reserved to see 3 parts (listed below the table). |
Days Of Supply | An estimate of how many days your current stock will last, based on recent sales. Days Of Supply = (Total − Safety Stock) ÷ Avg Daily Qty. |
Reorder Date | The suggested date to reorder so you don't run out. It uses your sales and your settings. |
Reorder Qty | The suggested number of units to reorder. Reorder Qty = Avg Daily Qty × Reorder Days. |
Asset Value | The asset value of the inventory. |
% Of Asset | This product's share of your total inventory asset value. |
Gross Sales | The total sales from the product over the period. |
Avg Daily Sales | The average sales per day for the product. |
Sales Qty | The total units sold over the period. |
Avg Daily Qty | The average units sold per day. |
Profit | The total profit from the product's sales. |
Cost | The cost of the units sold in the period. It is $0.00 when the item has no sales. |
ROI | Return on investment. ROI = Profit ÷ Cost. |
Inventory Turnover Rate | How fast your Amazon inventory is sold and replaced over the period (FBA only). |
When you hover over Reserved, you see:
Reserved FC Transfer: Units moving between fulfillment centers.
Reserved FC Processing: Units being processed to enter fulfillment centers.
Reserved Customer Order: Units held for orders not yet shipped.
Customization options
Columns
Click Columns to choose which columns to show or hide.
Customize
Click Customize to set up the report for your business. You can:
Display Items By: Choose how item names show.
Group By: None, FNSKU/SKU, Asin, Parent Asin, Categories, Buyers, Seasons and Gateway.
Transaction Date: Choose order date or posted date.
Days of Sales Data: Enter how many days of sales ConnectBooks should use to work out your average daily sales.
Cost Type: Default Cost, QuickBooks Cost and QuickBooks Historical Cost (only for stores that track inventory), Manual Cost, plus Sellercloud, Goflow or ConnectStock cost types when those are connected.
Ignore Prep Cost: Leave prep cost out of the asset value.
Exclude Inbound Shipments: Leave inbound shipments out of the total and the asset value.
Export
Click Export to download the report to Excel.
Click here to learn how to save your customized filters as a template.
Frequently asked questions
Why does Cost show $0.00 for some items?
Cost only counts units sold in the period, so items with no sales show $0.00.
How is Reorder Qty worked out?
Reorder Qty = Avg Daily Qty × Reorder Days. Avg Daily Qty leaves out days you were out of stock.
Where do I change Reorder Days, Safety Stock or Lead Time?
Click Listings, then click the Inventory Settings tab.