In order to be able to import an accountant export from your MultiSafepay Control into your Exact Online account, you will need to provide an additional international bank account number (IBAN). However, bear in mind that this is just for Exact to be able to process this kind of operation and the account number can therefore be a “dummy” account.
How to “create” a dummy IBAN
- Go to https://www.ibancalculator.com/bic_und_iban.html
- Navigate to the Calculate an IBAN field
- Select the Netherlands as country
- Choose any option for a bank (e.g. ING Bank)
- Fill in any 7 digits in the Account number field
- Click on calculate IBAN
- A bank account number (IBAN) and BIC will be generated
How do I process the bank account number in my Exact Online platform?
- Go to bank accounts in your Exact Online platform
- Click new
- Select payment service provider as type
- Enter the full international bank account number
- Synchronize by selecting the ING bank
- Click save
You have created a bank account. All transactions linked to this bank account number can now be registered.
Exact Online and Exact Globe can both perfectly import and match our MT940 report if:
- your accounting package supports the processing of MT940 files (bank statements).
- the order numbering that appears in the exported accountant files (eg 200160526), also appears in the correct invoice fields in your accounting platform.
- the customer’s name and the order amounts that appear in the exported accountant files correspond to those in your accounting platform,
Exact Basic / Standard package does not support the MT940 import function, at least Exact Advanced version is required to import an MT940 report.
Lightspeed users must require Lightspeed to perform an adjustment to make sure the order number appears in the correct field in Exact for it to be matched with our MT940.