No Tags Found!


View Poll Results: Do You Like?
Yes 748 90.45%
No 82 9.92%
Multiple Choice Poll. Voters: 827. You may not vote on this poll

Attendance Register Cum Payroll Including All ESI PF Forms (By Joshua Alvina)

EDITED ON 28.01.2010 (and link file also given open the zip folder and copy the files and paste in ur add-in)

Regards, Joshua

How to Use: Step by Step

1. Open Workbook
2. Enable Macro
3. Enter Login Password: @joshua
4. Unhide All the Workbooks
5. Unprotect Worksheet Password: alvina
6. While Exit Lock all the workbook click on lock or Lock user Password: joshua@

You have to find all the there. Attendance register, Payroll calculation, Payslip, Advance Register, Consolidated Statement, Form 3A, Form 6A, Form 5, 7, ESI yearly Returns, Form 12A, etc.,

This will help you guys. 1st Sheet PASSWORD: Carrot All other sheet password: Alvina Login Password: @joshua Lock Password: joshua@

From India, Madras
Attached Files (Download Requires Membership)
File Type: jpg 1.JPG (182.4 KB, 2856 views)
File Type: jpg 2.JPG (176.2 KB, 1313 views)
Attached Files (Download Requires Membership)
File Type: xls Esi.xls (66.0 KB, 9600 views)
File Type: xls Systematic and Faster Attendance Register Fully Designed With Macro (EDITED).xls (807.0 KB, 10643 views)
File Type: zip New Compressed (zipped) Folder.zip (33.2 KB, 5873 views)

Acknowledge(5)
AA
DC
AN
Amend(0)

Hi Joshua,

I am Rajesh, a new member in this network. The attached sheets are very useful and I would like to know if I can use them. If yes, please provide me with the password and other details.

Regards,
M. Rajesh

From India, Visakhapatnam
Acknowledge(1)
SR
Amend(0)

Dear Joshua Files do not open as well the password supplied ( Carrot ) is also incorrect. Kindly upload working model please. Ravi Mishra
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Singh Raj,

I am sending the attendance format which I believe will be useful for you. This attendance format is typically followed by manufacturing companies.

The attachment files include:
1. Attendance format
2. Overtime format
3. Driver's and cleaners' salary attendance format.

Please find the attachments enclosed.

Thank you,
Amar
9603346857
9949455395

From India
Attached Files (Download Requires Membership)
File Type: xls NOVEMBER attedance 2003 format.xls (92.0 KB, 1093 views)

Acknowledge(0)
Amend(0)

Dear Joshua,

The password "Carrot" is not working. How do I unprotect it? What will be the password for this so I can utilize all of its features? Other passwords like "ottffsse," "joshua," or "SALSLVS" are also not working.

Thank you.

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

Dear Joshua It says incorrect password. Tried in different combination in upper case & lower case. Kindly send the correct password Thanks & Best Regards Ravi Mishra
From India, Mumbai
Acknowledge(2)
Amend(0)

Hi,

I have attached some files that will help you understand how to simplify the salary process. The documents include:

1) Attendance Sheet
2) Salary Calculator
3) Salary Bank Credit Statement (A-C No)
4) Salary Credit Report

Sudhir Singh Rawat
Mumbai, India
9821443636

Attached Files (Download Requires Membership)
File Type: xls Attandance master.xls (24.0 KB, 1528 views)
File Type: xls Attendance Sheet.xls (87.0 KB, 1003 views)
File Type: xls salary calculater.xls (31.0 KB, 1487 views)
File Type: pdf Salary -bank credit statement( A-C NO).pdf (13.3 KB, 867 views)
File Type: doc Salary Credit Report.doc (34.5 KB, 849 views)

Acknowledge(1)
Amend(0)

Hi,

Why don't you give us the password? The passwords: CARROT, JOSHUA, SALSLVS, ALVINA, and ottffsse don't work. Please don't create a mess if you don't want to give the password. Why did you post this file here when many, including me, requested the password but you didn't give it? What are you trying to show? Disgusting.

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

Dear Joshua, Pwds Alvina or Carrot is not working. Could you please send me the with unlocking one. Regards
From India, Ludhiana
Acknowledge(0)
Amend(0)

