From "Joshuaalvina" : Dear All,
I am pleasure to post Attendance Register + Payroll Calculation + Payslip + Esi Chellan + Esi Form (Returns) 5 (or) 6(REGULATION No. 32) + Form 3A (Returns) + Form 6A (Returns) in Excel Format Wowwww Systematic ones.
If you like reply me. All the credit goes to
Finally I have unhided the password for all of my fans......... password: ottffsse
Password for attendance register: joshua (or) SALSLVS
"Scroll Down You Can Find Something New"
Thanks & Regards,
Note: This is only sample ones.................Anyone can design this templates better then me and send it to me for ur taste.............
8th September 2009 From India, Madras
Attached Files
File Type: xls Workers 1 (August 2009).xls (930.0 KB, 48351 views)
File Type: xls Esi Chellan.xls (67.0 KB, 14102 views)
File Type: xls Form-05 (REGULATION No. 32).xls (238.0 KB, 10410 views)
File Type: xls Form 6A (PF Return Contribution).xls (37.5 KB, 10917 views)
File Type: xls Form 3A (Return Contribution).xls (37.5 KB, 9976 views)

uday3003 5
Dear Joshuaalvina,
Excellent work u have done.
I have some doubts .....
* Please let me know on wat % you have calculated Basic?
* It is showing some other deductions if emploee worked for full month also(I doubt plz check)
* In my company there is no OT concept.
Really i appriciate for your hard word
Well done
Thank you .
8th September 2009 From India, Hyderabad
Joshuaalvina 96
Upading Files Weekly Planner
8th September 2009 From India, Madras
Attached Files
File Type: xls Weekly Planner.xls (79.5 KB, 10356 views)
File Type: xls yearly-calendar.xls (48.5 KB, 11992 views)
File Type: xls Stock Management.xls (443.5 KB, 9658 views)
File Type: xls Bill of Lading Sample.xls (240.0 KB, 5265 views)
File Type: xls EXPORT INVOICE.xls (248.5 KB, 5923 views)
jeevarathnam 555
Dear Jousua!
Excellent posting. But requires some corrections.
Plz don't mind on pointing the errors.
1) If employees gross salary exceeds 10000/- then there should not be ESI deduction.
2) If total of Basic+DA+HRA+Other Allowances comes to 15000 then how can the pay will be 10099/-?
3) More over the net pay should not be more than net pay.
More over it is password protected. can u plz tell me the pasword
8th September 2009 From India, Bangalore
Joshuaalvina 96
8th September 2009 From India, Madras
Attached Files
File Type: xls Attendance-Register.xls (50.0 KB, 26712 views)
File Type: xls Outstanding-Report.xls (53.5 KB, 7445 views)
File Type: xls unprotect.xls (519.5 KB, 7664 views)
File Type: xls Attendance Register Cum Payslip.xls (2.12 MB, 16575 views)
kuldeep.k74 10
Dear All, I am pleasure to post Attendance Register + Payroll Calculation + Payslip in Excel Format If you like reply me. Thanks & Regards, Kuldeep kumar
8th September 2009 From India, Chandigarh
Attached Files
File Type: xls ATTENDENCE SHEET WITH SALARY, ESI & PF CALCULATION.xls (43.0 KB, 17585 views)
Joshuaalvina 96
this is small test for you guys the password is i already given in the worksheet pls findout...........:) Regards, Joshuaalvina
8th September 2009 From India, Madras
boski 1
Passwd to activate "ATTENDANCE REGISTER - SRI LAKSHMI VINAYAGAR SHOES" cell/box is SALSLVS & Paaswd to activate cells of the column "NAME OF EMPLOYEE" is joshua Thanks!
8th September 2009 From India, Mumbai
Excalibur 2
Hi, I’ve broken the protection for the attendance spreadsheet. I’ve attached it as unprotected to make life easier. Hope you find this useful. Excalibur
9th September 2009 From United Kingdom, Sheffield
Attached Files
File Type: xls Attendance-Register-unprotected.xls (50.0 KB, 3238 views)
Ash Mathew 43
I have not opened the files yet - But based on the comments of the people here - I guess it must be good.
I have only a comment on your poll!
Sir - you only have positive points for people to vote on. You have not given a signle thing which differs from any of the statement!
?????? Why? Afraid of rejection?
Each of the 4 statements dont differ from each other.
When you are confident that its a great work, let no fear bother you! Include even negative points and see how happy you will be when no one choses the negative point. Because it is the effort and the willingness to share that is very valued!
Take care
9th September 2009 From India, Madras
To be part of this and many other peer to peer discussions, Register at CITE which provides insights into real world issues and fosters community support and learning.

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.
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.

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network