Attendance Register + Payroll Calculation + Payslip In Excel Format Wowwww Systematic

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 HRcite.com
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,
Joshuaalvina.
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

Membership is required for download. Create An Account First

Workers 1 (August 2009).xls (930.0 KB, 51700 views)

Esi Chellan.xls (67.0 KB, 15373 views)

Form-05 (REGULATION No. 32).xls (238.0 KB, 11550 views)

Form 6A (PF Return Contribution).xls (37.5 KB, 12072 views)

Form 3A (Return Contribution).xls (37.5 KB, 10983 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 .
Regards
UDAY
8th September 2009 From India, Hyderabad

Upading Files Weekly Planner
8th September 2009 From India, Madras

Attached Files

Membership is required for download. Create An Account First

Weekly Planner.xls (79.5 KB, 11848 views)

yearly-calendar.xls (48.5 KB, 12921 views)

Stock Management.xls (443.5 KB, 11084 views)

Bill of Lading Sample.xls (240.0 KB, 5917 views)

EXPORT INVOICE.xls (248.5 KB, 6634 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
Cheerz
Jeeva
8th September 2009 From India, Bangalore

ATTENDACE REGISTER CUM SALARY CALCULATION & PAYSLIP NEWLY UPDATED TODAY (19.10.2009) ENJOYYYYYY Password: joshua Regards, Joshua Alvina
8th September 2009 From India, Madras

Attached Files

Membership is required for download. Create An Account First

Attendance-Register.xls (50.0 KB, 29249 views)

Outstanding-Report.xls (53.5 KB, 8336 views)

unprotect.xls (519.5 KB, 8701 views)

Attendance Register Cum Payslip.xls (2.12 MB, 19793 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

Membership is required for download. Create An Account First

ATTENDENCE SHEET WITH SALARY, ESI & PF CALCULATION.xls (43.0 KB, 21563 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

Membership is required for download. Create An Account First

Attendance-Register-unprotected.xls (50.0 KB, 5107 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

Hi Joshua,
I have gone thru ur Attendence sheet its excellent but I have a few suggestions for improvement
You have give only three options I would suggest you to add OT and Paid Holidays To it. bcoz as per labour act the person has to work only for 26 days and four weekly offs has to be provided and you should limit the working days to 26 and anything above that is counted as OT.
Paid holidays like August 15 or any other national holidays are counted as present which should have a separate column and the wage amount should be added while calculating the wages.
9th September 2009 From India, Hyderabad

Dear Joshuaalvina,
Excellent work u have done.
I have some doubts .....
* Please let me know on wat % you have calculated Basic?
* I want to insert Department column
* Where enter our OT Your sheet is protected.
If you want we work in your sheet plz give passoward. otherwise it is a good picture.
Really i appriciate for your hard word for making a picture.
Well done
Thank you .
Regards
Verma
9th September 2009 From India, Calcutta

Hi,
This posting is really mind blowing. do you have the format like this for Maintaining Training record.
We have Training card of Individual employee which contents Skill Matrix, Training Feedback & Evaluation etc.
9th September 2009 From India, Indore

Dear Josh ! Yes, i found the pwd and now it is unprotected.. excellent piece of work done ! Keep posting B/Rgds RK
9th September 2009 From India, Hyderabad

Attached Files

Membership is required for download. Create An Account First

Workers 1 (August 2009).xls (929.5 KB, 1410 views)

Hi all,
this is for all those souls who are tired trying to edit the masterpiece created be Joshua.
the password is " joshua " and this is how it has to be done with.
Sorry Joshua. good work though
How to Remove a password
Do one or both of the following:
Open the file using your open password and as read/write.
Open the file using your modify password and as read/write.
Click the Microsoft Office Button , and then click Save As.
Click Tools, and then click General Options.
Select the password, and then press DELETE.
Click OK.
Click Save.
If prompted, click Yes to replace the existing file.

10th September 2009 From India, Bangalore

Dear
i m very proud of you that you have posted good formats on the citehr. please we will grateful of you if you send me password of the unprotect sheet.
My employee strength is more than 100 and i want to increase rows , maharashtra lwf, loan, advance, other deduction like coupen, lic, column is not available please give me unprotect sheet password immediately. thanking you
10th September 2009 From India, Pune

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
Regards,
GRREDDY
29th September 2009 From India, Bellary

CODE No.: W12009 Quote Code No. while you reply.............. Password: protect Regards. J/A
20th October 2009 From India, Madras

Attached Files

Membership is required for download. Create An Account First

Workers 1 (November 2009).xls (912.0 KB, 822 views)

CODE No.: Form252009 (UP) Quote Code No. while you reply.............. (Adttendace register cum payslip) Password: Unprotect Regards. J/A
20th October 2009 From India, Madras

Attached Files

Membership is required for download. Create An Account First

Attendance Register.xls (1.32 MB, 1667 views)

Company Letterhead for emergency Use........... CODE No.: LH2009 Quote Code No. while you reply.............. Password: LH Regards, J/A
20th October 2009 From India, Madras

Attached Files

Membership is required for download. Create An Account First

letterhead.xls (92.5 KB, 1347 views)

dEAR jOSHUA
i CANT OPEN UR FILE BECUASE UR FILE I S PROTECTED AND I TIRED TO OPEN
THANKS.
CHIRAG
26th May 2018 From India, Ahmedabad

i am an employer . i run a inter college. i want to add aepf account for our staff. iwant to know that minimum wage for epf is 6500 and max 15000.but on labour law in up min. wage for skilled stoff is about 10000 .if i give sailary to staff approx.9000 then what is a legal advise for me ? i have no capacity that sailary above 9000 then what i do ?
29th June 2018 From India, Lucknow

Hi please can u give me full addition of Stock management record becuase some of option can not be opened
27th July 2018 From Pakistan, Lahore

Need password for the file attached please help me
15th November 2018 From India, Srinagar

Attached Files

Membership is required for download. Create An Account First

Attendance Register Cum Payslip.xls (2.13 MB, 120 views)

Need password for the file attached please help me
21st November 2018 From India, Adilabad

Please provide the password for "attendance register cum pay sleep.
30th November 2018 From India, Calcutta

Attached Files

Membership is required for download. Create An Account First

Attendance Register Cum Payslip (3).xls (2.09 MB, 131 views)

Hi All,
"Attendance Register Cum Payslip.Xls" Icons not working. Can you pls help me or provide an alternative payroll file to generate payslips?
Regards,
Velu
6th December 2018 From India, Chennai

https://www.citehr.com/attachments/1...payslip-3-.xls ple password
10th December 2018 From India, Basi

pl password send me
10th December 2018 From India, Basi

Attached Files

Membership is required for download. Create An Account First

Attendance Register Cum Payslip (3) k.xls (2.12 MB, 133 views)