Dear Sir/Madam,

I am Ruban, pursuing M.S.W (H.R) at Mar Gregorios College. I have prepared a payroll process based on my knowledge. I am seeking your suggestions and corrections so that I can improve myself. I am eagerly awaiting your valuable comments.

Thank you.

From India, Madras
Attached Files (Download Requires Membership)
File Type: xls payroll.xls (25.5 KB, 2418 views)

Acknowledge(0)
Amend(0)


From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls salary format 2011 for CL.xls (29.5 KB, 1834 views)

Acknowledge(0)
Amend(0)

Hi There is no universal format for salary structure. However, earnings should be in LHS & deductions in RHS.
From India, Pune
Acknowledge(0)
Amend(0)

Dear ruban, Seen your salary sheet and comments given by sharma is appreciated. Also would like to add EPs8.33% MAX up to Rs.541/- only rest of amount goes to PF which pls update. Regards, ASK
From India, Madras
Acknowledge(0)
Amend(0)

Dear Sarma, wat about ESI & EPF cieling??? EPF it is fine if ur org allows contribution more than 6500 but in ur pay sheet, there is no cieling for ESI. pl check
From India, Hyderabad
Acknowledge(0)
Amend(0)

Hi Ruban, Attached is a Payroll format for your understanding...... please review and if you need anything to insert further, please revert. Thanks Taru
From India, New Delhi
Attached Files (Download Requires Membership)
File Type: xls Payroll Annexure-2 (2).xls (20.5 KB, 2310 views)

Acknowledge(0)
Amend(0)

boss2966
1189

Dear Friend,

Please change the PF card No. into PF Account No. Calculations and other details are okay. Please start with Basic Pay. HRA can be a lump sum or up to 40 to 50% of basic. Not everyone will be on traveling, so travel allowance is not required. Instead, you can make it as Conveyance Allowance.

In totality, it seems to be okay. All the best, dear.

From India, Kumbakonam
Acknowledge(0)
Amend(0)

Dear Mr.Ruban I have gone thru the xls file and I suggest HRA can be worked out at 50% of basic instead of 25% so as to avoid taxation on HRA.
From India, Madras
Acknowledge(0)
Amend(0)

Hello seniors,

As I am studying, I prepared it. But I don't know the split-ups. Can anyone help me out with the split-up? I am not familiar with taxes. Could you teach me so that it will be helpful for me? Another question I have is about attendance. How should we take it, as 30, 31, or else 30.5? These are the doubts I have. Could you please clear them for me? Thank you very much for your suggestions and corrections, seniors.

Thanks and regards,
Ruban

From India, Madras
Acknowledge(0)
Amend(0)

hello seniors : Can any one help me out in salary split ups, tax and attendance ......... Seniors help me out
From India, Madras
Acknowledge(0)
Amend(0)


From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls salary format 2011 for CL.xls (28.0 KB, 202 views)

Acknowledge(0)
Amend(0)

Hi Ruban,

Attendance is counted as the number of worked days + leave with pay (SL/CL/PL/ML/Special Leave) - Leave without pay. Income Tax deductions are normally handled by tax professionals. Every company has separate employees who are engaged and belong to the Chart of Accounts, Finance, or the senior-most HR person in the Compensation & Benefits division. It's a wide subject. If you want, please search on the Cite HR pages.

After becoming well-versed in the CTC format and salary statement preparation, only then can you understand the income tax deductions part.

Regards,
Sarmakpk1981@gmail.com
9160019220

From India, Hyderabad
Acknowledge(0)
Amend(0)

Hi RSDG Pls check with ealiear posting of reply mail for Ruba Pls go through it and ur saying is wrong. pls check and revert. regards Sarmakpk
From India, Hyderabad
Acknowledge(0)
Amend(0)

Welcome and if any clarification regarding payroll attendance compensatory & benifits stautory provision pls share with me. i will give you upto my knowledge REgads/Sarma
From India, Hyderabad
Acknowledge(0)
Amend(0)

Join 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.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.