General information

Generating reconciliation files gives you the possibility to keep your accounting up to date more easily.
Since separate payments are often compressed into one bigger transaction and then transferred to your business bank account, it is difficult to keep record of all payments correctly and generates a lot of manual work in most cases.

When generating a reconciliation file, all transactions are listed instead of one big transaction.

• Payment link files can be generated once each day, when a link was paid the file is available the next day.
  Example: Bob and Julia have paid using their respective links on Monday,the file is available Tuesday and contains both payments.
• Direct Debit files can be generated depending on your selected Reconciliation method

Overview:

• Search files (1)
• Filter (2) everything (by default), archived and non archived
• Upload account info (3)
• Generate (4) CAMT53, MT940 or CODA file(s) for Direct Debit transactions and Payment links
• View archived files and reset filters (5)
• List of generated files
• Download (6) button

Generate CAMT53, MT940 or CODA files

Reconciliation Account

When you click on the Generate button, the reconciliation account that will be used in your reconciliation file for each Target is displayed:

This account is defined in this particular order, and depending on the target:

Transactions

1. The default Twikey account is used: BE71088260500969
2. A custom account of your choice is used: Contact your Business Support Agent to configure one.

Payment links

1. You configured a reconciliation account in your Payment Provider Gateway, that one is used
   Settings > Payment Hub > Payment provider Gateway > Configure > Advanced:

2. No specific account is configured on your Payment Provider Gateway:
   We use the IBAN from that Payment Provider if known in our system:

• Mollie: NL30ABNA0524590958
• MultiSafePay: BE15399104252630
• CCV: Depending on your registered address:
  • Belgium: BE79363065348233
  • Netherlands: NL26INGB0006865503

In case we do not know the IBAN, there won't be any account displayed. Configure one on your Payment Provider Gateway first in order to generate payment link reconciliation files.

How to generate files

• Click on 'Generate' (1) on the top right.
• Select the format (2).
• Select the target(s) (3) (both are possible).
• Click on 'Generate' (4).

Formats and targets

When generating files you select both a format and a target.

Available formats:

Available targets:

Both targets can be selected at the same time.

Filenames

Each generated file follows a predictable naming pattern so you can identify its origin at a glance.

CAMT example:

sdd_twikey_BE81ZZZ1234567891-210319152443-2223_camt53.xml
          └─ creditor ID ──┘ └ date+ref ┘ └─ template ID

CODA example:

sdd_twikey_BE81ZZZ1234567891-210322033017-2223.cod
          └─ creditor ID ──┘ └ date+ref ┘ └─ template ID

The prefix is sdd_twikey_ for Direct Debit files and rcc_twikey_ for Recurring Credit Card files.

Reconciliation method

You can configure which transactions are included in your Direct Debit reconciliation files via Settings > Account > Company > Reconciliation method.

Three options are available:

Only paid Transactions (default)
The reconciliation file is generated as soon as all transactions in the batch have been returned by the bank. Only paid transactions are included. Failed transactions are already handled in the bank files you receive via your regular bank feed, so including them here would create duplicates in your accounting package.

Booked Transactions
Includes all transactions that have received a booking date from the bank — both paid and failed. Use this when your accounting package needs a complete picture of all booked items and handles deduplication with the bank file on its own.

All Transactions
Includes all transactions regardless of whether bank feedback has been received. Transactions without a booking date will use the collection date as a fallback. Use this when you do not want to wait for bank confirmation and accept the risk that some transactions may later turn out to be rejected.

Content

The content of the files use the general standards.
In the CODA files we include a reference to the batch id on the first line:

Transactions

For CODA, CAMT053 and MT940 files, which transactions are included depends on your selected Reconciliation method. Regardless of that setting, transactions that originally failed but were later recovered — either through the dunning workflow or manually marked as paid — are never included. These were not settled via the bank and would break the 1-on-1 match with your bank file.

The reversal zero sum entry is always included in the transaction count shown on screen.

CSV files behave differently: they always list all transactions from the batch together with the status received from the bank (paid or failed). The file count shown in the overview reflects only the paid transactions.