Triodos bank export files

Triodos bank allows you to export or download bank statements (transactions) for a selected period via online banking and save them as an export file. This electronic file can then be uploaded to Yuki, so that the transactions are automatically processed in the administration.

Check date of most recently imported transaction

Before exporting transactions, it’s important to check the date up to which bank transactions have already been processed in Yuki. You can find this date in the last column of the overview of all bank accounts in Yuki.

If the bank account in question does not yet exist in Yuki, it will be created automatically when you upload the file. After that, you only need to specify which ledger the bank account belongs to.

Supported file formats

To import Triodos bank transactions into Yuki, you must submit the export file in one of the following formats:

• MT940 (unstructured)
• CAMT.053.

Download Triodos bank file

You have to go through the following steps in order to download a bank file of your corporate account with the Triodos bank:

• You log in to online banking with the Triodos bank (https://bankieren.triodos.nl/ib-seam/login.seam?locale=nl_NL)
  
  
  

• Click 'Overzichten' and then click 'Downloaden'.
  
  
  

• Select 'Zoekopdracht' on the basis of which you want to download your transactions.

• Select the corporate bank account.

• Select the start date and the end date of the period for which you want to download the transactions.
• Select the 'MT940 (unstructured)' or 'CAMT,053' download format.
• Click the 'Downloaden' button.
• Click the 'Herladen' button.
  You will now find your download in the overview of requested downloads of the past two weeks.
• Click the download icon in order to retrieve the downloaded file.
• You can now save the file.
  In most browsers the file will be saved in the 'Downloads' folder.

Upload Triodos bank file to Yuki

We recommend that you do not open or edit the bank file. This ensures that the file structure remains intact and allows Yuki to process the file correctly.

You can then upload the downloaded bank file to Yuki via the PO Box or send it as an attachment by email to <yourdomainname>@yukiworks.nl.

The electronic bank file will be automatically processed in your administration.

For a detailed description of uploading files in Yuki, see article Upload files from PO Box.