Complete Indian Payroll Excel Workbook | Salary, PF, ESI & Payslip
Complete Indian Payroll Process Excel workbook with salary registers, salary calculation, bank payment list, PF ECR, ESI ECR, PT report and payslip format.
You save ₹500
🔒 Secure payment via Razorpay · Instant digital delivery
- 🔒 Secure Razorpay checkout
- ✅ Instant download after payment
- 📧 Download link also sent to email
- ⬇️ 72-hour · 3 downloads link validity
What's Inside
- Complete Monthly Payroll Workbook - Manage salary calculation, deductions, employer contributions, CTC and Net Pay in one structured Excel workbook.
- 2 Monthly Salary Registers- Maintain employee payroll data and calculate monthly salary using the two salary-register approaches provided in the workbook.
- Salary Breakup Calculator - Prepare salary structures with Basic + DA, HRA, Conveyance, Gross Pay, PF, ESI, Bonus, Gratuity, deductions and Net Pay.
- Old vs New Salary Comparison - Compare salary components under the Old and New calculation approaches and review the difference in salary, deductions and employer cost.
- Monthly Bank Salary Payment List - Prepare an employee-wise bank payment working list with Net Pay, bank account number, bank name, branch and IFSC.
- PF ECR Working Sheet - Use payroll-linked employee and wage information to prepare the PF ECR working data.
- ESI ECR Working Sheet - Prepare payroll-linked ESI information including IP details, paid days and monthly wages.
- Professional Tax Report - Summarise PT information by branch and applicable PT slab.
- Payslip Format - Prepare employee salary slips using the payroll information maintained in the workbook.
- Complete Salary-to-CTC Calculation - Calculate earnings, employee deductions, employer contributions, Net Pay, Monthly CTC and Annual CTC in the payroll register.
- Employee Payroll Master Data - Maintain key employee information including UAN, ESI details, PAN, Aadhaar and bank details along with joining and salary revision information.
About This Product
Complete Indian Payroll Excel Workbook
Payroll processing involves much more than calculating an employee's salary.
Every month, HR and payroll teams need to work with employee information, attendance and LOP, salary components, statutory deductions, employer contributions, Net Pay, CTC, bank payment data and payroll-related reports.
This Complete Indian Payroll Excel Workbook brings these major payroll working requirements together in one Excel file.
Instead of maintaining separate Excel files for salary calculation, salary breakup, bank payment, PF, ESI, Professional Tax and payslips, you can work with a structured workbook containing dedicated sheets for each activity.
What Is Included?
The workbook contains 10 dedicated worksheets:
- Important
- Old vs New Salary Comparison
- Salary Breakup Calculator
- Monthly Salary Register 1
- Monthly Salary Register 2
- Monthly Bank Payment List
- Monthly PF ECR
- Monthly ESI ECR
- Monthly PT Report
- Payslip Format
1. Monthly Salary Registers
The workbook provides two Monthly Salary Registers for payroll processing.
The registers include employee information such as:
- Employee Code
- Employee Name
- Date of Joining
- Gender
- Department
- Designation
- Branch
- State
- Minimum Wages
- Days
- Paid Days
- LOP
- Overtime Hours
- Fixed Monthly CTC / Total Remuneration
- UAN
- ESI Number
- PAN
- Aadhaar
- Bank Details
- Salary Revision Details
The salary registers then calculate the applicable earnings, deductions, employer contributions, Net Pay and CTC based on the workbook's formulas.
2. Salary Earnings & Gross Pay
The payroll calculation includes salary components such as:
- Basic + DA
- HRA
- Conveyance Allowance
- Medical Allowance
- Phone & Internet Allowance
- Washing Allowance
- Overtime
- Reimbursements
- Gross Pay
The workbook also provides inputs for in-kind components including:
- Meal Coupons
- Transport Facility
- Other Non-Cash Benefits
3. Employee Deductions
The payroll register includes employee-side deductions such as:
- Employee PF
- Employee ESI
- Professional Tax
- Employee LWF
- Other Deductions
- Total Deductions
The workbook then calculates the resulting Net Pay.
4. Employer Contributions
The employer-side payroll calculation includes:
- Employer PF
- Employer ESI
- Employer LWF
- Statutory Bonus
- Gratuity
- Insurance
- Total Employer Contributions
These components are incorporated into the CTC calculation.
5. CTC Calculation
The workbook provides calculations for:
- Monthly CTC
- Annual Statutory Bonus
- Gratuity
- Insurance
- Annual Variable Pay
- Annual CTC
This helps you review the overall employer cost of the salary structure.
6. Salary Breakup Calculator
The separate Salary Breakup Calculator can be used to prepare and review salary structures.
It covers:
- CTC
- Basic + DA
- HRA
- Conveyance
- Gross Salary
- In-Kind Remuneration
- Employer PF
- Employer ESI
- Statutory Bonus
- Gratuity
- Employee PF
- Employee ESI
- Professional Tax
- Total Deductions
- Net Pay
- Monthly CTC
- Annual CTC
- Variable Pay
It also provides PF Ceiling and No PF Ceiling options.
7. Old vs New Salary Comparison
The workbook includes a dedicated Old vs New Salary Comparison sheet.
It allows you to compare salary components and understand the difference between the two calculation approaches.
The comparison includes items such as:
- CTC
- Basic + DA
- HRA
- Conveyance
- Medical Allowance
- Gross Salary
- Employer Contributions
- Employee Deductions
- Net Pay
- Difference
This is particularly useful when reviewing the potential impact of salary restructuring.
8. Monthly Bank Salary Payment List
The workbook includes a dedicated Monthly Bank Payment List linked to the salary register.
It provides employee-wise information such as:
- Employee Code
- Employee Name
- Net Pay
- Bank Name
- Bank Account Number
- Branch
- IFSC Code
This can be used as a working format for preparing monthly salary payment data.
9. Monthly PF ECR
A separate Monthly PF ECR sheet is included with payroll-linked information such as:
- UAN
- Member Name
- Gross Wages
- EPF Wages
- EPS Wages
- NCP Days
- Date of Joining
- Gender
- Other employee-related PF fields
This provides a structured working sheet for PF-related payroll data.
10. Monthly ESI ECR
The workbook also includes a separate Monthly ESI ECR sheet containing fields such as:
- IP Number
- IP Name
- Number of Days for Which Wages Are Paid / Payable
- Total Monthly Wages
- Reason Code for Zero Working Days
- Last Working Day
The information is linked with the payroll register wherever applicable.
11. Monthly Professional Tax Report
A separate Monthly PT Report is included for summarising Professional Tax information.
The report includes:
- Branch
- PT Slab
- Number of Employees
- Total PT
This provides a convenient working format for reviewing PT deductions.
12. Payslip Format
The workbook includes a dedicated Payslip Format for preparing employee salary slips.
It can be used to present employee information, paid days, LOP, earnings and deductions in a structured salary slip format.
How the Workbook Fits Into the Payroll Process
The workbook brings together the major payroll working stages:
Employee Data → Salary Calculation → Employer Contributions → Employee Deductions → Net Pay → CTC → Bank Payment → PF / ESI Working Data → PT Report → Payslip
This makes it useful for HR and payroll professionals who manage payroll calculations and related working formats through Excel.
Who Is This Workbook For?
This workbook is suitable for:
- HR Professionals
- Payroll Professionals
- HR Executives
- Payroll Executives
- HR Managers
- Payroll Managers
- Compensation & Benefits Professionals
- HR Consultants
- Payroll Consultants
- HR Generalists
- Employers
- Business Owners
- Small and medium-sized organisations managing payroll in Excel
Important Before You Use This Workbook
The workbook contains sample employee and payroll data to demonstrate how the calculations and linked sheets work.
You should replace the sample information with your organisation's actual employee and payroll data before use.
This is an Excel-based payroll calculation and working workbook. It does not directly connect to EPFO, ESIC, banks, tax authorities or other government portals.
The PF ECR and ESI ECR sheets are provided as working formats. Verify the final data against the applicable portal requirements before making any statutory submission.
State-specific requirements, including Professional Tax, Labour Welfare Fund, minimum wages and other applicable provisions, should be independently verified before live payroll processing.