{"id":6005,"date":"2025-11-26T10:06:00","date_gmt":"2025-11-26T08:06:00","guid":{"rendered":"http:\/\/support.simplbooks.ee\/en\/?post_type=ht_kb&p=6005"},"modified":"2025-12-04T15:24:55","modified_gmt":"2025-12-04T13:24:55","slug":"importing-bank-transactions","status":"publish","type":"ht_kb","link":"https:\/\/support.simplbooks.ee\/en\/kasutusjuhendid\/importing-bank-transactions\/","title":{"rendered":"Importing bank transactions"},"content":{"rendered":"

Bank transactions can be imported into SimplBooks in three ways:<\/strong><\/p>\n

\n
<\/span>1. By using a bank integration<\/strong><\/div>
\n

SimplBooks includes the option to create an integration<\/a> with four Estonian banks: Swedbank, SEB Pank, LHV Pank and Coop Pank.
\nIf the bank integration is activated, the system will automatically import the previous day\u2019s bank transactions into the software during the night. If you have enabled automatic transaction processing in the environment settings<\/a><\/span><\/span>point 9 of the guide<\/span><\/span><\/span><\/span>, the system will immediately save all transactions for which correct matches are found and will delete any duplicates. Duplicates may occur in situations where you imported transactions from a file on the previous day. In such cases, the automatic bank import will detect the transaction as a duplicate and will not allow it to be saved again.
\nIf necessary, it is also possible to import transactions from earlier periods through the integration, but transactions from the current day cannot be imported.
\n<\/div><\/div>\n

<\/span>2. By importing a machine-readable XML file<\/strong><\/div>
\n

It should be possible to download a bank statement in XML<\/strong> format from all Estonian banks, which can then be imported into SimplBooks. Export the file from the bank for the appropriate period. Please ensure that the file type is XML<\/strong> or ISO XML<\/strong> (the exact wording may vary depending on the bank).
\n<\/div><\/div>\n

<\/span>3. By importing a CSV file<\/strong><\/div>
\n

When saving a bank statement in CSV<\/strong> format, you need to map the data fields during import to ensure the information is transferred correctly into SimplBooks. To simplify the process, you can use an import template<\/a>. In the default settings, import templates<\/a> are available for SEB, Swedbank, LHV and Wise.<\/div><\/div>\n

<\/div>\nA more detailed overview is provided below
\n<\/strong>
<\/span>The bank transactions have been imported into the system. How to find them?<\/strong><\/div>
\n

If the transactions have been imported via the integration or from a file, but no suitable match is found automatically, they will remain pending. This means that the transactions do exist in the system, but they have not yet been saved and are not reflected in the accounting data. Regardless of which navigation path you use to access the transactions view, you will always see the same pending transactions.<\/p>\n\u25cf<\/span> On the company overview<\/strong> page, there is a panel titled “Importable bank transactions”<\/strong> which displays the number of unprocessed transactions. By clicking “Continue here”, you will be taken to the transaction processing view.<\/p>\n

\"\"<\/a><\/p>\n\u25cf<\/span> If you open the Receipts<\/strong> or Payments<\/strong> view from the Operations<\/strong> menu, a notification about pending bank transactions will appear above the list on a green background. The same area also includes a link that will take you to the transaction processing view.<\/p>\n

\"\"<\/a><\/p>\n<\/div><\/div>\n

<\/span>Importing bank transactions<\/strong><\/div>
\n

You can start importing bank transactions from the company overview page by clicking the “Bank transactions import”<\/strong> link in the “Importable bank transactions” panel.
\nAlternatively, you can open the Receipts<\/strong> or Payments<\/strong> view from the Operation <\/b>menu and click “Import”.\"\"<\/a><\/p>\n\u25cf<\/span> If the bank integration is activated, the import sources will include both file import and all banks that have been connected via the integration.<\/p>\n

\"\"<\/a>When importing from a file, there is no period restriction (the period must be set in the bank). However, when importing directly from the bank, transactions from the current day cannot be imported.
\nIf you want to import transactions from before the bank integration was activated, note that banks have different limitations on how far back they allow transactions to be imported via the integration.<\/p>\n\u25cf<\/span> If the bank integration is not activated, the file upload<\/strong> view will open immediately. When uploading a file in XML<\/strong> format, no additional selections are required – simply click the “Import”<\/strong>\u00a0button.<\/p>\n

\"\"<\/a><\/p>\n\u25cf<\/span> When uploading a file in CSV<\/strong> format, you must also select the import template<\/strong> (1), if one has been added and the bank account<\/strong> (2). Then click the “Import<\/strong>” button.
\nIf no import template has been added, you will be prompted to map the fields in the next view.<\/p>\n

\"\"<\/a><\/p>\n<\/div><\/div>\n

<\/span>Bank transaction statuses<\/strong><\/div>
\n

What do the statuses on bank transaction rows mean?<\/p>\n