Export Payments

The Export Payments action exports payments linked to bank accounts for a selected period. This action is available on the toolbar. The export file is generated in XLS format.

Export Flow

  1. In the main list of objects, one or several Bank Accounts are selected.

  2. After clicking , the period selection window opens.

  3. After confirming the period, a file explorer window opens to select the save location.

  4. Once the file is saved, the system prompts to open the exported file.

As a result, an Excel file with payment statements is generated.

File Naming

The exported file is named using the following pattern: BALANCE Selected Period.xls.

Example format: BALANCE DD.MM.YY - DD.MM.YY.xls.

Multiple Bank Accounts

If several bank accounts are selected, payment statements are created:

  • One worksheet per bank account.

  • All worksheets are included in the same Excel file.

Worksheet Naming Rules

Worksheet names follow this structure:

Sequential Number · Client Short Name · Bank Short Name · Currency

Additional rules:

  • If a worksheet with the same combination already exists, the last 4 digits of the bank account number are added to the name.

  • If a worksheet name exceeds 31 characters, it is truncated to 31 characters.

  • If a short name is not defined, the full name of the client or bank is used instead.

Worksheet Columns

Each worksheet contains the following columns:

  1. Payment Date (sorted from earliest to latest);

  2. Amount;

  3. Balance (account balance after the payment);

  4. Currency;

  5. Counterparty;

  6. Purpose;

  7. Description;

  8. Vessel (from the invoice linked to the payment);

  9. Paid Invoice â„–;

  10. Account â„–.