Supply Chain & InventoryFree worksheetPDF, Excel, Word exportManufacturingAfrica

Local Content Supplier Tracker Worksheet

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.

Download:

Supplier	Spend category	Supplier origin	Annual spend	Local value share (%) (%)	Local content value	Imported value
					$294,000	$126,000
					$76,500	$8,500
					$62,000	$248,000
					$0	$260,000
					$120,000	$0
					$28,000	$0

Total spend

$1,223,000

Total local content value

$580,500

Total imported value

$642,500

Local content percentage

47.5%

Largest single supplier spend

$420,000

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.

Report local content from your ERP

Optional: we can help add supplier origin attributes and a report.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

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.

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

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

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

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.

Frequently Asked Questions

How do I choose the local value share?

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?

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?

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

Can I export the table?

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

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

Talk to an Expert Explore More Free Tools

Related Tools

Country & Tax

More Supply Chain & Inventory tools

See all

Back to All Tools