Item-wise P&L Report (Purchase) Report
This report calculates the P&L based on the following below:
-
Profit or loss calculate per each purchased item by comparing:
(Sale Value – Purchase Value –Sale Return Value + Purchase Return Value) -
It considers both opening stock till selected date and current stock availability of product as of today for reference.
Example:
Suppose you have one bag.
Particulars | Value |
---|---|
Opening Qty | 10 units |
Quantity in Stock (Today) | 5 units |
Purchase during period | 20 units @ ₹4000 each |
Sale during period | 22 units @ ₹5000 each |
Purchase Return | 2 units @ ₹4000 each |
Sale Return | 1 unit @ ₹5000 each |
First Calculate the Values.
- Sale Value
22 units × ₹5000 = ₹110000 - Purchase Value
20 units × ₹4000 = ₹80000 - Purchase Return Value
2 units × ₹4000 = ₹8000 - Sale Return Value
1 unit × ₹5000 = ₹5000
Net Profit/Loss
Sale Value – Purchase Value –Sale Return Value + Purchase Return Value
= ₹110000 – ₹80000 – ₹5000 + ₹8000
= ₹27000 Net Profit
Final Report Output