Table of Contents
101: Getting Started with Analysis & Reports
Click “Analysis” in the navigation menu.
The Analysis module defaults to displaying all transactions over the last 30 days.The returned results are summarized in 3 important ways:
The Headline Metric (bolded) along with a smaller Trend Metric (green/red) 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 rom 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 Summary, Transactions, or Balances
Cadence: Defines how data is aggregated, either Daily, Weekly, Monthly, or Quarterly
Group by: Defines how the Analysis results are grouped. There are a max of 3 group levels.
Tag Delta: A sub-option that appears when the Group by is set to "Tag". This feature helps you quickly identify and resolve any tagging discrepancies that may exist in your report. Each transaction includes a number on the left, indicating how many tags overlap.
Image or attachment is not accessible.
Review and Resolve Overlaps: For each transaction, you can choose one of the following methods to remove the overlapping tags.
Option A — Manually Remove Tags: Open the metadata of the transaction to see it's tag list. Click a highlighted tag, then select "Remove". This update may take a couple of seconds to process.
Option B — Adjust Tag Criteria: Update the tag criteria to automatically prevent overlaps in the future. To do this, open the metadata of the transaction to see it's tag list. Click a highlighted tag, then select "Edit" to make changes to the tag parameters. This update may take a couple of minutes to process.
A caution icon ⚠️ appears next to the value in the total row if one or more tags are applied to the same transaction, causing the total for that period to be inflated.
Image or attachment is not accessible.
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, Summary:
A combination of the below, depending on which tab view (Transactions / Balances) is toggled
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)
Summary Column: Add or remove a column on the far right of the data table that shows a summary of data across multiple periods. You can choose to display totals, averages, maximum or minimum values, or the total change (Balance Reports only).
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.
201: Customization Options
Add a Goal to Your Report or Analysis
Open the configuration panel by clicking the icon in the top right of the Analysis or by clicking the "Edit Report" button in a Report.
Scroll down and click the "Trend Metrics" dropdown, then click "Custom"
Inside the Custom Trend Metric window, select "Total Goal", "Difference from", and input the goal value.
If you're creating a goal related to an expense or outflow report, make sure to add a negative sign before inputing the value. (ex: "-5000").
Last but not least, click "Create Metric" to add the goal to the top of your report.
Common Trend Metric and Goals Use Cases
Customer Receipts / Collections Tracking
Keeping your receipts goal front and center helps you quickly spot essential transactions from key customers and identify which ones are behind on payments before it affects your cash flow.
Project Expense Tracking Against a Budget
Keep your project financially healthy and stress-free by tracking your current expenses against the set budget at the top of your report. This way, you'll stay within budget throughout your project's lifecycle.
Daily Balance Targets
Maximize your financial efficiency by setting a target balance and utilizing excess liquidity as opportunities for your business.
Saving Reports & Exporting Data
Click “Save” to see your options:
Save as Report: Allows users to save Analysis paramaters as a new Report that will be visible to all entitled users in your instance.
Export as PDF: Download a PDF version of your report.
Export as CSV/XLSX: Download a CSV/XLSX version of your report.
Data Table Export Options
There are two ways to export the data from an analysis or report table:
Direct Download
Copy & Paste via Grid Mode
Option 1: Direct Download
Open your Analysis or Report.
Scroll down to the Data Table section.
Click the Download icon above the table.
Choose your formatting preferences (e.g., XLSX or CSV), and the file will download automatically to your browser.
Option 2: Copy & Paste via Grid Mode
Open your Analysis or Report.
Scroll down to the Data Table.
Click the Grid Mode icon to switch the table view.
Highlight specific cells, or click the top-left corner of the table to select everything.
Copy: Press Command+C (Mac) or Ctrl+C (Windows) to copy the data.
Paste the values into any spreadsheet using Command+V (Mac) or Ctrl+V (Windows).
Automated Report Email Delivery Preferences
Navigate to the report you want to share.
Click the three-dot menu in the top-right corner, then select "Report Delivery Preferences"
Create a New Share - In the "Scheduled Shares" dialog, you'll see a list of any existing scheduled email deliveries. Click "New Share" to set up a new one.
Enter Recipients - Add email addresses, separated by commas.
Note: Recipients do not need to be Trovata users to receive reports.
Set Delivery Preferences - Choose how often you want the report to be sent: Daily, Weekly, or Monthly, then input your preferred send time.
Confirm and Schedule - Click "Schedule Email" to finalize the setup.
301: Summary Reports (Transactions + Balances)
We’re excited to introduce Summary Reports, designed to give you the most comprehensive and complete view of your bank data. Use a Summary Report to see your bank data end-to-end:
Opening balance → Transaction Activity → Closing balance
Build from Analysis or directly in Reports → Create Report
Break down your transaction activity by Inflows/Outflows (default), Tag, or G/L Tag
Toggle built-in checks for FX Delta and Data Completeness
Summary Report Benefits
Comprehensive Data View
See your entire cash position: from opening to closing balances across one or more periods.
Flexible Transaction Categorization
Choose how your transaction activity is grouped:
Inflows/Outflows (default) – debits vs. credits
By Tag - cleanly review your tagged cashflows with built-in checks that highlight overlapping and uncategorized activity.
By G/L Tag - cleanly review your transactions tagged by a specific set of G/L Tags.
Data Integrity & Completeness
Each report includes built-in checks to ensure accuracy:
FX Impact – shows any gaps caused by daily FX conversion rate changes when multiple currencies are included and your report is in a cadence other than daily (can be toggled on/off).
Data Completeness – confirms that daily net activity matches the change from opening to closing balances (can be toggled on/off).
If reporting by Tags, we also offer checks that help you refine tagging rules and understand where data falls outside categories:
An ‘Other’ row includes transactions not tagged by the included tags.
A ‘Tag Overlap’ row captures transactions that are part of two or more tags that are included in the report.
Building a Summary Report
You can build a Summary Report in two ways:
Build on the fly in Analysis, then save it to the Reports module (just like other report types today).
Or, directly from the Reports module by clicking Create Report → Summary Report.
Steps to Create a Summary Report
Open a Report Builder
From Analysis, or
From Reports → Create Report → Summary Report
Select Accounts
Use the account filter to include only the accounts you need. Filtering reduces noise and makes performance more responsive.
Choose Transaction Categorization
Options:
Inflows/Outflows (default)
By Tag
By G/L Tag
(Optional) Format Your Report
Reorder transaction activity rows
Toggle data integrity rows (FX Delta, Data Completeness, Category Overlap, “Other”)
Other Configuration Options:
Cadence - You can build reports by day (recommended), week, month, or quarter.
⚠️ Note on FX: When reporting across longer cadences with multiple currencies, FX fluctuations may create small gaps in your totals. Use the FX Impact toggle to add these adjustments.
(Optional) Select your Row Breakdown
Decide how you would like the rows to breakdown in your report. Options include Currency, Account, Entity, Entity Region, Entity Division, and Account Type.
Save Your Report
Click Save in the top-right corner
Give your report a clear name so colleagues can easily find it
FAQ & Troubleshooting
1). Why doesn’t my report tie out?
Check if FX Delta is toggled on when reporting across multiple currencies.
Confirm Data Completeness is enabled to validate balances and transactions.
2). What if some transactions are missing categories?
Check the built-in Uncategorized row to see how much activity isn’t tagged.
Review or adjust your tagging rules.
3). Can I compare multiple account groups?
Yes. Use the account filter to include one or more accounts or groups in the same report. Choose how you'd like to compare each account group by making a Row Breakdown selection.
4). What does it mean if the Data Check row has a value?
The Data Check row helps verify the completeness and accuracy of your data in local currency. It does this by confirming that each account’s daily change in balance matches the net transaction activity for the same period.
Statuses:
✓ indicates everything ties out correctly, and no data is missing.
Any other value - indicates there may be missing data or a mismatch between the balance change and transaction activity in local currency.
5). What is the FX Impact row?
If your report includes accounts in multiple currencies and is viewed in a cadence greater than daily (such as weekly, monthly, or quarterly), the FX Impact row shows the difference caused by exchange rate fluctuations over that period.
For example, if you hold AUD 200 throughout the month of August but your report is displayed in USD, the USD value will vary as the AUD-to-USD exchange rate updates. The FX Impact row captures this difference so you can see how currency movements affected your reported totals.
In the extremely simple example above, if the FX Impact row is positive and there was no change in activity, it means the Australian Dollar strengthened against the U.S. Dollar. If it’s negative, the Australian Dollar weakened during that period.
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 |
Recommended Reports Guide
For a full list of Trovata's Recommended Reports to build to further support your Treasury, Finance, and Accounting teams, check out this guide.