< back

EEO-1 Report

KEY TOPICS:

  • Prepare the Roster Data Table
  • Develop Report Information
  • Perform Verification (Recommended)
  • View Summary Report
  • Export Report
  • Master Plan Considerations and Settings
    • Import Establishments

Create the EEO-1 Report for Your Organization

Important Note: While the EEO-1 and VETS-100 components of balanceAAP share similar functions, each is tailored to the specific requirements for the type of reporting.

Please consult the regulations for more information on EEO reporting requirements and the fields you will be required to complete.

Prepare the Roster Data Table

EEO-1 report(s) 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, which will be placed in the report's header and footer. This information will be used by the Agency to identify the reporting organization and its contacts.

Click [Save].

Enter Establishment Information

At the top of the menu, choose: None.

View and Edit the Establishment Information

Once established, the Establishment Information table will be organized by Establishment Code and describe each establishment, using EEO-1-required fields. An EEO-1 report for an organization with one location will, accordingly, have one Establishment.

To view hidden fields for a record, click the expand [Plus sign] on the right.

To add or edit information, click [Edit], and update the displayed fields. Click [Save].

Export Report

If applicable, from the Report Export option located on the Reports tab, choose to export the EEO-1 report as: a Single file or Separate files.

Next, select the file type PDF, Word, Excel, or Rich Text. Then select the Establishment Codes (if applicable) to include in the report. Select the report settings, if necessary, and click [Run Report].

To export the file, select File Export and then click [Run Report]. The exported file will be formatted according to the EEOC requirements for electronic submission. You will be prompted to download the file. If your pop-up blocker prevents the file from automatically being downloaded, you can also click the link at the top of the screen to download the file.

Perform Verification (Recommended)

The Verification tab allows you to initiate a scan on the report's data prior to submission: Click [Verify]. In the information section, identified by the info icon, the date of the most recent verification will be listed.

If the system detects errors in the EEO-1 report, they will be displayed in the Errors Section. If your report has multiple error types, you can select to view a particular error from the Error Type drop-down menu. Any errors that should be addressed will be listed in table form, displaying the description of the error, the Establishment the error is located in, the field that contains the incorrect data, and the actual incorrect value.

Some error types have an available acceptable solution. These errors will have the Fix These Records link next to the Error Type drop-down menu. Click this option to be assisted in fixing the error(s).

If the error type does not have an acceptable solution, you will need to correct the data through data entry: Return to the Report Information tab, and make any necessary changes.

View Summary Report

Click View Summary.

Master Plan Considerations and Settings

Multiple Plan Data Import

If all of the following apply, follow the instructions below:
  • Your organization's AAP effective date is not during the required EEO-1 reporting period
  • The organization is comprised of multiple locations
  • All EEO-1 reports can be created from a master data set

First, create a Master Plan, following the instructions to:Create Plan.

Then Import a master data set. Include a Plan Code, a Drilldown, or a User Defined Field in the data set to be used as the Establishment Code, which will parse data for each EEO-1 report.

Proceed to the EEO-1 module.

Establishment Information

If multiple establishments are to be represented in the EEO-1 report, navigate to the provided Establishment Information drop-down, which by default is displayed as: None. Instead, choose the field from the Data Tables that contains this information (e.g., Plan Code, Drilldown, or User Defined Fields).

Add Establishment Information

To enter information, select [Add Establishment] from the middle toolbar. A window will display, allowing data to be entered. Click [Save] to store the information.

Important Caution: Changing the selection to or from None will cause any current Establishment Information record(s) to be deleted.

Import Establishments

Click [Import Establishments]. Choose the appropriate file type (Excel, Access or a text) from the. Click [Browse], locate the file on your computer, and click [Next]. Select the file and sheet name information from the drop-down menu.

Under Match Fields, select the field names from the drop-downs that best match the system's field names.

Notes: Some fields may be automatically matched. Fields marked with an * are required.

Navigate to the bottom of the page to see the Preview of Data. If satisfactory, click [Next]. Then choose whether to Overwrite or Append the data.

Click [Import Data] to initiate the process. The import results will be displayed when the process is complete.

The Establishment Code and three additional fields will display in the table. To view additional information fields for the establishments, click on the plus sign icon on the right.