Parse Bank Statement

The Parse Bank Statement action allows automatic processing of bank statement files from supported banks. The system creates payment entries and can optionally match them to existing invoices.

Supported Banks

The list of supported banks is regularly updated. Currently includes, but is not limited to:

  • Hamburg Commercial Bank;

  • Skandinaviska Enskilda Banken;

  • Barclays Bank;

  • Bendura Bank;

  • Ajman Bank;

  • Raiffeisenbank;

  • Banque Misr;

  • Paysera;

  • Revolut;

  • OTB;

  • RAKBANK;

  • and others…

Supported File Formats

Depending on the bank, the following formats are accepted:

  • CSV

  • XLS

  • XLSX

  • PDF

  • XML

Process Overview

  1. The system prompts for a bank statement file.

  2. It identifies the correct parser based on file type and structure.

    • If no parser is available, an error is shown:
      "Unable to find parser to parse Bank Statement."

  3. Once a parser is found, the file content is analyzed.

    • If the bank account number is recognized but not registered in the system, an error is shown.
      The bank account must be added before restarting the action.

  4. The system extracts transaction records and opens a step-by-step interface for further processing.

If a parser for a specific bank statement format is not available, it means the format is not yet supported. To add support for a new format, please contact the TOR system provider.

Step-by-Step Interface

Step 1: Transaction Review and Counterparty Matching

  • A table displays all transactions found in the file.

  • The Counterparty column shows matched counterparties or is highlighted red if not found.

  • To assign a counterparty:

    • Select a transaction row;

    • Use the dropdown at the bottom to choose a contact;

    • Click .

If account matching is enabled, a Client can be set in the same way. This client will be used as a higher priority for selecting invoices.

At the top of the screen, the following options are available:

  1. Ignore Counterparty — Skips transactions without a counterparty.
    Use when statement files do not contain reliable counterparty data.

  2. Don’t Match Invoices — Disables automatic invoice matching.
    Use when payments will be linked to invoices manually.

  3. Don't Match Payments Without Counterparty — Disables automatic matching for payments that do not have a counterparty specified.
    Use when such payments should be matched manually by first assigning a counterparty and an invoice.

    • For automatic matching of payments without a counterparty to work, Ignore Counterparty must be enabled and this checkbox must be cleared.

  4. Matching Settings — Opens invoice matching configuration.

To proceed to the next step, click .
If Ignore Counterparty checkbox is disabled and any transaction has no counterparty assigned, an error appears: "Counterparty must be set for all payments rows."

Step 2: Payments with Unassigned Counterparties (only if needed)

After the initial transaction processing, the system prepares payment objects.

  1. If the Don’t Match Invoices option is not enabled, the system will:

    • Automatically match payments to appropriate invoices with outstanding balances.

      • Follows the same logic as Match Invoices action in the Payment card;

      • Matches are made sequentially;

      • A debt fully covered by one payment will not be considered again for the next.

  2. If the Ignore Counterparty option is enabled and Don’t Match Invoices is not, the system will try to identify both the counterparty and the related invoice using indirect data.

    • If more than one possible invoice is found for a transaction, the system will display the Step 2, allowing manual selection of the correct invoice (similar to how counterparties are selected in Step 1).

Step 3: Payments to Import and Skipped Lines

The final screen includes:

  1. Statement Preview Tab — Visual representation of how the file was parsed.

  2. Invoices with Debt Tab — List of invoices with outstanding balances linked to the account.

  3. Payments to Create — Payments ready for creation.

  4. Skipped Lines — Lines not processed due to errors, inconsistencies, or duplicate payments already in the system.

  5. External Payment Info — Shows the selected payment record from the Payments to Create list.

    • Values can be adjusted and saved by clicking .

    • Switching to another payment without saving will discard changes.

Completing the Process

Click to create and save all payment records from the Payments to Create list to the system database.