thumb_up
thumb_down
link
Copy link
Copied
insert_emoticon
lmatfy
Copied

Bank statements using the bank link (AFAS Online)

You can receive and import electronic bank statements automatically using a link between internet banking and AFAS Online; the bank link. This makes it unnecessary for you to retrieve and import bank statements yourself. You only have to process the bank statements yourself.

Each day (early in the morning), the bank sends the electronic bank statements to AFAS Online as a SWIFT file (MT940 (Rabo and ING) or MCR (ABNAMRO)). You only need to start the bank statement processing.

This topic is an extension of the description of Electronic bank statements. Only the differences with the standard procedure are explained.

Note:

The bank link is only available for AFAS Online customers who do their internet banking with the ABN-Amro, Rabo- and/or ING banks.

Content

Video

Description

Each day (early in the morning), the bank sends the electronic bank statements to AFAS Online. You receive these bank statements via a communication message in the communication service in Profit. Profit automatically imports the bank statement in this message into your environment when you open the bank statement view. After this, you have to process the bank statement yourself.

Bank link options:

The bank link is only available for AFAS Online customers who do their internet banking with the ABN-Amro, Rabo- and/or ING banks. Furthermore, the Rabobank offers you the option to send payment and collection files via this link. As yet, the ABN-Amro bank and the ING bank do not offer this option:

Bank name

Automatic exchange via AFAS Online

Fin_Logo Bank ABN_Amro

  • Electronic bank statements (Transactions)

Fin_Logo bank ING

  • Electronic bank statements (Transactions)

Fin_Logo bank Rabo

MT940 file from the ING bank

The format of the name is as follows: MT940_<accounting package>_YYYYMMDD_Sequencenumber.SWI.

YYYYMMDD is the entry date following the entry date of the transactions in the MT940 file. This means that the file received no later than 05:00 on Tuesday, Wednesday, Thursday and Friday has the 'creation date'. The file received on Saturday morning, with transactions from Friday, is given the date from Monday in the file name. The sequence number is part of the file name. If an account does not have any transactions, an MT940 file is still delivered for it. The exchange of transaction data is done based on IBAN numbers. The MT940 file contains statements for the accounts that are/were linked up to 20:00 in the evening. It contains all the transactions for this day (thus not only the transactions up to 20:00).

Preparation

Procedure

Also see

Process

Electronic bank statements