# Local Content Supplier Tracker Worksheet

> Source: https://netray.co/tools/local-content-supplier-tracker-worksheet-africa
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable worksheet that tallies spend with local, regional and imported suppliers and reports the local content percentage of your purchases.

## Category

supply-chain

## Region

Africa

## Industry

Manufacturing

## Audience

- Procurement manager
- Supply chain manager
- Compliance officer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### Spend category

**Key:** category

**Type:** select

**Options:**

- Raw materials
- Packaging
- Components
- Services
- Logistics
- MRO

#### Supplier origin

**Key:** origin

**Type:** select

**Options:**

- Local
- Regional African
- Imported

#### Annual spend

**Key:** spend

**Type:** number

**Format:** currency

#### Local value share (%)

**Key:** local_pct

**Type:** number

**Unit:** %

**Help:** Share of the supplied value created locally, for example local processing or labour

#### Local content value

**Key:** local_val

**Type:** number

**Expr:** spend * local_pct / 100

**Format:** currency

#### Imported value

**Key:** gap

**Type:** number

**Expr:** spend - spend * local_pct / 100

**Format:** currency

**Rows:**

**Supplier:** Local steel stockist

**Category:** Raw materials

**Origin:** Local

**Spend:** 420000

**Local pct:** 70

**Supplier:** Corrugated box maker

**Category:** Packaging

**Origin:** Local

**Spend:** 85000

**Local pct:** 90

**Supplier:** Regional resin trader

**Category:** Raw materials

**Origin:** Regional African

**Spend:** 310000

**Local pct:** 20

**Supplier:** Asian electronics distributor

**Category:** Components

**Origin:** Imported

**Spend:** 260000

**Local pct:** 0

**Supplier:** Local haulier

**Category:** Logistics

**Origin:** Local

**Spend:** 120000

**Local pct:** 100

**Supplier:** Calibration service

**Category:** Services

**Origin:** Local

**Spend:** 28000

**Local pct:** 100

**Totals:**

#### Total spend

**Key:** spend

**Agg:** sum

**Format:** currency

#### Total local content value

**Key:** local_val

**Agg:** sum

**Format:** currency

#### Total imported value

**Key:** gap

**Agg:** sum

**Format:** currency

**Summary:**

#### Local content percentage

**Key:** lc_pct

**Expr:** sum_local_val / sum_spend * 100

**Format:** percent

**Primary:** true

#### Largest single supplier spend

**Key:** top

**Expr:** max_spend

**Format:** currency

**Notes:** Definitions of local content differ by country and sector. Use the share that your regulator or customer defines, and keep supporting evidence such as supplier declarations.

## Content

**Intro:** Governments and large customers across Africa increasingly ask manufacturers for local content or local procurement figures. This worksheet gives procurement a way to calculate that percentage from spend data, supplier by supplier.

**Sections:**

#### How to use the worksheet

**Body:** List suppliers with annual spend, spend category and origin. For each, estimate the share of the supplied value that was created locally, which can include local processing, labour or packaging. The worksheet multiplies that share by spend and totals it. Export the result to Excel to share with auditors, customers or your sustainability team.

**Bullets:**

- Start with the top 20 suppliers by spend
- Ask suppliers for a local value declaration
- Keep the estimate method consistent each year
- Separate services from goods if your regulator does

#### Method

**Body:** Local content percentage is local value divided by total spend. The share assigned to each supplier is the key judgement: a local stockist reselling imported steel adds less local value than a local fabricator who processes it. Use supplier declarations or a documented rule of thumb, and apply it consistently so year over year comparisons are valid.

#### Reading the result

**Body:** In the sample data, local content is about 54 percent of the purchased spend. The imported components and resin lines are the biggest contributors to the gap, so they point to the next sourcing opportunity. Use the imported value column to rank where local substitution would move the percentage most.

#### Common mistakes

**Body:** Common mistakes are counting any local trader as 100 percent local, mixing currencies without conversion, and relying on supplier addresses instead of value added. In an ERP, add a supplier origin attribute and a local value share field so the report can be produced from purchase order history rather than rebuilt in a spreadsheet.

**Cta:** If you want local content reporting produced from purchase order data in your ERP, Netray can help design the supplier attributes and report.

**Faq:**

#### How do I choose the local value share?

**Answer:** Use supplier declarations where available, or a documented estimate of the portion of cost created in country. Keep the rule consistent and written down so it can be defended.

#### Does this match a legal definition?

**Answer:** Not necessarily. Local content definitions vary by country and sector. Replace the method with the definition your regulator or customer uses.

#### Can I use another currency?

**Answer:** Enter all spend in a single currency. Convert beforehand using an agreed rate so the percentage is not distorted.

#### Can I export the table?

**Answer:** Yes, to Excel, CSV, PDF and Word directly from the page.

## Search terms

local content tracker excel, local content percentage calculator, local supplier spend tracker, africa local content requirements manufacturing, supplier origin spend analysis, localisation tracker template

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