Bankimport+

Summary: Bankimportplus Module for Dolibarr

1. 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

2. Template Management

• 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

3. Intelligent Assignments

• 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 for non-automatic recognition
• Filtering by transaction type (customer/supplier invoices based on amount)

4. 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

5. File Management

• Upload of CSV files with size restriction
• Temporary storage in import/temp
• Option to automatically delete after successful import
• File preview and download option

6. Import History

• Logging of all imports with:
  • Import date and time
  • Username
  • Filename
  • Bank account assignment
  • Number of imported transactions
• Unique import identifier (timestamp) for statistics

7. Statistics

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

8. 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

9. Configuration Options (Admin)

• BANKIMPORTPLUS_SETFACTUREPAID: Automatic marking of invoices as paid (Yes/No)
• BANKIMPORTPLUS_LANDING_PAGE: Configurable landing page after