Bonus Pool Allocation Calculator

Pool fit

{{ balanceLabel }} {{ totals.eligibleCount }} eligible {{ formatMoney(totals.averageBonus) }} average Top: {{ topAllocationRow.label }} {{ formatMoney(totals.floorTotal) }} floors {{ formatMoney(totals.capTotal) }} cap limit

{{ err }}

Total bonus pool:

Enter the gross pool to allocate before payroll deductions or tax withholding.

Allocation method:

Participants:

Use anonymous labels if needed; service is percent proration, and floor/cap values are optional per row.

Participant	Eligible	Base salary	{{ weightLabel }}	Rating	Service	Floor	Cap	Remove
		{{ currency_symbol }}			%	{{ currency_symbol }}	{{ currency_symbol }}

Rounding mode:

Use cents for payroll precision, or larger increments for planning estimates.

Rounding residual:

Leave residual visible for review, or assign it to the largest flexible eligible row.

Redistribute caps/floors:

Turn off when cap or floor leftovers should stay as visible unallocated balance.

Currency symbol:

Use one symbol or short code, such as $, RM, EUR, or GBP.

Participant	Effective weight	Initial	Final bonus	Pool share	Status	Copy
{{ row.label }}	{{ formatNumber(row.effectiveWeight, 3) }}	{{ formatMoney(row.initialAllocation) }}	{{ formatMoney(row.finalAllocation) }}	{{ formatPercent(row.sharePercent) }}	{{ row.statusLabel }}
Total	{{ formatNumber(totals.totalWeight, 3) }}	{{ formatMoney(totals.initialTotal) }}	{{ formatMoney(totals.allocated) }}	{{ formatPercent(totals.allocatedShare) }}	{{ balanceLabel }}

Participant	Initial	Final bonus	Change	Floor	Cap	Status	Copy
{{ row.participant }}	{{ formatMoney(row.initialAllocation) }}	{{ formatMoney(row.finalAllocation) }}	{{ formatSignedMoney(row.delta) }}	{{ row.floorLabel }}	{{ row.capLabel }}	{{ row.statusLabel }}

Ledger item	Value	Note	Copy
{{ item.label }}	{{ item.value }}	{{ item.note }}

Flag	Detail	Copy
Review flag	{{ note }}
No active review flags No cap, floor, eligibility, or residual warnings are active for this scenario.

Add at least one positive eligible award to render the bonus mix chart.

Add at least one positive eligible award to render the constraint impact chart.

Embed:

Customize

Include current inputs

Size

Advanced

Width

Height

Aspect ratio

Max height

Collapsible embed

Allow fullscreen

Referrer policy

Sandbox tokens

A bonus pool turns one approved budget into several individual awards. The budget may come from company performance, a department target, a project fund, or a leadership decision, but the planning problem is the same: every eligible award has to be explainable, and the final total has to reconcile to the pool.

Simple equal splits work only when participants have the same target opportunity and the same service period. Many plans need a weighted split instead. Weight can stand for job level, target bonus opportunity, salary, committee points, or another plan signal. A rating multiplier can raise or lower that signal, while service proration reduces the share for partial-year participation.

Caps and floors make the arithmetic more realistic and harder to audit. A floor can push a row above its first proportional share. A cap can release money that should either be redistributed or left visible for review. Rounding can create small residual balances even when the proportional math was correct before payroll-ready amounts were produced.

A reconciled bonus pool needs both row-level award logic and a pool-level balance check.

Bonus allocation planning signals
Planning signal	What it represents	Common mistake
Eligibility	Who may receive money from the pool.	Deleting ineligible rows instead of leaving visible zero-award evidence.
Weight or points	Relative share within the current pool.	Treating weights as currency amounts rather than proportions.
Rating	Performance multiplier applied before the split.	Letting rating amplify a salary or weight basis without review.
Service proration	Partial-year participation or plan-specific service credit.	Using a rough percentage that does not match the plan document.
Floor and cap	Minimum and maximum award boundaries.	Forgetting that limits can leave money unused or overallocate the pool.

Reconciliation protects against a common spreadsheet failure. Individual awards can look fair row by row while the total is still short, over the approved pool, or dependent on one row absorbing the residual. A good review shows the first proportional split, every cap or floor change, the rounding movement, and the final balance.

