Filename bankintegration - ISO20022
CONTENT
-
Files to bank (export)
-
Return files from bank (import)
-
Danske Bank
-
DNB
-
Eika
-
Evry
-
Nordea
-
SEB
-
Swedbank
-
Bank Connect – BankData
-
Bank Connect – SDC
-
Bank Connect – BEC
-
Handelsbanken Sweden
When integrating with a bank, the ISO20022 format is used. The names of the files sent to the banks and the return files received from the banks have specific formats, depending on the bank. When setting up remittance with bank integration, it is important that the filename filters in the Aritma Pay setup match the filenames used by the bank. Below are examples of the filename filters required for the different banks.
Files to bank (export)
The payment/remittance file to be sent to the bank must always be named P001.xml. This applies regardless of the bank.
Return files from bank (import)
Most banks can deliver three types of return files: Pain.002 (receipt), Camt.54 debit (settlement), and Camt.54 credit (incoming payments). A separate line should be added in the import setup for each of these files, under “Files from bank”.
If you approve payments in pay.zdata.no, you should also add filename filters for receipts from Aritma. If payments are rejected in pay.zdata.no, a receipt is generated that can be imported into Visma Business to update the payment status to “Rejected”. In this case, add the following filename filter:
*p002*.xml
The image below illustrates an example of how the setup may look (here with filenames for return files adapted to DNB).
Danske Bank
-
???X*.(Receipt) -
???D*.(Settlement) -
???I*.(Incoming payment – capital I) -
Aritma receipt:
*p002*.xml
Note:??? = Enter the SenderID from Danske Bank here. This is customer-specific and always 3 digits. Contact Aritma if you have questions.
DNB
-
P.00123456789.001.P002.*.DAT(Receipt) -
P.00123456789.001.P002.*.XML(Receipt) -
P.00123456789.001.C54D.*.DAT(Settlement) -
P.00123456789.001.C54D.*.XML(Settlement) -
P.00123456789.001.C54C.*.DAT(Incoming payment) -
P.00123456789.001.C54C.*.XML(Incoming payment) -
Aritma receipt:
*p002*.xml
Note:
-
001= example division number in DNB. Replace with your own division number. -
123456789= example organization number. Replace with your company’s organization number.
DNB uses .XML in the new core system (2025), but .DAT in the old system. Therefore, it is recommended to include import lines for both .DAT and .XML files.
Eika
-
ERPZDATA_PAIN002*.xml.pgp(Receipt) -
ERPZDATA_CAMT054D*.xml.pgp(Settlement) -
ERPZDATA_CAMT054K*.xml.pgp(Incoming payment) -
Aritma receipt:
*p002*.xml
Evry
-
P.00123456789.000.P002.*.DAT(Receipt) -
P.00123456789.000.C54D.*.DAT(Settlement) -
P.00123456789.000.C54C.*.DAT(Incoming payment) -
Aritma receipt:
*p002*.xml
Note:123456789 = example organization number. Replace with your company’s organization number.
Nordea
-
NDCAPXMLO*.xml(Receipt) -
NDCAPXMLD54O*.xml(Settlement) -
SFTPMessageFromNordeaCAMT054*.(Incoming payment) -
Aritma receipt:
*p002*.xml
SEB
-
pain002ban_*.(Receipt) -
pain002con_*.(Receipt) -
camt054D_*.(Settlement) -
camt054C_*.(Incoming payment) -
Aritma receipt:
*p002*.xml
Note:
Settlement and incoming payments are delivered in the same file. If you only want to import one of them, you must configure a system type filter in the format. This is done by going to “Edit import”. Choose message type Camt.054.001 and import Inpayment for incoming payments, or Settlement for settlements.
Swedbank
-
*.PAIN002.*.XML(Receipt) -
*.CAMT054.DENA.*.XML(Settlement) -
*.CAMT054.CRNA.*.XML(Incoming payment) -
Aritma receipt:
*p002*.xml
Note:
Receipts from Swedbank (Pain002) are only sent in case of rejection (RJCT status).
Bank Connect – BankData
-
Pain.002.*.xml(Receipt) -
Camt.054.*.xml(Settlement and incoming payment) -
Aritma receipt:
*p002*.xml
Note:
Settlement and incoming payments are delivered in the same file. To only import one of them, you must configure a system type filter in the format. This is done by going to “Edit import”. Choose message type Camt.054.001 and import either Inpayment (for incoming payments) or Settlement (for settlements).
Bank Connect – SDC
-
Pain.002.*.xml(Receipt) -
Camt.053.*.xml(Settlement) – must include a system type filter for Settlement -
Aritma receipt:
*p002*.xml
Note:
SDC does not yet support Camt.54 debit and credit (settlement and incoming payment). To still be able to import settlements, the account information file Camt.053 can be used. To enable this, a system type filter must be set up in the format. Go to “Edit import”, choose message type Camt.053.001, and import Settlement.
If you are also using the reconciliation program Aritma Control with manual file import, the file path in Control will look like this:Camt.053.*.xml.b~1
Bank Connect – BEC
-
Pain.002.*.xml(Receipt)
Note:
BEC does not yet support Camt.54 debit and credit (settlement and incoming payment).
Handelsbanken Sweden
-
GEUT_PAINSTAT_*.5551234567.xml(Receipt) -
GEUT_CAMTKRED_*.5551234567.XML(Incoming payment) -
GEUT_CAMTDEB_*.5551234567.XML(Settlement) -
GEUT_CAMTSATR_*.5551234567.xml(Bank reconciliation)
Note:5551234567 = example organization number. Replace with your company’s organization number.
Handelsbanken Sweden does not send receipts as of February 2024.