Salary Sheet, Payslip, Bank List, Master Data - XLS Download

Dear Sandeep Jee,
Excellent ............... It is really so good helpful for every one . Please provide us the same idea
in Accounts (trading, PL a/c, Balance Sheet, TDS, TCS, PF , ESI etc)
With regards
Rajan Mishra

yes exellent work....
i want to use it....but problem is ... am not so good with excel sheet ...n dont know how make formulas....
any one suggest me how to learn excel sheet ... any book or sumthing

Sandeep
The sheet is fabulous. I am actually a starter in General HR and hope it will support me a lot. I believe it is one among the best structures.
Regards
Soujanya Hegde

Dear Sandeep
this post is really helpful to people like me who are freshers
regards
rajani

Hi Sandeep,
i really appreciate your work. i am also using it and prepared my sheet first time for company employees keeping ur base.
can u explain me the rules for HRA and LTC. Actually employees are demanding to include those heads which are exempted in incometax so that they can have benefit of investing less and pay less tax.
I have already taken meal vouchers upto 15000p.a,medical reimbursement-15000 p.a, 9600 conveyance and 2400 chidren allowance.
can u pls help me to provide hra and LTC....

hi!!
Really Sandeep you have done a very good job. It is really very easy for freshers to understand. But it will be more good if you update the same as almost all the provisions are changed...

Dear Sandeep
The information u have posted is really important but u have given password to excel sheet. Plz post it again without password.
regards
Asmita

Hi Pratima,
following is the information regarding HRA and LTA
HRA exemption = minimum of (40% (50% for metros) of Basic+DA or HRA or rent paid - 10% of Basic+DA)
LTA is exempt to the tune of ecomony class airfare for the family to any destination in India, by the shortest route.
LTA can be claimed twice in a block of 4 calendar years. The current block is from Jan 2010 to Dec 2013
Regards,

Dear all,
Herewith i am attaching the copy of Gujarat professional tax form 5 which we have to submit with professional tax challan.
I have made this form with a lot of searching and hard work.
I think it will be useful not only for gujarati HR professionals but also it will guide to all other state professionals to make such descriptive and ready to use for freshers' form.

[QUOTE=Bulla Kranthi Kumar;868331]Dear Sandeep
Its a great job it will be helpful for everyone who are new to this payroll process and im a MBA(fresher) and i started my HR career in the hotel industry it will surely helpful to continue my HR career in the payroll process and i have no words to express my views....may god bless u....
Regards,
jagadeesh.v