# Employee Wise Salary Report

<p class="doc-lead">Employee payroll balance movement for a date range. Each row shows opening balance, period activity across pay runs, payments, advances, and expense claims, and closing balance — the full payable reconciliation per employee.</p>

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

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

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

Go to <b>Payroll → Payroll Reports → Employee Wise Salary</b>.

<p><b>What it shows.</b> One row per active employee (joined before period end, not terminated before period start) with nine amount columns plus employee code, name, and department.</p>

<p><b>When to use it.</b> Month-end payroll reconciliation, comparing movement columns across employees, and verifying closing balance against Employee Statement.</p>

<p><img src="payroll/images/employee-wise-salary.webp" alt="Employee Wise Salary Report" loading="lazy"></p>

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

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

<ul>
<li><b>Payroll team</b> — Reconcile all employees' payable movement for the month in one grid.</li>
<li><b>Department review</b> — Filter by department (from Department Wise Salary drill-down or department selector).</li>
<li><b>Investigation</b> — Click employee name to open <a href="#/payroll/reports/employee-statement-report">Employee Statement</a> for transaction detail.</li>
</ul>

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

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

| **Filter** | **Description** |
|------------|-----------------|
| Date range | Period for movement columns (default: current month). Opening is calculated before from-date. |
| Department | Optional — limit to employees in one department. |

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

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

| **Column** | **API field** | **Description** |
|------------|---------------|-----------------|
| Code | employeeCode | Employee code. |
| Name | name | Employee name. Click to open Employee Statement. |
| Department | department.name | Employee department. |
| Opening | opening | Balance before the period: prior pay-run earnings − other deductions − pay-run payments − cash advances + receipts on advances − deductions on expense + expense claims. |
| Earnings(+) | payRunEarnings | Sum of pay-run payment totals (process date in period). |
| Other Deductions(-) | payRunOtherDeductions | Pay-run deductions with category ID ≥ 3 (e.g. LOP). |
| Payrun Payments (-) | paymentsOnPayRuns | Payment vouchers linked to employee pay runs in the period. |
| Cash Advance(-) | cashAdvances | Cash advance vouchers issued in the period. |
| Cash Advance Receipts(+) | receiptsOnCashAdvances | Receipt vouchers against employee cash advances in the period. |
| Deductions on expense(-) | deductionOnExpenses | <a href="#/payroll/deduction-on-expense">Deduction on Expense</a> vouchers in the period. |
| Expense claims(+) | expenseClaims | Expense claim amounts in the period. |
| Closing | closing | Opening + earnings − other deductions − payrun payments − cash advances + cash advance receipts − deductions on expense + expense claims. |

<p>A <b>Total</b> row sums all amount columns.</p>

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

<h2 id="closing-formula">Closing Balance</h2>

```
Closing = Opening
        + PayRunEarnings
        − OtherDeductions
        − PaymentsOnPayRuns
        − CashAdvances
        + ReceiptsOnAdvances
        − DeductionOnExpenses
        + ExpenseClaims
```

<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>Why is Opening different from Employee Statement opening?</b><br>Both use the same components; Employee Statement shows line-by-line detail while this report aggregates into column buckets.</p>

<p><b>What counts as Other Deductions?</b><br>Pay-run deduction lines with deduction category ID ≥ 3 (Loss of Pay and custom categories above it).</p>

<p><b>Are expense claims only cleared ones?</b><br>All approved and closed expense claims dated in the period are summed, regardless of whether they have been through a pay run yet.</p>

<p><b>What is included in Gross Earnings?</b><br>Sum of pay-run payment lines plus additional payments and expense reimbursements in the period per report column definitions.</p>

<p><b>Why doesn't my employee appear?</b><br>User employee filters for payroll may restrict visible staff — select an employee you have access to or check with administrator.</p>

<p><b>Can I compare two months?</b><br>Run the report twice with different date ranges or export to Excel for side-by-side analysis — no built-in comparison mode.</p>

<p><b>How do cash advances affect the report?</b><br>Advances and recoveries appear in dedicated columns — net effect reduces take-home when vouchers are recovered on pay run.</p>

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