Premium Report - Stock Intake & Sales Velocity

Stock Intake & Sales Velocity

This report is for merchants who are looking to measure their stock vs. sales in any given month. 

Using this report, you can see exactly how much you sold of each item, how much you stocked, key metrics like Resale Ratio & Sell Through Rate, and finally, how long current inventory will last based on the quantity sold each day.

This makes it ideal for proper inventory management, tracking how fast items are selling, and determining which items you need to think about re-ordering.  

You can find this report under Inventory History in the left-hand menu.

Inventory History needs to be enabled by our Report Toaster staff. Please contact us at support@cloudlab.com so we can set these reports up for your account.

As Premium Reports, these are available on all Paid Plans of Report Toaster. If you aren't signed up, follow these steps to upgrade your account.

Here is what you need to be familiar with to understand the Stock Intake & Sales Velocity report.

Please note - Inventory History is only tracked from the time this feature is enabled for your account.

For example, if we enabled the feature for you on 6/20/23, you would have Inventory history from this date onwards - so you may want to adjust your date range on the report accordingly..

1.) Available (start): The number of units of the product in stock at the start of the time period.

This is determined by the first date on the date range (top right). 

For example, imagine the report was set to Last 30 Days, today is 6/24/24.

If I had 480 Drifting Ducks in stock on 5/24/24, then  Available (Start) would be 480.

2.) Available (end): The number of units of the product in stock at the end of the time period.

This is determined by the last date on the date range (top right). 

For example, imagine the report was set to Last 30 Days, today is 6/24/24.

If I had 479 Drifting Ducks in stock on 6/24/24, then  Available (end) would be 479

3.) Days in stock: The number of days the product was in stock during the selected time period (based on the date range, top right).

For example, the Drifting Duck was in stock for all 30 days for the Last 30 Days that the report currently covers.

4.) Quantity: The number of units that have been sold during the time period. 

For example, 2,319 Drifting Ducks have been sold in the Last 30 Days. 

5.) Stocked: The number of units that must have been added to the inventory during the time period.

This number is worked out by taking the difference between Available end and the (Available start minus Quantity).

For example, if we started with 480 Drifting Ducks, ended with 479, and sold 2,319 of them, then we must have stocked 2,318. 

6.) Resale Ratio: The Quantity of units sold divided by the number of units Stocked (rounded to 2 decimal places).

For example, 2,319 Drifting Ducks have been sold, 2,318 were stocked, so 2,319/2,318 = 1.00

7.) STR: The Sell Through Rate (STR) for a particular item.

This is worked out by taking the Quantity divided by (Available End + Quantity) x100.

For example, 2,319 Drifting Ducks have been sold, we ended with 479 in stock, so 2319/ (479+2319) x 100 = 82.88% 

8.) Daily Quantity Sold: The average number of units sold of an item per day that it is in stock.

This is worked out by taking Quantity divided by Days in stock.

For example, if 2,319 Drifting Ducks have been sold and it was in stock for 30 days, then we sold an average of 77.30 per day.

9.) Daily Available: The number of days the product will continue to be Available, based on the current stock (and assuming no further restocks). 

This is worked out by taking Available end divided by Daily Quantity Sold.

For example, if we have 479 Drifting Ducks left in Stock, we sell an average of 77.30 per day, then we will run out of current inventory in 6 days time. Might be time to arrange another restock?

Like all Report Toaster reports, these reports are fully customizable - so you can add/remove columns, introduce a filter or change the sort to suit your individual needs. See our basic guides here for more info.

For other premium reports you can add to your account, check out our other article guides here. 

• Related Articles

• Premium Report - Sell Through Reports

  Sell Through Rate (By Product, By Variant, By Vendor) Sell Through Reports are used to compare how much of something has been sold vs how much you have in stock. These reports all follow a very similar format - tracking your Sell Through Rate on a ...

• Premium Report - Sales Velocity

  Sales Velocity - Days of Inventory Available Sales Velocity reports are used to see how quickly something has been selling so you can plan your inventory accordingly. As a Premium Report, this is available on all Paid Plans of Report Toaster. If you ...

• Premium Report - Stock Report

  Stock Reports Stock Reports are used to compare how much of something has been sold vs how much you have in stock at each of your different locations. These reports follow a similar format to the Sell Through Reports, but the available quantity ...

• Premium Report - Dead Stock Products/Variants

  Dead Stock Products/Variants For merchants who are wanting to tidy up their inventory or perhaps work out which items to discount, Dead Stock reports are useful to see which items have not been selling over a given time period. This report follows a ...

• Premium Report - Inventory Value by Location

  Inventory Value by Location Inventory Value Reports are used by merchants to see how much the amounts and value of their current stock. For merchants who store inventory at multiple locations however, sometimes it's important to see your stock on a ...