Fortis Nederland allows you to export or download bank statements (transactions) for a selected period via online banking and save them as an export file. This electronic file can then be uploaded to Yuki, so that the transactions are automatically processed in the 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
To import Fortis Nederland bank transactions into Yuki, you must submit the export file in one of the following formats:
- MT940 (.STA file)
- MT940 Grote Beer (.STA file)
- CAMT.053.
MT940 Grote Beer format
The MT940 Grote Beer format differs from the standard MT940 format in that it includes specific information enclosed in curly braces ({ and }).
For a detailed description of uploading files in Yuki, see article Upload files from PO Box.
Export Instructions
- Instructions for exporting MT940 files are not currently available.
- According to Fortis Netherland, the MT940 Grote Beer format cannot be exported via the internet portal.
Fortis Nederland MT940 file (.STA file) (individual fields)
| Section | Description | Layout | Example | Explanation |
| :20: | Transaction reference | 99 9999999999 | 99 9999999999 | fixed value |
| :25: | Account number | OLB /0000000000 | OLB /123456789 | 9-digit account number |
| :28: | Statement information | 000/0 | 284/1 | 284=statement number, 1=sequence number |
| :60F: | Opening balance | [C|D]YYMMDDEUR00000,00 | C091001EUR000000001467,57 | EXPORT FORTIS IS NOT CORRECT |
| :61: | Transaction/mutation data | YYMMDDMMDD[C|D]00000,00N000' | 0910011001C000000000007,57N000 | N000 never filled in |
| :86: | Description | 000>00>... | 12.34.56.789 P JANSEN | can stand on multiple lines, >20 contra account and name, >21 description with transaction type, >31 contra account, >32 name beneficiary |
| :62F: | Closing balance | [C|D]YYMMDDEUR00000,00 | C090720EUR000000001467,57 | EXPORT FORTIS IS NOT CORRECT |
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