ING bank export files

In Yuki it is possible to import the bank statements of the ING bank as an electronic bank file.

You have to submit your ING bank transactions in MT940 format (this format is preferable) or CSV format (Comma separated CSV file).

TIP!

The credit card statements of the ING bank can be submitted via a downloadable PDF file.

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

All your bank transactions can also be downloaded completely automatically and then uploaded into your online bank accounts using the ING accounting link.

>For a detailed description, see article Accounting link with ING

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.

A simultaneous linking of a bank account to Ponto as well as with the accounting link with ING will cause duplicate transactions in the administration!

The accounting link with ING must be discontinued in that case.

For a detailed description, see article Ponto PSD2 links. 

Download ING bank file

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

• >You log in to online banking with the ING bank (https://mijnzakelijk.ing.nl/login)
  
  
  
• Select the corporate payment account
• Click 'Af- en bijschrijvingen downloaden'
• Enter the start date and the end date of the period for which you want to download your transactions
  Maximally 18 months back in time if you at least were already using online banking during that period. If you are only using online banking for 3 months then three months is the maximum. 
• Select the 'MT940' or 'Kommagescheiden CSV' file format
• Click the 'Download' button
• You can now saved the file.
  In most browsers the file will be saved in the 'Downloads' folder.

We strongly advise you not to open the bank file before you upload it in your administration in Yuki or send it as an attachment per email to 'your domain name@yukiworks.nl'. 

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

CSV file of ING (individual fields)

The CSV file must contain the following columns:

• Datum: the transaction date
• Naam/Omschrijving: the contact name of the contra account
• Rekening: your own IBAN number
• Tegenrekening: the contra account number of the bank transfer    
• Code: mutation code 
• Af Bij: a withdrawal or a deposit
• Bedrag (EUR): the amount of the withdrawal or deposit
• MutatieSoort: the mutation type
• Mededelingen: the description of the transaction.   

Example CSV file of ING 

An example of an ING bank CSV file has been added as an attachment to this article.