Allocation math is only the planning part. Bonus plan documents, approval rules, employment agreements, payroll withholding, overtime treatment, and local law can all affect the final payment. The allocation should make the proposed awards easier to review, not replace HR, payroll, tax, or legal checks.

How to Use This Tool:

Use the calculator as a planning worksheet: define the pool, set the participant rules, then check the balance before copying award values.

Enter Total bonus pool. Use the range slider for rough scenarios, then type the exact gross pool before review.
Choose Allocation method. Equal split gives each eligible row one unit, Weight-based and Custom points use the row weight field, Rating-weighted starts from one unit, and Salary-weighted uses base salary.
Fill Participants. Use anonymous labels for sensitive drafts, mark Eligible, and enter Base salary, Weight, Rating, and Service values needed by the selected method.
Add Floor and Cap only when a row has a minimum or maximum award. If a cap is below its floor, results stay hidden until that row is corrected.
Set Rounding mode. Use nearest cent for payroll-style precision, nearest dollar or larger increments for planning packets, or no rounding when you want to see raw allocations.
Choose Rounding residual. Leave the balance visible for review, or assign it to the largest flexible eligible row when that row can absorb the difference without crossing a cap or floor.
Use Redistribute caps/floors when limit changes should be spread across remaining flexible rows. Turn it off when cap and floor effects should remain visible as unallocated or overallocated balance.
Review Pool fit, Allocation Table, Constraint Impact Table, Pool Balance Ledger, and Pool Review Flags. If an error list appears, fix the named issue before treating the awards as ready.

Interpreting Results:

Final bonus is the award after eligibility, effective weight, floors, caps, rounding, and residual policy. Initial allocation is the proportional amount before limits and rounding. The difference between those values explains how much the plan rules changed each row.

Pool balanced means the final allocated total is within half a cent of the input pool. An unallocated balance leaves money unused. An overallocated balance means the listed awards exceed the approved pool and should not move forward until the pool, floors, caps, eligibility, or residual policy is corrected.

Status labels point to the reason a row changed. Capped, Floor applied, and Residual adjusted explain constrained rows; Ineligible and Zero weight explain zero-award rows. Do not rely on the charts alone. Read Pool Balance Ledger and Pool Review Flags before copying awards, because those checks expose hidden leftover, overage, and rebalancing issues.

A clean-looking split can still be misleading if the wrong method is selected. Confirm the plan basis first, then compare Weight share, Final bonus, and Status so a large salary, rating, cap, or service percentage does not dominate the pool by accident.

Technical Details:

A bonus pool allocation is a constrained proportional distribution. Each eligible row receives an effective weight, the pool is divided by each row's share of total effective weight, and the first award is then tested against floor and cap limits. Rounding happens after those constraints, because rounding should not decide the proportional share.

The selected method controls the basis value before rating and service proration. Equal split and rating-weighted methods start with one unit per eligible row. Salary-weighted uses the salary value. Weight-based and custom points use the weight field. Ineligible rows keep a visible row but receive zero effective weight and zero final allocation.

Formula Core:

The effective weight for row i combines allocation basis, rating multiplier, and service percentage:

e_{i} = b_{i} \times r_{i} \times \frac{s_{i}}{100}

The initial allocation is the gross pool multiplied by that row's share of all eligible effective weight:

a_{i} = P \times \frac{e_{i}}{\sum_{j = 1}^{n} e_{j}}

When rounding is selected, each final row is rounded to the selected step q after cap and floor handling:

rounded (x) = round (\frac{x}{q}) \times q

Bonus allocation formula variables
Symbol	Meaning	Source or unit
`P`	Approved gross bonus pool.	Total bonus pool.
`b`	Allocation basis.	1 for equal or rating-weighted, salary for salary-weighted, weight or points for weight-based methods.
`r`	Rating multiplier.	Rating; 1.00 means no rating change.
`s`	Service proration.	Service percent; 100 means full service.
`e`	Effective weight.	Basis after rating and service; zero for ineligible rows.
`a`	Initial allocation.	Proportional award before floors, caps, and rounding.
`q`	Rounding step.	0.01, 1, 10, 100, or no rounding step.

