Assessment Guide · Excel + CSV · 4 Sheets · Editable
Map Your QuickBooks Spend to
Scope 3 in One Afternoon
The exact template our customers use to convert a year of expense data into a draft Scope 3 inventory across categories 1–8.
✓
NAICS-to-Category-1 crosswalk — 60+ manufacturer NAICS codes pre-mapped to EPA USEEIO v2.0 factors (kg CO₂e per dollar)
✓
Freight category logic — inbound freight → Cat 4, outbound → Cat 9, with ton-mile and spend-based factor options
✓
Capital goods threshold rules — how to split Cat 1 vs. Cat 2 based on useful life (>1yr) and unit cost (>$50K) per GHG Protocol guidance
Sheet 1
Instructions
Step-by-step: how to export the right QuickBooks report, which columns to use, and how to populate the Mapping sheet.
Sheet 2
Mapping
QB Account → Annual Spend → NAICS Code → Scope 3 Category → EEIO Factor → Estimated Emissions (auto-calculated formula).
Sheet 3
NAICS Reference
60+ common manufacturer NAICS codes with default EPA USEEIO v2.0 emission factors. Find your suppliers, copy the factor.
Used by manufacturers responding to Walmart Project Gigaton, Costco SSA, Target SSA, and Apple Supplier SAQ requirements.
Walmart Project Gigaton
Costco SSA
Target SSA
Apple Supplier SAQ
EcoVadis Submission
CDP Climate Change
SBTi Science-Based Targets