Manpower Planning Specialist
Sr. Hr Executive
Ms Office, Pagemaker, Banglaword, Autocad,
It was nice to open the file but plz tell us the password for the total no of days and holidays so that we can access and try for the solution.
Plz forward us the password of this and password of the attendance and salary slip also
Thanks in advance,
7th November 2009 From India, Hyderabad
I believe you are online now. On this Discussion board you have uploaded two files. One of them is "Employee attendance inside view.xls". I could download the file, but could not use it as the file is protected with PASSWORD. On Saturday 7th I requested for that password. Would you please provide the password to unprotect the file and make useful.
9th November 2009 From India, Calcutta
Thanks for post of Attendance Register in very easy way.
I need some explanation on loss of pay calculation. How you have calculated this loss of pay. on the office timings or wht..... please do reply. As our office timings are 10.00 a.m to 6.00p.m. Concession time 2 hrs in the morning or in the everning one of the either can use. and weekly offs on all sundays. So please do reply .....
9th November 2009 From India, Mumbai
You have mentioned you have already provided password and all in caps.. but I did not find the password on any message posted by you for this topic " Advance Systematic Attendance Register + Salary Calculation + Payslip Without Protect" and for file "Employee attendance inside view.xls". If you have the password please mention that here.
13th November 2009 From India, Calcutta
Totally Usefriendly program.
You can enter your Company name,Address,Department,Designations
You can set Categoeries of Fixed earning-Other Earning-Fixed deduction-Other deduction in Salary Slip.
You can set limit of ESI,P.F,Income Tax Slab for Man and Woman,Surchage setting,Professional Tax.
Program is Designed on Two mode
(1) In Auto mode salary slip will be generated as per Your predefined data given in "Company Detail Sheet"
(2) In Manual mode Salary Slip will be generated as per Manual detail given by You.It will not concern with the data given by you in "Company detail sheet"
Ex: We need to generate salary for Regular Employee as per company Policy for that You may put this employees on Auto mode and it will generate Salary slip as per your predefined data (If Basic is 25% of Gross than auto calculate it)But Some Employees are Temperaroy or We don't Follow Rules as per Regular employee so that This Type of Employee Put on Manual mode and enter your Data manually(here You have manually enter Basic and other details).
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 deop Thanks...
6th March 2010 From India, New Delhi
· Provides a menu driven user interface.
· High accuracy in payroll management.
· Employees and managers can easily access this application via Internet or mobile devices.
· No start-up cost is required.
· Nightly backups of all data.
· Helps to ensure compliance with federal wage and hour laws.
· Advanced reporting module.
· Integrated billing and invoicing module.
· Data can be exported to Excel spreadsheets for further processing.
· Integration with payroll programs like ADP, Quick Books, Peach tree and others available
<link outdated-removed> ( Search On Cite | Search On Google )
21st April 2010 From India, Delhi
Its useful for all, keep posting.
We have job openings in our company. For that i have to get permission in a college to conduct campus recruitment in their college. Could u please give me a Letter format for inviting?
21st April 2010 From India, Madras
I have few doubts in your Salary Structure Calculator. Assume we have 200 employees in our company as january opening balance, 10 employees resigned or absconded in the same month. So,in total 190 as closing balance. In your method, the salary for february,march..will be calculated for 200 employees instead of 190. The name of resigned employees will also come all months. Because the employees name and other related details for salary and attendance have given formula from the sheet "DATA". Pls try to solve it.
23rd April 2010 From India, Madras
Each & Evey time we are asking you for password, because without that this attendance register is useless for us. So please provide Password of this, so that we can appreciate your creativity.
So Please provide password of it with this thread. & If its copyrighted form somewhere then let us know that your are not being able to provide that password.
26th April 2010 From India
Many of u are asking password to unprotect the workbook. Actually, we can use this without password. Am using this without password. Just follow the instructions given in the workbook. Really it is useful n helpful.
27th April 2010 From India, Madras
7th June 2010 From India, New Delhi
Thank you a lot for providing us with ur WOWWWW payroll and other excel sheets.I have seen everything but didnt go anyfurther cos of the PASSWORD.u gave us three passwords and all three didnt work but for some ppl it worked.dunno why.anyways...one kinda advice..doing something for urself is cool..but the same thing doing unto others to the full most will make u a more hearted person.so keep pulling in good slides and playing with ur password tricks and ppl there who are not like JOSHUA or spacejoshua or ottfee or...giveus UNPROTECTED VERSIONS..so we can able to shar ething sin FUTURE... wish JOSHUA a good future.BYE BYE BYE TO UR WOWWWWWWWWWWWW post.
4th December 2010 From India, Madras
But let me make one thing clear. Making colourful, attractive excel files which are only for viewing and cannot be used will only make you unpopular. All members are working professionals and we certainly can't waste our time trying out the passwords which you keep changing.
One of the Cite HR member, Roulette, used to post many useful HR policies and formats which I found useful in my career. He never protected his files nor indulged in attention grabbing tactics like you. If you want others to benefit from your work, learn to be selfless like Roulette.
I request the Admin team to close the thread of Mr. Joshua and not allow him to upload anymore files unless he gives the correct password for each file.
11th September 2012 From India, Mumbai