# Employee Wise Purchase Report

<p class="doc-lead">Summarizes purchase activity by employee—number of purchases, total value, and bill totals. Use it to monitor procurement workload, accountability, and employee-level spend patterns.</p>

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

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

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

Go to <b>Purchase → Employee Reports → Employee Wise Purchase</b>.

<p><b>What it shows.</b> One row per employee with purchase count, total value, and aggregate bill total for purchases they processed or are in charge of during the selected period.</p>

<p><b>When to use it.</b> Review team productivity, identify employees handling high-value procurement, and support performance or audit reviews.</p>

<img src="purchase/images/purchase-employee-report.webp" alt="Employee Wise Purchase Report with purchase count, total, and bill total" loading="lazy">

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

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

<ul>
<li><b>Team workload review</b> — Compare purchase counts across employees to balance procurement assignments.</li>
<li><b>High-value handler audit</b> — Identify employees with the highest bill totals for spot checks or approval policy review.</li>
<li><b>Drill-down review</b> — Click an employee to open their individual purchases for detailed review.</li>
<li><b>Period comparison</b> — Run for consecutive months to track changes in employee-level purchase volume.</li>
</ul>

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

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

<ul>
<li><b>Date Range</b> — Limit purchases to a specific period.</li>
</ul>

<p>Click an employee row to drill into their purchases in the Purchase Report (filtered by that employee).</p>

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

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

| **Column** | **Description** |
|------------|-----------------|
| **Name** | Full name of the employee. |
| **Employee Code [ID]** | Employee code with the system ID in brackets. |
| **No. of Purchases** | Count of purchase transactions handled by the employee. |
| **Value Total** | Total purchase value (before bill-level adjustments) for the employee. |
| **Bill Total** | Aggregate of final bill totals on those purchases. |

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

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

<ul>
<li><b>Generate</b> — run the report for the selected date range</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Row drill-down</b> — click an employee to open their purchases in the Purchase Report</li>
</ul>

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

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

<b>Which employee is counted—in charge or creator?</b><br>
Totals reflect the employee assigned as in charge on the purchase transaction, per system configuration on purchase documents.

<b>What is the difference between Value Total and Bill Total?</b><br>
Value Total is the purchase value before final bill adjustments; Bill Total is the sum of final bill amounts including tax and rounding as posted.

<b>Are purchase returns deducted?</b><br>
Returns may appear as separate transactions depending on configuration. Verify with purchase return reports for net employee activity.

<b>Can inactive employees appear?</b><br>
Yes, if they processed purchases in the selected date range.

<b>Which document types are included?</b><br>
Purchase invoices and related purchase documents where an employee is recorded as in charge, per the report filters.

<b>Why is my report empty?</b><br>
No purchase activity matches the date range, employee filter, or branch scope.

<b>Does this include purchase orders only?</b><br>
No. Totals reflect billed purchase value (invoices), not open order commitments unless configured otherwise on the report.

<b>Video — Purchase reports overview</b>
<iframe width="560" height="315" src="https://www.youtube.com/embed/bcx8cJOc2MU?si=ELG5uiIFHDTw7BN_" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
