Dear All,
All of you will be happy to know that I got a HR job in new company. The first task I got is to make Salaries. This is a automobile Industry so calculation policies are different. I need your help to manage this salary sheet. I need some Formulas setting bcoz old one is very difficult to understand.
The steps are:-
Late Time (LT):- 3 late time (LT) are considerable and after that we need to deduct half day salary.
Half Day:- for Half day need to deduct half day salary.
Sunday Present: Need to pay full day salary or can adjust with Absents.
For leaves:- Leaves have to be adjusted with Opening leave balance. If leave balance is zero then consider it as absent to deduct amount.
Closing leaves:- Need to calculate closing leave and carry forward it for next month.
Advances deduction
Mobile deduction
Deposit deductions
Then ESI / PF calculation.
Please help me to put formulas setting in this sheet. I will be very thankful. you can mail me at
or in case of emergency can call me at 9630097328 (Official contact No).
Thanks
Poja Sharma
From India, Indore
28All of you will be happy to know that I got a HR job in new company. The first task I got is to make Salaries. This is a automobile Industry so calculation policies are different. I need your help to manage this salary sheet. I need some Formulas setting bcoz old one is very difficult to understand.
The steps are:-
Late Time (LT):- 3 late time (LT) are considerable and after that we need to deduct half day salary.
Half Day:- for Half day need to deduct half day salary.
Sunday Present: Need to pay full day salary or can adjust with Absents.
For leaves:- Leaves have to be adjusted with Opening leave balance. If leave balance is zero then consider it as absent to deduct amount.
Closing leaves:- Need to calculate closing leave and carry forward it for next month.
Advances deduction
Mobile deduction
Deposit deductions
Then ESI / PF calculation.
Please help me to put formulas setting in this sheet. I will be very thankful. you can mail me at
Thanks
Poja Sharma
From India, Indore
PFA and help me for the same. Really need a help from excel expert. If any one from you can teach me that will be more good.
From India, Indore
From India, Indore
Dear Pooja Hum apko help nahi karenge Simple simple formula v apko logo se puchna parta hai, its not good dear.
From India, Kolkata
From India, Kolkata
Hi,
Kindly find attached file.
Let me know if any help required.
Salary Statement Format « hrmexpress
Thanks,
Bhakti
From India, Mumbai
Kindly find attached file.
Let me know if any help required.
Salary Statement Format « hrmexpress
Thanks,
Bhakti
From India, Mumbai
Hi Bhakti,
Plz share ur No. or call me at 9630097328
Its urgent............................................ .................................................. .................................................. .................................................. ............................
From India, Indore
Plz share ur No. or call me at 9630097328
Its urgent............................................ .................................................. .................................................. .................................................. ............................
From India, Indore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Effectively Manage Workplace Diversity.doc
How to Manage Training - A Guide to Design and Delivery for High Performance.[20 03.ISBN08144077 9.zip
How to manage your boss.pdf