Skip to main content

Reporting

Learn how to dig deep into your data using Prediko reports

Amar Sujith avatar
Written by Amar Sujith
Updated over a week ago

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

Inventory on hand

This report helps you view current stock levels for all products and variants to track availability and plan restocks effectively.

  • Product Name

  • SKU

  • Product Type

  • Units in Stock

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.

  • Product Name

  • Product Type

  • Date

  • Net Sales

  • % Total Revenue

  • Net Quantity

  • % Total Quantity

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.


  • Product Name

  • SKU

  • Product Type

  • Unit Cost

  • Units in stock

  • Inventory Value

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.

Key Components:

  • Quantity sold: Total units sold during the period

  • Ending stock: The inventory level at the end of the period

  • Total supply: Quantity sold + Ending stock

Calculation Method:

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

This gives you the percentage of total handled 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: Sum of quantity sold across all SKUs of the product divided by the sum of total supply across all SKUs of the product

  • Category level: Sum of quantity sold across all products in the category divided by the sum of total supply 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)

  • Quantity sold: 60 units

  • Ending stock: 20 units

  • Total supply: 60 + 20 = 80 units

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

SKU: New Release Hoodie

  • Quantity sold: 15 units

  • Ending stock: 0 units (sold out)

  • Total supply: 15 + 0 = 15 units

  • Sell-Through Rate: (15 ÷ 15) × 100% = 100%

Product: T-shirt (all sizes/colors)

  • Blue T-shirt (M): Quantity sold = 60, Total supply = 80

  • Red T-shirt (S): Quantity sold = 30, Total supply = 50

  • Red T-shirt (L): Quantity sold = 20, Total supply = 40

  • Product T-shirt STR: (60+30+20) ÷ (80+50+40) = 110 ÷ 170 = 64.7%

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

Did this answer your question?