Automate Bank Account Reconciliation

With a job queue entry, 365 business Banking retrieves bank transactions per bank account regularly and applies them automatically.

Business Value

Manually retrieving bank transactions and then matching them against open entries takes time every day. With automation, bank transactions are retrieved and matched regularly without manual intervention. Bank account reconciliation runs in the background.

Feature Description

In 365 business Banking, you automate bank transaction retrieval and automatic matching per bank account with a job queue entry in Microsoft Dynamics 365 Business Central. The job queue entry regularly retrieves new transactions, updates the Payment Reconciliation Journal, and performs automatic matching. You set it up with the Automate bank transaction retrieval action on the bank account card or in the bank account list.

This requires the transactions to be retrieved over a connection. camt files and Universal files are uploaded through a file dialog and therefore cannot be retrieved in the background. The run skips these accounts.

If the bank requires a new consent with a TAN for an account connected through PSD2/XS2A, the run stops with a message, because no web form can be opened in the background. In that case, run the retrieval manually once and sign in. After that, the automation runs again.

For more information on setting up automation, see the article Automating Bank Account Reconciliation.