{{ summaryTitle }} {{ summaryValue }} {{ summaryLine }} {{ badge.label }} {{ badge.value }}

Allocation flow visual unavailable.

Bonus pool allocation workflow
Bonus pool policy and participant inputs
Enter the approved pool, then use the slider for quick scenario comparisons.
{{ formatMoney(poolAmountNumber) }}
{{ safeCurrencySymbol }}
Choose the starting basis; rating and service adjustments still apply.
Service is a percentage of a full period. A floor or cap of zero means no limit.
Participant Eligible Salary {{ weightHeading }} Rating Service Floor Cap Remove
{{ safeCurrencySymbol }}
%
{{ safeCurrencySymbol }}
{{ safeCurrencySymbol }}
Choose payroll precision or a larger planning increment.
The balance always remains visible in the summary and review ledger.
Turn off to preserve each initial proportional award before independently clamping rows.
{{ rebalanceConstraintsEnabled ? 'On' : 'Off' }}
{{ workflowFeedback }}
Use a symbol or short code such as $, RM, EUR, or GBP.
{{ tableExportAnnouncement }}
ParticipantEligibilityEffective weightInitialFinal awardShareStatusCopy
{{ row.label }}{{ row.eligible ? 'Eligible' : 'Ineligible' }}{{ formatNumber(row.effectiveWeight, 3) }}{{ formatMoney(row.initialAmount) }}{{ formatMoney(row.finalAmount) }}{{ formatPercent(row.sharePercent) }}{{ statusPresentation(row.status).label }}
{{ tableExportAnnouncement }}
ParticipantFloorCapAdjustmentReview noteCopy
{{ row.label }}{{ row.floorAmount > 0 ? formatMoney(row.floorAmount) : 'None' }}{{ row.capAmount > 0 ? formatMoney(row.capAmount) : 'None' }}{{ formatSignedMoney(row.adjustment) }}{{ row.note }}
{{ chartExportAnnouncement }}

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.

Evidence needed before allocating a bonus pool
DecisionEvidence to preserveCommon failure
EligibilityPlan rule and eligible service period.Including a person who is outside the approved plan population.
WeightingNamed basis, rating scale, and proration rule.Mixing unlike ratings or undocumented manager adjustments.
ConstraintsApproved floors, caps, and redistribution policy.Assuming the total still balances after clamping rows.
RoundingPayroll 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.

  1. Enter the approved Total bonus pool and select an Allocation method. The currency symbol labels amounts only; it does not convert currencies.
  2. 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.
  3. Enter a Floor or Cap only when the plan authorizes it. Zero means no limit, and a floor cannot exceed a nonzero cap.
  4. 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.
  5. Select Award rounding and the Rounding residual policy. Review the final balance after both choices have been applied.
  6. 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.

ei=bi×ratingi×servicei100

Ineligible rows receive an effective weight and award of zero. Each positive effective weight receives its fraction of the pool.

Ai,0=Pool×eijnej

After constraints and rounding, reconciliation is explicit:

Balance=PooliAi,final

Mechanism Core

Ordered allocation mechanism
StageExact behavior
1. WeightCompute basis × rating × service/100 for each eligible row; the total must be greater than zero.
2. ProportionAllocate the whole pool across positive effective weights.
3. Constraints onLock 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 offClamp each initial row independently to its floor or cap. Do not redistribute the resulting difference.
4. RoundRound each final row to the nearest cent, whole unit, 10 units, or 100 units. “No added rounding” retains cent precision.
5. ResidualLeave 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

Input and review boundaries
ItemSupported boundary or warning
Pool and row money0–100,000,000, inclusive; negative values are rejected.
Rating0–10, inclusive.
Service0%–200%, inclusive.
Weight or points0–100,000, inclusive.
Participant rows1–12; at least one row must be eligible and total effective weight must be positive.
Review codesUnallocated 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: