Hi Guys,
I have to prepare the salary statement, can anyone help me how to calculate in excel and i need formula for basic by which keying gross salary and no of days present,,,
Please help me out,, its very urgent,,,
Thanks
Saravanan
From India, Ambala
6I have to prepare the salary statement, can anyone help me how to calculate in excel and i need formula for basic by which keying gross salary and no of days present,,,
Please help me out,, its very urgent,,,
Thanks
Saravanan
From India, Ambala
Hi All, Herewith I am attaching a Salary sheet . Hope this information would help you.
From India, Mumbai
From India, Mumbai
I do not think there is any rule as to the dividing factor i.e. 31/30 or 26. It depends from organization to organization. Organizations either take 30 or 31 as they give advantage to the employees for LOP deductions. Presently, organizations like to be lenient because of intense competition. On the contrary most of the employees do not what dividing factor is considered while calculating LOP. But 26 days can be considered. For eg. If salary is 30,000, an organization stands to gain Rs.186 for one day's LOP, so if there are average 100 LOPS in an organization in one month, organization saves 18600 each month.
From India, Delhi
From India, Delhi
Sir,
My is Zubair Ansari please tell me All Excel formula results in Excel work all Excel formula write in Excel Sheet Fully tips & tricks to write on excel which formulas work this. Mere kahane ka matalab hai mujhe chahiye ki aap excel main jitne bhi formula hai uski working karke excel sheet par de koan sa formula kis kaam main aata hai koan sa kis kam main ye sare formula excel sheet par with formula show karte hue mujhe dene ki kripya karein main aapka jivanbhar ehsanmand rahuinga bas inhi formula ki wajah se main koi aachi job bhi kar paraha huin. Ek baar to ek company ka job ka offer aaya tha lekin excel must maang rahe aur salary 10,000 se 15000 tak de rahe the. lekin formula ka issued main puri tarah se nahi janta please mujhe puri working ke saath excel sheet par formula lagane ki tricks & trips batain aapka main jivanbhar ehsaanmand rahuinga. AAPKA shagird:idea:
From India, Ghaziabad
My is Zubair Ansari please tell me All Excel formula results in Excel work all Excel formula write in Excel Sheet Fully tips & tricks to write on excel which formulas work this. Mere kahane ka matalab hai mujhe chahiye ki aap excel main jitne bhi formula hai uski working karke excel sheet par de koan sa formula kis kaam main aata hai koan sa kis kam main ye sare formula excel sheet par with formula show karte hue mujhe dene ki kripya karein main aapka jivanbhar ehsanmand rahuinga bas inhi formula ki wajah se main koi aachi job bhi kar paraha huin. Ek baar to ek company ka job ka offer aaya tha lekin excel must maang rahe aur salary 10,000 se 15000 tak de rahe the. lekin formula ka issued main puri tarah se nahi janta please mujhe puri working ke saath excel sheet par formula lagane ki tricks & trips batain aapka main jivanbhar ehsaanmand rahuinga. AAPKA shagird:idea:
From India, Ghaziabad
Hi,
Could you plz let me know in detail like Calculation of SALARY ie. Basic pay , DA , HRA etc in terms of percentages (as against CTC) for ex: 50% of CTC is taken as HRA , etc. Plz reply me soon and e-mail me to this ID :
Regards,
SAK_82
From India, Hyderabad
Could you plz let me know in detail like Calculation of SALARY ie. Basic pay , DA , HRA etc in terms of percentages (as against CTC) for ex: 50% of CTC is taken as HRA , etc. Plz reply me soon and e-mail me to this ID :
Regards,
SAK_82
From India, Hyderabad
hi all, Pls tell me, can we breakup the minimum wages or not under labour act, if yes what is the formula for calculation.
From India, Delhi
From India, Delhi
Hi, Plz find enclosed herewith salary sheets format as per your requirement. Hope this will help you to know.
From India, Nasik
From India, Nasik
Hi, Plz find enclosed herewith Salary Sheet format as per your requirement. Hope this will help all of you to know.
From India, Nasik
From India, Nasik
hello everyone, I m vijay. Can anybody elaborate the meaning of the salary of Rs.9300-34800,Grade pay Rs.4200 & applicable allowances as per companies rules.??????
From India, Mumbai
From India, Mumbai
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.
Salary-Note.doc
SALARY SHEET CALCULATION.xls