
This is the platform table.
Column O contains names in different languages and some of them may consist of 3-4 words.
Column H represents the amount in currency, and there should be a second stage of verification according to this amount.
Column F is the currency.

This is the bank table.
The synchronization task is as follows:
We take each payment in turn, look at column A (date), B (transaction type, incoming or outgoing), C (contains information about the sender or recipient including the name), column D (amount of currency), column E (currency).
And accordingly, we need to find in the platform table the row with the corresponding amount and name considering that the names need to be adapted. If it matches, then in the platform table, we need to transfer the date from the bank table column A to column S.
I would like to emphasize that the key is to find a solution for the correct synchronization of names.
The full names are indicated in the platform statement in different languages, there may be different orders of surname and name, or they may consist of 4-5 words. In the bank statement, they are mostly indicated in Latin letters, but there are some exceptions.