Tresio TRENDS provides a visual representation of your company’s financial development over time. With TRENDS, you can not only monitor your liquidity planning, but also review historical data based on your bank transactions. In a future step, profitability and balance sheet KPIs will also be integrated to provide an even more comprehensive view of your financial management. The goal is to identify developments at an early stage and support informed decision-making.
Where can I find TRENDS in the Tresio application?
If TRENDS is not already displayed in the menu (at the top), navigate to “More Tools”.
Activate TRENDS in the menu (recommended) or navigate directly to the corresponding page from there.
Which functions are available in Tresio TRENDS?
This is what the TRENDS screen looks like. Below is an overview of the available functions. The functions are described in more detail further below.
(1) Views
Tresio TRENDS allows you to create multiple views. This enables you to track different information such as liquidity forecasts, historical balance developments, or custom KPIs in separate locations while maintaining a clear overview at all times.
Click “New” to create additional views.
(2) Selection
Period: Select the reporting period here (from… to…). Both predefined periods and fully customizable periods are available.
Interval: Choose whether the information should be displayed on a yearly, quarterly, monthly, weekly, or daily basis.
⚠️ Attention: Displaying weekly or daily data over longer periods may result in longer loading times.
Currency Filter: Select whether all currencies or only a specific currency should be displayed.
Liquidity Forecast: These settings define which company data, planning data, and invoices are used for the liquidity forecast. Payment delays, overdue invoices, and scenario adjustments can also be taken into account.
(3) Settings
Export: Export both charts and tables in various formats.
Settings: Define which information should be displayed. Additional details can be found below.
Share: The Share function allows dashboards and plans to be shared securely via a link with external users who do not have direct access. More information can be found here.
1/2 Format: Select the format in which numbers should be displayed (whole numbers / with decimals / in thousands).
(4) Positions
This overview displays all relevant cash flow and financial positions at a glance, such as balances, cash movements, loans, and revenues. Further below, you will find information on how these can be edited.
(5) Chart
The chart displays the data graphically according to the selected settings. By clicking the individual elements in the upper-right corner, you can show or hide them as needed.
The chart colors correspond to the respective data categories and help distinguish values quickly.
(6) Period View
Data is displayed according to the selected period settings and visualized accordingly in the chart.
(7) Tabular View
The tabular view displays all integrated data in table format.
By clicking an individual value, a detail popup opens showing the underlying composition of the figure, broken down by Transactions, Invoices, Subscriptions, Planning, HR, and Loans, each with its own filter. This gives you an immediate overview of which data sources make up a figure and how much weight planned data carries compared to actual data.
When hovering over a figure with your mouse, a tooltip additionally shows a quick summary of the composition, e.g. “Planning: 5, Subscriptions: 1, HR-cost: 3”.
What options are available for the individual functions?
Liquidity Forecast Settings:
(A) Companies whose data is used to generate the report
Only one selected company and exclude all subsidiaries
The report includes only the data of the currently selected company. Subsidiaries are not included.
Selected company and subsidiaries configured on “Companies” page
The report uses the companies and subsidiaries according to the configuration previously defined on the “Companies” page.
Selected company including all subsidiaries
The report automatically includes the selected company and all associated subsidiaries.
Include in the report all companies accessible within this workspace
All companies you have access to within the workspace are included together in the report.
(B) Dataset used to plot the past trend
Use historical account balances data
The historical trend is based on the actual historical balances of the connected bank accounts.
Use only planning data, disable the “Planned Balance” function
Historical information is displayed exclusively based on planning data. The Planned Balance view is disabled.
Enable KPIs based on journal data (coming soon)
In the future, KPIs based on accounting or journal entries can be displayed.
Automatically generate missing balance entries based on transactions. If balance entries are missing for individual days, they are automatically added based on the available transactions, so the balance history is displayed without gaps.
(C) Dataset used to plot future trend
Consolidate all planning and invoices datasets
The forecast combines planning data with outstanding invoices and other available data sources to provide the most realistic outlook possible.
Use planning data only
Future developments are based exclusively on manually entered or imported planning data.
Use data from open and overdue invoices only for forecasting
Open and overdue invoices are considered only in the future forecast and are not displayed in historical periods.
The first [xx] days are planned based on invoices, after that the planning data. For the initial period you define (e.g. the first 30 days), the forecast is based on open invoices; from the following day onward, the calculation automatically switches to the recorded planning data. This is useful if you want accurate, evidence-based figures in the short term, but want to rely on your planning in the medium term.
To calculate today’s “Opening balance”, use intraday “Bank accounts” entries: This setting includes intraday account movements to calculate today’s opening balance as accurately as possible. More details on intraday data and where else it is used can be found in the article Intraday bank reconciliation
(D) Additional settings for invoices and bills
Include overdue invoices and bills from the last xx days
Includes overdue invoices and settlements from the defined period in the forecast.
Distribute invoices and bills over xx days
Distributes invoice or settlement amounts evenly across the selected period to smooth cash flow peaks.
(E) Dataset adjustments for quick scenario correction
These adjustments can be made separately for Loans, Subscriptions, Planning, HR-cost, and Invoices. For each of these categories:
Due date shift (xx days). Moves the expected payment of the respective category by the specified number of days.
Effective value (xx percent). Adjusts the considered amount of the respective category by a percentage.
This allows you to shift, for example, only the loan payments, without affecting the invoices or HR planning.
(F) User description for current TRENDS page
Here you can enter your own description text for the selected settings. Afterwards, activate the function using “Show Settings” (G).
If no description is entered, you can still activate “Show Settings”, and the selected settings will be displayed in the planning view.
Bookmark Settings
(I) General Assign a name to the view.
(II) Tabs Order Adjust the order of the different views.
(III) Visibility Filter Here you can define which information should be displayed.
Module Icon Displays the module and expands it.
Filter Icon Displays the module but hides subordinate entries.
Hide Icon Completely hides the module.
These functions are particularly useful when structuring reports individually and displaying only selected modules or levels of detail.
Pin Icon Defines that a specific row (for example selected bank accounts) should always remain visible and does not need to be expanded first.
Chart Icon Defines that the information in a row should be displayed in the chart by default.
Trash Bin Icon Hides information from the table.
These functions are especially useful when you want to display only the balance development of specific accounts or selected cost categories within a report.
(IV) AutoSave Here you can define which settings should automatically be saved for the next time the view is opened.
(V) You can also duplicate, save, or delete the view here.
Visual Settings
The display of individual categories can be customized. For each category, you can define color, chart type, and display size independently. This allows information to be structured more clearly and visually differentiated in both charts and tables.
The selected settings are applied directly to the forecast view and allow for a personalized presentation of the various data areas.
These settings can be adjusted here:
Color: Select the color in which the element should be displayed in the chart.
Chart Type: Elements can be displayed as a line, area, or column.
Marker Type: Elements can optionally be marked with a circle, square, diamond, or triangle.
Display on Chart: Enabling or disabling this option determines whether the element is shown in the chart by default. This corresponds to the function described above.
Show absolute values: When enabled, negative values (e.g. costs) are displayed as upward columns as well. This can improve readability when comparing costs and revenues. When disabled, columns for negative values extend downward.
Apply row coloring: Colors the corresponding table row using the same color as the chart element. This can improve readability. When disabled, rows are displayed in a neutral black color.
Bold line Style: Displays the corresponding row in bold. Recommended for highlighting important KPIs.
Highlight Values: When enabled, negative values are displayed in red and positive values in green.
Use the checkboxes to determine whether the respective information should be displayed in the chart.
Clicking the Plus Icon displays the corresponding subcategories. These can then also be individually shown or hidden in the chart using the checkboxes.
Using the green button (see screenshot), you can enlarge or reduce the size of the chart. Click the green square and drag it until the chart reaches the desired size.
If, for example, you would like to quickly show or hide specific information during a presentation, you can do so directly by selecting the desired category.
Tabular View
In the tabular view, all selected data is displayed in table format.
By hovering your mouse over a value, you can see how the figure is composed.
By clicking on individual values, you can view a detailed breakdown of the underlying data. These details can also be filtered afterwards. This is particularly useful when questions arise during a meeting regarding specific figures within the liquidity forecast.
Available filters are Transactions, Invoices, Subscriptions, Planning, HR, and Loans, each showing the number of underlying entries. The detailed breakdown shows Type, Name, Amount, Due Date, and a Description for each record, for example Debitor, Issue Date for invoices, Planning type: payment schedule; Payment index for planning items, Periodicity, Date of first payment.