ISX Transactions — Report documentation

Purpose

The ISX Transactions report shows every ISX transaction in one place: value date, source account, currency, reference, details, and credit or debit amounts with running balance. A separate Balance Module shows current ISX bank balances by source account. Finance and operations use it to reconcile ISX activity, trace a transaction by reference or account, and see how balances stand for ISX accounts over a chosen period.

What data this report uses

This report uses two data sources:

ISX transaction data (isx_transactions_raw): one row per ISX transaction, with value date, source account, currency, transaction reference, details, credit and debit amounts, and balance. For full field definitions and how the data is structured, see the ISX Transactions Raw — User Guide.
Overall Balances (v_overall_balance): one row per balance record by bank, source, and related attributes. The Balance Module uses this data restricted to ISX bank. For full field definitions and balance concepts, see the Overall Balances — User Guide.

Report-level filters

These filters apply to the whole report and narrow which ISX transactions appear in the main table.

Filter	What it does	How to use it	When it's useful
Transaction Reference	Finds transactions that match a given reference.	Enter a value in the text input (exact or partial, depending on Looker configuration).	Tracing a single transaction or a small set by reference.
Currency	Limits results to transactions in a specific currency.	Pick one or more currencies from the dropdown.	Analysing or reconciling by currency (e.g. EUR only).
SourceAccount	Limits results to transactions for a specific source account.	Pick one or more accounts from the dropdown.	Focusing on one account or comparing a few ISX accounts.
Date range	Restricts the table to transactions whose value date falls within the selected period.	Choose a start and end date (e.g. Mar 8, 2026 – Mar 14, 2026).	Reviewing activity for a specific week or month; matching to statements.

Resource-level filters

The Balance Module (the table that shows ISX bank balances) uses a filter that applies only to that visual:

Filter	Resource	What it does	How to use it
Balance Bank – ISX	Balance Module	Restricts the balance table to rows where the bank is ISX.	When the report is built, this filter is applied so the Balance Module shows only ISX bank balances. You do not need to change it unless you are editing the report to show a different bank.

Main table — ISX transactions

The report is built around one table that lists ISX transactions. Each row is one transaction. The table can be long (many thousands of rows), so the report shows a page at a time; use the pagination controls (e.g. 1–1000 of 15043) to move through pages.

Columns appear in the same order as on the report. The following table describes what each column shows in plain language.

Column	Meaning
ValueDate	The value date of the transaction (the date used for settlement or booking). Use it to see when each transaction is effective.
SourceAccount	The source account identifier for the transaction (e.g. the ISX account from which or to which the movement applies).
Currency	The currency of the transaction (e.g. EUR).
TransactionRef	The transaction reference. Use it to trace or match a specific transaction.
Details	Any extra narrative or description for the transaction.
CreditAmount	The amount credited (incoming) for this transaction.
DebitAmount	The amount debited (outgoing) for this transaction.
Balance	The balance associated with the transaction (e.g. running or period-end balance in that source account and currency).

Balance Module

A separate section titled Balance Module shows current ISX bank balances. It is a table backed by Overall Balances, restricted to bank ISX, so every row is an ISX balance record.

Column	Meaning
Bank	The bank name (ISX in this report).
source	The source account identifier (e.g. CY03904000010004600925601000). Use it to match balances to the main table’s SourceAccount.
Balance	The balance amount for that source, typically in EUR.

Use this block to see how ISX balances stand by source account alongside the transaction list.