PFAS Reporting Worksheet
PFAS questions now arrive from customers, regulators and retailers at the same time. This worksheet gives compliance teams a structured inventory of PFAS in purchased parts, with a running annual mass so the scale of exposure is visible.
| Part number | Supplier | PFAS use | PFAS substance | CAS number | Part mass (g) | PFAS concentration (ppm by weight) | Units per year | PFAS per year (g) | |
|---|---|---|---|---|---|---|---|---|---|
75,600 | |||||||||
108,000 | |||||||||
30,000 | |||||||||
94,050 |
Concentration is the PFAS share of the part by weight in parts per million. Request supplier data for each entry and mark unknowns clearly. Reporting definitions and thresholds differ by jurisdiction, so check the current rule before using this for a filing.
Match supplier chemical data to ERP parts
Optional: talk through a private assistant that links supplier declarations to part numbers and volumes.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add a row for each part you know or suspect contains PFAS. Record the substance, CAS number and the concentration your supplier reports in parts per million by weight. Enter the part mass in grams and annual volume. The sheet multiplies these to give grams of PFAS per year per part and in total. Use the example rows as a pattern, then replace them with your own data and export to Excel for supplier follow-up.
- Start with cables, seals, coatings, lubricants and membranes
- Record unknown concentrations as a gap to chase
- Keep the supplier statement date for each row
The method behind it
PFAS are a large family of fluorinated substances, and fluoropolymers such as PTFE, FEP and PVDF are common in electronics and industrial parts. In the United States, TSCA section 8(a)(7) requires reporting of PFAS manufactured or imported since 2011, including as part of articles, subject to the rule's terms and dates. In the EU, restriction proposals under REACH are under discussion. Mass per year is simple arithmetic: part mass times concentration times volume.
Reading the result and common mistakes
The total tells you which parts drive volume, so you can prioritise supplier outreach and substitution. It does not decide whether a duty to report applies. Definitions, exemptions and de minimis rules vary, so use the result as an input to your regulatory review.
- Counting only the polymer and missing processing aids and coatings
- Using percent where parts per million is expected
- Not tracking imported articles in finished goods
- Relying on a verbal supplier answer
Frequently Asked Questions
What does PFAS stand for?
Per- and polyfluoroalkyl substances. They are fluorinated chemicals valued for heat, chemical and water resistance, and many persist in the environment. The exact definition used differs between regulators, so check the rule that applies to you.
Is PTFE a PFAS?
Under broad definitions such as the OECD 2021 definition, fluoropolymers like PTFE are included. Some regulators treat them differently. Confirm how the specific rule you are subject to defines the scope.
How do I get concentrations from suppliers?
Send a supplier survey that asks for the substance, CAS number, concentration range and use for each part. Request a signed declaration and, where needed, analytical test results. Record the date and keep the response with the part record.
Does the worksheet file a report for me?
No. It organises the data and computes annual mass. A regulatory filing needs to follow the specific rule, such as the TSCA reporting form and submission tool, with your legal and compliance review.
If you want PFAS supplier answers matched to ERP part numbers and volumes automatically, we can help build that on your own infrastructure.
Related Tools
Conflict Minerals CMRT Supplier Tracking Worksheet
Track which suppliers returned a Conflict Minerals Reporting Template, which version, and what share of their smelters are RMAP conformant.
Compliance & ContractsRoHS Restricted Substances and Exemptions Reference
Searchable lookup of RoHS 2 substance limits, widely used Annex III exemptions and equipment categories.
Compliance & ContractsREACH SVHC Supplier Declaration Response Template
Fill in a clear supplier declaration that answers a customer's REACH SVHC request with Candidate List version, substances and safe use information.
Compliance & ContractsProp 65 Warning Compliance Checklist
Work through the questions a manufacturer or seller should settle before shipping a product into California.
More Compliance & Contracts tools
See all- Supplier Material Declaration Request Letter Template
- RoHS Homogeneous Material Limit Margin Calculator
- SAP SoD Residual Risk Score Calculator
- SAP Firefighter ID Usage Review Log
- IBM i (AS/400) User Profile Access Review Worksheet
- SyteLine Security and User Access Audit Checklist
- Infor XA (MAPICS) User Access Review Worksheet
- China ERP Data Security and Compliance Assessment
- ERP Vendor Data Processing Agreement Outline
Keep exploring
Free tools
- RoHS Homogeneous Material Limit Margin CalculatorConvert lab or supplier mass data into a weight percent per homogeneous material and see how much margin you have to the RoHS maximum concentration value.
- Article Substance Mass Roll-Up Worksheet (REACH 0.1% w/w)Enter each component mass, quantity and substance concentration to get total substance mass and the percentage of the whole article.
- Electronics BOM Cost CalculatorEstimate loaded BOM cost per board and annual material spend, including volume pricing tiers, procurement overhead, and attrition.
ERP fixes and how-tos
- SAP Business One: Reporting to Excel, Module List and Price ListsHow to export SAP Business One data to Excel, which modules the menu contains, and how price lists (OPLN, ITM1) are set up and applied to customers.
- How to Copy a Part in Epicor, Add Revisions and Customer Cross-ReferencesHow to copy a part in Epicor Part Maintenance, add a revision to a new part, set up customer part cross-references and find fixed asset numbers in Epicor 10 and Kinetic.
- Infor M3 Report Manager: Building, Running and AlternativesWhat Report Manager does for Infor M3 finance reporting, how reports are built and run, when it fits, and the alternatives for M3 reporting.
Runs with your ERP
- Spreadsheet Server with SAP Business One: live Excel reporting on inventory, sales and costHow insightsoftware Spreadsheet Server gives Excel live drill-down on SAP Business One inventory, sales and production cost data, with setup and pitfalls.
- Birst Analytics and Infor SyteLineHow Birst, Infor's cloud BI platform, fits with SyteLine: what data it reads, setup steps, common pitfalls, alternatives, and where private AI helps.
- Spreadsheet Server and Infor SyteLine: live Excel reportingHow insightsoftware Spreadsheet Server gives SyteLine, M3 and XA users live Excel reporting with drill-down to subledger detail and scheduled distribution.
Guides
- Cost Accounting Standards (CAS) for Defense ContractorsCost Accounting Standards for defense contractors: CAS 401, 402, 405, 410, and 418 explained, plus disclosure statements and the ERP setup they require.
- Reporting on CloudSuite Industrial: The Honest ComparisonThe real options for CloudSuite Industrial reporting: built-in reports, DataViews, SQL and SSRS, BI platforms, and AI query layers, with honest trade-offs for each.
- How to Configure Production Reporting in Infor SyteLineStep-by-step guide to configuring production reporting in Infor SyteLine, including standard reports, custom dashboards, KPI setup, and real-time production visibility.
AI on your ERP
- ServiceMax AI Integration: Private AI Over Work Orders, Installed Base and ERP DataPrivate AI over ServiceMax work orders, installed products, entitlements and PM plans, joined to ERP parts, contracts and billing. Read-only, on-prem option.
- Dynamics 365 Field Service AI Integration: Dataverse Data Joined to Your ERPPrivate AI for Dynamics 365 Field Service: work orders, bookings, agreements and customer assets from Dataverse, joined to ERP parts and billing. Read-only.