In Q4 '23, we shipped several enhancements to our Analysis and Reports module simplifying the chart visualizations, integrating TQL search to filter various types of metadata more efficiently, and giving our users the ability to hide/show metrics and report components used to analyze their results.
Getting Started - View Analysis
Click “Analysis” in the navigation menu.
When clicking into your Analysis page for the first time, you'll notice that this module defaults to display all transactions over the last 30 days.
The returned results are summarized in 3 important ways:
The Headline Metric along with a smaller Trend Metric provide an immediate summary of the returned results throughout the given date range. Both of these items can be toggled off or on in the configuration panel.
The Chart displays a dynamic time series of the data that a user can interact with in order to find additional transactions or balance details. The configuration panel on the right side is used to manage display options like Cadence, Group by, and Chart Type.
The Data Table is the easiest way to analyze and summarize the same values that are represented in the chart above. The grid icon in the top right corner of the table, provides a simple way for users to copy and paste values out of Trovata.
Filter your Data (via TQL search)
The top section of the Analysis page is designed to filter data in and out of your results.
You can filter data into Analysis in two ways:
1) Search Bar - enter your search parameters to refine your results below. Alternatively, click the query builder icon on the right side of the search bar to assist with selecting your properties and values individually.
You can view a comprehensive list of all TQL search properties here.
2) Date Picker - click the date range and add a start date & end date or choose a recommended date range from the list on the left side of this dropdown.
Configure your Analysis
Click the icon in the top right corner of the Analysis page to expand the configuration panel.
Below, are the definitions of the available configuration options:
Analysis Type - defines the data type: either Transactions or Balances
Cadence - defines how data is aggregated into period: either Daily, Weekly, Monthly, Quarterly
Group by - defines how the Analysis results are grouped: Max 3 group by levels.
True Rounding - allows users to round by the nearest whole number, thousands, millions, and billions.
Currency - allows users to select a preferred currency to convert to. Defaults to user’s preferred currency.
Headline Value (display / hide toggle)
Options, Transactions:
Net Cashflow: sum of all transactions returned in the Analysis results.
Credit / Debit: individually sums all credits and debits respectively.
Options, Balances:
Current Balance: Most up to date balance of current period.
Previous Period Balance: Balance of period before current period.
Chart/Graph (display / hide toggle)
Options:
Bar Chart
*Net Cash - (Bar Chart only) if this toggle is selected, the bar chart will show a net cashflow instead of dividing by credits and debits.
Stacked Bar Chart
Line Chart
Scatter Plot
Pie Chart (Balances only)
Table (display / hide toggle)
Trend Metrics (display / hide toggle)
Primary Metric Options:
Total Change
Transactions
calculates the difference between the sum of all transactions with and without the most recent period.
Balances
calculates the difference between the first period and the last period.
Period Change (Balances Only) - calculates the difference between the current period and the second most current period.
Average - average across all periods
Max - largest period value
Min - smallest period value
Period Change (Balances Only)
Custom - Select this option to set a static goal for your report and visualize the difference from the goal.
Save Options
Click “Save” to see your options:
Save as Report - allows you to save your Analysis paramaters as a new report that will be visible to all entitled users in your instance.
Export as PDF - lets you download a pdf version of your report that.
Available TQL search properties
Account Properties | Description |
Account | Select one or more accounts. |
Bank | Select one or more banks. |
Currency | Select one or more Currencies. |
Account Type | Select one or more account type. Options include: Operating, Debt, Investment. |
Entity (Legacy) | Select one or more Account Groups. |
Region (Legacy) | Select one or more Account Groups. |
Division (Legacy) | Select one or more Account Groups. |
Manual Account | Used to filter by Manual Accounts. Only accepts "true" or "false" values |
Account Closed | Used to filter by Open and Closed Accounts. Only accepts "true" or "false" values |
*Only available when Analysis or Report Type = Transactions
*Transaction Metadata Properties | Description |
Credit / Debit | Filters by transaction directionality. |
Amount | Value of transaction. |
Tag | Select one or more tags. |
Text Search | Used to execute a broad text search across transaction metadata fields |
Description | Used to search values in the main Description section in a transaction |
Description Detail | Used to search values under the Description Detail section in transaction metadata |
BAI Code | Used to search values in the BAI Code field |
BAI Description | Used to search values in the BAI Description field |
Bank Reference Number | Used to search values in the Bank Ref field |
Check Number | Used to search values in the Check Number field |
Memo | Used to search values in the Memo field |
G/L Tag | Select one or more G/L Tag |
Credit G/L Code | Select one or more G/L Code |
Debit G/L Code | Select one or more G/L Code |
Is Intraday | Used to filter by intrady transactions. Only accepts "true" or "false" values |
Is Batch Transaction | Used to filter by batch transactions. Only accepts "true" or "false" values |
Entity Properties | Description |
Parent Entity | Select one or more Parent Entities. Each selected parent entity will include accounts from the parent entity and it's children. |
Entity | Select one or more Entity Aliases |
Entity Region | Select one or more Entity Regions |
Entity Division | Select one or more Entity Divisions |
Entity Code | Select one or more Entity Codes |
Entity ERP | Select one or more ERP providers |
Entity ERP Reference | Select one or more ERP entity references |
Entity Functional Currency | Select one or more entity functional currencies |
Entity Name | Select one or more legal entity names |
Entity (Custom Fields) | Select one or more custom Entity fields |