# South Africa B-BBEE Supplier Spend Recognition Worksheet > Source: https://netray.co/tools/south-africa-bbbee-supplier-spend-recognition-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer List suppliers, enter spend and B-BBEE recognition percentage, and see recognised spend and the overall ratio against your total procurement. ## Category regional ## Region South Africa ## Audience - Procurement manager - Compliance officer - Buyer ## Tool **Kind:** worksheet **Mode:** editable **Currency:** R **Columns:** #### Supplier **Key:** supplier **Type:** text #### B-BBEE level **Key:** level **Type:** select **Options:** - Level 1 - Level 2 - Level 3 - Level 4 - Level 5 - Level 6 - Level 7 - Level 8 - Non-compliant #### Spend (excl. VAT) **Key:** spend **Type:** number **Format:** currency #### Recognition % **Key:** recog **Type:** number **Unit:** % **Help:** Level 1 = 135, 2 = 125, 3 = 110, 4 = 100, 5 = 80, 6 = 60, 7 = 50, 8 = 10, non-compliant = 0. #### Recognised spend **Key:** recognised **Type:** number **Expr:** spend * recog / 100 **Format:** currency **Rows:** **Supplier:** Cape Steel Distributors **Level:** Level 1 **Spend:** 4200000 **Recog:** 135 **Supplier:** Gauteng Fasteners **Level:** Level 4 **Spend:** 1850000 **Recog:** 100 **Supplier:** Durban Packaging Co **Level:** Level 2 **Spend:** 960000 **Recog:** 125 **Supplier:** Imported Components Agent **Level:** Non-compliant **Spend:** 2300000 **Recog:** 0 **Supplier:** Eastern Cape Logistics **Level:** Level 6 **Spend:** 740000 **Recog:** 60 **Totals:** #### Total measured spend **Key:** spend **Agg:** sum **Format:** currency #### Total recognised spend **Key:** recognised **Agg:** sum **Format:** currency **Summary:** #### Recognised spend as % of total spend **Key:** ratio **Expr:** sum_recognised / sum_spend * 100 **Format:** percent **Primary:** true #### Spend-weighted recognition **Key:** avg_recog **Expr:** sum_recognised / sum_spend * 100 **Format:** percent **Notes:** Recognition percentages follow the generic B-BBEE recognition levels. Sector codes and qualifying small enterprises can differ, and the verification agency decides the final figure. Use this as an internal planning sheet. ## Content **Intro:** Procurement is a large part of the B-BBEE scorecard, and every supplier's recognition level changes how much of your spend counts. This worksheet lets a buyer or compliance officer see recognised spend before the verification agency does. **Sections:** #### How to use it **Body:** Replace the sample suppliers with your own. Pick the level shown on each supplier's valid B-BBEE certificate or sworn affidavit, then enter the recognition percentage that matches the level. Enter spend excluding VAT. The totals and ratio update as you edit, and the Excel export keeps the formulas visible as values for your auditor. **Bullets:** - Keep a copy of each certificate with its expiry date - Update the level when a supplier renews - Add a row for every supplier in the measurement period #### The recognition logic **Body:** A supplier's recognition level multiplies your spend. A Level 1 contributor is recognised at 135%, Level 2 at 125%, Level 3 at 110%, Level 4 at 100%, Level 5 at 80%, Level 6 at 60%, Level 7 at 50%, Level 8 at 10% and a non-compliant contributor at 0%. Recognised spend divided by total measured spend gives the ratio used to compare against the scorecard target. #### Reading the ratio **Body:** A ratio above 100% means your supplier base is more transformed than the baseline. A low ratio shows where to shift spend. In the sample, one large non-compliant import agent pulls the ratio down, which is a typical pattern for manufacturers with import-heavy bills of materials. #### Common mistakes **Body:** Do not apply the percentage to spend that is excluded from measurement, such as certain imports or intercompany purchases defined in the codes. Do not use expired certificates. In your ERP, add the B-BBEE level and expiry to the vendor master so the spend report can be pulled by vendor attribute. **Cta:** If you want vendor level and expiry held in your ERP vendor master with an automatic spend report, we can scope that as a small build. **Faq:** #### Is this the official B-BBEE scorecard? **Answer:** No. It is an internal planning tool for the procurement recognition step. The official scorecard is calculated by a SANAS-accredited verification agency using the sector code that applies to your business. #### Where do I find a supplier's level? **Answer:** On their valid B-BBEE certificate from a verification agency, or a sworn affidavit for exempt micro enterprises and qualifying small enterprises. Certificates have an expiry date, so record it next to the level. #### Should spend include VAT? **Answer:** Normally measured procurement spend is taken excluding VAT. Confirm the treatment with your verification agency, since it depends on the applicable code and the nature of the spend. #### Can I add columns? **Answer:** The columns are fixed in the browser tool, but you can export to Excel and add your own, for example a category or plant column. Keep the level and recognition columns unchanged. ## Search terms bbbee procurement recognition worksheet, bbbee supplier level recognition table, preferential procurement spend calculation, bbbee scorecard procurement excel, supplier bbbee level 135% recognition, total measured procurement spend, bee spend tracker --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json