To make well-informed business decisions, it’s essential to know your company’s financial position at all times. The balances feature gives you a clear, real-time overview of your company’s financial position by consolidating data from all accounts and subsidiaries. It also lets you retrieve account balances as of any date.
Whether you’re analyzing current balances or historical trends, this feature ensures transparency, accuracy, and traceability in your financial operations. With flexible date selection and access to the balances history, you can monitor changes over time, detect anomalies, and support your strategic planning with reliable financial information.
Two views: “Balances” and “Balances history”
Tresio offers two complementary views:
- Balances shows exactly one value per account: the balance as of a report date you choose – a snapshot in time.
- Balances history, on the other hand, shows every individual balance record ever captured for an account – the complete history. This is useful for tracking when and how often a balance changed, or for reviewing past balances.
Both views display the data in the same column format:
- Source – the integration type used to import the balance data (e.g. Ebics, manual).
- Company – the name of the company the bank account belongs to.
- Bank – the name of the bank holding the account.
- Account name (internal) – an internal label you can use to give the account your own name or purpose.
- Account number – the official account number (IBAN).
- Balance – the balance reported as of the balance date.
- Currency – the currency in which the bank account is held.
- Balance Date – the date the bank reported the balance; reflects the official balance date from the bank’s response.
- Change Date – the last known date when the balance actually changed; shows account activity, not just data updates.
- Update Date – the most recent date we successfully retrieved balance data from the bank; may differ from the balance or change dates.
Depending on the selected view, additional columns such as Relevance and Found may be displayed. These show the status of an entry (e.g. active or deleted) and whether the corresponding account can still be matched in the system.
“Balances” in detail
The “Balances” page shows the balance of all accounts as of the selected report date.
- Report date – choose a date in the top right to display balances as of that date.
- Search – use the search field in the top right to quickly find specific entries, e.g. by bank, company, or account number.
- Sort – click a column header to sort the list ascending or descending by that column.
Uploading balances
Under “Upload”, you can import your account balances directly from an Excel file. Two modes are available:
- “Add new balances and update existing ones” – new entries are added, and existing balances for the same accounts are updated.
- “Add new balances and replace all existing balances for the uploaded accounts with the new ones from the file” – all previous balances of the affected accounts are replaced with the new values from the file.
Under “Upload”, you’ll also find a sample Excel file showing the required structure for the upload.
Exporting balances
Export your account balances directly from Tresio – as an Excel file, PDF, or CSV, copied to the clipboard, or printed directly.
“Balances history” in detail
The “Balances history” page provides a historical view of the balances of all companies and bank accounts the current user has access to.
By default, this view only shows current (active) entries – deleted entries are hidden. To also view deleted entries, click the view selector “Active accounts” in the top right and select the “Display all” view. This shows both active and deleted entries.
Use the checkboxes at the start of each row to select one or more entries, so you can act on them together using the “Delete” or “Restore” buttons in the toolbar. Alternatively, delete a single entry directly via the trash icon at the end of its row.
Deleted entries are not shown by default but remain stored in the system and can be restored at any time via “Restore”.
Note: Deleting an entry on the “Balances history” page also removes it from “Balances”. Restoring the entry brings it back in both views.