Bank Statements

Overview

The Bank Statements module manages bank transactions for all company accounts. It enables automatic downloading from banking APIs, manual import from file formats, and matching transactions with invoices and cash desk.

Main features:

• Automatic download from bank APIs (FIO, Raiffeisenbank Premium)
• Manual import of statements in ABO/GPC and XML CBA formats
• Automatic and manual matching with issued invoices, received invoices, and cash desk
• Complete change history and audit of all operations
• Export to Excel, print confirmations, send email confirmations
• Support for multiple currencies and bank accounts

User Rights

• 0 = No access - Cannot access the module
• 5 = View all - Can view all transactions
• 10 = View + edit - Can view, match, add notes and import
• 15 = Full access - Can delete transactions and change all settings

Configuration

Connecting a Bank Account

1. Go to Settings → Bank Statements - Connection
2. Enter account name, number, IBAN, SWIFT, and currencies
3. Select API type (FIO, Raiffeisenbank Premium, or none)
4. For FIO: Enter API key from internet banking
5. For Raiffeisenbank: Upload client certificate (P12 format)
6. Enable "Active" and optionally "Automatic download"

Automatic Matching Settings

• Match with received invoices - Auto-find by variable symbol and amount
• Match with issued invoices - Auto-find by variable symbol and amount
• Match only with same amount - When enabled, amounts must match exactly

Importing Transactions

ABO/GPC Format Import

1. Click Actions → Import ABO/GPC format
2. Select the bank account
3. Choose file with .GPC or .ABO extension
4. Click Import

XML CBA Format Import

1. Click Actions → Import XML CBA format
2. Select XML file
3. System auto-detects bank account and imports transactions

API Download

1. Click Actions → API - Download all (or specific account)
2. System connects to bank and downloads new transactions
3. Automatic matching runs if enabled

Matching Transactions

Automatic Matching

1. Click Actions → Match unprocessed
2. System compares variable symbols with invoice numbers
3. Matches transactions with corresponding invoices

Manual Matching

1. Open transaction detail by clicking on the row
2. Click Add in the appropriate column (Received Invoices, Issued Invoices, or Cash Desk)
3. Select invoice or document from the list
4. Enter the amount and optional note
5. Click Save

Transaction Detail

View complete transaction information including:

• Amount, date, symbols (variable, specific, constant)
• Our account and counterparty account details
• Matching with invoices and cash desk
• History of all changes

Available Actions

• Mark as processed - Transaction gets green background
• Print confirmation - Generate PDF confirmation
• Send email confirmation - Send transaction details by email

Filters and Export

• Year filter - Select specific year or "All"
• Processed filter - "Unprocessed only" or "All"
• Currency filter - Filter by CZK, EUR, USD, etc.
• Account filter - Select specific account
• Search - Full-text search across all columns
• Excel export - Export visible transactions
• Print - Print current view