Bankimport+

Bankimportplus Module for Dolibarr

Demo system available at: https://demo.my-dolibarr.eu

1. Enable Banking – Direct Bank Connection (Open Banking)

• Connect your bank account directly via the Enable Banking API – no CSV file needed
• Supports hundreds of European banks across Austria, Germany, Switzerland and more
• Consent-based secure authorisation (OAuth 2.0 / PSD2)
• Fetch transactions for any date range with one click
• Same preview, matching and import workflow as CSV import

2. CSV Import of Bank Transactions

• Import of bank transaction lists from various e-banking systems in CSV format
• Automatic detection of already imported transactions (duplicate check)
• Two-stage import process: Preview → Selection → Import

3. CAMT Import (ISO 20022 camt.053 XML)

• Import of bank statements in the standardised CAMT format – no import template needed
• Verified against bank statements from Austrian and German banks
• Target bank account detected automatically from the IBAN in the file
• Several statement files can be uploaded and read out one after the other
• Duplicate detection via the bank reference, also across CSV and Enable Banking imports
• Statement number taken over as bank receipt number of the entry (can be switched off)

4. Template Management (CSV)

• Creation and management of multiple CSV templates for different banks
• Configurable parameters per template:
  • Column mapping (date, amount, IBAN, description, etc.)
  • Delimiter (comma / semicolon)
  • Header row present / not present
  • Date format detection (flexible)
  • Time buffer for database queries
  • Assignment to bank accounts
• Default template function
• Template list with creation date, last modification and last usage

5. Intelligent Matching

• Automatic invoice recognition: Matching based on amount and invoice reference in payment reference
• Automatic business partner recognition: Identification via IBAN matching
• Manual assignment: Dropdown fields for business partners and invoices
• Filtering by transaction type (customer / supplier invoices based on amount)

6. Invoice Management

• Automatic marking of invoices as "paid" after successful assignment
• Support for customer invoices and supplier invoices
• Automatic creation of supplier invoices (for negative amounts, optional)
• Linking of payments with bank account and invoice

7. Import History

• Logging of all imports with:
  • Import date and time
  • Username
  • Source (CSV file / Enable Banking)
  • Bank account assignment
  • Number of imported transactions

8. Statistics

• Highest / lowest transactions: Top-10 lists filterable by month and year
• Transactions over 10,000: Special view for large amounts
• Display of date, description and amount

9. Export Functions

• Export of imported transactions in various formats:
  • CSV: Compatible file structure
  • PDF: Formatted documentation
  • XML: Structured data output
• Filtering by date range and bank account