Employee Census Checker Skill

Send the broker a census that's right the first time: every missing field, swapped date and tier mismatch found, with a clean copy ready to send.

$19 one-time

Buy and download

Pay with crypto (USDC or USDT)

Same price on Base, Ethereum, Arbitrum, Optimism, Polygon or Solana. No account, no KYC. Files appear as soon as the payment confirms. How it works

14-day refund: if it doesn’t work and we can’t fix it, email hello@youraitools.co within 14 days and we refund you.

Sold by YourAITools. Support: hello@youraitools.co

Delivery: Right after payment, Stripe’s confirmation page shows your download link.
Format and license: Zip, 15 KB, v1.0, 13 files. You may use and modify this kit for your own work and for clients you serve, including paid client work. Not affiliated with or endorsed by any insurance carrier or benefits platform.
Refunds: 14-day refund: if it doesn’t work and we can’t fix it, email hello@youraitools.co within 14 days and we refund you. Refund policy

Employee Census Checker Skill product illustration

What it does

Brokers and carriers quote from your employee census, and a bad census means a wrong quote, a re-quote or a delayed renewal. Run one command on the census CSV and get every problem with its line number, plus a cleaned copy with ages and age bands. Python standard library only; nothing is uploaded.

python3 -m census census.csv --as-of 2027-01-01 --out census-review/

What you get

The screenshot is real output from the kit’s own commands. Tested from a fresh download of this exact zip: ./run_tests.sh ran 6 tests OK on Python 3.13 and 3.10.

Real terminal output from Employee Census Checker Skill: demo and passing tests

Checks

Check	What it flags
MISSING_COLUMN / MISSING_VALUE	required data missing (default: employee ID, date of birth, hire date, ZIP, coverage tier; change with --required)
BAD_DATE, FUTURE_BIRTH_DATE, IMPLAUSIBLE_AGE, HIRED_BEFORE_BIRTH, FUTURE_HIRE_DATE, TERM_BEFORE_HIRE	impossible or swapped dates, employees under 14, anyone over 100
TERMINATED_ON_CENSUS	terminated people still listed (unless on COBRA)
ZIP_LOST_ZERO, BAD_ZIP	4-digit ZIPs Excel stripped (fixed in the clean file), non-US codes
UNKNOWN_TIER, TIER_DEPENDENT_MISMATCH, TWO_SPOUSES, ORPHAN_DEPENDENT, UNKNOWN_RELATIONSHIP	tiers normalized to EE / ES / EC / FAM / Waive and checked against the dependent rows
CHILD_26_PLUS	child dependents 26 or older on the census date
DUPLICATE_EMPLOYEE, SAME_PERSON_TWO_IDS	repeated IDs, same name and birth date under two IDs
FT_UNDER_30_HOURS, PT_30_PLUS_HOURS	status vs scheduled hours, as a note to check against your plan's eligibility rule

Outputs: census_issues.csv (with a fixed_by column), census_clean.csv (all your columns, unchanged, plus Age, Age Band, ZIP (fixed), Tier (normalized)) and summary.md (headcount, dependents, tier mix, age bands, average age). Dates like 04/12/1985, 1985-04-12, Apr 12, 1985 and Excel serials are read; --dayfirst for day/month files.

./demo.sh runs a planted example (17 issues). ./run_tests.sh runs the tests. Claude Code plugin with a skill in skills/employee-census/.

Not included (on purpose)

No eligibility, underwriting, ACA or plan-rule decisions: notes like CHILD_26_PLUS and FT_UNDER_30_HOURS say "check your plan rules", because the carrier, broker and plan documents decide. It never scores or ranks employees.

Honest limits

US ZIP codes; other countries' postal codes are flagged for review.
Dependents are linked by employee ID on each dependent row.

Also see the Payroll Register Reconciliation Skill and the CSV Data Quality Checker. License: LICENSE.txt.

Format and license

Zip, 15 KB, v1.0, 13 files. You may use and modify this kit for your own work and for clients you serve, including paid client work. Not affiliated with or endorsed by any insurance carrier or benefits platform.

FAQ

Does it decide who is eligible?: No. It checks the data and says when to check your plan rules; eligibility is the carrier's and plan's call.
Does it change my file?: No, it writes a separate clean copy with your original columns plus age, age band, fixed ZIP and tier.
Is the data uploaded?: No, it runs on your computer.
How do I get the files?: Right after payment, Stripe’s confirmation page shows your download link.
Refunds?: Email hello@youraitools.co within 14 days if it doesn’t work and we can’t fix it.
Can I pay with crypto?: Yes. Pay the same price in USDC or USDT on Base, Ethereum, Arbitrum, Optimism, Polygon or Solana from the "Pay with crypto" button, with no account or KYC. We check the payment on-chain and show your download links as soon as it confirms.

Get Employee Census Checker Skill

Check an employee census for health insurance quotes: missing fields, swapped dates, lost ZIP zeros, tier vs dependents, children 26+. Clean copy. $19.

$19 one-time

Buy and download Pay with crypto

Save with a bundle

Back-Office Ops Skills Bundle: 4 products for $49 ($86 separately, you save $37).

Pairs well with

Download$19

SaaS Spend Finder Skill

Find software subscriptions in card or bank exports: monthly and annual cost, double charges, price increases, overlapping tools, renewals. Local, $19.

View SaaS Spend Finder Skill

Download$19

Sales Pipeline Hygiene Checker

Pipeline hygiene check for CRM exports: past-due close dates, stale and stuck deals, missing amounts, duplicates, slipped deals. Fix list per owner. $19.

View Sales Pipeline Hygiene Checker

DownloadFree

UTM Builder & Checker (Free)

Free UTM builder and checker: tag a whole campaign sheet, catch utm typos, capitals and spaces, and see which links GA4 will file as Unassigned.

View UTM Builder & Checker (Free)