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 |
Inventory on hand | This report helps you view current stock levels for all products and variants to track availability and plan restocks effectively. |
|
|
Sales and Quantities | This report gives you the percentage of inventory sold during a period, calculated based on the starting inventory plus any stock received from suppliers within that timeframe. |
|
|
Inventory Value | This report gives you the total monetary value of your inventory, calculated based on the cost price of each product multiplied by the quantity on hand.
|
|
|
Sell Through Rate (STR) | The Sell-Through Rate (STR) measures the percentage of inventory that has been sold relative to the total inventory handled during a specific period. This metric helps you understand how effectively your inventory is moving.
Calculation Method:
Let’s work through this with a simple example:
SKU: New Release Hoodie
Product: T-shirt (all sizes/colors)
This calculation shows that you sold 75% of the Blue T-shirts (Size M) and 64.7% 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 save them as custom reports
Can I customize my reports?
Yes, if you have already created custom views of your Buy table or Inventory page, you can use them on your Reports.
Once you apply those custom views, you can further customize the Report by adding more filters and then save it as a new report.
You can find the new report on the Reports page.
Can I schedule reports to send to my inbox?
Absolutely!
Once you finalize your desired report with the filters, simply click the "Schedule Send button at the top to check the scheduling options.
Enter the email recipients (separated by a comma)
The frequency and time, and finally
The start date
Click Schedule