Free download • Use as a template • Print or share
A Worksheet Demographic Comparison is a structured legal and compliance document used to systematically record, compare, and analyze the demographic composition of a workforce, applicant pool, or other defined employment group across protected-class categories — including race, ethnicity, sex, age, disability status, and veteran status. It captures headcount by demographic group, calculates selection or representation rates, applies the EEOC four-fifths rule to identify adverse impact, benchmarks internal representation against external labor market availability, and documents findings in a signed, certifiable record. Organizations use it as the quantitative backbone of affirmative action plans, EEO-1 filings, pay equity reviews, and regulatory audit responses, and — when prepared under attorney direction — as privileged litigation-support documentation.
Without a current, properly executed demographic comparison worksheet, an employer responding to an EEOC charge or OFCCP compliance review has no organized paper trail to demonstrate good-faith analysis of its employment decisions — and regulators draw adverse inferences from the absence of documentation. Federal contractors who fail to maintain required utilization analyses risk debarment from federal contracting. Beyond mandatory compliance, an employer that conducts a reduction in force or runs a promotion cycle without a demographic analysis is flying blind: disparities that could have been identified and corrected in advance become costly settlements or consent decrees afterward. A structured worksheet forces the analysis to happen before decisions are final, creates a defensible record of methodology, and provides the specific, dated evidence that distinguishes a good-faith compliance program from a paper exercise. This template gives you the framework to run that analysis correctly the first time.
| If your situation is… | Use this template |
|---|---|
| Analyzing hiring selection rates across demographic groups for adverse impact | Adverse Impact Analysis Worksheet |
| Completing a formal EEO-1 Component 1 workforce snapshot | EEO-1 Report Form |
| Comparing compensation across demographic groups for pay equity review | Pay Equity Analysis Worksheet |
| Documenting workforce diversity metrics for an annual sustainability or ESG report | Workforce Diversity Report |
| Analyzing demographic composition of a promotion or reduction-in-force decision | RIF Demographic Impact Worksheet |
| Comparing applicant pool demographics to hire rates by protected class | Applicant Flow Log |
| Tracking demographic participation in training programs over time | Training Participation Demographic Log |
Why it matters: The four-fifths rule requires comparison to the best-performing group — using the average rate systematically understates adverse impact and can produce a false clean result that won't survive regulatory scrutiny.
Fix: Identify the group with the highest selection rate first and use that figure as the denominator for all adverse impact ratio calculations.
Why it matters: Different employment classifications have different legal protections and availability benchmarks; combining them distorts both the selection rate and the utilization gap calculation.
Fix: Segment headcount by employment classification in separate rows or separate worksheets, and note the classification scope in the employer identification block.
Why it matters: An adverse impact worksheet circulated to managers, recruiters, or business partners without a privilege header can be deemed discoverable in litigation, turning a compliance tool into evidence of known disparities.
Fix: Determine at the outset whether the analysis is being prepared under attorney direction. If it is, apply the privilege designation before any distribution and restrict access to named recipients only.
Why it matters: A benchmark that is five years old or drawn from the national census for a role that realistically hires from a single metro area will produce utilization gap figures that are either too alarming or too favorable to be defensible.
Fix: Update availability benchmarks at least every three years or when the relevant labor market changes materially, and document the source, geographic scope, and data year directly in the worksheet.
Why it matters: A worksheet with completed tables but a blank or generic narrative suggests the calculations were run but not actually reviewed, which undermines the document's value as a compliance record and signals a lack of good-faith effort to regulators.
Fix: Write at least two substantive sentences per job group in the findings section: one stating the ratio and whether adverse impact was indicated, and one noting the recommended action or explaining any mitigating factor.
Why it matters: Documenting placement goals as minimums or quotas creates liability under Title VII, Section 703(j) of the Civil Rights Act, and equivalent statutes — the very laws the worksheet is meant to help comply with.
Fix: Label all placement goals as good-faith aspirational targets tied to availability data, and include a note confirming they do not constitute quotas or constitute preference for protected-class members.
In plain language: Records the employer's legal name, address, EIN or contractor ID, the establishment or division being analyzed, and the specific date range the data covers.
Employer: [LEGAL ENTITY NAME] | EIN: [XX-XXXXXXX] | Establishment: [LOCATION / DIVISION] | Reporting Period: [START DATE] through [END DATE].
Common mistake: Using a trade name instead of the registered legal entity name. Mismatches between the worksheet and official filings create reconciliation problems during audits and can invalidate the document as supporting evidence.
In plain language: Defines each protected-class category being tracked — race, ethnicity, sex, age band, disability status, veteran status — with reference to the applicable regulatory standard (EEOC, OFCCP, or equivalent).
Demographic categories used in this worksheet align with EEOC EEO-1 Component 1 definitions: Hispanic or Latino; White (non-Hispanic); Black or African American (non-Hispanic); Asian (non-Hispanic); Native Hawaiian or Other Pacific Islander (non-Hispanic); American Indian or Alaska Native (non-Hispanic); Two or More Races (non-Hispanic); Male; Female.
Common mistake: Creating custom category definitions that do not map to the applicable regulatory standard. Non-standard categories make it impossible to compare internal data against EEOC benchmarks or use the worksheet as evidence in a regulatory proceeding.
In plain language: Captures the total headcount in each job group or decision pool, broken down by each demographic category, for the selected reporting period.
Job Group: [JOB GROUP NAME] | Total Employees: [N] | White (M): [N] | White (F): [N] | Black or African American (M): [N] | Black or African American (F): [N] | [ALL REMAINING CATEGORIES]: [N EACH].
Common mistake: Including employees who were on leave, temporary staff, or contractors in the same headcount as permanent employees without a separate notation. Mixing populations distorts the comparison and can produce misleading adverse impact ratios.
In plain language: Calculates the rate at which each demographic group was selected, promoted, terminated, or otherwise affected by the employment decision under analysis, expressed as a percentage.
Selection Rate = [NUMBER SELECTED FROM GROUP] ÷ [TOTAL APPLICANTS / ELIGIBLE EMPLOYEES IN GROUP] × 100. White Male: [X]%. Black or African American Male: [X]%. [ALL GROUPS]: [X]%.
Common mistake: Rounding percentages before calculating the adverse impact ratio. Premature rounding causes small population groups to produce artificially clean ratios, masking real disparities that would otherwise meet the four-fifths threshold.
In plain language: Compares each group's selection rate to the highest selection rate using the four-fifths rule, and flags whether the ratio indicates adverse impact for each demographic category.
Adverse Impact Ratio = [GROUP SELECTION RATE] ÷ [HIGHEST GROUP SELECTION RATE]. A ratio below 0.80 indicates adverse impact. [GROUP]: [RATIO] — [ADVERSE IMPACT: YES / NO].
Common mistake: Comparing all groups to the overall average rate rather than to the highest-selected group's rate. The four-fifths rule requires comparison to the highest-selected group — using the average systematically understates adverse impact.
In plain language: States the external benchmark data source — census, EEO-1 national aggregates, or O*NET labor market data — and the availability percentage for each demographic group in the relevant labor market.
Availability data source: [U.S. Census ACS / EEO-1 Aggregate Data / STATE WORKFORCE COMMISSION] for [GEOGRAPHIC AREA], [YEAR]. Availability — [GROUP]: [X]% of qualified labor market.
Common mistake: Using a national availability figure for a role that realistically draws from a local or regional labor pool. A national benchmark for a warehouse supervisor role in a rural county will systematically misrepresent underutilization.
In plain language: Compares current internal representation to external availability and identifies any utilization gap — where a group is underrepresented relative to their labor market availability — and documents any placement goals set to address the gap.
Group: [PROTECTED CLASS] | Internal Representation: [X]% | Labor Market Availability: [X]% | Utilization Gap: [+/- X percentage points] | Placement Goal: [X]% by [DATE], if applicable.
Common mistake: Treating a placement goal as a quota. Placement goals are aspirational targets — labeling them as quotas or hard minimums creates legal exposure under Title VII and equivalent statutes in most jurisdictions.
In plain language: A written section where the preparer documents the conclusions drawn from the quantitative analysis, notes any mitigating or explanatory factors, and records recommended corrective actions.
Summary of Findings: The analysis identified an adverse impact ratio of [X] for [GROUP] in the [JOB TITLE / DECISION TYPE] category for the period [DATE RANGE]. [EXPLANATORY FACTOR, IF ANY]. Recommended action: [CORRECTIVE ACTION / NO ACTION REQUIRED].
Common mistake: Leaving the narrative section blank or inserting a boilerplate 'no issues found' statement without running the underlying calculations. A blank or cursory narrative undermines the document's value as a compliance record and may suggest the analysis was not actually performed.
In plain language: States the confidentiality classification of the worksheet — typically attorney-client privileged or work-product protected when prepared in anticipation of litigation — and restricts access to named recipients.
CONFIDENTIAL — ATTORNEY-CLIENT PRIVILEGE / WORK PRODUCT. This document was prepared at the direction of [ATTORNEY NAME / LAW FIRM] in anticipation of litigation or legal advice. Distribution is restricted to: [LIST OF RECIPIENTS].
Common mistake: Circulating the worksheet to business managers or HR generalists without a privilege header when it was prepared under legal direction. Broad distribution can waive attorney-client privilege, making the document and its findings discoverable in litigation.
In plain language: A signed attestation by the preparer confirming the accuracy and completeness of the data, the methodology used, and compliance with the applicable regulatory standard.
I certify that the data and calculations contained in this worksheet are accurate and complete to the best of my knowledge and were prepared in accordance with [EEOC UNIFORM GUIDELINES / OFCCP AAP REQUIREMENTS / APPLICABLE STANDARD]. Prepared by: [NAME] | Title: [TITLE] | Date: [DATE] | Signature: _______________.
Common mistake: Having a junior HR analyst sign the certification without managerial review. If the data is later found to contain errors, an unsigned or improperly authorized certification removes a layer of accountability and can expose the preparer personally.
Determine whether the worksheet covers hiring, promotion, termination, compensation, or another HR decision. Define the job group, reporting period, and the regulatory standard you are complying with — EEOC, OFCCP, or a state-level equivalent.
💡 Document the purpose before entering any data. If the worksheet is prepared at an attorney's direction in anticipation of litigation, note that in the privilege designation block before sharing it with anyone.
Fill in the legal entity name, EIN or contractor registration number, the specific establishment or division, and the exact start and end dates of the reporting period.
💡 Match the entity name and EIN exactly to your EEOC or OFCCP registration to prevent reconciliation issues during an audit.
Select the demographic categories that match the regulatory framework you are working under. For EEOC filings, use the seven EEO-1 race/ethnicity categories and binary sex categories. For OFCCP AAPs, add disability and protected veteran status.
💡 If your workforce data was collected using older category labels, document the mapping between your internal codes and the current regulatory standard in a footnote.
For each job group in scope, enter the total population and the breakdown by each demographic category. Keep permanent employees, temporary staff, and contractors in separate rows unless the analysis specifically includes all populations.
💡 Pull headcount from a single authoritative source — typically your HRIS as of the snapshot date — and record the data source and extraction date in the notes column.
For each demographic group, divide the number selected by the total eligible population to get the selection rate. Then divide each group's rate by the highest group's rate to produce the adverse impact ratio. Flag any ratio below 0.80.
💡 Carry selection rates to at least four decimal places before calculating ratios to avoid rounding errors that mask real disparities in small-population job groups.
Record the external availability data source, the geographic scope, the data year, and the availability percentage for each demographic group. Calculate the utilization gap by subtracting internal representation from external availability.
💡 Use the most granular geographic and occupational benchmark available — a county-level O*NET estimate is more defensible than a national census figure for most roles.
Summarize what the quantitative analysis found for each demographic group, note any mitigating factors — small sample size, pipeline constraints — and document recommended actions. Be specific about job group, ratio, and date range.
💡 Write the narrative as if an auditor who has never seen the data will read it in two years. Specificity now prevents ambiguity in litigation or regulatory review later.
Have the analysis reviewed by a senior HR leader or employment counsel before certification. The preparer should sign and date the certification block, and an authorized manager or attorney should co-sign if the document is intended for regulatory submission or litigation support.
💡 Store the signed original in a secure, access-controlled location and retain it for at least five years — or longer if litigation is pending or reasonably anticipated.
A Worksheet Demographic Comparison is a structured document used to record and compare the demographic composition of a workforce, candidate pool, or other employment group across protected-class categories such as race, sex, age, and disability status. It supports adverse impact analyses, affirmative action plan preparation, EEO-1 filings, pay equity reviews, and regulatory audit responses. The document is typically treated as a legal compliance record and, when prepared under attorney direction, may qualify for attorney-client privilege protection.
Federal contractors with 50 or more employees and contracts of $50,000 or more are required to maintain affirmative action plans that include demographic utilization analyses under OFCCP regulations. Employers with 100 or more employees must file EEO-1 reports annually. Beyond mandatory filers, any employer facing an EEOC charge, preparing for litigation, or conducting a proactive pay equity or hiring audit should maintain a current demographic comparison worksheet as part of their compliance documentation.
The four-fifths rule is the EEOC's practical guideline for identifying adverse impact: if the selection rate for a protected group is less than 80% of the rate for the highest-selected group, adverse impact is indicated. The worksheet calculates each group's selection rate, identifies the highest-selected group, and divides all other rates by that figure to produce an adverse impact ratio. Any ratio below 0.80 is flagged for further review and documented in the narrative findings section.
It can be, depending on how it was created and distributed. When prepared at the express direction of outside or in-house counsel in anticipation of litigation or to obtain legal advice, the worksheet may qualify for attorney-client privilege or work-product protection. However, privilege is easily waived by distributing the document to parties outside the legal team — such as HR generalists or business managers — without a clear privilege designation and access restriction. Consult employment counsel before circulating any completed demographic analysis.
Federal contractors subject to OFCCP requirements must update their affirmative action plan — including utilization analyses — annually. Employers not subject to OFCCP should update the worksheet any time a significant employment decision is made (a large hiring cohort, a reduction in force, a promotion cycle), and at least annually as part of an EEO compliance calendar. The availability benchmark data should be refreshed at least every three years or after a material change in the relevant labor market.
Adverse impact refers to a facially neutral employment practice — a selection test, a degree requirement, a physical standard — that produces a statistically significant disparity in outcomes for a protected group, regardless of intent. Disparate treatment is intentional discrimination: treating a member of a protected class differently from similarly situated employees because of their protected characteristic. A demographic comparison worksheet primarily measures adverse impact using selection rate ratios; evidence of disparate treatment typically requires additional investigation into individual employment decisions.
Small employers can and should use a demographic comparison worksheet, though their legal obligations differ. Employers with fewer than 15 employees are generally not covered by Title VII, the ADA, or the ADEA at the federal level, but state and local laws often apply at lower thresholds. Any employer conducting a reduction in force, facing an EEOC charge, or evaluating pay equity should complete a demographic analysis regardless of size. The four-fifths rule has limited statistical power with very small populations, so small employers should note sample-size limitations in the narrative findings section.
The most widely accepted sources in US affirmative action practice are the US Census Bureau's American Community Survey occupation and industry tables, EEO-1 national or metro aggregate data published by the EEOC, and O*NET labor market information. For the UK and EU, national statistics office labor force surveys and the relevant national equality body data are standard. Choose the most geographically specific source available for the realistic recruiting area of each job group, and document the source name, geographic scope, and data year directly on the worksheet.
A completed worksheet that identifies adverse impact or underutilization does not, by itself, create legal liability — it is evidence of good-faith compliance analysis. The risk arises when findings are ignored and the same disparities persist, or when the worksheet is distributed without privilege protection and later becomes discoverable in litigation. Conducting the analysis under attorney direction, restricting distribution, and acting on the findings with documented corrective measures is the standard practice recommended by employment counsel to manage this risk.
The EEO-1 Report is a mandatory federal filing submitted annually to the EEOC that records workforce composition by race, ethnicity, sex, and job category. The Worksheet Demographic Comparison is the internal analytical tool used to prepare, verify, and interpret that data before submission. The EEO-1 is the regulatory output; the worksheet is the working document behind it.
An Adverse Impact Analysis Worksheet focuses specifically on selection rate ratios for a single employment decision — such as one hiring cycle or one promotion cohort. The Demographic Comparison Worksheet is broader, covering overall workforce composition, labor market benchmarking, utilization gaps, and placement goals across multiple job groups and time periods. Use the adverse impact worksheet for a single-decision audit; use the demographic comparison worksheet for ongoing compliance documentation.
A Pay Equity Analysis examines whether compensation differs statistically across demographic groups for employees in comparable roles, controlling for legitimate pay factors. The Demographic Comparison Worksheet examines representation and selection rates — who gets hired, promoted, or terminated. Both are required components of a comprehensive OFCCP affirmative action plan, but they answer different compliance questions.
A Workforce Diversity Report is typically a narrative document presenting demographic trends for public or board-level audiences — often published as part of an ESG or CSR disclosure. The Demographic Comparison Worksheet is an internal compliance and legal record with precise calculations, regulatory category definitions, and a certification signature. The report communicates progress; the worksheet documents the legal analysis behind it.
Technical hiring pipelines often show documented demographic disparities at the screening and offer stages — the worksheet captures funnel-stage selection rates by group to identify where drop-off occurs.
FINRA-regulated firms and federal contractor banks use demographic comparison worksheets as the quantitative backbone of annual AAP submissions and to defend against CFPB or EEOC lending-related discrimination inquiries.
Hospital systems and large healthcare employers use the worksheet to analyze promotion and pay-band disparities across clinical and administrative job groups, often in response to state pay transparency mandates.
Federal contractor manufacturers under OFCCP jurisdiction are required to run annual utilization analyses by job group — the worksheet structures this analysis and provides the paper trail for on-site compliance reviews.
Title VII of the Civil Rights Act, the ADA, the ADEA, and Executive Order 11246 collectively govern demographic analysis obligations for US employers. OFCCP requires federal contractors with 50+ employees to maintain written AAPs including utilization analyses. The EEOC's Uniform Guidelines on Employee Selection Procedures formalize the four-fifths rule as the primary adverse impact standard. California, Illinois, New York, and Colorado have enacted additional pay transparency and demographic reporting requirements that may mandate more frequent or detailed analyses.
The Employment Equity Act requires federally regulated employers with 100 or more employees to conduct annual workforce analyses and file employment equity reports comparing internal representation against external availability for four designated groups: women, Indigenous peoples, persons with disabilities, and members of visible minorities. Provincially regulated employers in Ontario, Quebec, and British Columbia face parallel requirements under provincial human rights codes. The Canadian Human Rights Commission publishes standardized availability data and analysis methodology for employers subject to the Act.
The Equality Act 2010 prohibits employment discrimination across nine protected characteristics. Employers with 250 or more employees must publish gender pay gap data annually under the Gender Pay Gap Regulations 2017. While ethnicity pay gap reporting is not yet mandatory, the Government Equalities Office has issued guidance strongly encouraging it. Demographic comparison worksheets prepared in connection with grievance or tribunal proceedings may be protected as litigation-privilege documents under English law, provided they were created for the dominant purpose of litigation.
The EU Pay Transparency Directive (2023/970), which member states must transpose by June 2026, requires employers with 100 or more employees to report pay gaps by sex and, where a gap of 5% or more exists, to conduct a joint pay assessment that includes demographic comparison analysis. GDPR strictly governs the collection and processing of demographic data including race, ethnic origin, and health status as special-category data under Article 9 — explicit consent or a specific legal basis is required. Member state implementations vary: France, Germany, and the Netherlands have additional national equality reporting obligations.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | HR managers running routine annual adverse impact analyses or preparing EEO-1 data for employers not subject to OFCCP | Free | 2–4 hours per job group |
| Template + legal review | Federal contractors preparing OFCCP affirmative action plans, employers responding to an EEOC charge, or any organization where adverse impact has been identified | $500–$2,500 for employment counsel review | 1–3 business days |
| Custom drafted | Employers in active litigation, those undergoing an OFCCP compliance review, or organizations with complex multi-establishment or multi-country workforce structures | $3,000–$15,000+ depending on scope and legal complexity | 2–6 weeks |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start free · No credit card required
