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)
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 Sale price: taken from item Purchase price: taken from item Amount Sold = Inventory * Sale price Amount Purchased: = total current inventory value taken from inventory receiving vouchers 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.
