Deal Report for Period

The Deal Report for Period action generates a deal report based on a selected period and filtering parameters. This action is available in the More Actions submenu.

Report Generation Flow

Step 1: Report Parameters

The following parameters define how data is loaded and included in the report:

  • Start Date / End Date: Reporting period used to select data.

  • Filter by Company: Filters data by selected Own Company.

  • Include in Period: Defines how data is selected relative to the period.

    1. Invoices Within Period

      • Invoices are loaded based on Invoice Date.

      • All payments linked to these invoices are included.

      • Payments may fall outside the selected period.

    2. Payments Within Period

      • Payments are loaded based on Payment Date.

      • All invoices linked to these payments are included.

      • Invoices may fall outside the selected period.

    3. Invoices and Payments Within Period

      • Combines both approaches:

        • invoices within the period + their payments;

        • payments within the period + their invoices.

      • As a result, both invoices and payments may extend beyond the selected period.

  • Deal Links: Controls whether data must be linked to deals.

    • Invoices out of Deals — Includes invoices not linked to any deal. If not selected, only invoices linked to deals are included.

    • Payments out of Deals — Includes payments not linked to invoices (such payments appear at the end of the report). If not selected, only payments linked to invoices are included.

  • ID Columns: Controls visibility of identifier columns.

    • Show ID Deal.

    • Show ID Invoice.

    • Show ID Payment.

Step 2: Report Preview

After parameters are applied, the system generates a spreadsheet preview.

Data is loaded using the following logic:

  • Invoices and/or payments are selected first (depending on the chosen mode);

  • Related deals are then loaded if a link exists.

This allows including financial records that are not linked to deals, as well as partial deal data associated with the selected invoices or payments.

The report structure and columns match the standard Deal Report.
If the dataset includes both deals with voyages and deals without voyages, separate reports are generated.

Preview Form and Export

The report is displayed in a standard spreadsheet preview form.

Within this form:

  • Data can be reviewed before export.

  • The exported file reflects the modified version displayed in the preview.

Click to save the report as an Excel file.