# Department Wise Salary Report

Pay-run totals aggregated by department for a date range. Shows opening balance, period payments, deductions, expenses, net payable, amount paid, outstanding balance, and closing balance per department.

On this page

Overview Use Cases Filters Columns Actions FAQ

Overview

Go to Payroll → Payroll Reports → Department Wise Salary.

What it shows. One row per active department with pay-run activity summarized for the selected process-date range, plus a totals row.

When to use it. Department budget tracking, management reporting on payroll cost by department, and drilling down to employee-level detail. The Net by department title on the Pay Run Dashboard opens this report for the same dates.

Department Wise Salary Report

Use Cases

Department head — What is our department's total salary cost and unpaid balance this month?
Finance — Compare opening vs closing payable by department across a quarter.
HR — Click a department name to open Employee Wise Salary Report filtered to that department.

Filters

| **Filter** | **Description** | |------------|-----------------| | Date range | Pay runs with process date in this range (default: current month). |

Columns

| **Column** | **Description** | |------------|-----------------| | Department | Department name. Click to open Employee Wise Salary for this department. | | Opening | Sum of pay-run balances before the period (by employee department). | | Payments | Sum of payment totals on pay runs in the period. | | Deductions | Sum of deduction totals on pay runs in the period. | | Expenses | Sum of expense reimbursement totals on pay runs in the period. | | Net Payable | Total payable (payments + expenses − deductions) in the period. | | Paid | Amount already paid: Net Payable − Balance. | | Balance | Outstanding pay-run balance in the period. | | Closing | Opening + Balance. |

A Total row sums all columns.

Actions

Generate — run the report
Export — export to Excel
Print — print the report

FAQ

Which department is used?
The employee's current department on their profile at report time.

What pay-run statuses are included?
Approved and Closed pay runs only.

How is Paid calculated?
Net Payable minus remaining Balance for pay runs processed in the period.

Can I drill down to employee pay runs?
Click department subtotals then open Employee Wise Payrun Report filtered by department employees.

Are bonus pay runs included?
Yes when status is Approved or Closed and process date falls in the selected period — both Regular and Bonus types.

Why is an employee in the wrong department?
Report uses current department on the employee profile, not historical department at pay-run date.

Does the report show gross or net?
Columns reflect pay-run payable and paid amounts after deductions — see column definitions on the report form.