There have been many enquiries on PCB bonus calculations from companies using Excel. In fact our article : 3 Ways to do PCB calculation for Bonus without a Payroll Software has been viewed more than 45,000 times.
To make it easier for such users, we have designed an Excel template to automate the difficult parts of the PCB Bonus calculation. Following is a screenshot of the template. All you have to do is replace the values in RED.
This example is for staff who is married , spouse working with 2 children KA2.
The excel file comes with 2 templates. One for the bonus calculation another for the end of month salary. In some cases, the month salary will require some extra calculations.
Download file here : http://actpayroll.com/download/pcb-bonus-calculation-excel-template/
If you find this File useful, please “Like” us on Social Media