Free tool · for HR and payroll · runs on your device
Severance payment tracker
Add each departing employee once. The tracker figures severance weeks and the total, and builds the payment schedule after the release takes effect. It adds any COBRA subsidy and flags timing problems before payroll runs.
Many employees, one payment calendar
Severance tracker
Do not enter Social Security numbers. Use an employee ID or name. The tracker rejects anything that looks like a Social Security number. Leave out medical details too.
The tracker lives in this page. Nothing is stored or sent unless you choose Save to my account where it appears, and reloading clears unsaved work. Download the Excel file to keep a copy.
Paste employees from a spreadsheet
Copy rows from Excel or Google Sheets, one employee per row, tab separated. Use these columns in this order, or include a header row with these names:
- Employee
- Hire date
- Separation date
- Annual salary
- Age 40 or older
- Group program
- Method
- Fixed weeks
- Weeks per year
- Service rounding
- Minimum weeks
- Maximum weeks
- Payment form
- Pay frequency
- Known payday
- Verified final offer date
- Release signed
- Days to consider
- Revocation days
- COBRA months
- COBRA monthly premium
- Employer COBRA share %
Fix the settings marked above to see flags, schedules and the calendar.
Employees
| Employee | Separation | Severance | Payment | First payment | Status | Actions |
|---|
Flags
Combined payment calendar
| Pay date | Payments | Total for the date |
|---|
Each employee's schedule
COBRA subsidy schedule
| Month | Employer pays | Total for the month |
|---|
Download or print
Section 409A timing is not computed. Confirm the timing of severance payments with counsel before payroll runs them.
How the tracker works
- Years of service. Whole anniversaries of the hire date on or before the separation date. A partial year is the share of the current service year completed. A February 29 hire date has its anniversary on February 28 in other years.
- Severance weeks. Fixed weeks, or weeks per year times years of service. Completed years round down, nearest year rounds a half year up, and prorated counts the partial year to 2 decimals. Then the minimum is applied if the result is lower, and the maximum if it is higher.
- Total. Weeks times annual salary divided by 52, rounded to the cent once.
- Release timing. For a waiver of ADEA rights, count from the employer’s final offer. A material change restarts the period unless the parties agree that changes will leave the period in place. Enter the period actually offered, with a minimum of 21 days or 45 days for a group program. The revocation period is at least 7 days after signing (29 CFR 1625.22(e)).
- First payment. The first payday on or after the day after the revocation period ends, or on or after a later planned date.
- Lump sum or salary continuation. A lump sum is one payment of the total. Salary continuation pays annual salary divided by the paydays in a year (52, 26, 24 or 12) on each payday. The last payment is whatever is left, so the payments add up to the total exactly.
- Paydays. Weekly and every-two-weeks paydays step from the known payday. Twice a month is the 15th and the last day of the month, and monthly is the last day. A payday on a weekend or company holiday moves by your setting.
- COBRA subsidy. Months times the monthly premium times the employer share. The monthly amount is rounded to the cent and starts the month after separation unless you pick a month.
Worked example (fictional employees)
The Example button loads 5 employees as of November 9, 2026, with holidays on November 26, December 25 and January 1.
- E-5101 Jordan Blake, 40 or older: 12 completed years times 2 weeks = 24 weeks. At $1,846.15 a week, the total is $44,307.69. Salary continuation every two weeks pays $3,692.31 eleven times and $3,692.28 last. Signed November 4, 2026, so the revocation period ends November 11, 2026 and the first payday after it is November 20, 2026. The January 1, 2027 payday is a holiday, so it moves to December 31, 2026. That puts 4 payments ($14,769.24) in 2026 and 8 ($29,538.45) in 2027.
- E-5103 Chris Morgan, group program: the prorated formula gives 85.36 weeks, capped at 26, or $60,000.00. The release is not signed yet, and the 45-day consideration period ends December 28, 2026.
- E-5104 Sam Rivera: 1 completed year gives 2 weeks, raised to the 4-week minimum, or $4,500.00. The agreement gives only 3 days to revoke. The tracker holds all payments for this row.
- E-5105 Alex Kim signed after the entered consideration deadline. The tracker holds all payments for this row pending review.
The combined calendar holds 13 payments on 13 pay dates, $55,384.61 in all. The COBRA subsidy for scheduled rows totals $5,550.00.
The rules behind the flags
| Flag | Rule |
|---|---|
| Release not signed | No payments are scheduled. The tracker shows the consideration deadline and the first payday if the employee signs on the last day. |
| Consideration deadline passed | The period ended without a signature. Check the agreement before paying anything that depends on the release. |
| Review period too short (40 or older) | A worker 40 or older must get at least 21 days, or 45 days in a group program (29 U.S.C. 626(f)). Enter the period actually offered. The tracker holds the schedule if this period is missing or too short. |
| Signed before the review period ended | Allowed when the employee chooses to sign early (EEOC). The revocation period still runs from the signing date. |
| Revocation period under 7 days (40 or older) | A worker 40 or older gets at least 7 days after signing to revoke. The tracker holds the schedule if the agreement’s revocation period is missing or shorter than 7 days. |
| Payment scheduled before revocation ends | Never release the first payment before the revocation period ends. The tracker moves the payment to the first payday after. |
| Signed after the deadline | The tracker holds the schedule while you verify the controlling dates and agreement terms. |
| Revoked | Cancel the schedule and pay nothing that depends on the release. |
| Payments in two calendar years | The pay date sets the W-2 year and which year's Social Security wage base applies. |
| Group program | Give the written decisional unit disclosure, with the job titles and ages of those selected and not selected (EEOC). |
| Floor or cap applied | The formula result was below the minimum or above the maximum, so the limit was used. |
What the tracker does not do
- Section 409A timing. The tracker does not compute section 409A timing for severance. Confirm the timing of severance payments with counsel.
- Final wages and PTO payout. State final pay laws set those deadlines, and they cannot wait for a release. Use final pay by state and the PTO payout calculator.
- Taxes. Amounts are gross. Severance is wages for Social Security, Medicare, federal income tax withholding and FUTA (IRS Publication 15). A lump sum paid separately from regular wages may use the 22% flat rate for supplemental wages. The rate is 37% on supplemental wages over $1 million in the year.
- COBRA premium limits. The premium you enter is the plan's full charge. It cannot be more than 102% of the plan's cost, or 150% during a disability extension (DOL employer guide).
Best practices for severance payments
- Track the verified final offer date, consideration deadline, signature date, revocation end date, first eligible payroll and last payment date for each person.
- Never release the first payment before the revocation period ends.
- Write the severance formula down in a plan or policy, and apply it the same way to everyone in the same group.
- For group programs with workers 40 and older, attach the decisional unit disclosure to every agreement.
- Pay final wages under state final pay law, separately from severance. Final pay should never wait for a signed release.
- Coordinate any COBRA premium subsidy with the COBRA administrator, so the person is not billed for months the employer pays.
- Code severance as its own earning type, so it is easy to report and audit.
- Keep a file with the signed agreement, the timing dates and the payroll records for each payment.
- Review severance templates at least yearly. The NLRB position on confidentiality and non-disparagement changed several times from 2023 to 2026.
Frequently asked questions
What should I not enter in the tracker?
Never enter a Social Security number. Use an employee ID or name, and leave out medical details. The tracker rejects text that looks like a Social Security number. Back to the tracker.
When can the first severance payment be made?
After the revocation period ends. A worker 40 or older gets at least 7 days after signing to revoke (29 U.S.C. 626(f)). The tracker uses the first payday on or after the next day.
How does salary continuation work in the tracker?
Each payday pays annual salary divided by the paydays in a year. The last payment is the amount left, so payments add up exactly. How it works.
How is the COBRA subsidy figured?
Months times the monthly premium times the employer share. The plan's premium cannot be more than 102% of its cost (DOL). Tell the COBRA administrator which months you pay.
Does the tracker handle section 409A?
No. Section 409A timing for severance is not computed. Confirm payment timing with counsel. What the tracker does not do.
Is my tracker saved anywhere?
Not unless you choose Save to my account where it appears. Otherwise it lives in this page, and reloading clears it. Download the Excel file to keep a copy. Back to the tracker.
More on leaving a job
- Leaving a Job DeskYour first week after notice, every separation guide and the HR checklist.
- How to read a severance agreementThe parts, the rules if you are 40 or older, taxes and questions to ask.
- COBRA guide and dates calculatorWho qualifies, the deadlines, state laws and the Marketplace option.
- Unemployment benefitsHow to file and the official claim site for all 50 states and DC.
- WARN notice requirementsFederal and state layoff notice rules, with a notice date calculator.
- State payroll laws: final pay by stateFinal paycheck deadlines for all 50 states and DC.
- PTO payout calculatorUnused vacation times the rate, with state payout rules.
- Employee change impact checkerWhat HR, payroll and benefits each do for a termination.
Official sources
Each rule and figure on this page was checked on these official pages on November 9, 2026.
- 29 U.S.C. 626(f), waivers of age discrimination claims (GovInfo)
- Q&A: Understanding Waivers of Discrimination Claims in Employee Severance Agreements (EEOC)
- Publication 15 (2026), (Circular E), Employer's Tax Guide (IRS)
- An Employer's Guide to Group Health Continuation Coverage Under COBRA (DOL EBSA, October 2021)
- 29 CFR 1625.22, Waivers of rights and claims under the ADEA (eCFR)
Free Excel template
The same rules in a spreadsheet with working formulas, ready to fill in and keep. Free with your P.A.Y. profile.