Skip to main content

Reporting

Learn how to dig deep into your data using Prediko reports

Amar Sujith avatar
Written by Amar Sujith
Updated this week

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.

  • Product Name

  • SKU Name

  • Location

  • Estimated Daily Loss and (the amount of sales lost every day due to the item being out of stock)

  • Days since stock out (the number of days since the products have been out of stock)

Health = Out of Stock

Overstock

This report highlights the products with excess inventory, tying up capital and increasing storage costs.

A recommendation here is to run a flash sale to get rid of the overstock.

  • Product Name

  • SKU Name

  • Location

  • Days Left

  • Days of Cover

  • Stock

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.

  • Product Name

  • SKU Name

  • Location

  • Days Left

  • Days of Cover

  • Stock

  • Safety Stock Days

Health = At risk

Deadstock

This report identifies products that haven't sold in 3 months or more, signaling potential write-offs or discounting opportunities.

  • Product Name

  • SKU Name

  • Location

  • Stock

Qty Historical 3 month:≤0
And
Available:>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.

This means we attribute the cost of goods sold to the oldest available inventory first, matching each sale to the corresponding purchase cost in order of arrival.

More about our approach here:

Initial Stock Determination:


We calculate your initial stock by looking at all historical transactions, subtracting purchase orders received, and subtracting your current stock level


For inventory consumed before your first recorded purchase order, we use the unit cost you’ve set in your Shopify store.


FIFO Matching Process:


When you sell an item, the system matches that sale with your available inventory in chronological order.


Sales are matched to the oldest inventory batch first, then proceed to newer batches as needed.


Cost Calculation:


The system tracks both unit cost and landed unit cost (including additional costs specified in your POs).


Each sale’s cost is calculated based on the specific inventory batches it consumed.


For sales that span multiple inventory batches of different costs, a weighted average is calculated.

Here’s a quick example to show how it works:

Initial Setup:

  • Product: T-shirt

  • Initial stock: 10 units at $5.00 each (based on your Shopify unit cost)

Supply Transactions:

  1. Jan 5th: Purchase of 20 units at $6.00 each

  2. Feb 10th: Purchase of 15 units at $6.50 each

Sales Transactions:

  1. Jan 15th: Sale of 15 units

  2. Feb 20th: Sale of 25 units

FIFO COGS Calculation:

  1. Jan 15th Sale (15 units):

  2. First consumes all 10 units from the initial stock: 10 × $5.00 = $50.00

  3. Then consumes 5 units from Jan 5 purchase: 5 × $6.00 = $30.00

  4. Total COGS: $80.00

  5. Average unit cost: $80.00 ÷ 15 = $5.33

  6. Feb 20 Sale (25 units):

  7. First consumes remaining 15 units from Jan 5 purchase: 15 × $6.00 = $90.00

  8. Then consumes 10 units from Feb 10 purchase: 10 × $6.50 = $65.00

  9. Total COGS: $155.00

  10. Average unit cost: $155.00 ÷ 25 = $6.20

This way, your margin always reflects your actual purchase costs, especially when prices change over time.

  • Product Name

  • SKU Name

  • Date

  • Unit Cost

  • Quantity sold

  • COGS

  • Landed cost

  • Landed COGS

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.

  • Product Name

  • Category

  • Value sold

  • Quantity sold

  • % Total Revenue

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.

Key Components:


Starting stock: The inventory level at the beginning of the period


Stock supply: New inventory received during the period (from purchase orders)


Quantity sold: Total units sold during the period


Total supply: Starting stock + Stock supply


Calculation Method:


Sell-Through Rate = (Quantity Sold ÷ Total Supply) × 100%

This gives you the percentage of available inventory that was sold

The higher the percentage, the more efficiently your inventory is moving


Multi-Level Analysis:


Individual SKU level: Direct calculation of STR for each specific item


Product level: Weighted average based on sales volumes across all SKUs of the product


Category level: Weighted average based on sales volumes across all products in the category

Let's work through this with a simple example -

Period: January 1-31, 2023

SKU: Blue T-shirt (Size M)

  • Starting stock: 50 units

  • New supply received: 30 units

  • Total supply: 80 units

  • Units sold: 60 units

  • Sell-Through Rate: (60 ÷ 80) × 100% = 75%

SKU: New Release Hoodie

  • Starting stock: 0 units (not in inventory yet)

  • New supply received: 0 units (PO not recorded)

  • Total supply: 0 units

  • Units sold: 15 units (sales recorded)

  • Sell-Through Rate: (15 ÷ 0) × 100% = >100% (Prediko will display 100%+)

Product: T-shirt (all sizes/colors)

  • Blue T-shirt (M): 75% STR (60 units sold)

  • Red T-shirt (S): 60% STR (30 units sold)

  • Red T-shirt (L): 50% STR (20 units sold)

  • Weighted Product STR: [(75% × 60) + (60% × 30) + (50% × 20)] ÷ 110 = 66.8%

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.

  • Product Type

  • Location

  • Date

  • Quantity Sold

  • Total Stock

  • Sell Through Rate


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

Did this answer your question?