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

Census File Format

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

Census Template CSV

Click Here to Download the Census Template CSV

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 
  • 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

Click here to view a sample census

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

Click here to learn how to upload the census