[intro]On this page you can download either a PDF or CSV document detailing the payouts Klarna have made to your bank account. [/intro]
The PDF version is a Summary Report detailing how many sales you have had, the total income from these sales, any refunds processed and any fees paid to Klarna.
If you want to see a more detailed document regarding the separate sales then you will need to download the CSV document. A CSV document can be opened in a variety of programs such as Excel and Numbers. When first downloaded, the CSV can seem slightly confusing and the following is a guide on how to get this spreadsheet to display in an easier to read format.
The following guide is based upon opening this document within Excel.
To separate all the data within your CSV document to individual columns you will first need to open the CSV document within Excel and highlight the first column:
From here Click onto the Data tab at the top and select the 'Text to Columns' option:
A pop up will appear and you will need to select the 'Delimited' option from the Original data type option:
Click 'Next' and ensure that the Delimiters selected is set to just 'Semicolon':
Finally, click 'Next' and then 'Finish' and you will see that all of your information has been put into separate columns as so:
To find the Sale/Fee relating to your EKM order, you can find the EKM 'Order Number' listed underneath the 'merchant_reference1' column:
Below you will find a description regarding all of the column headings you will find within your CSV document.
|total_sale_amount||Decimal||Total of all "sale" events|
|total_fee_amount||Decimal||Total of all "fee" events|
|total_return_amount||Decimal||Total of all "return" events|
|total_reversal_amount||Decimal||Total of all "reversal" events|
|total_commission_amount||Decimal||Total of all "commission" events|
|total_holdback_amount||Decimal||Amount held back until a future payout|
|total_repay_amount||Decimal||Amount used to pay back previous debt|
|total_release_amount||Decimal||Amount released from an earlier holdback|
|total_settlement_amount||Decimal||Total amount of this payout|
(sales + release - fees - returns - holdback - reversals - repay = total_settlement_amount)
|total_tax_amount||Decimal||Taxes paid by the merchant for Klarna's services.|
|payment_reference||String||Unique identifier of this payout|
|payout_date||Date||Date of the payout. Please note that it’s not necessarily the date that the merchant receives the funds.|
|merchant_id||String||Klarna Merchant ID, like "K000000"|
|merchant_settlement_type||String||“NET” or “GROSS”|
|type||String||Type of this event. Possible values:|
|capture_date||Date||Date of capture|
|sale_date||Date||Date of sale|
|short_order_id||String||Customer-facing order ID, like "ABC1234"|
|merchant_reference1||String||Merchant provided order ID|
|merchant_reference2||String||Merchant provided order ID|