List of supported bank export formats

Modified on Tue, 18 Jul, 2023 at 2:22 PM

Yuki offers support for the import of the export files of most Dutch banks. These files have to be downloaded by the user via the online banking system of the bank. The files that you have downloaded from the bank yourself only need to be uploaded in the 'Bank' folder or emailed as an attachment to the email address of your administration. In addition it is also possible to daily import mutations of the ABN AMRO, Rabobank, ING and Knab automatically via an accounting connection.


For a detailed description of the ABN AMRO, ING and Knab accounting link see category Links.

For a detailed description of the Rabobank accounting link see article Rabobank accounting link


In general the banks use two different types of file formats:

  • MT940 (NL)
  • Comma separated files (.CSV).


If you don't have an original file of the bank then you can also submit bank transactions by using a special Yuki bank import format. You can simply create this format in Excel yourself. 


An example of the Yuki bank import format in Excel has been added as an attachment to this article.


Yuki supported banks and their export formats

The export formats mentioned below also have to be used for foreign currency accounts that are opened with the relevant banks.


Dutch banks

Credit cards


TIPS!

  • The ABN AMRO Professional credit card is for private use only and therefore cannot be submitted as a CSV file.
  • It is possible to submit the credit card statements of the ING bank as a downloadable PDF file. The transactions must then be entered manually in a document of the 'Bank statement' document type.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article