Settlement files

Settlement files are created for every merchant payout and they contain detailed information on a transaction level in CSV format.

SFTP Settings

With your merchant SFTP account, you will be able to access to the root folder that contains all your merchant reports, i.e. settlement file and the merchant payout report.

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

Configuration

You can use the below settings for connecting to Klarna SFTP.

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

File name

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

Example: 262203.20150724T000226.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, is the timestamp of the report generation. It is in UTC.

Note: If you receive the settlement files by other means 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