There are currently few options available under bank reconciliation rules to set for finding and sorting bank transactions. Since each bank have its own way to produce statements and provide references in the statement, it is found that the current available fields are not enough to set up rules and would lead to do customer a manual reconciliation, which involves much human efforts and increase client cost to run the process.

It would be beneficial if bank reconciliation rules have the followings fields for the D365 bank transaction to setup additional criteria and grouping.

Voucher: A voucher on the customer/vendor payment line is mostly unique and can help to sort out the transactions easily.

Document number: A document number available on the customer/vendor payment line (not the deposit slip document number.

Method of payment and Payment specification, Category purpose, Charge bearer, Local instrument, Service level -

Methods of payment, payment specification, and various purpose selected on the journal lines could.

Cheque number - Cheque number on journal line.

Reason code - Reason code selected on journal line

FINANCIAL DIMENSIONS - financial dimension selected on journal line.

These fields are most commonly used for vendor/customer payment journal. Currently these are not available in additional criteria for bank reconciliation rules. With having these fields, it would be more easy to sort out the bank transaction and thus enables the bank transactions to match transaction with bank statement transactions. It reduce the client manual activity to find out the transactions manually.

Also, D365 should provide option to auto generate two field value in vendor payment journal / customer payment journal based on journal names and number sequence.

The field basis on the journal name will allow to fill a default fixed value on vendor payment journal / customer payment journal. This will help in the group condition setup, where a bank provide one line amount for multiple transactions.

The field basis on number sequence allow to have a value in vendor/customer payment journal which can be mapped to the file sent to bank for payment and thus getting the same value back in bank statement.