Klarna

Klarna is an innovative fintech platform that provides merchants with advanced payment integration tools, offering customers flexible financing options at checkout to drive sales and enhance brand loyalty.

Features

Setup Guide - ELT

Step 1 - Create API Key

1. In your Klarna Merchant Portal

2. Click on Settings

3. Click on Generate New Klarna API key

4. Copy the Password for the Weld Integration

Step 2 - Finalize Weld Integration

1. On the Weld App enter a Schema Name
2. Enter the Klarna API key password you created
3. Select the region
4. Click Connect

Step 3 - Data To Sync

1. Select the pre-built reports you wish to include in the sync.
   You can view the schema, remove columns or hash sensitive information.

Step 4 - Configure Sync

1. Select how often you would like the data to sync.
2. Check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.

Weld will take over from here and commence syncing data from your Klarna account.

Data Schema

SQL Templates

View all →

Daily settlement activity

Sales, returns, fees and the rest of the settlement ledger, per day.

grain: day x klarna_account x merchant_id x currency_code · builds on 1 model

Fees by type

What Klarna charged, broken down by fee type, per month, with the effective rate against that month's sales.

grain: month x klarna_account x merchant_id x currency_code x transaction_type x detailed_type · builds on 1 model

Payout reconciliation

Every Klarna payout, Klarna's own breakdown of it, and whether the synced transactions add up to that breakdown.

grain: klarna_account x merchant_id x payout (payment_reference) · builds on 2 models