Copy page

Incoming Payments and Bank Reconciliation

Automating Bank Account Reconciliation

This page describes how 365 business Banking retrieves bank transactions per bank account regularly through the job queue and applies them automatically.

Instead of choosing Retrieve Bank Transactions every day, you create a job queue entry for a bank account. The entry retrieves the new transactions, writes them into the payment reconciliation journal and, optionally, applies them immediately. You then review and post the lines.

Applies to: PSD2/XS2A via finAPI · EBICS · payment service providers

Prerequisites

• The bank account is connected through 365 business Banking: Connect a bank account.
• You have permission to create job queue entries and set them to Ready.

Standard functionality in Business Central

The job queue runs reports and codeunits in the background at defined times. A job queue entry defines what runs, at which interval and how many attempts are made after an error.

More information from Microsoft: Use job queues to schedule tasks.

What 365 business Banking adds

The Automate bank transaction retrieval action creates a preconfigured job queue entry for the Retrieve Bank Transactions report:

Step by step

1. Open the Bank Account Card of the account, or select the account in the Bank Accounts list.
2. Choose Actions > Automate bank transaction retrieval. The action is only available for connected bank accounts.
3. The request page of the Retrieve Bank Transactions report opens. On the Options FastTab, leave the Apply Automatically toggle turned on if the transactions should be applied immediately. The bank account is already entered in the filters. You can add further connected bank accounts using No., IBAN or SWIFT Code.
4. Choose OK.
5. Business Central reports: "Job Queue Entry to automate bank transaction retrieval has been created. Do you want to open the Job Queue Entry page to review the entry?" Choose Yes.
6. On the Job Queue Entry Card, check frequency, weekdays and start time, and adjust them if required.
7. Choose Set Status to Ready.

What happens on every run

1. Retrieve. For each bank account in the filter, the report retrieves the new transactions. The same rules apply as for manual retrieval, including the duplicate check. In Default mode, the transactions are written into an existing open payment reconciliation journal of the account or into a new one, in the Daily, Weekly and Monthly modes into the journal of their period, and in the Per Bank Statement mode into the journal of their bank statement: Retrieve bank transactions.
2. Apply (only with Apply Automatically). Only journals that received new transactions in this run and contain at least one line with an amount but no application are considered. Journals of earlier periods remain unchanged.
3. Reject first, then apply again. In each of these journals, all automatic applications from earlier runs are rejected. The entire journal is then applied again. Lines with the match confidence Accepted or Manual remain unchanged.

Reasons for rejecting first: Automatic application only considers open entries that are not already applied to another line. Without rejecting, the entries applied by an earlier run would no longer be candidates, while their lines would lose their application in the new run. In addition, the matching can only decide across all lines which entry belongs to which line if the entire journal is applied in one step. The result is therefore the same as choosing Apply Automatically in the journal. Applications that you accepted or made manually are kept.

The order of matching is described in How automatic application works.

What applies per connection

Notes

• No messages in the background. The message after retrieval and the confirmation for more than 50 new journals are only shown for manual retrieval.
• Frequency. The default is one run per day. To retrieve more often, change the number of minutes between runs on the Job Queue Entry Card. With the default Import Until Date Formula (-1D), however, PSD2/XS2A transactions of the current day are only retrieved on the following day.
• Several bank accounts. Each time you use the action, it creates one entry for one bank account. You can also extend the filter on the request page so that one entry retrieves several accounts.
• Only automatic applications are renewed. The run does not change applications that you accepted or made manually in the journal.
• No tolerance questions. If a payment lies after the payment discount date but within the payment discount tolerance, or within the payment tolerance, the run answers the payment discount tolerance warning and the payment tolerance warning without a dialog with their default option. A late payment discount is not granted, and no payment tolerance is posted. The remaining amount stays open and can be applied manually. Apply Automatically in the journal still shows the questions.

Troubleshooting

See also

• Retrieve bank transactions
• Apply bank transactions
• Renew PSD2 consent
• Use job queues to schedule tasks (Microsoft Learn)