KSIDol documentation > KSIDol modules > Bank Import

Module guide: Bank Import

Non-technical user guide: what the module is for, how to use it and how it fits together with Dolibarr.

Bank formats imported5: CSV, OFX, QIF, CAMT.053, MT940

Documents reconciledInvoices, down payments, credit notes, salaries, charges

Dolibarr paymentCreated only after human validation

CompatibilityDolibarr 18+ - PHP 8+

1. Module overview

Bank Import is a KSIDol module that brings your bank statements into Dolibarr and helps you match every movement with the right accounting document. You import a file from your bank (or you prepare an API connector profile), the module automatically suggests the invoices, down payments, credit notes, salaries or charges that best match each line, then, after your validation, it creates the native Dolibarr payment and settles the invoice. The goal: less manual entry, faster reconciliation and up-to-date accounting, without ever letting the module act on its own.

It relies entirely on native Dolibarr objects: bank accounts, customer and supplier invoices, down payments, credit notes, salaries, social/tax charges and payment methods.
No modification of the Dolibarr core: the module adds its own pages and its own tables, in the Bank/Cash menu.
Control stays human: the Dolibarr payment is never created without you having validated the match.
Once a bank entry is paid or reconciled, it is locked and no longer suggested, which avoids double payments.

2. Importing bank statements

The Bank Import page lets you upload a file provided by your bank and turn each operation into an entry ready to be reconciled, on the Dolibarr bank account of your choice.

Support for 5 formats: CSV, OFX, QIF, CAMT.053 XML and MT940 (.sta files), with an option to detect the format automatically.
Tolerant reading of CSV exports: various separators, Windows/ISO encodings, old dates and separate debit/credit columns.
Choice of the destination Dolibarr bank account (a default account can be pre-selected in the configuration).
Each imported file becomes an identified import batch, with a fingerprint, to keep track of what has been loaded.
Anti-duplicate protection: the module rejects an operation already present (file fingerprint and business key date + account + amount + label + counterparty).
Display of a diagnosis of the first lines in error to fix a malformed file.
Security checks: allowed file extensions and a configurable maximum import size.

3. Dashboard and import tracking

The module's home page gives an overview of reconciliation activity and quick access to the latest imported operations.

Four figure-bearing, clickable tiles: imported transactions, suggested matches, approved lines and payments executed.
A Latest imports panel listing recent batches: date, source, file name, bank account (clickable link to the account record), number of lines imported/read, duplicates and status.
List sortable by column and direct shortcuts to import, matches and import batches.

4. Smart reconciliation of entries

The Bank matches page is the heart of the module: it compares each bank line to the open documents in Dolibarr and suggests the best associations, without ever deciding in your place.

Automatic generation of suggestions (candidates) for the entries to be processed.
Relevance score calculated on several criteria: amount (exact, close, approximate, gap compatible with fees/rounding, partial payment), invoice reference, third-party name or code, direction of the movement and date proximity.
Each suggestion shows its reasons, backed by the evidence found (third-party word, reference spotted...).
Workflow tracking tabs: To process, Approved to pay, Rejected, Completed, All.
Detection of the payment type (cheque, card, transfer, direct debit, bill of exchange, cash) to pre-fill the payment method.
Guided reconciliation in a dedicated window: validating a suggested match, manually assigning an invoice, or partial collection with an amount to reconcile.
Per-line actions: approve, reject, reopen a rejection, cancel an approval, lock after payment.
Entries already reconciled, paid or locked are no longer suggested in new calculations.
Reconciliation is possible with bank entries already present in Dolibarr: in this case, reconciliation only, never a second payment.

5. Creating Dolibarr payments

Once a match is validated, the module creates the corresponding native Dolibarr payment and updates the document, provided you have the right to do so.

Customer invoice settled via a native customer payment; supplier invoice via a native supplier payment.
Customer and supplier down payments are also supported for creating the payment.
Unpaid salaries and social/tax charges: creation of the native Dolibarr salary or charge payment.
The payment generates the link to the invoice, the entry on the bank account and the switch to paid status if the document is fully settled.
Partial payment is possible by entering the amount to reconcile.
Special case of credit notes: they are only reconciled and locked, without automatic creation of a payment.

6. Integration with Dolibarr's native Bank pages

