I have two table: BANK STATEMENT and CASH BOOK Firstly, want to compare the amounts, if they are equal then Secondly, check the narration if at least three or four letters match, will pair them. If amount is equal but none of the narration matches, will unmatch them. I have attached an excel to explain it further and this is also an example
BEFORE
BANK STATEMENT
29-Mar-16 SF REDT IFO NAANA GRACE N/R 1,000.00
24-Mar-16 SF IFO SOLOMON TEYE T N/T 1,000.00
30-Mar-16 SF REDT IFO SAMUEL MANU N/R 1,000.00
19-Jan-16 SF REDT IFO CLEMENT ASANDENAM 1,018.56
16-Mar-16 REDT OF SF IFO STEPHEN ASIEDU ASANTE 1,084.29
CASH BOOK
29-Mar-16 Samuel Kyei Manu 1,000.00
24-Mar-16 Solomon Teye Tettey 1,000.00
15-Jan-16 Clement Asandenam 1,018.56
23-Mar-16 Naana Graham Grace 1,000.00
23-Jul-15 SF IFO Paul Boateng 1,091.07
AFTER
BANK STATEMENT CASH BOOK
24-Mar-16 SF IFO SOLOMON TEYE T N/T 1,000.00 24-Mar-16 Solomon Teye Tettey 1,000.00
29-Mar-16 SF REDT IFO NAANA GRACE N/R 1,000.00 23-Mar-16 Naana Graham Grace 1,000.00
30-Mar-16 SF REDT IFO SAMUEL MANU N/R 1,000.00 29-Mar-16 Samuel Kyei Manu 1,000.00
19-Jan-16 SF REDT IFO CLEMENT ASANDENAM 1,018.56 15-Jan-16 Clement Asandenam 1,018.56
16-Mar-16 REDT OF SF IFO STEPHEN ASIEDU ASANTE 1,084.29
23-Jul-15 SF IFO Paul Boateng 1,091.07
Bookmarks