BankImport+ User Guide

1. Overview

BankImportPlus lets you import bank transactions directly into your Dolibarr bank account. The module automatically detects which entries already exist (duplicate protection) and tries to match each transaction to an open invoice or a business partner – saving you a lot of manual reconciliation work.

The module provides two import methods:

2. CSV Import

2.1 Creating an import template

An import template tells the module how your CSV file is structured: which column contains the date, which contains the amount, which contains the payment reference, etc. You only need to create this template once per bank and can reuse it for all future imports.

💡 Tip: Open your CSV file in Excel or LibreOffice Calc to identify the column numbers. The first column is column 1, the second is column 2, etc. Also check whether the first row is a header row – you can specify this in the template.
  1. Open the menu: Import Templates → Add Template
  2. Enter a descriptive name (e.g. "First Bank")
  3. Select the corresponding Dolibarr bank account from the list
  4. Enter the column number for each field (date, amount, business partner, payment reference)
  5. Select the date format, separator type (comma or semicolon), and thousands/decimal separators
  6. Click Save – the template is now ready to use
💡 Default template: In the template list you can mark a template as the default by clicking the star icon (☆). The default template is automatically pre-selected on the upload page – you don't need to select it manually every time.

2.2 Importing a CSV file

Once your import template is set up, you can upload CSV files:

  1. Open the menu: Import Bank Data → via CSV File
  2. Select your import template from the dropdown list
  3. Click Choose File and upload the export file from your bank
  4. Click Read – the module reads the file and shows a preview
  5. In the preview, select the transactions you want to import and click Import
💡 Import & delete file: Next to the Import button there is also an Import & delete file button. This automatically removes the uploaded CSV file from the server after a successful import.

2.3 Preview and assignment

The preview shows all read transactions side by side with the existing Dolibarr bank entries. This gives you a clear view of which entries are new and which already exist.

💡 Note on automatic matching: The automatic matching can occasionally be inaccurate – for example when your bank retroactively changes the booking date of a transaction compared to a previous import. Always review the pre-selected entries carefully before confirming the import.

2.4 Automatic supplier invoice creation

For outgoing payments (negative amount), the module can automatically create a supplier invoice in Dolibarr, validate it, and mark it as paid.

Prerequisites

How it works

  1. In the preview table, a checkbox appears in the "SI" column for every negative-amount entry that does not yet have a matching Dolibarr bank entry
  2. Tick the checkbox for the desired entries
  3. Select the appropriate supplier from the Business partner dropdown
  4. Click Import – the module automatically creates a supplier invoice for each ticked entry

Each created supplier invoice contains:

⚠️ The supplier invoice is only created if a business partner is selected. If no partner is selected, an error message is shown and the entry is skipped.
💡 The SI checkbox only appears for negative-amount entries that do not yet have a corresponding entry in Dolibarr.

3. Enable Banking (direct bank import)

3.1 What is Enable Banking?

Enable Banking is a European service that allows you to securely fetch bank transactions directly from your online banking – without manual CSV exports. The connection uses the legally regulated PSD2 standard (EU open banking directive), which requires you to explicitly grant the application access to your account data.

Enable Banking supports over 2,000 banks across Europe, including banks in Austria, Germany, France, Spain, and many other EU countries.

Transactions are always fetched manually – there is no automatic background process. You decide when to retrieve new entries from your bank.

3.2 Setting up an Enable Banking account & app

⚠️ This setup requires a Dolibarr user with administrator rights and access to the server where Dolibarr is running.

This is a one-time setup that takes approximately 15–20 minutes.

1
Create an Enable Banking account Visit enablebanking.com and create a free account. After registering, you will receive a confirmation email – click the link to activate your account.
2
Log in to the Control Panel Log in at enablebanking.com/cp (Control Panel). This is where you manage your applications and API access. On first login, the application list will be empty.
3
Create a new application under "API applications" In the Control Panel menu, click API applications and then New Application. The application registration form will open.
4
Fill in the registration form

1. Choose environment – click "Production":
Click the Production button (not Sandbox!). Sandbox is intended for developers and testing only and supports only a limited number of banks.

2. Choose RSA key method:
Select the option that matches your technical experience:

  • "Generate in the browser" (recommended for beginners): Enable Banking automatically generates the key pair in your browser. The private key is downloaded as a file immediately after registration. No terminal or technical knowledge required.
  • "Generate outside the browser" (for advanced users): You generate the key pair yourself and upload only the public key as a certificate. Commands in a Linux/Mac terminal: openssl genrsa -out private_key.pem 2048 openssl rsa -in private_key.pem -pubout -out public_key.pem Then upload the generated public_key.pem as the certificate.

3. Fill in the form fields:

  • Application name: Any name, e.g. "Dolibarr BankImportPlus"
  • Allowed redirect URLs: The callback URL of your Dolibarr installation (one URL per line): https://your-dolibarr-instance.example.com/custom/bankimportplus/bankimportplus_eb_callback.php
  • Application description: Required – enter Bankimport+ for Dolibarr
  • Email for data protection matters: Your email address (for GDPR/privacy inquiries)
  • Privacy URL: Required – enter the following URL: https://your-dolibarr-instance.example.com/custom/bankimportplus/bankimportplus_privacy.php
  • Terms URL: Required – enter the following URL: https://your-dolibarr-instance.example.com/custom/bankimportplus/bankimportplus_terms.php

Finally, click Register.

