Item-wise P&L (Purchase)
This report calculates the Profit & Loss (P&L) for all purchased items based on the stock availability and total purchase value. It provides insights into the cost of goods acquired and helps track overall stock value.
Column Description
Opening QTY: Starting quantity of the item on the selected date
Quantity in Stock: Current quantity of the product as of today
Sale Value: Total Sale Value of the item in the selected date range. (QTY * Unit Price)
Purchase Value: Total Purchase Value of the item in the selected date range. (QTY * Unit Price)
Purchase Return Value: Total Purchase Return Value of the item in the selected date range. (QTY * Unit Price)
Sale Return Value: Total Sale Return Value of the item in the selected date range. (QTY * Unit Price)
Average Sale Price: Sales Value / Sales Qty
Average Purchase Price: Purchase Value / Purchase Qty
Average Sale Return Price : Sales Return Value / Sales Return Qty
Average Purchase Return Price : Purchase Return Value / Purchase Return Qty
Margin per unit : Avg sale price - Average purchase price
Realized profit/Loss : Sales Qty * Margin per unit
Net Profit/Loss : Total Profit/Loss of the item in the selected date range. (Sale Value - Purchase Value - Purchase Return Value + Sale Return Value)
Please note: Profit/Loss is calculated excluding taxes and extra discounts.