Importing bank account statements

• 09/12/2025
• 6 minutes to read

Continia Banking has implemented an advanced process for importing data into the Bank Acc. Reconciliation page or the Payment Reconciliation Journal. This approach enhances the reconciliation workflow by substituting the standard import actions with a more efficient, tailored solution.

On the Banking Import Setup page, you can decide which entries can automatically match, set limits for payment proposal variances, and specify the minimum details required for accurate matching. For more information on the settings of the Banking Import Setup page, refer to the Configuring import settings article.

The import procedure

The import procedure begins by either showing a browse dialog or downloading the file directly from the bank, depending on the bank account setup. Once the account statement is imported, Continia Online converts the files and saves them in the file archive. Then, it imports the converted files into the Bank Acc. Reconciliation page and Payment Reconciliation Journal. During this conversion, the system stores data in various tables based on the type and location of the information in the bank statement.

• Bank transaction header - contains data related to the entire statement file, such as the creation date, unique file ID, balance, and totals.
• Bank transaction line - includes details about each transaction, including date, description, currency information, and amounts.
• Bank transaction detail - stores additional unstructured information related to transaction lines, accessible from the reconciliation pages.
• Bank transaction interest - contains information about interests associated with transaction lines.
• Bank transaction charge - records information about charges related to transaction lines.

To use search text to match accounts

If a bank statement imports into the bank transaction tables but not into the Bank Acc. Reconciliation or Payment Reconciliation Journal, the account may not match.

To fix this:

1. Open the bank account card
2. Add a search term, such as the IBAN or BBAN.
3. Retry the import.

To adjust page layout and actions

To show more or fewer columns:

• On the Bank Transaction - Continia Banking page, and click Page > Select Show More Columns or Show Fewer Columns to adjust the displayed information.

To show more or fewer actions:

• On the Bank Acc. Reconciliation or Payment Reconciliation Journal pages, and click Page > Select Show More Actions or Show Fewer Actions to adjust the available actions.

To manage imported data

From the Bank Acc. Reconciliation and Payment Reconciliation Journal pages, you can manage and review source data. These actions help address discrepancies and provide insights into bank transactions.

Delete and set as Imported

Purpose: Deletes a reconciliation and marks the data as imported to prevent re-import.

Steps:

• Bank Account Reconciliation page - on the action bar, click Actions > Functions > Delete and set as Imported.
• Payment Reconciliation Journal page - on the action bar, click Related > Details > Delete and set as Imported.

This action can be reversed on the Bank Transactions page.

Show Bank Transaction

Purpose: View headers and transaction lines for a reconciliation.

Steps:

• Payment Reconciliation Journal page - on the action bar, selected Related > Details > Show Bank Transaction.
• Bank Acc. Reconciliation page - on the action bar, select Related > Show Bank Transaction.

Set Imported to Company

Purpose: Marks a bank statement as imported to prevent duplicate imports.

Steps:

• Go to the Bank Transactions - Continia Banking page and select Set Imported to Company.

Remove Imported to Company

Purpose: Restores a bank statement line for re-import.

Steps:

1. Go to the Bank Transactions - Continia Banking page.
2. Locate the specific line.
3. Select Remove Imported to Company.

To change the import settings

Banks vary in how they place transaction descriptions. Configure import settings to ensure accurate mapping:

1. Go to Banking Import Setup.
2. Select or create a statement description template.
3. If no template is assigned, the system uses the Posting Description from the Bank Transaction Line table by default.
4. You can override the template at the Bank Account Card level.