Fortis Nederland export files

Modified on Thu, 18 Jun at 9:39 AM

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)



SectionDescriptionLayout
Example
Explanation
:20:Transaction reference99 999999999999 9999999999fixed value
:25:Account numberOLB     /0000000000 OLB     /1234567899-digit account number
:28:Statement information000/0284/1284=statement number, 1=sequence number
:60F:Opening balance[C|D]YYMMDDEUR00000,00C091001EUR000000001467,57EXPORT FORTIS IS NOT CORRECT
:61:Transaction/mutation dataYYMMDDMMDD[C|D]00000,00N000'0910011001C000000000007,57N000N000 never filled in
:86:Description 000>00>...12.34.56.789 P JANSENcan 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,00C090720EUR000000001467,57EXPORT 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article