hello to every one . could any body give the formula for a situation where by just putting the number of days worked we get the basic salary pop in the salary cell. its very urgent as i am new to this company .
thanking in advance for the help , whoever would extend to me.

From India, Mangaluru

Get Dual Certificates from IIM Shillong and SHRM →
Promoted: IIM Shillong - PG Certification in Human Resource Management (Explore Course)
Hi Check this
From India, Bangalore

Attached Files (Download Requires Membership)
File Type: xls Salary sheet format.xls (355.0 KB, 54075 views)
File Type: xls Salary slip format.xls (19.5 KB, 17122 views)

i.ve checked the attachments , its quite helpful for me in the later stage , but currently i need the solution for the sheet which i have uploaded, where in u can find the " days" cell before "basic" cell , in the salary section , in the " days" cell when we put the days worked , it should give the basic salary , details of which are in Data sheet before "march" sheet. i hope u got wat i meant.
From India, Mangaluru

Attached Files (Download Requires Membership)
File Type: xls Employee Attendance and Salary Sheet.xls (984.5 KB, 24940 views)

mr arun attacheed plcheck ur sheet. i inserted one more column in b/w.
From India, Madras

Attached Files (Download Requires Membership)
File Type: xls amended.xls (644.5 KB, 9001 views)

Pl check attached file, hope it will serve yr purpose. rgds, Sharmamk
From India, Faridabad

Attached Files (Download Requires Membership)
File Type: xls Employee Attendance and Salary Sheet.xls (987.0 KB, 11250 views)

Pls find attached salary sheet,you can calculate ESI/PF/OT etc.. Best Regard Sajid Ansari-Delhi
From India, Delhi

Attached Files (Download Requires Membership)
File Type: xls Salary Calculation With OT ESI EPF ADV(1).xls (150.0 KB, 15969 views)

dear Pls see attached sample worksheet that may help you. V. Balaji
From India, Madras

Attached Files (Download Requires Membership)
File Type: xls sample payslip.xls (21.5 KB, 9418 views)

thanks a lot from all of you friends, i dun know if such a help would have been provided by my near n dear friends or no.who said Indians hate each other? this forum is a live evidence that we love each other. thank you all once again
From India, Mangaluru
friends i have another issue as well dun no whether to ask here or in some other topic, still i'll make n effort. issue is , i have done my LLB+MBA in HR n have joined a newly established medical transcription company , where in my role is yet to b known as i am the first HR of this company with 10 employees , n there is no training which i have undergone as an HR. plz help me or advise me as to wat can i do to help this co grow from legal and hr point of view . thanks in advance.
From India, Mangaluru
Dear Sr.
Plz help me for some confusion. How to calculate Professional tax ,as per day or as per salary. Eg.salary is 10000 and workinh days is 15 and as per professional tax slab we cut professional tax 150 or 120 ????
PLz sol my this quarry ...
Regards
Kalpa

From India, Ahmadabad

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.


Please Login To Add Reply →






About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHRô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server