Settlement & Reconciliation

Settlement And Reconciliation

The information needed to reconcile captured funds - the balance report and transactions list - are available for all merchants using Swedbank Pay.

• By default, the settlement files will be sent to you by via e-mail.
• We also have the option to send it via SFTP as well. If this is something you’d like, please inform your sales representative. They will in turn let the setup team know.
• The settlement frequency is defined in your agreement, but the default is
• monthly or weekly.
• You do not need to subscribe, the files will be delivered by default.

Please contact kundsupport@swedbankpay.se for further inquiries regarding this.

Settlement

There are two main alternatives for settlement - either we handle the settlement process for you, or you handle the process yourself:

If Swedbank Pay Handles The Settlement Process

Swedbank Pay handles the settlement process on your behalf, (called “Redovisningsservice”). Swedbank Pay transfers the net amount to you directly.

When choosing Swedbank Pay Checkout we will always handle the settlement process for you, gathering all your eCommerce payments in one place. Straighforward and time efficient.

You Handle The Settlement Process Yourself

If you will handle the settlement yourself, then Swedbank Pay will send you an invoice with the relevant fees, in addition to the report and transactions lists. Your acquirer will transfer settled funds to you.

Balance Report

The Balance Report (a .pdf file) specifies the total sales for a specific period, including fees and VAT. The report contains three parts: a payment summary and specifications for sales and for fees.

Two versions of the balance report are currently in production, v1 and v2. All new customers are set up with v2, so if you are a new customer or have joined us within the last year, the v2 sections should be your focus. V1 will be phased out during 2023.

The main differences are in the transaction list.

Payment Summary

Provides a summary of the Amount sold, Fees and VAT. If Swedbank Pay handles the settlement process, the Transferred amount shown in the balance report summary is equivalent to the disbursement on the bank statement (the remaining total amount after fees).

Sales Specification

Provides a specification over sales for the given period. The sales total is specified per payment area (CreditCard, Invoice) and underlying payment instruments. Each sales row specify Quantity, Sum sales and Amount to pay out, the last one is only eligble if Swedbank Pay handles the Settlement process.

A summary of payments through the last date of the report is also provided.

Fees Specification

Provides a specification of the fees in the given period. The fees total is specified per payment area (CreditCard, Invoice) and underlying payment instruments. Each fees row specify Quantity (sales), Amount (sales), Unit price, Provision and fee Amount. If you handle the settlement process yourself, you will receive a separate invoice for fees.

Transaction List

The Transaction List (also called Sales Accounted Transactions) is provided in .xlsx and .xml formats and specifies all transactions for a specific period, including a summary of transactions grouped by payment instrument. Both formats contain the same information, but the xml file is meant for computer processing, while the excel workbook is meant for human interaction.

The first row contains the name of the Swedbank Pay company (e.g. Swedbank Pay Solutions AB) that the merchant has the contract with, and the balance report number. The header fields contain a summary of the transactions displayed in the body.

As with the Balance Report there are two versions of the Transaction List, and v1 will be phased out during 2023.

V1 Header Fields

V1 Body Fields

V2 Header Fields

V2 Body Fields

Reconciliation

To do the reconciliation, you need to match the information in your system against the information provided by Swedbank Pay in the balance report and transaction list. Below is a sequence diagram detailing the interaction.

Reconciliation Sequence Diagram

sequenceDiagram
    participant SwedbankPay as Swedbank Pay

    activate Merchant
    activate SwedbankPay
    Merchant-->>SwedbankPay: Online payment transactions
    deactivate Merchant

    deactivate SwedbankPay

    activate Merchant

    SwedbankPay->>Merchant: Balance Report (PDF-file)
    note left of Merchant: files are sent by e-mail or file transfer
    SwedbankPay->>Merchant: Transaction list (XLSX-file)
    SwedbankPay->>Merchant: Transaction list (XML-file)
    deactivate Merchant

There are two ways for you to match the information from your system with the information given in the reconciliation files from Swedbank Pay:

1. You can use information generated by your system (you will have to set a unique payeeReference when you make the transaction), or
2. You can use the transaction number generated by Swedbank Pay (this is called transaction number and is returned from Swedbank Pay after you have created the transaction).

A credit card transaction is made when you either make a capture or a reversal. In the input data for making a capture, you will set the payeeReference. The unique value of this field is the same as the field called OrderID in the reconciliation file.

1
2
3
4
5
6
7
8

{
    "transaction": {
        "amount": 1500,
        "vatAmount": 0,
        "description": "Test Reversal",
        "payeeReference": "ABC123"
    }
}

When you receive the response from Swedbank Pay, the response will include transaction.number. This is the same as the field called TransactionNo in the reconciliation file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

