Comprehensive Guide to Bonus Calculation Methods and Excel Sheets for Employee Compensation

Anonymous

dear all senior, i have attached two excel sheet of bonus calculation, please tell me what is the right way to prepare bonus % by earned basic or working days
31st October 2015 From India, Gurgaon

Attached Files (Download Requires Membership)

BONUS CALCULATION BY WAGE.xls (41.0 KB, 8384 views)

BONUS CALCULATION BY WORKING DAYS.xls (33.0 KB, 10126 views)

Acknowledge(0)

Amend(0)

Add Reply → Start New →

Mahesh Manave

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= 42000/-
3rd June 2016 From India, Chennai

Acknowledge(1)

Amend(0)

Rai surya

If a graduate employee drawing basic salary 17000/- pm and govt minimum scale is 10000/- pm. What will be the figure for bonus purpose @ 8.33% .
28th April 2017

Acknowledge(2)

Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.

Other Discussions That May Be Relevant

Efficient overtime calculation using excel sheets for employee compensation
Dear leaders this is rinki sharma. i want to know if we can calculate overtime hours in an excel sheet by only entering the in and out times....
2 Replies 0 Files 3 Participants

Various mis compensation report required... - xls download
I am working as a compensation & mis executive where i need to maintain various reports. however as i am new to the company i require different formats and guidance...
2 Replies 1 Files 2 Participants

How to merge sheets from multiple excel files into one .xls file
To merge sheets from multiple excel files into one .xls file you can follow these steps: 1. open the excel files that contain the sheets you want to merge. 2....
2 Replies 0 Files 3 Participants

Employee bonus calculation - details and procedures pertaining to the payment of bonus act
Hello everyone warm regards i need guidance on how to prepare bonuses for our personnel. i am seeking comprehensive information about the procedures and details related to the payment of...
25 Replies 0 Files 23 Participants

Insights on bonus calculation & payment under the payment of bonus act
Dear seniors we were paying a bonus to staff at 8.33 employees getting a salary of rs 3500 or less at the actual salary basic and da. it is noticed...
7 Replies 3 Files 8 Participants

Understanding bonus eligibility and calculation for marketing executives
Would you mind if i could get some information/clarifications about bonuses? if you would not mind could you please advise me? you see we have appointed 3 marketing executives along...
2 Replies 0 Files 3 Participants

Understanding bonus calculation and payment of bonus act
Hi friends i have some knowledge about bonus calculation. we take basicda from april 2007 till april 2008 8.33. do we also have to take their number of years...
2 Replies 0 Files 3 Participants

Related Files & Downloads Shared By Members

 BONUS CALCULATION  FOR W.B.Govt employee for  2010-2011.xls

 Employee excel sheet.xls

 SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls

Comprehensive Guide to Bonus Calculation Methods and Excel Sheets for Employee Compensation

Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 543017)

TOP ENTRIES ON SUBJECT

Interest Tags

Trending Tags

Trending

Comprehensive Guide to Bonus Calculation Methods and Excel Sheets for Employee Compensation

Login Or Register

Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 543017)

TOP ENTRIES ON SUBJECT