I have a process in which I have bunch of transactions which need to be verified by checking inside Bank Statements regularly being updated in a Shared Folder.
The input I am getting is:
i) Bank Amount
ii) Bank Date
iii) Bank Name
iv) Customer Name
I have successfully created a process which can search through a specific bank statement based upon Bank Amount and Bank Date. The issue I am getting is when multiple transactions or a different transaction occurs on the same exact date with the same exact amount it will consider it as verified and store the bank statement and proceed with the process.
To make it 100% accurate, I need to find Customer Name in the bank statements which is very vague and is sometimes written in different language, other times it is misspelled in the bank statements.
Thanks in advance for your suggestions and workarounds.