Bonus Pool Allocation Calculator
Allocate a bonus pool by eligibility and weighted policy, then reconcile floors and caps plus payroll rounding against the final balance.Allocation flow visual unavailable.
| Participant | Eligibility | Effective weight | Initial | Final award | Share | Status | Copy |
|---|---|---|---|---|---|---|---|
| {{ row.label }} | {{ row.eligible ? 'Eligible' : 'Ineligible' }} | {{ formatNumber(row.effectiveWeight, 3) }} | {{ formatMoney(row.initialAmount) }} | {{ formatMoney(row.finalAmount) }} | {{ formatPercent(row.sharePercent) }} | {{ statusPresentation(row.status).label }} |
| Participant | Floor | Cap | Adjustment | Review note | Copy |
|---|---|---|---|---|---|
| {{ row.label }} | {{ row.floorAmount > 0 ? formatMoney(row.floorAmount) : 'None' }} | {{ row.capAmount > 0 ? formatMoney(row.capAmount) : 'None' }} | {{ formatSignedMoney(row.adjustment) }} | {{ row.note }} |
A bonus pool is both a budget and a policy. The arithmetic decides how much each eligible person receives, but the policy decides which facts may influence that arithmetic: equal participation, salary, target weight, performance rating, service period, floors, or caps.
A defensible allocation starts with an approved gross pool and a written basis. Equal split gives each eligible person the same starting basis. Salary weighting ties the starting share to salary. Weight or point methods let a plan assign explicit relative values. Rating and service percentage then adjust that basis before any money is divided.
Constraints create the difficult part. A minimum award can consume more than a participant's proportional share; a cap can release money that was initially assigned. Redistributing those differences preserves the pool when enough flexible rows remain. Applying each floor or cap independently preserves the first proportional allocation instead, which can leave money unallocated or push the total above the pool.
Rounding creates a second reconciliation problem. Three equal awards from a 1,000-unit pool cannot all be whole units. Two may become 333 and one 334, or the one-unit residual can remain visible. Neither choice is neutral: assigning a residual changes one award, while leaving it requires a later payroll or governance decision.
| Decision | Evidence to preserve | Common failure |
|---|---|---|
| Eligibility | Plan rule and eligible service period. | Including a person who is outside the approved plan population. |
| Weighting | Named basis, rating scale, and proration rule. | Mixing unlike ratings or undocumented manager adjustments. |
| Constraints | Approved floors, caps, and redistribution policy. | Assuming the total still balances after clamping rows. |
| Rounding | Payroll increment and residual owner. | Hiding a leftover or overallocated balance. |
Allocation arithmetic does not decide whether a bonus rule is lawful, equitable, contractual, affordable after employer costs, or appropriate for a jurisdiction. Those questions belong in the approved compensation plan and payroll review.
How to Use This Tool:
Model the gross award policy, reconcile the pool, and only then hand amounts to payroll.
- Enter the approved Total bonus pool and select an Allocation method. The currency symbol labels amounts only; it does not convert currencies.
- Add 1–12 participant rows and mark Eligible only where the plan permits. Enter the basis needed by the selected method, plus rating and service percentage.
- Enter a Floor or Cap only when the plan authorizes it. Zero means no limit, and a floor cannot exceed a nonzero cap.
- Choose whether to Redistribute constraints. Keep it on to reallocate money released or consumed by constrained rows; turn it off to clamp each initial award independently.
- Select Award rounding and the Rounding residual policy. Review the final balance after both choices have been applied.
- Use the award and constraint ledgers to confirm eligibility, effective weights, adjustments, final awards, and review warnings before payroll approval.
Interpreting Results:
Initial award is the unconstrained proportional split. Final award includes floors, caps, rounding, and any assigned residual. The difference between them identifies the rows whose policy or payroll settings changed the first allocation.
- Balance equals the pool minus final allocated total. Zero is balanced; a positive value is unallocated; a negative value is overallocated.
- Share is each final award as a percentage of the final allocated total, not necessarily the original pool. When a balance remains, shares can still total 100% of what was allocated.
- Constraint pressure means at least one floor or cap changed an award. Check whether enough flexible rows remained to absorb the difference.
- Residual assigned identifies a row changed solely to reconcile post-rounding balance. Preserve that policy decision with the payroll record.
Technical Details:
Money is normalized to integer cents before allocation. Participant labels do not affect the proportional result except as the final deterministic tie-breaker when a residual must be assigned.
Formula Core
For eligible participant i, the selected method supplies a basis b. Equal and rating-weighted methods use 1; salary-weighted uses salary; weight-based and custom-points methods use the entered weight or points. Rating and service then form the effective weight.
Ineligible rows receive an effective weight and award of zero. Each positive effective weight receives its fraction of the pool.
After constraints and rounding, reconciliation is explicit:
Mechanism Core
| Stage | Exact behavior |
|---|---|
| 1. Weight | Compute basis × rating × service/100 for each eligible row; the total must be greater than zero. |
| 2. Proportion | Allocate the whole pool across positive effective weights. |
| 3. Constraints on | Lock any row below its floor or above its cap, then redistribute the remaining pool across unlocked rows by effective weight. Repeat until no new row locks. |
| 3. Constraints off | Clamp each initial row independently to its floor or cap. Do not redistribute the resulting difference. |
| 4. Round | Round each final row to the nearest cent, whole unit, 10 units, or 100 units. “No added rounding” retains cent precision. |
| 5. Residual | Leave the balance visible, or add the entire residual to the largest flexible eligible award if doing so respects its floor and cap. |
Residual candidates are ordered by current final award, then effective weight, then label. This produces a repeatable result when several rows are otherwise equally eligible for the adjustment.
Validation and Review Rules
| Item | Supported boundary or warning |
|---|---|
| Pool and row money | 0–100,000,000, inclusive; negative values are rejected. |
| Rating | 0–10, inclusive. |
| Service | 0%–200%, inclusive. |
| Weight or points | 0–100,000, inclusive. |
| Participant rows | 1–12; at least one row must be eligible and total effective weight must be positive. |
| Review codes | Unallocated balance, overallocated balance, constraint pressure, ineligible rows, residual assigned, and constraints not redistributed are reported independently. |
Responsible Use Note:
Use the output as a gross allocation worksheet, not a payroll calculation or legal determination. It does not calculate withholding, employer taxes, statutory overtime effects, benefits, exchange rates, or jurisdiction-specific compensation rules.
- Apply only approved eligibility, rating, proration, floor, and cap rules. Preserve the source policy and reviewer approval with the final ledger.
- Review protected-class impact and consistency before communicating awards. A mathematically consistent rule can still produce an unfair or unlawful outcome.
- In the United States, bonuses may affect regular-rate and overtime calculations, and bonus payments are generally treated as wages or supplemental wages for tax purposes. Other jurisdictions differ.
- Have payroll, finance, HR, and legal owners review the gross awards before payment.
Worked Examples:
A floor and cap leave part of the pool
Two equal eligible rows split a 1,000-unit pool at 500 each. A 600 floor locks the first row and a 300 cap locks the second. Even with constraint redistribution enabled, no flexible row remains, so final awards total 900 and the 100-unit balance stays visible.
Three whole-unit awards need a residual owner
Three equal rows initially receive 333.33 each from a 1,000-unit pool. Whole-unit rounding produces 333, 333, and 333, leaving 1. With “Assign to largest flexible award,” the deterministic first candidate receives the residual, giving 334, 333, and 333 with a zero balance.
References:
- Fact Sheet #56C: Bonuses under the Fair Labor Standards Act, U.S. Department of Labor.
- Publication 15 (2026), Employer's Tax Guide, Internal Revenue Service, 2026.