External Cash Transactions offset account

Summary:

Dear Experts,

We have a requirement to create external cash transactions from bank statement.

However offset accounts to be used is based on whether transactions codes entry is debit or credit entry in bank statement.

Ex

please let us know how we can achieve this requirement.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):