Clean termination data keeps three systems in step.
Payroll, enrollment and carrier records have to agree after a layoff. Here is where the data goes wrong.
Where the data drifts.
Payroll vs. Enrollment
Payroll may show a separation date that enrollment never received, so deductions and coverage disagree.
Manual Edits
A list built by hand for one carrier rarely matches what another carrier received.
Eligibility Files
A carrier that takes an eligibility file reads the next file as the truth, including any errors in it.
How it plays out.
Take a small example. Payroll records a separation on the 14th. The enrollment system is updated on the 30th. The carrier file runs on the 1st with the enrollment date. Three systems now disagree, and the carrier’s date is the one that decides the bill.
The fix is rarely hard, but it has to be done in the right order: decide the date, correct the enrollment record, then let that record feed the carrier and payroll deduction files.
After the next cycle, spot-check a few people in each system. If the three agree on those, they probably agree on the rest.
How we help.
A broker should take work off a smaller HR team, not add to it.
Reconcile First
We help compare payroll, enrollment and carrier lists before anything is sent.
Fix at the Source
We help correct the record in the enrollment system so every feed carries the same date.
Spot Checks After
We help spot-check carrier files after the next cycle.
Order of work.
Agree the Final Date
Settle one separation date and one coverage end date for each person.
Correct the Enrollment Record
Update the enrollment system first, since other feeds read from it.
Run the Feeds
Send the carrier and payroll files from that record.
Spot-Check the Result
Check a sample in each system after the next cycle.
Mistakes that cost money.
Editing the Carrier Only
A fix made at the carrier alone is undone by the next file.
Two Dates for One Person
Keeping a separation date and a coverage date in the same field causes confusion.
Skipping the Check
Without a spot-check, errors surface only on a bill or a claim.
Related guides.
Right-Sizing HR After Layoffs: The Benefits Workload
The full picture.
Carrier Terminations After a Layoff
After a layoff, each carrier needs accurate termination dates for every person affected.
One Source of Records After a Layoff
Notices, terminations and billing should draw on the same records.
Is HR carrying more than it should?
Tell us what changed, and we will show you what to take off the desk.
Your renewal letter
Your census
Your current plan documents
Your renewal date
Rough answers are fine. We build the numbers from there.
An independent employee benefits consulting firm. We look at the entire benefits program — cost, plan performance, risk and administration.
Switch to CFH. Unhappy with your broker? Your employees won’t notice. You will. →
Cookies on This Site
We use cookies to keep the site working properly and to understand how it is used. You can decline anything that is not essential. See our Privacy Policy for the detail.
- Essential — needed for the site to load and for you to move around it. These cannot be switched off.
- Analytics — tell us which pages get read, so we know what is worth writing more of.
- Advertising — set by third parties such as ad and social platforms to measure and target campaigns.