📊
Your Template is Ready
Excel workbook + CSV — 4 sheets, 60+ NAICS codes, auto-calculated emissions formula. Open it, paste your QuickBooks data, done.
What's inside the workbook
1
Instructions
How to export from QuickBooks, which report to use, and how to populate each column.
2
Mapping
QB Account → Annual Spend → NAICS Code → Scope 3 Category → EEIO Factor → Estimated Emissions (formula auto-calculates).
3
NAICS Reference
60+ manufacturer NAICS codes with EPA USEEIO v2.0 factors. Find your supplier's code, copy the factor to the Mapping sheet.
4
Summary
Auto-pivot showing total spend and estimated emissions by Scope 3 category (Cat 1–9). Ready to drop into any buyer submission.
Source: EPA USEEIO v2.0 · GHG Protocol Corporate Value Chain (Scope 3) Standard. A confirmation email with both download links is on its way.