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. This account is used as the suspense account in your accounting package. It can be:

  • The default account of your Payment Service Provider (PSP).
  • The default Twikey reconciliation account (BE71088260500969) — used when no PSP account is found.
  • A custom account you have configured.

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