Solved

Automatic bank reconciliation

  • 8 October 2021
  • 3 replies
  • 403 views

Userlevel 2
Badge +2

Hi community!

 

We are quite new to IFS and we are thinking to start using automatic bank reconciliation. But we still have not figured out how to make the bank statement filematch the file template in the External File Assistant.

 

Anyone who can help with detailed info? 

 

Thank you for the support!

iLINCA

icon

Best answer by Eranda 8 October 2021, 22:03

View original

This topic has been closed for comments

3 replies

Userlevel 7
Badge +19

@Ilinca Please check if the 2nd reply in this thread might help you:

 

 

Userlevel 2
Badge +2

Thank you @EnzoFerrari  but it does not help. My issue regards making the bank file match the template in external file assistant.

Userlevel 6
Badge +11

Hi @Ilinca

You have to create a file template as per the standard Bank Statement file template. In this case, you might place a challenge to convince the bank to send the file in your format. Other option is you can create a file template to fetch the data from the bank statement file. For an example, all most all the banks in the world is ready to provide MT940 based bank statement if they are part of the SWIFT network. But, in IFS you cannot load MT940 file directly to bank reconciliation purpose, since the standard bank statement file template was not based on MT940 structure. In this case you have to build a new file template based on File Type “Bank Statement” to match with MT940 structure. This requires a very good knowledge on external file message functions. If you need more details on this please send me a direct message.