Create the EEO-1 Report for Your Organization

About the EEO-1 Report

Federal contractors, meeting certain descriptions, are required to submit reporting on employee demographics to the Equal Employment Opportunity Commission (EEOC). With the Reports > EEO-1 Report module, you can prepare the necessary reporting. While employee information and demographics can be extracted from balanceAAP > Data, additional information will be compiled in this module to identify your organization, in conformance with the reporting requirements.

For covered employers, below is an introduction to EEO-1 tools.

Cross-references: For more on the Federal requirements, see the EEOC Website —

• EEO-1 Survey (Home page)
• EEO-1 Instructions Booklet

EEO-1 Reporting Components 1 and 2

In July 2019, the EEO-1 format was updated to include a "Component 2" requirement for the reporting of 2018 (and 2017) employee counts by pay band for each EEO category. Instructions for preparing this component are included below; and more information is available via the Federal EEO-1 Web page, linked above.

Accordingly, the traditional EEO-1 submission is now designated as "Component 1."

Prepare the Roster Data Table

The first step is to build a new plan (or use a current plan) with a date that falls within the snapshot period. The workforce snapshot period for the 2024 EEO-1 Component 1 report would be an employer-selected pay period between October 1, 2024 and December 31, 2024.

Accordingly, a Roster snapshot, corresponding to the chosen Plan Date, must be imported (or available in the current plan). Fields for Race, Gender, and EEO Job Group, along with supporting Reference Tables, will be used to develop the EEO-1 report.

Develop Report Information

On the Report Information tab are the Analysis Information menu and the Establishment Information table. Also available from the tab header are tabs for Verification and Report.

Enter Analysis Information

Enter Analysis Information for inclusion in the EEO-1 report's header and footer. This information will be used by the Agency to identify the reporting organization and its contacts. To assist with the creation of the EEO-1 report, the Analysis Information can be imported directly into the plan. Using [Export Analysis Info], an excel file template can be modified to include the needed analysis information. The file can then be selected and uploaded by using [Upload Workbook] and once the file is confirmed, imported into balanceAAP through the [Import Analysis Info] option.

Click [Save].

View and Enter Establishment Information (For one location)

An EEO-1 report for an organization with one location will, accordingly, have one Establishment. Therefore, using the drop-down under Establishment, retain the default selection of: None.

Once created, the Establishment Information table will be organized by Establishment Code and describe the establishment, using EEO-1-required fields, including, but not limited to:

• Report Type (drop-down)
• Unit Number
• Unit Name
• Unit Address
• City, County, State, Zip
• NAICS Code
• EIN
• Federal Contractor Status,
• Unique Entity ID (UEI)

Page Controls for Establishment Information

The Establishment Information menu provides the following tools:

• Display Hidden Columns — Only the first few menu columns display by default. To view hidden fields for a record, some of which are critical for the EEO-1 report accuracy, click the expand button, [Plus sign], on the right.
• Edit Establishment Information — To edit or append Establishment Information, click [Edit], and update the displayed fields. Click [Save].
• Quick Search Tip: To search the list of Establishments, enter an term in the Search field. Then hit ENTER on the keyboard to perform the Search. Use the ESCAPE (ESC) key to clear the Search results.

Perform Verification (Recommended)

The Verification tab allows you to initiate a scan on EEO-1 data prior to submission. A Notifications panel at the top of the page will indicate the last date the scan was run, if any, and summarize the results. Click [Verify] to run the check.

Any detected errors in the EEO-1 report will be displayed on the Verification errors table. To display errors by type, make a selection from the Error Type drop-down, located in the table header. Use the Fix These Records link, also in the table header. Select one of the provided solutions, and choose [Submit].

If errors remain in the table, return to the Report Information tab, and make any necessary changes, using the record-level [Edit] icon.

View (Errors) Summary Report

Chose the [View Summary] button, which is located in the lower toolbar. The Summary Report will list EEO-1 > Verification errors by: Error Description, Field, Incorrect Value.

Preview and Finalize EEO-1 Report

Navigate to the Reports tab, and follow the instructions below.

Select Component

At the top of the screen, select:

• Component 1 (Traditional report)
• Component 2 (Add-on for pay bands)

Preview Report

From Report Viewing options, select: Preview. Then select to View Reports in:

• HTML
• PDF

Then click [Run Report] to open the EEO-1 report in a new window.

Export Report for Internal Use

From Report Viewing options, select: Report Export. Then — Select a File Type for Reports:

• PDF
• Word
• Excel
• Rich Text

Click [Run Report]. You will be prompted to download and save the file.

Export File for EEOC Submission

From Report Viewing options, select: File Export.

Click [Run Report]. The exported file will be formatted according to the EEOC technical requirements for electronic submission. You will be prompted to download the Zip file.