Bonus Calculation Sheet

What is a Bonus Calculation Sheet?

A bonus calculation sheet works out, employee by employee, what bonus is due for the year: the qualifying wage, the percentage applied, any ceiling, the days worked and the amount payable. Where bonus is a statutory entitlement rather than a discretionary payment, the sheet is the evidence an inspector or an auditor asks for. Without it, the figure paid is a number nobody can reconstruct a year later.

Payroll and HR teams in India prepare these annually under the Payment of Bonus Act, usually ahead of the statutory payment deadline that follows the end of the accounting year, and inspectors ask to see them alongside the bonus register. Outside that statutory context, employers use the same sheet for discretionary or contractual schemes: sales commission, an annual performance bonus, profit share, or a thirteenth-month payment where local law or practice requires one. Accountants use it to support the accrual sitting in the year-end accounts.

Whether a bonus is compulsory at all depends entirely on the jurisdiction. India's Payment of Bonus Act imposes a statutory minimum and maximum, an eligibility wage ceiling, a separate calculation ceiling and a service qualification, and those figures are amended by notification — check the current ones and the current applicability thresholds before you calculate anything. Several Latin American and European countries require a thirteenth-month or holiday payment by law or collective agreement. The UK, the US, Canada and Australia generally have no statutory annual bonus, so entitlement comes from the contract or the scheme.

The sheet applies a rule; it does not decide whether the rule applies. Whether your establishment is covered, whether a particular employee is eligible, and whether a bonus can be reduced or withheld are questions for the statute, the scheme rules or an adviser, not for a spreadsheet. It is not a payslip, and it is not the statutory bonus register, which several jurisdictions prescribe in a set form. It also does not handle tax: bonus is generally taxable and often subject to withholding at the point of payment, on rules that differ by country.

What to put in a Bonus Calculation Sheet

These are the details this template asks for. Anything left blank is marked in red on the preview so you can see what is still missing.

How to write a Bonus Calculation Sheet

1. Confirm coverage and eligibility first

   Before any arithmetic, record for each person whether they meet the eligibility test being applied: minimum days worked in the year, wage below the eligibility ceiling if one applies, and whether they were employed for the whole period. Note leavers, new joiners and anyone on unpaid leave separately. An eligibility column carrying a yes or no and a reason is what prevents the same argument every single year.

2. Fix the wage base for each employee

   State which components make up the wage used for the calculation — typically basic and dearness allowance under a statutory scheme, or a defined figure under a contractual one — and exclude the rest. Show the monthly figure and the annual total. Where a calculation ceiling applies, show both the actual wage and the capped figure in separate columns, so the effect of the cap is visible and checkable.

3. Count qualifying days worked

   Record days actually worked plus any days that count as worked under the applicable rule — paid leave, statutory leave, and lay-off days in some schemes. Pro-rate the bonus for anyone who did not work the full period. Getting this wrong for a mid-year joiner is the most common source of underpayment, and underpayments are what employees raise months later with interest attached.

4. Apply the percentage and show the working

   Set out the percentage being applied and where it comes from — the statutory minimum, a board resolution, a scheme formula, an allocable surplus calculation. Show wage base, percentage and result in adjacent columns rather than as a single value, so a reviewer can recompute any row. Where the figure paid is above the minimum, record the decision that authorised the higher rate.

5. Total, approve and record payment

   Total the payable column, reconcile it to the accrual in the accounts and to the amount transferred, then record the payment date and method against each row. Have it approved by someone other than the preparer. Keep it with the supporting register and the approval for the retention period your jurisdiction sets — bonus disputes surface long after the year has closed.

Common mistakes

• Calculating on gross pay when the applicable rule uses a narrower wage base, which overstates the liability and sets a precedent employees will expect repeated.
• Applying last year's ceiling or percentage because the sheet was copied forward, so the figures are wrong for every employee the moment a notification changes them.
• Missing the pro-rata for joiners and leavers, producing underpayments that resurface as claims once one employee compares their figure with another's.
• Treating a discretionary bonus as statutory, or the reverse, so the employer either creates an entitlement it never intended or fails to pay one it owed.
• Paying after the statutory deadline where one applies, which converts an administrative delay into a compliance failure with penalties attached.

Frequently asked questions

This page explains general practice and is not legal advice. Requirements differ between countries and, in some cases, between states — check what applies where the document will be used.

Related templates

All templates · HR & People templates