Calculating staff bonuses

bonus-calculator.xls

This is a simple but effective little spreadsheet for you to download and play with.

In the practice who use it, profits are calculated monthly and then distributed to all salaried staff in the same proportion that their individual salary bears to the overall payroll cost.

This means that everybody is getting the same percentage of their salary as a bonus – get that?

You can enter bonus percentage, salaries and monthly profits in the white spaces – and go from there! Â Â

 Â