Account Transactions

The account transactions report displays transactions recorded for selected accounts and business units.

Shem Bogusz avatar
Written by Shem Bogusz
Updated over a week ago

Use the Account Transactions report to analyse transaction detail for individual accounts or business units with various grouping options available to provide further analysis and reconciliation of numbers based on the selected Account Tree and Business Units Tree.

See the following additional help articles for generic help with the Calxa Report Builder.

Current Support for Transaction Reporting

To use the Account Transactions, report your organisation must be in a transaction syncing mode. Some integrations do not yet support transaction mode.

  • Xero: transaction mode fully supported.

  • MYOB: early access now available on request.

  • QuickBooks: coming soon.

  • Manual Organisations: transaction cannot be imported for manual organisation and therefore transaction reports are not supported for manual organisations.

Report Criteria

See the Set Report Criteria help article where you can learn more about using the report criteria.

Group by Options

Grouping is a key part of the Account Transactions report, so we'll therefore explain the group by options in more detail.

Group by Account or Business Unit.

Group by Account

Groups reported transactions by account, where each group may be more than one account as defined by the Account selection.

Account selection

The Account selection not only acts as a filter for the reported transactions but also creates the grouping categories. In the example below selecting the header or the 2 detail accounts will result in the same filter but the group by will be either one category for the header selection or 2 categories for the detail account selection.

Selecting a header account or the detail accounts under the header.

Tips 💡use an Account Tree to create custom headers that can be used for additional grouping options.

Example grouped by Grants header with multiple Grants accounts in the group

Example grouped by Grants header with multiple Grants accounts in the group

Group by Business Unit

Groups reported transactions by business unit, where each group is defined by the Business Units selection.

Business Units

The selected business units not only act as a filter for the reported transactions, but also determine the grouping categories. When Organisation is selected there is no filter and grouping by business unit creates a single group for the whole organisation.

Business Unit selection choosing default All Active and then a custom Business Unit Tree

Tips 💡use a Business Unit Tree to provide advanced filtering and grouping options.

Business Unit Combinations: 💬 if you've defined Business Unit Combinations the report only returns transactions where both Business Unit A and Business Unit B from the specific combination are assigned to the transaction.

Did this answer your question?