Reconciliation for cheque transactions from different bank account

Summary

Reconciliation for cheque transactions from different bank account

Content

We have a client who has one expenditure account which is used to make payments to suppliers.When the bank statement gets generated, the payment lines are included in the bank statement lines.This is applicable for EFT transactions (Payment method: Electronic)

For cheque transactions, the process of payment again uses EFT payment file(payment method: CHECK) sent to bank and bank issues cheque on behalf of the customer to the supplier.When the cheque is issued the money for the cheque first gets debited from the expenditure account (setup in Oracle) and then gets credited to an additional bank account(this bank account is not setup in Oracle) maintained for cheque payments.The bank uses this account to park the amount for release when the cheque is presented by supplier.The bank statement lines import shows the lines for the transactions from the expenditure account and not for the additional bank account.