The Transactions screen allows you to monitor the imported transactions as well as upload transactions from a file. This detailed view helps you identify patterns, track spending, and make informed decisions to improve financial planning and forecasting. With a clear history of your transactions, you can better predict future trends, adapt to changes, and maintain strong financial control.
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 specific account number or account identifier tied to the transaction
- 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 type of currency used for the transaction (e.g., USD, EUR, GBP)
- 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
- Comments: Any additional notes or remarks added for clarification or further context regarding the transaction.
Please note that you won’t be able to edit transactions, as they will be displayed in Read-Only mode. However, you can still filter, print or export them to other applications for further analysis if needed.
How to upload transactions
To upload transactions, click on the ‘Upload’ option, which will take you to the ‘Upload Transactions’ screen.
On this screen, you can select your preferred upload ‘Mode’ by choosing one of the available options in Settings. Afterward, you can provide the file containing the transactions for upload. The upload mode allows you to either add new transactions and update existing ones, or remove all existing transactions for the selected accounts and replace them with the new ones from the file.
If you are not sure about the file content, you can download a sample Excel file pre-populated with sample data, which can be removed.
The next step is to verify and confirm the column mapping.
The mapping screen enables you to map your file’s columns to the required fields for upload. In the ‘Account’ field, you can specify whether your file contains bank account details or if all records should be assigned to a single bank account. You can select the desired account from a dropdown list of all available accounts across user-assigned companies.
A similar process applies to the ‘Currency’ field, where you can designate how currency information is mapped.
After completing the mapping, proceed to the next screen for a final preview of your data before upload.
The Preview Screen displays your data and allows you to change the upload mode if needed. Additionally, it highlights any error messages related to transactions that will be ignored during the upload process.
During the preview process, you can choose not to upload specific transactions. Simply select the transactions you want to exclude by checking them, then click the ‘Remove‘ button to eliminate them from the upload.
Transactions that wont be uploaded
During the upload process, the system validates each transaction to ensure the bank account number and currency match an existing bank account record in the system. The following transactions will be ignored and not uploaded:
- Nonexistent bank accounts: Transactions associated with a bank account that does not exist in the system.
- Mismatched currency: Transactions where the currency differs from the specified bank account’s currency.
- Access restrictions: Transactions for an existing bank account to which the user does not have access.
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. For a complete data history, Tresio provides an option to upload older transactions manually via Excel or CSV files.
I accidentally uploaded the wrong data. How can I delete transactions?
To minimize the risk of misuse, bank transactions in Tresio cannot 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 advantages does Tresio offer?
Online banking often limits historical data visibility to 12–24 months, requiring manual storage for older records. Tresio allows you to store 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.