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
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.
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
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.
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.