Funds Allocation Report

The Funds Allocation Report displays how funds are distributed across invoices and payments. This action is available in the More Actions submenu.

Report Generation Flow

Step 1: Report Parameters

The following parameters are available:

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

  • Company: Filters data by the selected Own Company.

  • Selection Type: Defines how data is loaded and structured in the report.

    1. By Invoices

      • Invoices are loaded first. The reporting period and company filter are applied to invoices only.

      • Related payments are then loaded regardless of payment date. As a result, payments may fall outside the selected period.

      • Company filtering applies to invoice fields (Issued By or Payer). Payments may reference other companies.

    2. By Payments

      • Payments are loaded first, filtered by period and company.

      • Related invoices linked to the filtered payments are then loaded.

  • ID Columns: Controls the visibility of identifier columns in the report.

    • Show ID Invoice.

    • Show ID Payment.

Step 2: Report Preview

After parameters are confirmed, the system generates a preview in spreadsheet format.

The report is displayed as a table with color-coded columns:

Column order depends on the Selection Type:

  • If By Invoices is selected:
    Invoice columns → Accrual-to-Payment columns → Payment columns.

  • If By Payments is selected:
    Payment columns → Accrual-to-Payment columns → Invoice columns.

Preview Form and Export

The report is generated in a spreadsheet preview form used across the system.

Within this form:

  • The content can be edited before export.

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

Clicking opens a file explorer to choose the save location.
After saving, the report can be opened immediately.