Bonus & Incentive Calculation Template Free Excel for Indian Businesses

Q: Is bonus mandatory even if the business made a loss?

Yes. Section 10 mandates minimum bonus of 8.33% regardless of profit or loss. The profit-linked mechanism (set-on/set-off under Sections 15-16) only determines whether bonus goes above 8.33%, up to 20% maximum.

Q: When must bonus be paid?

Within 8 months of the accounting year's close per Section 19. For April-March FY, the deadline is 30-Nov. Non-payment attracts imprisonment up to 6 months or fine under Section 28.

Calculate statutory bonus under the Payment of Bonus Act, 1965. Checks eligibility, applies the Rs.7,000 calculation ceiling, handles pro-rata for part-year employees. Plus an incentive tracker for performance bonuses. Updated June 2026.

Auto-calculates bonus from 8.33% (minimum) to 20% (maximum) with pro-rata adjustment
Checks the Rs.21,000 eligibility ceiling and Rs.7,000 calculation ceiling automatically
Team view for 25 employees plus a separate incentive tracker for performance bonuses

No spam. Instant download link to your email.

Petpooja presents

Bonus & Incentive Calculation Template

For Indian Businesses

Sheets · Excel template

FY 2025-26

What's Inside

Everything you need for accurate bonus calculation.

Statutory Bonus Calculator

Enter salary, days worked, and bonus percentage. The sheet checks eligibility, applies the calculation ceiling, computes pro-rata bonus, and shows the final amount with a min/max comparison.

Team View (25 Employees)

Calculate bonus for up to 25 employees at once. Set one bonus % for the whole team, see who's eligible and who isn't, and get total bonus liability in one view.

Incentive Tracker

Track non-statutory incentives: sales commissions, attendance bonuses, festival bonuses, quarterly targets. Separate from statutory bonus so you know exactly what's mandatory vs. voluntary.

Quick Reference Guide

All the rules in one sheet: eligibility and applicability criteria, bonus rates and ceilings, payment timelines, penalties, the 2015 amendment changes, and set-on/set-off provisions.

Worked Example

A complete calculation for a Rs.18,000/month employee who worked 320 days. Every step shown, plus "what if" scenarios at 8.33%, 12%, and 20%. Also covers why a Rs.22,000 employee isn't eligible.

Instructions + Legal References

Step-by-step guide with the bonus formula, key terms, and every relevant section of the Payment of Bonus Act cited. No ambiguity about which rule applies where.

Why This Matters

The Bonus Calculation Most Indian Employers Get Wrong

Every year around Diwali, the same question comes up: "How much bonus do we have to pay?" The answer isn't just "one month's salary." It's more specific than that, and most employers get it wrong.

The Payment of Bonus Act, 1965 applies to every factory and every establishment with 20 or more employees. That covers most restaurants, retail stores, clinics, and offices across India. The minimum is 8.33% of salary, the maximum is 20%. Our labour law compliance checklist covers this alongside PF, ESI, and other requirements.

Here's where it gets tricky. The Act has two separate ceilings that confuse everyone. First, there's the eligibility ceiling of Rs.21,000/month: employees earning more than this (Basic + DA) aren't covered under the Act at all. Then there's the calculation ceiling of Rs.7,000/month: even if an employee earns Rs.18,000, the bonus is calculated on Rs.7,000 (or the minimum wage, whichever is higher).

So an employee earning Rs.18,000/month doesn't get 8.33% of Rs.18,000. They get 8.33% of Rs.7,000 (the calculation ceiling). That's Rs.6,997/year for a full year, not Rs.18,000. Miss this distinction, and you'll overpay by over 2.5x. Understanding the salary structure breakdown helps get this right.

This template handles both ceilings, computes pro-rata bonus for employees who joined mid-year, and lets you compare the cost at different bonus percentages. If you're also calculating the full CTC breakup for your team, that template pairs well with this one.

Sample Preview

What the template shows for an Rs.18,000/month employee.

Here's a preview of what you'll get inside:

Eligibility: Rs.18,000 salary is below the Rs.21,000 ceiling, and 320 days worked exceeds the 30-day minimum. Employee is eligible.

Calculation salary: MIN(Rs.18,000, Rs.7,000) = Rs.7,000/month. Bonus is always calculated on the lower of actual salary or the ceiling.

Annual bonus base: Rs.7,000 x 12 = Rs.84,000. Then Rs.84,000 x 8.33% = Rs.6,997 gross bonus.

Pro-rata: Rs.6,997 x (320/365) = Rs.6,134. Adjusted for actual days worked in the bonus year.

What-if at 20%: Rs.84,000 x 20% x (320/365) = Rs.14,729. Shows the cost difference between min and max bonus.

... plus team view for 25 employees, incentive tracker, quick reference with all legal citations, and a worked example.

Key Stats

Why bonus compliance matters.

8.33%

Minimum statutory bonus every covered employer must pay, regardless of whether the business made a profit that year. This equals roughly one month's salary calculated on the bonus wage ceiling.

Source: Payment of Bonus Act, 1965, Section 10

₹21,000

