TRESIO serves as a central data warehouse for bank transactions across all banks and company-wide. All functions related to the management and analysis of these transactions are bundled in TRESIO under the Transactions menu.
Here, you can monitor imported transactions from connected accounts and also upload transactions from a file. The detailed view helps you identify patterns, track expenses, and make informed decisions to improve financial planning and forecasting. With a clear transaction history, you can better anticipate future trends, adapt flexibly to changes, and maintain solid financial control. A Google-like search also allows you to quickly find individual transactions.
How to view your bank transactions
The ‘Transactions’ tab lets you view your transactions that have been imported via a banking integration or uploaded manually. In order to import transactions you have to have a banking integration activated and ‘Import transactions’ option checked in.
The ‘Transactions’ tab shows:
- Company: The name of the company associated with the transaction. This identifies the business entity involved
- Bank Name: The name of the bank where the transaction is recorded or processed
- Account: The account label associated with the transaction (e.g. “UBS CHF”)
- Account number: The specific account number (IBAN) linked to the account.
- Transaction No: A unique reference or identifier assigned to each transaction for tracking and record-keeping purposes
- Amount: The monetary value of the transaction, indicating the total amount involved
- Currency: The currency (or currencies) in which the transaction was processed (e.g. CHF, EUR, USD).
- Date: The date on which the transaction occurred or was processed
- Details: A description or additional information about the transaction, often specifying the nature or purpose of the transaction
- User comment: Any additional notes or remarks added for clarification or further context regarding the transaction.
- Category: Here you can assign the transaction to a category. As long as no category has been assigned, the field shows the status “Unclassified” instead of staying empty. Categories are structured on two levels: the main categories “Inflows” and “Outflows” each contain several selectable subcategories.
- Relevance: Indicates whether the account is currently active or not. The status can also show “Deleted” if the associated bank account has been removed.
- Found: Transactions were matched based on the account number – if no clear match is found, they remain marked as “Not found” in the system.
Deleting and restoring: The trash icon lets you delete a transaction. For already deleted transactions, a restore icon (↺) appears instead, which lets you bring the transaction back.
Search and filter: Above the table there is a search field (“Search …”) for full-text search, as well as an additional filter icon for further narrowing down results. A dropdown, labelled “Active accounts” by default, lets you switch between saved views: “Active accounts” (default) and “Display all” (includes transactions from deleted accounts).
Editing Category and User comment: Clicking the pencil icon at the end of a row opens the “Edit record” window with the two fields User comment and Category. Alternatively, both fields can also be edited directly inline in the table, via the small pencil icons underneath the respective cells.
The remaining transaction data (Account, Account Number, Transaction No, Amount, Currency, Date, Details) is read-only and cannot be overwritten.
All column headers are sortable (ascending/descending).
You can export the transactions to Excel or PDF and use them for further analysis.
How to upload transactions
To upload bank transactions manually, for example for bank accounts that are not connected, or to add historical data, click “Upload”.
Here you can select how the transactions should be uploaded, by choosing one of the options in the Settings area, and then providing the file containing the transactions for the upload:
- Add new transactions and update existing ones
- Add new transactions and beforehand remove all existing transactions for the uploaded accounts, replacing them with the new ones from the file
In principle, Tresio works with CSV / Excel formats from all banks. It’s simply important that the first row defines the columns and does not contain, for example, a title or similar.
If you are unsure about the format, click “Download sample Excel” first to check whether your format contains all the necessary columns.
Next, verify the content and match the columns of your bank export to the fields required for the upload, in the matching screen:
Sheet: If your file contains multiple sheets, you can select the relevant one here via a dropdown (the actual sheet names from your file are displayed).
Account: You choose between two modes:
- “Each line contains a bank account number” – if your file contains multiple accounts across different rows
- “All records belong to the same bank account number” – if the entire file relates to just one account, which you select directly
Transaction No: You choose between two modes:
- “Each line contains a transaction number” – you map the corresponding column from your file
- “Tresio to create a unique transaction identifier based on the transaction information” – for bank exports without transaction numbers (e.g. Credit Suisse, Raiffeisen). Tresio automatically generates a unique hash code during upload, based on the data in the corresponding row.
Debt & Credit Amount: Required field for the transaction amount. There is also a separate field called “Credit Amount”. If “Credit Amount” is empty for a row, the value from “Debt & Credit Amount” is used unchanged. If “Credit Amount” is filled in, its value is used instead and recorded as a negative amount; the value from “Debt & Credit Amount” is not taken into account in that case.
Currency: You choose between two modes:
- “Each line contains a currency code” – if your file contains multiple currencies across different rows
- “All records are in the same currency” – if the entire file relates to just one currency
Date: The column in your file corresponding to the date.
Details: For an introductory reference, e.g. the column with the company name/booking text.
User comment: Optional column for additional remarks.
Clicking “Next” takes you to a preview of the data as it will be uploaded.
The preview screen displays your data and lets you change the upload mode if needed. The mode selection (Add & update / Add & remove existing transactions) appears here a second time – directly above the “Save” and “Cancel” buttons – and must be confirmed again before the final save. In addition, error messages are highlighted for transactions that will be ignored during the upload process – for example because the associated bank account does not exist in Tresio, the currency does not match the one on file for the bank account, or there is no access permission for the account in question (see the “Troubleshooting” section further below).
During the preview, you can exclude individual transactions from the upload. To do so, simply select the transactions you don’t want to upload, then click the “Remove” button.
Troubleshooting: Upload isn’t working
During the upload, a validation takes place that ensures the currency of the transactions and the account number match a bank account on file in the system. The following transactions are ignored in the process:
- Nonexistent bank accounts: Transactions associated with a bank account that does not yet exist in Tresio.
- Mismatched currency: Transactions where the currency differs from the one set for the bank account on file.
- Access restrictions: Transactions for a bank account the user does not have access permission for.
Important: Unrecognized accounts do not cause the entire upload to fail. Instead, the preview screen shows two separate notice boxes:
- A warning box listing the ignored, unmatched accounts (e.g. “Transactions were detected in unconnected accounts, these transactions will be ignored”)
- A separate confirmation box listing the accounts that were successfully matched (e.g. “Transactions were found for the following accounts”)
Only the rows for unmatched accounts are skipped; all other, correctly matched rows are still saved. If the entire file contains only unmatched accounts, the preview table remains empty (“No data available in table”).
In such cases, the system will display relevant error messages to inform the user about the ignored transactions.
Frequently asked questions (FAQ)
I have already linked my bank account to Tresio. Why can’t I see any historical data?
The amount of historical data imported depends on the bank and the type of integration. Typically, transactions from the past three months are imported by default, but for comparable data, Tresio provides an option to upload older historical data manually via Excel or CSV file.
I accidentally uploaded the wrong data. How can I delete transactions?
To minimize the risk of misuse, bank transactions in Tresio can be changed or deleted directly. However, you can perform a new import and select the option to delete all previous transactions.
I can see transactions in my online banking, what advantage does Tresio offer?
Online banking often limits historical data visibility to 12-24 months, requiring manual storage for older records. Tresio allows you to view transaction data indefinitely in a central, secure location for all banks and companies. Additionally, its advanced search and filtering features ensure you can quickly locate specific transaction details, similar to a Google search.