Payroll Processing Xls Download

Dear All,
I need to understand who is resposponsible for Payroll processing Accounts or HR. What part is handled by Accounts and HR.
Attaching herewith the format where I would request to provide with the information.
Thanks
Sarika

Mamtha,
Very good format.
-------------------------------------------------------------
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[/quote]

hi mamatha dis is ankitha
culd u pls tell me wt r the duties, responsibility for the admin departments. as a admin wt r the works, duties they hv to do & maintain . my id is
[Login to view]
waitnig for replay
thank u

hi friends..
I am a new member to this site. I find it very informative.Hats off to the creaters of this idea.
can anyone tell me if there is any change in the sealing of salary in respect to the contribution towards pf and esi from both employee and employer.
thanks
suresh

Mamtha u r right but u do one thing add some other component
I.e component Like :
Basic = 50% or 40 % of gross
HRA = 40% or 50% of basic (Depending on Metro & non-metro)
CCA = 20% of Basic
Medical = Rs 1250/- pm
Children Education = 100/- pm (1200/- PA)
Bonu = 8.33% of basic normally (Rest depends on company)
PF = 12% of basic
ESI = depending on gross (if applicable)
Telephone expenses = Rs 750/- pm.
And the remaining like Traveling Allowances, Food Allowance, Petrol Allowances etc completely depends on the company.

Then u may design as above for knowledge

manoranjan

Sindhhu

u shared a food info. but some of the companies are deducting Mediclaim fronm salary every month .

vijay

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[/quote]

what u mean by FDA, VDA, Basic earned, HRA earned, Conveyance earned, DA earned, FDA earned, VDA earned, total salary earned.For example can u tell the difference between FDA and FDA earned
Suresh M.G

Hi Premlatha
We have head office in chennai . We do payroll outsourcing and temp staffing. Please give me your email id or Contact number for further details.
Archana

GKM offers payroll processing services to various companies ranging from small to Fortune 500 companies. We customize our software to suit the requirements of the corporate and use the same for complete payroll processing.This is the traditional Payroll Outsourcing model where we collect inputs from the corporate, process the payroll at our end and submit the statutory & non-statutory reports to the corporate on pre-decided dates.This will help you undrstanding of payroll processing..

Hi All,
Thank you everyone! This information is very useful for me to understand what is payroll processing. Please let me know the forms need to be maintained for employees related to statutory compliance ?
Malathi