Globaloverseas144
Soical Compliance Auditing
CaPulkit
Practicing Chartered Accountant
ExcelRocker
Chief Consultant
Balaji Rao03
Aviation Logistics, 3pl Regional Head
Alokranjan
Situational Handling Capacity
V. Balaji
Ir & Hr
Harika07.kadavakollu
Sr.human Resource Executive
Virendra Solanki
Hr Executive
Vinoth@
Hr - Executive
+8 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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
Hi Check this
From India, Bangalore

Attached Files
File Type: xls Salary sheet format.xls (355.0 KB, 53436 views)
File Type: xls Salary slip format.xls (19.5 KB, 16776 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
File Type: xls Employee Attendance and Salary Sheet.xls (984.5 KB, 24535 views)

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

Attached Files
File Type: xls amended.xls (644.5 KB, 8851 views)

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

Attached Files
File Type: xls Employee Attendance and Salary Sheet.xls (987.0 KB, 11087 views)

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

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

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

Attached Files
File Type: xls sample payslip.xls (21.5 KB, 9280 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

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.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™