ABN AMRO allows you to export bank and credit card transactions from a selected time period via its online banking portal. You can then upload the exported file to Yuki, so that the transactions are automatically processed in your administration.
Check date of most recently imported transaction
Before exporting transactions, it’s important to check the date up to which bank transactions have already been processed in Yuki. You can find this date in the last column of the overview of all bank accounts in Yuki.
If the bank account in question does not yet exist in Yuki, it will be created automatically when you upload the file. After that, you only need to specify which ledger the bank account belongs to.
Supported file formats
Bank transactions
To import ABN AMRO bank transactions into Yuki, you must submit the export file in one of the following formats:
- MT940
- CAMT.053..
Credit card transactions
Transactions from a Business Card must be submitted in:
- CSV.
ATTENTION!
The ABN AMRO Professional credit card is intended for individuals and cannot be submitted as a CSV file.
Automatic processing via ABN AMRO accounting link
In addition to manually exporting and uploading bank files, you can also use the ABN AMRO accounting link.
With this link, you no longer need to manually download and upload bank files. Bank transactions are automatically retrieved and processed in Yuki, ensuring your administration always have up-to-date bank data.
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' or 'CAMT.053' format.
Click the 'Download' button.
You can now save the file.
In most browsers the file will be saved in the 'Downloads' folder.
Upload ABN AMRO bank file to Yuki
We recommend that you do not open or edit the bank file. This ensures that the file structure remains intact and allows Yuki to process the file correctly.
The check digit ensures you that you upload the same file in Yuki.
You can then upload the downloaded bank file to Yuki via the PO Box or send it as an attachment by email to <yourdomainname>@yukiworks.nl.
The electronic bank file will be automatically processed in your administration.
For a detailed description of uploading files in Yuki, see article Upload files from PO Box.
ABN AMRO MT940 file (individual fields)
| Section | Description | Layout | Example | Explanation |
| 20: | Transactiion reference | n.v.t. | - | - |
| :25: | Account number | 000000000 | 123456789 | 9-digit account number |
| :28: | Statement information | 000/0 | 1401/1 | 1401=statement number 1=sequence 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: | Closing 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
-
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article