Transaction Analysis

Transaction Analysis video

About Transaction Analysis

Transaction Analysis in ANZ Transactive - Global aggregates transaction data from your accounts to display cashflow patterns and trends, providing you with a comprehensive view and assist with payment and cash flow decisions.

You can perform the following functions in Transaction Analysis:

• View cash inflow, outflow and net cash flow by:
  • Month
  • Comparison by Period
  • Closing Balance by Month
  • Day of month

• Customise your view by selecting:
  • Date range (for up to 24 months)
  • Australian domiciled account(s)

• Compare transactional data on a month-on-month and year-on-year basis to identify trends
• Export data into CSV format for advanced analysis
• Analyse cash flow data through a chart or tabular view

Transaction Analysis data is refreshed from the previous business day.

Transaction Analysis Dashboard

Control Bar

The control bar allows you to manage your dashboard content based on your filtered selections, such as account and date range. Account will default with all accounts and date will default with last 12 months.
Account - Choose from:

• All accounts
• Select the require account(s)

Date Range - Choose from:

• Last 6 Months
• Last 12 Months
• Last 24 Months
• Custom date range - select a specific date range up to 24 months prior to today’s date.

Reset Filters - click this to return to the default view which will display the Last 12 Months of transaction information for All Accounts.

Download dashboard widget content

Once you have updated your dashboard and selected your preferred account(s) and date range, you can download the content of your individual widgets to a CSV file.
Click the export icon from the widget to save the CSV file to your preferred location.

Sample downloaded file

Transaction Analysis Widgets

There are four widgets available and are presented on your dashboard. These widgets provide cashflow data for selected accounts within the date range.

• Cash Flow by Month
• Cash Flow Comparison by Period
• Closing Balance by Month
• Cash Flow by Day of Month

Customise your widgets

Your widgets can be customised to suit your preferences. Use the icons from the top right of the widget to customise your view.

• Chart view
• Tabular view
• Download - click to download to CSV file
• Information - click to show detailed information regarding the widget

Widget display options:

Chart View	Tabular View

• Hover over the graphs to view the total inflow, outflow and net cash flow per month.
• Select/Unselect the legend to alter the chart view.

Transaction Analysis widget types

Cash Flow by Month

Displays cash inflow, outflow, and net cash flow aggregated monthly for the selected accounts across a selected date range.

• Cash Inflow: Displayed in green, is the total value of credit transactions each month.
• Cash Outflow: Displayed in orange, is the total value of debit transactions each month.
• Net Cash Flow: Displayed as the black through-line, is the difference between monthly cash inflow and outflow.

Cash flow by Comparison Period

Displays cash inflow, outflow, and net cash flow aggregated monthly for the selected accounts across a selected date range with benchmarked year-on-year comparison.

• Inflow: The total value of credit transactions each month.
• Outflow: The total value of debit transactions each month.
• Net Flow: The difference between monthly cash inflow and outflow.

 Year on Year – select between Cash inflow, Cash outflow or Net Flow. The display will adjust for a year-on-year comparison.
Information is presented in two charts:

• Line graph - Displays current period flow (shown as solid line), compared with the previous period (shown as dotted line)
• Bar graph - Displays flow increase and decrease as a percentage. This Year-over-year (YoY) change calculates the difference between values for selected period to previous period (12 months prior to selected period) values. This difference is divided by the previous period value to produce the YoY percentage.

Closing Balance by Month

Displays end of month closing ledger balance for the selected accounts across a selected date range.

Cash Flow by Day of Month

Cash inflow, outflow, and net cash flow calculated daily and aggregated over 5-day intervals for selected accounts and selected date range.

• Cash inflow: The total value of credit transactions each day.
• Cash outflow: The total value of debit transactions each day.
• Net cash flow: The difference between daily cash inflow and outflow.