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

• Invoice matching by reference: the remittance information is checked against the numbers of all open invoices, and the amount then confirms the match
• Supplier invoices are also matched by the vendor's own invoice number – an outgoing transfer usually names that one rather than your internal reference
• Collective transfers: one bank entry can settle several invoices at once; further invoices can be added by hand with the "+" button
• Cash discount: invoices paid minus an agreed early payment discount are recognized; the payment is booked over the amount actually received and the invoice closed with the reason "discount" (can be switched off)
• Foreign currency: invoices in another currency are matched despite the exchange rate difference between invoice and payment day, within an adjustable tolerance
• Badges show in the preview what the import is going to do: cash discount, foreign currency, partial payment, overpayment – or a warning when the sum of the selected invoices does not fit the amount
• Payments already recorded by hand are recognized and shown next to the line from the import file, instead of being offered for booking a second time
• Automatic partner matching through IBAN comparison
• Search dropdowns for partners and invoices: results are loaded while you type – by number, name or amount. The preview stays fast even with thousands of open invoices

6. Creating or Assigning Documents on Import

• For every entry no invoice was found for, you pick the document type; a dialog then asks for exactly what that document needs
• Available types: supplier invoice, customer invoice, VAT payment, social contribution, salary, expense report, transfer between your own accounts and miscellaneous payment
• What is offered depends on the modules enabled, the rights of the user and the direction of the entry
• Assign an existing document instead of creating one – an expense report already approved, for instance
• The document is created on import, paid over the bank amount and linked to the entry
• The same choice can be applied to all further entries with the same counterparty IBAN – handy for recurring payments
• The ledger account of a miscellaneous payment is picked from the real chart of accounts
• Assigned invoices are set to paid automatically (can be switched off), with the payment linked to both 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