can anyone explain in detail how the payroll processing is done in a company having 50+ employees.
From India, Madras
Acknowledge(0)
Amend(0)
2From India, Madras
Acknowledge(0)Amend(0)
Hi, Prema Latha,
The Payroll Processing will be easy if you maintain a complete EMPLOYEE DATABASE working in your organization.
Employee Codes help you in sorting the problems.
For 50+ employees, Payroll Processing can be done on an Excel sheet.
The sheet should contain the basic information of the employees like Employee code, Employee Name, Designation, Department/Section, Date of Joining, Date of Birth, PF No, ESI No, Father Name.
Total days for the month, Days to pay DTP (worked days for the month including leaves & W/O):
[DTP = (Physical Working Days + Paid Leaves (CL, SL, EL) + Paid Holidays + W/O + Compensatory Offs) - (Loss of Pay + Unauthorised Absence)]
Salary Details: Gross Salary, Basic, HRA, Conveyance, DA, FDA, VDA, Total Salary, Basic earned, HRA earned, Conveyance earned, DA earned, FDA earned, VDA earned, total salary earned.
Other Pays: Overtime pay, incentive pay, etc.
Supplementary pay, arrear pay.
Deductions: PF ded, ESI ded, deductions for late comings / early goings, etc.
The Gross salary earned for the month + other pays = Total earnings of the employee.
The total earnings of the employee - Total deductions = NET SALARY OF THE EMPLOYEE FOR THE MONTH
I hope I haven't missed anything.
If I have missed anything, please let me know.
Bye...
Sindhu
From India, Hyderabad
Acknowledge(0)Amend(0)
The Payroll Processing will be easy if you maintain a complete EMPLOYEE DATABASE working in your organization.
Employee Codes help you in sorting the problems.
For 50+ employees, Payroll Processing can be done on an Excel sheet.
The sheet should contain the basic information of the employees like Employee code, Employee Name, Designation, Department/Section, Date of Joining, Date of Birth, PF No, ESI No, Father Name.
Total days for the month, Days to pay DTP (worked days for the month including leaves & W/O):
[DTP = (Physical Working Days + Paid Leaves (CL, SL, EL) + Paid Holidays + W/O + Compensatory Offs) - (Loss of Pay + Unauthorised Absence)]
Salary Details: Gross Salary, Basic, HRA, Conveyance, DA, FDA, VDA, Total Salary, Basic earned, HRA earned, Conveyance earned, DA earned, FDA earned, VDA earned, total salary earned.
Other Pays: Overtime pay, incentive pay, etc.
Supplementary pay, arrear pay.
Deductions: PF ded, ESI ded, deductions for late comings / early goings, etc.
The Gross salary earned for the month + other pays = Total earnings of the employee.
The total earnings of the employee - Total deductions = NET SALARY OF THE EMPLOYEE FOR THE MONTH
I hope I haven't missed anything.
If I have missed anything, please let me know.
Bye...
Sindhu
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi,
You all are almost right, except for income tax calculation and working. You have to work with whose gross salary is above 12500 (PM) or 150000/- PA. Then you have to start thinking about income tax calculation, either on a monthly basis or from January, February, March alone.
You have to start calculating the taxable income of the employee/staff and deduct the amount as per your calculation. If you do not deduct the income tax (TDS) on your staff/employee, that expense (salary) cannot be claimed under the P&L account for that year.
Regards,
Kugan Paramasivam.
From India
Acknowledge(0)Amend(0)
You all are almost right, except for income tax calculation and working. You have to work with whose gross salary is above 12500 (PM) or 150000/- PA. Then you have to start thinking about income tax calculation, either on a monthly basis or from January, February, March alone.
You have to start calculating the taxable income of the employee/staff and deduct the amount as per your calculation. If you do not deduct the income tax (TDS) on your staff/employee, that expense (salary) cannot be claimed under the P&L account for that year.
Regards,
Kugan Paramasivam.
From India
Acknowledge(0)Amend(0)
Hi Prema,
This is Mamatha from Bangalore. I have one format, but you still need to work on that format as you have to update it with income tax details. Just check the attached document. I hope it might give you an idea.
Regards,
Mamatha
Acknowledge(0)Amend(0)
This is Mamatha from Bangalore. I have one format, but you still need to work on that format as you have to update it with income tax details. Just check the attached document. I hope it might give you an idea.
Regards,
Mamatha
Acknowledge(0)Amend(0)
Hi Premalatha,
Sindhu has covered most of the components required for processing payroll, but every December a "Labour Welfare Fund" needs to be deducted from the employees eligible for it. Most of us ignore this as we would have configured this in the payroll software which automatically takes care of this deduction. The payroll software will help us in verifying the payroll process done is correct by generating the Delta Report. Most of the Statutory reports of PF, ESI, PT, and IT will also be covered. This helps us to reduce our time spent on salary process work.
Thanks,
Srinivas
Acknowledge(0)Amend(0)
Sindhu has covered most of the components required for processing payroll, but every December a "Labour Welfare Fund" needs to be deducted from the employees eligible for it. Most of us ignore this as we would have configured this in the payroll software which automatically takes care of this deduction. The payroll software will help us in verifying the payroll process done is correct by generating the Delta Report. Most of the Statutory reports of PF, ESI, PT, and IT will also be covered. This helps us to reduce our time spent on salary process work.
Thanks,
Srinivas
Acknowledge(0)Amend(0)
Hi HR professionals,
If you are computer savvy and smart enough, have patience, and are willing to learn, you can work in MS Access and export data to Excel. Has anyone tried it? If not, you should give it a try and seize the opportunity to learn MS Access.
From India, Madras
Acknowledge(0)Amend(0)
If you are computer savvy and smart enough, have patience, and are willing to learn, you can work in MS Access and export data to Excel. Has anyone tried it? If not, you should give it a try and seize the opportunity to learn MS Access.
From India, Madras
Acknowledge(0)Amend(0)
Hi Everybody,
Please guide me, is there any hard and fast rule in any law regarding the heads in the salary, i.e. salary breakup should be in a certain percentage in each head, or can we distribute the gross salary under various heads as per our convenience? Because presently, we are distributing the salary in the following way:
Basic: 70%
HRA: 12%
CCA: 15%
Spl. Allowance: 3%
----------------------
Total (Gross): 100%
Less: PF (12% of Basic)
Less: ESI (1.75% of Total Gross)
Less: TDS wherever applicable
Is this format fine? Or is there any legal/approved format for salary distribution?
Regards,
Kapil
From India, Delhi
Acknowledge(0)Amend(0)
Please guide me, is there any hard and fast rule in any law regarding the heads in the salary, i.e. salary breakup should be in a certain percentage in each head, or can we distribute the gross salary under various heads as per our convenience? Because presently, we are distributing the salary in the following way:
Basic: 70%
HRA: 12%
CCA: 15%
Spl. Allowance: 3%
----------------------
Total (Gross): 100%
Less: PF (12% of Basic)
Less: ESI (1.75% of Total Gross)
Less: TDS wherever applicable
Is this format fine? Or is there any legal/approved format for salary distribution?
Regards,
Kapil
From India, Delhi
Acknowledge(0)Amend(0)
Payroll processing is normally a technical job requiring knowledge of various laws related to PF, ESIC, IT, Bonus, etc. However, it is simple to understand and then practice. Please consult with any professional agency that deals with payroll processing.
Regards,
Rajpal
From India, Mumbai
Acknowledge(0)Amend(0)
Regards,
Rajpal
From India, Mumbai
Acknowledge(0)Amend(0)
Bifurcation of CTC is dependent on the company's policy, which may differ from company to company, whereas PF, ESIC, etc., are statutory deductions and are standard for each company.
Hope this information gives you some insight.
Regards,
Rajpal
From India, Mumbai
Acknowledge(0)Amend(0)
Hope this information gives you some insight.
Regards,
Rajpal
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Premalatha,
Processing salary on Excel is okay as it gives immediate results, but I recommend working with professional software. Software stores data, and the data can be queried to generate MIS reports apart from statutory reports. The payslip can be automatically converted into PDF format and emailed to respective employees, and so on.
I use Ziacpay, developed by Ziac Software Private Limited, a Bangalore-based company.
Thanks,
Srinivas
Acknowledge(0)Amend(0)
Processing salary on Excel is okay as it gives immediate results, but I recommend working with professional software. Software stores data, and the data can be queried to generate MIS reports apart from statutory reports. The payslip can be automatically converted into PDF format and emailed to respective employees, and so on.
I use Ziacpay, developed by Ziac Software Private Limited, a Bangalore-based company.
Thanks,
Srinivas
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Statutory Compliance of a Industrial or Commercial Unit.xls
Statutory-compl iance.pdf
Statutory Compliance.zip