EEO-1 Report
JUMP TO: VETS-4212
KEY TOPICS:
- Prepare the Roster and Related Data
- Develop Report Information
- Enter Analysis Information
- View and Enter Establishment Information
- Perform Verification (Recommended)
- View (Errors) Summary Report
- Finalize and Export Report
- Tools for Multiple EEO-1 Reports
Important Note: While EEO-1 and VETS-4212 modules share similar functions, each is tailored to some specific requirements for the type of reporting.
Create the EEO-1 Report for Your Organization
Federal contractors, meeting certain descriptions, are required to submit reporting on employee demographics to the Equal Employment Opportunity Commission. With the Reports > EEO-1 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.
As a covered employer, your organization may have a single location or it may have multiple establishments. Below is an introduction to the EEO-1 module, with additional information, regarding multiple locations, available at: Tools for Multiple EEO-1 Reports.
Cross-reference: For more on the Federal requirements:requirements, see: EEOC.gov / EEO-1 Survey.
Prepare the Roster and Related Data
The first step is to build a new plan (or use a current plan) with a Plan Date that confirms with the required survey period, typically falling between July 1 and August 31 each year. Accordingly, the Roster snapshot must correspond to the chosen Plan Date, and the fields for Race, Gender, and Job Group must be coded.To calculate the minimum and maximum number of employees for the EEO-1 form, the system will rely on Hire Date and Termination Date fields, located in the New Hire and Termination Data tables, respectively.
Cross-references:
- To learn about the employee Roster: Data Tables / Roster Table
- If you need to import Data, see: Data > Import
- For a downloadable resource: BALANCEaap Data Requirements Guide
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.Click [Save].
View and Enter Establishment Information
First, 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
- Filed Last Year?
- NAICS Code
An EEO-1 report for an organization with one location will, accordingly, have one Establishment.
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 [Plus sign] on the right.
- Edit Establishment Information — To edit or append Establishment Information, click [Edit], and update the displayed fields. Click [Save].
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 Report
Navigate to the Reports tab, and follow the instructions below.First, review Report Settings for this option: Mark reports with less than 50 employees as Status Code 8 Reports.
Preview Report
From Report Viewing options, select: Preview. Then select to View Reports in:- HTML
OR
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:- 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.Review Report Settings — If you did not select this option by Establishment and/or wish to have the system determine it for you:
- Check the box for: Mark reports with less than 50 employees as Status Code 8 Reports.
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.