suriyaprakashs Started The Discussion:
Hi! Friends i am working in a Small Sized Enterprise, I am using Excel to do my Payroll proccess, I am interested to change the format, can you suggest me a new format please.
SURIYA :? :? :? :? :? :?
Please note that There is no need of any password to use this program.
Read instruction carefully provided with the program before entering you detail..
After reading the instruction if you find any difficulty for entering your data please let me know.
3-Generate Salary Slip.
4-Track Employees' Leave history.
5-Track Income Tax of All Employee.
6-Print out Leave History of Employee.
8-Master Data sheet of All Employees.
9-Leave Calculation sheet.
10-ESI Calculation(Set Your Requirements)
(Here there are Two Options one is if Basic<=6500 than Basic*12% otherwise 6500*12%
Second is 12% of Basic)
12-Pension Scheme (not more than 541 rs submission)
14-Annual Salary statement of Employee and Employer
15-Employer Monthly Salary statement
16-Income Tax Calculations
17-Generation of Form No-6 (For ESIC)
18-Generation of Form no-3A (PF)
19-Generation of Form no-6A(PF)
Limitation: You have monitor Leave of employee each month when It goes minius Red indication is glow on that cell so You have to Put it on LWP otherwise minus leave will effect on salary sllip generation.
Requied Attention: Please be vigilant about Auto and Manual mode and P.F Selection.
If You find this is useful for You than Don't miss to drop Thanks...
Download from : Excel Programs-Softwares-Books-Novels
Found This Useful? +Vote Up This Page Via Google.
Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas
Topic Categories >> annual salary statement attendance register income tax Location-India-Coimbatore pension scheme salary slip Complete List Of Categories
Interesting Relevant Discussions