Client Balance Report

The Client Balance Report provides a multi-level table showing financial activity and outstanding balances, grouped by company, client, and transaction currency. The report is accessed from the More Actions submenu as .

This report is based on two primary data types:

  • Invoices;

  • Payments.

Opening and Configuring the Report

Upon opening, the report window appears with no data loaded. At the top, query parameters can be adjusted:

  • Period Type: Predefined or custom time range (defaults to the current calendar year).

  • Include Paid Invoices: Show fully paid invoices (not affecting balances).

  • Include Unpaid Invoices: Show only unpaid invoices.

  • Payments Only for Invoices Within Period: Show payments only if they belong to invoices within the selected period (excludes unlinked payments).

  • Client Mode: Uses the Client field from invoices instead of Payer when calculating and grouping balances. When disabled, outgoing invoices are grouped by Payer; when enabled, they are grouped by Client.

After setting the filters, use the button to run the report.

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

Parameter values are saved to MRU and restored automatically the next time the form is opened.

Data Views

Once loaded, data is displayed in three tabs:

  1. Company View — Grouped by internal companies;

  2. Client View — Grouped by clients;

  3. Client Operations — Grouped by clients without company segmentation.

Although the views are displayed as tables, each one uses a multi-level view with expandable rows. Sub-levels can be expanded by clicking the “” icon next to each record.

This view displays balances grouped by company first, then client.

Data hierarchy:

  • Company;

  • Client (separately listed under each company);

  • Currency;

  • Invoices, unallocated payments (if any), and full operation history;

    • For master invoices, an additional level shows child invoices with summarized data.

  • Payments by invoice.

Child Invoice Behavior

Child invoices are displayed for reference only. They are not included in summary statistics, history calculations, or reconciliation reports.

Payments are not shown under child invoices, as they are automatically distributed from the master invoice through special reconciliations.

The History subtab shows all transactions in chronological order.
Example: invoice issued → debt recorded → payment received → balance updated.

This subtab helps understand how financial obligations change over time.
All totals are shown as running balances, allowing insight into the progression of debts, payments, and balance over the selected period.

This view groups data by client, followed by associated companies.

Data hierarchy:

  • Client;

  • Company;

  • Currency;

  • Invoices, unallocated payments (if any), and operation history;

    • For master invoices, an additional level shows child invoices with summarized data.

  • Payments by invoice.

This view is useful for analyzing the overall financial position of a client across all companies.

The action is available only from this view.

This view displays financial data by client, without splitting by company.

Data hierarchy:

  • Client;

  • Currency;

  • Invoices, unallocated payments (if any), and full operation history;

  • Payments by invoice.

This layout simplifies review by showing a unified stream of transactions per client.

Export Options

Two export options are available:

  1. Export to Excel

    • Generates a WYSIWYG-style Excel file.

    • Maintains the report’s multi-level structure.

    • Columns may require manual resizing.

  2. Reconciliation Report

    • Available only in the Client View tab.

    • Exports a formatted Excel report.

    • Includes only clients whose rows have been expanded (via “” icon).