Blog · Procurement and supply chain · Procurement
Supplier diversity analytics compares purchasing by supplied, verified classifications. Work through spend reconciliation, overlapping classifications, business-unit comparisons, and the treatment of missing or expired evidence.
Supplier diversity analytics compares spend by supplied, verified supplier classifications while showing how much purchasing remains unclassified. Start with reconciled purchases and a dated status register, then compare the results by category and business unit. The arithmetic can establish spending shares; it cannot determine a supplier's characteristics or certify its status.
The procurement program owner decides which supplied classifications belong in the report, what evidence is accepted, and whether status is evaluated at transaction date or at a stated reporting cutoff. Record that policy beside the figures. Do not quietly switch between these approaches when a certificate expires.
Program names matter. The SBA's business certification guidance describes distinct programs and says each has its own standards and certification process. Keep the issuing organization and exact program with the record rather than treating all labels as interchangeable. An internal purchasing report should not be presented as a federal compliance report merely because some labels resemble federal program names.
Use only supplied, verified classifications. Never infer ownership, disability, ethnicity, veteran status, or other characteristics from a supplier name, address, photograph, product category, or website. If evidence is absent, the correct analytical result is an unknown classification.
The purchasing file should contain invoice line ID, supplier ID, posting date, net amount, currency, category, and business unit. Net amounts include the credit treatment defined for the report. Choose an accounting scope, such as posted purchasing excluding tax, and reconcile that scope before analyzing classifications.
The classification register needs supplier ID, classification, program, source reference, verified date, effective date, expiry date where applicable, and review status. A supplier can have multiple supported classifications, so preserve those records without repeating invoice lines in the overall spend total.
Resolve aliases through a stable supplier ID. The supplier name normalization guide explains that matching task. Where a parent company and subsidiary have different status evidence, do not transfer the parent's status to the subsidiary without supplied support and the program owner's decision.
| Register | Row represents | Essential check |
|---|---|---|
| Purchasing | One net invoice line | Unique invoice line and reconciled amount |
| Classifications | One supplier classification and validity record | Supported status for the chosen reporting date |
| Supplier reference | One legal purchasing entity | No ambiguous ID mapping |
| Exceptions | One unresolved record | Named owner and reason for exclusion or unknown status |
The owner of classifications is accountable for evidence. Finance owns the spending reconciliation. Category managers use the results to decide which records need follow-up and where sourcing activity needs review.
A US distributor reports posted purchasing for one quarter in USD. Its program owner supplied the current register below. A and B are illustrative labels for two classifications already verified under that company's documented program; they do not stand for an inferred characteristic.
The reviewed supplier with no qualifying classification has a current supplied record explicitly supporting that treatment. It has not been assigned that outcome merely because a certificate was missing. The expired record is unresolved under the company's stated cutoff-date policy.
| Supplier ID | Category | Business unit | Net spend (USD) | Supplied reporting status | Qualifying classifications | Qualifying flag |
|---|---|---|---|---|---|---|
| S1 | Packaging | East | 120,000 | Current and verified | A | 1 |
| S2 | Facilities | West | 80,000 | Current and verified | A and B | 1 |
| S3 | Facilities | East | 50,000 | Current review; no qualifying classification recorded | None | 0 |
| S4 | Packaging | West | 30,000 | Expired evidence; unresolved | Unknown | 0 |
| S5 | Facilities | East | 20,000 | Missing evidence | Unknown | 0 |
| Total | 300,000 |
Qualifying spend share = Net spend with at least one verified qualifying classification / Total in-scope net spend
Unknown spend share = Net spend with unresolved classification / Total in-scope net spend
Qualifying spend is $120,000 + $80,000 = $200,000. Its share is 200,000 / 300,000 = 66.7%, rounded to one decimal. Unknown spend is $30,000 + $20,000 = $50,000, or 16.7%. The reviewed group without a qualifying classification is also $50,000, or 16.7%.
The dollar identity proves completeness: $200,000 + $50,000 + $50,000 = $300,000. The displayed rounded percentages do not add exactly to 100%; the unrounded shares do. Use the dollar reconciliation as the primary check.
Classification coverage is a separate measure. Here it means spending with a resolved current reporting status, including the reviewed group without a qualifying classification. That is (200,000 + 50,000) / 300,000 = 83.3%, rounded to one decimal.
Excluding unknowns would produce 200,000 / 250,000 = 80.0%. That answers the narrower question of qualifying spend among resolved records. It should not replace the all-spend share of 66.7% without an explicit denominator label.
The classification views overlap:
| View | Included suppliers | Spend (USD) | Share of all spend |
|---|---|---|---|
| Classification A | S1 and S2 | 200,000 | 66.7% |
| Classification B | S2 | 80,000 | 26.7% |
| At least one qualifying classification | S1 and S2, counted once | 200,000 | 66.7% |
Adding A and B would give $280,000 and count S2's $80,000 twice. The overall figure uses the union of supported classifications. Classification-specific views can remain overlapping if their labels say so.
For a worksheet check, use the displayed table in columns A through G, with headers in row 1. Spend is in D2:D6 and the supplied, validated qualifying flag is in G2:G6. The share formula is:
=SUMIFS(D2:D6,G2:G6,1)/SUM(D2:D6)
Microsoft's SUMIFS documentation explains summing values that meet criteria. The flag represents at least one qualifying classification, rather than the number of classifications. Unresolved records have a zero qualifying flag here while retaining their separate unknown status; that zero does not establish a nonqualifying classification. Covirage is not affiliated with Microsoft.
The same supplier rows produce these business-unit results. Calculate shares from each unit's own denominator, retaining the overall dollar tie.
| Business unit | Total spend (USD) | Qualifying spend (USD) | Unknown spend (USD) | Qualifying share | Unknown share |
|---|---|---|---|---|---|
| East | 190,000 | 120,000 | 20,000 | 63.2% | 10.5% |
| West | 110,000 | 80,000 | 30,000 | 72.7% | 27.3% |
| Total | 300,000 | 200,000 | 50,000 | 66.7% | 16.7% |
Shares are rounded to one decimal, with totals calculated from dollars rather than averaged percentages. West's higher qualifying share sits beside a higher unknown share; resolving its expired evidence is a separate action from changing purchasing.
Category totals offer another view. Packaging has $150,000 total spend, including $120,000 qualifying and $30,000 unknown. Facilities also has $150,000 total spend, including $80,000 qualifying and $20,000 unknown. These views tie to the same $300,000 overall scope.
Use the supplier management review workflow to assign follow-up and retain evidence. Classification is one reporting dimension; supplier risk analytics addresses a different purchasing question and should use its own evidence rather than treating a classification as a risk proxy.
Bring a sample of your own purchasing export and supplied, verified classification register; Covirage maps the columns, and its tools compute and check the spending comparisons. The external AI model explains the figures with every result traced to its rows, using the classifications you supplied. Create a free Covirage account, which takes about a minute, and set up your business with your own data.
See Covirage for procurement teams for the purchasing context.
Use net purchasing records with supplier IDs, dates, categories, business units, and currency, plus a supplied classification register. That register should identify the evidence, verification date, validity period, and program definition supporting each reported status.
Keep missing, expired, disputed, or unmatched classifications in a disclosed unknown group until the program owner resolves them. Do not infer ownership or other characteristics from a supplier's name, location, website, or purchasing category.
Yes, if the supplied evidence supports each classification under the reporting program. Category views may overlap, but the overall qualifying spend total should count each purchase once. Clearly label overlapping category totals so readers do not add them together.
No. A report uses the classifications and supporting evidence supplied by the business. The program owner or relevant certifying organization establishes status under its rules. A computed purchasing share does not establish eligibility for a certification or contracting program.