Rabobank export files

Modified on Thu, 18 Jun at 2:40 PM

IMPORTANT!

As of November 15, 2026, Rabobank will no longer support MT940 files. Starting on this date, bank transactions can only be imported into Yuki manually using the CAMT.053 format. We recommend switching to this file format in a timely manner or using the Rabobank accounting integration.


Rabobank 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 admiinstration.



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 Rabobank bank transactions into Yuki, you must submit the export file in one of the following formats:

  • MT940 Structured
  • CAMT.053
  • CSV.


Although CSV files can be imported, MT940 Structured and CAMT.053 are preferred because they provide more detailed transaction information.


Credit card transactions

Transactions from a Rabobank Business Card must be submitted in:

  • CSV


Important for credit card transactions

To ensure the correct import of credit card transactions, it is important that the last four digits of the credit card number are recorded in the credit card account within Yuki.



Automatic processing via Rabobank accounting link

In addition to manually exporting and uploading bank files, you can also use the Rabobank 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 Rabobank accounting link.



Download Rabobank bank file

You have to go through the following steps in order to download a bank file of your corporate account with the Rabobank:

  • You log in to online banking with the Rabobank (https://bankieren.rabobank.nl/klanten/bedrijven/internetbankieren/betalensparen/rekeningoverzicht/downloaden_transacties/?)


  • Click 'Betalen en sparen' and next click 'Downloaden transacties' immediately
  • Choose the download format 'MT940 Structured (.swi)', 'CAMT.053' or 'CSV (.csv)'
  • Select one or more corporate bank accounts
  • Download the transactions from the date of the last download (maximally 3 months back in time) ór select the month for which you want to download the transactions ór enter the start date and the end date of the period for which you want to download the transactions (maximally 3 consecutive months)
  • Give the file a recognnisable file name like 'from date to date', 'month' of 'number'
  • Click the 'Bestand downloaden' button
  • You can now save the file.
    In most browsers the file will be saved in the 'Downloads' folder.



Upload Rabobank 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.


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.


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