Skip to main content
Solved

Automatic bank reconciliation

  • October 8, 2021
  • 3 replies
  • 529 views

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 1 reply

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

Best answer by Eranda

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.

 

This topic has been closed for replies.

3 replies

Asela Munasinghe
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 805 replies
  • October 8, 2021

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

 

 


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • October 8, 2021

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


Eranda
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 217 replies
  • Answer
  • October 8, 2021

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.