background
Tags:paymentlinkspaylinksreconciliationreconciliatiebetaallinkpspibanaccountingboekhouding

When a customer pays a payment link, the funds are collected by your Payment Service Provider (PSP). The PSP periodically transfers the collected amounts to your bank account as a lump sum — making it difficult to match individual payments back to invoices in your accounting package.

Twikey solves this by generating a reconciliation file for your paid payment links. By importing this file into your accounting package using a temporary suspense account, the collected amounts are automatically matched to your individual invoices — no manual reconciliation needed.

The reconciliation menu is only available to users with the Controller role.

Generate a reconciliation file

  1. Navigate to Reconciliation in the left-hand navigation menu.
  2. Click Generate.
  3. Select the type Payment links.
  4. Select your desired file format.
  5. Click Download.
  6. Import the file into your accounting package.
Upload each reconciliation file into your accounting package only once. Uploading the same file multiple times may overwrite existing data.

Reconciliation accounts

Each reconciliation file contains a designated reconciliation account, used as the suspense account in your accounting package. Twikey picks the account in the following priority order:

  1. Custom account — the IBAN you configured on the PSP (see below).
  2. PSP default account — the default reconciliation IBAN of the PSP.
  3. Twikey fallback — BE71088260500969, used when neither of the above is available.

In the example below, three PSPs are active. For each PSP, the corresponding reconciliation account is displayed.

Configure a custom reconciliation account

  1. Navigate to Settings in the left-hand navigation menu.
  2. Open Payment Hub.
  3. Click the PSP to open the details.
  4. Open the Configuration tab.
  5. Click Advanced.
  6. Enter the IBAN to use for reconciliation.
  7. Click Save.

Last Update: 2026-03-11