Wage sheet linked with ESI register, ESI challan, EPF register, and EPF challan attached without any passwords for the use of all CiteHR members.

Yours sincerely,

MAJ (RETD) D BHUSHAN RAO
SAIPAVAN SECURITY SERVICE
MOB 9848592330

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

Dear CiteHR members,

I have found that the members of this forum are well-behaved and cultured with respect to the norms of sharing and spreading knowledge to and around the world, at least. However, one of the members, Joshua, shared a password-protected Excel file named "Systematic and Faster Attendance Register Fully Designed With Macro" and also provided some incorrect passwords in this community. I wonder why this disturbed member posted this file in this elite forum. I myself was very disappointed when I tried to use it, and so was everybody else who downloaded it.

One of my genuine requests to all the members and especially the Moderator of this forum is to please BAN this member from this elite forum or ensure that he will post the correct passwords for the file. If this is not possible, please delete this post from this community.

Regards,


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

I have given the correct password, and many of my fans have given personal thanks in private messages. I don't know why this happened. However, I have created this program for CiteHR to use. I will go through this file again and repost it. Sorry for any inconvenience caused by me.

Regards,
JA

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

Dear CiteHR members,

I have found that the members of this forum are well-behaved and cultured with respect to the norms of sharing and spreading knowledge to and around the world, at least. However, one of its members, Joshua, shared a password-protected Excel file named "Systematic and Faster Attendance Register Fully Designed With Macro" and also provided some incorrect passwords in this community. I wonder why this disturbed member posted this file in this elite forum. I myself was very disappointed when I tried to use it, as was everyone else who downloaded it.

One of my genuine requests to all the members, and especially the Moderator of this forum, is to please BAN this member from this elite forum or ensure that he will post the correct passwords for the file. If these actions are not possible, please delete this post from this community.

Regards,

Proof of record

Password for Lock:

Dim mypassword

tryagain:

mypassword = InputBox("Are You Sure?", "Password")

If mypassword = "joshua@" Then

ActiveWindow.DisplayWorkbookTabs = Not (ActiveWindow.DisplayWorkbookTabs)

'your code here

MsgBox ("Successfully Locked")

Else

If MsgBox("Password incorrect, try again?", vbYesNo, "Wrong password") = vbYes Then GoTo tryagain

End If

ActiveSheet.Next.Activate

ActiveWorkbook.Sheets(1).Activate

Password to open

Dim mypassword

tryagain:

mypassword = InputBox("Enter Login Password", "Password")

If mypassword = "@joshua" Then

ActiveWindow.DisplayWorkbookTabs = Not (ActiveWindow.DisplayWorkbookTabs)

'your code here

MsgBox ("Successfully Locked")

Else

If MsgBox("Password incorrect, try again?", vbYesNo, "Wrong password") = vbYes Then GoTo tryagain

End If

ActiveSheet.Next.Activate

ActiveWorkbook.Sheets(1).Activate

Password for Sheet:

Sheets(1).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

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

jashuaa i will appreciate if u explain the procedure to procees the data as u have done earlier
From India, Hyderabad
Acknowledge(0)
Amend(0)

Joshua, Pls advice how to open your file, if we open this open what should we do next to unlock it ...where to put you given password?? If you say you are innocent, tell us...
From India, Delhi
Acknowledge(0)
Amend(0)

Once u open the password work with attendance report u will get all the detaisl in Salary Calculation Payslip ect. Gothrough with file first and ask the doubt. Regards, JA
From India, Madras
Acknowledge(0)
Amend(0)

You have given wrong password___as i told you many times___ pls delete this post___ its stupidity to waste our time with this___ members pls do not break head with this post__
From India, Delhi
Acknowledge(0)
Amend(0)

Hi Joshua Alvina,

I could not find the attachment. When I opened the sheet, it didn't ask for a password, and there are no options to click on the login password or lock password. If you could please send it to hr2@ayantech.com, it would be really great.

Thanks

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

Dear Joshua,

You are right, the passwords are all correct. The only problem with me and all the not so computer-savvy people, as I am, don't know about the macros in the Excel sheet. After a long battle with the settings with macro security options, I found the solution. Here is how I found the solution:

Opened Microsoft Excel Tools -> Macro -> Security... Under "Security Level" Tab Select "Low (not recommended)" radio button

