UNSPSC Spend-Based Emissions Calculator β

How to Use This Tool

  1. Setup: Enter your company details (Legal Entity Name, Asset, Country, and Default Currency) below. You can optionally upload a previously exported mapping file to automatically apply mappings to new data.
  2. Upload Data: Drag and drop your accounting data file (.csv or .xlsx) containing: Date of invoice, Accounting keys, Cost, Currency, and Asset. The tool will automatically group categories and suggest UNSPSC codes.
  3. Map Categories: Review the mapping progress indicator and map each accounting category to the appropriate UNSPSC code. Use the searchable dropdown to find codes, or click the suggested code button for auto-suggested mappings. The tool will automatically focus on the next unmapped category after each mapping.
  4. Calculate: Once all categories are mapped, click "Calculate Emissions" to see your total spend-based emissions broken down by category and UNSPSC code.
  5. Export: Use "Download Excel" to save the results for import into the Klappir platform.
  6. Remap if Needed: You can change the UNSPSC code for any mapped category by clicking on it and selecting a different code.

Note: This calculator uses spend-based emission factors to estimate Scope 3 emissions from purchased goods and services. The factors are based on UNSPSC codes and vary by country. Categories are automatically grouped by accounting category name for easier mapping.

Beta Version: This tool is currently in beta. We welcome your feedback and suggestions for improvements.

Company Setup

Upload Accounting Data

Upload your accounting data file with the required fields: Date of invoice, Accounting keys, Cost, Currency, Asset. Supported formats: CSV, Excel (.xlsx, .xls)

Drag & drop a .csv or .xlsx file here to upload accounting data

Spend Categories

Auto-mapping: When you map an accounting key to a UNSPSC code, all identical accounting keys will be automatically mapped to the same code.

Mapping Progress: 0 of 0 categories mapped
Accounting Category
UNSPSC Code
Spend Amount
Emission Factor (kgCO₂e/currency)

Total Emissions Summary

Total Spend-Based Emissions (kgCO₂e)

0.00

Total Spend Amount (Local Currency)

0.00

Mapping Overview

Review and manage your category mappings. Click to expand groups and remove incorrectly mapped items.

Complete mapping to see overview.

Export Results

Legal Entity Supplier From time To time Description Asset Scope 3 category KgCO2e Reference
Please complete setup to generate a report.