Sales Item P&L Report
The system calculates the net profit or loss for each product and its quantity in the invoice by determining the difference between the sales price and the purchase price.
Here’s how it works:
Date – The date on which the invoice was generated.
Serial Number – The unique invoice number assigned to each transaction.
Product Name – The product details added in the invoices
Unit Price – This is the price at which the product is sold to customers.
Purchase Unit Price – This is the cost at which the product was originally acquired.
This calculation is done after applying any discounts on the sales price.
If the adjusted sales price (after applying the discount) is higher than the purchase price, it results in a profit.
However, if it is lower, it leads to a loss, which will be displayed as a negative value.
This helps in accurately assessing the profitability of each product sold.
Formula: Total Profit/Loss of the products in the Sale Invoice. Includes discount of item level. (QTY * (Unit Price after discount - purchase unit price) )
Please note: Profit/Loss is calculated excluding taxes and extra discounts.