That's it. And then the passwords are working fine...

Regards

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

Dear All, You need to click on unhide all workbooks dat’s it, all the sheets are very much there. Thanks Joshuaalvina, it seems to be very useful....!
From India, Delhi
Acknowledge(0)
Amend(0)

Dear Joshua, The unprotect password alvina for unprotecting worksheet is incorrect. Please check and reply. Regards Amit
From India, Ludhiana
Acknowledge(0)
Amend(0)

Dear Joshua, The unprotect password alvina or carrot is incorrect. Please check and post it again if possible. Regards Meenakshi
From India, New Delhi
Acknowledge(0)
Amend(0)

Hi Joshua!

You are not cheating anybody. It really works, what you have attached. Thanks a lot.

Guys, please see scrap no. 87 (Taslima).

Opened Microsoft Excel.

Tools -> Macro -> Security...

Under the "Security Level" tab, select the "Low (not recommended)" radio button.

That's it.

I'm attaching it again.

Regards,
Pushpendra

From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls Att. Salary, Payslip workbook.xls (784.0 KB, 688 views)

Acknowledge(1)
Amend(0)

Hi Joshua,

I can easily work on your sheet. It's easy to run the file, and what a work you have done! I really appreciate it. Can you tell me when all sheets are unhidden, then what's the password for different sheets as you have mentioned?

Also, I request you to please provide me the attachment that you have attached on this forum.

Again, thanks a lot as it is very, very useful.

Regards,
Arihant

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

Dear Joshua,

Could you please be so kind as to resend the file "Systematic and Faster Attendance Register Fully Designed With Macro.xls" once more, along with your mobile number? This way, we can seek your direct assistance at any time.

Thank you.

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

Dear Josh,

I am grateful that you have provided the password-free Attendance Register to your fans. I have downloaded it and found it very helpful. When we give something to others, we find inner peace and happiness. I am sure that you will be proud of yourself because sharing your hard work with unskilled people like me without asking for anything is a matter of great pride. According to Buddhism, you have created good karma, which will be helpful in your future life.

Sher

From Pakistan, Karachi
Acknowledge(0)
Amend(0)

Dear friends, i have attached a file for maint of accounts . Please see this. It may be usefull to somebody. Yours sincerely, major d bhushan rao
From India, Hyderabad
Acknowledge(0)
Amend(0)

Hi,

I have downloaded the attachment but am unable to access the Excel sheet due to the password. I was able to log in as the administrator, but then could not find the password to unlock it.

Please help.

Thanks and Regards,
Ferdinand Dsouza

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

Hi Joshua,

My name is Zeshan, and I recently joined a company as an HR Assistant Manager. First of all, thanks for your Attendance Register. However, I have a problem with it. Your calculation is based on daily wage staff, but I have permanent staff on a monthly basis. How can I manage this worksheet? Please guide me. You can reply to my email address at bajwazeshan@gmail.com.

Thanks

From United Arab Emirates, Dubai
Acknowledge(0)
Amend(0)

Dear your passwords are not working except login please give the right passwords so we can edit
From India, Delhi
Acknowledge(0)
Amend(0)

The layout is really nicely done. The downside is that many people can't get the passwords to work, and this person seems to enjoy playing around with providing the correct password. It's truly a shame that this type of problem exists. Personally, I just load a macro to remove all passwords; it's much easier than constantly asking for passwords.
From United States, Grand Prairie
Acknowledge(0)
Amend(0)

Hi Joshua,

When I click on the calendar, it gives me an error. None of the passwords on Sheet 1 or any are correct. When I click on any button on the index, nothing opens. The rest unlock button is also not working. We, the passwords, are all wrong - Alvina and Carrot. Kindly send me a correct sheet, please.

Thank you.

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: bmp untitled1.bmp (843.8 KB, 83 views)
File Type: bmp untitled.bmp (843.8 KB, 30 views)

Acknowledge(0)
Amend(0)

Please reply Joshua the entire software seems to be the best one. but even after unablingt macros it doesnt work.. u can see the screen shots that I have attached
From India, Mumbai
Acknowledge(0)
Amend(0)

Joshua I request you please give me the corrected sheet. I am using this as it full fills the requirement in terms of payroll
From India, Mumbai
Acknowledge(0)
Amend(0)

