Salary Register - Monthly
Salary Register – Monthly Report
The Salary Register – Monthly Report provides a comprehensive record of salary disbursements for all employees within a selected month. It serves as the official payroll ledger, capturing both earnings and deductions, and acts as a reference for salary processing, audits, and statutory compliance.
This report gives management, HR, and accounts teams a complete overview of payroll activity for the month and ensures transparency in salary payments.
Key Features
-
Displays employee-wise detailed salary information for a selected month.
-
Captures earnings, deductions, and net payable salary in a structured format.
-
Supports filters by department, branch, designation, or employee type.
-
Provides consolidated monthly totals for overall payroll expenses.
-
Can be exported in Excel/PDF for submission to auditors, management, or statutory authorities.
Report Fields
-
Employee ID – Unique employee identification number.
-
Employee Name – Full name of the employee.
-
Department / Project – Assigned department, cost center, or project.
-
Designation – Employee’s role/title.
-
Basic Salary (₹) – Fixed salary component.
-
Allowances (₹) – Additional allowances like HRA, transport, overtime, etc.
-
Gross Earnings (₹) – Total salary before deductions.
-
Deductions (₹) – PF, ESI, professional tax, TDS, loan/advance recovery, etc.
-
Employer Contributions (₹) – Employer’s share towards statutory benefits (PF, ESI, etc.).
-
Net Payable Salary (₹) – Final salary to be paid after deductions.
-
Payment Date – Date of salary disbursement.
-
Payment Mode – Bank transfer, cheque, or cash.
Sample Data
| Employee ID | Employee Name | Department | Designation | Basic Salary (₹) | Allowances (₹) | Gross Earnings (₹) | Deductions (₹) | Net Salary (₹) | Payment Date | Payment Mode |
|---|---|---|---|---|---|---|---|---|---|---|
| EMP001 | Anil Sharma | Accounts | Sr. Accountant | 25,000 | 5,000 | 30,000 | 2,500 | 27,500 | 31-07-2025 | Bank Transfer |
| EMP002 | Priya Mehta | HR | HR Manager | 28,000 | 6,500 | 34,500 | 3,200 | 31,300 | 31-07-2025 | Bank Transfer |
| EMP003 | Ravi Kumar | Operations | Supervisor | 20,000 | 3,000 | 23,000 | 1,800 | 21,200 | 31-07-2025 | Cash |
Benefits
-
Acts as the official salary ledger for monthly payroll.
-
Ensures accuracy in salary calculation and payment tracking.
-
Provides evidence for audits and compliance reporting.
-
Helps management analyze monthly payroll expenses by department or project.
-
Supports easy reconciliation with bank statements.
✅ This report is often used alongside
-
Payroll Summary Report (for consolidated payroll totals).
-
Payroll Tax Report (for statutory filing).
-
Employee Payslip (individual employee-level details).