Monthly salary ceiling for bonus eligibility. Employees earning more than Rs.21,000/month (Basic + DA) are not covered under the Act. This was raised from Rs.10,000 by the 2015 amendment.

Source: Payment of Bonus Act, Section 8 (amended 2015)

8 months

Deadline for bonus payment after the close of the accounting year. For businesses with an April-March financial year, bonus must be paid by 30-Nov. Delay attracts penalties under Section 28.

Source: Payment of Bonus Act, 1965, Section 19

Common Mistakes

6 Bonus Mistakes Indian Employers Make

Calculating bonus on actual salary instead of the ceiling

The biggest mistake. Section 12 says bonus is calculated on Rs.7,000/month (or minimum wage, whichever is higher), NOT the employee's actual salary. An employee earning Rs.18,000 gets bonus calculated on Rs.7,000. Check our salary structure as per labour law guide for more on how these ceilings work.

Confusing the two ceilings

Rs.21,000 is the eligibility ceiling (who gets bonus). Rs.7,000 is the calculation ceiling (how much bonus). These are different numbers serving different purposes. Mixing them up is extremely common.

Skipping bonus because the business made a loss

Section 10 requires minimum bonus of 8.33% regardless of profit or loss. The allocable surplus mechanism (Sections 15-16) adjusts the bonus percentage between 8.33% and 20% based on profits, but the minimum is always payable.

Not pro-rating for employees who joined mid-year

An employee who joined in October and worked 180 of 365 days gets bonus proportional to those 180 days, not a full year's bonus. The template handles this automatically.

Including non-eligible salary components

"Salary" under Section 2(13) means Basic pay plus Dearness Allowance only. HRA, overtime, commissions, and other allowances don't count for either the eligibility check or the calculation.

Paying bonus after the 8-month deadline

Section 19 requires payment within 8 months of the accounting year's close. For a March year-end, that's 30-Nov. Section 28 prescribes imprisonment up to 6 months or fine for non-compliance.

Comparison

Bonus: Manual Calculation vs This Template.

Aspect	Manual Calculation	With This Template
Eligibility check	Manual salary comparison	Auto-checks Rs.21,000 ceiling + 30-day rule
Calculation ceiling	Often missed or applied incorrectly	Auto-applies Rs.7,000 or min wage
Pro-rata for part-year	Calculated individually	Auto-adjusts for actual days worked
Min/Max comparison	Separate calculation needed	Shows 8.33% vs 20% side by side
Bulk processing	One employee at a time	25 employees in Team View
Incentive tracking	Separate spreadsheet	Built-in tracker with categories
Total liability	Manual sum	Auto-summed with eligible/ineligible count

Stop overpaying or underpaying bonus.

Download the free Bonus & Incentive Calculation Template and get the exact number for every employee.

FAQ

Frequently asked questions.

How is statutory bonus calculated in India?

Statutory bonus is calculated on the lower of actual salary or Rs.7,000/month (or minimum wage, whichever is higher). The formula: Annual Calculation Salary x Bonus % x (Days Worked / Total Days). Minimum bonus is 8.33% of salary per Section 10 of the Payment of Bonus Act, 1965. Maximum is 20% per Section 11. "Salary" means Basic pay plus Dearness Allowance only. Use our free salary calculator to check the Basic + DA split.

Which employees are eligible for bonus?

Employees earning up to Rs.21,000/month (Basic + DA) who have worked at least 30 days in the accounting year are eligible under Section 8. The Act applies to every factory and every establishment with 20 or more employees. Employees can be disqualified under Section 9 for fraud, riotous/violent behaviour, theft, misappropriation, or sabotage. Bonus is part of the broader payroll compliance picture.

What is the difference between the Rs.21,000 and Rs.7,000 ceilings?

Rs.21,000/month is the eligibility ceiling (Section 8): employees earning more than this aren't covered. Rs.7,000/month is the calculation ceiling (Section 12): bonus is calculated on this amount or your state's minimum wage, whichever is higher. In most states, minimum wages now exceed Rs.7,000, so check our Minimum Wages Reference Chart for your state's current rate.

Is bonus mandatory even if the business made a loss?

Yes. Section 10 mandates a minimum bonus of 8.33% (or Rs.100, whichever is higher) regardless of profit or loss. The profit-linked component (Sections 15-16 on set-on and set-off) only determines whether the bonus percentage goes above 8.33%, up to the 20% maximum. The minimum is always payable from year one. Track how bonus affects your bottom line with our free CTC calculator.

When must bonus be paid?

Within 8 months of the close of the accounting year, per Section 19. For businesses following an April-March financial year, the deadline is 30-Nov of the same calendar year. Non-payment attracts penalties under Section 28: imprisonment up to 6 months, or fine up to Rs.1,000, or both. When employees exit before bonus payment, include it in the Full & Final Settlement.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.

Automate bonus calculation for your entire team

Petpooja Payroll auto-calculates statutory bonus for every eligible employee, tracks incentives, and processes payments on time. It also handles production incentives and quality bonuses for manufacturing teams.

Book a Free Demo Call: +91-72280 34343