A free Excel checklist and an email template for people who collect carbon footprint data from suppliers. Use them for your corporate footprint (Scope 3) or for a product carbon footprint.
Enter your email, and we will send you both files. It is free.
Do you collect carbon data from suppliers? Write to us:
In a corporate carbon footprint, purchased goods and services (Scope 3 category 1) are often the largest item. If you calculate them with average factors from databases or with the spend-based method, you cannot influence the result. It falls only when you buy less. Without supplier data, it is also hard to manage and cut emissions in the supply chain. So customers, banks and standards ask for data from the suppliers themselves. The trouble starts with the first request:
A general request for “the carbon footprint” brings back an environmental policy or an ISO 14001 certificate, not a number.
You get the emissions of the supplier's whole company in tonnes of CO₂e. But you need a factor per kilogram, piece or tonne-kilometre of the product you buy.
Each supplier used a different method, a different year and different boundaries. So you cannot compare or check the results.
Files and numbers sit in emails and attachments. After a few weeks, nobody knows which suppliers have sent data and whom to chase.
Demand for supply chain data comes from several sides:
Under the GHG Protocol, a corporate carbon footprint has three scopes. You express emissions in kilograms or tonnes of carbon dioxide equivalent (CO₂e). Scope 1 covers direct emissions, for example from fuel burnt in your own boilers and vehicles. Scope 2 covers indirect emissions from purchased electricity and heat. A company calculates Scopes 1 and 2 from its own invoices and meters. Scope 3 covers all other indirect greenhouse gas emissions in the value chain, in 15 categories. Supplier data matters most where the emissions happen at the supplier:
Other categories, for example business travel, usually come from data of the travel agency as a service supplier, or from financial data. Data from a specific supplier is called primary data. It replaces secondary data, that is average factors from databases or financial data converted with the spend-based method. The GHG Protocol recommends collecting primary data first where emissions are largest. It also matters where the company can influence the choice of supplier and how it buys.
From each supplier, you need more than the result. You also need information that shows if the result fits your report. In the checklist, we group it into four areas:
The supplier's name, the product or service you buy and the date of your request. Without them, a year later you will not know where a number in your report came from.
Which standard the supplier used (GHG Protocol, ISO 14067, EPD), with the method and the sources of emission factors. Also the period, the place of production and the boundaries of the calculation.
The result in kg CO₂e per unit of product (kg, piece, metre, tkm). Also a link to the invoice or delivery note, so you can multiply the factor by the real quantities.
Does the supplier have reduction targets? Are they validated, and is there a reduction plan? This is the basis for work on Scope 3 in the next years, not only for the report.
At the end, you answer one question: is the data from this supplier complete enough to use in the report? If not, use an average factor for this supplier and come back to it next year.
The GHG Protocol guidance for Scope 3 recommends five data quality criteria: technological, time-related and geographical representativeness, completeness and reliability. In practice, this means five questions:
You can use data that passes these questions instead of database factors. Treat other data as a starting point for a talk with the supplier.
The email template and the checklist guide you through steps two to four. So you do not start collecting Scope 3 data from a blank page.
15 questions in four groups, with columns for 18 suppliers. You choose answers from a list (Yes, No, n/a). At the end, you decide if the data is complete enough for the report.
Text to copy, with fields to fill in. It works for a corporate footprint (Scope 3) and for a product carbon footprint under ISO 14067.
How to fill in the email template and how to move suppliers' answers into the checklist.
It helps sustainability (ESG), purchasing and quality teams that collect supplier data for Scope 3 or a product footprint for the first time. It also helps companies that got a request for supply chain data from their own customer.
Ready to use: you can send your first request today, without writing questions from scratch.
The same questions for all suppliers: you can compare the answers, assess them and use them in your calculation.
Based on the GHG Protocol and ISO 14067: the questions cover what you need for the report and its verification.
We will send the checklist (Excel) and the email template (PDF) to your email address.
How to calculate emissions from purchases, and where to get the data.
We calculate Scope 1, 2 and 3 emissions, together with supplier data.
How to find the Scope 3 categories that matter most.