Ship-Client Balances

The Ship-Client Balances action is available only if the Cargo Module is installed and loaded in the system. The action is available from the More Actions submenu.

This report provides a multi-level tabular overview of freight invoice activity and payments, grouped by vessels, clients, and voyages. It serves as a specialized version of the Client Balance Report.

The report is based on two main data sources:

  • Freight Invoices;

  • Payments related to those invoices.

Opening and Configuring the Report

When selected, the report opens in a new window with no data loaded by default. At the top of the screen, filter parameters can be configured (collapsed by default):

  • Period: Operation period (predefined or custom; defaults to the current calendar year).

  • Vessel: Filter by a specific vessel (single-select). If no selection is made, all vessels are included.

  • POL: Loading ports (multi-select).

  • POD: Discharge ports (multi-select).

Click to apply the filters and start loading.

Since this may involve large volumes of data, loading can take time. A progress bar is displayed during the process.

Data Views

After loading, the data is shown in three tabs:

  1. Vessel View — Grouped by vessels;

  2. Client View — Grouped by clients;

  3. Debtors View — Grouped by clients with outstanding balances.

All views use a multi-level structure with expandable rows. Sub-levels can be expanded using the “” icon next to each record.

This view shows freight invoice data grouped by vessels and their voyages.

  • At the top level, each vessel’s voyage is listed.

  • For each voyage, the system groups clients associated with freight invoices under that voyage.

  • Under each client:

    • A list of freight invoices is displayed.

    • Linked payments for each invoice are shown.

    • A summary of package types used in the invoices is included.

This view organizes data from the client perspective.

  • At the top level, each client is shown.

  • Under each client, voyages related to that client’s freight invoices are grouped.

  • For each voyage:

    • Freight invoices are listed.

    • Payments linked to those invoices are shown.

    • A breakdown by package types is included.

This view highlights outstanding balances by client.

  • Only two levels are shown:

    • The client with unpaid invoices.

    • The voyages where the client has outstanding debt.

Invoice and Payment Details

The report supports direct access to source documents:

  • Freight Invoices can be opened in read-only mode by double-clicking the invoice row.

  • Payments can be opened in read-only mode by double-clicking the payment row.

Exporting the Document

Pressing the button generates and saves the Excel file.
Exported tables preserve the same multi-level structure (WYSIWYG), matching the report layout.