Batch update - Payments / receipts

I have uploaded the excel table with single data line using “batch create” option:

Most of the data is uploaded correctly, however, the account option shows suspense:

Editing the particular entry shows that debit COA and credit COA is not picked up by the system:

Can anyone help, Please.

Thanks in advance.
Muhammad Yousuf

You need to use a hexadecimal codes for the account names not the account names

Thanks for the reply.

Where to find these hexadecimal codes for account name and how to use these?

Sorry, you need to enter a few trial transactions and then do a batch update where the codes will be shown - you can then use them in your import file.

Can you not achieve the same goal using bank rules?