ABN AMRO Nederland export files

Modified on Tue, 30 Jan 2024 at 12:22 PM

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.


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 name@yukiworks.nl'. 


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


MT940 file of ABN AMRO (individual fields)


SectionDecriptionLayout
ExampleExplanation
:20:Transaction referencen.v.t.--
:25:Account number0000000001234567899-digit account number
:28:Statement information000/01401/11401=statement number 1=serial number
:60F:Opening balance[C|D]YYMMDDEUR00000,00C091031EUR9000,00-
:61:Transaction/mutation dataYYMMDDMMDD[C|D]00000,00N000NONREF'0911041104D100,N426NONREFN426=transaction type
:86:Description -12.34.56.789 P JANSEN-
:62F:Final balance[C|D]YYMMDDEUR00000,00C091105EUR8900,00-

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
-

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 atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article