Regina HR
Manpower Planning Specialist
Sr. Hr Executive
Hr Executive
Ms Office, Pagemaker, Banglaword, Autocad,
+9 Others

Thread Started by #Joshuaalvina

Dear My Fans / Admin / Moderators
I would like to post Advance Systematic Attendance Register + Salary Calculation + Payslip Without Protection..........based on your replies and i request admin / moderators do not close my thread.
This is totally designed in excel format.....and also advice how to reduce file size its comming around 3.16MB many of my fans are asking this file format i cant able to give cause our admin adviced me to reduce file size.......
This is for your kind information & Thanks in advance.
6th November 2009 From India, Madras

Attached Images
Membership is required for download. Create An Account First
File Type: jpg Payroll.JPG (182.8 KB, 3440 views)
Attached Files
Membership is required for download. Create An Account First
File Type: xls Employee attendance inside view.xls (293.5 KB, 7594 views)
File Type: xls Systematic Attendance Register.xls (233.5 KB, 6720 views)

My Dear,
can't you provide password of Attendance Register Cum Payslip.xls (2.12 MB, 624 views) of this file please provide it and it would be better if you provide all password in the same place.
I'll thankful to you.
6th November 2009 From India, New Delhi
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
Hi Joshua,
Will you please provide the PASSWORD for Employee attendance inside view.xls file to make that file useful. I really thank you for providing such useful file. However, it will not be in use unless I know the password.
Thanks again.
7th November 2009 From India, Calcutta
Hello, Its very nice but it will be great and will be more popular your talent if you provide the password keeping the copyright with you of this creation Thanks Sunil
7th November 2009 From India, Pune
Dear, can’t you provide password of Attendance Register Cum Payslip.xls (2.12 MB, 624 views) of this file please provide it and it would be better if you provide all password in the same place.
9th November 2009 From India, Jaipur
Hi Joshua,
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
Dear Sir,
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
Hi Joshu,
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
Dear Joshua,
Your creations are very useful and pls keep on updating. Can u send me the password for both the files and it will be more useful to me and can implement. Send password to ""
14th November 2009 From Oman, Muscat
It’s useless without password. It’s better to keep it in your record instead of posting here.
18th November 2009 From India, New Delhi
Dear Joshu Madam, i am lakshmanan, your Employee attendance inside view - this file is very useful but protected by password can u send the password to my id: Thanks for your response by lakshmanan
21st November 2009 From Malaysia, Penang
Please find new version of Salary Master with new Feactures..

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

Software Contains:

1-Attendance Register.
2-Payroll Register.
3-Generate Salary Slip.
4-Track Employees' Leave history.
5-Track Income Tax of All Employee.
6-Print out Leave History of Employee.
7-Overtime Monitor.
8-Master Data sheet of All Employees.
9-Leave Calculation sheet.
10-ESI Calculation(Set Your Requirements)
11-P.F Calculation
(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)
13-TDS Calculation
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
The Swifttime is an electronic web based application making it easy for employees and managers to improve work efficiency. Best suited for firms with remote employees and companies with hourly employees where proper documentation of working hours are required. This application can be accessed from any web based device like mobile devices(Blackberry or iphone). It has following advantages:

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
Hi Joshua,
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
Dear josh, The sheet is quite impressive, and it actually proved to be fruitful. This can be of great help for HR. Kindly provide the password to unlock the sheet. Thanks & Regards, Danish Shaikh
22nd April 2010 From India, Mumbai
Dear Jiguparmar,
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.
Thanking you,
26th April 2010 From India
Hi Everybody,
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
It,s Very nice and useful .But u can't you provide password of Attendance Register Cum Payslip.xls (2.12 MB, 624 views) of this file please provide it and it would be better if you provide all password in the same place.
6th June 2010 From India, Kalamboli
There is no need any password to use the program.Have you read instruction "May I help You" in the program? If you have not study or use the program than don't jump to any conclusion. First of all read the instruction carefully and use the program according the instruction.Read page of 6,7 of the same thread .After that If you find any difficulty please let me know.
7th June 2010 From India, New Delhi
Dear Joshuaalvina,
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 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 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 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
Dear Mr. Joshua, inspite of so many members asking you for the passwords you give passwords which don't work. Even if we try in caps or normal, we can't unprotect the sheets. This clearly shows that you have no intention of helping the members and keep positing protected files for your personal glory. This is just your way of grabbing attention.

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
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2017 Cite.Co