Business Need:

In the Advance Bank Reconciliation process, there are scenarios where the amount received or paid differs from the related invoice amount due to bank charges. Currently, if the variance exceeds the configured maximum penny difference/tolerance, the transaction cannot be settled automatically and requires additional manual processing.

Suggested Enhancement:

Introduce a feature that allows users to designate settlement variances as bank fees when the difference between the bank transaction amount and the invoice amount exceeds the maximum penny difference threshold.

Proposed Functionality:

• During bank transaction settlement, detect variances that exceed the configured tolerance.
• Provide an option to automatically or manually post the variance to a designated Bank Fees account.
• Allow configuration of the ledger account used for bank fee postings.
• Maintain a clear audit trail linking the settlement, variance, and generated bank fee transaction.