Bank Import — Bank import, API and smart reconciliation for Dolibarr

Bank Import

Version 1.3.13 · Dolibarr 18–24

Bank Import — Bank statement import & smart reconciliation

Bank Import automates bank reconciliation inside Dolibarr: import your statements, let the module suggest matches with your invoices, salaries and social/tax charges, then create native Dolibarr payments — always after your validation.

What the module does

• Multi-format import: CSV, OFX, QIF, CAMT.053 XML and MT940. The format is auto-detected or chosen manually.
• Duplicate protection: each entry is identified by a fingerprint (account, source, reference, dates, amount, normalised label, counterparty). Repeated imports never create duplicates.
• Smart reconciliation: each bank line is compared to customer/supplier invoices and down payments, credit notes, and optionally to unpaid salaries and social/tax charges. A score and its reasons guide you.
• Human validation: you approve the line, pick the payment mode and date, then the module creates the native Dolibarr payment (invoice, salary or charge) and the related bank entry. Credit notes are only pointed and locked, with no automatic payment.
• No double payment: bank entries already present in Dolibarr are suggested for pointing only.
• Import batch management: batch details, deletion of a batch or a single line, reset of test data sets. Pointed, paid or locked lines are protected; forcing is admin-only and never deletes an already-created payment.
• Payment type detection: cheque, card, transfer, direct debit, domiciled bill, cash.
• Bank connectors: connector profiles with a secret reference (never the raw key). Automated synchronisation requires a bank/provider specific adapter (PSD2/EBICS).

Key benefits

• 5 import formats with auto-detection
• Scored, explained reconciliation (amount, reference, third party, direction, date)
• Invoices, down payments, credit notes, salaries and social/tax charges
• Payments created only after human validation
• Integrates in the Bank menu, feeds native Dolibarr objects
• Compatible with Dolibarr 18 to 24, multilingual (fr, en, de, es, it)

Requirements

• Dolibarr 18.0 to 24.x — PHP 8.0+
• Banks/Cash module enabled, one bank account and one payment mode
• Payment-creation permission for the validating user

Going further

Also discover the KSIDol Signature Terminal, to sign any native Dolibarr document sheet — compatible with all KSIDol modules. Find all modules on ksidol.io.

Publisher: KSIDol.io — Licence: GPLv3 — Compatibility: Dolibarr 18 → 24, PHP 8.0+.

Official resources

Support and assistance

Publisher assistance and technical requests through KSIDol.

KSIDol.io