# Understanding Item-wise Profit & Loss (P&L) Report in Swipe

**URL:** <https://community.getswipe.in/t/understanding-item-wise-profit-loss-p-l-report-in-swipe/2621>\
**Category:** Reports\
**Created:** [March 28, 2025, 10:35am UTC](https://community.getswipe.in/t/understanding-item-wise-profit-loss-p-l-report-in-swipe/2621 "2025-03-28T10:35:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rupa](https://yyz1.discourse-cdn.com/flex003/user_avatar/community.getswipe.in/rupa/32/161_2.png) [@Rupa](https://community.getswipe.in/u/Rupa)\
**Post date:** [March 28, 2025, 10:35am UTC](https://community.getswipe.in/t/understanding-item-wise-profit-loss-p-l-report-in-swipe/2621/1 "2025-03-28T10:35:02Z")

</div>

**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 –Sale Return Value + Purchase Return Value)`

 ![image](https://canada1.discourse-cdn.com/flex003/uploads/getswipe/original/2X/f/f6d21e416ab8daa9680ffd597993364f7954e561.png)

**Please note** : Profit/Loss is calculated excluding taxes and extra discounts.