5
Save the private key
  • Browser method: The private key is automatically downloaded as a file after registration. Save it immediately in a secure location – Enable Banking does not store it and it cannot be retrieved later!
  • Manual method: Use the private_key.pem file you generated with OpenSSL in step 4.
6
Activate the app by linking your own bank account

After registration, the app appears in the Control Panel with the status Inactive. To activate the application, you need to link your own bank account (the account from which you want to import transactions) to the Enable Banking app.

Click the Activate by linking accounts button.

7
Select your bank and link it

Three selection fields appear:

  1. Country: Select your bank's country (e.g. "AT" for Austria)
  2. ASPSP: Select your bank from the list
  3. Usage type: Select account type – "Private" or "Business"

Then click Link.

8
Complete authentication via your bank's e-banking app

You will be redirected to Enable Banking's authentication page. Click Continue authentication to proceed.

Complete the authentication using your bank's e-banking app – typically via a push notification, QR code scan, or SMS code. After successful authentication, the app is activated and your bank account is linked.

💡 This account linking in the Enable Banking Control Panel activates the application. Connecting for the actual data retrieval in Dolibarr is done in section 3.3.
9
Note your App ID After registration, the application overview shows your Application ID (e.g. "a1b2c3d4-e5f6-…"). Copy or note this ID – you will need it for the Dolibarr configuration.
10
Store the private key securely on the server

Copy private_key.pem to the server running Dolibarr – but outside the web directory (not inside htdocs!). Note the full path, e.g.:

/home/dolibarr/keys/private_key.pem
⚠️ The private key must never be stored in a publicly accessible web directory! Make sure only the web server user has read access to the file.
11
Configure the module settings in Dolibarr

Go to: Administration → Modules/Applications → BankImportPlus → Settings (gear icon). Enter the following values:

  • Enable Banking App ID: the App ID from step 9
  • Enable Banking Private Key Path: the full server path from step 10 (e.g. /home/dolibarr/keys/private_key.pem)

Click Save. The Enable Banking submenu now appears in the BankImportPlus left menu.

3.3 Connecting a bank account in Dolibarr

Once the settings are saved, you can connect your bank account:

  1. Open the menu: Enable Banking → Connect bank account
  2. Select your bank's country (e.g. "DE" for Germany, "AT" for Austria)
  3. Click Load banks and select your bank from the list
  4. Select the corresponding Dolibarr bank account to link the transactions to
  5. Click Connect with bank – you will be redirected to your bank's login page
  6. Log in to your bank and confirm the data access for the application (PSD2 consent)
  7. You will be automatically redirected back to Dolibarr. The connection is now active.
💡 Bank data access is typically valid for 90 days (depending on your bank). Shortly before expiry, the module will show a warning – click Reconnect to renew access.

If your bank returns multiple accounts after authentication, a selection page appears – choose the desired account and confirm.

To remove an existing EB connection, click the Delete icon next to the relevant account in the connection list.

3.4 Fetching transactions manually

Fetching transactions is always done manually. There is no automatic background process – you decide when to retrieve new entries from your bank.

  1. Open the menu: Import Bank Data → via Enable Banking
  2. Select the connected bank account and the desired date range (From – To)
  3. Click Load preview – the module fetches the transactions from Enable Banking
  4. Review the transactions in the preview and click Import

4. Automatic matching (invoices & business partners)

The module automatically tries to match each imported transaction to an open invoice or a business partner in Dolibarr. It works in this order:

  1. Invoice reference: The transaction's payment reference is searched for invoice numbers (e.g. "INV-2025-0042"). Found numbers are compared against open invoices in Dolibarr.
  2. Amount: In addition to the reference, the system checks whether the transaction amount matches the amount of an open invoice.
  3. IBAN: If a counterparty IBAN is available in the data, the system checks whether a Dolibarr business partner has this IBAN on file.
💡 For incoming payments (positive amount), customer invoices are searched. For outgoing payments (negative amount), supplier invoices are searched. Only open (unpaid) invoices are considered.

If no automatic match is found, you can manually select the invoice and business partner from a dropdown list in the import preview.

5. Statistics & reports

The Statistics menu provides two reports:

Select the month and year from the dropdown at the top and click Show.

💡 Statistics only include transactions imported via CSV. Transactions fetched via Enable Banking are not shown in the statistics.

6. Export

Under Export you can download your imported bank transactions in various formats:

Select a date range (From – To) and optionally a specific bank account. If no account is selected, all accounts are exported. Then click Generate Export.

💡 The export only includes transactions imported via CSV. Transactions fetched via Enable Banking are not included in the export.

7. Import history

Under Import History you will find a complete record of all past imports. For each import, the following information is displayed:

The history serves as an audit trail and makes it easier to investigate unclear imports.

8. Module settings

The module settings page is accessible via: Administration → Modules/Applications → BankImportPlus → Settings (gear icon).

Setting Description
Automatically mark invoices as paid When enabled, a matched invoice is automatically set to "Paid" during import. Enabled by default.
Enable Banking App ID The Application ID from the Enable Banking Control Panel – required for all EB features.
Enable Banking private key path Full server path to the RSA private key file. The file must be stored outside the web directory (not inside htdocs!).
Enable Banking debug logging Enables detailed logging to the Apache error log. Only activate for troubleshooting – leave disabled during normal operation.
EB duplicate detection buffer days Number of days by which the date range is extended for Enable Banking duplicate detection. Default: 5 days. Increase this value if transactions with a value date just outside the fetched period are incorrectly detected as duplicates.
Landing page after import URL of the page to redirect to after a successful import. Default: the BankImportPlus start page.
↑ Back to top