Skip to content
English
  • There are no suggestions because the search field is empty.

Census File Format

You will be uploading census documents frequently. Using the census template and formatting it correctly will minimize delays and frustration.

Note: There are different census data requirements when creating an initial prospect (Go/No Go) census and a final employer census to upload into the benefitbay® platform.


Stages of Modeling

There are two main stages of the ICHRA modeling process and both have different census data requirements. The Go/No Go Census is used when first prospecting a lead to determine if ICHRA is financially viable. The Final Census is used when employers are confident they will be moving forward with ICHRA and require a more detailed model that will help them determine a contribution strategy. Below you will find a list of the data requirements needed for both stages of modeling.


Census Template CSV


Census Data Requirements

Go/No Go Census Data Requirements 

Employee ID
  • Relationship
  • First Name
  • Last Name
  • Date of Birth (MM/DD/YYYY)
  • Gender
  • Tobacco Use (Y/N)
    • If Tobacco use is not known, mark it as "N."
  • Home Zip Code
  • ACA Benefit Status
    • "FT_ACA" if full-time and ACA-eligible
    • "PT_OFFER" if not ACA-eligible but offered coverage
    • "PT_NO_OFFER"if not ACA-eligible and not offered coverage
  • ACA Benefit Status Renewal
    • Optional, used to denote employee's ACA status next year if changing year-over-year
  • Annual Wages
  • Pay Type
    • Salary
  • Employment Start Date
  • Current Coverage 

When you are adding dependents, you must add them below the employee they are a dependent of. You should include their relationship to the employee, and use the same "Employee ID" so the platform can map the dependents to the correct employee.

Required for Group vs ICHRA Comparison Only
  • Current Employer Amount (monthly)
  • Current Employee Amount (monthly)
  • Renewal Employer Amount (monthly)
  • Renewal Employee Amount (monthly)

Final Census Data Requirements:

All the information for the Go/No Go Census plus the following:

  • Tax ID (SSN)
  • Full Home Address (State should be two-letter abbreviations) 
  • Primary Phone Number (Personal phone number for employee)
  • Email (Personal email for Employee)
  • Pay Type (Hourly or Salary)
    • For Hourly; Average Hours Per Week and Hourly Rate
    • For Salary; Annual Wages

 

 

 

Census Template CSV

You must upload a properly formatted CSV file in order to get your census information into the benefitbay platform. This article will provide sample files and more information about formatting each required field.


 

Census Data Requirements

Fields bolded below are Required

  • Employee ID (REQUIRED)

    • This is your internal company ID number for your employee
  • External Employee ID (Optional)

    • You may use this for any additional internal ID numbers 
  • Benefitbay ID (Leave blank for new hire entry)

    • *Leave this field blank when entering new hires into the system
    • This field is REQUIRED when using the census to terminate employees
    • To find an employee's benefitbay id, you can download the census
  • Relationship (REQUIRED)

    • You should only be uploading eligible employees on your census
    • Use Employee 
  • First Name (REQUIRED)

  • Last Name (REQUIRED)

  • Date of Birth (REQUIRED)

    • Use format (MM/DD/YYYY)

  • Gender (REQUIRED)

    • Use M or F
    • Unfortunately, insurance carriers will only accept either "Male" or "Female" — there are no other gender options at this time. 
  • Tax ID (REQUIRED)

    • Use format with dashes: XXX-XX-XXXX
    • This is the employee's Social Security number.
  • Tobacco Use (REQUIRED)

    • Use Y or N
    • If Tobacco use is not known, use N
  • Home Address (REQUIRED)

  • Home Address 2 (Optional)

    • Use only for Apartment designations
  • Home City (REQUIRED)

  • Home State (REQUIRED)

    • Use the state's two-letter abbreviation
  • Home Zip Code (REQUIRED)

  • Primary Phone Number (Optional, but highly recommended)

    • Use the employee's personal phone number
  • Email (REQUIRED)

    • If possible, this should be the Employee's personal email
  • ACA Benefit Status (REQUIRED)

    • Use FT_ACA, PT_OFFER, or PT_NO_OFFER
    • Use FT_ACA if the employee is full-time and ACA-eligible
    • Use PT_OFFER if the employee is not ACA-eligible but is still offered coverage
    • Use PT_NO_OFFER if the employee is not ACA-eligible and will not be offered coverage
      • Note: You are not required to upload employees who are not eligible for benefits. PT_NO_OFFER status is available for employees who remain active, but have lost benefits eligibility.
  • ACA Benefit Status Renewal (Optional)

    • Optional, used to denote employee's ACA status next year if changing year-over-year due to ACA look-back.
    • Use same fields as above
  • Avg. Hours per Week (REQUIRED for Hourly)

    • Leave blank if the employee is Salary
  • Hourly Rate (REQUIRED for Hourly)

    • Leave blank if the employee is Salary
  • Annual Wages (REQUIRED for Salary)

    • Leave blank if the employee is Hourly
  • S Corp Owner > 2% (Optional)

    • Use Y or N or leave blank to default to No
    • If an employee is an S Corp Owner who owns more than 2% of the company, use Y
      • S Corp Owners are not eligible to receive a contribution for their health insurance. Marking them Y allows them to elect coverage in the platform with a $0 contribution.  
  • Pay Type (REQUIRED)

    • Use Salary or Hourly 

  • Pay Frequency (optional) 

    • Use Monthly, Semi-Monthly, Bi-Weekly, or Weekly

  • Job Title (Optional)

  • Employment Start Date (REQUIRED)

    • Use format MM/DD/YYYY
  • Custom Coverage Eligible Date (Optional)

    • Use this field if the employee's eligibility date is different then their employment start date. 
    • Use format MM/DD/YYYY
  • Employment Termination Date (Required if using census to terminate EEs)

    • Use this field when terminating employees in bulk
    • Use format MM/DD/YYYY
  • Employment Final Premium (Required if using census to terminate EEs)

    • Use this field when terminating employees in bulk
    • Use format MM/DD/YYYY 
    • Use any date on or after the termination month. 
  • Employment Termination Reason (Required if using census to terminate EEs)

    • Use this field when terminating employees in bulk
    • Use Voluntary or Involuntary
  • Cur ER Amt (Leave blank)

    • This field and the following three fields are meant to be used by brokers modeling new customers.

  • Cur EE Amt (Optional)

  • Ren ER Amt (Optional)

  • Ren EE Amt (Optional)

  • Current Coverage (Optional)

    • Use format EEO, EES, EEC, EEF, or WAIVE
      • EEO - Employee Only
      • EES - Employee + Spouse
      • EEC - Employee + Child
      • EEF - Employee + Spouse + Child
  • Other Income (Leave blank)

    • This field should only be used by brokers modeling new customers.
  • Location Name (Optional)

  • Collective Bargaining Group (Optional)

  • Home Phone Number (Optional)

  • Work Email (Optional) 

  • Carrier Name (Optional)

    • This field and the following four fields should only be used by brokers modeling new customers. 

    • Use any text

  • Plan Name (Optional)

    • Use any text

  • Plan Type (Optional)

    • Use any text

  • HSA (Optional)

    • Use Y or N

  • Actuarial Value (Optional)

    • Use numeric value only (e.g. 0.75, 70.0)




Census Format

Please download the sample census (link above) in order to view a properly formatted census file. The file type must be a CSV so that it will upload into the benefitbay platform. Include all the required census data points required for the modeling stage you are in.

 


Census Format

Please format your census file like the example below. The file type must be a CSV so that it will upload into the benefitbay platform. Include all the required census data points required for the modeling stage you are in. Screenshot 2026-09-02 at 3.14.41 PM