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
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Globaloverseas144
Soical Compliance Auditing
CaPulkit
Practicing Chartered Accountant
Balaji Rao03
Aviation Logistics, 3pl Regional Head
Alokranjan
Situational Handling Capacity
V. Balaji
Ir & Hr
Harika07.kadavakollu
Sr.human Resource Executive
Vinoth@
Hr - Executive
+3 Others

Hi Check this
From India, Bangalore

Attached Files (Download Requires Membership)
File Type: xls Salary sheet format.xls (355.0 KB, 54360 views)
File Type: xls Salary slip format.xls (19.5 KB, 17298 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, 25122 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, 9065 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, 11309 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, 16091 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, 9476 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.


Add Reply → Start New →






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

All rights reserved @ 2022 CiteHRŽ

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