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, 47682 views)
File Type: xls Esi Chellan.xls (67.0 KB, 13876 views)
File Type: xls Form-05 (REGULATION No. 32).xls (238.0 KB, 10204 views)
File Type: xls Form 6A (PF Return Contribution).xls (37.5 KB, 10737 views)
File Type: xls Form 3A (Return Contribution).xls (37.5 KB, 9816 views)

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
Upading Files Weekly Planner
8th September 2009 From India, Madras
Attached Files
File Type: xls Weekly Planner.xls (79.5 KB, 10059 views)
File Type: xls yearly-calendar.xls (48.5 KB, 11799 views)
File Type: xls Stock Management.xls (443.5 KB, 9393 views)
File Type: xls Bill of Lading Sample.xls (240.0 KB, 5144 views)
File Type: xls EXPORT INVOICE.xls (248.5 KB, 5772 views)
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
8th September 2009 From India, Madras
Attached Files
File Type: xls Attendance-Register.xls (50.0 KB, 26191 views)
File Type: xls Outstanding-Report.xls (53.5 KB, 7259 views)
File Type: xls unprotect.xls (519.5 KB, 7459 views)
File Type: xls Attendance Register Cum Payslip.xls (2.12 MB, 15933 views)
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, 16843 views)
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
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
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, 2817 views)
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