# Employee Payrun Category Splitup

<p class="doc-lead">Employee payrun amounts split by payment category and deduction category for a date range. One row per employee; category names are the amount columns.</p>

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

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

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

Go to <b>Payroll → Payroll Reports → Employee Payrun Category Splitup</b>.

<p><b>What it shows.</b> One row per employee. Pay runs in the selected process-date range are summed, then split into a column for each payment category and each deduction category that has an amount. A totals row sums every amount column.</p>

<p><b>When to use it.</b> Month-end salary cost by component (basic, allowances, overtime, and deductions) across employees, without opening each pay run.</p>

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

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

<ul>
<li><b>Payroll accountant</b> — How much basic, HRA, and other allowances were paid this month, employee by employee?</li>
<li><b>Finance</b> — Export category columns to reconcile wages by component.</li>
<li><b>Department review</b> — Filter by department and compare category totals for that team.</li>
</ul>

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

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

| **Filter** | **Description** |
|------------|-----------------|
| Date range | Pay runs whose process date falls in this range (default: current month). |
| Employee | Limit the report to one employee. Leave blank for all employees you can access. |
| Department | Limit the report to employees in one department. |

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

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

| **Column** | **Description** |
|------------|-----------------|
| Code | Employee code. |
| Employee | Employee name. |
| Department | Employee’s current department. |
| Payments | One column per <a href="#/payroll/payment-categories">payment category</a> that has a non-zero amount in the result, then a <b>Total</b>. |
| Deductions | One column per <a href="#/payroll/deduction-categories">deduction category</a> that has a non-zero amount in the result, then a <b>Total</b>. |
| Net | Payment total minus deduction total. |

<p>Categories with no amount in the selected range are omitted. A <b>Total</b> row at the bottom sums each amount column.</p>

<p>Expense claim lines on the pay run are not columns. Only payment lines and deduction lines are included.</p>

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

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

<ul>
<li><b>Generate</b> — run the report</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>Which date is used?</b><br>The pay run process date, not the pay period from/to dates. This matches <a href="#/payroll/reports/department-wise-salary-report">Department Wise Salary</a>.</p>

<p><b>What pay-run statuses are included?</b><br>Approved and Closed pay runs only. Regular and Bonus pay runs are both included.</p>

<p><b>Why is a category missing?</b><br>A category appears only when at least one included pay run has a non-zero amount for it in the selected range.</p>

<p><b>How is Net calculated?</b><br>Sum of the payment category columns minus the sum of the deduction category columns for that employee. It does not include expense reimbursements.</p>

<p><b>An employee has several pay runs in the range. How many rows?</b><br>One. Amounts from those pay runs are added together.</p>

<p><b>Why don’t I see every employee?</b><br>Only employees with an included pay run in the range are listed. User employee filters for payroll still apply.</p>

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

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

<ul>
<li><a href="#/payroll/pay-run">Pay Run</a></li>
<li><a href="#/payroll/reports/employee-wise-payrun-report">Employee Wise Pay Run</a></li>
<li><a href="#/payroll/reports/department-wise-salary-report">Department Wise Salary</a></li>
<li><a href="#/payroll/payment-categories">Payment Categories</a></li>
<li><a href="#/payroll/deduction-categories">Deduction Categories</a></li>
</ul>
