ABN AMRO Nederland export files

In Yuki it is possible to import the credit card statements and the bank statements of ABN AMRO Nederland as an electronic bank file. 

You have to submit your ABN AMRO bank transactions in MT940 format in Yuki. The credit card transactions of the Business Card have to be submitted in CSV format.

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

The ABN AMRO Professional credit card is for private use only and therefore cannot be submitted as a CSV file.

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

For a detailed description, see article Accounting link with ABN AMRO.

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 ABM AMRO will cause duplicate transactions in the administration!

The accounting link with ABN AMRO must be discontinued in that case.

For a detailed description, see article Ponto PSD2 links. 

Download ABN AMRO bank file

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

• You log in to online banking with the ABN AMRO (https://www.abnamro.nl/portalserver/mijn-abnamro-zakelijk/mijn-overzicht/overzicht/index.html)
  
  
  Enter the start date and the end date of the period for which you want to download the 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' format.

• Click the 'Download' button.

• You can now save 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 [email protected]'. 

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

MT940 file of ABN AMRO (individual fields)

Example MT940 file of ABN AMRO

ABNANL2A
940
ABNANL2A
:20:ABN AMRO BANK NV
:25:500950253
:28:17501/1
:60F:C090623EUR17369,99
:61:0906230624D7,5N192NONREF
:86:GIRO   428428 KPN BV             BETALINGSKENM.  000000018503995
5109227317                       BETREFT FACTUUR D.D. 20-06-2009
INCL. 1,20 BTW
:61:0906230624D203,N369NONREF
:86:BEA               23.06.09/22.22 VILLA DORIA SCHOTEN,PAS590
:62F:C090624EUR17159,49
-
ABNANL2A
940
ABNANL2A
:20:ABN AMRO BANK NV
:25:500950253
:28:17601/1
:60F:C090624EUR17159,49
:61:0906240625D1027,91N422NONREF
:86:64.45.12.113 G.B. ROTTERDAM     AANSLAGBILJETNUMMER 30076145
BETALINGSKENMERK 0000 0000       3007 6145 MOZARTLN 136 WOZ2009
:62F:C090625EUR16131,58
-
ABNANL2A
940
ABNANL2A
:20:ABN AMRO BANK NV
:25:500950253
:28:17701/1
:60F:C090625EUR16131,58
:61:0906250626D19,45N192NONREF
:86:34.01.56.740                    CANAL DIGITAAL B.V.
BETALINGSKENM.  0000000120357271 FACTURATIE MAAND JULI 2009
77064387 ENTERTAINMENT-PAKKET    ZIE WWW.CANALDIGITAAL.NL/FACTUUR
:62F:C090626EUR16112,13
-
ABNANL2A
940
ABNANL2A
:20:ABN AMRO BANK NV
:25:485082713
:28:17501/1
:60F:C090623EUR295922,68
:61:0906260624C25111,08N838NONREF
:86:VERKOOP BECAM HOLDING PER        23/06 ST 1.439 @ 17.52246
:62F:C090624EUR321033,76
-