Explaining the EEO-1 Report

The Equal Employment Opportunity Commission (EEOC) requires large companies to report by September 30th historical taxable wages and total hours worked for 2017 and 2018. In 2019, the EEOC updated its requirements for the annual EEO-1 Report to include the collection of pay data for calendar years 2017 and 2018. Zenefits will be helping companies by providing company data in one of the following methods:

  • Raw data spreadsheet
  • EEO formatted upload file

What will these reports contain?

In the raw data file, you'll see several new fields included in addition to the standard fields.
  • 2017 total taxable earnings
  • 2017 total hours worked
  • 2018 total taxable earnings
  • 2018 total hours worked
  • EEO Race
  • Work Location & Job Category (as of last day of that year)
Additionally, the file will include the EEO encoded values for Race/Ethnicity, Gender, Job Category, and Total Taxable Earnings.

Alternatively, companies can generate an aggregate data file
  1. Click the EEO reporting card in Business Intelligence. 
  2. Fill in any missing data within the EEO census (missing data typically stems from using another payroll or time & attendance provider). 
  3. Download the CSV file. 
  4. Review it for accuracy! 
  5. Upload to the filing website.

What are the new requirements?

Component 2 is the new component of EEO reporting this year. To read more about what it entails, visit the EEOC website

What if I don't use Zenefits Payroll or Zenefits Time & Attendance?

You'll still have access to download the raw data file, but the wage and hour information will not be included. 

Can I download this file if we just began using Zenefits?

Yes, the report will include all of the information you currently have in Zenefits. If you weren't using Zenefits Payroll or Time & Attendance during 2017 or 2018, these fields will remain blank in the file.

Why are there so many blank cells in the EEO data? Shouldn't Zenefits have this as my system of record?

If you didn't use Zenefits Payroll or Time & Attendance in 2017 and 2018, you'll notice the file will contain blank cells.

Why are the zip codes I entered only displaying 4 digits in Excel?

Excel formatting removes any leading zeros, so if you entered any zip codes that begin with 0 you'll notice this in the Excel version. If no formatting changes are made, the file will upload without problem to the EEO. If you wish to add the leading 0 back into the Excel file, it's recommended to change the formatting of the column to Text so the 0 isn't overwritten when you retype the 0.

Why do some workers have blank fields if I used Zenefits for Payroll and/or Time & Attendance in 2017 and 2018?

The system will return blank values if an FLSA status was not assigned to a worker, or if they were a non-exempt worker and there is no Time & Attendance data.

Why am I receiving an endless loading screen?

If you haven't enabled the EEO question in your company's Hiring app, you won't be able to create an EEO report.

What is the pay period associated with the Component 2 information?

The Component 2 information is as of December 31 of either 2017 or 2018. It is not associated with a specific pay period.

Was this article helpful?  

Still need our help? Our support team is waiting to help you. Contact us