Bonus pool constraints and status labels
Rule	Boundary used	Visible cue
Eligibility	Rows not marked eligible receive zero final allocation.	Ineligible
Positive basis	Eligible rows need effective weight above zero to share the pool.	Zero weight or validation error
Floor	A positive minimum raises a lower final award to that floor.	Floor applied
Cap	A positive maximum lowers a higher final award to that cap.	Capped
Residual assignment	The remaining rounded balance is assigned only to the largest eligible row that can absorb it without crossing floor or cap limits.	Residual adjusted
Pool balance	Absolute balance below 0.005 is treated as balanced.	Pool balanced

With a $60,000 pool and effective weights of 3, 2, and 1, the initial awards are $30,000, $20,000, and $10,000. If the first row has a $25,000 cap and redistribution is on, $5,000 is released. The remaining $35,000 is split across the two flexible rows in their 2-to-1 weight ratio, producing about $23,333 and $11,667 before any larger rounding step changes the balance.

Validation blocks results for a negative pool, no participant rows, no eligible rows, no positive effective weight among eligible rows, or any row where the cap is below the floor. Those checks prevent an impossible allocation from rendering as a polished table.

Responsible Use Note:

Treat results as planning output. In the United States, nondiscretionary bonuses may affect regular-rate and overtime calculations for non-exempt employees, and bonus payments are generally treated as wages for employment tax and withholding purposes. Confirm final awards against the plan document, payroll rules, tax treatment, employment agreements, and local legal requirements before payment.

Worked Examples:

Weighted department pool

A $60,000 pool split across three eligible rows with weights of 3, 2, and 1 gives Final bonus values near $30,000, $20,000, and $10,000 when there are no caps or floors. Pool balanced should appear because the allocated total reconciles to the gross pool.

Cap with redistribution

Using the same $60,000 pool, a $25,000 cap on the highest-weight row lowers that row from $30,000 to $25,000. With Redistribute caps/floors on, Constraint Impact Table shows the capped row down $5,000 and the flexible rows receiving the released money.

Floors exceed the pool

A $100,000 pool with eligible floors of $50,000, $35,000, and $20,000 has $105,000 of minimum awards before proportional allocation. Pool Review Flags reports that eligible minimum bonuses exceed the pool, and the balance cue stays overallocated until floors are lowered, eligibility changes, or the pool increases.

Blocking row error

If one participant has a $10,000 floor and an $8,000 cap, results stay hidden and the error message identifies that row. Raise the cap, lower the floor, or remove the limit, then re-check Pool fit and Pool Balance Ledger.

FAQ:

Which allocation method should I start with?

Use Equal split for one same-size award per eligible person, Weight-based for target or job-level weights, Rating-weighted when performance multiplier should drive the split, Salary-weighted when salary is the basis, and Custom points when another worksheet already produced point values.

Why did the results disappear?

Results stay hidden until the blocking error is fixed. Checks cover a negative pool, no participant rows, no eligible rows, no positive effective weight among eligible rows, and any participant whose cap is below that participant's floor.

Does the currency symbol convert amounts?

No. Currency symbol changes display text for the pool, awards, caps, floors, tables, and copied output. It does not apply exchange rates or change allocation math.

Should I enter employee names?

The worksheet does not require real names. Use anonymous labels for sensitive drafts, and avoid sharing URLs that contain edited participant rows because row labels and amounts can be preserved in the scenario link.

Glossary:

Bonus pool: The gross amount approved for allocation before withholding, deductions, or payroll posting.
Effective weight: The row's allocation basis after rating multiplier and service proration are applied.
Service proration: A percentage adjustment for partial participation, such as part-year service or plan-specific eligibility periods.
Floor: A minimum award for an eligible participant row.
Cap: A maximum award for an eligible participant row.
Residual: The small balance left after constraints and rounding are applied.
Pool Balance Ledger: The reconciliation table that traces the input pool to the final allocated total.

References:

Fact Sheet #56C: Bonuses under the Fair Labor Standards Act, U.S. Department of Labor, December 2019.
Publication 15 (2026), Employer's Tax Guide, Internal Revenue Service, 2026.