How is Item-wise P&L Report (Purchase Price) Report is calculated in Swipe?

Reports
1

Item-wise P&L Report (Purchase Price)

This report calculates the P&L based on the following below:

  1. Profit or loss calculate per item by comparing:
    (Sale Amount – Purchase Amount)
  2. It will consider items actually sold, not the stock still in inventory.

Example:

Suppose you are selling Pens.

  • Purchase Price per Pen = ₹8

  • Selling Price per Pen = ₹12

  • Quantity Purchased = 100 pens

  • Quantity Sold (in selected date range) = 60 pens.

Report Calculation :

  1. Sale QTY = 60 pens

  2. Sale Amount = 60 × ₹12 = ₹720

  3. Purchase Amount (for sold qty only) = 60 × ₹8 = ₹480

  4. Net Profit/Loss = ₹720 – ₹480 = ₹240 Profit


Final Report Output

image
image1897×768 53.8 KB