# Item Wise Profit Report

<p class="doc-lead">Analyses profit or loss by item—net profit, unit profit, and profit percentages. Use it to identify best and worst performing products and adjust pricing or purchase strategy.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/sales/reports/profit-item-report?id=overview">Overview</a>
<a href="#/sales/reports/profit-item-report?id=use-cases">Use Cases</a>
<a href="#/sales/reports/profit-item-report?id=filters">Filters</a>
<a href="#/sales/reports/profit-item-report?id=columns">Columns</a>
<a href="#/sales/reports/profit-item-report?id=actions">Actions</a>
<a href="#/sales/reports/profit-item-report?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Sales → Profit Report → Item Wise Profit Report</b>.

<p><b>What it shows.</b> Profit or loss for each item sold in the period. Alongside gross figures (sale quantity, sale amount, sale cost, unit profit, total profit) it shows return figures (return quantity, return S.P./C.P., loss in return) and the net result after returns (net profit, net unit profit, markup %, margin %). Returns (credit notes) are netted so the net columns reflect the true margin after returns. Losses are highlighted on a pink label.</p>

<p><b>When to use it.</b> Find high-margin and loss-making items, compare performance by customer or employee, and refine product mix and pricing.</p>

<b>Item Wise Profit Report</b>
<img src="sales/images/profit-itemwise-report.webp" alt="Profit Itemwise Report" loading="lazy">

<b>Filtration — Customer</b>
<img src="sales/images/profit-itemwise-report1.webp" alt="Profit Itemwise Report1" loading="lazy">

<img src="sales/images/profit-itemwise-report2.webp" alt="Profit Itemwise Report2" loading="lazy">

<b>Filtration — Employee</b>
<img src="sales/images/profit-itemwise-report3.webp" alt="Profit Itemwise Report3" loading="lazy">

<b>Filtration — Item Group</b>
<img src="sales/images/profit-itemwise-report4.webp" alt="Profit Itemwise Report4" loading="lazy">

<b>Filtration — Duration of sale</b>
<img src="sales/images/profit-itemwise-report5.webp" alt="Profit Itemwise Report5" loading="lazy">

<b>Filtration — Advanced Filter</b>
<img src="sales/images/profit-itemwise-report6.webp" alt="Profit Itemwise Report6" loading="lazy">

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Product margin review</b> — Rank items by net profit percentage to focus on high-margin SKUs.</li>
<li><b>Loss item identification</b> — Spot items consistently sold below cost (pink label).</li>
<li><b>Category analysis</b> — Filter by item group to compare profitability across product lines.</li>
<li><b>Customer-specific pricing</b> — Filter by customer to see margin impact of special rates on specific items.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

<ul>
<li><b>Customer</b> — Limit to sales for selected customers.</li>
<li><b>Employee</b> — Filter by sales employee.</li>
<li><b>Item Group</b> — Limit to items in a product group.</li>
<li><b>Duration of Sale</b> — Limit to a date range.</li>
<li><b>Advanced Filter</b> — Additional criteria such as item, brand, or branch—see <a href="advanced-filter.md">Advanced Filter</a>.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| **Item Code / Name** | Item code and name. |
| **Sale Qty** | Total quantity sold in the period. |
| **Report Qty** | Sale quantity shown in the item's report unit (when "Show In Report Unit" is on). |
| **Sale Amount** | Total taxable sales value for the item. |
| **Sale Cost** | Total cost of the quantity sold. |
| **S.P (Avg)** | Average selling price per unit (sale amount ÷ sale qty). |
| **C.P (Avg)** | Average cost price per unit (sale cost ÷ sale qty). |
| **Unit Profit** | S.P (Avg) minus C.P (Avg). |
| **Total Profit** | Gross profit before returns (sale amount minus sale cost). |
| **Profit %** | Gross profit as a percentage of cost. |
| **Rt Qty** | Quantity returned (credit notes). |
| **Rt S.P (Avg)** | Average sale value per returned unit. |
| **Rt C.P (Avg)** | Average cost per returned unit. |
| **Loss In Ret** | Return value minus return cost. |
| **Net Profit** | Total profit minus loss in return (profit after returns). |
| **Net Unit Profit** | Net profit per net unit (sale qty minus return qty). |
| **Markup %** | Net unit profit as a percentage of average cost. |
| **Margin %** | Net unit profit as a percentage of average selling price. |

<p>Loss rows are highlighted with a pink label when net profit is negative.</p>

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>View Details</b> — Drill into bills containing the item where supported.</li>
<li><b>Export</b> — Download to Excel or PDF for product analysis.</li>
<li><b>Print</b> — Print the item-wise profit list.</li>
<li><b>Filter &amp; Sort</b> — Adjust customer, employee, item group, duration, or advanced filters.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<b>Why is an item shown as a loss?</b><br>
When net profit is negative—because sale cost plus loss in return exceeds the sale value for the quantity sold (often due to discounting, cost increases, or high returns)—the item appears as a loss on a pink label.

<b>Are returns considered?</b><br>
Yes. Returns (credit notes) for the item are netted. The Rt Qty, Rt S.P/C.P, and Loss In Ret columns show the return impact, and Net Profit, Markup %, and Margin % are calculated after returns. Total Profit and Profit % show the gross figures before returns.

<b>How do Advanced Filters work?</b><br>
Advanced Filter adds extra criteria beyond the standard filters—see the <a href="advanced-filter.md">Advanced Filter</a> guide for available options.

<b>How is this different from Bill Wise Profit Report?</b><br>
Item Wise Profit aggregates by product across all bills. Bill Wise Profit shows margin per individual invoice.
<p><b>Why do totals differ from Item Wise Sale?</b><br>Sale value minus cost. High volume low margin items may rank differently on profit vs revenue.</p>

<p><b>Can I filter one brand?</b><br>Use brand or item group filter if available before generate.</p>
<hr class="doc-section-divider">