Setting up CSV ports using the wizard

  • 15/01/2026
  • 6 minutes to read

Use the CSV Port Setup Wizard to define import formats for CSV or Excel files used in PSP, bank account, and payment reconciliations. This guided process helps you configure file structure, delimiters, column mappings, and optional advanced settings.

To configure general settings

Start by setting up the basic properties of your CSV port, including file upload, row skipping, and column mapping.

To configure general settings:

  1. Search (Search) for and select CSV Port Setup.

  2. Optionally download a sample CSV file to test the setup.

  3. Click Next to begin the wizard.

  4. On the upload step, fill in the following fields:

    • CSV Port Code - a unique identifier for this CSV Port. The system suggests the next available value, but you may enter your own.
    • File Type - select CSV or Excel.
    • Import Target - select what this file will be used to reconcile, such as PSP files, bank accounts, or transactions..
    • Upload File - upload your CSV or Excel file so the wizard can analyze it.

  5. Click Next to continue.

  6. Specify which header or footer rows should be skipped during import. Many CSV or Excel files include extra information, such as titles, bank names, report summaries, or empty lines, that isn’t part of the transactional data. By telling the system which rows to ignore, you make sure that only relevant data is imported.

    • Skip Lines From Start - enter how many top rows to ignore (for example, header text or introductory information).
    • Skip Lines From End - enter how many bottom rows should not be imported.
    • First Line is Header - enable this if the first line contains column names.

  7. In the File Preview you can see how the values affect the file.

  8. Click Next.

  9. Define the structural properties of the file so the system can correctly interpret how data is separated and organized. These settings make sure each column is read accurately during import.

    • CSV Separator - select the character used between columns.
    • CSV Separator Character - if you selected a custom separator, enter it here.
    • Delimiter - specify the delimiter for text fields; enter a custom value if applicable.
    • Column Count - review the detected number of columns (read-only).

  10. Click Next to continue.

  11. Map key posting and reconciliation columns:

    • Posting Date Column - enter the column number or letter (e.g., 1 or A).
    • Posting Description Column - enter the column for primary posting descriptions.
    • Alternative Posting Description Column - enter a fallback column to use when the primary description is blank.

  12. The preview updates automatically. Click Next.

To configure advanced settings

After completing the general setup, define advanced options such as currency columns, local formats, transformations, and meta data.

To configure advanced settings:

  1. Define currency and amount columns:
    • Currency Column - enter the column for currency codes (e.g., 2 or B). If your file doesn’t include a currency column, enter a fixed currency value such as EUR.
    • Amount Column - enter one or more columns containing amounts, separated by commas (e.g., A,5,6).
    • Currencies and Amounts Columns - for multiple currency/amount pairs, enter each pair separated by semicolons (e.g., 2,5;C,F;EUR,7).
  2. Click Next.
  3. Specify the local formats used in the file:
    • Date Format - enter the file’s date pattern (e.g., dd/MM/yyyy, d-M-y). Remember that Microsoft formats use capital letters for months.
    • Decimal Separator - enter the symbol used for decimal values.
    • Thousands Separator - enter the symbol used for thousands grouping.
    • Amount Column - review the amount columns (display-only).
  4. Then define transformations for values:
    • Invert Amounts - enter columns where amounts should be inverted (e.g., change positive to negative).
    • Absolute Amounts - enter columns where amounts should always be positive.
    • Invert Alt. Amounts - enter columns where alternative description amounts should be inverted.
    • Skip Alt. Descriptions - enter columns containing alternative descriptions that should not be imported.
  5. Click Next.
  6. Configure optional advanced settings used for file identification and additional metadata:
    • Header Message ID Column - enter the cell that contains the unique header-level ID (e.g., A3) to prevent duplicate imports.
    • Fixed Columns - define fixed header or footer positions for Posting Description, Posting Date, Currency, and Amount. Use semicolons to separate groups (e.g., B2,B3,B4,B5;C2,C3,EUR,C5).
    • Message ID Column - enter the column for line-level unique identifiers (e.g., 7 or G).
    • Internal Texts Column - review the positions of internal text columns, separated by commas (e.g., 8,9,M,N).
    • Fee Alt. Descr. Column - select columns containing fee-related alternative posting descriptions.
    • Fee Column Names - enter the names of fee-related columns (e.g., Fee,VAT). Click Next.
  7. Review all settings on the final step. If everything is correct, finish the wizard to save your CSV Port setup.