Settlement files

Settlement files are ledgers that provide details of all transactions at the close of a business day and are created for every payout. Settlement files are of CSV format and can be accessed in three different ways - using Klarna’s Merchant Portal, using the Settlements API or by using an SFTP.

 

Merchant Portal

Using the Merchant Portal to access your Settlement files is the simplest method of managing settlement files, as no technical setup or configuration is needed. The Merchant Portal allows for filtering by dates and currency and simple downloads of settlement files for desired transactions.

 

Settlements API

The Settlements API allows for managing and gathering Settlement files using our predefined API. It requires technical configuration, but is a preferred method to manage larger volumes of settlement files.
Click here for detailed information and API reference on the Settlements API.

 

SFTP Settings

A merchant SFTP account allows for access to the root folder that contains all merchant reports, i.e. settlement file and the merchant payout report.

Merchant reports are kept in the SFTP account for 90 days. After that period, they are deleted automatically.

Configuration

Use the below settings for connecting to Klarna SFTP.

OptionSetting
Addressmft.klarna.com
ProtocolSFTP
Port4001
UsernameProvided by account manager
PasswordProvided by account manager

File name

The file name of the settlement file from the SFTP includes the unique payout id for the payout, and the report generation timestamp in UTC.

Example: 262203.20150724T000226+0000.csv

Green part, i.e. 262203, is the payout id for this payout. This payout id is also included in the settlement file’s header. Blue part, 20150724T000226+0000, is the timestamp of the report generation. It is in UTC.

Note: If settlement files are received by means other than the SFTP (such as email) the files will be named differently. The filename will contain the merchant id and the timestamp.

Header fields

FieldTypeDescription
total_sale_amountDecimalTotal of all "sale" events
total_fee_amountDecimalTotal of all "fee" events
total_return_amountDecimalTotal of all "return" events
total_reversal_amountDecimalTotal of all "reversal" events
total_commission_amountDecimalTotal of all "commission" events
total_holdback_amountDecimalAmount held back until a future payout
total_repay_amountDecimalAmount used to pay back previous debt
total_release_amountDecimalAmount released from an earlier holdback
total_settlement_amountDecimalTotal amount of this payout
(sales + release - fees - returns - holdback - reversals - repay = total_settlement_amount)
total_tax_amountDecimalTaxes paid by the merchant for Klarna's services.
payment_referenceStringUnique identifier of this payout
settlement_currencyISOSettlement currency
payout_dateDateDate of the payout. Please note that it’s not necessarily the date that the merchant receives the funds.
merchant_idStringKlarna Merchant ID, like "K000000"
merchant_settlement_typeString“NET” or “GROSS”

Body fields

FieldTypeDescription
typeStringType of this event. Possible values:
  • SALE
  • RETURN
  • FEE
  • COMISSION
  • REVERSAL
capture_dateDateDate of capture (UTC)
sale_dateDateDate of sale (UTC)
order_idUUIDOrder ID
short_order_idStringCustomer-facing order ID, like "ABC1234"
capture_idStringCapture ID
merchant_reference1StringMerchant provided order ID
merchant_reference2StringMerchant provided order ID
amountDecimalAmount
posting_currencyISOSales currency

Sample file contents

total_sale_amount;total_fee_amount;total_return_amount;total_reversal_amount;total_commission_amount;total_holdback_amount;total_repay_amount;total_release_amount;total_settlement_amount;total_tax_amount;payment_reference;settlement_currency;payout_date;merchant_id;merchant_settlement_type
100.00;2.00;0.00;0.00;0.00;0.00;0.00;0.00;97.50;0.50;225;GBP;2014-06-19T00:00:00.000Z;testMerchantNetRefId1;NET
type;capture_date;sale_date;order_id;short_order_id;capture_id;merchant_reference1;merchant_reference2;amount;posting_currency
SALE;2014-06-18T14:25:36.000Z;2014-06-18T14:25:36.000Z;c504a9bb-1948-46d5-99be-bd55948c6321;9875QW2;245;;;20.00;GBP
FEE;2014-06-18T14:25:36.000Z;2014-06-18T14:25:36.000Z;c504a9bb-1948-46d5-99be-bd55948c6321;9875QW2;245;;;0.40;GBP
SALE;2014-06-18T14:25:40.000Z;2014-06-18T14:25:40.000Z;81569635-0c4c-4725-ac2e-db575cae0e8f;VMRZN6Z;247;;;20.00;GBP
FEE;2014-06-18T14:25:40.000Z;2014-06-18T14:25:40.000Z;81569635-0c4c-4725-ac2e-db575cae0e8f;VMRZN6Z;247;;;0.40;GBP
SALE;2014-06-18T14:25:43.000Z;2014-06-18T14:25:43.000Z;2800dc37-b779-49a4-a9eb-7bc43279dce8;G1BRKH2;249;;;20.00;GBP
FEE;2014-06-18T14:25:43.000Z;2014-06-18T14:25:43.000Z;2800dc37-b779-49a4-a9eb-7bc43279dce8;G1BRKH2;249;;;0.40;GBP
SALE;2014-06-18T14:25:47.000Z;2014-06-18T14:25:47.000Z;a125bc2a-c740-4bce-8e36-992d542fa69f;RNSLMFH;251;;;20.00;GBP
FEE;2014-06-18T14:25:47.000Z;2014-06-18T14:25:47.000Z;a125bc2a-c740-4bce-8e36-992d542fa69f;RNSLMFH;251;;;0.40;GBP
SALE;2014-06-18T14:25:51.000Z;2014-06-18T14:25:50.000Z;e12a2c96-e5c2-4e8e-80a2-6e209097ff0d;C2CDJQL;253;;;20.00;GBP
FEE;2014-06-18T14:25:51.000Z;2014-06-18T14:25:50.000Z;e12a2c96-e5c2-4e8e-80a2-6e209097ff0d;C2CDJQL;253;;;0.40;GBP