EEO-1 Report
KEY TOPICS:
- Prepare the Roster Data Table
- Develop Report Information
- Perform Verification (Recommended)
- View (Errors) Summary Report
- Finalize and Export Report
- Tools for Multiple EEO-1 Reports
Create the EEO-1 Report for Your Organization
Important Note: While the EEO-1 and VETS-100A components of balanceAAP share similar functions, each is tailored to the specific requirements for the type of reporting.
Federal contractors, meeting certain descriptions, are required to submit reporting to the Equal Employment Opportunity Commission. Please consult the regulations for more information on EEO-1 reporting requirements, and the fields you will be required to complete, at: EEOCEEOC.gov / EEO-1 Survey.
Prepare the Roster Data Table
EEO-1 reporting should be created using an employee Roster effective between July 1 and August 31 of the current survey year. If the source AAP Plan Date does not fall within this period, create a separate plan, and use the employment data from the appropriate period to create the EEO-1 report(s).
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 Analyses 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, choose or 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.
Display Hidden Columns – Only the first few 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.