Excel template · HR & payroll

Statutory Bonus Calculator in Excel – Code on Wages (8.33% to 20%)

Works out statutory bonus for every employee under the Code on Wages, 2019: eligibility (wages up to ₹21,000 a month and 30 days worked), the calculation ceiling of ₹7,000 or the minimum wage if higher, bonus at the rate you declare between 8.33% and 20%, interim or festival bonus already paid, and the payment deadline.

For: Employers, HR and payroll teams and consultants in establishments with 20 or more employees, especially factories, shops and service businesses paying near the minimum wage.

Free download · no sign-up · no macros · Excel 2010+, Google Sheets, LibreOffice

Step-by-step guide: How to Calculate Statutory Bonus in 2026 (Code on Wages)

Preview of the Statutory Bonus Calculator Excel template with sample data
Main sheet with sample data

At a glance

What it is
Statutory Bonus Calculator — an Excel workbook for Indian employers, HR and payroll teams
Free edition
4 sheets (Guide, Settings, Bonus Register, Summary) — free download, no sign-up
Pro edition
6 sheets, adds Allocable Surplus and Bonus Slip — ₹19 one-time (regular ₹99)
Works in
Microsoft Excel 2010 or later, Google Sheets, LibreOffice Calc — no macros
Checked
Recalculated with zero formula errors; sample data and a Guide sheet included
Made by
Prakash Bagchi, finance professional, PB Lab (Raipur, India)

Free vs Pro: what you get

SheetFreePro
Guide
What it does, how to use it, assumptions and a live status check
Settings
Accounting year, eligibility limit, calculation ceiling, bonus rate (checked 8.33%–20%), minimum bonus, minimum wage by category and the payment deadline
Bonus Register
Up to 300 employees: wages under the Code (50% rule), days worked, eligibility with the reason, ceiling, bonus wages, bonus, advance adjusted, net payable and payment status
Summary
Eligible employees, bonus cost at 8.33%, at your rate and at 20%, paid and still due, and totals by department
Allocable Surplus
Available and allocable surplus (60% / 67%), set-on and set-off, and the bonus rate the year's profits support
—
Bonus Slip
Printable slip for each employee with wages, days, ceiling, bonus, advance adjusted and net payable
—

Pro edition

Get Statutory Bonus Calculator – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • Allocable Surplus — Available and allocable surplus (60% / 67%), set-on and set-off, and the bonus rate the year's profits support
  • Bonus Slip — Printable slip for each employee with wages, days, ceiling, bonus, advance adjusted and net payable
  • One-time payment, instant .xlsx download, free updates
+91

Secure payment by Razorpay · UPI, cards, netbanking & wallets

We use your details only to deliver the file and support your purchase. See our privacy policy and terms.

Need more than one? The HR & Payroll Kit has all 9 hr & payroll Pro templates, including this one, for ₹134.

How to use it

  1. 1Download the free file and read the Guide sheet.
  2. 2On Settings, enter the accounting year, the bonus rate and the minimum wage for each category.
  3. 3On the Bonus Register, add everyone who worked during the year, including those who have left.
  4. 4Enter basic + DA, other allowances, days worked and any festival advance paid.
  5. 5Check the Summary and pay by the deadline – 30 November for an April–March year.

Bonus under the Code on Wages

From 21 November 2025, statutory bonus is governed by Chapter IV of the Code on Wages, 2019, which replaced the Payment of Bonus Act, 1965. It applies to establishments employing 20 or more persons. An employee is eligible if their wages are up to the notified limit – ₹21,000 a month – and they worked at least 30 days in the accounting year. The minimum bonus is 8.33% of wages or ₹100, whichever is higher, and the maximum is 20%.

The calculation ceiling

Bonus is not worked out on the full wage. Under notifications issued on 25 August 2026 (effective 21 November 2025), where an eligible employee's wages are more than ₹7,000 a month, bonus is calculated as if the wage were ₹7,000 or the minimum wage, whichever is higher. Since minimum wages are now above ₹7,000 almost everywhere, the minimum wage for the employee's category usually sets the ceiling. Practice differs on whether the State or Central minimum wage applies, so the template lets you enter the rate you use for each category.

What counts as wages

Under the Code, wages mean basic pay, dearness allowance and retaining allowance. Allowances such as HRA, conveyance and overtime are excluded – but if the excluded items are more than 50% of total remuneration, the excess is added back. The register applies this 50% rule automatically from basic + DA and other allowances, and uses the result both for the ₹21,000 eligibility test and for the bonus.

Allocable surplus, set-on and set-off

Whether you pay more than 8.33% depends on profits. The allocable surplus is 60% of the available surplus (67% for a company that hasn't arranged to pay dividends in India). If it is more than the minimum bonus, the rate rises up to 20%; any excess above 20% is carried forward as set-on, and if the minimum bonus is more than the surplus, the shortfall is carried forward as set-off – each for up to four years. The Pro edition works this out from your profit figures.

Deductions and the deadline

Interim bonus or customary festival bonus paid during the year can be deducted from the statutory bonus, as can amounts for financial loss caused by the employee's misconduct. Employees dismissed for fraud, violent behaviour, theft, misappropriation, sabotage or sexual harassment are disqualified. Bonus must be paid within eight months of the end of the accounting year – by 30 November 2026 for 2025-26.

Written by Prakash Bagchi, finance professional and founder of PB Lab. Last reviewed .

Frequently asked questions

Who is eligible for statutory bonus in 2026?

Employees whose wages are up to ₹21,000 a month and who worked at least 30 days in the accounting year, in establishments with 20 or more persons, under the Code on Wages, 2019.

How is bonus calculated?

On wages of ₹7,000 a month or the minimum wage, whichever is higher, if actual wages exceed ₹7,000 – at 8.33% to 20% depending on allocable surplus, with a minimum of ₹100.

What is the last date to pay bonus for 2025-26?

Within eight months of the end of the accounting year – 30 November 2026 for an April 2025 to March 2026 year.

Can Diwali advance be adjusted against bonus?

Yes. Interim bonus or customary festival bonus paid during the year can be deducted from the statutory bonus payable. Enter it in the advance column.

Do employees who left during the year get bonus?

Yes, if they worked at least 30 days and are not disqualified. Bonus is on the wages they earned in the year; the register handles part-year employees.

Is bonus payable in a new business?

In the first five accounting years, bonus is payable only for a year in which the employer makes a profit; set-on and set-off apply from the sixth and seventh years with modifications.

What wages are used – gross or basic?

Wages under the Code: basic + DA + retaining allowance, plus any excess of other allowances over 50% of total pay. The register applies the 50% rule for you.

How much does the Pro edition cost and how do I get it?

The Pro edition is ₹19 (regular price ₹99), a one-time payment through Razorpay by UPI, card, netbanking or wallet. You download the .xlsx file right after paying, and the download page works again later if you bookmark it. Pro adds: Allocable Surplus, Bonus Slip.

Related free calculators

More Excel templates

See all templates →

Disclaimer: This template is a working aid, not legal, tax or accounting advice. Sample data is fictional. Laws, rates and thresholds change — verify them against the current Act, rules and notifications, or with a qualified professional, before relying on the results. PB Lab is not responsible for decisions made using this file.