• ABN AMRO
• Rabobank
• ING
• ASN Bank
• RegioBank
• SNS Bank
• Knab
• Bunq
• Triodos
To install the Banking NL app you simply navigate to the Microsoft Marketplace for Business Central apps (AppSource) via your own Business Central environment. From here you can automatically install the extension and make it available within every company in your Business Central environment.
For the correct working of the app, make sure that the setting for the Micro Apps Base App is set to “allowing HttpClient Request”.
Prerequisite:
Before the Banking NL app can be used to its full potential, a couple of settings need to be set up. In this chapter we will discuss these settings.
Bank accounts:
The bank accounts that are going to be used via the banking interface need to have the following configuration.
General journal template:
The Banking NL app uses as much of the standard Business Central functionality as possible. This means that Business Central need to be configured in such a way that the base functionality can be used.
This also means that for each of the bank accounts that will be used via the banking interface extension a general journal template is needed. Refer to the table below for the information that is required:
| Field | Value |
|---|---|
|
Type |
Bank |
|
Bal. account type |
Bank account |
|
Bal. account |
Bank account that will be used as balance account when the gen. journal is used. |
|
No. Series |
No. series that will be used for the numbering of the journals. |
|
Force Doc. Balance |
True / Active |
|
Copy VAT setup to line |
True / Active |
The general journal template must be setup in Business Central. In the picture below an example is shown for a ‘ABN AMRO’ bank account:
> Click to enlarge <
This needs to be configured for every bank account that will be used via the banking interface extension. In case this is not configured correctly transactions cannot be imported using this app.
Financial service provider:
The Banking NL app uses the services of a third-party to enable functionality for transactions to be imported. The financial service provided chosen by Micro-Apps is Bizcuit. Bizcuit is a fully licensed financial service provider that connects with any Dutch bank via PSD2.
This means that the app has no direct access to your bank account as Bizcuit is handling all the financial transactions.
With the use of the PSD2 act the financial service provider only has access to the bank account for a limited time. This means that after a period of 3 months (90-days) the mandate needs to be renewed with Bizcuit.
Once the installation is complete, the app needs to be set up. This can be done via the Banking NL setup wizard. This wizard contains all the necessary steps to completely set up the extension. The first step is to register yourself and to activate the trial:
> Click to enlarge <
> Click to enlarge <
Account registration:
The actions on the setup page are divided into two areas, the first is the general page itself. Here you will be able to enable or disable the entire extension and you are also able to authenticate the extension with the financial service provider Bizcuit.
1. To authenticate with Bizcuit an account is needed. The first step is therefor to click the ‘Create account’ button in the wizard.
> Click to enlarge <
Note: The banking interface app will create a company (administration) in the Bizcuit Portal that is named after the company from which the bank account is registered. If there is already a ‘Privé’ company (administration) created within Bizcuit that is holding the same bank account as that you are trying to set-up, this bank account needs to be deleted first from this company.
Within the Bizcuit platform go to ‘Balance’ and open the dropdown menu to see which bank accounts the companies hold. If a company that is not ‘Micro Apps Bankkoppeling…’ hold the same bank account, this account can be deleted by going to the overview of the bank accounts, go to ‘settings’ and delete the bank account. Then continue with the next step.
2. After an account is created, you have to authenticate the app by using the ‘Authenticate’ button in the wizard. This will link your Business Central company to Bizcuit and you are able to use the extension. When this is done, the app will automatically be set to ‘Active’.
> Click to enlarge <
Bank account registration:
After registering a Bizcuit account and authenticating, the bank accounts need to be registered with Bizcuit too. This can be done with the Banking NL setup wizard, by clicking the ‘Register bank account’ button in the wizard:
> Click to enlarge <
The newly shown page will show all the bank accounts that are eligible to be registered with Bizcuit. The banking interface app checks if the bank accounts is already known in Bizcuit, if this is the case the bank account will not be shown.
> Click to enlarge <
To register a bank account, you select the bank account you would like to register and click on ‘OK’. This will register the bank account within Bizcuit. To register multiple bank accounts at once, hold shift and click on the bank accounts that you would like to register, after selecting the desired bank accounts click ‘OK’. After clicking OK, you will be asked to give consent to Bizcuit and you will be directed to the Bizcuit website to do so.
If you would login into the Bizcuit portal you would see the registered bank accounts listed as in the image below. The banking interface app will also create a company in the Bizcuit portal that is named after the company from which the bank account is registered.
> Click to enlarge <
Job queues:
The Banking NL app does have functionality to import the latest transactions automatically into the Bank/Giro Journal. This is done via a job queue that is created at the time the extension is installed.
To start the automatic processing of the transactions, the job queue needs to be started because these are inserted with status ‘On Hold’ by default. To create and start the job queue you click on ‘Create Job queues’ in the Banking NL setup wizard. This will open all the job queues that are currently configured. To start the job queue you simply select the banking interface job queue and click ‘Restart’ in the ribbon.
> Click to enlarge <
A job queue will be created for each of the banks that are currently supported by the Banking Interface extension. Below you will see an example of each of the job queues that will be created when the ABN AMRO, ING and Rabobank interface extension is installed.
> Click to enlarge <
Importing bank transactions:
After the installation and registration of the bank accounts with Bizcuit, you can import the transaction(s) that are ready for import. Importing transaction(s) can be done via one of the following ways:
When transactions are being imported, a call will be made to Bizcuit to determine which transactions need to be processed. Therefor only transactions that are not yet imported will be downloaded from Bizcuit. It is therefore important not to import transactions via the standard Business Central functionality, when the banking interface is being used to process bank transactions.
Manually importing transactions:
To manually import transactions, the following actions need to be performed.
Via bank-/giro Journal:
> Click to enlarge <
The imported transaction will be placed in a bank journal. These journals will need to be checked and posted before the transaction will be visible in the General Ledger of Business Central.
In the case that transactions from a specific date need to be imported, the function Import transaction by from date may be used. Doing so will take you through the same steps as the function Import transaction with one additional page where a date may be picked.
> Click to enlarge <
Via Bank Account card:
To manually import transaction the following actions need to be performed.
The imported transaction will be placed in a bank journal. These journals will need to be checked and posted before the transaction will be visible in the General Ledger of Business Central.
Caution: Keep in mind that as the import usage standard Business Central functionality, blocking customers or vendors may result in error messages. To overcome these error message, the following blocking settings may be used. For customers only use the blocking method Shipment, when vendors are blocked the method of Payment may be used to block vendor but still be able to import transactions.
Processing Payments:
The payments via the bank interface extension makes heavy use of the standard Business Central functionality to export the payments, in particular the functionality that can be found in the Dutch localization.
As the standard functionality is used to create the proposal, it is necessary to define the transaction mode on the vendor ledger entries. The next step is to navigate to the Telebank – Bank overview page and in the ribbon click on Process → Get Proposal Entries.
> Click to enlarge <
Whiles creating the proposal entries, Business Central will go through all the vender and customer ledger entries and will select the entries that fall within the range of set filters. Attention: To be able to send the payment to Bizcuit only payments with currency Euro are allowed, therefore an additional filter needs to be set on when performing the function Get Proposal Entries.
On both the Customer and Vendor ledger entries, in case the administration currency is Euro, the following filter must be set: Currency code = ‘’ (Single quotes without a space in between). If the administration currency is set to a differently, please choose the currency code EURO.
> Click to enlarge <
After creating of the proposal entries is completed an amount should be shown in the column Proposal. You may need to refresh the page for the amount to show (F5).
> Click to enlarge <
The next step would be to process the proposal, this will create a payment run within Business Central. To have a create overview of the payments run and to export them, either click on the amount that is shown in the column Payment History or click the corresponding button in the ribbon.
> Click to enlarge <
The payment hasn’t been send to Bizcuit yet for processing this step needs to be executed manually by the user. To export the payment, navigate to Process in the ribbon and click the button Send Payment History to Bizcuit. This will send the payment to Bizcuit for further processing.
> Click to enlarge <
After sending the payment to Bizcuit, an message will be displayed stating that the payment needs to be approved within Bizcuit, is done to ensure that only users with the correct authority are able to approve payments.
> Click to enlarge <
At the moment the payments are send to Bizcuit the field directly under the header Bizcuit Status will be set to New. This means the payments still needs to be approved within the Bizcuit portal. The following statuses are present:
In case the status is not automatically updated, the user may request an update by using the Update Bizcuit Status from the ribbon on the payment history card.
Importing payment into bank journal:
After the payment has been processed by the bank, the payment may be imported into the bank journal. To add the processed payments, either create a new bank journal or use the bank journal that has been created by the bank interface app when importing the bank transactions.
To add the payment, open the bank journal, navigate to More options → Related → Telebank → Insert Bizcuit Payment History.
> Click to enlarge <
A new page will open with an overview of all the payments that are processed, although all payments that are currently being processed will be displayed, only those that are Done processing will be eligible for importing.
> Click to enlarge <
During the importing process all payments with the status done will be processed and added to the bank journal. Business Central will keep track of all the payments that have been added to a bank journal. This will prevent the importing of payments into multiple bank journals.
The last step in the importing and processing of the payments is to post the bank journal, this will set the payment as processed and will set the remaining amount to €0,00.
Got a great app idea you want us to develop for Business Central? Click the button (form pops up), tell us what you want and we’ll get in touch!
Want to resell one (or more) of the suggested apps. Click the button, fill out the (pop-up) form and we will get in touch with you.
Kastanjelaan 400 (Microlab)
5616 LZ Eindhoven
info@micro-apps.com
040 – 303 23 29
Want to resell one (or more) of the suggested apps. Click the button, fill out the (pop-up) form and we will get in touch with you.
Kastanjelaan 400, 5616 LZ Microlab Eindhoven info@micro-apps.com 040 – 303 23 29
Want to resell one (or more) of the suggested apps. Fill out the pop-up form and we will get in touch with you.
If Something Wasn’t Clear?
Feel free to contact us, and we’ll be more than happy to answer all of your questions.
