Match bank transactions

There are two tabs under Cash and bank. One where you see all bank transaction for a specific period, and one where you see which bank transactions that need to be checked or matched manually. If the button on a transaction row is green, the program has found a likely accounting transaction match, e.g. an invoice, and you can choose to match it by clicking the button. If the button is orange, you need to match the bank transaction against the accounting transaction manually.

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.

In most scenarios, the program is able to match incoming and outgoing payments of invoices, 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 Standaard 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.

Related topics

Work with bank integration
Import bank statements
Manually register bank transaction