{
    "payment": "/psp/paymentorders/payments/7e6cdfc3-1276-44e9-9992-7cf4419750e1",
    "capture": {
        "id": "/psp/paymentorders/payments/7e6cdfc3-1276-44e9-9992-7cf4419750e1/captures/ec2a9b09-601a-42ae-8e33-a5737e1cf177",
        "transaction": {
            "id": "/psp/paymentorders/payments/7e6cdfc3-1276-44e9-9992-7cf4419750e1/transactions/ec2a9b09-601a-42ae-8e33-a5737e1cf177",
            "created": "2016-09-14T01:01:01.01Z",
            "updated": "2016-09-14T01:01:01.03Z",
            "type": "Capture",
            "state": "Initialized",
            "number": 1234567890,
            "amount": 1500,
            "vatAmount": 250,
            "description": "Test Capture",
            "payeeReference": "ABC123",
            "failedReason": "",
            "isOperational": false,
            "operations": []
        }
    }
}

• payeeReference sent to Swedbank Pay is equal to OrderId in the reconciliation file.
• capture.transaction.number returned from Swedbank Pay is equal to TransactionNo in reconciliation file.

Below you will see the API mapping tables to the fields in the settlement report for Capture and Reversal.

Capture

Reversal

Report Samples

The content of the files depends on the type of agreement you have made with Swedbank Pay. For some payment instruments, only option A is available, while for other payment instruments, only option B is available. The sample files can be downloaded below. Make sure that you choose the examples from your current version of the balance report (v1 or v2).

V1 Option A: Swedbank Pay Handles The Settlement Process

• PDF Balance Report
• XLSX Transaction List
• XML Transaction List

V1 Option B: You Handle The Settlement Process Yourself

• PDF Balance Report
• XLSX Transaction List
• XML Transaction List

V2 Option A: Swedbank Pay Handles The Settlement Process

• PDF Balance Report
• XLSX Transaction List
• XML Transaction List

V2 Option B: You Handle The Settlement Process Yourself

• PDF Balance Report
• XLSX Transaction List
• XML Transaction List

Split Settlement

The split settlement feature is an easy way of doing settlements for companies with multiple sub-merchants. With only a few steps, the settlement process becomes more efficient with regards to invoicing, payouts and setup for both your sub-merchants and yourself.

In short, it is a settlement feature where a company with a website or an app can attach specific subsite numbers to sub-merchants selling their goods or services through the company. The subsite number is used to match the transactions with the correct sub-merchant, so the settlement is automatically split between them. If you run a site selling tickets to concerts, theaters, sporting events etc., each venue gets its own subsite number. If you run a funeral home, the sub-merchants can be everything from flower shops to charities.

What We Need From You As A Company

• Submit a KYC (Know Your Customer) form for each sub-merchant you want to include. We will also do a KYC check on your sub-merchants, providing extra security for both of us.
• Give every sub-merchant who sells goods/services through your website or in your app a unique subsite number. It must be in the format of A-Za-z0-9. This must be included in the KYC form. We recommend using the same customer number they have in your system.
• Attach the subsite number to all the goods/services the sub-merchant sells through your website or app, so the goods/services can be matched to the correct merchant in our back office system.
• A partner agreement is needed for automatic deduction of revenue cuts and fees.

How It Works

1. We set up the sub-merchant subsite number in our system.
2. You add the number in the request’s subsite field when you create the payment for the goods or service.
3. The customer selects a payment instrument and completes the payment.
4. The payment goes into a client funds account.
5. Swedbank Pay matches the transaction with the sub-merchant using the subsite number.
6. The settlement is split and connected to the correct sub-merchant.
7. Revenue cuts for the super merchant and fees from Swedbank Pay are deducted automatically.
8. Payout to the sub-merchant is done.

The Upsides Of Split Settlement

Connecting sub-merchants to Swedbank Pay through the super merchant instead of having separate setups has a lot of pros:

• You only need one agreement for each payment instrument (credit card, Vipps, Swish, MobilePay Online, invoice) and payment gateway.
• You only need one acquiring agreement.
• You only need one Vipps or Swish certificate.
• You can add more payment instruments easily, as it only has to be done once.
• New sub-merchants can be set up quickly, as the only thing needed is a KYC form and a subsite number. This shortens the setup time to a matter of hours for both you and us.
• The automatic settlement split and deduction of fees and revenue cuts minimizes the work for your accounting department, as you won’t have to invoice your sub-merchants.
• The subsite split is available for all payment instruments we offer on our eCom platform.

Split Settlement Admin Functions

With regards to admin functions, we offer a full integration towards our Merchant Portal system. This way, you do not have to log in to the Merchant Portal to perform these operations.

Capture And Cancel

Captures and cancels are done by the super merchant the same way as all other flows.

Reversal

In cases where you need to do reversals, this will be performed by the super merchant. The reversal amount will be charged from the sub-merchants subsite number. If the sub-merchants balance is 0 (zero), the super merchant will be invoiced. The super merchant will in turn have to invoice this amount to the sub merchant.