Search results
Sep 26, 2017 · For an example if an employee basic salary is 12000 Rs ( here we will take 7000 Rs only as bonus salary) and he works for 12 months in a financial year then the bonus amount he will get in that year will be calculated like this : Bonus Calculation = (Basic Salary + DA) x Number Of Months Worked x 8.33%. = 7000 x 12 x 8.33% = Rs.6997.
The figure is bonus payable to employee under the act. BONUS CALCULATION PARAMETERS. CASE 1 BASIC LESS THAN EQUAL TO 3500 = BONUS=ACTUAL BASIC X (BONUS MONTHS) X 20%. CASE 2 BASIC MORE THAN 3500 UPTO 8400 = BONUS=Rs. 3500 X (BONUS MONTHS) X 20%, EXGRATIA=0.
Sep 1, 2017 · The calculation has to be done on the number of days the employee present. In case an employee has loss of pay in any month, the bonus basic will get reduced accordingly. In case employee has 5 days loss of pay in a particular month in which calender day is 30. Then bonus basic would be =7000/30*25=6250/-.
Attached Files (Download Requires Membership) Bonus_Calculation.xls (25.5 KB, 7256 views) R.N.Khola. 363. 3. Dear Prashant, In my opinion we should write bonus payable days instead of present days in the Bonus calculation sheet as weekly off days can not be considered as present days in a month.
Apr 13, 2011 · Need help with Bonus calculation This is my excel sheet. Name DOJ Basic Now what should be my formula for calculating bonus for these employees for last year? Well a bit confused with the concept. If anyone can clarify. 13th April 2011 From India, Pune
Jun 19, 2008 · Please find enclosed herewith the Form A which may be help you. Our company (pvt ltd) paying bonus every six months once then which form is applicable please suggest .this information is helpful for my audit. Please find attached copy of bonus calculation rules.
Oct 31, 2015 · Attached Files (Download Requires Membership) BONUS CALCULATION BY WAGE.xls (41.0 KB, 8212 views) BONUS CALCULATION BY WORKING DAYS.xls (33.0 KB, 9960 views) Add Reply → Start New →. Mahesh Manave. 1. 2. Dear Friends, Witch amount update in Bonus Form 'C' in column no 7. Ex. monthly Rs. 9759*12= 117108/- or Bonus ELIG wages Rs. 3500*12 ...
Jul 28, 2012 · I have some confusion regarding calculation of Bonus and Ex- gratia. for the rest part of salary that is (8100-3500)= 4600/- he will get ex - gratia , which is 1 month BA+DA. [B]Exp . 2 , if an employee's gross salary is 18600.00/- where BA +DA is 10,044.00/- , he will get not get any bonus, but only ex- gratia , which is 1 Month BA+DA.
Hi All, I should put professional tax slab in excel. Slab for professional tax in bangalore are till 3000 its nil;from 3000 to 4999 its 30Rs; from 5000 to 7999 its 60Rs; from 8000 to 9999 its 100 Rs; from 10000 to 14999 its 150 Rs; above 15000 its 200R s. So please guide me to apply this slab into formula in excel sheet.
Jun 18, 2008 · Minimum Limit for the Bonus is 8.33% and maximum is 20%. Minmum Bonus @ 8.33% for the employee drawing wages more than Rs. 3500.00 and less than Rs. 10000.00 will be Rs. 3500.00 as the Act. For the Employees drawing wages less than 3500.00 per month will be paid on actuals. hope this will clear your query. 18th June 2008 From India, Delhi.
