Browse and analyze transactions

Filter transaction detail, group and aggregate values, build pivot tables, and export the result.

Use the to move from financial-statement totals to the records behind them. You can filter the full transaction set, summarize it with grouped totals, pivot it for comparisons, and return to individual rows without leaving the grid.

Start with the right scope

Open the Transactions Browser directly to browse across the available data, or open it from a financial-statement value to carry that value’s account and reporting context into the grid.

Set the broad scope with the controls above the grid:

• choose the accounts or reporting layout;
• select one or more entities;
• set the period and period granularity;
• turn Group currency on when values should be converted to the group currency;
• choose which transaction categories and deleted transactions to include.

Use the filters in individual column headers to narrow the result further. For example, you can filter by date, local or group account, counterparty, description, or dimension. All three grid views use the same active scope and filters, so you can change the presentation without rebuilding the investigation.

Choose a grid view

View	What it shows	Use it to
All	Individual transaction rows and their available fields.	Inspect dates, descriptions, account details, counterparties, and source identifiers.
Grouped	A hierarchy of selected fields with transaction values summed at each level.	See which entities, accounts, dimensions, periods, or counterparties contribute to a total.
Pivot Table	Aggregated values arranged by row and column fields.	Compare a measure across two or more attributes, such as accounts by month or entities by counterparty.

The grid uses server-side pagination and aggregation. In All, the visible page may contain only part of the filtered result. Grouped and Pivot Table calculate their totals from the complete matching scope rather than only the rows currently visible.

Group and aggregate transactions

1. Choose Grouped.
2. Open Group by.
3. Select one or more grouping fields, such as entity, group account, local account, dimension, period, or counterparty.
4. Use the arrows to set the grouping order.
5. Expand a group to move from its summed value to the next level and, ultimately, the transactions behind it.

Grouping order changes the question the grid answers. Entity → Group Account first shows each entity and then its contributing accounts. Group Account → Entity first shows each account and then how its value is distributed across entities.

When grouping by period, choose monthly, quarterly, half-yearly, or yearly granularity to match the comparison you are making.

Build a pivot table

1. Choose Pivot Table.
2. Open the Columns panel on the right side of the grid.
3. Add fields to the row groups and column labels.
4. Keep the transaction value as the aggregated measure.
5. Expand row groups or adjust filters until the table answers the comparison you need.

For example, use group accounts as rows and monthly periods as columns to review movement over time. Use counterparties as rows and entities as columns to compare where group activity originates.

Work with dimension allocations

Leave Dimensioned Rows off when one row per accounting transaction is sufficient. Turn it on when you need the dimension allocations behind each transaction. One source transaction can then appear on multiple rows, so reconcile the transaction value rather than comparing raw row counts between the two modes.

Save, share, or export the result

• Use Saved Views to return to a useful combination of scope, filters, grid mode, grouping, and column settings.
• Use Share to copy a link to the current analysis.
• Use Export to download CSV or Excel, create a summary report, or copy all matching rows to the clipboard.

Export fetches all matching rows rather than only the visible page, up to 100,000 rows. If the result is larger, Control exports the first 100,000 rows and shows a warning. Apply additional filters when you need a complete export of a larger result.

Common analysis patterns

Question	Start with
Which accounts make up this statement value?	Group by group account, then local account.
Which entity explains a group-level movement?	Group by entity or pivot entities across periods.
What changed between periods?	Pivot accounts or counterparties by period.
Why did a cost center move?	Filter to the dimension item, then group by account or counterparty.
Which exact entries make up a total?	Expand the grouped result, then switch to All with the same filters.

Related guides

• Investigate an unexpected transaction value
• Keep transaction data current
• Build and review financial statements