# Conflict Minerals CMRT Supplier Tracking Worksheet > Source: https://netray.co/tools/conflict-minerals-cmrt-supplier-tracking-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track which suppliers returned a Conflict Minerals Reporting Template, which version, and what share of their smelters are RMAP conformant. ## Category compliance-legal ## Industry Electronics Manufacturing ## Audience - Compliance engineer - Supplier quality - Procurement ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Supplier **Key:** supplier **Type:** text #### Part or commodity **Key:** part **Type:** text #### 3TG in scope **Key:** mineral **Type:** select **Options:** - Tin - Tantalum - Tungsten - Gold - Multiple 3TG - None declared #### CMRT status **Key:** status **Type:** select **Options:** - Received - Requested - Overdue - Expired - Not applicable #### CMRT version **Key:** version **Type:** text #### Smelters listed **Key:** smelters **Type:** number #### RMAP conformant or active **Key:** conformant **Type:** number #### Conformant share **Key:** pct **Type:** number **Expr:** if(gt(smelters,0), conformant / smelters * 100, 0) **Format:** percent #### Follow-up due **Key:** due **Type:** date **Rows:** **Supplier:** Northfield Connectors **Part:** Board-to-board connectors **Mineral:** Multiple 3TG **Status:** Received **Version:** 6.4 **Smelters:** 42 **Conformant:** 38 **Due:** 2027-03-31 **Supplier:** Apex Capacitor Works **Part:** Tantalum capacitors **Mineral:** Tantalum **Status:** Received **Version:** 6.3 **Smelters:** 14 **Conformant:** 14 **Due:** 2027-03-31 **Supplier:** Lakeshore Solder Alloys **Part:** SAC305 solder wire **Mineral:** Tin **Status:** Overdue **Smelters:** 0 **Conformant:** 0 **Due:** 2026-11-15 **Supplier:** Meridian Precision Plating **Part:** Gold plating service **Mineral:** Gold **Status:** Expired **Version:** 5.12 **Smelters:** 9 **Conformant:** 6 **Due:** 2026-12-01 **Supplier:** Harbor Machined Parts **Part:** Housings, aluminium **Mineral:** None declared **Status:** Not applicable **Smelters:** 0 **Conformant:** 0 **Due:** 2027-06-30 **Totals:** #### Total smelters listed **Key:** smelters **Agg:** sum **Format:** integer #### Total conformant **Key:** conformant **Agg:** sum **Format:** integer #### Suppliers tracked **Key:** supplier **Agg:** count **Format:** integer **Summary:** #### Overall conformant smelter share **Key:** overall_pct **Expr:** if(gt(sum_smelters,0), sum_conformant / sum_smelters * 100, 0) **Format:** percent **Primary:** true **Description:** Conformant or active smelters as a share of all smelters listed across received CMRTs. **Notes:** Use one row per supplier and commodity. Conformant means conformant or active on the RMI Responsible Minerals Assurance Process list at the time of your review. Always re-check the smelter list before relying on it for a Form SD filing. ## Content **Intro:** A conflict minerals program lives or dies on follow-up: who has sent a CMRT, which version, and whether their smelters are on the right lists. This worksheet gives you a single place to track it and export a clean record. **Sections:** #### How to use the worksheet **Body:** Add one row per supplier and covered commodity. Pick the 3TG metal in scope (tin, tantalum, tungsten, gold), set the CMRT status, and record the template version the supplier used. Enter the number of smelters or refiners the supplier listed and how many are conformant or active in the RMAP. The sheet computes a conformant share per row and an overall share. Set a follow-up date for anything overdue or expired, then export to Excel to share with procurement or your reporting team. **Bullets:** - Start with every supplier whose parts may contain tin, tantalum, tungsten or gold - Mark suppliers with no declared 3TG so the decision is documented - Keep the CMRT version, since older versions miss newer questions - Review expired or overdue rows monthly during the reporting season #### The method behind it **Body:** Section 1502 of the Dodd-Frank Act requires SEC registrants whose products contain necessary 3TG to perform a reasonable country of origin inquiry and, where needed, due diligence, then file Form SD by 31 May each year. Most companies use the RMI Conflict Minerals Reporting Template to collect supplier declarations and smelter lists, and align due diligence to the OECD guidance. The smelter or refiner is the choke point, which is why the conformant share is the key number. Customers outside the SEC population often ask for the same CMRT through their supply chain. #### Reading the result and common mistakes **Body:** A high overall share is good, but a single supplier with zero smelters listed or a declaration of unknown is a gap, not a pass. Look at each low row and decide whether to escalate, request a corrected CMRT, or switch source. Treat the conformant share as a monitoring metric, not a compliance verdict. **Bullets:** - Accepting a blank or partly completed CMRT as received - Tracking the company level only when the answer is product specific - Not re-checking smelter status after the template date - Forgetting 3TG in plating chemicals, solder and alloys **Cta:** If your supplier declarations live in an ERP vendor record and a shared drive, we can help pull them into one governed view that your team queries on-prem. **Faq:** #### What is a CMRT? **Answer:** The Conflict Minerals Reporting Template is a standard spreadsheet maintained by the Responsible Minerals Initiative. A supplier uses it to declare whether tin, tantalum, tungsten or gold is in their products and to list the smelters or refiners in their supply chain. #### Who has to file Form SD? **Answer:** Companies that file reports with the SEC and manufacture or contract to manufacture products where necessary 3TG are present must conduct the inquiry and file Form SD each year. Suppliers outside the SEC population are usually asked for a CMRT by their customers. #### What does RMAP conformant mean? **Answer:** It means the smelter or refiner has undergone an audit under the Responsible Minerals Assurance Process and meets the standard. Active means it has committed to an audit. Check the current RMI lists, since status changes over time. #### Does this replace the CMRT itself? **Answer:** No. The CMRT is the supplier declaration. This worksheet is your internal tracker that records who responded, which version, and the quality of the smelter data, so you can chase gaps and keep an audit trail. ## Search terms conflict minerals CMRT worksheet, CMRT tracking spreadsheet, 3TG supplier tracking template, conflict minerals supplier survey tracker, RMAP conformant smelter tracking, Dodd-Frank 1502 supplier due diligence, Form SD conflict minerals worksheet, CMRT excel tracker --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json