List of supported bank export formats

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. 

TIP!

It is also possible to link all bank accounts according to PSD2 and GDPR regulations to Yuki via Ponto in a secure and reliable way.

For a detailed description of the accounting link with Ponto see article Ponto PSD2 links. 

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

• ABN AMRO
  • MT940
• ASN bank 
  • SWIFT-MT940
    maximally 18 months back in time
• Bunq bank
  • MT940
• Fortis bank
  • MT940 (.sta)
  • MT940 Grote Beer (.sta)
• ING bank 
  • MT940
  • CSV (if MT940 is not available)
• Knab bank
  • MT940
• Rabobank
  • MT940 Structured (.swi)
    maximally 15 months back in time
  • CSV (if MT940 is not available)
    maximally 15 months back in time
• Regiobank
  • SWIFT-MT940
• SNS bank
  • SWIFT-MT940 
• Triodos bank
  • MT940 (unstructured)
• Van Lanschot 
  • CAMT.053
  • MT940 Structured
    
    

Credit cards

• ABN AMRO
  • CSV (Business Card)
• Rabobank
  • CSV
• ICS (International Card Services)
  • CSV
• American Express
  • CSV.

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.