# Bonus Accrual Plan bonuses by department, spread the cost across the year, and see the liability and cash payout in one clear view. - Canonical: https://finamodel.com/templates/bonus-accrual - Excel download: https://finamodel.com/templates/bonus-accrual.xlsx - Category: Corporate Finance - Model type: Operating model - Difficulty: Beginner - Audiences: CFOs & FP&A, Founders & operators, CFOs, FP&A teams, Controllers, Heads of people - Tags: bonus, accrual, compensation, fp&a, payroll ## Overview Use this workbook to set an annual bonus pool by department and see its monthly cost. Change headcount, salary, target bonus, and performance assumptions to update the plan. The summary shows the total bonus cost, monthly expense, outstanding liability, and payout timing, so finance and people teams can plan the budget and cash impact together. ## What's included - Bonus pool by department, based on headcount, salary, target bonus, and performance - Employer costs and the total cost of the annual bonus pool - Monthly expense, liability, and payout schedule - Summary of bonus cost, cash timing, and impact on EBITDA - Five departments with headcount, average salary, target bonus %, and individual performance multiplier - Single corporate performance multiplier and uniform employer burden % - Pool sheet with per-department gross bonus, burden, and fully-loaded cost plus a panel-total annual pool - 12-month BS roll with opening liability, monthly accrual, payment in the payout month, closing liability, cumulative accrual, and percent accrued - Pre-bonus EBITDA, opening liability, and payout-month inputs for cash-paid timing - Summary with total HC, gross pool, burden, fully-loaded pool, monthly and annual P&L, M12 closing liability, pool / EBITDA, burden % of gross, fully-loaded $ per FTE, and traffic-light status - Green and amber pool-to-EBITDA thresholds and a reconciliation check that confirms burden, percent accrued, and full-pool tie back within tolerance ## How the Bonus Accrual Model Turns Headcount Plans into Monthly Liability This bonus accrual model helps finance teams size an annual bonus pool, spread the cost across twelve months, and track the resulting liability and cash payout. It builds everything from a named employee list, so the numbers tie back to individuals rather than top-down estimates, and it shows how a single scenario switch changes the pool, the monthly accrual, and the year-end balance. ### What Drives the Pool: Employees, Ratings, and the Corporate Multiplier The pool starts at the individual level. Each named employee has a base salary, a target bonus percentage, a performance rating, tenure, and a vested flag. - A lookup table converts the rating into an individual multiplier, which is then capped by a scenario-driven limit. Gross bonus per employee equals base pay times target percentage times that individual multiplier, times a corporate multiplier, times full-time-equivalent and vested factors. - This means the model reflects actual headcount and pay structure rather than an assumed average bonus. A forfeiture adjustment is applied row by row, reducing each gross bonus by the expected forfeiture rate before any department totals are calculated. The employee-level detail then rolls up into five departments using conditional sums, producing department headcount, gross bonus, and forfeiture-adjusted bonus. ### From Department Totals to a Fully Loaded Liability Once department totals are in place, the model adds employer burden. A separate detail sheet stacks statutory and benefit components, including Social Security and Medicare taxes, federal and state unemployment contributions, retirement match, and a benefits load. - Several of these components are effectively zero on bonus pay because annual wage bases are already exceeded on base salary, so the model uses an effective-rate approximation rather than recomputing caps month by month. The derived burden percentage is applied to the forfeiture-adjusted pool to produce total burden dollars, and adding that to the adjusted pool gives the fully loaded pool. - That fully loaded figure is what gets accrued, because employer taxes and benefits are real cash costs that belong alongside the bonus itself. ### How the Accrual, Liability, and Journal Entries Flow Each Month The accrual schedule runs three stacked rollforwards. The prior-year payable opens at a known liability and drains according to a payout-weight vector, so a multi-month payment pattern is visible rather than assumed to be a single lump sum. - The current-year accrual builds from zero to the fully loaded pool over twelve months, either straight-line or, if a true-up trigger fires mid-year, as a revised remaining amount spread across the months left. Total balance sheet liability is the sum of the prior-year and current-year closing balances. - Each month, the accrual is allocated across departments in proportion to their share of gross bonus, creating debit entries that tie exactly to the credit to accrued compensation liability. A pass-or-fail check confirms that debits equal credits every month. ### Scenarios, Capacity Checks, and Practical Use A three-way scenario switch selects between floor, target, and stretch assumptions for the corporate multiplier, forfeiture rate, individual cap, and EBITDA realisation. The scenarios sheet compares all three side by side regardless of which one is active, and reports a probability-weighted expected pool so a compensation committee can see the range rather than a single point. - A quarterly EBITDA capacity sheet tests whether the pool fits within a chosen percentage of earnings, showing headroom or shortfall at mid-year and full-year cutoffs. Sensitivity grids display how the pool-to-EBITDA ratio changes with the corporate multiplier, forfeiture, and EBITDA movement, with colour-coded status flags. - The model is designed for a single operating entity and does not cover multi-entity consolidation, stock-based compensation, or currency translation. ## Built for the comp committee When the question is "does the bonus pool fit the EBITDA envelope, and what does the M12 liability look like?", a pool-sized-by-department panel plus a 12-month BS roll is the cleanest answer. This template gives CFOs and FP&A leads an audit-ready bonus plan that ties every department-target dollar to a month, a pool, and an EBITDA ratio. ## Designed for one-edit responsiveness Every input - HC, salary, target %, individual multiplier, corporate multiplier, burden % - is a per-department row or a named-range cell. Flex one number and the per-department pool, monthly accrual, and pool-to-EBITDA status all recompute - no formula rewrites. ## Honest about payout timing The opening liability is the prior-year pool waiting for cash. It drains in the user-set payout month (default March). The current-year pool accrues across all 12 months and rolls to next year as the new opening liability - the cash drain and the P&L expense never overlap. ## Built for the comp committee When the question is "does the bonus pool fit the EBITDA envelope, and what does the M12 liability look like?", a pool-sized-by-department panel plus a 12-month BS roll is the cleanest answer. This template gives CFOs and FP&A leads an audit-ready bonus plan that ties every department-target dollar to a month, a pool, and an EBITDA ratio. ## Designed for one-edit responsiveness Every input - HC, salary, target %, individual multiplier, corporate multiplier, burden % - is a per-department row or a named-range cell. Flex one number and the per-department pool, monthly accrual, and pool-to-EBITDA status all recompute - no formula rewrites. ## Honest about payout timing The opening liability is the prior-year pool waiting for cash. It drains in the user-set payout month (default March). The current-year pool accrues across all 12 months and rolls to next year as the new opening liability - the cash drain and the P&L expense never overlap. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: department panel, multipliers, burden, EBITDA, timing, thresholds. - Five departments with HC, average salary, target bonus %, individual multiplier - Single corporate multiplier and uniform employer burden % - Pre-bonus EBITDA, opening liability, payout month - Green and amber pool-to-EBITDA thresholds, reconciliation tolerance ### Pool Per-department gross bonus, employer burden, and fully-loaded cost; panel-total annual pool. - HC × target $/head × individual mult × corporate mult = gross bonus - Burden = gross × Burden_Pct (named range) - Fully loaded = gross + burden - Panel-total row sums HC, gross, burden, fully-loaded ### Accrual Schedule 12-month BS roll plus monthly P&L expense. - Opening liability = prior closing (M1 = Opening_Liability input) - Monthly accrual = Fully_Loaded_Pool / 12 (straight-line) - Payment = Opening_Liability in the payout month, zero elsewhere - Closing = opening + accrual − payment - Cumulative accrual rolls forward - Percent accrued = cumulative / fully-loaded pool ### Summary Headline pool, monthly accrual, closing liability, key ratios, traffic-light status. - Total HC, gross pool, employer burden, fully-loaded pool - Monthly P&L, annual P&L (M12 cumulative), M12 closing BS liability - Pool / pre-bonus EBITDA, burden % of gross, fully-loaded $ per FTE - Status flag: On track / Watch / Off track against thresholds - Reconciliation check across burden, percent accrued, and pool tie-back ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: department panel, multipliers, burden, EBITDA, timing, thresholds. - Five departments with HC, average salary, target bonus %, individual multiplier - Single corporate multiplier and uniform employer burden % - Pre-bonus EBITDA, opening liability, payout month - Green and amber pool-to-EBITDA thresholds, reconciliation tolerance ### Pool Per-department gross bonus, employer burden, and fully-loaded cost; panel-total annual pool. - HC × target $/head × individual mult × corporate mult = gross bonus - Burden = gross × Burden_Pct (named range) - Fully loaded = gross + burden - Panel-total row sums HC, gross, burden, fully-loaded ### Accrual Schedule 12-month BS roll plus monthly P&L expense. - Opening liability = prior closing (M1 = Opening_Liability input) - Monthly accrual = Fully_Loaded_Pool / 12 (straight-line) - Payment = Opening_Liability in the payout month, zero elsewhere - Closing = opening + accrual − payment - Cumulative accrual rolls forward - Percent accrued = cumulative / fully-loaded pool ### Summary Headline pool, monthly accrual, closing liability, key ratios, traffic-light status. - Total HC, gross pool, employer burden, fully-loaded pool - Monthly P&L, annual P&L (M12 cumulative), M12 closing BS liability - Pool / pre-bonus EBITDA, burden % of gross, fully-loaded $ per FTE - Status flag: On track / Watch / Off track against thresholds - Reconciliation check across burden, percent accrued, and pool tie-back ## Features - **Pool sized by department:** Five-department panel multiplies headcount by salary, target bonus %, individual multiplier, and a single corporate multiplier - every driver is a named range so a corporate-multiplier change recomputes the pool, accrual, and EBITDA ratio instantly. - **Straight-line monthly accrual:** The fully-loaded pool divides into twelve equal monthly accruals on the P&L while the BS liability builds across the year and the prior-year opening liability drains in a single configurable payout month. - **Pool / EBITDA traffic light:** Summary tags the fully-loaded pool as a percent of pre-bonus EBITDA against green and amber thresholds - On track, Watch, or Off track - so capacity questions land in one cell. ## Use cases - **Annual budget bonus sizing:** Stress-test next year's bonus pool against pre-bonus EBITDA before the comp committee meeting. Flex the corporate multiplier or individual multiplier per department and watch the pool-to-EBITDA status flag move. - **Mid-year accrual true-up:** Update the corporate multiplier mid-year and the monthly accrual instantly re-bases; the closing liability and cumulative accrual recompute so the bookings reflect the live forecast. - **Year-end payout planning:** The payment row drains the opening liability in the payout month, so Q1 cash-out timing is visible alongside the P&L expense for the new performance year. ## Frequently asked questions ### What is a bonus accrual model? It helps you estimate the year's bonuses, record the cost evenly each month, and plan when the cash will be paid. ### What can I change? Update headcount, salary, target bonus, performance, employer costs, and the payout month. The workbook updates the pool, monthly expense, and liability for you. ### Can I use it for more than five departments? Yes. Add rows for your departments and extend the formulas in the pool and summary sheets. ### How is bonus cost recorded each month? The annual bonus pool is spread evenly across the year, so the monthly expense reflects the cost as it is earned. ### When is the bonus paid? Choose the expected payout month. The model separates that cash payment from the monthly expense for the new bonus year. ## Related templates - [Payroll Forecast](https://finamodel.com/templates/payroll-forecast) - [Accrued Expenses](https://finamodel.com/templates/accrued-expenses) - [Stock-Based Compensation](https://finamodel.com/templates/stock-based-compensation)