Klarna Docs - How to get settlement reports via SFTP

How to get settlement reports via SFTP

Learn how to create SFTP credentials and connect to the Klarna SFTP. Once you have set up your credentials, the next settlement reports will be automatically uploaded to your account. Optionally you can use the “Configure Reports” option in the Settlements App to additionally receive PDF reports or to customize your CSV reports. Additionally, you can choose to receive the reports of all your merchant IDs (MIDs) in the same SFTP account, by changing the SFTP target directories.

Manage SFTP Credentials

Visit the Settings App in the Merchant Portal and create credentials for the merchant ID. Make sure to save the .txt file which contains the username, password and ports.

Regional Merchant PortalLink to the SFTP credential service
Europehttps://eu.portal.klarna.com/settings/sftp-credentials
United States of America and Canadahttps://us.portal.klarna.com/settings/sftp-credentials
Australia and Asia Pacifichttps://oc.portal.klarna.com/settings/sftp-credentials

The SFTP credential self service

Once you have set up your credentials, the next settlement reports will be automatically uploaded to your account.

Configuration

Use the below settings for connecting to the Klarna SFTP in production and playground (testing environment).

OptionProductionPlayground
Addressmerchants.sftp.klarna.comsftp.playground.klarna.net
Username

File names

The file name of the Settlement Report from the SFTP includes the unique Payment Reference for the payout, and the timestamp of report generation day (00:00:00) in UTC: paymentReference.TimeStamp.format

Example: 123456789.20180809T000000+0000.csv

In this example, 123456789, is the Payment Reference for this payout. This payment reference is also included in the Settlement Report’s header. The second part 20180809T000000+0000, is the timestamp of the report generation day. It is in UTC and bound to the start of the day.

Note: The Merchant Portal and Settlements API are using a different naming convention: settlement.paymentReference.format

Temporary files: Please Ignore .tmp suffixed files, for example: 123456789.csv.tmp

These are reports that are currently being created.

Manually upload settlement reports to your SFTP account

You might want to manually upload a CSV or PDF report to your SFTP account. For example, after changing the report structure with the Report Configurator.

Simply click on the respective payment reference in the Settlements table and choose to "Send to SFTP".