From version 1.3.0, the module appears directly inside Dolibarr's native bank entries (Bank, account, entries), without leaving the usual screen.

"Import a statement" button on an account's entries list: it opens a validation window (the bank concerned and statements already imported) then reuses the module's import, with no double entry.
"Reconciliation" column on each entry: at a glance it tells apart lines pointed through a Bank Import batch from those reconciled natively in Dolibarr.
"Point" action on an unreconciled entry: it opens the module's matching to link the entry to one or several invoices.
No duplicate bank movement: the payment is attached to the existing entry (no new line), then the native reconciliation is ticked automatically once the entry is fully allocated.
Two-way behaviour: pointings and reconciliations are shared between the module and Dolibarr's native Bank screen.
Active as soon as the module is enabled: after an update, just deactivate then reactivate the module to register it, with no manual configuration. Can be turned off in the module configuration if needed.

7. Managing import batches

The Import batches page lets you review what has been loaded, consult its detail and clean up properly, particularly during testing phases.

List of batches with reference, source, file, date, number of lines present and protected, and status.
Batch detail: line-by-line review of the imported entries.
Deletion of a whole batch or of a single import line.
Lines already reconciled or paid are protected; their forced deletion is reserved for administrators and never deletes the Dolibarr payments already created.
Useful to reset a test dataset before going into production.

8. Bank connectors (API preparation)

The Bank connectors page lets you declare connection profiles to banking APIs, with a view to automating the retrieval of entries.

Creation of PSD2/AISP, EBICS or Custom JSON type profiles.
Entry of the provider or bank, the API URL, the linked bank account and the active status.
The secret is never stored in clear text: you enter a secret reference (environment variable or server secret), entered in a protected field.
A warning reminding that a banking API requires a dedicated contract/provider.
Point of caution: actual synchronization requires an adapter specific to the bank or the provider; the profiles prepare the integration but do not trigger an automatic import as standard.

9. Module configuration

The configuration screen adapts the module's behavior to your company and to your way of reconciling.

Default bank account used for imports and payments.
Default payment method suggested at validation.
Amount tolerance to absorb rounding or small fees (0.02 by default).
Strong candidate score and minimum match score, to tune the precision of the suggestions.
Maximum number of invoices analyzed and number of candidates kept per entry (performance).
Maximum size of imported files.
Options to enable/disable: also search in salaries, also search in social/tax charges, and filter on the amount gap (avoids suggestions whose amount has no relation).

10. Access rights (permissions)

The module provides distinct Dolibarr rights to separate viewing, importing, reconciliation and the accounting action.

Read Bank Import: view the dashboard and the entries.
Import bank statements.
Generate and validate matches.
Create Dolibarr payments (accounting action).
Administer Bank Import: configuration and connectors.
This separation allows, for example, a staff member to import and reconcile without being authorized to create the payments.

11. Links with Dolibarr

The module does not work in isolation: it integrates with the native building blocks of Dolibarr.

Bank accounts (Bank/Cash) : Each import targets a Dolibarr bank account; at payment, the entry is posted to that account through the native flow, and the account remains clickable from the dashboard.
Customer invoices : Collection entries are reconciled with open customer invoices; validation creates a native customer payment and settles the invoice if the amount is complete.
Supplier invoices : Disbursements are reconciled with supplier invoices; validation creates a native supplier payment and updates the invoice.
Down payments and credit notes : Customer/supplier down-payment invoices can generate a payment; customer and supplier credit notes are only reconciled and locked, with no automatic payment.
Third parties (companies) : The module recognizes the third party in the bank label (name, keywords, code) to suggest the right documents, relying on Dolibarr third parties.
Salaries and social/tax charges : Optionally, unpaid salaries and social/tax charges are suggested; validation creates the native Dolibarr salary or charge payment.
Payment methods : The suggested payment method comes from the dictionary of active Dolibarr payment methods (c_paiement), and can be pre-detected according to the operation type.
Accounting and document status : Since payments are created by Dolibarr's native mechanisms, they feed the standard accounting and switch fully settled invoices to paid status, with the associated bank line.
Bank / Reconciliation : The module integrates with the native bank entries page (Bank, account, entries): import button, pointing column and "Point" action. Payments created are attached to the existing entry and tick Dolibarr's native reconciliation, without creating a duplicate movement.