Finance Integration Guide
Connect your financial systems to automatically extract expense, procurement, and payment data for comprehensive carbon accounting and reporting.
What You'll Learn
- Finance system identification and setup
- API authentication and secure access
- Financial data extraction and mapping
- Carbon spend analysis and categorization
- Automated expense carbon calculations
- Financial carbon reporting and compliance
Prerequisites
Before you start, ensure you have:
System Access Requirements
- Administrator access to your finance system
- API access permissions or app marketplace access
- Accounting team collaboration and approval
Financial Data Requirements
- Expense transactions and receipts
- Supplier and vendor information
- Chart of accounts and cost center structure
1
Identify Your Finance System
We support 20+ major finance and accounting systems with specialized connectors for carbon-relevant financial data extraction.
QB
QuickBooks
- • Online & Desktop versions
- • Expense tracking & categorization
- • Vendor & customer management
- • Purchase order integration
OAuth 2.0 API
XE
Xero
- • Cloud accounting platform
- • Automated bank feeds
- • Expense claims & receipts
- • Project cost tracking
REST API
SG
Sage
- • Sage 50cloud & Sage Business Cloud
- • Advanced purchase ledger
- • Multi-currency support
- • Comprehensive reporting
API Gateway
FF
FreeAgent
- • Small business accounting
- • Expense & mileage tracking
- • Time tracking integration
- • Tax compliance features
REST API
Additional Finance & Accounting Platforms
Wave
Free accounting software
FreshBooks
Time tracking, invoicing
Kashoo
Small business accounting
Zoho Books
Online accounting
KashFlow
UK SME accounting
Clear Books
Cloud accounting
Expensify
Expense management
Concur
Travel & expense
Multiple finance systems? We can consolidate data from different accounting software, expense tools, and payment platforms. Contact us for multi-system integration guidance.
2
Set Up API Authentication
QB
QuickBooks Integration
Create QuickBooks App
- Visit Intuit Developer console and sign in
- Create new app:
Carbon Tracking Integration - Select QuickBooks Online Accounting API
- Configure OAuth 2.0 settings:
- Scopes: accounting.read, accounting.write
- Redirect URI: https://your-app.com/callback/quickbooks
- App Type: Web app
- Environment: Production (after testing in Sandbox)QuickBooks OAuth Flow
- • Initiate OAuth authorization with QuickBooks
- • User grants permissions for financial data access
- • Exchange authorization code for access/refresh tokens
- • Test API connection with company information endpoint
XE
Xero Integration Setup
Create Xero App
- Access Xero Developer Portal
- Create new app:
Carbon Data Connector - Configure app settings and OAuth 2.0:
- Integration type: Web app
- Company or application URL: https://your-domain.com
- OAuth redirect URI: https://your-app.com/callback/xero
- Scopes: accounting.read, accounting.contacts.readXero Connection Process
- Generate OAuth 2.0 authorization URL with required scopes
- User authenticates and authorizes data access
- Handle callback and exchange code for tokens
- Validate connection with organisation endpoint call
SG
Sage Business Cloud Setup
Sage Developer Registration
- Register at Sage Developer Portal
- Create application:
Carbon Emissions Tracker - Request API access and configure OAuth:
- Application Type: Server-side web application
- Callback URLs: https://your-app.com/sage/callback
- Requested Scopes: full_access (or specific resource scopes)
- Business Cloud APIs: Accounting, Business Cloud FinancialsSage API Authentication
- • Implement OAuth 2.0 authorization code flow
- • Handle multi-tenant access for different Sage companies
- • Configure automatic token refresh mechanisms
- • Test API endpoints for purchases, expenses, and suppliers
3
Configure Financial Data Mapping
Map financial transactions to carbon accounting categories for spend-based emission factor calculations and Scope 3 reporting.
| Financial Category | Data Sources | Carbon Category | Emission Scope |
|---|---|---|---|
| Office Expenses | Utilities, rent, office supplies, telecommunications, cleaning services | Purchased goods & services | Scope 3 - Category 1 |
| Travel & Entertainment | Airfare, accommodation, meals, car rentals, taxi/rideshare, fuel cards | Business travel & employee commuting | Scope 3 - Category 6 & 7 |
| Procurement & Materials | Raw materials, components, packaging, manufacturing services, tooling | Purchased goods & services | Scope 3 - Category 1 |
| Professional Services | Consulting, legal, audit, marketing, IT services, training, recruitment | Purchased services | Scope 3 - Category 1 |
| Asset Purchases | Equipment, machinery, vehicles, IT hardware, furniture, property | Capital goods | Scope 3 - Category 2 |
| Logistics & Transportation | Shipping, freight, courier services, warehousing, distribution | Upstream & downstream transport | Scope 3 - Category 4 & 9 |
Spend-based Emission Factor Framework
Data Classification
- • Supplier categorization
- • Industry sector mapping
- • Product/service classification
- • Geographic region analysis
Emission Factors
- • UK DEFRA conversion factors
- • EXIOBASE sectoral factors
- • EEIO spend-based factors
- • Custom supplier-specific factors
Data Quality Enhancement
- • Supplier engagement programs
- • Primary data collection
- • Activity-based refinements
- • Uncertainty quantification
4
Test & Validate Finance Integration
Finance Integration Testing Checklist
Technical Validation
- OAuth authentication successful
- API data extraction working
- Transaction mapping accuracy verified
- Multi-currency handling functional
- Historical data synchronization complete
Financial Data Validation
- Transaction amounts match accounting records
- Vendor information correctly captured
- Carbon calculations reasonable
- Category mapping approved by accounting team
- Compliance with financial data policies
Sample Finance Integration Test Results
Finance Integration Test Results: QuickBooks Online (Company: Acme Ltd)
✅ OAuth Connection: SUCCESS (Read/write permissions active)
✅ Transaction Sync: SUCCESS (8,247 transactions in last 12 months)
✅ Vendor Data: SUCCESS (156 suppliers with complete information)
✅ Currency Handling: SUCCESS (GBP, EUR, USD conversions accurate)
⚠️ Data Quality: WARNING (4.1% transactions missing detailed descriptions)
Financial Carbon Summary (Last 12 Months):
- Total Business Spend: £1,247,891
- Carbon Intensive Categories: £398,456 (32% of total spend)
- Travel & Transport: £89,234 → 127.3 tCO2e
- Office & Utilities: £67,891 → 23.8 tCO2e
- Procurement & Materials: £241,331 → 89.4 tCO2e
- Professional Services: £124,567 → 8.9 tCO2e
Spend-based Carbon Footprint: 249.4 tCO2e
Average Emission Intensity: 0.20 tCO2e/£1k spend
Data Quality Score: 87.3/100
Top Carbon Spend Categories:
1. Raw materials & components: £156,234 (62.7 tCO2e)
2. Business flights & accommodation: £67,123 (89.1 tCO2e)
3. Freight & logistics: £45,678 (18.9 tCO2e) 5
Set Up Financial Carbon Analytics
Automated Spend Analysis
- Real-time carbon spend monitoring
- Supplier carbon intensity analysis
- Department-level carbon budgeting
- Purchase order carbon impact assessment
- Carbon cost accounting integration
Financial Carbon Reporting
- Scope 3 spend-based emission reporting
- Monthly financial carbon statements
- Supplier sustainability scorecards
- CFO-ready sustainability dashboards
- Carbon accounting integration with GAAP
Your Finance Carbon Dashboard Will Show:
Spend Emissions
249.4
tCO2e annually
Carbon Intensity
0.20
tCO2e/£1k spend
High-Impact Spend
32%
of total budget
Potential Savings
£89K
carbon reduction/year
Common Issues & Solutions
OAuth authentication failures or token expiration
Possible causes:
- Incorrect OAuth application configuration in finance system
- Refresh token expired or not properly handled
- User permissions changed or revoked in accounting software
- Callback URL mismatch between app and finance system settings
Solutions:
- Verify OAuth app settings and redirect URLs
- Implement robust token refresh and error handling
- Check user permissions and re-authorize if necessary
- Monitor token expiration and set up automated renewal
Missing or incomplete financial transaction data
Possible causes:
- Finance system API limitations or date range restrictions
- Transactions missing required fields (descriptions, categories)
- Multi-company or multi-currency data filtering issues
- Bank feed delays or manual entry timing differences
Solutions:
- Adjust API query parameters and pagination settings
- Work with accounting team to improve data entry practices
- Configure company and currency filtering appropriately
- Set up regular data synchronization and validation checks
Inaccurate carbon calculations from financial data
Possible causes:
- Incorrect spend-based emission factor assignments
- Currency conversion errors affecting calculation accuracy
- Category mapping misalignments between finance and carbon systems
- VAT/tax inclusive vs exclusive amount handling
Solutions:
- Validate emission factors against industry benchmarks
- Implement accurate currency conversion with historical rates
- Review and refine category mapping with sustainability team
- Standardize on net amounts for carbon calculations
Data privacy and security compliance concerns
Possible causes:
- Financial data containing sensitive supplier or customer information
- Regulatory compliance requirements for financial data handling
- Audit trail and data retention policy conflicts
- Multi-jurisdiction data processing requirements
Solutions:
- Implement data anonymization and pseudonymization techniques
- Ensure compliance with PCI-DSS, SOX, and GDPR requirements
- Configure appropriate data retention and deletion policies
- Work with legal and compliance teams on data processing agreements
Need Help?
Our financial systems and carbon accounting specialists understand the complexities of spend-based emission calculations and financial data integration.