How to upload bank statement in IFS10 for auto transaction matching

Hi Asaleem,

There are mainly two types of bank reconciliations in IFS system.

1. Reconcile bank statement with cash book transactions ( Use Bank Reconciliation flow in IFS).
2. Reconcile bank statement with AR & AP transactions (Use external payment flow in IFS).  

I assume you are referring to the generic Bank Reconciliation flow. Hope you have prepared your bank statement layout in order to match with IFS supported bank reconciliation file format. If you want to directly upload the exact bank statement(e.g MT940 based statement), you have to defined a new external file template to match with your bank statement layout (that is a different topic to discuss).

Once the file template is define, you can setup the automatic matching attributes.

IFS Application Path: Cash Book/Payment Institute/RMB on your institute(bank) - Payment Type Grouping per institute/ RMB - Attributes for Automatic Matching

Note:

• That Bank Transaction Code is a mandatory attribute for auto reconciliation process
• Your file should contain the required attributes for matching

Once the matching attributes are set, you can upload the bank statement file to the system.

Now, go to Automatic Transaction Matching window and see whether your bank transactions  (displayed in the bottom panel of the window). are correctly matched with the cash transactions (displayed in the top panel of the window).