Match bank transactions

In order for an invoice to be registered as paid it must be matched against a payment or a credit note. The program uses the following four criteria to match the payments against invoices: customer/supplier IBAN, the customer/supplier name, the invoice number and the paid amount.

If the invoice number, amount and either the name or IBAN from the bank transactions correspond exactly to the invoice details, the transaction will be posted to the ledger automatically. The transaction will be visible under Bank transactions this period. Automatic posting of payments will only take place on bank accounts with direct bank integration.

If the result is not 100% certain, you will receive a suggested match, which you then can confirm or edit. This typically is the case when at least two of the four criteria are met. If you have multiple transactions with matching suggestions, you can post them all at once by selecting the Confirm all button, which you can find at the bottom left, after verifying that the suggestions are correct. Matching suggestions are carried out no matter if you have a direct bank integration, import a file with bank transactions from your bank or if you register your bank transactions manually.

Automatic matching and posting to the ledger can also occur for batch payments of purchase invoices that were sent to the bank for payment or uploaded to the bank in a payment file. In case the payment is visible as a lump sum transaction for multiple purchase invoices on your bank account, the program will try to match this batch payment with the associated purchase invoices based on the transaction reference.

If the transaction amount matches the amount of the unpaid purchase invoices from the associated payment batch, the bank transaction will automatically be matched and posted to the ledger, and the purchase invoices will be marked as paid.

In most scenarios, incoming and outgoing payments of invoices are automatically matched, but if you for example have made a purchase with receipt or received money from Belastingdienst, you must create a new accounting transaction to match against the transaction on the bank statement.

When posting invoice payments from direct bank integration or CAMT.053 import, the program will automatically fetch the counterparty IBAN from the bank transaction and register it in the associated customer/supplier settings. This will improve matching of any following payments for this customer or supplier, thus making it easier for you to process these transactions. The IBAN will be imported only under these conditions: there is no IBAN registered yet, the bank transaction is matched manually, and the counterparty's name in the bank transaction has to match the name in Visma eAccounting Pro closely.

You will find examples and tips on how to match and post frequently occurring transactions in the topics Match incoming payments manually and Match outgoing payments manually.