Excel Formula - Number Of Days And Salary? - XLS Download

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.
16th July 2009 From India, Mangaluru

Hi Check this
16th July 2009 From India, Bangalore

Attached Files

Membership is required for download. Create An Account First

Salary sheet format.xls (355.0 KB, 52549 views)

Salary slip format.xls (19.5 KB, 16344 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.
17th July 2009 From India, Mangaluru

Attached Files

Membership is required for download. Create An Account First

Employee Attendance and Salary Sheet.xls (984.5 KB, 23931 views)

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

Attached Files

Membership is required for download. Create An Account First

amended.xls (644.5 KB, 8592 views)

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

Attached Files

Membership is required for download. Create An Account First

Employee Attendance and Salary Sheet.xls (987.0 KB, 10855 views)

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

Attached Files

Membership is required for download. Create An Account First

Salary Calculation With OT ESI EPF ADV(1).xls (150.0 KB, 15270 views)

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

Attached Files

Membership is required for download. Create An Account First

sample payslip.xls (21.5 KB, 9111 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
23rd July 2009 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.
23rd July 2009 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
25th July 2009 From India, Ahmadabad

Dear,
Professional tax is calculated based on one's earnings and a slab where his earnings get fitted in the slab. This varies from regional to region and state to state.
assume, the slab goes like this,
0 - 3000 : NIL
3001 - 5000 : Rs.50
5001 - 7000 : Rs.60
7001 - 10000 : Rs.1000
His actual salary is Rs.10,000/- and earns only Rs.5200- (due to loss of pay), Hence, his PTAX deduction shall be be Rs.60/-. Assume he goes on loss of pay for the whole month, his salary will be zero and hence there would be no deduction. Therefore, it should be based on the earnings only.
someone can enlighten, if i am wrong.
V. Balaji
26th July 2009 From India, Madras

Dear Sajid
Would u please tell me How u have to calculated the BASIC & HRA/DA OF ONE EMPLOYEE ? is there any fixed formula u have used here or it differs from employe to employee ?
u can mail me:
15th November 2009 From India, Bhubaneswar

Would u please tell me How u have to calculated the BASIC & HRA/DA OF ONE EMPLOYEE ? is there any fixed formula u have used here or it differs from employe to employee ?
u can mail me(pra_belman@gmail.co.in
4th December 2009 From India, Bangalore

i am really happy to join that i can easily know about the payroll process and pf ,esi and tax deductions.i thanks to overall all of member of cite hr who paid their contribution .
20th April 2013 From India, Hyderabad

Dear member Attaching a sheet which should be useful to you. Regards Preetam Deshpande
24th April 2013 From India, Mumbai

Attached Files

Membership is required for download. Create An Account First

attendancecumsalarysheet.xls (39.5 KB, 1957 views)

Please let me know if TDS is deducted for consolidated Salary and how can a breakup be done in case of consolidated salary. For eg:- if an employee is paid 50,000 as consolidated salary - what is the TDS to be deducted and how can i make abreakup in the sal slip.
20th May 2013 From India, Kochi

hello really its very use full for fresher of MBA hr like me
1st June 2013 From India

Dear All ,
I t would really appreciable that one on one help each other.
Any ways mine is same Problem.I do have experience 2yrs but i dont know how to do paroll process.Please help me out to learn things.
Regards
Harika
8th August 2013 From India, Vijayawada

Hi not a problem you can download the sheet from links in red below. This excel template will not only give you the salary based on attandance. But with this template its possible to even manage full HR Requirements.
9th August 2013 From India, Bangalore

Dear Harika, please open the file with "Macro enabled:. Regards, Prabhas
13th August 2013 From India, Madras

hi to all am new in this and i want all your help and guidance, am confused how to take out the basic salary of the monthly ctc if 15000/-. what will be the % of ctc for basic salary.
5th December 2016 From India, Balaghat

sir, this is most valueable for me and sir please send new format excel format pf & esi
31st December 2016 From India, Malda

Hello Sir,
Here I am see all salary structure but not sufficient to my organisation. So pls Provide me any retails Industries salary structure so me very helpful to our organisation.

I Hope you provided us any retails industries salary format
11th March 2017 From India, Ahmedabad

Hi ..could any tell me For this situation ...In our company there is no pf or esi deduction for the employees but we provide take home salary only... What my question is?.. If employee relieved from the company in proper way.. Should I give payslip to them?.. I need solution for this
17th September 2017 From India, Kalpakkam

can anyone provide me with Consolidated excel sheet for attendance for workers and supervisors in factory.
Thanks & Regards
30th September 2017