Introduction to CSV Ports

  • 2 Min.

Continia Banking lets you import CSV statement files from third-party payment providers, such as PayPal or Klarna, directly into the Payment Reconciliation Journal. It does this through CSV ports that are configurable mappings you set up once per provider to match how that provider formats its files.

Configuring a CSV port means defining parameters such as the separator, date format, and delimiters, and mapping each column to the correct field. To create one, first analyze a sample statement file to identify its structure, then configure the port based on your findings. Once set up, every future file from that provider imports quickly and accurately, with no repeated setup.

Analyze external statement files

Before you configure a new CSV port, it's crucial that you analyze the file you want to import and identify key elements, such as separators, delimiters, and other formatting details. In this way, you can ensure you import all the relevant information from the CSV file and that each column in the CSV file is mapped accurately to a corresponding field in Business Central.

We suggest you review the data in the file in detail and make note of the following before configuring the CSV port in Continia Banking:

  • CSV Separator: Which character is used to separate the values on each line?

  • Delimiter: Which character is used to mark the beginning and end of a text string, for example, the description? It can be single or double quotes.

  • Column headings: Does the file have any headers and if so, does the file include just one header, or more?

  • Headers and footers: Is there any additional information at the beginning or end of the file that may affect data parsing?

  • Date format: Which date format is used in the file? This is important to ensure accurate interpretation during import.

  • Posting descriptions: What information in the file do you want to use for matching during the reconciliation process?

  • Currency: Which currency denomination is used throughout the transactions?

After you have identified these aspects of your statement file, you're ready to configure a CSV port for the specific provider and ensure the accurate and efficient import of bank transactions into Continia Banking.

More resources