Import bank statement
Importing bank statements into Holded is done when you add accounts manually, whether they are of the bank or card type.
In addition, debit cards are not synchronized in Holded, so you will need to import their statements in order to see all the movements made with them.
To import the bank statement, follow these steps:
Go to Treasury > Banks, from the sidebar.
Click on the bank or card account where you want to import the statement.
Click on the three-dot menu (⋮), in the upper right corner, and select “Import transactions”.
Download and complete the import template, making sure that the transactions are in order, from the most recent to the oldest.
Return to Treasury > Banks, and again select “Import movements from the three-dot menu (⋮).
Upload or drag the completed template, review the data and confirm the operation twice.
When finished, the statement will be updated. Manually imported transactions will be displayed with a cloud icon to differentiate them from those synchronized automatically.
Import template fields
Date: uses the format dd/mm/yyyy.
Concept: indicates the name or reason for the transaction.
Amount: uses positive numbers for income and negative numbers for expenses.
Balance: enter the balance in the currency of the account, calculated by adding and subtracting transactions.
Do you need personalized help?
If you have any doubts or errors in the import, our support team is ready to help you. Write to us via chat and we will guide you to ensure that your information is imported correctly and smoothly.
Download bank statement
To download an account or card statement, follow these steps:
Go to Treasury > Banks, from the sidebar.
Click on the bank or card account for which you want to download the statement.
Click on the three-dot menu (⋮), in the upper right corner, and select Download bank statement.
The file will download in .xlsx format, ready for you to use.
Download file fields
The statement includes detailed information to facilitate the management of your bank transactions:
Date: shows the day the movement occurred (corresponds to the “value date” in the table).
Description: explains the concept of the movement (it is the same that appears in the platform).
Amount: indicates the amount, either income or expense.
Balance: shows the accumulated balance after each movement.
Reconciled: indicates how much of the item's total amount, movement or transaction is reconciled.
Reconciliations: details what the movement has been reconciled against, saving you time by avoiding searching for it manually in the accounting.
Status: indicates whether the transaction is pending, partially reconciled, or already reconciled.
Notes: if you have added notes to a transaction, they will appear here.
☝🏼 You can add notes by clicking on the transaction, typing them, and saving them.
This file is a useful tool for keeping a clear and detailed control of your treasury, especially for reviewing items pending reconciliation and analyzing reconciliations already performed.