# Bill Item Wise Profit

<p class="doc-lead">Item-line profit on each sale invoice — sale value, cost, profit, profit %, margin %, and markup %. Use it when bill-wise profit is not detailed enough.</p>

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

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

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

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

Report title in ERP: <b>Bill Item Wise Profit</b>

<p><b>What it shows.</b> One row per sale invoice item line with <b>In Charge</b>, <b>Order</b>, quantity, <b>Unit</b>, <b>SP</b>, <b>Total Sale Value</b>, <b>Total Cost Value</b>, <b>Profit</b>, <b>Profit %</b>, <b>Margin %</b>, and <b>Markup %</b>. Loss lines are highlighted in red. There is no bill-total column.</p>

<p><b>When to use it.</b> Find which items on a bill made or lost money, audit discounts at line level, and review margin by customer or employee.</p>

<p><b>How amounts are calculated.</b> Includes Approved and Closed sale invoices (opening invoices are excluded). <b>Total Sale Value</b> is the line sale amount before tax. <b>Total Cost Value</b> is inventory cost from the delivery note or the invoice (receipt notes against the delivery note only adjust cost to the invoiced quantity). <b>Profit</b> = Total Sale Value − Total Cost Value. <b>Profit %</b> and <b>Markup %</b> are profit as a percentage of cost. <b>Margin %</b> is profit as a percentage of sale value. Credit notes and sale expenses are <b>not</b> netted on this report. For margin after returns, use <a href="#/sales/reports/profit-item-report">Item Wise Profit Report</a> or <a href="#/sales/reports/profit-bill-report">Bill Wise Profit Report</a>.</p>

<img src="sales/images/profit-bill-item-report.webp" alt="Bill Item Wise Profit report with item-level sale value, cost, and profit" loading="lazy">

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

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

<ul>
<li><b>Product margin review</b> — Sort by Loss or Loss% to find lines sold below cost (red rows).</li>
<li><b>Pricing audit</b> — Check that discounted lines still keep an acceptable <b>Margin %</b>.</li>
<li><b>Customer profitability</b> — Filter by <b>Customer</b> to see which items drive profit or loss at an account.</li>
<li><b>Employee review</b> — Filter by <b>Employee</b> to review margin on handled sales.</li>
</ul>

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

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

<p><b>Header (quick filters)</b></p>

<ul>
<li><b>Date</b> — date range for sale invoices. Defaults to today.</li>
<li><b>Customer</b></li>
<li><b>Employee</b> — respects your employee access in the Sale module.</li>
<li><b>Item</b></li>
<li><b>Sort by Date</b> / <b>Sort by Profit</b> / <b>Sort by Loss</b> / <b>Sort by Profit%</b> / <b>Sort by Loss%</b></li>
<li><b>Show Monthly Totals</b> / <b>Hide Monthly Totals</b> — after the last item line of each month, insert a total row (qty, sale value, cost, profit, profit %, margin %, markup %). Rows stay in date order. Sorting by profit or loss hides the month rows; turn the button on again to sort by date and show them. The footer <b>Total</b> row remains the overall total.</li>
</ul>

<p><b>Advanced Filter</b> (filter icon) — additional fields:</p>

<ul>
<li><b>Customer</b></li>
<li><b>Customer Group</b></li>
<li><b>Customer Category</b></li>
<li><b>Center</b></li>
<li><b>Form Type</b> — sale type on the invoice</li>
<li><b>State / Province</b></li>
<li><b>Zone</b> *(when zone access is enabled)*</li>
<li><b>Branch</b> *(when multiple branch is enabled)*</li>
<li><b>Route</b> *(when route access is enabled)*</li>
<li><b>Item Group</b></li>
<li><b>Brand</b></li>
</ul>

<p>Tap <b>Clear</b> after applying Advanced Filter to reset advanced filters.</p>

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

<h2 id="layout">Layout &amp; columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| Date | Sale invoice date. |
| Inv No. | Invoice number. Click to open the invoice. |
| In Charge | Employee on the invoice. |
| Order | Linked sale order number. |
| Customer | Customer name. |
| Item | Item on the line. |
| Qty | Net quantity sold. |
| Unit | Line unit. |
| SP | Selling price (Total Sale Value ÷ Qty). |
| Total Sale Value | Line sale amount before tax. |
| Total Cost Value | Inventory cost for the line. |
| Profit | Total Sale Value minus Total Cost Value. |
| Profit % | Profit as a percentage of Total Cost Value. |
| Margin % | Profit as a percentage of Total Sale Value. |
| Markup % | Same as Profit % (profit ÷ cost). |
| Footer Total | Quantity, sale value, cost, profit, and percentages for the page. |

<p>Loss rows (Profit less than zero) are highlighted in red.</p>

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

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

<ul>
<li><b>Generate</b> — run the report for the selected filters</li>
<li><b>Show Monthly Totals</b> / <b>Hide Monthly Totals</b></li>
<li><b>Advanced Filter</b> — open additional filter fields</li>
<li><b>Clear</b> — reset active advanced filters</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report (company header and date range are included)</li>
<li><b>Inv No.</b> — open the sale invoice</li>
</ul>

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

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

<p><b>How is this different from Bill Wise Profit Report?</b><br><a href="#/sales/reports/profit-bill-report">Bill Wise Profit Report</a> is one row per invoice and nets credit notes and sale expenses. This report is one row per item line and does not net returns or expenses.</p>

<p><b>Why are some lines red?</b><br>Profit is negative — Total Sale Value is less than Total Cost Value.</p>

<p><b>Where does cost come from?</b><br>Inventory cost on the delivery note or sale invoice at the time of sale.</p>

<p><b>Are returns deducted here?</b><br>No. Credit notes are not subtracted. Use <a href="#/sales/reports/profit-item-report">Item Wise Profit Report</a> or <a href="#/sales/reports/profit-bill-report">Bill Wise Profit Report</a> for margin after returns.</p>

<p><b>Is there a Bill Total column?</b><br>No. Totals are at line level and in the footer.</p>

<p><b>How do monthly totals work?</b><br>Turn on <b>Show Monthly Totals</b>. A total row is inserted after the last item line of each month. Sorting by profit or loss hides those rows; turn the button on again to sort by date and show them.</p>

<p><b>Do I need special permission?</b><br>Yes. Your user role must include access to profit reports.</p>

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

<h2 id="related">Related</h2>

<ul>
<li><a href="#/sales/reports/profit-bill-report">Bill Wise Profit Report</a></li>
<li><a href="#/sales/reports/profit-item-report">Item Wise Profit Report</a></li>
<li><a href="#/sales/estimated-cost-margin">Estimated Cost Margin</a></li>
</ul>
