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.
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.
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)
Section | Decription | Layout | Example | Explanation |
:20: | Transaction reference | n.v.t. | - | - |
:25: | Account number | 000000000 | 123456789 | 9-digit account number |
:28: | Statement information | 000/0 | 1401/1 | 1401=statement number 1=serial number |
:60F: | Opening balance | [C|D]YYMMDDEUR00000,00 | C091031EUR9000,00 | - |
:61: | Transaction/mutation data | YYMMDDMMDD[C|D]00000,00N000NONREF' | 0911041104D100,N426NONREF | N426=transaction type |
:86: | Description | - | 12.34.56.789 P JANSEN | - |
:62F: | Final balance | [C|D]YYMMDDEUR00000,00 | C091105EUR8900,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 -