Offline Banking for Perfex CRM

This is an extension module for Perfex CRM. Perfex CRM is required to use this module.

Import your bank statements and automatically match transactions with invoices and expenses. Save hours of manual bookkeeping work.

Demo: perfex.demo.phplabor.de
Use login buttons “Admin 1” or “Admin 2”

The Problem

Every month you download bank statements from your online banking. Then you spend hours manually checking which payment belongs to which invoice. Which expense was already booked? Did customer XYZ pay invoice #1234?

The Solution

Offline Banking imports your CSV bank statements and automatically suggests matching invoices and expenses. The intelligent algorithm analyzes invoice numbers, amounts, client names, and dates to find the best matches. One click to confirm – done.

Key Features

Smart Matching Algorithm

• Finds invoice numbers in transaction descriptions
• Matches amounts (exact or within tolerance)
• Compares client names with counterpart names
• Considers date proximity
• Shows confidence score for each suggestion

Flexible CSV Import

• Works with any bank that exports CSV
• Auto-detects delimiter and format
• Visual column mapping editor
• Supports different date formats
• Handles European (1.234,56) and US (1,234.56) number formats
• Duplicate detection prevents double imports

Complete Transaction Management

• Link income to invoices (creates payment record)
• Link expenses to existing expenses
• Create new expenses directly from transactions
• Assign multiple invoices to one transaction
• Ignore transactions (e.g., internal transfers)
• Unassign with option to delete booking

Multi-Account & Multi-Currency

• Unlimited bank accounts
• Individual CSV mapping per account
• Different currency per account
• Account No. / IBAN storage for reference

Perfex SaaS Compatible

Fully compatible with the Perfex SaaS Module by ulutfa.

• Regular License: Master installation only
• Extended License: Master + all Tenants automatically

Included Languages

English, German, French, Spanish, Italian, Portuguese (Brazil)

Requirements

• Perfex CRM 3.0 or higher
• PHP 7.4 or higher

Support

Documentation, license management, and support: https://licenser.phplabor.de

Changelog

Version 1.2.0

- Fix: Fixed table sorting that was off by one column — sorting now correctly applies to the intended column - New: New licensing server adress -New: New linked documentation plattform

Version 1.1.0

- New: Bulk actions - Select multiple transactions to ignore, restore or delete at once - New: Checkbox column in transaction list for multi-selection - New: Context-aware bulk actions (shows "Restore" when viewing ignored transactions) - Fixed: Currency display in account overview now shows currency name instead of ID

Version 1.0.0

Initial release