The merit pool, spent and unspent

Six hundred thousand was approved. 577,080.00 went out. 22,920.00 never left. The budget report shows each department’s pool, spend, and remainder on one line, so the cycle closes with arithmetic instead of an argument.

RuleClose every cycle with pool minus spend equals remainder, by department. An unspent pool is a decision waiting to be made, not a rounding error.

Neverlet managers award against a pool nobody reconciles. The overspend always surfaces, one budget season too late.

◆ Pool, spend, remainderone line per department, closed to the cent.

Department	Approved pool	Spend	Remaining	Used %
Sales	260,000.00	249,600.00	10,400.00	96.0
Technology Delivery	210,000.00	201,600.00	8,400.00	96.0
Support	130,000.00	125,880.00	4,120.00	96.8
All departments	600,000.00	577,080.00	22,920.00	96.2

Every row closes: pool minus spend equals remaining, and the spend column is the same 577,080.00 annual cost the cycle report states. The 22,920.00 left over is now a named decision: return it, roll it, or fund the off-cycle cases. Sample values are illustrative, never client data.

◆ Why the remainder mattersunspent money is unanswered questions.

A pool underspent by four percent usually means a handful of awards were planned and never entered, or a department held reserve for a case that resolved late. Both are worth a name. The remainder is where next quarter’s off-cycle adjustments quietly come from, and a report that shows it keeps that spend visible instead of folkloric.

◆ The owned answerbudget beside events, reconciled by query.

The pool is a small reference table; the spend is the sum of merit events per department. The reconciliation is one join, rerun whenever an event backdates into the cycle.

-- pool vs spend vs remainder, by department
SELECT b.dept, b.pool,
       COALESCE(SUM(e.new_base - e.old_base), 0)           AS spend,
       b.pool - COALESCE(SUM(e.new_base - e.old_base), 0)  AS remaining
FROM ref_merit_budget b
LEFT JOIN fct_comp_event e
  ON e.dept = b.dept AND e.reason = 'Merit'
 AND e.effective_date = '2026-05-01'
GROUP BY 1, 2

Use case

Problem

Merit pools are approved in a deck, spent in a tool, and reconciled never; unspent money vanishes and overspends surface at year end.

What we build

A budget reference table reconciled by query against merit events per department: pool, spend, remainder, and utilization on one line each.

What you get

A cycle that closes like a ledger: every department’s pool accounted for to the cent, and the remainder turned into a named decision.

Where did the unspent merit money go?

We build the pool-to-spend reconciliation that closes every cycle to the cent.

Talk to us

Terms on this page

merit pool: The approved budget for cycle increases, per department.
spend: The summed annual value of awarded increases.
remainder: Pool minus spend; a decision, not dust.
utilization: Spend over pool, quoted after the money is summed.
off-cycle adjustment: An increase outside the cycle, often funded by remainders.