Payroll Processing Xls Download - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.

Attached Files
Membership is required for download. Create An Account First
File Type: xls payroll_responsibility1_510.xls (19.5 KB, 1490 views)

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.

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

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.

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



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


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.


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 ?

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™