Alpha Bank Transactions Overview
Importing and managing bank transactions in Alpha
Bank Transactions Overview
The Bank Transactions module imports bank statement data and reconciles transactions against invoices, expenses, and internal transfers.
Importing Transactions
MT940 Import
Bank transactions are imported from MT940 files, a standard bank statement format:
- Navigate to ERP > Bank Transactions
- Click Import and select the MT940 file from your bank
- Transactions are parsed and created with Unmatched status
- Review the imported transactions for accuracy
Each imported transaction includes:
| Field | Description |
|---|---|
| Date | Transaction date |
| Amount | Debit or credit amount |
| Description | Bank statement description |
| Counterparty | Name of the other party |
| Reference | Payment reference or invoice number |
| IBAN | Counterparty bank account |
Transaction Status
stateDiagram-v2
[*] --> Unmatched: Import
Unmatched --> Matched: Auto Match
Unmatched --> ManuallyMatched: Manual Match
Unmatched --> Ignored: Ignore
Matched --> [*]
ManuallyMatched --> [*]
Ignored --> [*]Status Definitions
| Status | Description |
|---|---|
| Unmatched | Imported but not yet linked to any record |
| Matched | Automatically matched to an invoice or expense |
| Manually Matched | Matched by a user to a specific record |
| Ignored | Marked as not requiring reconciliation |
Key Features
Auto-Matching
The system attempts to automatically match imported transactions to existing records based on:
- Invoice number in the payment reference
- Amount matching against open invoices
- Counterparty IBAN matching against known suppliers/clients
Manual Matching
For transactions that cannot be auto-matched, users can manually link them to the correct records.
Filtering and Search
Filter transactions by:
- Status (Unmatched, Matched, Manually Matched, Ignored)
- Date range
- Amount range
- Counterparty name
Navigation
Access Bank Transactions from ERP > Bank Transactions:
- All Transactions - Complete list
- Unmatched - Requiring reconciliation
- Matched - Successfully reconciled
- Ignored - Excluded from reconciliation