Introduction:
While our current Inventory table can be used to build reports, it can be a bit overwhelming as there are a ton of columns to choose from. Sometimes, it's hard to know where to start.
So, we decided to build a dedicated Reporting section where you can easily access ready-made reports and build on top of the existing templates.
You can access Reporting from the main navigation menu
What do you see under Reporting?
Right now, you see 4 default reports that can be used to monitor your inventory health and the risk of stockouts.
Let's dig into each of these reports and understand their descriptions, columns, and default filters.
Report | Description | Columns | Default filters |
Stock out | This report helps you identify products that are out of stock, thereby leading to missed sales opportunities.
It's a mission-critical report, and we recommend that you always keep a tab of the products that are currently out of stock to restock them promptly. |
| Health = Out of Stock |
Overstock | This report highlights the products with excess inventory, tying up capital and increasing storage costs. |
| Health = Overstock |
Stockout Risk | This report flags products that are at risk of running out soon, based on current stock levels and safety stock thresholds. |
| Health = At risk |
Deadstock | This report identifies products that haven't sold in 3 months or more, signaling potential write-offs or discounting opportunities. |
| Qty Historical 3 month:≤0 |
COGS (FIFO) | The FIFO (First-In-First-Out) COGS (Cost of Goods Sold) calculation determines your inventory costs based on the principle that the oldest inventory items are sold first. This provides an accurate picture of your cost of goods sold over time.
Here’s a quick example to show how it works:
Supply Transactions:
Sales Transactions:
FIFO COGS Calculation:
This way, your margin always reflects your actual purchase costs, especially when prices change over time. |
| None |
ABC | This report helps you classify products by their impact on sales using the 80/20 rule to focus efforts and reduce costs with ABC inventory analysis.
Know what your most important products are!
This report always lists your most important products in descending order of the revenue generated. |
| None |
Sell Through Rate (STR) | The Sell-Through Rate (STR) measures the percentage of inventory that has been sold relative to the available supply during a specific period. This metric helps you understand how effectively your inventory is moving.
This gives you the percentage of available inventory that was sold The higher the percentage, the more efficiently your inventory is moving
SKU: New Release Hoodie
Product: T-shirt (all sizes/colors)
This calculation shows that you sold 75% of the available Blue T-shirts (Size M) and 66.8% of all T-shirts overall during January, providing insights into inventory performance at different levels of detail. |
|
|
Sorting:
You can sort the data on a report using any of the available columns on each report (in either ascending or descending order)
Here's an example:
Filters:
There is a default filter applied to each report, which distinguishes it from other reports. For example, on the Stockout report, the default filter applied is Health = Out of Stock, and you cannot edit or delete this filter on this report.
However, you can add additional filters on top of this one. When you add a set of filters, you can save that as a view under this report to always revisit later.
Please note that a view is created based on the filters you added to your report.
Clashing of filters:
If the filters added to your view are conflicting with the default filters enforced by this report, then the app will notify you to adjust them.
Sampling:
This applies to the COGS (FIFO) report, where you can sample the report depending on the time frame selected. The sampling options are Monthly, Quarterly, and Yearly. This is nothing but grouping the COGS for your products for a monthly, quarterly, or yearly time frame.
Export options:
You can export the report as an Excel file and when you hit the "Export" button at the top, we will send you the exported file to your email address.
Upcoming improvements:
Please note that we are coming up with custom reports in the next version.
You can add/remove columns within the standard reports and can save them as custom reports