The Inventory Report shows a snapshot of what your inventory is (or was) at any given time. As long as Thrive Inventory by Shopventory was installed at the moment, we can tell you exactly what you had on the shelves! And now, you can get those numbers even faster.
The Inventory Report will show your total value of inventory (current or historic). This means you know your total cost of inventory in seconds.
Products or services with quantity tracking "Disabled" will not be included in the inventory report. Since Bundles do not contribute uniquely to inventory value, these are excluded. Products with negative quantities in stock do not count against inventory value.
NOTE: If you plan to reverse your bundle/component setups, be aware that you will be essentially starting with a new set of inventory and inventory history for those products. We encourage you to download any relevant reports before making the switch.
To get started, enter the point in time you want the report generated for, or select from one of the presets. The inventory report will be generated for a specific moment in time, vs. a Sales Report where you might want to see a range (whether that's 24 hours, a week, month or year). If you are wanting to see how your inventory has changed over a period of time, we recommend generating an Inventory Change Report.
Once that report has been generated, you'll see a screen that looks similar to this:
For more information on the Old Inventory Report, click here.
We've added a Potential Profit summary box, along side the existing Total Value, Potential Revenue and Quantity in Stock.
You can use the Filter button, or Search field to narrow your scope. When you filter the report in anyway, the summary boxes above will show the new results based on the filter.
The "Display" button will allow you to customize the columns of the report. The available columns include:
In Stock = Units in stock at the specified time
List Price = Current retail price
Cost/Unit = Range of costs applied to the units in stock
Total Value = Total cost of the units in stock
Potential Revenue = In Stock x List Price
Potential Profit = The sum of (Price - Cost) for each unit in stock with a cost
Profit Margin % = (Price - Cost) / Cost, converted to a percentage, of the current lot
Markup* = (Price - Cost) / Cost, converted to a percentage, of the current lot
*Click the "Display" button to enable these options
If a product was received at varying costs, the cost column will be listed as a range. This happens because we calculate cost on the inventory report based on lot cost (not default cost). If you would like to spot-check a product to ensure the right cost is being calculated, you can do that in the lot history.
The Summary Boxes are the multi-colored boxes at the top of the report that provide a synopsis of certain aspects of the report. Included in this report are:
Quantity in Stock = Sum of In-Stock column
Downloading your Report
To save your report (or schedule it to run for you), click the "Actions" button. Options to "Schedule this Report" or download as a PDF or CSV will be available for you. For more information on saving and scheduling reports, click here:
Things to Note:
At the bottom left corner of the page, you'll be able to navigate through pages using bottom the arrow buttons.
Show more products per page, by selecting a new option on the bottom-right of the page.
Click on column heading to re-sort the entire report.
The (old) Inventory Report
The (old) Inventory Report (click here) provides much of the same information, but is a slightly limited when compared to the new version.
Click the following links for more information on:
The columns on the Inventory Report include:
Potential Profit (including a Profit Margin %)
Still have questions? We are here to help!
Start a chat with us by clicking the chat bubble at the bottom-right of this page.