Automating Carbon Accounting: Netvisor API Integration for Finnish Accounting Agencies
Automating Carbon Accounting: Netvisor API Integration for Finnish Accounting Agencies
As voluntary sustainability reporting under EFRAG's VSME (Voluntary SME) standard becomes the norm for European supply chains, small and medium-sized enterprises (SMEs) in Finland face a new administrative bottleneck. Corporate buyers, public procurement boards (such as Hilma), and financial institutions are increasingly requiring suppliers to present validated Scope 1 and Scope 2 carbon footprint disclosures to win tenders or secure loans.
For most SMEs, this triggers a scramble: collecting utility invoices, searching for grid emission factors, and entering data into complex, error-prone spreadsheets.
Finnish accounting agencies (tilitoimistot) are on the front lines of this shift. Clients are turning to their bookkeepers, asking for help compiling the energy, fuel, and utility data required for these audits.
To solve this resource bottleneck, ExecutESG has launched its native Netvisor API Integration. This pilot allows accounting agencies and internal finance teams to connect their Netvisor environments directly to ExecutESG, converting bookkeeping journal entries into verified, audit-ready carbon calculations automatically.
How it Works: Bookkeeping to Carbon Math
In traditional accounting, every purchase is categorized by an account code. In carbon accounting, these same ledger lines represent activity data that can be converted into carbon dioxide equivalents ($CO_2e$) using scientific emission factors.
By integrating with the Netvisor API, ExecutESG reads the ledger entries, extracts the transaction details, and automatically performs the carbon calculations.
┌───────────────────────────┐ ┌───────────────────────────┐
│ NETVISOR LEDGER │ │ EXECUTESG OS │
│ │ │ │
│ Account 4010: Electricity │ ──────> │ Fingrid CO₂ Mapping │ ──> Scope 2: 0.85 tCO₂e
│ Account 4020: Vehicle Fuel│ ──────> │ Diesel B7 Factor (Maa) │ ──> Scope 1: 5.12 tCO₂e
│ Account 4030: District Heat│ ──────> │ Local Utility Coeff. │ ──> Scope 2: 0.98 tCO₂e
└───────────────────────────┘ └───────────────────────────┘
By connecting the systems, ExecutESG removes the need for manual data entry:
- Scope 1 (Direct Emissions): Fuel purchases recorded in Netvisor (e.g., ST1, Neste, or Teboil corporate fuel card invoices) are parsed for volume (litres) or expenditure, and mapped to Tilastokeskus (Statistics Finland) fuel carbon weights.
- Scope 2 (Indirect Emissions): Electricity and heating invoices (e.g., Fingrid, Helen, Vantaan Energia) are mapped directly to their corresponding local utility grid emission factors (expressed in $gCO_2e/kWh$).
The Core Calculations: Mapping Ledger Lines
To understand the automation, let's look at how ExecutESG translates specific Netvisor journal ledgers into carbon outputs:
| Account / Transaction Type | Netvisor Source Ledger | Carbon Mapping Method | Emission Factor Applied | Output Category |
|---|---|---|---|---|
| Electricity Consumption | Utility invoice journals (kWh) | Direct multiplier of active grid consumption | Fingrid Finnish Grid Mix ($gCO_2/kWh$) | Scope 2 (Location-based) |
| Fleet Fuel (Diesel B7 / E10) | Fuel card monthly summaries | Litres purchased or €-to-litre conversion | Statistics Finland ($kgCO_2/litre$) | Scope 1 (Direct) |
| District Heating | District heat utility bills | MWh consumption mapped to supplier coefficient | Local utility specific factor (e.g., Helen) | Scope 2 (District Heat) |
| Logistics & Freight (Scope 3) | Transport partner invoices | Spend-based or weight-distance model | GHG Protocol Scope 3 Category 4 Factor | Scope 3 (Upstream) |
Automated Location-Based Scope 2 Calculations
For a typical office utility invoice from Helen Oy, the journal entry in Netvisor contains the total cost and the energy consumption in kilowatt-hours (kWh). When synced, ExecutESG applies the formula:
$$\text{Electricity Consumption (kWh)} \times \text{Fingrid Emission Factor } (gCO_2/kWh) = \text{Total } CO_2e$$
This ensures that the calculations match the exact grid mix of the Finnish electrical network, meeting the strict audit standards of the GHG Protocol.
Step-by-Step: Connecting Netvisor to ExecutESG
Setting up the integration takes less than 15 minutes. Here is the step-by-step workflow for accounting agencies:
Step 1: Retrieve API Credentials in Netvisor
- Log into your Netvisor environment with administrator privileges.
- Navigate to Company Settings -> Rights of Interface Resource.
- Create a new integration key for ExecutESG.
- Copy your Organization ID and the generated User Key.
Step 2: Activate the Integration in ExecutESG
- Log into your ExecutESG dashboard.
- Go to Settings -> Integrations and locate the Netvisor card.
- Click Connect and enter your Organization ID and User Key.
- Click Verify Connection.
Step 3: Map Your Chart of Accounts
Once connected, ExecutESG imports your Netvisor Chart of Accounts.
- Map your energy and fuel accounts (e.g., Account
4010 - Electricity, Account4200 - Vehicle Fuel) to the corresponding ExecutESG emission categories. - Set default utility providers (e.g., Fingrid for electricity, Helen for heating) to automate the correct emission factor selection.
Step 4: Run the Sync
Click Sync Data. ExecutESG parses the ledger entries for the selected period, calculates the Scope 1 & 2 emissions, and populates your VSME Basic Module workspace.
The Value for Accounting Agencies: Zero-Labor Advisory
Finnish accounting agencies are transitioning from traditional bookkeeping to strategic business advisory. Offering automated carbon accounting provides a major commercial advantage:
- Eliminate Manual Data Gathering: Stop chasing client utility invoices and fuel receipts. The data is pulled directly from Netvisor journals already processed by your bookkeeping team.
- Ensure Audit Compliance: ExecutESG's emission factors are automatically updated, providing clients with verified, audit-ready calculations that satisfy corporate buyer requests and bank questionnaires.
- Unlock Green Advisory Services: Use the completed VSME reports to help clients design active reduction strategies (e.g., fleet transitions or energy efficiency initiatives) using ExecutESG's Action Planning (ACT) module.
Accounting agencies can manage multiple client portfolios from a single multi-tenant partner dashboard, streamlining sustainability reporting across their entire customer base.
Stop Manual Entry. Start Automating.
By converting ledger lines into carbon calculations, ExecutESG and Netvisor turn compliance reporting from an administrative burden into an automated financial process.
If you are a Finnish accounting agency or an SME looking to automate your VSME baseline, you can connect your Netvisor pilot environment today.
👉 Register for a free account and start your Netvisor integration
👉 Read the step-by-step VSME Report Tutorial
👉 Learn the difference between Carbon Accounting Software and Spreadsheets