# Employee Wise Profit Report

<p class="doc-lead">Profit or loss by sales employee for a period — sale amount, cost, returns, and margin. Use it to compare rep-level profit, not just volume.</p>

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

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

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

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

Report title in ERP: <b>Employee Wise Profit Report</b>

<p><b>What it shows.</b> One row per employee with sale amount, sale cost, return amount, return cost, profit, markup %, and margin %. There is no expense column. Invoices with no employee are grouped as <b>Other</b>.</p>

<p><b>When to use it.</b> Evaluate sales team profitability, coach reps on discounting, and align incentives with margin — not just volume.</p>

<p><b>How amounts are calculated.</b> Same calculation as <a href="#/sales/reports/profit-bill-report">Bill Wise Profit Report</a>, then grouped by the employee on the sale invoice. Includes Approved and Closed sale invoices (opening invoices are excluded). Sale amount is invoice sale amount before tax; sale cost is cost of the goods sold from the invoice journal. Approved and Closed credit notes on those invoices are subtracted. Sale expenses are <b>not</b> subtracted. <b>Profit</b> = (Sale Amount − Sale Cost) − (Return Amount − Return Cost). Unassigned invoices appear as <b>Other</b>.</p>

<img src="sales/images/profit-employee-report.webp" alt="Employee Wise Profit Report with sale value, cost, and profit" loading="lazy">

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

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

<ul>
<li><b>Sales team margin review</b> — Rank employees by total profit for monthly performance meetings.</li>
<li><b>Discount coaching</b> — Identify reps with high volume but low or negative profit.</li>
<li><b>Incentive design</b> — Balance volume-based commissions with margin using this report.</li>
<li><b>Territory comparison</b> — Use <b>Zone</b>, <b>Branch</b>, or <b>Route</b> in Advanced Filter.</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. Respects your employee access in the Sale module.</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>
</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** |
|------------|-----------------|
| Slno | Row number. |
| Employee | First and last name of the employee on the invoice. Bills with no employee are grouped as <b>Other</b>. |
| Sale Amount | Total taxable sales value attributed to the employee. |
| Sale Cost | Cost of goods sold on those sales. |
| Return Amount | Sale amount before tax of credit notes on the employee's invoices. |
| Return Cost | Cost reversed on those returns. |
| Profit | (Sale Amount − Sale Cost) − (Return Amount − Return Cost). |
| Markup % | Profit as a percentage of net cost (Sale Cost − Return Cost). |
| Margin % | Profit as a percentage of net sale (Sale Amount − Return Amount). |
| Footer Total | Column totals and overall markup % and margin %. |

<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>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</li>
</ul>

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

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

<p><b>How is profit assigned to an employee?</b><br>From the employee recorded on each sale invoice. Invoices with no employee appear as <b>Other</b>.</p>

<p><b>Are returns included?</b><br>Yes. Credit notes against the employee's invoices are subtracted. Return Amount and Return Cost show the reversal.</p>

<p><b>Are sale expenses included?</b><br>No. This report has no Expense column. Use <a href="#/sales/reports/profit-bill-report">Bill Wise Profit Report</a> for expenses per invoice.</p>

<p><b>How is this different from Employee Wise Sale Report?</b><br><a href="#/sales/reports/employee-sale-report">Employee Wise Sale Report</a> shows bill count and total value. This report shows profit and margin after cost and returns.</p>

<p><b>Can I filter by one employee?</b><br>There is no Employee dropdown on this header. Use <a href="#/sales/reports/profit-bill-report">Bill Wise Profit Report</a> filtered by employee for invoice detail, or export this list.</p>

<p><b>Should commission use this report?</b><br>Use <a href="#/sales/reports/sale-target-commision">Sale Target Commission</a> for payroll. This report is for margin management.</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-customer-report">Customer Wise Profit Report</a></li>
<li><a href="#/sales/reports/employee-sale-report">Employee Wise Sale Report</a></li>
<li><a href="#/sales/reports/sale-target-commision">Sale Target Commission</a></li>
</ul>
