kalakriti
11-22-2019, 12:43 PM
Hi
,
I have a two sets of statement, one from the client [ referred as Client books] needs to be reconciled with the co. ledger [ Co. books] .
there are lot of transactions , every month and most of the times the amounts are similar for different transactions .
Now the challenging part being absence of any common reference in both the statements which would have simplified my life .
without the absence of a common reference , I go on manually knocking of based on the amount from both the statements .
Amount appears as positive in the clients books while it appears as negative amount in Co books
I am attaching the excel sheet for your reference
What I am looking for is i
n column F , I need a formula which will check the value of column D , appearing against the client books and match with the similar amount appearing with the co books , if Matched it will say matched in column F
and then give the corresponding reference appearing in column B for the respective amounts in Column G.
Hope I have explained it clearly, any help would be really appreciated .
,
I have a two sets of statement, one from the client [ referred as Client books] needs to be reconciled with the co. ledger [ Co. books] .
there are lot of transactions , every month and most of the times the amounts are similar for different transactions .
Now the challenging part being absence of any common reference in both the statements which would have simplified my life .
without the absence of a common reference , I go on manually knocking of based on the amount from both the statements .
Amount appears as positive in the clients books while it appears as negative amount in Co books
I am attaching the excel sheet for your reference
What I am looking for is i
n column F , I need a formula which will check the value of column D , appearing against the client books and match with the similar amount appearing with the co books , if Matched it will say matched in column F
and then give the corresponding reference appearing in column B for the respective amounts in Column G.
Hope I have explained it clearly, any help would be really appreciated .