Hi,

The formula was very helpful, however Please find the file for your reference.

Needed: If it is receipt one GL statement and bank statement receipt should match as highlighted in excel, if it's payment also wise versa.

If you could help on this i so much great full to you.

 Thanks,