Dolibarr Bank Reconciliation & Statement Import | KSIDol

Dolibarr Bank Reconciliation Module - Bank statement import software

Bank Import is a Dolibarr module designed to import bank entries, reconcile movements with invoices and create native Dolibarr payments after human validation.

It helps businesses reduce manual entry, control reconciliation decisions and keep a clear audit trail for import batches, matches and payments.

Main features

• Import CSV, OFX, QIF, CAMT.053 XML and simple MT940 bank statement files.
• Tolerant parsing for legacy bank exports with separators, encodings and debit/credit columns.
• Import batches with id, fingerprint and duplicate protection.
• Smart matching by amount, third party, reference, invoice number, direction and date consistency.
• Manual invoice assignment when the automatic proposal is not the right one.
• Reject irrelevant matches to avoid accidental validation.
• Create native Dolibarr payments for compatible customer invoices, supplier invoices and deposits.
• Select the active payment mode and confirm the receipt date before validation.
• Lock reconciliation after review to prevent reusing the same bank entry.
• PSD2, EBICS or custom API connector profiles with external secret reference.

Business workflow

1. Configure the bank account, payment modes and matching thresholds.
2. Import a bank file or prepare a connector profile.
3. Review the import batch and detected entries.
4. Generate the proposed matches.
5. Approve, reject or manually assign an invoice.
6. Create the native Dolibarr payment, then lock the reconciliation after review.

Business benefits

The Dolibarr bank reconciliation module speeds up payment follow-up, reduces data entry mistakes and keeps human control before each accounting action. It is useful for companies that want cleaner bank statement imports, invoice payments and traceability inside their ERP CRM.

Compatibility

Standalone external module for Dolibarr 16.0 or higher and PHP 8.0 or higher. Installed in htdocs/custom/bankimport/, without modifying Dolibarr core files.