# B-BBEE Scorecard Worksheet: Track Points per Element and Find Your Contributor Level

> Source: https://netray.co/tools/b-bbee-scorecard-points-level-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Record points scored against each B-BBEE scorecard element, see the gap to maximum, and read the indicative contributor level and procurement recognition.

## Category

compliance-legal

## Region

South Africa

## Industry

Manufacturing

## Audience

- Compliance officer
- Financial controller
- Procurement manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Scorecard element

**Key:** element

**Type:** text

#### Maximum points

**Key:** maxpts

**Type:** number

**Format:** number

#### Points scored

**Key:** score

**Type:** number

**Format:** decimal

#### Gap to maximum

**Key:** gap

**Type:** number

**Expr:** maxpts - score

**Format:** decimal

#### Achievement

**Key:** pct

**Type:** number

**Expr:** if(gt(maxpts,0), score / maxpts * 100, 0)

**Format:** percent

#### Action owner

**Key:** owner

**Type:** text

**Rows:**

**Element:** Ownership

**Maxpts:** 25

**Score:** 12.5

**Owner:** Company secretary

**Element:** Management control

**Maxpts:** 19

**Score:** 9

**Owner:** HR director

**Element:** Skills development

**Maxpts:** 20

**Score:** 11

**Owner:** Training manager

**Element:** Enterprise and supplier development

**Maxpts:** 40

**Score:** 18

**Owner:** Procurement manager

**Element:** Socio-economic development

**Maxpts:** 5

**Score:** 5

**Owner:** Finance director

**Totals:**

#### Total available points

**Key:** maxpts

**Agg:** sum

**Format:** number

#### Total points scored

**Key:** score

**Agg:** sum

**Format:** decimal

**Summary:**

#### Overall achievement

**Key:** overall_pct

**Expr:** if(gt(sum_maxpts,0), sum_score / sum_maxpts * 100, 0)

**Format:** percent

#### Indicative contributor level (9 means non-compliant)

**Key:** level

**Expr:** if(gte(sum_score,100),1,if(gte(sum_score,95),2,if(gte(sum_score,90),3,if(gte(sum_score,80),4,if(gte(sum_score,75),5,if(gte(sum_score,70),6,if(gte(sum_score,55),7,if(gte(sum_score,40),8,9))))))))

**Format:** integer

**Primary:** true

#### Procurement recognition for your customers

**Key:** recognition

**Expr:** if(gte(sum_score,100),135,if(gte(sum_score,95),125,if(gte(sum_score,90),110,if(gte(sum_score,80),100,if(gte(sum_score,75),80,if(gte(sum_score,70),60,if(gte(sum_score,55),50,if(gte(sum_score,40),10,0))))))))

**Format:** percent

**Primary:** true

**Notes:** Uses the generic scorecard weightings and level thresholds from the Amended Codes of Good Practice. Qualifying small enterprises and exempted micro enterprises use different rules, and priority elements have sub-minimum targets that can lower the level by one. Only a SANAS-accredited verification agency can issue a certificate.

## Content

**Intro:** A B-BBEE scorecard is a points exercise: five elements, a maximum of 109 points on the generic scorecard, and a contributor level that your customers use in procurement. This worksheet lets you track points element by element and see the indicative level before you pay for verification.

**Sections:**

#### How to use the worksheet

**Body:** Replace the sample scores with your latest verified or estimated points for each element. Use the action owner column to assign who closes each gap. The sheet calculates the gap to maximum, the achievement percentage, total points, an indicative contributor level and the procurement recognition percentage. Add rows if you track sub-elements such as preferential procurement or skills spend separately.

**Bullets:**

- Update scores after each verification cycle.
- Add sub-element rows for finer tracking.
- Export to Excel for the board pack.

#### The scorecard behind it

**Body:** The generic scorecard weights ownership at 25 points, management control at 19, skills development at 20, enterprise and supplier development at 40 and socio-economic development at 5, which totals 109 including bonus points. Levels run from 1 for 100 or more points down to 8 for 40 to under 55, and below 40 is non-compliant. Recognition for customers' procurement spend ranges from 135% at level 1 to 10% at level 8.

#### Reading the result

**Body:** Look first at the largest gaps in points, not in percentage. Enterprise and supplier development carries 40 points and is often where manufacturers gain most through local supplier spend. Remember that the priority elements ownership, skills development and enterprise and supplier development have sub-minimum thresholds. Missing them can reduce the level by one even if total points are high.

**Bullets:**

- Prioritise the element with the biggest point gap.
- Check sub-minimums before celebrating a level.
- Tie procurement targets to your ERP supplier master.

#### Common mistakes

**Body:** Companies often assume they use the generic scorecard when their turnover places them in the exempted micro enterprise or qualifying small enterprise category with different rules. Others rely on estimates for supplier B-BBEE status without current certificates or affidavits. Keep evidence for every point you claim, because verification reviews documents, not intentions.

**Cta:** Netray can report supplier spend by B-BBEE level straight from your ERP vendor master and purchase history, so procurement points are tracked in real time.

**Faq:**

#### How many points are on the generic B-BBEE scorecard?

**Answer:** The generic scorecard totals 109 points including bonus points: ownership 25, management control 19, skills development 20, enterprise and supplier development 40, and socio-economic development 5.

#### What score gives a level 4 contributor?

**Answer:** A level 4 contributor scores 80 points or more but under 90 on the generic scorecard, which gives customers 100% procurement recognition. Sub-minimum rules on priority elements can still affect the final level.

#### Can I issue my own B-BBEE certificate?

**Answer:** No. Large entities need a certificate from a SANAS-accredited verification agency. Smaller exempted micro enterprises and qualifying small enterprises can use a sworn affidavit under the rules that apply to them.

#### Does this worksheet replace verification?

**Answer:** No. It is a planning tool for tracking points and gaps. Only an accredited agency can verify and certify your actual level.

## Search terms

bbbee scorecard template, b-bbee scorecard excel, bbbee level calculator, bbbee points table, generic scorecard bbbee, bbbee procurement recognition, bbbee scorecard worksheet, contributor level table

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json