Setting up CSV ports
Once you have analyzed the file you want to import and identified separators, delimiters, and other formatting elements, you are ready to map each column in the CSV file to a corresponding field in Continia Banking.
To get started quickly, use the CSV Port Setup wizard. For step-by-step instructions, see Setting up CSV ports using the wizard. You can open the wizard by clicking Setup CSV Port on the action bar.
To add a CSV port
To set up a CSV port:
Search () for and select CSV ports - Continia Banking.
On the action bar, select New to create a new port.
On the CSV port page, enter the general information:
On the Setup FastTab, enter the information used to map the fields:
On the Positions FastTab, enter the column positions:
To set amount format rules
On the Amount Format Rules page, you can select the column that contains the amount and configure how the value should be transformed. You can set the amount to absolute, invert the sign, choose a type of amount, or specify whether certain values should be inverted or skipped. The rules shown on the CSV port card are available for verification only. To add, edit, or drill down into columns and values, use the wizard.
To configure amount format rules:
Search () for and select CSV Ports - Continia Banking.
Open a CSV port, and on the action bar, click Amount Format Rules.
The following table describes the available fields:
To configure column mappings
Column mappings let you define how values from your CSV file are interpreted and assigned to fields such as document type, bank account, dimensions, and other data during import.
To configure column mappings:
- Search () for and select CSV Ports - Continia Banking.
- Open a CSV port and on the action bar, select Column Mappings.
On the Column Mappings page, configure the following:
To configure text format rules
Text format rules let you transform text values from your CSV file before importing them. You can use a rule to extract a fixed part of a value or remove unwanted characters.
To configure text format rules:
- Search () for and select CSV Ports - Continia Banking.
- Open a CSV port, and on the action bar, select Text Format Rules.
On the Text Format Rules page, configure the following:
To start the import process
After you map the fields of the CSV file on the CSV Port page, the file is ready to be handled and reconciled. After you map the fields of the CSV file on the CSV Port page, the file is ready to be imported. What you do next depends on the import target of the CSV port:
- PSP - add a PSP agreement for the payment service provider, and import the file in a cash receipt journal.
- Transactions or Account Statement - set up the bank accounts that you want to import files for, and import the file in the Payment Reconciliation Journal. A file with the import target Account Statement can also be imported in the Bank Acc. Reconciliation.
To import a file for a bank account:
- Set up the bank account for the CSV port by using the Setup Bank Account action on the CSV Port - Continia Banking page.
- Search () for and select Payment Reconciliation Journals, and open the journal. The bank account needs a bank code and the same currency as the transactions in the CSV file.
- On the action bar, select Home, and then in the Import CSV group, select Import and Apply CSV Transactions. In versions earlier than 29.0.0, select Import CSV Payments.
- In the Import CSV File dialog, select the CSV port that you want to import, and then select the file when you are prompted to upload a file.
- In the Bank Accounts and Currencies dialog, select the bank account for each currency in the file. The dialog opens every time you import a file, because a payment reconciliation journal belongs to one bank account and one currency. The selection is saved and suggested the next time you import a file for the same CSV port and currency.
- You can now reconcile lines in the journal. For more information about processing lines in the Payment Reconciliation Journal, refer to the dedicated article.
Related information
Introducing CSV Ports
Setting up CSV Ports using the wizard
Importing and exporting CSV ports