Dear Joshua,

The Attendance Register Cum Payroll software is good, but I am unable to operate it. The index only shows that it is protected. Please send me the password or some tips on how to operate it.

Thanks,
Nitin Jolly

From India, New Delhi
Acknowledge(0)
Amend(0)

Dear All,

I am Rajesh. I worked in the manufacturing industry, but now I am working in the service industry, which is registered under the Shops and Establishments Act of Karnataka. Can someone help me understand the difference in annual returns compared to the Factories Act with reference to all acts?

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

Hi Joshua, Your efforts are great. I have downloaded the files too. but I am not able to enter the password even after enabling the Macros. Am I missing anything? Can you please help? Thanks Tanya
From India, Ahmadabad
Acknowledge(0)
Amend(0)

dera Joshua, Please provide the user admin Password.so that i can edit the months in INdex sheet
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Systematic and Faster Attendance Register Fully Designed With Macro (EDITED).xls (787.5 KB, 698 views)

Acknowledge(1)
Amend(0)

Dear Joshua, please provide me with the details of the password as I cannot update the month calendar in the index sheet. It is still showing November 2009 and it is interlinked with all other sheets, I believe. Please update it and forward it to me at my email: [Email Removed For Privacy Reasons].

Thank you.

Regards.

From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Systematic and Faster Attendance Register Fully Designed With Macro (EDITED).xls (807.0 KB, 774 views)

Acknowledge(0)
Amend(0)

Dear Sir, hats off to you for breaking the Excel macros. I am unable to include the members in the payslip format. It is indicating errors in the Employee Name and Designation everywhere. Please find the attachment of the Payslip for Employee No. 020. I have used the formulas; however, it is still showing errors. Please suggest how I can correct it.

Moreover, the Basic Salary calculations seem to be incorrect. The Net Salary for a Gross Salary of Rs. 21,000/- shows only Rs. 13,950 as Net Salary. Kindly correct and send it back to me.

Thank you.

Regards, D. DHANASHEKAR

From India, Bangalore
Acknowledge(1)
Amend(0)

Your job is greatly appreciated, especially for sharing the same. I have gone through the attendance sheet and noticed the markings "X, A, H, S, PH." However, in the scenario where a person works for half a day and takes half a day off, how should I mark this? Please correct this for me, or kindly inform me on the correct method.

Thanks and regards,

MANJUNATH KS

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

I have attendance register modified to suit my requirement , how do i generate report based on the attendance recorded. Can someone help me . to generate attendance and absence report.
From India, Thane
Acknowledge(0)
Amend(0)

You can use attendance software, which provides a convenient way to track your employees' attendance and monitor productivity. There are multiple software options available in the market. One such software is greytHR, which can streamline your attendance management. Additionally, greytHR can generate your attendance and absence reports. It can create ten different attendance reports based on your requirements, such as the attendance summary report, attendance consolidation report, attendance regularization report, NCP report (Non-Contribution Period as per statutory), and more. https://www.greythr.com/in/features/...ment-software/

Regards

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

Hi,

As per your attachment "ATTENDANCE REGISTER CUM PAYROLL Including All ESI PF forms" by Joshua Alvina, edited on 28.01.2010 (and link file also given - open the zip folder, copy the files, and paste them in your add-in).

The unprotected sheet password is not working. Kindly advise me.

Regards,

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

Hi, this is Sudhagar. I have downloaded your Systematic and Faster Attendance Fully Registered with Macro Edited. It's a very beautifully planned and worked software for Salary Payroll and a great help for all HR people. However, I am not able to unlock the Pay Slip Cum Time Card sheet. Could you please help me with the password? Without the password, how could I edit that sheet? This is my email address Sudhagar_r@yahoo.in, so can you send the PW.
From India, Coimbatore
Acknowledge(0)
Amend(0)

Hi, this is Jeevan. I have downloaded your Systematic and Faster Attendance Fully Registered with Macro Edited. It's a very beautifully planned and worked software for Salary Payroll, and a great help for all HR people. However, I am not able to unlock it. When I am trying to unlock it, it does not open. May I know the password? My email id is jeeva.ragati@polyglotit.com.
From India, Hyderabad
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.