Reporting Overview

Reports can be created to identify trends, test hypotheses, or answer specific cash questions. Below you will find examples of commonly used Reports in Trovata.

This transaction report is grouped by 8 Tags with a Weekly Cadence for 13 Periods in a Stacked Bar Chart format. The number of tags included, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: This report breaks down cash flow activity based on the categories relevant to your business. Users can better understand the directionality of their cash flow based on this historical data, and even leverage learnings to project future cash flows for any (or all) transaction categories.

This transaction report is grouped by 5 Tags with a Monthly Cadence for 12 Periods in a Stacked Bar Chart format. The number of tags included, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: This report gives users and understanding of the volume of their receipts coming from the various payment methods (ACH, EFT, Remote Deposit, and Wire).

This transactions report is filtered by 5 Tags, with a Monthly Cadence for 12 Periods in a Stacked Bar Chart format. The number of tags included, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: This report drills into customer collections by identifying the top/key customers for any given business. Users can speak with their AR/Credit teams to identify the top 1 to 10 key customers and report on the respective inflows over time.

This transactions report is filtered by 5 Tags, with a Weekly Cadence for 13 Periods in a Stacked Bar Chart format. The number of tags included, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: This report drills into vendor disbursements by identifying the top/key vendor for any given business. Users can speak with their AP team to identify the top 1 to 10 key vendors and report on the respective outflows over time.

This transaction report is grouped by Currency with a Daily Cadence for 14 Periods in a Line Chart format. The number of currencies represented, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: The goal of this report is to visually represent the currencies that comprise your cash flows. It also serves to display the scale of operations of the business in any given currency based on the total transaction flow.

Net

Gross

These transaction reports have no filters, are toggled to display the net & gross totals respectively, and have a Monthly Cadence for 12 Periods in a Bar Chart format.

Purpose: The goal of this report is to visually represent the net & gross totals of your inflows/outflows.

This transaction report is grouped by the Payroll Tag with a Weekly Cadence for 13 Periods in a Stacked Bar Chart format. The number of currencies represented, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: The goal of this report is to drill into Payroll data in relation to your overall cash flows.

This transactions report is grouped by various Bank Fee Tags, with a Monthly Cadence for 12 Periods in a Stacked Bar Chart format. The number of tags represented, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: The goal of this report is to visually represent and track monthly bank fees/charges related to each institution for which you have a banking relationship.

This balances report uses the Composite Balance Converted balance type and is grouped by Institution and Account with a Daily Cadence for 5 Periods in a Stacked Bar Chart format. The number of grouped institutions represented, cadence, number of periods, and chart format of the report is totally subjective. This report also leverages the "Average" Trend Metric to evaluate the average balance over the last 5 days.

Purpose: This report is designed to track prior day balances across all institutions and accounts on a rolling basis in one consolidated place.

This balances report uses the Composite Balance Converted balance type and is grouped by Region, Entity, and Institution with a Daily Cadence for 15 Periods in a Line Chart format. The number of grouped regions represented, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: This report can be leveraged to track account balances across a company's entity/region/division groupings. This balance reporting specifically comes in handy for businesses that have several entity/region/divisions to report on, as users can build specific reports that hone in on those objects.

This balances report uses the Composite Balance Converted balance type and is grouped by Currency with a Daily Cadence for 5 Periods in a Pie Chart format. The number of grouped currencies represented, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: The goal of this report is to visually represent your currency portfolio across all institutions/accounts connected to Trovata.

This balances report uses the Composite Balance Converted balance type and is grouped by Institution with a Daily Cadence for 30 Periods in a Line Chart format. The number of grouped institutions represented, cadence, number of periods, and chart format of the report is totally subjective.

Purpose: The goal of this report is to visually represent your cash balance trends over time within your bank mix.

This reconciliation report uses the Account field in the Items Reconciled menu and is filtered by USD Currency and JP Morgan Institution with a Prior Day View. The Tag Breakdown feature is also used to filter by the top 3 parent tags of the company (Receipts, Disbursements, and Book Transfers). The number of filters and tags used is totally subjective.

Purpose: The purpose of this report is multifaceted. Users can leverage this report to verify that net transaction activity is equal to the change in balance for any given account on any given (prior) business day. Additionally, users can leverage the report, and specifically the tag breakdown, to understand what transactions for a given day fall into which respective transaction categories (i.e. Receipts, Disbursements, Book Transfers, etc.). The "Other" line item is a catch all for any transactions that either do not yet have a tag OR do have a tag, but the assigned tag has not been included in the Tag Breakdown.