Stock Summary Report

The Stock Summary report displays the details of all your item’s opening stock, quantity sold (Export In Period), purchased (Import In Period), and closing stock (calculated as Opening Stock + Quantity In - Quantity Out) for a given period. This report is generated based on the accounting stock of your inventory items and can be filtered based on warehouse locations.

First, I will explain the calculation formula of the Stock Summary report

Open Stock Qty: quantity of inventory imported at the beginning of the period

Open Stock Amount: = qty * purchase price

Import In Period Qty: total quantity imported by filter period

Import In Period Amount: is the total amount taken from inventory receiving vouchers according to the filter period

Export In Period Qty: total quantity exported by filter time

Export In Period Amount: is the total amount taken from inventory delivery vouchers according to filter time

Closing Stock = Open Stock Qty + Import In Period Qty - Export In Period Qty

Closing Stock Amount = calculates the total remaining inventory value according to the import price of each batch of inventory

For example, an item with opening stock = 0, , we create 2 inventory receiving vouchers with different purchase prices:

1st : quantity = 10 ; purchase price = 20

2nd: quantity = 5 ; purchase price = 15

Then create inventory delivery voucher with quantity = 12 (Because the export method is FIFO, 10 products are calculated with purchase price = 20; 2 products are calculated with purchase price = 15 -> remaining 3 products are calculated with purchase price = 15)

=> Closing Stock= 3

=> Closing Stock Amount = 3*15 = 45 (15 is the purchase price of the second inventory receiving voucher)

Inventory Analytics

Profit Rate Differences = ((Profit Rate Inventory - Default Profit Ratio ) / Default Profit Ratio) * 100

Profit Rate Inventory = [(sale price / Average Cost of Inventory) - 1] * 100 ( Calculate the selling price using the cost and profit rate)

Profit Rate Inventory = [1 - (Average Cost of Inventory / sale price)] * 100 (Calculate the selling price using the selling price and profit rate)

Inventory Valuation Report

The report calculates the expected profit based on the purchase and sale price of the item.

Inventory = Closing Stock

Expected Profit = Amount Sold - Amount Purchased

Warranty period report

Warranty period is calculated from the date of creation of delivery note + warranty (month)

To get the data for this report, first need to declare the warranty (month) for the product.
Next, Create the inventory delivery voucher and select product above.