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).

Thanks for information Eranda,

If you are using Camt 053 file in Apps 9, how is the process looking?

Hi Andreas,

Camt053 & camt054 uploading process is same in both App9 and App10. The functionality is fully supported in both versions. 

Process in short form.

1. You have to define message codes based on your bank statement file.

2. Define external payment parameters 

3. Upload bank statement file to application server IN folder. 

4. The file will be loaded to external payment and matching will be performed based on your external payment parameters setup.

5. Create mixed payment.

Best Regards 

Eranda

Hi 

Just a question related to using the IFS Bank Reconciliation functionality (APPS 10 Update specifically as requesting our bank to provide daily/weekly bank statement files for uploading and transaction matching.

1. Do most banks (in this case the TD Bank in Canada) provide this service if requested?
2. Can we request the bank to create and align their statement files based on the structure of the IFS STDBNKSTAT File Template or to meet the layout of any template that we might create ourselves and use in place of the standard template?

Thanks

Alan

Am currently using the below Version of IFS:

can somone help me please