premlatha
2

can anyone explain in detail how the payroll processing is done in a company having 50+ employees.
From India, Madras
sindhuu
6

Hi.... Prema Latha

The Payroll Processing will be easy if you maitain complete EMPLOYEE DATABASE working in your organisation.

Employee Codes helps you in sorting the problems.

For 50+ employees, Payroll Procssing can be done on an excel sheet.

The sheet should contain the basic information of the employees like Employee code, Employee Name, Designation, Departtment/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 any thing

If I have missed any please let me know.

Bye...

Sindhu

From India, Hyderabad
kuganparamasivam
11

Hi,
Your all are almost Right, Exepect Income tax calculation and working.
Your have to work Whoes Gross Salary is Above 12500(PM) or
150000/- PA then you have start think about Income tax calculation either in the every month basis or from the Jan,feb, march alone.
you have to start calculating the Taxable income of the Employee/staff and deduct amount as per you calculation.
If you are not duduct the Income tax (TDS) on your Staff/employee that expenses(salary) you can't claim under the P&L Account for that year.
Regards
Kugan Paramasivam.

From India
gmamatha82
14

Hi Prema,
This is Mamatha from Bangalore. I have one Format. But you need to still work on that format as you need to update it with Income tax details. Just check the attached document. Hope it might get u an Idea.
Regards,
Mamatha

Attached Files (Download Requires Membership)
File Type: xls payroll_587.xls (17.5 KB, 11443 views)

srinivas_blore71
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


suryaa71
1

hi hr dudes,
if you all are computer savvy and very smart enough. If you have patience and willing to learn, you can do it in MS.Access and export it to excel.
Have any one try it. If not you people try it and also have a chance to learn MS.Acess.

From India, Madras
kap_il_007
11

Hi Everybody,
Please guide me, is there any hard and fast rule anywhere in any law, regarding the heads in the salary ie. 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
Rajpal
7

Payroll processing is normally a technical job requiring knowledge of various law related to PF , ESIC , IT , Bonus , IT etc. However , it is simple to understand and then practice. Please consult or any professional agency who deal with payroll processing.
Regards,
Rajpal

From India, Mumbai
Rajpal
7

Bifurcation of CTC is dependant on company's policy which may differ from company to company hwereas PF , ESIC etc are statutory deductions and are standard for each company.
Hope, this shall give you some idea.
Reagrds,
Rajpal

From India, Mumbai
srinivas_blore71
Hi Premalatha,
Processing Salary on excel is OK as it gives immediate result but I recommend working on professional software. Software store 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 Bangelooru based company.
Thanks,
Srinivas


Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.