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.

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

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

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

OptionProductionPlayground
Addressmerchants.sftp.klarna.comsftp.playground.klarna.net
ProtocolSFTPSFTP
Port40014001
Username & PasswordAs provided by the SFTP credential self-service in the Merchant Portal Settings App. See section above. As provided by the SFTP credential self-service in the Merchant Portal Settings App. See section above.

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.

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".